[sims] SIMS Bulk Import - Can't get it to work!

[ilsley_SIMS]

Hi,

 

I have downloaded the hopefully very handy SIMS Bulk Import tool, but I can't seem to get it work for me. :-/

 

I have created a CSV file that contains the following two columns: Admission Num, Learning Mentor

 

 

Once I have uploaded the CSV file and filled in the form accordingly, I click the Import button but it renders a blank table in my browser. I suspect I need to have more fields in my CSV than I currently have, although I was hoping it would only require the Admission Number to match on...

 

 

Any ideas? Thanks!

Edited June 12, 2015 by ilsley_SIMS

[ilsley_SIMS]

Anyone used this tool before? I can't seem to find a user guide anywhere.

[matt40k]

Try saving it as an Excel spreadsheet. What version you using? You can get the latest version from https://simsbulkimport.uk/. I assume Learning Mentor is a UDF? Is it a single-line text?

[ilsley_SIMS]

Try saving it as an Excel spreadsheet. What version you using? You can get the latest version from https://simsbulkimport.uk/. I assume Learning Mentor is a UDF? Is it a single-line text?

 

I'll try saving it as a standard .xlsx file. And yes, Learning Mentor is a single-line text UDF. I'm using the latest version (v2.01).

 

Will report back shortly.

Edited June 12, 2015 by ilsley_SIMS

[SovietRussia]

I used it just the other day to upload all our student usernames to their SIMS profiles, worked a treat.

 

Did an export from SIMS of admission numbers and name, built a script to automatically check AD based on name to fill in a column called 'username'. Once that had done, had about 70 people left who had changed their name etc.

 

Uploaded it all, took a while for it to check and sync the data but 1300+ done.

[matt40k]

@SovietRussia - could do with some testimonials for the site really, or better yet blog posts detailing how folks are using it.

[ilsley_SIMS]

I just tried to import some sample data from an .xlsx file again, but again, it fails to import the UDF data.

 

See attached screenshots - what am I doing wrong?

 

PS I have tried the import by matching just on Admission Number AND by Admission Number and Surname/Forename, and it gives me the same result.

[ilsley_SIMS]

And does it matter whether SIMS is open or closed when using this tool?

[matt40k]

Nope, just need SIMS .net installed on your client. What version are you running?

[ilsley_SIMS]

Nope, just need SIMS .net installed on your client. What version are you running?

 

I'm using version 2.01.

[matt40k]

Update to 2.3.27.0, that should sort you out - download from https://simsbulkimport.uk/

[ilsley_SIMS]

Update to 2.3.27.0, that should sort you out - download from https://simsbulkimport.uk/

 

Hi Matt. I installed the latest version this morning and had another run at it, but it gives me the same problem. It matches the records up correctly, but once i click 'import', the web report shows that the data has not been successfully imported.

 

Do you think it might be some sort of permissions issue?

[matt40k]

I assume you've got permissions to add it into SIMS .net manually?

[ilsley_SIMS]

I assume you've got permissions to add it into SIMS .net manually?

 

Yes. I've got full System Admin rights.

[Kate101]

I to am having problems with this tool.

I downloaded the latest version yesterday.

I created a csv file with Admission No, Surname, Forename, Email and Location.

I can connect to the database, browse and open the csv and pick the fields that I want to import.

On clicking import it starts to process the file and then just closes the tool.

It never imports anything and there is no blank data in the csv file.

This is the first time we have tried to use this tool so have no previous experience to refer to.

Any help would be very much appreciated.

[ilsley_SIMS]

I to am having problems with this tool.

I downloaded the latest version yesterday.

I created a csv file with Admission No, Surname, Forename, Email and Location.

I can connect to the database, browse and open the csv and pick the fields that I want to import.

On clicking import it starts to process the file and then just closes the tool.

It never imports anything and there is no blank data in the csv file.

This is the first time we have tried to use this tool so have no previous experience to refer to.

Any help would be very much appreciated.

 

 

Hi Kate. What appears under the 'status' column before you click 'import'?

[SovietRussia]

I to am having problems with this tool.

I downloaded the latest version yesterday.

I created a csv file with Admission No, Surname, Forename, Email and Location.

I can connect to the database, browse and open the csv and pick the fields that I want to import.

On clicking import it starts to process the file and then just closes the tool.

It never imports anything and there is no blank data in the csv file.

This is the first time we have tried to use this tool so have no previous experience to refer to.

Any help would be very much appreciated.

 

I had it close on me after 7% once because I disturbed it (clicked on it) - leave it be and well alone I have discovered!!!

[Kate101]

Hi ilsley_SIMS,

Thanks for you prompt reply.

Once I have matched the fields and I click OK it starts listing the students and against the staus for each one it says "import email".

It will carry on listing the students on a per line basis and then suddenly stop and close the program.

It will stop at different students so I cannot isolate it to anyone in particular.

Any thoughts please?

[ilsley_SIMS]

Hi ilsley_SIMS,

Thanks for you prompt reply.

Once I have matched the fields and I click OK it starts listing the students and against the staus for each one it says "import email".

It will carry on listing the students on a per line basis and then suddenly stop and close the program.

It will stop at different students so I cannot isolate it to anyone in particular.

Any thoughts please?

 

 

Try a CSV file with just a small sample of records (maybe 3?) and see if that works in the first instance. If it works, then hopefully Matt can get a better idea of what the problem might be.