Project

General

Profile

PrintPublisherDev » History » Version 9

Walter Berendsohn, 07/20/2016 09:39 AM

1 1 Niels Hoffmann
2
3
4
5 3 Katja Luther
# Print Publication with MS Access and MS Word
6 1 Niels Hoffmann
7
8
{{>toc}}
9
10
11
12
13
----
14 3 Katja Luther
15 9 Walter Berendsohn
For the print publication you need the MS-Access database CDM2Word.accdb and the Word template PrintoutputMakros.dotm. The most recent versions are available under http://cybertaxonomy.eu/download/platform/Output.zip.
16 1 Niels Hoffmann
17 9 Walter Berendsohn
18
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.
19 3 Katja Luther
20
21
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"
22
23
Please choose a classification and a directory to save the csv file.
24
25
26
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".
27
28
After selecting the file, an import assistent starts, here you can choose the specification.
29
30
31 7 Katja Luther
[!textimport_assistentpng!|!import_with_specification.png!]
32 3 Katja Luther
33
34
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.
35
36
37
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.
38
39
Please do a right click on the report and choose "Export" -> Textfile.
40
41
42
This export creates a txt file with all relevant format information. Open this txt file in Word and load the template:
43
44
45
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.
46
47 6 Katja Luther
[!add_templatePNG!|!load_template2.PNG!]
48 3 Katja Luther
49
50
If the word template is correctly loaded there should be two new buttons in your menu bar:
51
52 8 Katja Luther
53 4 Katja Luther
![](makros.png)
54 3 Katja Luther
55
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.