Hi, I am trying to import around 35 users on a cvs file, but it´s not working no matter the format I try.I tried using creating a cvs file with four columns : Email, Name, Phone, Internal Notes as the import help text says. However, it fails with an error saying the system was unable to map the info to the users fields, in spanish (Email;Name;Phone: Incapaz de encabezar el mapa a un campo de usuario).I also tried using a cvs file with all values separated by comma in just one column, and it didn't work either. What am I missing here...?General Info:Osticket latest version 1.9.7Spanish Language Best Regards,Marvin M

Since I have not yet used the csv import, have you tried to switch back to the English Language and import the csv then?

@[deleted] Thanks for your reply. I haven't tried that. I will,and report result here.Thanks.Marvin M

Please let us know how you make out.  Thanks

Hi, Just tried and I got the same error, but in English hehe Email;Name;Phone: Unable to map header to a user field@[deleted]

Did you make sure to include the headers in the csv and do they have the correct order as shown on the "import" popup window? Maybe, can you post a screenshot or the first two lines of your csv?Beside, did you try different delimiters, e.g. ";" or "," or "space" or "tabulator"?(Since I currently have no idea what delimiter osTicket can handle and which is the right one)

@ Chefkeks Thanks for your reply.Yes, I tried first with columns as the Import users page/pop up instructs. See screenshot belowblankThen I tried with all the data in one column separated by commas, and it didn't work either. In both cases I typed the headers in the first  row, in the first case, one header in each column, and on the second case, all headers separated by commas in the first row too.See attached screenshots. It be great if we had an updated wiki to set up all this stuff, I guess the feature is functional but I have no idea how to use it. 

screenshot_20150421_083229.png

screenshot_20150421_084022.png

screenshot_20150421_084059.png

I tried using the first option, just name and email, and guess what, it didn't work either :(So I guess there's something wrong with the importer.EDIT: I just found what was causing the error while trying to import users using just the name and email. I had one format error in one of the emails, a comma instead of the dot *email@gmail,com Duh! I corrected that, and could import all users.I also used the corrected file and tried to import the other fields like the phone  *(Using the upload tab), and it still didn't work and got the same error described in this thread.Thanks.

screenshot_20150421_103330.png

a year later

Does anybody have an update on this? I am trying to migrate users to a new osticket set up and cant use the import feature! it wont work no matter what format I use.

2 months later

I experience same problem. I use ost-1.9.8 English.I can only import name and email address.But tried many times still fail to import "Notes" into OST.The import process run OK and users imported, but the "Notes" detail in my CSV are all ignored and not imported.Then i try another test. I created manually online some users with "Internal Notes", then i do an User export into csv file. After that i delete all users in the system, import the same CSV file which OST exports.I was expecting the same set of users will be re-created. But the result was ERROR. Failed importing users.So the exported CSV file from OST also fail to import back.Still trying to find out how to import Users with "Internal Notes"

@codekmarv  have you tried to import the same CSV file 2 times in a row?this may solve your problem.from:https://github.com/osTicket/osTicket/issues/2123seems that "Internal Notes" can only be imported for EXISTING users in the system.So if you first time import users, "Internal Notes" are ignored.But when you import the same users the 2nd time, Internal Notes will be imported.I just tried i OST 1.9.8 and it works.

2 years later

Good Day To All,

I am on 1.11 and having this same issue from a long time ago.. I cant figure out if I'm doing something wrong but for the life of me I cant import users..

test_import.csv (have tried , and ; as delimiters and both fail)

When using , as delimiter I receive: "Both name and email fields are required"
When using ; as delimiter I receive: "email;name;phone;notes: Unable to map header to the object field"

here is what the contents of csv look like: (same with the , delimiter)

email;name;phone;notes
user@domainname.org;John Doe;301;

What am I doing wrong ? ?

On a side note, maybe someone knows.. When creating a user there is a spot for Ext. but the contact form doesn't have this while importing users... We do not want to create a new entry in the form since it does not update the actual Ext. field.. ?? Any ideas?

CSV = Comma Seperated Values.

create this as a flat text file and try importing it.

Email,Name,Phone,Notes
neil@osticket.com,Neil S. Tozier,1112223333X1212,

(feel free to delete the user after import)

That absolutely worked! I copy and paste text only with all formatting stripped to the new csv document that worked and then I get the same error.. must be something im pasting somewhere.. ? Will try now with multiple smaller files. THANKS FOR THE HELP!

I got it to work finally.. I work on a Mac and I was using TextWrangler to edit the csv.. it was saving it as default "Windows" compatible.. so I changed it to UNIX compatible and BAM it imported without a hitch..

Thanks for the push ntozier!

5 days later
ntozier changed the title to [resolved] Unable to Import Users with cvs file.
Write a Reply...