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>
Any help is appriciated, Thanks...