Infralution Support Forum Index Infralution Support
Support groups for Infralution products
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Importing Sales data from FastSpring

 
Post new topic   Reply to topic    Infralution Support Forum Index -> Licensing Support
View previous topic :: View next topic  
Author Message
mgladding



Joined: 31 May 2009
Posts: 5

PostPosted: Tue Jul 14, 2009 12:46 pm    Post subject: Importing Sales data from FastSpring Reply with quote

I'm trying to import sales data from the FastSpring Site Line Item CSV export file.

The import works correctly except for orders that contain multiple items. In this case only the first item is imported.

I'm using the following import definition, modified slightly from that submitted by a previous poster to this forum.

Code:

<Importer xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="CsvSalesImporter">
  <DateFormat>
    <string>M/d/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>
<TotalPriceTag>Subtotal</TotalPriceTag>
  <LicenseKeyTag>Licenses</LicenseKeyTag>
  <LicenseKeyDelimiter>\n</LicenseKeyDelimiter>
</Importer>
Back to top
View user's profile Send private message
Infralution



Joined: 28 Feb 2005
Posts: 5027

PostPosted: Tue Jul 14, 2009 11:04 pm    Post subject: Reply with quote

How do Fastspring handle multiple purchase items for a customer? Do they just add an extra line? If you could email a sample of the format for multiple purchase items to support@infralution.com we will take a look.
_________________
Infralution Support
Back to top
View user's profile Send private message Visit poster's website
Infralution



Joined: 28 Feb 2005
Posts: 5027

PostPosted: Wed Jul 15, 2009 11:13 pm    Post subject: Reply with quote

Thanks for the sample CSV file. I created a database with products to match the products defined in your CSV file and then just changed the license keys in the CSV file to ones I generated (so I could import them). I used your import definition for the distributor – but had to modify it slightly because your CSV file contains dates in two different formats. I was then able to import the CSV file without issues and it created sales for each line item (which you can see when you expand the customer or look in the Sales tab).

I’ve sent you a copy of the database where I have defined the product and the distributor (including modified import definition) as well as the modified CSV file (with license keys) so that you can try importing the CSV yourself.
_________________
Infralution Support
Back to top
View user's profile Send private message Visit poster's website
scdavid



Joined: 14 Feb 2011
Posts: 6

PostPosted: Mon Feb 14, 2011 6:40 pm    Post subject: Reply with quote

Do you formally support FastSpring? I don't see it in the templates folder.
Back to top
View user's profile Send private message
Infralution



Joined: 28 Feb 2005
Posts: 5027

PostPosted: Mon Feb 14, 2011 11:37 pm    Post subject: Reply with quote

We don't include a FastSpring import definition in the ILS install - but we are happy to support you if you want to use it. Here is the import definition that worked for the original poster:

Code:
<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>
    <string>M/dd/yyyy</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>
<TotalPriceTag>Subtotal</TotalPriceTag>
  <LicenseKeyTag>Licenses</LicenseKeyTag>
  <LicenseKeyDelimiter>\n</LicenseKeyDelimiter>
</Importer>

_________________
Infralution Support
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Infralution Support Forum Index -> Licensing Support All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group