NEED AN EXPORT TEMPLATE

[w2pac1234]

How do I create a template to export all the shiping infirmation including the email, phone #, full address, full name, and tokens for the quantity and auction title. I will be exporting these into DHL shipping program.

[Wes]

We have a customer export template available that will allow you to export your customer infromation into a CSV file. This may work for you without changes, or could serve as a starting point if you feel further customization is needed. You can download this template from the following URL.

http://www.interapptive.com/support/files/sw_templates/CustomerExport.zip

You will need to unzip the file and place its contents in C:\Program Files\ShipWorks\Application Data\Templates\Reports

To use the template, set your active template to Reports -> Customer Export. Select the desired orders, right click, and choose Save. Provide the file with a name, and click Save. The file will be exported and can be opened in Excel or imported into other applications.

Thanks,

Wes
Interapptive, Inc.

[w2pac1234]

Wes,

Can you please call me at 818-581-5670 as I need to create a custom template to meet my needs to export into DHL. Plase call today if possible.

Basically, I need an exrta fiel to export a token for the quantity and auction title so dhl can import it into the reference field on the shipping label.

-Danny Rackow
D&R Wholesale

[Wes]

I tried calling you today but you were unavailable. I left a voice message. Please feel free to email me directly at wes[at]interapptive[dot]com or call 1-800-95-APPTIVE during normal business hours.

Thanks,

Wes
Interapptive, Inc.

[w2pac1234]

Wes,

I just saw your call. Please call me tomorrow around noon so I can tell you what I need exactly.

[w2pac1234]

Looking at again all I need is the template that you posted here plus another colum for the quantity and another column for the item title in the .csv file. Is that an easy fix?

[Wes]

You could open the template in our Template Editor via Manage -> Manage Templates and make your modifications there. The two elements you mentioned could be accesing using code similar to <xsl:value-of select="//Order/Item/Name" /> and <xsl:value-of select="//Order/Item/Quantity" />.

Let us know if you need further assitance.

Thanks,

Wes
Interapptive, Inc.

[w2pac1234]

I delted the shipping section as I only need the billing address. Here is what I have. Where do I add the code for the quantity and the auction title??

<xsl:text>B_FIRST,B_LAST,B_COMPANY,B_ADDRESS1,B_ADDRESS2,B_ADDRESS3,B_CITY,B_STATECODE,B_STATE_NAME,B_POSTALCODE,B_COUNTRYCODE,B_COUNTRYNAME,B_PHONE,B_FAX,B_EMAIL,&nl;</xsl:text>

<xsl:for-each select="//Customer">



<xsl:variable name="address" select="Address" />


<!-- billing information -->
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/FirstName" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/LastName" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/Company" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/Line1" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/Line2" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/Line3" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/City" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/StateCode" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/StateName" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/PostalCode" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/CountryCode" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/CountryName" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/Phone" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/Fax" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/Email" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/Email" /><xsl:text>",</xsl:text>

[Wes]

An order can have multiple items, how would you like the items displayed along with the address information, if an order would have more than one item?

Thanks,

Wes
Interapptive, Inc.

[w2pac1234]

I dont allow the buyer to combine their purchases, so each order has to be paid for seperatley. They only only purchase more than one if the auction has a quantity greater than 1 available which is why I need a column for the quantity before the auction title.

[Wes]

The following code was modified to be per order (rather than per Customer record), and I added the QTY and NAME columns, along with their associated data.

[w2pac1234]

I think that will work perfectly. One last question is their a way to somehow filter an order if the address has a PO box in it so I know not to export it into DHL?

[w2pac1234]

Sorry, one last question. Is there a way to also have this # show up in the phone # section. 818-555-5555

[w2pac1234]

There seems to be a problem with the template.

I exported 20 orders and instead of each order being on a seperate row all the orders are on row 2 in excel and cannot be imported as each order has to be on a seperate row to correspond with the column header.

Any way to fix this?

[w2pac1234]

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE xsl:stylesheet[ <!ENTITY nl "&#xd;&#xa;"> ]>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:sw="http://www.interapptive.com/shipworks" extension-element-prefixes="sw">
<xsl:import href="System\Common" />

<xsl:output method="text" encoding="utf-8" />

<sw:settings>
<sw:preview>
<sw:type>Customers</sw:type>
<sw:count>14</sw:count>
<sw:zoom>108%</sw:zoom>
</sw:preview>
<sw:saving>
<sw:filename>CustomerExport</sw:filename>
<sw:multiPromptEach>True</sw:multiPromptEach>
<sw:filetype>csv</sw:filetype>
</sw:saving>
<sw:general>
<sw:type>report</sw:type>
</sw:general>
</sw:settings>

<!-- -->
<!-- Start of processing -->
<!-- -->
<xsl:template match="/">

<xsl:text>B_FIRST,B_LAST,B_COMPANY,B_ADDRESS1,B_ADDRESS2,B_ADDRESS3,B_CITY,B_STATECODE,B_STATE_NAME,B_POSTALCODE,B_COUNTRYCODE,B_COUNTRYNAME,B_PHONE,B_FAX,B_EMAIL,QTY,NAME&nl;</xsl:text>

<xsl:for-each select="//Order">



<xsl:variable name="address" select="Address" />


<!-- billing information -->
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/FirstName" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/LastName" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/Company" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/Line1" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/Line2" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/Line3" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/City" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/StateCode" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/StateName" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/PostalCode" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/CountryCode" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/CountryName" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/Phone" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/Email" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/Email" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="Item/Quantity" /><xsl:text>",</xsl:text>
<xsl:text>"</xsl:text><xsl:value-of select="Item/Name" /><xsl:text>",</xsl:text>
</xsl:for-each>

</xsl:template>

</xsl:stylesheet>

[Wes]

The following code includes a new line break for each record:

[w2pac1234]

Wes, Thanks for the phone support. I tried one more thing like we discussed and could not figure it out.

I need to edit this tag:

<xsl:text>"</xsl:text><xsl:value-of select="$address[@type='bill']/Phone" /><xsl:text>",</xsl:text>

I just want it to always put 818-555-5555 instead of trying to pull the phone # off of shipworks.

[Wes]

You could use the following:

[w2pac1234]

That worked great.

Is there a way to combine the quantity and auction title column into 1 culmn so that it would read for example:

"1new in box cell phone.,..."

instead of:

"1"
"new in box cell phone..."

[Wes]

The following code would combine the two columns as you requested:

[w2pac1234]

Wes,

The colmun header shows QTY_NAME, BUTTTT only displays the quantity in the rows below it for each order.

[Wes]

Looks like I made a mistake when editing the code. You will simply need to add "Item/" in before "Name" (without quotes) to resolve the problem.

Thanks,

Wes
Interapptive, Inc.

[w2pac1234]

Everything works great. its exporting to DHL like a champ. Thank you very much for all your efforts. Best service by far.

[Wes]

Glad to hear its working for you. However, wouldn't you need the shipping information to export, rather than the billing address? I know you mentioned that you modified the template to strip out the shipping section, so I was just curious, and I wanted to make sure that you are indeed outputting what you need/want.

Thanks,

Wes
Interapptive, Inc.

[w2pac1234]

I only ship to the billing address so I do not want to ship to the shipping address if it is different.