custom media catalog number

[set media label]

I already have this system of cataloging DVD movies by the year it was purchased and a number so that i can keep track of movies when they were purchased and so on. My question is how do I enter this information in to the Media label field automatically instead of entering it one by one
e.g. DVD 04-001 VCD 04-002 etc,
Is there any way to write a script so that it will automatically take the record number and append dvd or vcd to the number in specific format and enter it in some field like media label ?

Thanks
ploki

[antp]

So you want to put media type + movie number in the media label field? Lots of things can be done with scripting but I do not really understand what you want to take as info for this new label

[ploki]

I used to use excel and for making a list of all the movies, where I had a system with movie number (numeric), then movie catalog number (alpha numeric) and movie name and information.
The movie catalog numbers is based on
1. media type e.g. DVD
2. year the movie was purchased, e.g. 03, 04
3. The movie number e.g. 001 ...
so finally the catalog no. is DVD-04-001 etc.

Now in ANT MC there is automatic numbering of the database. I want to utilize that numbering system to set my old movie catalog number in the media label field. So I want to write a script that will take the number from the number field in AMC and manipulate it appending the media type and the year to create a catalog number. and insert this catalog number in the media label field. Is there anyway to do this ?

Thanks for your prompt reply.

[antp]

You mean the year of the "year" field or the year part of the "date" field ?
In the first case, it is quite easy:

Code: Select all

program MakeLabel;
begin
  SetField(fieldMedia, GetField(fieldMediaType) + '-' + GetField(fieldYear) + '-' + GetField(fieldNumber));
end.

In the other case, it depends of the date format that you use I think.

[ABNormal]

i think he would like to read the DATE's year as year info.
so it shuld be the substring of DATE field, from 7th to 10th letter as follows:
10/02/2004 data field= DATE
1234567--10 letter position

[antp]

Code: Select all

program MakeLabel;
begin
  SetField(fieldMedia, GetField(fieldMediaType) + '-' + Copy(GetField(fieldDate), 7, 4) + '-' + GetField(fieldNumber));
end.

it will fail if the "date" field is empty (could be checked easily)