Author Topic: Updating records upon custom field name changing  (Read 6658 times)

0 Members and 1 Guest are viewing this topic.

buah

  • Guest
Updating records upon custom field name changing
« on: April 19, 2010, 08:24:25 pm »
As it can be seen here, or even better here I have a custom-selectlist-field "DVD Case #:"

The actual last case always contains it's number and the starting movie ID for it and in it. For instance:

DVD Case #: 3: 02613 - 03876
DVD Case #: 4: 03877 -

The last one doesn't have latest movie ID, cause it wasn't filled in yet with discs, and I couldn't predict or anticipate which ID will be the last one.
Recently, I finally filled DVD case #4 closing it with a movie with ID 5329, so the value for this case had to be "4: 03877 - 05329" then.

While waiting what will be decided for a full multiple editor feature suggestion, is there a way to manually, or however, edit this value somewhere (outside PVD's interface?) so to update all records at once?

I hope I was clear enough, but willing to clarify further.

Offline rick.ca

  • Global Moderator
  • *****
  • Posts: 3241
  • "I'm willing to shoot you!"
    • View Profile
Re: Updating records upon custom field name changing
« Reply #1 on: April 19, 2010, 08:46:27 pm »
Export a list of movies with [DVD Case #] set to "03877 -" and re-import the list after you have changed those to "4: 03877 - 05329". It might take a minute or two. ;)

buah

  • Guest
Re: Updating records upon custom field name changing
« Reply #2 on: April 19, 2010, 09:10:56 pm »
Answer for dummies, please:

<DVD Case #:>{%value= ???}</DVD Case #:>

Experimenting values >300? ;D

buah

  • Guest
Re: Updating records upon custom field name changing
« Reply #3 on: April 19, 2010, 10:01:37 pm »
Ok, I'll join Zacca later ;D

But, still..

< ???>{%value=DVD Case #:}</ ???>

Offline rick.ca

  • Global Moderator
  • *****
  • Posts: 3241
  • "I'm willing to shoot you!"
    • View Profile
Re: Updating records upon custom field name changing
« Reply #4 on: April 19, 2010, 11:18:17 pm »
{%value=DVD Case #: custom="true"} (so others understand, your field name includes the ":")

If you followed nostra on twitter like you're supposed to, you'd know about the Personal Video Database Export Templates Manual. It answers this, and any other question you could possibly ask regarding templates. ;D

I suppose you have to be able to deduce "custom," in the context of a "parameter," must be a boolean value. :-\

buah

  • Guest
Re: Updating records upon custom field name changing
« Reply #5 on: April 19, 2010, 11:37:00 pm »
Rick,

Thank you.

Btw, how old are you Rick, if I'm not indiscreet? I'm 41, if you know what I mean.

Offline rick.ca

  • Global Moderator
  • *****
  • Posts: 3241
  • "I'm willing to shoot you!"
    • View Profile
Re: Updating records upon custom field name changing
« Reply #6 on: April 20, 2010, 02:22:16 am »
Funny you should ask. I was recently wondering why my profile says I'm 45. Then it came to me—I originally set it so it would show my age when I starred in Casablanca. I wouldn't want to confuse anyone by reporting an age that doesn't match my picture. But that was two years ago. I can't be bothered updating the birth date every year, so I'll just leave it. So now I'm 110—one year older than nostra. I'll have to let him explain how that is so. He was 38 in his photo and 84 now, but I figure he must be closer to 506. He probably just wants you to think he's younger than me, without having to lie any more than necessary. :-\

buah

  • Guest
Re: Updating records upon custom field name changing
« Reply #7 on: April 20, 2010, 06:44:26 am »
Wow! What was that? Pass it by, I want it too. ;D

Offline rick.ca

  • Global Moderator
  • *****
  • Posts: 3241
  • "I'm willing to shoot you!"
    • View Profile
Re: Updating records upon custom field name changing
« Reply #8 on: April 20, 2010, 07:11:24 am »
When you're as old as me, the flashbacks become more frequent. ;)

buah

  • Guest
Re: Updating records upon custom field name changing
« Reply #9 on: April 20, 2010, 07:53:52 am »
Yeah, I can imagine. I've been told by my folks about flashes in their backs.

{%value=back flash="true"}

 

anything