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...