NewYorkFashionToGo
Programmer
I am in process of Building an xml feed to feed into endicia for shipping. I tried exporting a file in XML format, It is very close to what I need, But not 100% what I need. I am trying to do some data manipulation in a query and I am stuck.
A small example of what the final result should be is:
<Package ID="1"> Need to manipulate
<MailClass> Perfectly fine
<Flat Rate> Perfectly fine
<More Fine> Other Fine fields
<Even More Fine> Other Fine Fields
<Package ID="2"> Need To Manipulate
I am running a query In one Field That will be hidden I want to put ="<Package ID="
In A completely seperate Field I want The Number Starting at 1 and adding 1 down each row in that column so It would be 1 , 2, 3, 4
Then In the third Hidden field I want to close it With ="">"
Then In the fourth Field I want to Put the other textfrom the three columns together So It will read in the query as: and The other fields.
<Package ID="1">
<Package ID="2">
<Package ID="3">
I am also open to any other suggestions I have about achieving doing shipping through endicia, Doesnt have to be this way. Just to mabee give me a different angle of looking at the problem in front of me.
Thanks In advance (o;
A small example of what the final result should be is:
<Package ID="1"> Need to manipulate
<MailClass> Perfectly fine
<Flat Rate> Perfectly fine
<More Fine> Other Fine fields
<Even More Fine> Other Fine Fields
<Package ID="2"> Need To Manipulate
I am running a query In one Field That will be hidden I want to put ="<Package ID="
In A completely seperate Field I want The Number Starting at 1 and adding 1 down each row in that column so It would be 1 , 2, 3, 4
Then In the third Hidden field I want to close it With ="">"
Then In the fourth Field I want to Put the other textfrom the three columns together So It will read in the query as: and The other fields.
<Package ID="1">
<Package ID="2">
<Package ID="3">
I am also open to any other suggestions I have about achieving doing shipping through endicia, Doesnt have to be this way. Just to mabee give me a different angle of looking at the problem in front of me.
Thanks In advance (o;