slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Data & Imports Forums - SalesLogix Imports
Forum to discuss general SalesLogix import and data migration topics. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Imports | New Thread

View: Search:

Author

Thread: Phone number quirk

Dan Carvin
Posts: 227

Phone number quirk Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 09 Oct 08 6:18 PM

I've discovered that if you import phone numbers with extentions in the format (999)999-9999 ext. 999, SaleLogix (at least 6.2) displays the "ext" as 398. SLX is apparently converting letters into numbers corresponding to the numbers on the phone keypad, as in (800) FLOWERS to (800) 356-9377. I have found that if you change the ext. to just x, SLX will display the x.

My ways to correct this are either to make my access phone number parsing formula even more complex, or to run a Replace SQL statement to change ext. to x, which I'm sure won't work in the Execute SQL utility and won't sync to remotes if you run it in query analyzer.

Grrrr.

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: Phone number quirk Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 10 Oct 08 8:38 AM

It's awlays done this - the only thing it recognises for extension is an X (for extension).

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/22/2024 9:50:33 AM