Developer forum

Forum » CMS - Standard features » Standard import users

Standard import users

E-mail notifications
Kim Søjborg Pedersen
Reply
Posted on 21/10/2011 08:51:37
Hi, is it possible to make a import on users in dynamicweb? or do I have to make some customcode.

I got a excel worksheet from a customer with about 16000 users

Replies

 
Michael Nielsen
Posted on 26/10/2011 09:40:03
Reply
Hi Kim

I can help you some of the way.

First you need access to Import/Export (Extended) module. There you drag and drop i.e. XML Source File and then User Destination to your pipeline.

In User Destination you can see the xml scheme so you know how your xml file should look like.

Unfortunately for me it only imports the last user :-/

 
Michael Nielsen
Posted on 28/10/2011 12:37:02
Reply
Contact HostNordic and get SQL access.

You will then get web-based sql access and in that there is an csv import wizard.

But don't select "First line contains fieldnames", it doesn't work. Instead after you select database and table, you then mark the fields you want to put data into and press next, there you can see in what order the fields should be in your csv file.
And please note that no matter what encoding you put on your file, special characters (like æ, ø, å, ä, ö, ü and so on) will be replaced with Ã.

 

You must be logged in to post in the forum