Login / Register  search  syndication  about

          Ryan Farley's Blog

Ryan Farley on .NET Development with a focus on CRM Development for SalesLogix

Date Formats and the SalesLogix Provider

If you're in the loop, you've found that the SalesLogix Provider expects all dates to be in ISO format (Note: to clarify, it was originally expected in ANSI format, but with v6.1 the standard was changed to ISO to account for Oracle). I say “in the loop” because unless you're paying close attention and possibly active in the SalesLogix BP newsgroups, then you likely never heard of this.

Simple enough to provide a workaround, just pass off any dates to a function to format them as ISO dates before passing and SQL statements off to the provider. But, why should I need to? So instead of just fixing it in the provider, now I have to modify my code in all places where I use a date in a SQL insert or update.

What if you forget a spot? Tough luck. The provider will still allow them into the database, a TEF file will still be created, the TEF file will be synched out to the remotes, but the remote client will *reject* it when it brings in the changes. So it will give you 100% impression that all things are fine and working, no errors, the data will be inserted into the database, but your remotes will never see the data (even though they saw the extra traffic in their sync.

Not a good thing. SalesLogix has provided the workaround of making us format dates as ISO. I'd be fine with that as long as the data would be rejected or an error thrown by the provider if I forgot to do it. As it is now, you'd never know you forgot to do that until remotes complained about missing data. You'd never know it by looking at the data on the LAN, it will exist fine there. How about this, as a general rule of thumb. If it makes it into the database, then make it sync. If there is going to be a problem making it sync, possibly because of an incorrect date format, then don't let it into the database. At least then you'd know right away what the problem is and you could say “oh yeah, I forgot that whole ISO date thing” and fix it right then.   >:(

What's This?
  
Bookmark and Share

About Ryan Farley

   Ryan Farley is the Director of Development for Customer FX and creator of slxdeveloper.com. He's been blogging regularly about SalesLogix since 2001 and believes in sharing with the community. He loves C#, Javascript, Python, web development, open source, and Linux. He also loves his hobby as an amateur filmmaker.

View the SalesLogix Mobile Seveloper Series
View the SalesLogix SData Developer Series
View the Git for the SalesLogix Developer series



Related Content
   Errors about "getcp" in Git Extensions for SalesLogix
Some of you have reported that you've been experiencing errors mentioning "getcp" when usin
Posted on Mar 15, 2011 by Ryan Farley to Ryan Farley's Blog
 
   Product Table, ModifyDate field not included for use in SalesLogix Web.
I have been working to build a web interface that allows a user to add unlisted products into t
Posted on Apr 29, 2010 by George Jensen to George Jensen's Blog
 
   Groups Not Loading in SalesLogix 7.5 Web
I recently saw an issue where groups would not load in SalesLogix 7.5.1 web. Not a single group would loa
Posted on Aug 31, 2009 by Ryan Farley to Ryan Farley's Blog
 
   Relationship Property Names and Case
In today's SalesLogix Web Developer class, we discussed an issue that someone in the class was having
Posted on Mar 27, 2009 by Ryan Farley to Ryan Farley's Blog
 
   Error Opening InsertOpportunity.aspx in SalesLogix 7.2 Web
I posted this a while back in the SalesLogix Business Partner newsgroups, but it has recently just helped
Posted on Jul 28, 2008 by Ryan Farley to Ryan Farley's Blog
 
Comments

 

Ted Sturr said:

Agree with you 100% on this .... if only we could get the "powers that be" to realize that this is what should happen ... why they didn't include this in SP1a is pretty amazing ... we won't see a possible fix on this now until next year... if ever.
November 22, 2003 11:31 AM
 

Christian B. Mortensen said:

The same problem exists when using the legacy scripts on 6.1 and syncing to remotes.

const MyDateFormat = "yyyymmdd hh:mm:ss"
strCreateDate = format$(now, mydateformat)

then you're date are in the ISO Format.

just helping out if anyone have the same problem I did, :).

April 28, 2004 6:24 AM
 

Ryan Farley said:

Thanks Christian, the more info out there the better!
April 29, 2004 5:58 PM

Leave a Comment

(required)  
(optional)
(required)  
Add
All contents Copyright © 2014 Customer FX Corporation
Customer FX Corporation
2324 University Avenue West, Suite 115
Saint Paul, Minnesota 55114
Tel: 800.728.5783

  Follow @CustomerFX on twitter
Follow the best news, tips, and articles
  Subscribe to Customer FX on youtube
Watch SalesLogix tutorial videos from Customer FX
Login / Register