Hello to All,
First, thanks to everyone that has chimed in to help, I'm not used
to receiving the number of quality replies that you folks have
offered. What a wonderful forum.
Since I was overwhelmed with responses, I'm trying to respond to all
in this one post. I believe that I have the problem solved, or at
least moved further down the road.
When I initiate the print command, LO asks if I want to print a form
letter. Responding with "Yes" brings up and error message that "The
Data Source could not be found", hence I stopped and tried to figure
out where the connection problem was. It appears though that it did
indeed did find the source. Andreas mentioned to press F4, and when
doing so there was my data, though LO thinks that it is header info
so I will need to re-configure to either tell LO there is no header
data, or have FM export header data.
It would be helpful if the entry in the "Guide" would mention that
the path to the data actually goes to the folder that contains the
data rather then the actual data file.
Also, I am intrigued by the possibly of setting this up with an OBDC
as the data source and eliminating the text file all together. Even
though I am very limited in my knowledge in this area, this sounds
like something worth trying.
Thanks again to each of you!!!
Charles
On 6/24/2012 9:17 AM, Andreas Säger
[via Document Foundation Mail Archive] wrote:
Dan Lewis
wrote
Have you opened the file you
exported from Filemaker using a text
editor? This should tell you what the structure is and what
separators
you need to use.
Exactly. In the end it is just text with a certain structure and
nothing magic.
When the
wizard asks what the file to use, it only wants to know
what folder contains the file. It will then open all the
text files in
that folder. This is why any text data sources should have
their
separate folder.
As Alex mentioned, you should also look at the
file's
extension.
If the file has the correct structure, renaming the file
extension to
.csv might help.
--Dan
This is because the wizard does exactly the same as you can do
manually when you connect a Base document with a folder of
similarly structured text files. Therefore it asks for the exact
same information. Folder name, file name extension (.csv, .tsv,
.txt, .anything), separators (comma, semicolon, tabs, whatever).
Once you've done that your folder of text files is a data source,
a repository of tabuar data.
Nevertheless, if the exporting Filemaker database resides in the
same network you may ask the person who exports the text files if
he can set up an ODBC data source. Then you could read from the
database without any text file import nor export. You (or the
"wizard") simply connect a Base document to a named ODBC source
and always use the current database data instead of data copies in
text files which may be out of date.
If you reply to this email, your
message will be added to the discussion below:
http://nabble.documentfoundation.org/Need-Help-Setting-Up-Mail-Merge-tp3991923p3991964.html
To unsubscribe from Need Help Setting Up Mail Merge, click
here .
NAML
--
View this message in context:
http://nabble.documentfoundation.org/Need-Help-Setting-Up-Mail-Merge-tp3991923p3991978.html
Sent from the Users mailing list archive at Nabble.com.
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
