Hi Martin,
An entry from the Quotes Collection Json file (not the CSV format) looks as follows:
{
“quote”: “The only way to avoid pissing people off is to do nothing important”,
“author”: “Oliver Emberton”,
“source”: “”,
“tags”: “important”,
“public”: “yes”
},
/* Note the opening and closing square brackets */
When you manually enter this quote in the Llama plugin and then export it, you get:
{
“quote”: “The only way to avoid pissing people off is to do nothing important”,
“title_name”: “Oliver Emberton”,
“source”: “”,
“category”:”important”
/* and a number of additional fields that are not */
},
So, edit the full Quotes Collection export using Notepad or a coding editor like Notepad++ or VScode, etc. to replace ‘author’ with ‘title_name’ (or ‘last-name’ or ‘first-name’). If you were using tags, change “tags”: into “category”:. Save the modified file under another name (e.g. Llama-import.json). Import that into Llama to see if it works.
If there are any other fields in the 1 record test export from Llama that you would like to use, insert these in the QC export as well. I did drop the ‘public’ field but possibly it won’t have any effect if you leave it in because it should be skipped by the Llama import function. Try to use bulk find/replace function to avoid having to update hundreds of individual records.
Good luck & keep ‘Punching’ :-).
Kind regards.
Hans
