UDF on Version 2.3.27 - Not Imported

[phughes]

Hi,

 

We have created a UDF field for pupils (single line) and need to import for all pupils. On my CSV I have two fields (to make things easy), Admission Number and UDF data. When I run through the import procedure, the Admission number is used to match and finds the pupil information. But when it comes to importing the new data into the UDF, the report shows "NOT IMPORTED".

 

When I checked the logs, this looks like the entry where it fails.

 

05/08/2015 10:18:46	Trace	Set UDF: False - 15670 - ca281102

 

Any ideas on how I can get this working?

 

Much appreciated,

Pete

[matt40k]

Can you manually do it via the front end?

[phughes]

Hi Matt,

 

Thanks for the quick reply.

 

I can go through SIMS.net and enter the data into the UDF field manually.

[matt40k]

What version of SIMS are you using?

[phughes]

SIMS 7.164

[phughes]

Matt? Any ideas?

[matt40k]

Sorry, I've only got far as replicating it - https://github.com/SIMSBulkImport/SIMSBulkImport/issues/15. Hopefully I'll have a fix by the end of the week.

[phughes]

Awesome. Thank you

[matt40k]

Fix in latest release (2.3.33) - https://github.com/SIMSBulkImport/SIMSBulkImport/releases/latest

[phughes]

Hi Matt,

 

Thanks for that. This release only seems to work with XLSX or XLS format, but thats good enough for me

[matt40k]

Odd, imported a CSV ok when testing it - https://gist.github.com/ef307a839980b6433a01 - how big a file are we talking? How many rows?

[phughes]

Even a 10 row csv freezes on loading data. XLSX and XLS loads straight away