>I have a website that collects files from clients and translates them into a format for our UNIX server. I was just handed an ods file for the first time today. I can open with Excel 2010, but VFP doesn't seem to have any knowledge of this file type, which makes sense due to it's age.
>
>Is there a third party add-on that will allow me to translate ods to a vfp cursor for processing? I don't think Office is installed and I've never tried automation of open office. Or is it time for a custom .NET dll call from VFP? I would love advice from anyone who's tried this so I don't go down a bunch of dead-ends.
>
>Thanks!
You might want to batch convert your .ods files before vfp looks at them:
PyODConverter:
http://www.oooninja.com/2008/02/batch-command-line-file-conversion-with.htmlPyODConverter supports all of the formats that you can import or export manually in OpenOffice.org. They include:
* odt OpenDocument (ODF) Text
* sxw OpenOffice.org version 1 Text
* doc Microsoft Word 97/2000/XP
* rtf Rich Text Format
* txt Plain text
* wpd WordPerfect
* html Web page
* ods OpenDocument (ODF) Spreadsheet
* sxc OpenOffice.org version 1 Spreadsheet
* xls Microsoft Excel 97/2000/XP
* odp OpenDocument (ODF) Presentation
* sxi OpenOffice.org version 1 Presentation
* ppt Microsoft PowerPoint 97/2000/XP
* swf Adobe Flash
or jodconverter:
http://www.artofsolving.com/opensource/jodconverter
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"