[sims] Sims.net importing new batch of Reception Children from Spreadsheet....?

[NeeeeeeT]

Hi and thanks in advance for any help and support along the way with this...

 

We have just spent an age designing a brilliant form for the parents to enter all the children's details into online, perfect, hours saved printing and handing out forms etc! Now just need to import that data from a CSV file into Sims, easy yea - surely Sims can do that?!? apparently not - I need to configure my form to output to the DfE's latest CTF XML specification. Has anybody successfully attempted this? I feel like its doable but could do with a nudge in the right direction if anyone has any advice I'd be very grateful...

 

Neil

[gh5000]

Hi and thanks in advance for any help and support along the way with this...

 

We have just spent an age designing a brilliant form for the parents to enter all the children's details into online, perfect, hours saved printing and handing out forms etc! Now just need to import that data from a CSV file into Sims, easy yea - surely Sims can do that?!? apparently not - I need to configure my form to output to the DfE's latest CTF XML specification. Has anybody successfully attempted this? I feel like its doable but could do with a nudge in the right direction if anyone has any advice I'd be very grateful...

 

Neil

It's possible to use AppsScript with the XML Service and sheets to generate an XML CTF.

 

I didn't get this next way working myself but you can download the CTF schema from the gov website. Import that into Excel. Assign the schema headings to the column headers and then export the XML. I got some errors with this approach, gave up and moved to AppsScript where I was comfortable that I would get a result rather than potentially spending hours figuring out excel, but if it works for you let me know.

[NeeeeeeT]

It's possible to use AppsScript with the XML Service and sheets to generate an XML CTF.

 

I didn't get this next way working myself but you can download the CTF schema from the gov website. Import that into Excel. Assign the schema headings to the column headers and then export the XML. I got some errors with this approach, gave up and moved to AppsScript where I was comfortable that I would get a result rather than potentially spending hours figuring out excel, but if it works for you let me know.

 

If AppsScript is the best way forward, Ill give that a go! Can you offer me any advice on where to start with it? I downloaded the Schemas originally but didnt get far with it so came on here....