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: Arranging source data into columns?

Dan Carvin
Posts: 227

Arranging source data into columns? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 18 Sep 08 3:18 PM

We want to import records into SLX, but the source data is not organized into columns. Instead it looks like this:

ABC Company
1234 Main Street
Seattle, WA 98123

XWZ Company
6789 Front Road
Suite 55
Los Angeles, CA 90210

And so on for 3500 records.

What's a reliable way to arrange these into colunms for import?

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Arranging source data into columns? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 18 Sep 08 3:55 PM

So is this in some sort of text file? Your best bet is to write some code to transform it. You could likely split on CRLF+CRLF to get the "rows" and then split on CRLF to get the columns. You'd want to check the length of the second split to see if it has an address2 entry or not. Should be some fairly quick code.

[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 10:26:58 AM