import products from xml or excell

import products from xml or excell

Post by Q2F0dH » Thu, 15 Sep 2005 21:47:03


could anyone know a way to import products from an excell or xml file as i
have a huge number of products saved on excell and xml files it's really
crazy to enter this products one by one to the crm :s
 
 
 

import products from xml or excell

Post by Ron Walleg » Fri, 16 Sep 2005 02:39:08

What we have done for a number of clients is the following:

Create a sql database with a tabel which stores your products.
Create a DTS package which opens the products and places them in the
database.
Next the dts package start a executable.

This executable connects to the database and picks up all products and
uploads them to MSCRM. This is a program which can be created using the SDK.
Doesn't take long and a lot of validations can be done by using SQL DTS and
Visual studio.

Good Luck

Ron Wallegie