Import of users
 
Notifications
Clear all

[Solved] Import of users

15 Posts
4 Users
1 Reactions
3,619 Views
Posts: 1509
Admin
(@trobinson)
Noble Member
Joined: 9 years ago

@dwi-cahyono-novianto Can you edit the csv in notepad and paste the first line?

Reply
1 Reply
(@dwi-cahyono-novianto)
Joined: 6 years ago

Eminent Member
Posts: 20

@trobinson Hallo Trevor thanks for your response,
this is the first line from my CSV

Display Name;E-mail Address;Password;First Name;Middle Name;Last Name;Type;Address;State;ZIP;City;Country;Job Title;Company;Department;Office;Business Phone;Fax;Home Phone;Mobile Phone;Pager;Web Page;Notes;Mailbox Plan

 

Thanks,

Regard

Reply
Posts: 1509
Admin
(@trobinson)
Noble Member
Joined: 9 years ago

Hello,

Can you try make the file Comma delimited?

Regards,

Trevor

Reply
1 Reply
(@dwi-cahyono-novianto)
Joined: 6 years ago

Eminent Member
Posts: 20

@trobinson thanks for your response

this is my file Co

mma delimited

image

i used this file for import csv, but the error steel same

 

Reply
Posts: 1509
Admin
(@trobinson)
Noble Member
Joined: 9 years ago

Hello,

The file you attached is Semicolon delimited and that could be causing the issue. When it is opened in excel it shows all values in column A due to this issue.

Please try saveas in excel and select CSV (Comma delimited) (*.csv) as the type.

Regards,

Trevor

Reply
2 Replies
(@dwi-cahyono-novianto)
Joined: 6 years ago

Eminent Member
Posts: 20

@trobinson 

Oke i will make some new file CSV (Comma delimited) as the type

i will try with the file below.

Thanks

Regards

 

 

Reply
(@dwi-cahyono-novianto)
Joined: 6 years ago

Eminent Member
Posts: 20

Hai Trevor

i got the same error, this is the error message 

[28/04/2021 19:39:19] ** SolidCP.Import.CsvBulk 1.4.7 Started **
[28/04/2021 19:39:20] ERROR: Column 'Type' not found
[28/04/2021 19:39:20] 1 line(s) processed
[28/04/2021 19:39:20] 0 mailbox(s) imported
[28/04/2021 19:39:20] 0 contact(s) imported
[28/04/2021 19:39:20] 0 user(s) imported
[28/04/2021 19:39:20] ** SolidCP.Import.CsvBulk Ended **

 

Reply
Posts: 1509
Admin
(@trobinson)
Noble Member
Joined: 9 years ago

Hello,

Your file is sill Semicolon delimited. I have attached a Comma delimited file.

Regards,

Trevor

 

Reply
1 Reply
(@dwi-cahyono-novianto)
Joined: 6 years ago

Eminent Member
Posts: 20

@trobinson

Waaaaw so many thanks for you trevor, With the file that you provide, I can import a large number of users in one import.

 

thanks a lot trevor

 

Reply
Page 2 / 2
Share: