Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Where this message comes from?
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01676330
Message ID:
01676365
Views:
36
I thought maybe the number of the rows in the resulting .xlsx matter. But no. I ran a test on my computer and my table has 6000+ records and they all well converted to the .xlsx file.

>I didn't know that .xlsx is a zip file. I will talk to the customer IT to see if I can ask them to disable the AV.
>
>I just did a test on the customer server. I filtered the resulting cursor to make it smaller (about 300 records); and no error. But as soon as I select the entire table (about 3500 records), problem. Maybe the size of the resulting .xlsx file makes a difference?!
>Thank you very much for your input.
>
>>I believe an .xlsx file is basically a ZIP file. So creating an .xlsx means Greg's tool is creating a ZIP.
>>
>>If you have a process that works at all customers except one, chances are it's something in that environment causing the issue, The customer should be willing to do some testing to address it, maybe in a sandboxed environment. Send their sysadmin a bottle of vodka :)
>>
>>You may have a workaround for now but there's no guarantee it will work in the future
>>
>>>I am using Greg Green's VFP tool that converts a cursor to an Excel. As far as I know it does not ZIP anything; just converts a cursor to the Excel.
>>>I can't disable AV because this happens on the customer server. And it happens with one specific customer.
>>>However, if split the cursor into 4 smaller ones ( about 1000 records) the conversion to XLSX goes without a problem. And resulting 4 small Excel files are fine.
>>>Thank you.
>>>
>>>>I believe current Office file formats are basically ZIP files. If you're creating an .xlsx maybe something is going wrong with the zipping process.
>>>>
>>>>Antivirus may be configured to scan zip files and may be interfering. You could test with antivirus real-time scanning temporarily disabled.
>>>>
>>>>>Please see the attached image of a messagebox. Anyone has ever seen it? Could it be coming from VFP 9 internals?
>>>>>
>>>>>I am getting this message when creating an Excel from a cursor. But I cannot figure where this message comes from.
>>>>>
>>>>>TIA
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform