Project

General

Profile

PrintPublisherDev » History » Version 5

Katja Luther, 07/13/2016 11:09 AM

1 1 Niels Hoffmann
2 1 Niels Hoffmann
3 1 Niels Hoffmann
4 1 Niels Hoffmann
5 3 Katja Luther
# Print Publication with MS Access and MS Word
6 1 Niels Hoffmann
7 1 Niels Hoffmann
8 1 Niels Hoffmann
{{>toc}}
9 1 Niels Hoffmann
10 1 Niels Hoffmann
11 1 Niels Hoffmann
12 1 Niels Hoffmann
13 1 Niels Hoffmann
----
14 3 Katja Luther
15 3 Katja Luther
For the print publication you need the Access DB PrintOutputCaryophyllales and the Word template PrintoutputMakros.dotm.
16 3 Katja Luther
17 3 Katja Luther
if you want to create print publications regularly you can copy the template to C:\Dokumente und Einstellungen\{username}\Anwendungsdaten\Microsoft\Word\STARTUP\, otherwise you load the template after opening word.
18 3 Katja Luther
19 3 Katja Luther
20 3 Katja Luther
To get the data for the print-publication you have to export a csv file. Therefore go to "File" -> "Export" -> "CDM" then click >"CSV_PRINT"
21 3 Katja Luther
22 3 Katja Luther
Please choose a classification and a directory to save the csv file.
23 3 Katja Luther
24 3 Katja Luther
25 3 Katja Luther
The csv file has to be imported to the MS Access DB. Therefore we provide a pre-defined specification. Click on the table Caryo_test with right click and choose "Import" then choose "text import".
26 3 Katja Luther
27 3 Katja Luther
After selecting the file, an import assistent starts, here you can choose the specification.
28 3 Katja Luther
29 3 Katja Luther
30 3 Katja Luther
[!textimport_assistentpng!|!import_with_specification.png!]
31 3 Katja Luther
32 3 Katja Luther
33 3 Katja Luther
After the selection of the specification you will get a warning that the fieldnames contain invalid characters, this is only because of the order of the steps for the import of the table. At the end everything works fine.
34 3 Katja Luther
35 3 Katja Luther
36 3 Katja Luther
The next step is to export the report CaryophyllalesSpecies if you want to create a report of all families, genera and below, if you want to export only the genera, use the CaryophyllalesGenera report.
37 3 Katja Luther
38 3 Katja Luther
Please do a right click on the report and choose "Export" -> Textfile.
39 3 Katja Luther
40 3 Katja Luther
41 3 Katja Luther
This export creates a txt file with all relevant format information. Open this txt file in Word and load the template:
42 3 Katja Luther
43 3 Katja Luther
44 3 Katja Luther
Go to File-> Options, then choose Add-ins, then choose in the pull-down "Word-Add-ins" and add the PrintoutputMakros.dotm to the templates.
45 3 Katja Luther
46 5 Katja Luther
[!add_templatepng!|!load_template2.png!]
47 3 Katja Luther
48 3 Katja Luther
49 3 Katja Luther
If the word template is correctly loaded there should be two new buttons in your menu bar:
50 3 Katja Luther
51 4 Katja Luther
![](makros.png)
52 3 Katja Luther
53 3 Katja Luther
If you want to format your output in willdenowia format, click on format willdenowia, or if you want to format it more like the publication of the cuba checklist then choose format Cuba.
Add picture from clipboard (Maximum size: 40 MB)