About    Download    Order    Support

Recent News

InnPlanner 2010 Released New faster database engine, more customization features, weekly tariffs, full multi-user work support and much more... 2010 Feb 10

InnPlanner 2010 RC1 InnPlanner 2010 Release Candidate 1 is ready for downloading and testing. You can download it from the "Downloads" section. 2010 Jan 14

Hotel Software Documentation

Custom Export Editor

Custom Export was introduced in the fourth version instead of the HTML/Txt Output Editor used in the third version. Now it allows you not only to create and use templates for exporting data to web pages and text files, but also to integrate your database with other applications.

In the current version you can use Custom Export to configure and automate the following operations:

• exporting data to a text file;
• generating a web page;
• creating and sending messages directly from your database using an external e-mail client (Outlook Express, The Bat, etc). More details...
• copying data from your database onto the Windows clipboard to insert it into any applicaton later on;
• inserting data from your database into an open Microsoft Word document or generating MS Word documents automatically based on the database data.

Location

Use the menu command Designer->Edit Custom Export Templates... to edit Custom Export Templates.

Use the menu command File->Import/Export->Custom Export... to export data using the created templates.

To make the export operation available with one mouse click or a key combination, see the ToolBar Editor and Script Designer sections.

 Introduction

Like with the Report Style Template, a Custom Export template can be described as a set of areas each being the constitute of the output document. For example, the template "Multiple records in one text file" includes the following areas:

• Start Part will be included at the beginning of the output file;
• Record Data Part is used to place the output data from the exported records. Inserted once for each exported record in the middle of the exported file;
• End Part will be included at the end of the output file.

To direct the field of exported records to the output area, type their names with [] brackets: [Field Name]. You can also use the quick-insert buttons (3) to insert fields, variables or mathematical formulas. (see below).

Thus, if areas are given the following values:

the output could be something like this:

You can also use special tags and format to custumize output.

Custom Export Editor Interface

• 1 - Lists of templates to select for editing. Using the last item of this list you can also sort your templates;
• 2 - List of areas. Used to select the area for editing;
• 3 - Quick insert and format buttons to insert fields, vars or formulas. For more information please, see Text Formulas help topic.
• 4 - Templates management buttons. Used to modify template properties, create new template or delete an existing template;
• 5 - Area editor. Used to edit the current area.

Click the Preview button to see how the output file has been created using the active template.

You can specify Edit Custom Export Area action to open only one area for quick edit. It's convinient if you have to modify one of the template areas often.

Template Properties

To open the Template Properties window, click the Modify Properties... button (4):

Other options can vary depending on the type of the selected template:

• Template Name. Specify the name of the template used to identify the template;
• Output file(s) extension. Specify the extension of the output file(s);
• Replace the "Return" tag with. You have an option to replace the line break tag with any other in the exported file. This option is especially useful when exporting to HTML files;
• Replace HTML tags. If checked, special HTML tags ("<", ">" etc.) will be replaced with their HTML equivalents (&lt; &quot; &gt; etc).
• Export data to the active MS Word Document - if this option is enabled and there is an opened MS Word document, the data will be exported to it, beginning from the current cursor position.
  

Two export methods

Virtually for all template types (HTML, Text, MS Word, E-mail) there are two export methods:

1. Export records separately. In this case each record will be exported independent from others. It means that you can get the following as a result:

• separate web pages
• separate text files
• separate Word documents or e-mail messages for each record

2. Export records all together. In this case the main template area is divided into three areas: Begin, Record Data, End, (see an example in the Introduction section) and all records will be exported into one place. It means that you can get the following as a result:

• one web page;
• one text file;
• one MS Word file or all records inserted into the active document
• data from all records sent in one message.

See Also:

Mailing

Custom Export Tags

Variables

Text Formulas

Today"s Poll

What software do use for your inn/b&b/hotel/etc?

Home Page | Contacs | Terms and Conditions

Copyright (C) 2001-2010 Binary Brilliant Inc