Tutorial videos are available here.
Visit our User Forum for discussions and solutions
Use data from a customer and/or staff database on your XpressDox templates. As a first step, the database needs to be configured as a data source in XpressDox. Learn how to configure a data source in this article.
Now that you have configured your data source, there may be some properties on the XpressDox configuration screen you want to know more about. Learn about those properties here.
Now that you have configured a data source, the data can be used on your XpressDox template using commands such as ChooseFromDataSource or IncludeDataSourceData. Learn more about these XpressDox commands here.
Working with LinkToDataSource – example with a highly normalised data base. You need to access a database which has the following structure: Table “Contact” ContactFirstName ContactLastName ContactTitle Address City Region ContactTypeId Table “ContactType” TypeId TypeDescription
XpressDox offers Salesforce.com users a simple-to-use Salesforce with Word or Web integration that enables users to populate their documents with Salesforce data automatically. This means that anything from simple documents to complex agreements can be
This Cookbook article refers to the AdventureWorks database which needs to be installed at a location available to your development environment. If you have not already done so, you can download the database from Download
Configuring a web service as a data source follows the same first steps as for other data sources. The first place where it differs is (obviously) at the point where you choose the type of
It may be that you are developing a set of templates using data from a database, but you are not the database administrator, and so can’t create your own views or stored procedures in the
XpressDox can retrieve data from just about any data base, but in particular, data from the Elite practice management system can be made available to your templates. The Elite data base is a Microsoft® SQL Server database, and so can be configured
Ensuring correct contact details on a letterhead can be a huge problem in a large enterprise. XpressDox has a number of features which make it possible to overcome this problem. One of these is the Data Source Configuration feature together with the ChooseFromDataSource command.
Global information sometimes needs to be made available to all templates. Either all templates in an organisation, or all templates in a specific application or group of applications. XpressDox Docussembly™ makes this possible via the Configuration of a data source.
XpressDox can provide data from a large number of source databases. In particular, SQL Server databases can be configured as Data Sources in XpressDox, and this makes it possible to include data form those databases in templates. This Cookbook recipe shows how to configure a SQL Server Customer table, from the Microsoft sample database “AdventureWorks”, as a Data Source, and then goes on to explain how to reference that Data Source in a template.
It is possible to export an XpressDox configuration file which contains data source definitions. This exported configuration can then be sent to other interested parties and imported into their own configurations. A typical example is
With effect from version 6, XpressDox offers a number of features which help the template author to develop templates which add new data to data sources. For example, to open a new account in an
Data from a data base can be inserted into a template. Perhaps this data has changed since it was last updated in the database, and the template-running-user is the one who knows about this change. It should be permissible for the user to change the data and have the change propagated back into the database.
There are any number of reasons that you might want to save the dataset for a template into a single column in as database. One of these would be to report on the data set,
When you have a system of templates and have run them a number of times, say for a number of your customers, the saved data set files become a source of valuable information. It would
Use one template to generate a letter to each of a set of clients whose contact details are saved in a database.
XpressDox can be configured to record every usage of a template, giving the date and time it was run, along with the user who ran it. This requires a database (a formal one like SQL
Some of the sample templates which are delivered with XpressDox make use of one of the early instances of the Microsoft AdventureWorks SQL Server database. This database can no longer be obtained from any Microsoft
901 S MoPac Expressway, Building 1, Suite #300, PMB 300127, Austin, TX, 78746, USA
85 Tottenham Court Road, London, W1T 4 TQ, UK
35 Anderson Road North, Cape Town, 7550, Western Cape, South Africa
Copyright ©2023 XpressDox. All Rights Reserved. | Website By Hello Fascination
