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: users+help@global.libreoffice.org
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
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: 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.