Re: [tdf-discuss] Macro Difficulties
Hi Charles, *,
On Wed, Mar 13, 2013 at 4:36 PM, Charles Jenkins <firstname.lastname@example.org> wrote:
You're right. My attempt to fool with options didn't work at first because I misidentified the
file's character set, so I thought the "csv" in the filter name was significant and embarked on
the quest to convert to CSV.
Ah, OK :-) - teh csv filter is used synonymous for all character
separated values, not specific to a comma, although that is the most
used ones. One could argue whether tsv deserves a special mention or
not, but you don't add hsv (hyphen separated) or all other kinds of
Now that I have the right character set, everything works perfectly!!!
I have put up a post on SAP's community network site to let others know it's possible to export
from Business One to LibreOffice; hopefully it will help the switchers out there. I start my post
off by publicly thanking you and Eduardo.
Great to hear that it works, and of course thanks for sharing your
findings with others!
If you'd like to see the post, it's at: http://scn.sap.com/thread/3325286
Allow me some nitpicking :-)
Public Sub StarOpenTsvFile(tsvPath As String)
Dim starDesktop As Object
Dim url As String
Dim doc As Object
Dim parms(1) As New com.sun.star.beans.PropertyValue
parms(0).Name = "FilterName"
parms(0).Value = "Text - txt - csv (StarCalc)" ' Name is incorrect, but required
The name is of course correct, as that is what the filter is called.
It is for text based ("Text") Spreadsheets ("StarCalc"), most commonly
with txt and csv extensions. It is not limited to comma separated
files. I prefer to read csv as character separated, as that matches it
much better, as multiple delimers, or also no delimter at all (when
using fixed-width columns) can be used.
It doesn't explicitly list tsv or other possible filename extensions though.
parms(1).Name = "FilterOptions"
parms(1).Value = "9,,65535,1" ' Tab seps, no string delim, UTF-16 charset, begin at line 1
having a pointer to documentation for these kind of "magic strings" is
always nice to have :-)
Otherwise: Thanks again for sharing the solution - too often one does
just read "Solved my problem, bye" and doesn't get to know what the
actual solution was, so thumbs up :-)
Unsubscribe instructions: E-mail to email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.documentfoundation.org/www/discuss/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy