Creating Assests from a Definition File

I have a spreadsheet that defines around 2,000 question fields (including the correct Squiz question-asset information).
Is there a way to have Squiz generate question assets bassed on a file like this spreadsheet[font="Arial"][/font]?

There are several ways with which you can achieve this. The approach you take is up to you (and what you find the easiest to implement).


Here are 2 options:



[list=1]

  • Convert the CSV file into a JSON file and use the JS API / Asset Builder (with a JS layer on top)
    [*]Use the Matrix API directly (PHP code) to create assets based on the CSV file


    The first approach is usually a good way to go if you have any SLA / server permission restrictions. The second approach is usually the fastest.

    I've used both in the past with great success.
  • wow … thanks heaps daemon … that's perfect …