About    Download    Order    Support


InnPlanner Reservation Software Videos

About
Download
Order/Prices
Support/Contact
Partner Program
Press Room
Online Help


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

Operations with database

List of Actions

Operations with database


Open a Database
(DatabasePath)

Open the database in the DatabasePath. If the DatabasePath is not specified, the user will be suggested to specify the path to the database.


Create Backup Copy
(Path,FileMask, Rewrite )

Create a backup copy of the current database in the Path under the name FileMask. FileMask can contain current date or(and) time. If Rewrite equals "Always", then the specified file will be rewritten without notification.


Custom Export
(Template, Records)

Export data according to the selected template Template. If the Template parameter is not specified, a dialog with the list of all templates in the database will be displayed. The Records parameter indicates the source of exported records. 


Print Records
(ShowPrintPreview, Records, ReportStyle)

Print out the selected records. If the ShowPrintPreview parameter is specified, the preview window will be displayed before printing. Otherwise the printing process will start without notification. ReportStyle determines what report style will be used. Records determines the group of records to be used for the report.


Show Report
(Records, ReportStyle, WhatPart)

Show a window with report. ReportStyle determines what report style will be used. Records determines the group of records to be used for the report. WhatPart determines what part of report style will be used to show the report. For example, reports can be used to preview an image or to get a summary:




Import From web-page
(URL, ImportType, Connection)

Imports text from Web page at URL and sends it to the parsing system. ImportType specifies how the data is to be imported - including html tags or not. Connection defines the connection type to be used when importing data:

  • Direct - dedicated fast-speed connection; unfortunately, some websites can prohibit this connection type.
  • Web-Browser - the program simulates a Web browser and returns the page content as if it was viewed through a regular browser.

Example:

Import From web-page("http://www.google.ru/search?q=database","Text only","Web-Browser") - returns google search results for the term "database".


Import From a Database
(DatabasePath, ImportPreset, ShowPreview)

Import data from a Database with a different format (such as mdb or xls). DatabasePath is the path to the database from which records are to be imported. ImportPreset is the import template, ShowPreview defines whether the import dialog will be displayed. If the ShowPreview is not set, the importing process will start without notification. If the ShowPreview is set, the dialog for setting up importing parameters will be displayed. The dialog for setting up importing parameters will also be displayed if the DatabasePath or ImportPreset parameters are not specified.

RETURN VALUE: Returns number of records were imported.


Import from MS Outlook
(ForlderFrom, FolderTo, ParsingStyle, MailsToParse)

Import e-mails from the FolderFrom folder of an MS Outlook account. The imported messages are passed to a suitable parser for processing. The optional parameter FolderTo defines the folder of an MS Outlook account into which the imported records will be moved. The ParsingStyle parameter defines the way the messages will be handed to the parser: either all messages will be sent as a large text or each message should be transmitted separately. In the MailsToParse parameter you can specify the mask for subjects of messages you want to import. If you don't specify the mask, you'll have to select messages to be imported in a dialog box.

RETURN VALUE: Returns number of imported e-mails.


Export To a Database
(DatabasePath, ExportPreset, ShowPreview)

Export data to a Database with a different format (such as mdb or xls). DatabasePath is the path to the database to which records are to be exported. ExportPreset is the import template, ShowPreview defines whether the export dialog will be displayed. If the ShowPreview is not set, the exporting process will start without notification. If the ShowPreview is set, the dialog for setting up exporting parameters will be displayed. The dialog for setting up exporting parameters will also be displayed if the DatabasePath or ExportPreset parameters are not specified.

RETURN VALUE: Returns number of records were exported.


Export DB Operation
(Operation, Column, RecordType, Data)

Allows to work with a 3rd party Database, directly export and import any data. See the Exporting to 3rd part DB using script section for more details.

RETURN VALUE: Returns cell value.


Execute Query
(Query)

Execute query Query. If the Query parameter is not specified, a dialog with the list of all queries in the database will be displayed.

RETURN VALUE: Returns number of records found by query.


Share Database
(DbNetName, DbNetPass, UserName)

Make the current database available for using in a network. In the DbNetName parameter you should specify the netname of the database; the DbNetPass parameter specifies the password used to connect to the database, and the UserName parameter specifies the name of the user who works with the database as a server. See the Networking section for more details.

RETURN VALUE: Returns 1 if the database was shared, 0 otherwise.


See Also:

List of Actions




Today"s Poll

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

Do not use
Inn Planner
Access, Excel
ASSD
Auberge
Digitalrez
Easy Inn Keeping
EnSuite HR
GuestMaster
iMagic HR
Smart FX
Other