cvs or text file propagtion program

bobbyg · Posted: Thu Dec 03, 2009 5:02 pm

Does anyone know of a generic propagation program that can be used on any of the databases?

montego · Posted: Sat Dec 05, 2009 10:03 am

bobbyg, what do you mean by "propagation". Can you please explain a bit more what you are looking to do?

bobbyg · Posted: Sat Dec 05, 2009 4:01 pm

If you are familiar with zencart, there is a program to take a cvs file and insert or update or delete products in the database.

When I did systems design on large frame under cobol I designed a program like that but it was extremely flexible by substituting parameters with field names and could handle variable number of fields.

A program like this could be used on any database, not just an ecommerce database.

fkelly · Posted: Sun Dec 06, 2009 8:35 am

Search on mysql import. There are ways to import text files (and probably Excel type files too) into mysql. Google 'em.

bobbyg · Posted: Sun Dec 06, 2009 4:50 pm

fkelly wrote:

Search on mysql import. There are ways to import text files (and probably Excel type files too) into mysql. Google 'em.

bobbyg wrote:

cvs file and insert or update or delete .

Import won't do it, otherwise I would just use my phpmysql.