View previous topic :: View next topic |
Author |
Message |
Dave R
Joined: 05 Apr 2009 Posts: 9
|
Posted: Thu Nov 26, 2009 2:53 pm Post subject: DateTime error when importing from Outlook |
|
|
PayPal Sandbox IPN Simulator successfully posts a purchase and I get an e-mail with subject: Payment Notification - John Smith. However, when I import the notification into License Tracker (version 4.5.1.0) it raises the exception:
String was not recognized as a valid DateTime.
The only date I can see in the xml is
<payment_date>06:40:51 Nov. 26, 2009 PST</payment_date>
How can I avoid this exception?
Thanks. |
|
Back to top |
|
|
Infralution
Joined: 28 Feb 2005 Posts: 5027
|
Posted: Thu Nov 26, 2009 9:44 pm Post subject: |
|
|
How have you set up your Sales Import definition for your License Tracker distributor? Did you use the PayPalIPN.xml definition from under the ImporterDefinitions folder? _________________ Infralution Support |
|
Back to top |
|
|
Dave R
Joined: 05 Apr 2009 Posts: 9
|
Posted: Fri Nov 27, 2009 2:35 am Post subject: |
|
|
Thanks. The PayPal Sandbox IPN Simulator created a default date as
<payment_date>06:40:51 Nov. 26, 2009 PST</payment_date>
If I change it in the Simulator text boxes by removing the '.' after Nov it sends
<payment_date>06:40:51 Nov 26, 2009 PST</payment_date>
and the License Tracker can import it just fine.
Thanks for pointing me to exactly the right solution. |
|
Back to top |
|
|
Infralution
Joined: 28 Feb 2005 Posts: 5027
|
Posted: Fri Nov 27, 2009 7:04 am Post subject: |
|
|
I think this is probably a bug in the PayPal simulator as the dates for real PayPal posts are not formatted like this. I haven't seen dates from the simulator like this either previously. You can however modify the import definition so that it will cope with this format. Simply change the date format part of the import definition to:
Code: | <DateFormat>
<string>HH':'mm':'ss MMM. dd, yyyy PDT</string>
<string>HH':'mm':'ss MMM. dd, yyyy PST</string>
<string>HH':'mm':'ss MMM dd, yyyy PDT</string>
<string>HH':'mm':'ss MMM dd, yyyy PST</string>
</DateFormat> |
Then it will import in either format _________________ Infralution Support |
|
Back to top |
|
|
|