NetTalk Central
Toggle navigation
Login
Register
×
Welcome,Guest
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
NetTalk Central
»
NetTalk Web Server
»
Web Server - Ask For Help
»
Export to Excel - The file is corrupt and cannot be opened
« previous
next »
Print
Pages: [
1
]
Author
Topic: Export to Excel - The file is corrupt and cannot be opened (Read 4737 times)
terryd
Hero Member
Posts: 759
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]
Logged
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
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
Logged
terryd
Hero Member
Posts: 759
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.
Logged
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
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.
Logged
terryd
Hero Member
Posts: 759
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.
Logged
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
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?
Logged
terryd
Hero Member
Posts: 759
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
»
Logged
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
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
Logged
Print
Pages: [
1
]
« previous
next »
NetTalk Central
»
NetTalk Web Server
»
Web Server - Ask For Help
»
Export to Excel - The file is corrupt and cannot be opened