If I answer yes, then I get an error message that says, ' Unexpected token: in statement ' I'm asked if I want to create a primary key. However, when I attempt to drag tables from the connected file to the new OOo base I get one of two error messages.įirst, when attempting to copy I am old I need either a unique index or primary key to proceed. In order to use your own template in Billomat, navigate in the settings to Documents > Templates > Upload new template, where you can upload your template and then use it.I have tried Drew Jensen's method for importing data from an MS Access database into OOo base, but I'm having some difficulty. The beginning and the end of a block must be marked. To do this, 2 bookmarks are required for each block: One for the beginning of the block, one for its end. Now you can open the Billomat database and choose a placeholder from the various data record types.The Billomat database then appears in the database selection.Now the database file has to be added once. To do this, click on Searchand select the Billomat.ods file that you just downloaded.

From the Insertmenu, choose Field Command > Other . Then click on the Database tab.

Inserting placeholdersįirst, the database file with the Billomat placeholders must be downloaded and added to Writer. This database file is a simple Calc document in ODS format and contains all placeholders that can be used in Billomat.

Please always save OpenOffice templates in RTF format, otherwise the placeholders will not be recognized.ĪTTENTION: We do not recommend using, as the RTF export from is very faulty and processing errors can occur!Īlready knew? You can also create your own templates with Microsoft Word. If you can not do anything yet with the terms wildcards and blocks you read the relevant sections in the article best general information on own templates by.

Openoffice base templates