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
Hy,
i'm agree with you.
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
@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
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
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.
