DataMatch Enterprise: Run Project Wizard

 

The “Run Project” wizard can export results to different storage (Excel, MS SQL, etc.). To make it it’s needed to determine the type of storage and the name of the file (or table) It can be done with help of the ‘Export’ form (standard master of DME).

Picture 1. The ‘Run Project’ wizard and ‘Export’ form

This can be done by pressing the ‘Export settings’ button on the form of the ‘Run project’ wizard. Chosen settings are saved in the project file and when the wizard is called next time they will be loaded onto the wizard. Settings will be shown in short form on form. The settings can be determined again or exporting can be switched off/on with a checkbox.

Picture 2. The short information about export settings and the checkbox for switching on/off of export.

If the “Run Project” is called a few times, results will be written over again on the same file name and only the last one will be accessible for the user.

To avoid such behavior a new feature has been implemented – a date/time template for exporting from the “Run Project” wizard.

Using such templates allows adding in the name of the exported file (or table) information about the current time of export.

The template is a set of symbols: d,f,F,g,h,H,K,m,M,s,t,y,z inside square brackets.

Below are some examples of usage and short descriptions of used symbols.

Picture 3. Name with the template of a table entered in Export Form and  created files with implemented template

Examples of usage

  Name of a table entered in Export Form

  Name of file on drive (or table in DB)

  export_[yyyy-MM-dd HH-mm-ss.f]

  “export_file_2019-04-24 13-16-04.3”

  my_export [h.m.s   M.d.y ]

  “my_export 1.16.4   4.24.19 ”

  export at [hh-mm-ss] after matching

  “export at 13-16-04 after matching”

Description of used symbols

Description

Example

(Time) ->(what will be shown)

“d”

The day of the month, from 1 through 31.

2009-06-01 13:45:30 -> 1

“dd”

The day of the month, from 01 through 31.

2009-06-01 13:45:30 -> 01

“f”

The tenths of a second in a date and time value.

2009-06-15 13:45:30.6170000 -> 6

“ff”

The hundredths of a second in a date and time value.

2009-06-15  13:45:30.6170000 -> 61

“fff”

The milliseconds in a date and time value.

6/15/2009   13:45:30.617 -> 617

“h”

The hour, using a 12-hour clock from 1 to 12.

2009-06-15   01:45:30 -> 1

2009-06-15   13:45:30 -> 1

“hh”

The hour, using a 12-hour clock from 01 to 12.

2009-06-15  01:45:30 -> 01

2009-06-15  13:45:30 -> 01

“H”

The hour, using a 24-hour clock from 0 to 23.

2009-06-15  01:45:30 -> 1

“HH”

The hour, using a 24-hour clock from 00 to 23.

2009-06-15  01:45:30 -> 01

“m”

The minute, from 0 through 59.

2009-06-15  01:09:30 -> 9

“mm”

The minute, from 00 through 59.

2009-06-15  13:29:30 -> 29

“M”

The month, from 1 through 12.

2009-06-15  13:45:30 -> 6

“MM”

The month, from 01 through 12.

2009-06-15   13:45:30 -> 06

“s”

The second, from 0 through 59.

2009-06-15   13:45:09 -> 9

“ss”

The second, from 00 through 59

2009-06-15  13:45:09 -> 09

“y”

The year, from 0 to 99.

2009-06-15  13:45:30 -> 9

2019-06-15  13:45:30 -> 19

“yy”

The year, from 00 to 99.

1900-01-01   00:00:00 -> 00

2019-06-15   13:45:30 -> 19

“yyyy”

The year as a four-digit number.

2009-06-15   13:45:30 -> 2009

Also there can be used: the period or era AD/BD (“g”); time zone information (“K”); the AM/PM designator (“tt””t”); hours offset from UTC (“z”, “zz”).

This template uses .Net features that why detailed description can be found by the link:

https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings

Restrictions

  1. The format of the template

If a few templates are used only the first will be implemented

The enter in Export Form:

   “export at [H.m.s]  No.1 on [M.d.y ]”

Name of  file (or table):

   “export at 13.16.4  No.1 on [M.d.y ]”

If order of square brackets is corrupted, then the template will not be implemented

The enter in Export Form:

   “export at] [H.m.s]  No.1”

Name of  file (or table):

   “export at] [H.m.s]  No.1”

  1. Maximum length of names

When a name of a table is entered it is important to ensure that the length of the name does not exceed the maximum allowed length in chosen storage.

For example, Oracle DB can have a limitation of 30 or 128 bytes, depending on the version of the database, other databases have similar limitations.

Want to know more?

Check out DME resources

Merging Data from Multiple Sources – Challenges and Solutions

Oops! We could not locate your form.