Skip to main content
Solved

Attachment File Export - File Type Issues 


Forum|alt.badge.img
  • Jr Varsity III
  • 67 replies

Hi everyone, 

When exporting file attachments, in this case the Shop for Rates excel export, it downloads to my computer in a strange way. It says its an Excel file, and the file size is 5 KB. 

 

After I open the excel document and save it, the file size jumps up to 9-10 KB. 

 

The main issue I’m having is when trying to import these export files into Power BI (or even Jupyter notebook and Python). If I try to import the file into Power BI before saving it, I get this error: 

Does anyone know what the file type really is when it is exported from Acumatica? And is there a way to have this change to a “Valid excel document” without having to open up every file, save, and close? 

 

Thanks in advance!

Best answer by bclark

@Chris Hackett 

The solution I ended up going with was a customization project that put a “Download Zip File” on the Search in Files screen, where I could select the files I wanted to export in bulk in a zip file on my local computer. 

Then I ran a python script to open, convert, and save each file to a CSV, because the file type straight out of Acumatica was not a proper Excel format. 

Then I saved all these files in an Access DB. It works, but it took a lot of other steps. Thanks!

View original
Did this topic help you find an answer to your question?

7 replies

Forum|alt.badge.img

Make sure you’re using Microsoft Office 2007 or later version. If not, you need to install the appropriate plug in. 

Please check the export to excel section in the site preferences form and make sure to set them as per your requirement.

https://help.acumatica.com/(W(6))/Help?ScreenId=ShowWiki&pageid=4859a849-af09-420d-a55b-93c72eabd553

Let us know the Acumatica version you’re using and attach the downloaded excel file to help you further.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 67 replies
  • December 28, 2023

Hi @MayomiRodrigo36 

I do have the latest versions of MS Office, so I don’t think that’s the problem there. 

I am currently running on Acumatica 2022 R2. 

Here are those export to excel settings: 

 

I’ve also attached a sample file that is read as not a valid excel document when entering directly into Power BI. 

Thanks for looking into this!


Forum|alt.badge.img

The reason for this issue can be because your excel is opening as a protected sheet at the beginning. Please try open the document > save it separately and try again to upload to Power BI


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 67 replies
  • December 29, 2023

@MayomiRodrigo36 

Yes, I have no problem opening it up in Power BI after saving the document first. I was wondering if there was a way to not have to save it. 

Because I’m wanting to export thousands of these Shop for Rates files like the one I shared, and I don’t want to open up each on individually to remove this “protected” format. 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2642 replies
  • January 19, 2024

Hi @bclark were you able to find a solution? Thank you!


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 67 replies
  • Answer
  • January 19, 2024

@Chris Hackett 

The solution I ended up going with was a customization project that put a “Download Zip File” on the Search in Files screen, where I could select the files I wanted to export in bulk in a zip file on my local computer. 

Then I ran a python script to open, convert, and save each file to a CSV, because the file type straight out of Acumatica was not a proper Excel format. 

Then I saved all these files in an Access DB. It works, but it took a lot of other steps. Thanks!


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2642 replies
  • January 20, 2024

Thank you for sharing your solution with the community @bclark!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings