Re: [libreoffice-users] How to Link LibreOffice Writer Labels to Database

On 09/16/2014 05:05 AM, Tom Davies wrote:
> Hi :)
> The Base Handbook might be able to help with this
> https://wiki.documentfoundation.org/Documentation/Publications
>
> First it is worth quickly skimming through the "Getting Started" 
> guide's chapter on Base.
>
> There is also an Faq that might lead you through something very similar
> https://wiki.documentfoundation.org/Faq
>
> It is generally better to base such "reports" or "forms" off Queries 
> rather directly off Tables.  It makes the system more flexible for the 
> future as it allows changes in the underlaying Table to be abstracted 
> away so that the Form/Report can still get the same inputs that it 
> expects.
> Regards from
> Tom :)
>
>
>
> On 16 September 2014 08:42, L. D. James <ljames@apollo3.com 
> <mailto:ljames@apollo3.com>> wrote:
>
>     Can someone tell me how to link Libreoffice Writer to a
>     LibreOffice Base
>     Database so that opening the saved label file will automatically
>     bring up
>     any changes that has been made to the database without any prompts.
>
>     At present I either see a way to bring up a saved mail merge file
>     that will
>     bring up the same data (old if the database has changed), or will
>     bring up
>     the pre-merged file that needs to have the sequence to use the
>     mailmerge
>     tool to update the information.
>
>     These are the current steps I have to do to see or print the new data:
>
>     Click on Merge file -> Answer the prompt to get the most recent
>     data  (now I
>     have one page of the first record) -> Click Tools -> Mail Merge
>     Wizard ->
>     Next -> Next -> Next -> Next -> Next -> Next -> (click) Save starting
>     document -> Finish
>
>     Now I have the updated data.
>
>     I'm hoping to have a way to save a file where one click on the
>     file will
>     bring up the updated data without any prompts.
>
>     Thanks in advance for any input on this.

Thanks for the links, TomD.

I had done a lot of research and reading the FAQ before posting my 
message.  It might be possible that what I was trying to do can't be 
done (a one click to bring the fresh data to a labeling merge).

I put the objective in to words the best way I could.  There is a chance 
I might not be describing it the best way.  I was hoping someone in the 
community might understand the question well enough to maybe assist me 
in clarification as well as how to do it if it could be done, or some 
close workaround.

I really don't have any problems with the 6 to 10 clicks to print a new 
list.  I was mainly trying to make it easy for office workers with 
little computer and data skills to perform a single click and have the 
new data and print a new labels.

As you suggested I'll study closer the features of LibreOffice Base for 
setting up the objective in forms.  I already undestand that it can be 
done that way.  But again, I was looking for a way to perform this in 
LibreOffice Word because I wanted to use the same feature for using 
linked fields in other databases such as mysql.


If I learn of a better way to clarify this task, I'll update the thread.

Thanks again for the input, as well as input from anyone else that might 
have some insight on this.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

--
To unsubscribe e-mail to: users+unsubscribe@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