11/21/2024 8:50:51 PM
slxdeveloper.com
Now Live!
|
|
| |
| Simple Product Import Tool |
|
| Description: |
A simple product import tool that imports products from an Excel spreadsheet.
|
| Category: |
Code Samples
|
| Author: |
Bob (RJ)Ledger
|
| Submitted: |
8/2/2005
|
| |
|
| Stats: |
Article has been read 15158 times
|
Rating:
 - 5.0 out of 5 by 1 users |
|
|
|
fiogf49gjkf0d
A simple Product Import Tool for V6.2.x.
I've included:
- Form w/Code
- Menu to launch the tool
- Sample Excel workbook (I use ADO to connect to the Excel workbook to get the import data).
This is a FREE UNSUPPORTED tool (that should have been in SalesLogix to begin with)
 Download the Bundle
... have a nice day!
|
|
|
Bob (RJ)Ledger
(SalesLogix Business Partner)
rjlSystems, LLC - www.rjlSystems.net - Sage SalesLogix Business Partner "...Customer First..."™
fiogf49gjkf0d Founder/CEO- rjlSystems, LLC - www.rjlSystems.net
- Sage SalesLogix Business Partner
- TaskCentre Business Partner
- Swiftpage Business Partner
Alpine skiing... BIG time!
.. Season Pass to Wildcat (NH)... any takers?
Carpentry..
View online profile for Bob (RJ)Ledger
|
|
|
|
Rate This Article
|
you must log-in to rate articles. [login here]
|
|
|
|
Please log in to rate article. |
|
|
|
Comments & Discussion
|
you must log-in to add comments. [login here]
|
|
|
- subject is missing.
- comment text is missing.
|
|
|
| Re: Simple Product Import Tool
Posted: 8/25/2005 2:39:01 AM | fiogf49gjkf0d Great thing to start from. Good to not have to write from scratch when finding yourself needing to import something from excel in the Client... | |
|
| Re: Simple Product Import Tool
Posted: 10/12/2005 8:44:24 AM | fiogf49gjkf0d The SalesLogix Import Wizard will basically import from Excel already. Well, Excel that's been saved as a CSV, which is a pretty simple task within Excel. So I don't know what one would gain from using this bundle? | |
|
| Re: Simple Product Import Tool
Posted: 10/17/2005 6:08:39 PM | fiogf49gjkf0d Michael,
Like all tools, the Import Wizard works best (no pun intended) when used for the purpose it was designed for. Specifically Importing Contacts and Accounts. However, the Product table(s) has no association with Accounts or Contacts. Although it is possible, it is not easy to imports Non-Account associated data (w/the Import Wizard). Also, my tool does pure ADO and not csv so there is not the typical "mess" associated with parsing that stuff.
This tool is also a complete example of how to write a tool for importing (into SalesLogix) any data using ADO. One just has to supply his/her own "connection string" to pull data from other sources.
| |
|
| Re: Simple Product Import Tool
Posted: 1/11/2006 11:06:47 AM | fiogf49gjkf0d Hello Bob,
thanks for your tools.
I have adaptes this to import oppotunities from a Access DB.
My opportunities are imported in the OPPORTUNITY table but they are not visilbe in the SLX client. (we are using slx 6.2).
Do you know why ?
thanks
| |
|
| Re: Simple Product Import Tool
Posted: 1/11/2006 11:58:11 AM | fiogf49gjkf0d The tool was designed specifically for the import of Products. Products do not depend on any other data/table(s). At a minimum, Opportunities are tied to accounts (and possibly contacts).
--
RJL | |
|
| Re: Simple Product Import Tool
Posted: 7/14/2006 5:52:16 AM | fiogf49gjkf0d Hi Nicolas,
If this is still a current issue you have, can you give me the column names you have attempted to populate and a typical line of data ? | |
|
| Re: Simple Product Import Tool
Posted: 12/20/2007 4:36:06 PM | fiogf49gjkf0d Will this work for SLX 7.0.1? | |
|
| Re: Simple Product Import Tool
Posted: 12/20/2007 5:33:44 PM | fiogf49gjkf0d Sure
--
RJLedger | |
|
| Re: Simple Product Import Tool
Posted: 3/25/2009 11:35:51 PM | fiogf49gjkf0d Bob, thanks for the tool it worked really well and is great for adding new products. I simply need to update the price on a large part of the product master in SLX, and even though I click append, it adds the records again. I tried to export the whole products table and then click new, it told me it was going to delete and I accepted, it did its thing, but then when I look at my products they are all there another time.... Any tips for how to just truly append the proce of existing products?
Thanks,
Rhonda | |
|
|
|
|
|
Visit the slxdeveloper.com Community Forums!
Not finding the information you need here? Try the forums! Get help from others in the community, share your expertise, get what you need from the slxdeveloper.com community. Go to the forums...
|
|
|
|
|
|