Sims - CTF Import Queries
I received a CTF file from another school - after importing I found that a number of fields imported incorrectly
a) the adresses of pupils imported incorrectly e.g. just a house number or a town instead of the full address.
Looking at another CTf file which imported successfully I notice that a successful file from another school has the following xml
<PAON> 11 </PAON>
For the inavalid format it is of the form
<AddressLine1>44 The Road Name</AddressLine1>
Any Idea if I can quickly edit the CTf file e.g. then reimport to import the addresses? i.e. does Sims overwrite existing data on CTF import and what xml forms for address can it handle e.g. is there a missing schema definition somewhere?? .
b) The year data also came in incorrectly i.e. Year 11 instead of Year 12. Is this a manual edit in Sims or can I also find and replace this data in the CTf file so that the import will overwrite it.
Many Thanks for any help