Developer forum

Forum » CMS - Standard features » Only last user is imported

Only last user is imported

Michael Nielsen
Reply
I have set up a pipeline for importing users, but only the last user in my xml document is imported.

In the pipeline I have chosen XML Source File followed by User Destination.

The settings for XML Source File are:
Rootelement: Users
XPath: //Users/User

My XML file looks like this

<?xml version="1.0" encoding="utf-8" ?>
<Users>
	<User>
		<AccessUserUserName>$3</AccessUserUserName>
		<AccessUserPassword>$4</AccessUserPassword>
		<AccessUserCompany>$1</AccessUserCompany>
		<AccessUserCustomerNumber>$2</AccessUserCustomerNumber>
		<AccessUserName>$5</AccessUserName>
		<AccessUserAddress>$6</AccessUserAddress>
		<AccessUserZip>$7</AccessUserZip>
		<AccessUserCity>$8</AccessUserCity>
		<AccessUserPhone>$9</AccessUserPhone>
		<AccessUserEmail>$10</AccessUserEmail>
		<AccessUserType>5</AccessUserType>
		<AccessUserValidFrom>01-01-1900</AccessUserValidFrom>
		<AccessUserValidTo>01-01-2999</AccessUserValidTo>
		<AccessUserActive>True</AccessUserActive>
		<AccessUserPasswordDate>31-12-2999</AccessUserPasswordDate>
		<AccessUserStatusBegin>01-01-1900</AccessUserStatusBegin>
		<AccessUserStatusEnd>01-01-2999</AccessUserStatusEnd>
		<AccessUserParentID>NULL</AccessUserParentID>
		<AccessUserModules />
		<AccessUserInformation />
		<AccessUserRead />
		<AccessUserShopID />
	</User>
        <User>
		<AccessUserUserName>$3</AccessUserUserName>
		<AccessUserPassword>$4</AccessUserPassword>
		<AccessUserCompany>$1</AccessUserCompany>
		<AccessUserCustomerNumber>$2</AccessUserCustomerNumber>
		<AccessUserName>$5</AccessUserName>
		<AccessUserAddress>$6</AccessUserAddress>
		<AccessUserZip>$7</AccessUserZip>
		<AccessUserCity>$8</AccessUserCity>
		<AccessUserPhone>$9</AccessUserPhone>
		<AccessUserEmail>$10</AccessUserEmail>
		<AccessUserType>5</AccessUserType>
		<AccessUserValidFrom>01-01-1900</AccessUserValidFrom>
		<AccessUserValidTo>01-01-2999</AccessUserValidTo>
		<AccessUserActive>True</AccessUserActive>
		<AccessUserPasswordDate>31-12-2999</AccessUserPasswordDate>
		<AccessUserStatusBegin>01-01-1900</AccessUserStatusBegin>
		<AccessUserStatusEnd>01-01-2999</AccessUserStatusEnd>
		<AccessUserParentID>NULL</AccessUserParentID>
		<AccessUserModules />
		<AccessUserInformation />
		<AccessUserRead />
		<AccessUserShopID />
	</User>
</Users>
The $1 is just a placeholder for the real information, every user of course has unique information (just to avoid any misunderstandings)

Any help is appriciated, Thanks...

Replies

 
Michael Nielsen
Reply
I tried placing them in groups by adding this
<AccessUserGroups>
     <GroupID>334</GroupID>
</AccessUserGroups>
And now it creates the last user for every unique GroupID.
 
Michael Nielsen
Reply
This post has been marked as an answer
Used the sql access from hostnordic and the built-in csv import wizard instead...
Votes for this answer: 0
 
Kristian Knudsen
Reply
test

 

You must be logged in to post in the forum