AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: domizzo on June 30, 2015, 01:01:36 PM

Title: CSV IMPORT
Post by: domizzo on June 30, 2015, 01:01:36 PM

When I export the product fields after creating a couple of sample products the result is the  maximum number of columns in excel (256 in the older version I am using) all filled with column headings; mostly options, etc.  I am wondering if just the product headings in the import/export section of the manual are the ones that I need and if so, can I just include them in my csv file to import or are some of the 256 headings required?(I'm using the latest version Abantecart 1.2.2

Title: Re: CSV IMPORT
Post by: abolabo on June 30, 2015, 01:56:27 PM

You talking about custom selection of columns.
AbanteCart do export based on it's own table model that do not support customize.
Try to use some other app to view and edit csv-files. CSV is not main excel file format.

Title: Re: CSV IMPORT
Post by: llegrand on June 30, 2015, 02:26:39 PM

Sounds like your Excel is pretty out of date  :)

Try one of these FREE alternatives  -  even though I have the latest MS Office programs,  I often prefer using Libre Office for export and import my db files as there is less Microsoft "extras" to strip out.


https://www.libreoffice.org/download/libreoffice-fresh/ (https://www.libreoffice.org/download/libreoffice-fresh/)

http://www.openoffice.us.com/ (http://www.openoffice.us.com/)

Title: Re: CSV IMPORT
Post by: domizzo on June 30, 2015, 04:57:35 PM

i can modify, delete column headings in excel but are you saying that all 256 of those unique column headings are required?

Title: Re: CSV IMPORT
Post by: Basara on July 01, 2015, 05:03:07 AM

Quote from: domizzo on June 30, 2015, 04:57:35 PM

i can modify, delete column headings in excel but are you saying that all 256 of those unique column headings are required?

Hello. Not all columns are required. In case you dont need tags, options....etc you can remove some of them see few examples http://www.abantecart.com/ecommerce-documentation/admin-user-manual/system/data#Example%202:%20insert

Title: Re: CSV IMPORT
Post by: domizzo on July 01, 2015, 02:18:27 PM

the reason i am asking is to avoid the number
of rows exceeded error msge

Title: Re: CSV IMPORT
Post by: Basara on July 02, 2015, 02:42:40 AM

Quote from: domizzo on July 01, 2015, 02:18:27 PM

the reason i am asking is to avoid the number
of rows exceeded error msge

I am using OpenOffice without any issues. It is free  ;)

Title: Re: CSV IMPORT
Post by: domizzo on July 02, 2015, 09:58:41 AM

I have the latest version of Open Office.  It also gave me the same error message.  Finally, I used a dedicated csv program and that solved the problem. So other than what the manual shows which is which columns need to be included if you are inserting new or updated products it's safe to not include all of the other columns abantecart generates on export?  Thanks for all your help by the way. :D

Title: Re: CSV IMPORT
Post by: Basara on July 02, 2015, 10:01:47 AM

Quote from: domizzo on July 02, 2015, 09:58:41 AM

Finally, I used a dedicated csv program and that solved the problem.

Can you please share "dedicated csv program" name?  ;) This will help to others 

Title: Re: CSV IMPORT
Post by: domizzo on July 02, 2015, 10:28:33 AM

oh ok, I didn't want you to think i was promoting any particular program.  It's a free program called, " Ron's Editor".  It's completely dedicated to csv files.  The free version does a lot and will do everything we need to do here.

Title: Re: CSV IMPORT
Post by: Internet Sales on October 04, 2015, 05:47:21 PM

Thank you Domizzo and Especially you BASARA!!