The time now is Sat 21 Apr 2018, 08:14
All times are UTC - 4 |
Page 1 of 2 [17 Posts] |
Goto page: 1, 2 Next |
Author |
Message |
Monsie

Joined: 01 Dec 2011 Posts: 633 Location: Kamloops BC Canada
|
Posted: Tue 16 Jul 2013, 05:49 Post subject:
Address Labels Subject description: create a template in Gnumeric |
|
Hi all,
Sometimes the little things matter when using a distro... especially when it involves completing a simple task that helps one's productivity such as making address labels in bulk. In Debian, I use Glabels for this task, but given that it is a Gnome app, it will not run in Wary Puppy as there are too many missing dependencies....
So, I got to thinking about this and I wondered about using a spreadsheet as a template... whether it would work or not. After spending a couple of evenings on this, I found a way to do this in Gnumeric while using the Avery Mailing Labels #08160 These mailing labels come in Letter Sized sheets with 30 labels per sheet.
In a nutshell, the task involves creating a spreadsheet layout that matches the Mailing Labels Sheet. To do this, one must resize the necessary rows and columns to match the size of each label and take into account the spacing between the labels. To accomplish this, one must convert the dimensions of each row and column from inches or centimeters to pixels.
Briefly here is what I did:
--determined that my screen display is set at 84 dpi
--set the screen dpi in Gnumeric to the same value --> Preferences
--converted the column widths and row heights from inches to pixels
--adjusted the font size for the address labels in Gnumeric
--set the margins for printing in Page Setup in Gnumeric
--frequently checked the Print Preview and tweaked the values for each row, column and margin in the set up
-- made four or five test prints until I was satisfied with the result
--I placed the finished spreadsheet here: --> /usr/share/gnumeric/1.10.16/templates
As proof of concept, I am attaching my template as a working example. The template can be re-worked by resizing the cells, rows, and columns in it to match the dpi setting of one's monitor, as well as the particular Mailing Label Sheet. Unfortunately, there is no "template that fits all" and it might be just as easy to start from scratch...
Lastly, I want to say that I am not a spreadsheet wizard. There may be some further tweaks or improvements that can be done, and I will welcome helpful advice, input etc. My thoughts are that this project is a bit tedious, but quite do-able, However, if anyone wants more details, more information how to do this, then I will consider writing another post in depth.
Cheers,
Monsie
 |
Description |
Works with Avery Mailing Label Sheets #08160
|

Download |
Filename |
address labels.tar.gz |
Filesize |
2.44 KB |
Downloaded |
587 Time(s) |
_________________ My username is pronounced: "mun-see". Derived from my surname, it was my nickname throughout high school.
Last edited by Monsie on Wed 28 Aug 2013, 14:47; edited 1 time in total
|
Back to top
|
|
 |
musher0

Joined: 04 Jan 2009 Posts: 12074 Location: Gatineau (Qc), Canada
|
Posted: Tue 16 Jul 2013, 09:58 Post subject:
|
|
Hi, Monsie.
Mailing labels can indeed be very handy. Thanks.
muhser0
_________________ musher0
~~~~~~~~~~
"Logical entities must not be multiplied beyond necessity." | |
« Il ne faut pas multiplier les entités logiques sans nécessité. » (Ockham)
|
Back to top
|
|
 |
Monsie

Joined: 01 Dec 2011 Posts: 633 Location: Kamloops BC Canada
|
Posted: Wed 17 Jul 2013, 17:31 Post subject:
Address Labels |
|
Thanks, Musher0
and of course you are welcome...
I am hoping to hear from others who have tried my method to find out if it works for them given that their display is likely running at a different resolution overall.
I have also looked at the Avery website and found that one can also use their products with a Linux distro to create fancy address labels while on-line. To do this, one must have an account with Avery, and be running Adobe Flash on their website.
While it is great to have this option, personally, I like to be able to do things on my desktop independently --first and foremost.
Monsie
_________________ My username is pronounced: "mun-see". Derived from my surname, it was my nickname throughout high school.
|
Back to top
|
|
 |
musher0

Joined: 04 Jan 2009 Posts: 12074 Location: Gatineau (Qc), Canada
|
Posted: Wed 17 Jul 2013, 23:49 Post subject:
|
|
I just gave your idea a little push on the French forum! http://murga-linux.com/puppy/viewtopic.php?p=714197&sort=lastpost#714197 (That's our resources for micro-business thread.)
_________________ musher0
~~~~~~~~~~
"Logical entities must not be multiplied beyond necessity." | |
« Il ne faut pas multiplier les entités logiques sans nécessité. » (Ockham)
|
Back to top
|
|
 |
8-bit

Joined: 03 Apr 2007 Posts: 3425 Location: Oregon
|
Posted: Thu 18 Jul 2013, 17:49 Post subject:
|
|
Yet another way is to scan in a copy of of an existing mailing labels sheet and use it to print additional mailing labels.
I have did this and it works well.
|
Back to top
|
|
 |
