1 <?xml version="1.0" encoding="utf-8"?>
2 <page xmlns="http://projectmallard.org/1.0/" xmlns:e="http://projectmallard.org/experimental/" type="guide" id="merge-ex2" xml:lang="sl">
5 <link type="guide" xref="merge#merge-ex"/>
6 <revision pkgversion="3.0" version="0.1" date="2010-05-04" status="incomplete"/>
7 <desc>Ustvari nalepke z naslovi iz datoteke CSV.</desc>
10 <email>evins@snaught.com</email>
12 <credit type="author">
13 <name>Mario Blättermann</name>
14 <email>mariobl@gnome.org</email>
17 <p>Creative Commons Share Alike 3.0</p>
21 <title>Primer 2: nalepke naslovov</title>
23 <p>In this example we are going to throw a party and need to print mailing
24 address labels for our invitations. We have a list of our closest friends
25 that we created in <app>gnumeric</app> and exported as the
26 following CSV file. It should be noted that not everyone has a middle initial or
27 a two line address.</p>
30 LAST,FIRST,MI,ADDR1,ADDR2,CITY,STATE,ZIP
32 Critter,Ess,S,"123 Faux St.",,Alexandria,VA,22310
33 Doe,John,,"Apt 1X","451 Mystery St.",Trenton,NJ,08601
34 Summers,Joyce,,"1630 Revello Dr",,Sunnydale,CA,95037
35 McGarret,Steve,O,"404 Piikoi Street",,Honolulu,HI,96813
36 Kramer,Cosmo,,"Apt 5B","129 W. 81 St.","New York",NY,10024-7207
39 <p>In <app>glabels</app> we have created a new <app>glabels</app>
40 document using the Avery 5512 "Address Labels" template. Next we use the
41 <guiseq> <gui>Objects</gui>
42 <gui>Merge Properties</gui> </guiseq> menu item to display
43 the <gui>merge properties</gui> dialog. We use this dialog to
44 select the source type (in our case CSV with keys on line 1) and the merge
45 source (filename) as shown.</p>
47 <!-- ==== Figure ==== -->
48 <media type="image" src="figures/merge-ex2-1.png" mime="image/png" style="right">
49 <p>Merge properties dialog</p>
51 <!-- ==== End of Figure ==== -->
53 <p>Before applying the merge source, we uncheck the first record since it only
54 contains empty fields. It is an artifact of our original <app>gnumeric</app> spreadsheet
55 and would simply waste our first label. We could also unselect
56 any other records that we didn't want to print a label for.</p>
58 <p>We can also view each record in more detail by clicking on the appropriate
59 expander (the little triangles) as shown. Once we are satisfied with the
60 selections in this dialog we click <gui>OK</gui> to accept the
63 <p>Now we start adding objects to our <app>glabels</app> document as shown.</p>
65 <!-- ==== Figure ==== -->
66 <media type="image" src="figures/merge-ex2-2.png" mime="image/png" style="right">
67 <p>Dodajanje predmetov</p>
69 <!-- ==== End of Figure ==== -->
71 <p>In this example we have a single text object. This text object contains
72 all of our merge fields organized on multiple lines as a mailing address.
73 Notice that fields ${ADDR1} and ${ADDR2} are each
74 located with no other text on their own lines. When
75 <app>glabels</app> encounters a field as the only text on
76 a line, it will not expand the line if the field is empty.</p>
78 <p>Now we can print our address labels by selecting the
79 <guiseq> <gui>File</gui>
80 <gui>Print</gui> </guiseq> menu item. This will display
81 print dialog as shown below.</p>
83 <!-- ==== Figure ==== -->
84 <media type="image" src="figures/merge-ex2-3.png" mime="image/png" style="right">
85 <p>Tiskanje nalepk naslovov</p>
87 <!-- ==== End of Figure ==== -->
89 <p>Just to make sure our labels are going to look okay, we select the
90 <gui>Print outlines</gui> option and click
91 <gui>Print Preview</gui>. This will display a print preview dialog
94 <!-- ==== Figure ==== -->
95 <media type="image" src="figures/merge-ex2-4.png" mime="image/png" style="right">
96 <p>Predogled nalepk naslovov</p>
98 <!-- ==== End of Figure ==== -->
100 <p>Everything looks good, so we can now load up our printer with
101 the appropriate label stock, print our address labels and start mailing
102 our party invitations.</p>