Basspassion
Joined: 03 Apr 2007 Posts: 11 Location: Sweden
|
Posted: Sat Nov 15, 2008 3:26 pm Post subject: Problems importing FastSpring sales export |
|
|
Greetings.
I'm trying to import a exported sales CSV from FastSPring.
The CS looks like this:
Code: | Date,Reference,Type,Item Type,Currency,Total,Subtotal,Tax,Product,Title,Base,Quantity,Referrer,Entry,Campaigns,Licenses,Salutation,First Name,Middle Name,Last Name,Company,Email,Phone,Address 1,Address 2,City,Country,Region,Postal
9/1/08,BASxxxxxx-xxxx-xxxxx,Purchase,Base,USD,39.95,39.95,0.00,Online Radio Tuner,Online Radio Tuner,Online Radio Tuner,1,http://www.onlineradiotuner.com/Purchase.aspx,,,xxxx-xxxx-xxxx-xxxx-xxxx-xxxx-xxxx-xxx,,john,,doe,home,test@acme.com,555-555-5555,this adress,blah,blah,US,xx,xxxx |
And my XML definition looks like this:
Code: | <?xml version="1.0" encoding="utf-16"?>
<Importer xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="CsvSalesImporter">
<DateFormat>
<string>M/dd/yy</string>
</DateFormat>
<PurchaseTag>row</PurchaseTag>
<PurchaseReferenceTag>Reference</PurchaseReferenceTag>
<PurchaseDateTag>Date</PurchaseDateTag>
<SalutationTag>Salutation</SalutationTag>
<LastNameTag>Last_x0020_Name</LastNameTag>
<FirstNameTag>First_x0020_Name</FirstNameTag>
<CompanyTag>Company</CompanyTag>
<EmailTag>Email</EmailTag>
<PhoneTag>Phone</PhoneTag>
<FaxTag></FaxTag>
<Street1Tag>Address_x0020_1</Street1Tag>
<StateTag>Region</StateTag>
<CityTag>City</CityTag>
<ZipTag>Postal</ZipTag>
<CountryTag>Country</CountryTag>
<ProductReferenceTag>Product</ProductReferenceTag>
<QuantityTag>Quantity</QuantityTag>
<LicenseKeyTag>Licenses</LicenseKeyTag>
<LicenseKeyDelimiter>\n</LicenseKeyDelimiter>
</Importer> |
I get this error:
Quote: | ---------------------------
Error Importing Sales Data
---------------------------
The following error occurred while importing:
String was not recognized as a valid DateTime.
Do you want to continue importing?
---------------------------
Yes No
--------------------------- |
Any suggestions?
(Using IPN v3.7.4)
Regards,
Magnus |
|