Monsie

Joined: 01 Dec 2011 Posts: 633 Location: Kamloops BC Canada
|
Posted: Fri 19 Jul 2013, 03:35 Post subject:
Address Labels |
|
Merci beaucoup, musher0
J'ai oublié mes cours de français au secondaire... mais J'espère que ça marche pour eux.
Monsie
_________________ My username is pronounced: "mun-see". Derived from my surname, it was my nickname throughout high school.
|
Back to top
|
|
 |
Monsie

Joined: 01 Dec 2011 Posts: 633 Location: Kamloops BC Canada
|
Posted: Fri 19 Jul 2013, 03:46 Post subject:
Address Labels |
|
8-bit wrote: | Yet another way is to scan in a copy of of an existing mailing labels sheet and use it to print additional mailing labels.
I have did this and it works well. |
8-bit, that is an interesting solution... Do you mean that you scanned a blank mailing labels sheet and used that as a template, or did you scan an already filled in mailing labels sheet? Please explain further and in more detail...
Thanks,
Monsie
_________________ My username is pronounced: "mun-see". Derived from my surname, it was my nickname throughout high school.
|
Back to top
|
|
 |
8-bit

Joined: 03 Apr 2007 Posts: 3425 Location: Oregon
|
Posted: Sat 20 Jul 2013, 00:41 Post subject:
|
|
Using a mailing label program on another OS, I printed a page of labels that had the fields filled in.
I then scanned that sheet of labels in and used it to print more using a word processing program and setting top, bottom, left, right, header, and footer margins appropriately.
I would then print out to a blank page, not mailing label page and compare that for fine tuning.
I also did this with pin feed single roll mailing labels.
|
Back to top
|
|
 |
Monsie

Joined: 01 Dec 2011 Posts: 633 Location: Kamloops BC Canada
|
Posted: Sat 20 Jul 2013, 02:48 Post subject:
Address Labels |
|
8-bit wrote: | Using a mailing label program on another OS, I printed a page of labels that had the fields filled in.
I then scanned that sheet of labels in and used it to print more using a word processing program and setting top, bottom, left, right, header, and footer margins appropriately.
I would then print out to a blank page, not mailing label page and compare that for fine tuning.
I also did this with pin feed single roll mailing labels. |
I am trying to think of a scenario where this could be useful... If for example, a mailing labels sheet was originally created by someone else who was using Microsoft Works or Microsoft Office, maybe I could import a scanned image of a printed mailing labels sheet into OpenOffice and make a template of that. This could address --pardon the pun-- possible problems with file compatibility if I were to use the original Microsoft file (that created the mailing address labels) in OpenOffice and try to print from that...
While there is definitely better compatibility between Microsoft Office and OpenOffice nowadays, I suppose there are still some glitches that come up...
Thanks for your feedback,
Monsie
_________________ My username is pronounced: "mun-see". Derived from my surname, it was my nickname throughout high school.
|
Back to top
|
|
 |
Monsie

Joined: 01 Dec 2011 Posts: 633 Location: Kamloops BC Canada
|
Posted: Sun 21 Jul 2013, 03:23 Post subject:
Address Labels |
|
Hi all,
Here's an update:
After doing some more research regarding templates, I found another solution for printing address labels... It turns out there is a website dedicated to creating and printing labels of all sorts: http://www.worldlabel.com/Pages/template_1.htm
I managed to find an OpenOffice template for the Avery Mailing Labels sheet #08160 and after downloading it, I discovered that it will indeed open in abiword. So, I created a set of address labels, ran a test print and found the result was fine.
Once again, this was a very useful solution for me, because given my old Pentium lll system, I don't have sufficient ram to run OpenOffice 3x where I could otherwise complete this task.
I suspect this will prove to be a useful solution for some other Puppy Linux users also...
Cheers,
Monsie
_________________ My username is pronounced: "mun-see". Derived from my surname, it was my nickname throughout high school.
|
Back to top
|
|
 |
tallboy

Joined: 21 Sep 2010 Posts: 907 Location: Oslo, Norway
|
Posted: Sun 21 Jul 2013, 20:35 Post subject:
|
|
Thank you very much, Monsie!
I downloaded the complete European/Asian label package for A4, and got all US labels thrown in too! Excellent!
Quote: | ...because given my old Pentium lll system, I don't have sufficient ram to run OpenOffice 3x... |
(deep sigh) Takes me back to good old times with my 17Mb RAM Mac IIsi, with the Claris Works office package, that took up a whopping 692 kb installed, and printed lables all day if you wanted it to!
tallboy
_________________ True freedom is a live Puppy on a multisession CD/DVD.
|
Back to top
|
|
 |
RSH

