Developer forum

Dynamicweb supports a standard format for products and groups. Make an export of your shop products and groups to CSV and use XSLT to transform them into that format. It may sound complex, but it's actually pretty simple. I made a presentation of it on Tech Review 2008-3, so take a look at the Part 2 video available here: http://developer.dynamicweb.dk/Tech-Review-2008-2-28453.aspx

the problem isnt't so much importing the data into the ecom but getting the data out of the old DW-shop, if we could get the data from the shop out as csv or xml then it would of course be no problem to use the import/export module. but how do we export from the old shop.

Since you want to switch to Ecom, I assume you're running SQL server. In SQL Server Management Studio right the database and choose "New Query". Enter SELECT * FROM ShopProduct and press F5. Right click the resulting grid and choose "Save Results As...". This allows you to save the data as a CSV file. Do the same for ShopGroup.

You can also use the Database Publishing module for this purpose. Check out this article for further information: http://developer.dynamicweb.dk/default.aspx?id=16918&action=ShowArticle&ArticleID=39

okay we will try that.

thx for the help

No problem. Let me know how it turns out for you.

next problem. we got database access but only through the https://sqladmin.dynamicweb.dk page. but with this tool we have no useful way to export the data we need. is it possible to get access to the database with MS server management studio?

What data do you need to export directly from the database? You'll have to contact HelpDesk regarding server access. I'm not sure whether we're able to provide that.