How to write custom CSV import routine

[mazhar]

You can write your own import routines to import the CSV data directly from the admin pages. I thought it would be helpful for the community to have some sample of custom CSV import routine. This sample is about how to import users from a CSV file. This is just a sample and provides a basic over view of the user import. It will only import the data for fields that are available with user object. For example the First and last name fields are available in address class so it will not import that information. Obviously that could be done but that will be a complected task and it would be better to keep the sample simple. The sample targets advance users who may want to import their custom CSV information.

[Niraj8428]

hi,

From where to get CommerceBuilder.Utility? if you can please upload the complete sample, as it contains only one page and no references are there, even one function "AlwaysConvert" is also missing.

Thanks.
Niraj

[mazhar]

These classes are used from dlls inside the AbleCommerce website's bin. So if you have your demo AbleCommerce store just put this module in its admin folder and then run the page it will work.

[mazhar]

How to import credit card data using custom CSV import routine
viewtopic.php?f=42&t=9839

[ozlighting]

is it possible to do something similar for Product Options given that there are 3 different dependent tables involved?

if not, how does everyone else import product options? XML is VERY tedious and csv is not supported. Any hints on how to efficiently create or edit XML? or any other hints on how to import Product Options?

Cheers,

Lance

[mazhar]

In order to edit XML you can use XML Marker, its a small free XML editor.
http://symbolclick.com/