Forum

Notifications
Clear all

[Solved] Import of users

Page 2 / 2

Trevor Robinson
Posts: 1328
Admin
(@trobinson)
Member
Joined: 5 years ago

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

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

Active Member
Posts: 7

@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
Trevor Robinson
Posts: 1328
Admin
(@trobinson)
Member
Joined: 5 years ago

Hello,

Can you try make the file Comma delimited?

Regards,

Trevor

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

Active Member
Posts: 7

@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
Trevor Robinson
Posts: 1328
Admin
(@trobinson)
Member
Joined: 5 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
(@dwi-cahyono-novianto)
Joined: 2 years ago

Active Member
Posts: 7

@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
(@dwi-cahyono-novianto)
Joined: 2 years ago

Active Member
Posts: 7

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
Trevor Robinson
Posts: 1328
Admin
(@trobinson)
Member
Joined: 5 years ago

Hello,

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

Regards,

Trevor

 

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

Active Member
Posts: 7

@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:
Downloads