English > Development

Sorting using a Custom Field during export.

<< < (3/3)

John666:
WOW, thanks for that. I have been having a look at it for hours now. It's way over my head but a good place to start.

Thanks.

handytouch:
Hi John,

How did you manage to pull the certification into PVD? I am trying that as well to pull Certification: Singapore as well.

John666:
Hi, sorry to disappoint. I entered the certificate info myself into the ‘release’ field but it could have been any custom field.

The easiest way if you have a lot of them is to export them to a .csv file, edit the appropriate field content and then import the changes. You must remember to include the record ID as one of the import/export fields.

I then use the export expression #stringreplace to convert the text into a number for sorting etc. for a website. See the Screen Captures.

[attachment deleted by admin]

rick.ca:

--- Quote ---You must remember to include the record ID as one of the import/export fields.
--- End quote ---

...Or anything that will uniquely match records on import, if there is no ID. Using [Title] and [Year] usually works fine for movies.

Navigation

[0] Message Index

[*] Previous page