How to create Labels ready to print?

VIEW THE VIDEO

1. Export data from Darwin

Do not use the export option available on the bottom of the Search form
Save first your research in DarWIN
Go to "My Preferences" menu
Select "Saved Search"
Click on "get reports" option for the saved search corresponding to your labels in order to get the full export of data for the selected specimens.

2. Open export file in Notepad/Notepad++

3. Download the template worksheet

4. Copy data in “RAW-DARWIN” worksheet

Libre Office Calc Options has to be modified to allow macro to run (to do once)
Go to macro security setting in Tools - Options - LibreOffice - Security
Select the medium option + OK + OK

Column titles have to be pasted too. Otherwise the program won’t work. You can copy data from different exports if needed.

When you are ready, you can choose which format you wish to create by clicking on the corresponding button below.

Each format is visible on the example worksheet with the corresponding name followed by “TEMPLATE”. These worksheets are protected from edition.

5. Create labels

Click on one of the buttons below, depending on the format. A new worksheet will be created, with your labels formated.

You can edit each label in this worksheet if needed (example: abbreviate too long names or comments, adapt font size, etc.)

Screen will update, let the program work until you see a message “Done!”