Joined: 05 Sep 2011 Posts: 2420 Location: Germany
|
Posted: Tue 27 Aug 2013, 04:03 Post subject:
|
|
Monsie wrote: | In Debian, I use Glabels for this task, but given that it is a Gnome app, it will not run in Puppy as there are too many missing dependencies.... |
Description |
|
Filesize |
51.73 KB |
Viewed |
536 Time(s) |

|
_________________ LazY Puppy
RSH's DNA
SARA B.
|
Back to top
|
|
 |
Monsie

Joined: 01 Dec 2011 Posts: 633 Location: Kamloops BC Canada
|
Posted: Tue 27 Aug 2013, 06:31 Post subject:
Address Labels |
|
RSH,
I stand corrected... I should edit my post to state that I have never been able to run glabels in Wary Puppy... but I am not the only one who has had difficulty with getting glabels to work with Puppy: http://www.murga-linux.com/puppy/viewtopic.php?t=70454&search_id=124180148&sid=ca95a78ff23bf5ec7d2566de9715f99a
While it has been packaged for a few versions of Puppy, note that some users have had issues with how well this application works: http://www.murga-linux.com/puppy/viewtopic.php?t=63387&search_id=124180148&sid=ca95a78ff23bf5ec7d2566de9715f99a
Are you interested in explaining how you managed to package and install glabels for Lazy Puppy, and, do you plan on sharing this application with the Community?
I am fairly sure there are some users who would be willing to test this application to see if it installs in their breed of Puppy and to find out whether it works better now...
Monsie
_________________ My username is pronounced: "mun-see". Derived from my surname, it was my nickname throughout high school.
|
Back to top
|
|
 |
RSH

Joined: 05 Sep 2011 Posts: 2420 Location: Germany
|
Posted: Tue 27 Aug 2013, 15:44 Post subject:
|
|
Hi.
Monsie wrote: | Are you interested in explaining how you managed to package and install glabels for Lazy Puppy, and, do you plan on sharing this application with the Community? |
I don't use .pet packages - only .sfs modules.
I can't remember where I did get the package from, but I'm sure it has been a .pet package in original.
Usually I do extract a .pet package to have a look into its pinstall.sh script (if there is any). After this I do some work needed to get the things from the pinstall.sh script done - if needed (mostly it is not). Also I'm editing the .desktop file/s for German Menu Entry, Icon etc.pp.
Then I do re-create the package, installing it (I don't use any save file so, I can do what I want without any risk!) and trying to run the application - if it doesn't run immediately I check for missing libraries etc. until the application runs (therefor I do copy all new files manually into the OS and also into the directory of the extracted package). When successful, I do re-create the package again and building a .sfs module out of this re-created package (I can do this just by right-click action, which builds me the .sfs module completely including creation of a RunScript).
After this I do a reboot and try to run the application by the created RunScript, which loads first the .sfs module automatically and executes the application immediately after loading the .sfs module. If it works then, it will go into my repository at smokey01.com/RSH/ (there are hundreds of .sfs modules to download).
The LP2_GLabels2281.sfs module is here.
_________________ LazY Puppy
RSH's DNA
SARA B.
|
Back to top
|
|
 |
Monsie

Joined: 01 Dec 2011 Posts: 633 Location: Kamloops BC Canada
|
Posted: Wed 28 Aug 2013, 04:31 Post subject:
Address Labels |
|
Hi RSH,
Thanks for sharing... So I loaded your sfs package and did some testing. Unfortunately, it will not run in Wary Puppy because Wary is assembled with glibc 2.10 whereas your version of glabels requires glibc 2.11 or greater.
Code: | /usr/bin# ldd which glabels |grep libc
libc.so.6 => /lib/libc.so.6 (0xb75dd000)....
... ./glabels: /lib/libc.so.6: version `GLIBC_2.11' not found (required by /usr/lib/libedataserver-1.2.so.11) |
So unless there is an earlier version that I could compile from source, running glabels in Wary Puppy is a non-starter... not to mention that there are also numerous dependencies which Wary does not have: libgnomeui, libgnome, libkrb5, libgconf, libbonobo, etc. etc. --you get the idea.
I did check Precise Puppy though, and it has glibc 2.15 and many of those needed libraries that I listed above, so probably glabels will run on the latest Puppies providing all dependencies are met... so hopefully others will try out your package and find it works for them.
That said, given my old computer, I am happy that I can create address labels using either abiword or gnumeric because I don't need any additional resources to do so. Since I am challenged by limited ram, limited storage, and a slow system, my priority must be to run as lean as possible.
Cheers,
Monsie
_________________ My username is pronounced: "mun-see". Derived from my surname, it was my nickname throughout high school.
|
Back to top
|
|
 |
|
Page 1 of 2 [17 Posts] |
Goto page: 1, 2 Next |
|
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 You cannot attach files in this forum You can download files in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|