Author Topic: Export Files not able to be read by access or excel  (Read 5157 times)

Offline nostril2

  • Newbie
  • *
  • Posts: 8
  • Karma: +0/-0
    • View Profile
Export Files not able to be read by access or excel
« 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

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: Export Files not able to be read by access or excel
« Reply #1 on: October 29, 2018, 05:18:41 AM »
Hi.
What delimiter you use for CSV export?

Offline nostril2

  • Newbie
  • *
  • Posts: 8
  • Karma: +0/-0
    • View Profile
Re: Export Files not able to be read by access or excel
« Reply #2 on: October 29, 2018, 10:45:48 AM »
I've tried every delimiter.  I'm stumped

Offline nostril2

  • Newbie
  • *
  • Posts: 8
  • Karma: +0/-0
    • View Profile
Re: Export Files not able to be read by access or excel
« Reply #3 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.

Offline nostril2

  • Newbie
  • *
  • Posts: 8
  • Karma: +0/-0
    • View Profile
Re: Export Files not able to be read by access or excel
« Reply #4 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

Offline nostril2

  • Newbie
  • *
  • Posts: 8
  • Karma: +0/-0
    • View Profile
Re: Export Files not able to be read by access or excel
« Reply #5 on: October 29, 2018, 03:14:58 PM »
Here's the attachment mentioned above

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: Export Files not able to be read by access or excel
« Reply #6 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

Offline nostril2

  • Newbie
  • *
  • Posts: 8
  • Karma: +0/-0
    • View Profile
Re: Export Files not able to be read by access or excel
« Reply #7 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.

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: Export Files not able to be read by access or excel
« Reply #8 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

 

Powered by SMFPacks Social Login Mod