NetTalk Central

Author Topic: Export to Excel - The file is corrupt and cannot be opened  (Read 4739 times)

terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
Export to Excel - The file is corrupt and cannot be opened
« on: July 21, 2015, 11:11:18 PM »
I am testing a small browse (browse.jpg)
If  I do an export of the whole browse I get the message above when opening in Excel
So I tested each record individually
All the records exports open in Excel except the record D00813 which has the error.
Attached are  2 xml files one generated by a successful open, the other an unsuccessful open.
Looking at the BusinessPartnerFail.xml file in notepad I cannot see anything in the file that could cause this.

 Any ideas?

[attachment deleted by admin]
Terry Davidson
Windows 10 64 bit/Windows7 64bit
Clarion 9.1.11529/Clarion10 12567
Nettalk 913
Nettalk 1015
StringTheory267/Winevent515/XFiles298/MessageBox239/Cryptonite186

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Export to Excel - The file is corrupt and cannot be opened
« Reply #1 on: July 21, 2015, 11:47:16 PM »
I've sent you an updated xfiles.clw to try. Let me know if it works and I'll make a build for general release.

cheers
Bruce

terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
Re: Export to Excel - The file is corrupt and cannot be opened
« Reply #2 on: July 22, 2015, 12:08:28 AM »
Hi Bruce
Yes that worked.
Terry Davidson
Windows 10 64 bit/Windows7 64bit
Clarion 9.1.11529/Clarion10 12567
Nettalk 913
Nettalk 1015
StringTheory267/Winevent515/XFiles298/MessageBox239/Cryptonite186

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Export to Excel - The file is corrupt and cannot be opened
« Reply #3 on: July 22, 2015, 03:19:31 AM »
cool, build is up.

terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
Re: Export to Excel - The file is corrupt and cannot be opened
« Reply #4 on: July 26, 2015, 12:40:02 AM »
Hi Bruce
I installed build xfiles 2.69
I found during my testing over the weekend that the same problem occurred.
I reverted to the xfiles.clw that you sent me by email and the problem disappeared.
Terry Davidson
Windows 10 64 bit/Windows7 64bit
Clarion 9.1.11529/Clarion10 12567
Nettalk 913
Nettalk 1015
StringTheory267/Winevent515/XFiles298/MessageBox239/Cryptonite186

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Export to Excel - The file is corrupt and cannot be opened
« Reply #5 on: July 27, 2015, 01:49:31 AM »
I'm not able to duplicate the problem with 2.69 Terry - maybe you can help with an example?

terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
Re: Export to Excel - The file is corrupt and cannot be opened
« Reply #6 on: July 27, 2015, 02:43:51 AM »
Hi Bruce
Not sure if this will help.
XfilesA.clw is the clw which had the original problem
XfilesB.clw is the clw installed with Xfiles269
Xfiles.clw is the file you emailed me and which I have replaced in the accessory\libsrc \win folder and which does not generate the error.

The XfilesB.clw and Xfiles.clw have different sizes
In the attached images winmerge found 2 sets of differences although one just looks like a positioning issue
The list on the left is the xfiles.clw that I am currently using.
If this doesn't help I will reinstall the 269 version and try to find a record that causes the issue.

[attachment deleted by admin]
« Last Edit: July 27, 2015, 02:58:31 AM by terryd »
Terry Davidson
Windows 10 64 bit/Windows7 64bit
Clarion 9.1.11529/Clarion10 12567
Nettalk 913
Nettalk 1015
StringTheory267/Winevent515/XFiles298/MessageBox239/Cryptonite186

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Export to Excel - The file is corrupt and cannot be opened
« Reply #7 on: July 28, 2015, 12:45:07 AM »
Hi Terry,

I think the best would be an example of a browse, and data, which shows the effect. I've got the other files, but in my tests here with columns I'm not seeing the effect you are reporting.

cheers
Bruce