How to change a few hundred movie numbers?

Guest · Post by **Guest** » 2005-03-13 16:51:28

Hello,
For the moment I have more than 1300 Movies in my AMC DB. All of them are stored in special DVD coffer with a specific number sequence xyzzz.
x = DVD coffer number (1 to 3)
y = row number in DVD coffer (1 to max4)
z = item in row in DVD coffer (1 to 136)

I recently bought a new big coffer with 3 drawers (its a good space saver

). This one can contain 2000 items but I found out that each item in this case has now his own unique label from 1 to 2000 independently if the DVD is in the next row or drawer.

So I wanted to renumber my movies from 12001 - 12136 and 13001 - 13136 to the new range 11137 - 11409 for example.

You can do this easily by exporting the AMC DB to CSV, let excel change the sequence of those movienumbers. Change the numbers of the images with a file renamer and import the whole thing back in to Ant Movie Catalog.

But, there is a problem

, I see that you cannot import the reference of the image, even not with xml but in my CSV file I can clearly see a column Pictures, in de xml file this reference is there too.
Is there a way to import those images? I couldn't find a solution in the forum? Or is this feature not possible?

Thanx,
Sebastiaan

seppie · Post by **seppie** » 2005-03-13 16:54:29

sorry vergeten in te loggen voor posten van bovenstaande vraag

Post by **antp** » 2005-03-13 17:45:30

In version 3.5 which I am currently uploading on my server you can import pictures with CSV import.
But using scripting it should be easy to do what you want.
Unfortunately I do not really understand what has to be done with the label...

You want to start e.g. at 11137 and increase the number on each next selected movie, so all the selected movies after the 11136 get a new number without gap?

Guest · Post by **Guest** » 2005-03-13 20:06:35

Yes I know, it wasn't easy to explain. Indeed there shouldn't be a gap anymore in the new sequence.

I started with the first movie 11001 from my old numbering sequence in the new DVD coffer.
The number 11001 is from the first old DVD coffer, first DVD row.
Now I know I should start with the number 10001 but for the moment I didn't wanted to have to change the 136 first movies also. When I find a solution my numbering will start from 10001 up to 12000. In the future 20001 could be the second big DVD coffer and so on.

Aparently I was to quick to ask if this is possible. I will try your new version as soon as it is available.

Thanx

Post by **antp** » 2005-03-13 20:16:21

So if you want to renumber all your DVD starting at 10001, use the following script :

Code: Select all

program NewScript;

var
  i: Imteger;

begin
  Inc(i);
  SetField(fieldMedia, IntToStr(i + 10000));
end;

That should work, hoping that the default sort order is correct.

This makes me think that I should add in the script window a way to specify the original sort order.