OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Print Avery 5160 mailing labels from postgresql DB?[solved]

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
turtle
General User
General User


Joined: 05 Jun 2008
Posts: 8
Location: $hell

PostPosted: Wed Dec 17, 2008 10:08 pm    Post subject: Print Avery 5160 mailing labels from postgresql DB?[solved] Reply with quote

Sorry if this seems like a question begging RTFM.
I actually purchaced a printed manual and have read on line and am missing something obvious.
I have successfully connected to my Ledgersmb Postgres database. I added the database and can select it in the file > new > labels box.
I selected the table and got something like:
<Think-data-test.public.customer.0.name><Think-data-test.public.customer.0.address1>
<Think-data-test.public.customer.0.address2><Think-data-test.public.customer.0.city>
<Think-data-test.public.customer.0.state><Think-data-test.public.customer.0.zipcode
not sure what he .0. (like in between customer and name means)
is that record 0? I tryed editing the 0 the reflect 0 - 400
I can see the data if I select "explorer on" I have a label that basicly has:
<name>
<address1>
<address2>
<city>
<state>
<zipcode>

and thats it no data.

I have searched the new and these forums and read what I could find looked for a manual etc.
I know the driver is working because I corrected bad zip codes etc.
In addition it would be handy to make a rule based on another table
like customer.extras quotation customer = FALSE
So I dont send a holiday card to someone whom we did not actually work for.

Thanks in advance for any ideas!

EDIT
After starting over a few more times and looking closely at the label wizard I had to select the correct labels for sticking on cards which I tink are "Avery 5160" or a 1" x 2-5/8" generic address label.
Then
this as weird as it seems I go to tools > mail merge wizard.
Now I get the same customer on every sheet instead of 1 customer per label.
But I am part way to solved.

EDIT 2008-12-18: Well took a look at this guide: http://sheepdogguides.com/fdb/fdb1addrlab.htm
Helpful but is says
Quote:
Don't be alarmed when you see the sheet fill with many copies of one person's label.

that is wrong because openoffice started printing 331 sheets each full of labels to a customer.


Last edited by turtle on Thu Dec 18, 2008 7:08 pm; edited 2 times in total
Back to top
View user's profile Send private message Visit poster's website
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Thu Dec 18, 2008 8:03 am    Post subject: Reply with quote

Quote:
it seems I go to tools > mail merge wizard. Now I get the same customer on every sheet instead of 1 customer per label.
Open the file, click the Print icon and answer 'yes' to the 'form letter' query.
Back to top
View user's profile Send private message
turtle
General User
General User


Joined: 05 Jun 2008
Posts: 8
Location: $hell

PostPosted: Thu Dec 18, 2008 9:09 am    Post subject: Reply with quote

I tried that exactly.
file > print > "do you want to print a form letter?" > "yes" no and help are other options.
The form letter must assume I want 1 record per page. there are 30 records per page.
I have also been reading the manual
Back to top
View user's profile Send private message Visit poster's website
thomasjk
Super User
Super User


Joined: 16 Dec 2005
Posts: 2374

PostPosted: Thu Dec 18, 2008 9:55 am    Post subject: Reply with quote

Read this its much better than the help http://www.freesoftwaremagazine.com/articles/mail_merge_openoffice_org .
Back to top
View user's profile Send private message
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Thu Dec 18, 2008 11:02 am    Post subject: Reply with quote

If you actually printed (to paper or file) and got all the same record then I think you are missing the Next Record field. Read the article and try again.
Back to top
View user's profile Send private message
turtle
General User
General User


Joined: 05 Jun 2008
Posts: 8
Location: $hell

PostPosted: Thu Dec 18, 2008 12:23 pm    Post subject: Reply with quote

Thank you for your quick replies! Such good community here.
Yes that is very well written it gets into labels on page 3.
However I am following all the steps.

  • File→New→Labels to open the Labels dialog
  • Chose the appropriate labels under Format Avery 5160 (funny it is what he is using in the example)
  • “Synchronize Labels”. for any changes to the labels after the Labels dialog, make changes on the first label only, then click on the button. This will update all other labels to match the first label. ( am not changing anything until other stuff works )
  • File → Print "Your document contains data fields do you want to print a form letter?" → YES.
Back to top
View user's profile Send private message Visit poster's website
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Thu Dec 18, 2008 12:42 pm    Post subject: Reply with quote

If you are creating the label on the Labels tab of the wizard then the Next Record field will automatically be inserted. If you are creating the label after you click New Document then you need to insert it manually and Synchronize.

Open your label file, turn on View > Field Names. Do you have a Next Record field? Don't forget to turn of View > FN.
Back to top
View user's profile Send private message
turtle
General User
General User


Joined: 05 Jun 2008
Posts: 8
Location: $hell

PostPosted: Thu Dec 18, 2008 1:35 pm    Post subject: Reply with quote

JohnV wrote:
If you are creating the label on the Labels tab of the wizard then the Next Record field will automatically be inserted.


I am not sure what the wizard is that in the steps I described above?

It is making an entire sheet with the same record then tarting a new sheet with the next record.

What does the next record field look like or contain? I just have what I posted above.

Thanks again John you are sweet!

OK I figured it out:
→Insert → Feilds → "NextRecord" Then click "Insert"
Thanks you guys!
Back to top
View user's profile Send private message Visit poster's website
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Fri Dec 19, 2008 7:38 am    Post subject: Reply with quote

To answer your questions the Wizard is what you get when you do File > New > Labels, you exit the wizard when you click New Document. While you are in the wizard you can design your label on the Labels tab.

The Next Record field contains those word and should be the last field in the label. You can see it if you turn on View > Field Names (Ctrl+F9 toggles this). Don't forget to turn it off.

If you need to insert this manually then the full path is Insert > Fields > Other > Database tab.

Glad to see you got things working.
Back to top
View user's profile Send private message
turtle
General User
General User


Joined: 05 Jun 2008
Posts: 8
Location: $hell

PostPosted: Thu Dec 25, 2008 11:18 am    Post subject: Reply with quote

Two more very important things I ran into:

1) The template for the labels is wrong it is a known issue and you need to add 3 spaces before each field.

2) All the how-to's on suppressing empty fields are wrong.

What I did to get it to work was simple:

You do go to insert → section
Check → Hidden
Enter
Code:
address2 EQ ''

Done
Open office just wants the syntax: address2 EQ "" Not the path to the table.
Which makes since there is allot you can mess up in typing the path to the table. Also I found that inputing the "section" info wrong results in a corrupt file that will not print or crashes wile printing. 2.4 builds crash when deleting section info. This may be the sun JRE 1.6.11 I did not test it with older Java. If you get the section info wrong on 2.4 just start over.
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group