Zen Cart Logo
Forums / Code Collaboration / Working on an importer

Working on an importer

Views: 4,019

Results 1 to 3 of 3
20 Aug 2019, 1:45 AM
#1
hasher avatar

hasher

New Zenner

Join Date:
Sep 2011
Posts:
77
Plugin Contributions:
0

Working on an importer

Hi Guys ,

I have been working on my own importer into the Zencart Database. So far I have made a app which takes a excel spreadsheet and formats all fields and sets up the defaults for my digital products. This is a great time saver as it can get through about 10000 products in a few minutes. It error checks and sorts products into their categories

Also I am working on an importer which links directly to the database using the excel database I have made.

My work so far has been in VB.NET and uses freeware Nuget libraries for MS Excel . MYSQL and Image manipulation. Everything so far is just console apps but I will combine it all at the end into a nice GUI. I'm not a professional coder but I do have a professional coder friend who reviews my work.

Just wondering if there is any interest from people who may want to be interested in collaborating a github community app?

Paul

20 Aug 2019, 8:32 AM
#2
torvista avatar

torvista

Totally Zenned

Join Date:
Aug 2007
Location:
Gijón, Asturias, Spain
Posts:
2,866
Plugin Contributions:
7

Re: Working on an importer

Seems like you are duplicating work on top of this:
https://www.zen-cart.com/showthread.php?220569-Database-I-O-Manager-%28DbIo%29-Support-Thread

Personally I use Pentaho Kettle Community to extract and manipulate data from a legacy database, and create a suitable csv for subsequent import into ZC (although it could do the whole process), as this plugin was not available when I needed it.

Still, I would recommend anyone to use this as a basis for making their own import template.

20 Aug 2019, 12:46 PM
#3
hasher avatar

hasher

New Zenner

Join Date:
Sep 2011
Posts:
77
Plugin Contributions:
0

Re: Working on an importer

Thanks torvista,

Checking out Database I/O manager . Wasnt happy with EP4 but this looks better.!