View previous topic :: View next topic |
Author |
Message |
markdart
Joined: 18 Oct 2006 Posts: 18
|
Posted: Tue Feb 02, 2010 3:23 pm Post subject: Outlook Import and Customer Name |
|
|
I am trying to import the IPN data from outlook into license tracker. The data gets imported successfully. The only problem is that it all gets imported with the customer name as mine. I am testing the import with my email addrss so maybe the importer is parsing out my name from the email address (?). I checked the IPN data.
Incoming IPN data is:
<?xml version="1.0" encoding="utf-16" ?>
- <Payment>
- <Transaction>
<mc_handling>0.00</mc_handling>
<mc_shipping>0.00</mc_shipping>
<custom />
<num_cart_items>1</num_cart_items>
<test_ipn>1</test_ipn>
<txn_id>7F7DKLPRSWWHZ3D22</txn_id>
<txn_type>cart</txn_type>
<notify_version>2.1</notify_version>
<charset>windows-1252</charset>
<verify_sign>vJxFRT046ccMipGonDnRDwjZuKDEwtATxAg3VdwQst-vJxFRT046ccMi</verify_sign>
<business>mdreher@mixermuse.com</business>
<receiver_email>mdreher@mixermuse.com</receiver_email>
<receiver_id>TK0M4PKU6YCN5</receiver_id>
<payer_id>TK0M4PKU6YCN5</payer_id>
<payer_email>dreherm_98@yahoo.com</payer_email>
<payer_status>unverified</payer_status>
<first_name>Andrew</first_name>
<last_name>Tester4</last_name>
<address_status>unconfirmed</address_status>
<address_name>Andrew Tester4</address_name>
<address_street>6 Test St</address_street>
<address_city>Test Town</address_city>
<address_state>Test State</address_state>
<address_zip>12345</address_zip>
<address_country_code>US</address_country_code>
<address_country>United States</address_country>
<residence_country>US</residence_country>
<payment_date>11:20:27 Jan 30, 2010 PDT</payment_date>
<payment_type>instant</payment_type>
<payment_status>Completed</payment_status>
<payment_fee />
<payment_gross>64.95</payment_gross>
<tax>0.00</tax>
<mc_gross>64.95</mc_gross>
<mc_currency>USD</mc_currency>
<mc_fee>0.00</mc_fee>
<item_number1>4</item_number1>
<item_name1>T2488 on CD for Tascam 2488 MKII</item_name1>
<quantity1>1</quantity1>
<mc_handling1>0.00</mc_handling1>
<mc_shipping1>0.00</mc_shipping1>
<mc_gross_1>64.95</mc_gross_1>
</Transaction>
- <PurchaseItem>
<Name>T2488 on CD for Tascam 2488 MKII</Name>
<ItemNumber>4</ItemNumber>
<Quantity>1</Quantity>
<TotalPrice>64.95</TotalPrice>
<Upgrade>False</Upgrade>
<LicenseKeys>BAC6-48A5-23FE-1C2B-7862-5FB0-D210-75F4-120A-0654-6623-1AF2-48C4-69CD-956C-139E</LicenseKeys>
</PurchaseItem>
</Payment>
Sale import data is:
<?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="XmlSalesImporter">
<EmailSubject>Payment Notification</EmailSubject>
<EmailFolder></EmailFolder>
<DateFormat>
<string>HH:mm:ss MMM dd, yyyy PDT</string>
<string>HH:mm:ss MMM dd, yyyy PST</string>
</DateFormat>
<PurchaseTag>Payment</PurchaseTag>
<PurchaseReferenceTag>Transaction/txn_id</PurchaseReferenceTag>
<PurchaseDateTag>Transaction/payment_date</PurchaseDateTag>
<CustomerTag>Transaction</CustomerTag>
<SalutationTag></SalutationTag>
<LastNameTag>last_name</LastNameTag>
<FirstNameTag>first_name</FirstNameTag>
<CompanyTag></CompanyTag>
<EmailTag>payer_email</EmailTag>
<PhoneTag></PhoneTag>
<FaxTag></FaxTag>
<AddressTag></AddressTag>
<Street1Tag>address_street</Street1Tag>
<Street2Tag></Street2Tag>
<StateTag>address_state</StateTag>
<CityTag>address_city</CityTag>
<ZipTag>address_zip</ZipTag>
<CountryTag>address_country</CountryTag>
<PurchaseItemTag>PurchaseItem</PurchaseItemTag>
<ProductReferenceTag>ItemNumber</ProductReferenceTag>
<QuantityTag>Quantity</QuantityTag>
<TotalPriceTag>TotalPrice</TotalPriceTag>
<UpgradeTag>Upgrade</UpgradeTag>
<TrueValue>True</TrueValue>
<FalseValue>False</FalseValue>
<LicenseKeyTag>LicenseKeys</LicenseKeyTag>
<LicenseKeyDelimiter>;</LicenseKeyDelimiter>
</Importer> |
|
Back to top |
|
|
Infralution
Joined: 28 Feb 2005 Posts: 5027
|
Posted: Tue Feb 02, 2010 9:34 pm Post subject: |
|
|
That's because License Tracker uses the email address to identify a customer. The may enter their name differently each time they purchase something (eg use initials or capitals etc) - however generally their email address can be used to identify them. So if a customer exists with the given email address then the sale will be imported into their record. _________________ Infralution Support |
|
Back to top |
|
|
markdart
Joined: 18 Oct 2006 Posts: 18
|
Posted: Tue Feb 02, 2010 11:05 pm Post subject: |
|
|
cool - so I am good then!
Another question:
I have the IPN local test server working.
What do I need to deploy the servr out to GoDaddy? I have visual studio 2008 pro (i did the upgrade to SP1) but it looks like I need asp.net, sql server express(?), web publisher - I guess I can't just ftp the files out to the server - too easy...I am just a lonely app developer...agg |
|
Back to top |
|
|
Infralution
Joined: 28 Feb 2005 Posts: 5027
|
Posted: Tue Feb 02, 2010 11:43 pm Post subject: |
|
|
Yes you can just FTP the files up to your server following the instructions in the online help on configuring your website. You don't need anything else. If you don't want to make modifications to the way our source code works then you can just upload the standard files under the Program Files\Infralution\IPN.NET\Server directory, replacing the IpnSettings.xml file with your own customized file. _________________ Infralution Support |
|
Back to top |
|
|
markdart
Joined: 18 Oct 2006 Posts: 18
|
Posted: Wed Feb 03, 2010 2:08 am Post subject: |
|
|
Oh, yes I did modify the IPN source and was running it nicely as a local server from visual studio with all appropriate emails being sent, etc. I was hoping I could ftp my new binaries to the server but I guess it is not that simple(?). |
|
Back to top |
|
|
Infralution
Joined: 28 Feb 2005 Posts: 5027
|
Posted: Wed Feb 03, 2010 4:43 am Post subject: |
|
|
Yes you can just FTP your binaries. Use the Build->Publish menu to copy the required files to a local directory and then you can just FTP them to your server. The online help documents steps for configuring the required directory permissions etc. _________________ Infralution Support |
|
Back to top |
|
|
|