O$ 10.0 Export to file on windows is unicode
pmulroney at logicaldevelopments.com.au
Thu May 27 01:32:09 UTC 2021
I've got a weird one. I'm exporting a file to disk, and then later it's being downloaded in the jsClient. When I'm testing on my mac, it downloads the tab-delimited file as ASCII UTF-8, no problems. Run the same in production on windows server, and it's downloaded as UTF-8 with BOM. This causes problems when I try to open the file in Excel. The file also has CR/LF when exporting from a windows platform, and only a CR when exporting from the Mac.
Can I make it so that it always exports with CR/LF, regardless of platform?
It's running a multi-threaded server, I'm wondering if that's causing a problem with the unicode export?
Here's the code in the startup task:
> Do $root.$prefs.$exportencoding.$assign(kUniTypeUTF8) ## Export as UTF-8 (ie ASCII)
> Do $root.$prefs.$exportbom.$assign(kFalse) ## Turn off export Byte Order Marker in the export file.
Here's the basic code that generates the export file.
> Set print or export file name [vsPathName]
> Prepare for export to file Delimited (tabs)
> Export data vlExport
> End export
> Close print or export file
What am I missing?
An invisible man married an invisible woman. The kids were nothing to look at either.
Paul W. Mulroney We Don't Do Simple Pty Ltd
pmulroney at logicaldevelopments.com.au Trading as Logical Developments
www.logicaldevelopments.com.au ACN 161 009 374
Ph: +61 8 9458 3889 86 Coolgardie Street
BENTLEY WA 6102
More information about the omnisdev-en