Working with strings

April 28, 2012 XpressDox Cookbook

XpressDox has numerous string handling functions.  The number of different applications is vast, and this article tries to provide a number of situations all in one place. Extract the last few characters of a string Suppose you have a situation where a particular data element will always contain a specific code in the last 3 characters, but [...]

Read the full article →

Version 4.2.5 (2012-04-25)

April 26, 2012 New in XpressDox

2012-04-24 Version 4.2.5 Some bugs have been fixed, and new features released. 1. The syntax of the List command can now accept function calls in the second parameter. For example: «List(Child,ToUpper(FirstNames) ToUpper(Surname),!, , and )». 2. The count() and position() functions now affect relevance in the interview. 3. The function «YearsBetween()» will calculate the number [...]

Read the full article →

The YearsBetween Function

April 26, 2012 User Reference

«YearsBetween(EndDate,StartDate)» returns the approximate number of years between the two dates. The reason that it is approximate is that it is calculated as the number of days between the two dates divided by 365.25. Thus for a long time period, the result will be more accurate than for a short time period. For example: I [...]

Read the full article →

Install a third party data source

April 20, 2012 XpressDox Cookbook

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 when a data source for a specific data base is created by, say, a system administrator, and this is to [...]

Read the full article →

Version 4.2.3 (2012-04-19)

April 19, 2012 Help

Version 4.2.3 This is primarily a bug-fix release.  The fixes include: 1. Some issues with style merging with IncludeTemplate and BaseTemplate have been addressed. 2. Bug in Create Interview Template in the Prepare PDF utility has been fixed.

Read the full article →

Source and Destination formatting in Version 4

April 16, 2012 XpressDox Cookbook

There was a change in Version 4 with the style handling with BaseTemplate,  IncludeTemplate and InsertTemplate template. How it worked in version 3 of XpressDox With version 3, when Source formatting was used, XpressDox would create a new style in the destination template for every style in the source template, but with a new name. (Note [...]

Read the full article →

Version 4.2.0 (2012-04-13)

April 13, 2012 New in XpressDox

New features added with this version are: 1. Sandbox option for SalesForce data sources introduced – applied in New Data Source Wizard. 2. Bug fixed in Macro As Datasource implementation. 3. Prevent empty General tab from showing. 4. There is some strange behaviour in Word 2003 XML which caused the XpressDox converter to save Version [...]

Read the full article →

The CaptureOnlyEmptyValues Command

April 13, 2012 Help

When the data set can be populated prior to the interview becoming active, then this command can be used to present an interview which contains only those data elements which are empty. A dataset can be populated prior to the interview in a number of ways: The data are sourced via an IncludeDataSourceData command. The data set is [...]

Read the full article →

The Chr Function

April 13, 2012 User Reference

This function can be used to return a character based on its numeric (Unicode) value. It will probably only be used in the context of building up a string where the character can’t be typed directly.  One such application is the building of a set of address lines into a block which can be displayed [...]

Read the full article →

The ChooseFromDataElements Command

April 13, 2012 User Reference

Once the data set being captured has acquired some data (either captured in this session or included from a data source or file), then a ChooseFromDataElements command can be used to allow the user to capture the value of a data element from the values of existing data elements. For example, suppose the interview has place [...]

Read the full article →