GhostFill Database Connections


Application An Application is a common storage area for all Lists, Clauses, Dialogs, databases, Profiles, Scripts, documents, and templates that have been specifically created to work together. It is useful to group these elements together so you know, for example, which database is used in a specific template. You can set the Application filter to display the contents of one Application at a time in the GhostFill Explorer.

Clauses You can edit and maintain a library of Clauses in the GhostFill Clause Editor. The changes you make to a Clause in the GhostFill Clause Editor are automatically carried through to the templates where the Clause is used. Clauses allow you to create complex agreements and contracts quickly and accurately, and they can be updated and maintained with ease.

Collection A collection is a group of objects. It is created for the purpose of treating these separate objects as a set instead of as independent entities. The objects in a collection are indexed, which means you can iterate over them and access an object based on its position (index) in the collection.

Conditional expression If an expression is conditional, it means that the action will only take place if the condition is met. This condition depends on input from a user at run time.

CSV String A CSV (comma separated values) string is a list of values stored as plain text. Each value in the list is usually surrounded by quotation marks, and is separated from other values in the list by a comma. Each row in the list may be separated by a character or a return. Often the first row of the list contains the names of the columns (fields) of the list.

DataLink A DataLink is created to allow GhostFill templates to communicate with databases. A DataLink is a reference to a database as well as to a specific data set (table or view) in that database. GhostFill uses a DataLink because it is easier to refer to data via a unique name (the DataLink name) rather than by both the database and data set names.

Dataset A data set is either a table, query, or a view from the data source defined by the DataLink. GhostFill does not support Parameter Queries or Stored Procedures.

Data source A data source defines the type and location of a database. A GhostFill data source is actually an ODBC data source. Defined data sources can be viewed and configured via the Windows Control Panel.

Database plugin The GhostFill Databases plug-in enables you to use information stored in databases, spreadsheets, E-mail programs, and contact managers (like MS Outlook) in your documents. In fact, GhostFill can link to any ODBC compliant data source.

Datacard A Data-card is an Answer-set of the Dialog to which the Data-deck links. A Data-card can be created, edited and selected from the Data-deck toolbar in the GhostFill Explorer.

Datadeck A Data-deck allows you to choose a master Dialog to use throughout the templates in an Application and then manage the Answer-sets (Data-cards) from a toolbar in the GhostFill Explorer. You can enable a Data-deck for an Application in the GhostFill Application Editor.

Dialog Editor GhostFill Dialogs Editor allows you to create sophisticated capture forms, that include standard Windows user interface elements like option buttons, drop-down lists, check boxes, and text entry fields. Dialogs can also be linked to each other to avoid repeating information.

Dialogs We fill in different types of forms on a daily basis, prompted by questions or labels to fill in the information required. GhostFill Dialogs are data capture forms that prompt the user to fill in answers. These answers are then used to fill the FillPoints in documents. The answers can be saved as Answer-sets and reused.

Documents Documents can be created, stored, and managed in the Documents tab of the GhostFill Explorer. Your documents can be organized in folders, Applications, and mappings.

FDF FDF stands for “Forms Data Format”. You can create a file containing form data only from a PDF file. This new FDF file is smaller than the original PDF file and is useful for electronically sharing the data.

Fill The filling process takes place when you choose to run a GhostFill template to generate a new document. On selection of one of the Run, Save As and Run, And Then… Run, And Then… Save As and Run, FastFill or Fill commands GhostFill evaluates the FillPoints that appear in the document, filling each with a result.

Fillpoint A FillPoint is a text string in a GhostFill Template that starts with the characters %[ (percent + open square bracket) and ends with a ] (close square bracket). FillPoints contain GhostFill instructions in the form of variables and tasks. GhostFill processes these instructions when it encounters a FillPoint.

Fillpoint Data The Data tab allows you to create FillPoints using the data stored in your plug-ins.

Fillpoint Editor The FillPoint Editor helps you construct complex FillPoints with ease. There are three tabs in the FillPoint Editor: The Tasks tab. The Variables tab. And the Data tab.

Fillpoint Tasks The Tasks tab lists all the tasks that make up the GhostFill Scripting Language. The tasks have been grouped together according to their functionality. They offer an assortment of powerful functions to enhance your templates.See the GhostFill Scripting Language Guide for a detailed description of each task.

Fillpoint Variables The Variables tab shows all the variables available in your open templates and in the editing area in the FillPoint Editor.

List Editor GhostFill List Editor helps you create custom Lists. You can drag a List from the GhostFill List Editor into your template to insert a List FillPoint.

List Wizard A List Wizard guides you step-by-step through the process of customizing the FillPoint. This FillPoint will determine how your List is displayed when you run your template. Based on this FillPoint, the List will open in a familiar windows format, and you can make a selection.

Lists A GhostFill list presents a group of options to choose from. Because the options are predetermined, you can control the choices that are made.

Mapping A mapping is a path to a shared storage location on a network. The name of a mapping usually describes what is stored in the location without giving any reference to the actual path

Markup Wizard The Markup Wizard helps convert existing Microsoft Word documents into templates. You may reproduce the same document again and again, changing certain words for each new version. In the Markup Wizard you can highlight these words, and they will be converted into FillPoints, without changing the layout and content of the remaining text. The result is a powerful GhostFill template created in a few easy steps.

Paragraph Wizard The Paragraph Wizard helps you use the Document Logic tasks in your templates. The document logic tasks are extremely powerful tools that let GhostFill make decisions for you at run time. There are certain actions that can be performed on paragraphs, based on the type of task being used and the conditions that have been set, e.g., whether to repeat a block of text, keep it, or delete it. The Paragraph Wizard helps you set up this complex logic in a few simple steps.

Plugin A plug-in is a software module that “plugs in” to a larger program to add a specific feature or service to the larger system, e.g., Clauses plugs in to GhostFill.

Profile A Profile is a group of variables that store related information. For example, a Profile could store information about an individual or company. This is especially useful for details that you repeat in your correspondence, e.g., Name, Address, E-mail address.

Profile Manager The Profiles are loaded and unloaded in the Profiles Manager. When you load a Profile you make its contents available to the Profile FillPoints in your templates.

Result A List result is the text that will be inserted into your document based on the item you have chosen from your List. The result can differ from the item displayed in the List (see Edit the results in a List).

Screentip A ScreenTip is an on-screen note in a small rectangular pop-up window. It gives a brief description of, for example, a toolbar button’s functions.

Script Execution The Script is executed outside of your template at run time using the Text filler. The actual filling process is not visible to the user and if input is required, small dialog boxes or Dialog Answer-sets will prompt for input.

Scripts GhostFill Scripts are executable blocks of the GhostFill Scripting Language that can be reused over and over again in your templates. They are a neat way of storing complicated FillPoints externally, i.e., without cluttering up your templates.

Style In word processing, a style is a named set of formatting specifications. To apply these specifications, simply select a section of text and apply the style name.

Tasks Tasks are the GhostFill Scripting Language contained within your FillPoints. They are pre-defined instructions which GhostFill will carry out during a fill operation. A task is made up of a task name describing the instruction.

Templates Document blueprint that can be set up with specific formatting and content.

Variable A variable is a container for a numeric or text value, or for the result of an expression, script, or task. The value stored in a variable will change each time a template is run.

XML XML stands for Extensible Markup Language. XML is a uniform method for describing and exchanging structured data in an open, text-based format, and delivering this information over the Web.

XSL XSL stands for Extensible Style Language. XSL is a specification set by the World Wide Web Consortium (W3C) for defining the layout (style sheet) of XML data.