Custom naming convention

Top  Previous  Next

The custom naming convention option allows you to name your exported files in various manners.

 

 

naming_custom_01

 

 

Let's start with a simple data set.

 

naming_custom_02

 

Now you want to name the files using the value from the ID column.  In the Naming convention option, enter the value <ID>.

 

naming_custom_06

 

The exported files will then be named this way:

 

naming_custom_04

 

 

Now say you want to use values from 2 columns e.g.

 

naming_custom_05

 

 

Just add the tags for both columns in the Naming convention option e.g.

 

naming_custom_07

 

The exported files are then naming accordingly:

 

naming_custom_08

 

 

You can also add some formatting to numerical values, for e.g. to always have the ID value be 5 digits, filled with 0s where necessary.  Just specify the column this way - <ID:00000>:

 

naming_custom_09

 

 

The files are then named this way:

 

naming_custom_10

 

If the column is a datetime value, you can also use tags to control exactly how the value is displayed.  By default, the value is displayed using the format yyyymmdd, so for a datetime value of 31 January 1970, the displayed value is 19700131.

 

You can format date and time values using a variety of formatting tags.  You add the formatting tags after the database column name, prefixed by a ':' e.g. if the datetime column is named checked_in_date, you can use the following tag: <checked_in_date:yyyy mm dd>.  The following are the supported formatting tags for datetime values:

 

d

Displays the day as a number without a leading zero (1-31).

dd

Displays the day as a number with a leading zero (01-31).

ddd

Displays the day as an abbreviation (Sun-Sat) using the strings given by the ShortDayNames global variable.

dddd

Displays the day as a full name (Sunday-Saturday) using the strings given by the LongDayNames global variable.

ddddd

Displays the date using the format given by the ShortDateFormat global variable.

dddddd

Displays the date using the format given by the LongDateFormat global variable.

m

Displays the month as a number without a leading zero (1-12). If the m specifier immediately follows an h or hh specifier, the minute rather than the month is displayed.

mm

Displays the month as a number with a leading zero (01-12). If the mm specifier immediately follows an h or hh specifier, the minute rather than the month is displayed.

mmm

Displays the month as an abbreviation (Jan-Dec) using the strings given by the ShortMonthNames global variable.

mmmm

Displays the month as a full name (January-December) using the strings given by the LongMonthNames global variable.

yy

Displays the year as a two-digit number (00-99).

yyyy

Displays the year as a four-digit number (0000-9999).

h

Displays the hour without a leading zero (0-23).

hh

Displays the hour with a leading zero (00-23).

n

Displays the minute without a leading zero (0-59).

nn

Displays the minute with a leading zero (00-59).

s

Displays the second without a leading zero (0-59).

ss

Displays the second with a leading zero (00-59).

z

Displays the millisecond without a leading zero (0-999).

zzz

Displays the millisecond with a leading zero (000-999).

t

Displays the time using the format given by the ShortTimeFormat global variable.

tt

Displays the time using the format given by the LongTimeFormat global variable.

am/pm

Uses the 12-hour clock for the preceding h or hh specifier, and displays 'am' for any hour before noon, and 'pm' for any hour after noon. The am/pm specifier can use lower, upper, or mixed case, and the result is displayed accordingly.

a/p

Uses the 12-hour clock for the preceding h or hh specifier, and displays 'a' for any hour before noon, and 'p' for any hour after noon. The a/p specifier can use lower, upper, or mixed case, and the result is displayed accordingly.

ampm

Uses the 12-hour clock for the preceding h or hh specifier, and displays the contents of the TimeAMString global variable for any hour before noon, and the contents of the TimePMString global variable for any hour after noon.

/

Displays the date separator character given by the DateSeparator global variable.

:

Displays the time separator character given by the TimeSeparator global variable.