Import of users
 
Notifications
Clear all

[Solved] Import of users

15 Posts
4 Users
1 Reactions
3,525 Views
Posts: 3
Topic starter
(@jonnyhjortland)
New Member
Joined: 8 years ago

Whats our options when registering/importing 600 organization users without manually registering them? It's a new domain without any user accounts registered.

Enteprise Import Tool:
This requires an Exchange installation which is not available. Can we somehow configure the space so that we can use the tool without Exchange?

CsvBulk Import:
I have downloaded the application but there are no instructions on how the .csv should be formatted with columns. Does anybody have an example csv that can be used? I presume this will create organization users and not SolidCP users...

Best regards

14 Replies
Posts: 20
(@groulte)
Eminent Member
Joined: 9 years ago

Hy,

i'm agree with you.

Reply
Posts: 20
(@groulte)
Eminent Member
Joined: 9 years ago

After i little bit search, i've found 🙂 I'm proud 😀

1/ configure your SolidCP.Import.CsvBulk.exe.config file

<add key="InputFile" value="test.csv"/>
<add key="TargetOrganization" value="YOUR-ORG-WHERE-IMPORT-YOUR-ACCOUNT"/>
<add key="ES.WebService" value="http://YOUR-ES-IP-ADDRESS:9002"/>
<add key="ES.Username" value="serveradmin"/>
<add key="ES.Password" value="YOUR-PASSWORD"/>
<add key="ConnectionString" value="server=COPY-AND-PASTE-INFORMATION-FROM-PORTAL-CONF"/>
<add key="LogFile" value="SolidCP.Import.CsvBulk.log"/>

2/ That'is the default header of your csv file. Is name must be -> test.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

There is 24 cells.

And 'voila' the first

Eric,eric@eric .fr,Eri1c90S$,Eric,,GROULT,Mailbox,,,,,,,,,,,,,,,,,EXCHANGE - 1 Go

The different kind of type is : Mailbox, Contact, User, Room, Equipement, SharedMailBox

3/ you can follow the debug process in the log file -> SolidCP.Import.CsvBulk.log

Good luck

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

Eminent Member
Posts: 20

@groulte i use this metode but i have error like this.

[27/04/2021 12:21:51] ** SolidCP.Import.CsvBulk 1.4.7 Started **
[27/04/2021 12:21:52] ERROR: Column 'Type' not found
[27/04/2021 12:21:52] 1 line(s) processed
[27/04/2021 12:21:52] 0 mailbox(s) imported
[27/04/2021 12:21:52] 0 contact(s) imported
[27/04/2021 12:21:52] 0 user(s) imported
[27/04/2021 12:21:52] ** SolidCP.Import.CsvBulk Ended **

in the header, i was used default header like your example. but i have error column 'Type' not found

please help for the problem

Reply
Posts: 3
Topic starter
(@jonnyhjortland)
New Member
Joined: 8 years ago

Hi again.

Thank you a lot groulte 🙂 This solved my case!

You actually have to have an Exchange-organization in place for this import to work, because you have to assign a Mailbox Plan. I tried without one but the import tool responded with:

[06.04.2017 12:54:24] INFO: Warning at line 2: Plan named  does not exist!
[06.04.2017 12:54:24] ERROR: Error at line 2: No valid plan name and/or no valid default plan

I have a mailbox plan defined for another Hosting Space and I could actually use the name of this Mailbox-plan despite the fact that the Hosting Space I was importing into wasn't enabled for Exchange and didn't have an Exchange Hosting Plan. I defined the import type as a User (not a Mailbox).

For those who doesn't have an Exchange installation at all, it might be possible to just create a "fake" Mailbox plan in the database with parameteres something like in the attached picture.

Regards

Reply
Posts: 20
(@groulte)
Eminent Member
Joined: 9 years ago

hy @jonnyhjortland . Good news for you & for the case when, you don't have Exchange MAILBOXPLAN.

I think, marco & friends should put a blank CSV with header in the ZIP file.

And maybe, we could create a mini HOWTO.

Have a nice week-end.

Reply
Page 1 / 2
Share: