+ Post New Thread
Results 1 to 14 of 14
MIS Systems Thread, Sims - CTF Import Queries in Technical; Hi, I received a CTF file from another school - after importing I found that a number of fields imported ...
  1. #1

    Join Date
    Feb 2010
    Location
    Bedforshire
    Posts
    22
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Sims - CTF Import Queries

    Hi,
    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

    <BS7666Address>
    <PAON> 11 </PAON>
    <Street>some street</Street>
    <Town>Some Town</Town>
    </BS7666Address><County>Bedfordshire</County>
    <PostCode>AB1 2CD</PostCode>
    <Country>United Kingdom</Country>

    </Address>


    For the inavalid format it is of the form

    <Address>
    <AddressLines>
    <AddressLine1>44 The Road Name</AddressLine1>
    <AddressLine2>Some Town</AddressLine2>
    <AddressLine3>Bedfordshire</AddressLine3>
    </AddressLines>
    <PostCode>AB1 2CD</PostCode>
    <SuppInfo>
    <SuppID>Serco</SuppID>
    </SuppInfo>
    </Address>


    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

    Cheers
    Chris

  2. #2

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,253
    Thank Post
    181
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    It would be a hell of a lot quicker to manually edit the fields, why bother with reimporting the XML?

    A CTF will not overwrite.

    EDIT: The CTF could well be right and the sending school had the data wrong.

  3. #3

    Join Date
    Feb 2010
    Location
    Bedforshire
    Posts
    22
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    YEs - the sending school had exported the wrong year for the pupils but as regards manual editing - there's some 25 addresses to manually edit in Sims - hence why I was hoping to do a find and replace in the xml to reimport the addresses.

  4. #4

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,253
    Thank Post
    181
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    Once a field is populated in SIMS the CTF is designed to ignore it, for good reason. So manual editing is the only way I'm afraid.

  5. #5
    garrysaddington's Avatar
    Join Date
    May 2007
    Location
    Hogsthorpe
    Posts
    89
    Thank Post
    3
    Thanked 25 Times in 16 Posts
    Rep Power
    38
    Quote Originally Posted by cgilmour View Post
    Hi,


    <BS7666Address>
    <PAON> 11 </PAON>
    <Street>some street</Street>
    <Town>Some Town</Town>
    </BS7666Address><County>Bedfordshire</County>
    <PostCode>AB1 2CD</PostCode>
    <Country>United Kingdom</Country>

    </Address>


    For the inavalid format it is of the form

    <Address>
    <AddressLines>
    <AddressLine1>44 The Road Name</AddressLine1>
    <AddressLine2>Some Town</AddressLine2>
    <AddressLine3>Bedfordshire</AddressLine3>
    </AddressLines>
    <PostCode>AB1 2CD</PostCode>
    <SuppInfo>
    <SuppID>Serco</SuppID>
    </SuppInfo>
    </Address>

    According to the CTF file standard both of the above are valid formats for address. Perhaps SIMS has decided to deprecate the addressline format before the other suppliers or is not mapping them correctly to the BS7666 format?

  6. #6
    BatchFile's Avatar
    Join Date
    Aug 2007
    Location
    Cumbria
    Posts
    948
    Thank Post
    544
    Thanked 128 Times in 106 Posts
    Rep Power
    60
    There's an address convertor tool for CTFs from other MIS's - it's available from supportnet here http://support.capitaes.co.uk/user/d...E4%E1%E1%A3%DC

    but I downloaded it for you in case you can't find it XMLAddressLinesConverterV7_132_17006.zip

  7. #7

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,253
    Thank Post
    181
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    Quote Originally Posted by TonyRidal View Post
    There's an address convertor tool for CTFs from other MIS's - it's available from supportnet here http://support.capitaes.co.uk/user/d...E4%E1%E1%A3%DC

    but I downloaded it for you in case you can't find it XMLAddressLinesConverterV7_132_17006.zip
    Am i right in saying that would be okay for the future but would not overwrite the ones already imported?

  8. #8
    BatchFile's Avatar
    Join Date
    Aug 2007
    Location
    Cumbria
    Posts
    948
    Thank Post
    544
    Thanked 128 Times in 106 Posts
    Rep Power
    60
    Quote Originally Posted by creese View Post
    Am i right in saying that would be okay for the future but would not overwrite the ones already imported?
    Probably - but there's no harm in (taking a backup and) giving it a go anyway...

  9. #9

    Join Date
    Feb 2010
    Location
    Bedforshire
    Posts
    22
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks to all!... I ran the tool (quite neat!) and converted the input CTF files.

    I then deleted the naff addresses associated with the students and reran the CTF import ( selecting pupils address only) and it imported correctly formatted addresses - great!

    I'ts a lot quicker to delete addresses for a group of pupils then enter new ones manually.

    thanks Again
    Chris

  10. #10
    garrysaddington's Avatar
    Join Date
    May 2007
    Location
    Hogsthorpe
    Posts
    89
    Thank Post
    3
    Thanked 25 Times in 16 Posts
    Rep Power
    38
    Quote Originally Posted by TonyRidal View Post
    There's an address convertor tool for CTFs from other MIS's - it's available from supportnet here http://support.capitaes.co.uk/user/d...E4%E1%E1%A3%DC

    but I downloaded it for you in case you can't find it XMLAddressLinesConverterV7_132_17006.zip
    Begs the question "Why is the tool's functionality not integrated with the CTF import utility?"

  11. #11

    Join Date
    Mar 2010
    Location
    UK
    Posts
    166
    Thank Post
    0
    Thanked 16 Times in 15 Posts
    Rep Power
    16
    Quote Originally Posted by garrysaddington View Post
    Begs the question "Why is the tool's functionality not integrated with the CTF import utility?"
    Why the Dfe/DCSF would spec two CTF address versions is the real question, Capita went with one version & Serco the other.

  12. #12

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,253
    Thank Post
    181
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    Quote Originally Posted by Banjo View Post
    Why the Dfe/DCSF would spec two CTF address versions is the real question, Capita went with one version & Serco the other.
    Sounds incompetant to me. But I'm sure it's not

  13. #13

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,326
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79
    It's not clever at all to have an either or. SIMS went for implementing BS766 standards (as opposed to free text) and there is a validate from a central database option. It's pretty easy to go from BS7666 to free text but the other way round is tricky to say the least.

    The pre-processor was developed to cope with the ambigous specification and was meant to be temporary because there were plans to move completely to BS7666.

  14. #14
    garrysaddington's Avatar
    Join Date
    May 2007
    Location
    Hogsthorpe
    Posts
    89
    Thank Post
    3
    Thanked 25 Times in 16 Posts
    Rep Power
    38
    Quote Originally Posted by Banjo View Post
    Why the Dfe/DCSF would spec two CTF address versions is the real question, Capita went with one version & Serco the other.
    I think it's probably historical (although Phil would probably be able to put us right on this), where the original version years ago was the addresslines. The DFES wanted to change to BS7666 but suppliers have been slow to change. So both are still allowed.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 4
    Last Post: 13th July 2010, 01:27 PM
  2. SIMS.net CTF file
    By localzuk in forum MIS Systems
    Replies: 9
    Last Post: 29th June 2009, 10:45 AM
  3. Problem with SIMS CTF Import
    By appleman in forum MIS Systems
    Replies: 6
    Last Post: 20th April 2009, 03:23 PM
  4. Sims CTF Import - Aspect not Found
    By mmuk08 in forum MIS Systems
    Replies: 1
    Last Post: 16th September 2008, 09:53 AM
  5. Submit CTF to NAA using SIMS
    By penfold_99 in forum MIS Systems
    Replies: 9
    Last Post: 15th July 2008, 06:29 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •