not matching admission numbers containing letters

[stevething]

Hi,

 

Hopefully someone can help.

 

I have been trying to use the tool to import a UDF, the only primary key i have to search on is the admission number.

 

However the school i working with, there sims admission numbers start with a letter, i.e. look like this "F012345", when i use the bulk import tool, it chops off the first two characters trying to search for "12345".

 

is this a bug in the software or is there something i could do to make it work?

 

cheers

[matt40k]

What version are you using, 1.7 or 2.0? What is the file type your using? If it's CSV, does the raw fill still have F0?

[stevething]

hi matt,

 

using 1.7.23, and using a csv. the raw fill just shows the truncated version. (just realised the example is wrong ish, only 6 characters long(monday morning head still on), admission number is F01234, the tool truncates to just "1234"

[matt40k]

So if you open up the raw file in notepad, Excel (or something) has truncated it already? I'm not sure if I could do anything - ideally you want to get your source file 100% correct first.

 

I'll have a look and see if there is anything I can do - no promises but I'll try and have a look tonight.

[stevething]

Hi,

 

the csv file is not truncated, my source file is correct. the bulk tool seems to be taking the admission number and ignoring the first two characters if it begins with a letter. if i replace the letter F with a number for testings sake, it appears in bulk tool ok, also if i make it a lowercase f, the bulk tool completely ignores the field for that line.

 

this school I'm working at doesn't know why all there admission numbers start with an F, I've never seen it before, the school I'm employed at our admission numbers are just numbers.

 

 

Thanks for your help and quick responses, very much appreciated.