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!

Administration Forums - General Administration
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to General Administration | New Thread

View: Search:

Author

Thread: Picklist related query

Richa
Posts: 45

Picklist related query Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Aug 07 3:31 AM

Hi All,

Importing contact details into the SLX from an excel sheet -- Excel contains few columns which are of picklist type.

The values in the columns need to be validated against the values in the DB; should the validation be against the Text column in the Picklist table?

Should the entire text column in the Picklist table be checked for the existence of the value specified for each row in the picklist type column in the excel sheet or is there any other work around?

Thanks,
Richa

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: Picklist related query Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Aug 07 7:06 AM

I would suggest if possible to do the cleanup before Importing the data if possible. This will also lead to less problems while loading + probably faster loading speed.

If you think about the Picklist table, it contains entries for all Picklists in the system, so a value may match against the table, but not be applicable for that field. (e.g. Acct. Status = Active is not a valid Opportunity Status on most Implementations).

You can load the data into a Temp SQL table, and then query each column doing a Distinct (or grouping it if you would like to get counts to establish relevance) so that you could establish what actual data you have on the table, then you should compare that against what values you are planning on having in the picklists. You may have somevalues to add to the picklist, and/or some values to replace on the data to make it consistent

[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 © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 7/9/2025 10:41:25 AM