Import/add data into existing record field

[ajwconsult]

Have have been using this Catalog for many years now..

It has got to a stage where I want to add some additional data into existing fields.

Example, I have a collection of 8,000 record, where there is a file name (saved locally on drives) which would match the "original title" field. I want to add from the file, the extension ID and the file size from each file and add to the existing record in the catalog.

I would place the, example: AVI or MKV or MP4 extension in the "Video Format" field, and the file size in the field "Files Sizes".

There is existing data imported in the video format field from IMDB Lookup, which would require removing and replacing with the new data.

Hope there is an easy solution :-)

[antp]

Hi,
This is probably doable by script, but then it would require some research or basic programming knowledge.
Using GetField & SetField you can access the wanted field info.
For the extension, ExtractFileExt returns just the extension.
For the file size, there is a GetFileSize function.