When you use the Database Integration Wizard to create a template that imports DMS data from a query result set, you may need to consider some of the following issues:
By default, the resulting template interprets the values in one row of the query result set as one DMS data record.
If your query result set is set up so that data for one DMS data record is found on multiple rows of the query result set, you must use the Template Wizard to modify the formulas in the template.
If the template was created to import both SPC and DMS data, then you were able to specify on step 4 of the Database Integration Wizard the number of features to be imported into SPC. You were also able to specify whether the subgroup data for these features was found only on one row of the query result set or on multiple rows.
By default, the resulting template will only store one DMS data record for each set of SPC features that you specified on step 4. It will import the DMS data from the first row of the query result set used for one set of SPC features, but will ignore any DMS data on other rows of the query result set used by that set of SPC features.
For example, if your template is designed to import data for three SPC features from three rows of the query result set along with DMS data, the template can only store the DMS data record from the first of those rows of data in the query result set when it stores all three of the SPC subgroups (one for each feature).
If your query result set contains more than one DMS data record on the rows containing one set of SPC features, you must use the Template Wizard to modify the formulas in the template.
If your query result set contains only date stamps but no time stamps, it is possible that several rows of the query result set may reference the same combination of standard and date. However, you can still map this date column from your query result set into the Date/Time cell on step 5 of the Database Integration Wizard.
By default, the resulting template uses the date stamp from your query result set and assigns consecutive time stamps to these data records, incrementing the time stamp as it moves through the query result set, and data is stored correctly.
However, if you are importing a large number of rows, this process of finding the next available time stamp can eventually slow down the process of importing data. If this causes problems for you, you can use the Template Wizard to modify the formulas in the template.
Here are two suggestions for faster creation of time stamps:
By default, a formula identifying the date value has already been entered in each Date/Time cell by the Database Integration Wizard. Concatenate this date formula to a string containing a space (" ") and then to the formula for the current time
Format Now, "Short Time"
An even faster way to store data is to use a counter for the time stamp, and to concatenate this counter to the date. The following is an example of how to do this:
SVar 50 = Date_Format Column CHR 9, CHR 34, 2, "MDY" : 'date' :
NVar 50 = NVar 50 + 1 : 'counter' :
NVar 51 = NVar 50 % 60 : 'seconds' :
NVar 53 = NVar 50 \ 3600 : 'hours' :
NVar 52 = (NVar 50 - (NVar 53 * 3600)) \ 60 : 'minutes' :
CONCAT SVar 50, " ", Format NVar 53, "00", ":", Format NVar 52, "00", ":", Format NVar 51, "00"