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: How to import Data from Excel to Notes in Contacts?

Libin
Posts: 38

How to import Data from Excel to Notes in Contacts? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 03 Jan 11 1:10 PM

I want to upload data to Notes of Contacts from excel sheet. How is it possible? Can I do it using ImportWiz? If possible, can anyone detail on it?

Thanks in Advance

Libin

[Reply][Quote]

Libin
Posts: 38

Re: How to import Data from Excel to Notes in Contacts? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Jan 11 3:06 AM

I Meant import to Notes in Contacts of SLX..!! Can anyone guide me on this..? Using the ImportWiz?

[Reply][Quote]

John Gundrum
Posts: 632

Re: How to import Data from Excel to Notes in Contacts? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Jan 11 8:10 AM

Is this a one time import or will this be an ongoing process?

A1: One Time - Do it manually.

A2: Ongoing - The Excel sheet has to have some piece of data in it to link the row of information to the contact in SalesLogix. Ideally this would be the SLX contact id, but beyond that I'd say go with an email address.

The problem with A2 is there will ALWAYS be exceptions to be dealt with. For example, if you decide to link via the email address method, what happens when a contact in the Excel sheet does not have an email address entered? Does the whole process fail (this makes it easier to redo)? Or does the import for that record only fail, which creates even more issues when trying to deal with that single row again.

[Reply][Quote]

Phil Parkin
Posts: 819

Re: How to import Data from Excel to Notes in Contacts? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Jan 11 11:39 AM

You'll struggle with ImportWiz, though it may be possible, as this tool was designed to bring in new accounts, contacts and notes all as part of the same batch. Bringing in Notes only for existing contacts may be possible - though you'll face matching issues, as mentioned above, unless you have the SLX Contact ID as one of your input fields. You'll also have to create a non-standard import map.

Alternatively, use a different tool. You could write the import as a new SLX routine and then use a menu item within the app itself to call it. Or develop an import routine in .NET or SSIS.

Whichever way you select, you'll need a connection via the SLX OLEDB Provider, when creating the new records - otherwise you won't be able to generate the necessary table IDs.

[Reply][Quote]

Libin
Posts: 38

Re: How to import Data from Excel to Notes in Contacts? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Jan 11 1:14 PM

Quote:
Originally posted by John Gundrum

Is this a one time import or will this be an ongoing process?

A1: One Time - Do it manually.

A2: Ongoing - The Excel sheet has to have some piece of data in it to link the row of information to the contact in SalesLogix. Ideally this would be the SLX contact id, but beyond that I'd say go with an email address.

For the time being, this is a single time process. I'm not sure if requests will be coming in future. Manaul editing seems rather implausible as there are hundreds of records to be updated.

[Reply][Quote]

Libin
Posts: 38

Re: How to import Data from Excel to Notes in Contacts? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Jan 11 1:15 PM

Thanks Phil and John..!! Lemme try the other ways tmrw...!!

[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): 4/25/2024 5:12:41 PM