[libreoffice-users] Re: Need Help Setting Up Mail Merge

    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