• Resolved Blurazor

    (@blurazor)


    Hi,
    I need to know how to I map the “author” field from Quotes Collection json file to Quotes llama’s First Name field.

    Ideally, I wish Quotes llama’s import function could extract the “author” field from the json file and populate it into the First Name and Last Name fields accordingly.

    Any advise is much appreciated.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author oooorgle

    (@oooorgle)

    Hi Blurazor,
    I am unfamiliar with the format of the Quotes Collection quote file. This type of integration is not something the Quotes Llama plugin is intended to provide. However, it shouldn’t be too difficult if you are familiar with spreadsheet applications like Microsoft Excel or Open Office’s Calc which is free if you don’t have one.

    The idea being for example and something along the line of:
    1.. import both files data into separate sheets.
    2.. Figure out how to map the data (likely the VLookup function) into a third sheet.
    3.. Export third sheet into importable quote file format such as .csv.

    I’ve not tried these solutions and don’t know exactly how to do it myself without spending time researching and refreshing my VLookUp skills.
    https://superuser.com/questions/781528/excel-take-two-csv-files-and-map-them
    https://stackoverflow.com/questions/40572884/excel-combining-two-csv-files-into-one-with-a-common-column

    Do try to figure it out yourself and if you cannot, provide a link where I can grab a copy of both the quotes files and I’ll give it a shot. Let me know.

    Thread Starter Blurazor

    (@blurazor)

    @oooorgle Thanks for your suggestion. I may give your method a go though I’m not familiar with the VLookup function. Cheers.

    Plugin Author oooorgle

    (@oooorgle)

    Any luck getting the quotes sorted out?

    Earl_D

    (@earl_d)

    You can export from Quotes Collection to json format and import into Quotes Llama. I did it and it was a smooth process. However categories don’t import.

    Quotes Llama doesn’t have that feature which would be a good addition.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Import from Quotes Collection Plugin’ is closed to new replies.