Exporting cover loactions when titles contain commas

[2benglish]

I'm trying to take the covers from Bookpedia and import them to FilemakerPro.

The data I want to export is title, cutom1, cover location. The import to filemaker will be based on custom1 with title and cover location being updated.

I'm not sure how to get this information out of Bookpedia. Also, some of the titles contain commas. Would this cause problems if exporting to csv?

Thanks for helping someone in need!

[Conor]

It's best to set up a dedicated text template for this. Copy the following code to a text file and save that file in your home folder at "~/Library/Application Support/Bookpedia/Templates/MyTemplate.txt".

Code: Select all

<!--BeginRepeat-->[key:custom1]	[key:title]	[key:localCoverImageURL]
<!--EndRepeat-->

it will now appear in Bookpedia as an option under the text export templates as "MyTemplate". The above is "tab" based instead of comma based to avoid any issues with titles with commas. Although if you prefer comma then a quoted version should have no problems either ("[key:custom1]","[key:title]","[key:localCoverImageURL]").

[2benglish]

Thanks very much for the quick and clear response. That sorted everything out.