AbanteCart Community

Shopping Cart Operations => Built-in Features => Topic started by: nostril2 on October 26, 2018, 07:15:29 PM

Title: Export Files not able to be read by access or excel
Post by: nostril2 on October 26, 2018, 07:15:29 PM
I am very familiar with manipulating data (ms access, txt files etc) but I'm stumped.

I have exported the products every way imaginable and I cannot get excel or an MS Access data link to understand all the field names.

Correction, I have gotten an XML export to have all of the fields (column names) be read when viewing within MS Access.  But when that happens the data is corrupted and spread all over the place.

If they allow the screenshot, you can what it looks like within access, and keep in mind, there is only actually one product listed in AbanteCart.  So there should only be one record.

Would appreciated any advice.  Thanks
Title: Re: Export Files not able to be read by access or excel
Post by: Basara on October 29, 2018, 05:18:41 AM
Hi.
What delimiter you use for CSV export?
Title: Re: Export Files not able to be read by access or excel
Post by: nostril2 on October 29, 2018, 10:45:48 AM
I've tried every delimiter.  I'm stumped
Title: Re: Export Files not able to be read by access or excel
Post by: nostril2 on October 29, 2018, 11:25:46 AM
See attached image for what it looks like during the Import Steps in MS Access.  You can see that that column names stop after the "products-date-modified" date field.

I've deleted all products and added new products with bare bones info and I still get a clean text file to download.
Title: Re: Export Files not able to be read by access or excel
Post by: nostril2 on October 29, 2018, 11:35:30 AM
Heres a look at the same process as above except it with the "FIRST ROW CONTAINGS HEADINGS" box unchecked
Title: Re: Export Files not able to be read by access or excel
Post by: nostril2 on October 29, 2018, 03:14:58 PM
Here's the attachment mentioned above
Title: Re: Export Files not able to be read by access or excel
Post by: Basara on October 30, 2018, 01:57:45 AM
Please attach example of exported file.
I have never seen any issues with CSV in OpenOffice (it is free) or Numbers app for OS X.

In microsoft office try to import file (not just open) https://www.hesa.ac.uk/support/user-guides/import-csv
Title: Re: Export Files not able to be read by access or excel
Post by: nostril2 on November 06, 2018, 08:50:29 AM
I've worked with text file files for 20 years with MS Access.  The goal is to get it to work with MS Access, because that's where I manage my store data.  I want to export directly from Access to a file supported by AbanteCart.  Ive attached a csv.

thanks for your help with this.
Title: Re: Export Files not able to be read by access or excel
Post by: Basara on November 07, 2018, 01:26:42 AM
I can open your file without any problems.
Maybe your soft dont like a delimiter but you can choose it when export