Troubleshooting Tips

Context Definitions

Tips:

• Do not deselect the Visible for Mapping check box on important fields when initially setting up and testing because it can be very confusing when trying to debug issues. It is easier to see important data being imported on File Mapping when troubleshooting. Once you have the mapping definition tested, you can go back and deselect Visible for Mapping on the field you do not want the users to change.

• Use the default sort order which increments by 10. This will allow you to insert additional staging records in the future.

• Ensure the staging tables hierarchy via the sort order. Parent table(s) will have a lower sort order than their children.

File Mapping Definition

Tips:

• If you start setting up in Pending status, make sure that you change the status to Active and save along the way to resolve setup issues as you proceed. Errors are not fired when the status is set to Pending.

• Use an incremental approach. Set up the required records, test, add some more records, and test. This is an easier way to troubleshoot setup issues.

• File Layout: When inserting File Fields, use the default sort order which increments by 10. This will allow you to insert additional fields later.

• Mapping page:

  • The system inserts the records according to the order listed on the Context Definition.

  • A value must be provided for each required field. The system displays an error message if a required field has a Mapping Action set to None.

  • If you are having issues using the Sequence Mapping Action, try setting the Mapping Action to Default and entering 1, 2, 3, and so on for each row of the record you are inserting to.

Porting definitions from one environment to another

Tips:

• When creating new File Parser definitions, it is important to understand that File Parser has a unique key structure for each of its definitions (that is, Conversion, Context, Pop Select, and Mapping).

• After creating these definitions in your development environment, query your current Production File Parser definitions to make sure that you will not overwrite them when porting your new definitions into your production environment.

• If you find any collision(s), rename the keys via native SQL to a unique value(s) prior to exporting the definitions.

The following are some examples of useful SQL and DataMover scripts to help you manage the export or import of File Parser definitions:

List Current File Parser Definitions:

/*
Instructions:

1) Identify scope. If you are porting either Conversion definitions and/or
   Pop Select Mapping Definitions, you will need to uncomment the respective SQL
   statements - See below.

2) Supply a WHERE clause to narrow down the results.
*/

/* -- - - - - - - - - Conversion Definitions (Optional)  - - - - - - - - - - */
/*
SELECT * FROM PS_SCCFP_CNVR;
SELECT * FROM PS_SCCFP_CNVR_FLD;
SELECT * FROM PS_SCCFP_CNVR_VAL;
*/

/* - - - - - - - - Pop Select Mapping Definitions (Optional) - - - - - - - - -*/
/*
SELECT * FROM PS_SCCFP_PS_MAP;
SELECT * FROM PS_SCCFP_PS_MAPFLD;
*/

/* - - - - - - - - - - - - Context Definitions - - - - - - - -- - - - - - - */

SELECT * FROM PS_SCCFP_CNTXT_DFN;
SELECT * FROM PS_SCCFP_CNTXT_REC;
SELECT * FROM PS_SCCFP_CNTXT_RF;

/* - - - - - - - - - - - - Mapping Definitions - - - - - - - - - - - - - - - */

SELECT * FROM PS_SCCFP_MAP_DFN;
SELECT * FROM PS_SCCFP_MAP_REC;
SELECT * FROM PS_SCCFP_MAP_FLD;
SELECT * FROM PS_SCCFP_FILE_SGT;
SELECT * FROM PS_SCCFP_FILE_FLD;

Update File Parser IDs (Keys):

/*
Instructions:

1) Identify scope. If you are porting either Conversion definitions and/or
   Pop Select Mapping Definitions, you will need to uncomment the respective SQL
   statements.

2) Identify the next available ID value(s).

3) Edit the SQL as follows:

   a) Conversion Definitions - (If applicable) Find/Replace the 
      string 'New_CNVR_ID'with the next available value assigned 
      to your application.

      Find/Replace the string 'Current_CNVR_ID' with 
      the current value of SCCFP_CNVR_ID.

   b) Pop Select Mapping Definitions - (If applicable) Find/Replace the 
      string 'New_MAP_ID' with the next available value 
      assigned to your application.

      Find/Replace the string 'Current_MAP_ID' with the current 
      value of SCCFP_MAP_ID. 

   c) Context Definitions - Find/Replace the string 'New_CNTXT_ID' with 
      the next available value assigned to your application.

      Find/Replace the string 'Current_CNTXT_ID' with the current 
      value of SCCFP_CNTXT_ID. 

   d) Mapping Definitions - Find/Replace the string 'New_MAP_ID' with 
      the next available value assigned to your application.

      Find/Replace the string 'Current_MAP_ID' with the current 
      value of SCCFP_MAP_ID.

4) Save your changes and execute the SQL statements in the native 
   SQL tool of your choice.
   
5) Repeat steps 1-4 for any additional File Parser definitions.

6) Verify/Unit test the changes within the File Parser component.
*/


/* - - - - - - - - - - Conversion Definitions (Optional) - -  - - - - - */
/*
UPDATE PS_SCCFP_CNVR
SET SCCFP_CNVR_ID = New_CNVR_ID
WHERE SCCFP_CNVR_ID = Current_CNVR_ID;

UPDATE PS_SCCFP_CNVR_FLD
SET SCCFP_CNVR_ID = New_CNVR_ID
WHERE SCCFP_CNVR_ID = Current_CNVR_ID;

UPDATE PS_SCCFP_CNVR_VAL
SET SCCFP_CNVR_ID = New_CNVR_ID
WHERE SCCFP_CNVR_ID = Current_CNVR_ID;
*/


/* - - - - - - -- Pop Select Mapping Definitions (Optional) - -  - - - - - -*/
/*
UPDATE PS_SCCFP_PS_MAP
SET SCCFP_MAP_ID = New_MAP_ID
WHERE SCCFP_MAP_ID = Current_MAP_ID;

UPDATE PS_SCCFP_PS_MAPFLD
SET SCCFP_MAP_ID = New_MAP_ID
WHERE SCCFP_MAP_ID = Current_MAP_ID;
*/


/* - - - - - - - -- - - - Context Definitions - - - - - - - - - - - - */

UPDATE PS_SCCFP_CNTXT_DFN
SET SCCFP_CNTXT_ID = New_CNTXT_ID 
/*    ,SCCFP_CNVR_ID = New_CNVR_ID */
WHERE SCCFP_CNTXT_ID = Current_CNTXT_ID;

UPDATE PS_SCCFP_CNTXT_REC
SET SCCFP_CNTXT_ID = New_CNTXT_ID
WHERE SCCFP_CNTXT_ID = Current_CNTXT_ID;

UPDATE PS_SCCFP_CNTXT_RF
SET SCCFP_CNTXT_ID = New_CNTXT_ID
WHERE SCCFP_CNTXT_ID = Current_CNTXT_ID;


/* - - - - - - - - - - - - - Mapping Definitions - - - - - - - - - - - - */

UPDATE PS_SCCFP_MAP_DFN
SET SCCFP_MAP_ID = New_MAP_ID,
    SCCFP_CNTXT_ID = New_CNTXT_ID 
/*    ,SCCFP_CNVR_ID = New_CNVR_ID */
WHERE SCCFP_MAP_ID = Current_MAP_ID;

UPDATE PS_SCCFP_MAP_REC
SET SCCFP_MAP_ID = New_MAP_ID
WHERE SCCFP_MAP_ID = Current_MAP_ID;

UPDATE PS_SCCFP_MAP_FLD
SET SCCFP_MAP_ID = New_MAP_ID
WHERE SCCFP_MAP_ID = Current_MAP_ID;

UPDATE PS_SCCFP_FILE_SGT
SET SCCFP_MAP_ID = New_MAP_ID
WHERE SCCFP_MAP_ID = Current_MAP_ID;

UPDATE PS_SCCFP_FILE_FLD
SET SCCFP_MAP_ID = New_MAP_ID
WHERE SCCFP_MAP_ID = Current_MAP_ID; 

Export File Parser Definitions Using DataMover:

-- Use this script to extract the File Parser definitions into a data (.dat) format 
-- to be used to import into another database.
--
-- Step 1) Save this script with a meaningful name; something reflective 
-- of the File Parser definitions being extracted.
--   
-- Step 2) Change the string 'xxxx' to a meaningful name for the export 
-- log. Add/prefix a path if you do not wish to use the default path 
-- defined in Configuration Manager.
--     
-- Step 3) Change the string 'yyyy' to a meaningful name for the data 
-- file. Add/prefix a path if you do not wish to use the default path 
-- defined in Configuration Manager.
--
-- Step 4) If you are extracting any conversion definitions, change the 
-- string 'aaaa' to the value of the conversion ID. 
--              Else, delete the EXPORT statements containing the string 'aaaa'.     
--   
-- Step 5) Change the string 'bbbb' to the context ID.
--
-- Step 6) If you are extracting any Pop Select definitions, change the 
-- string 'cccc' to the value of the map ID. 
--              Else, delete the EXPORT statements containing the string 'cccc'.      
--  
-- Step 7) Change the string 'dddd' to the value of the map ID.
--
-- Step 8) Save your changes and run the DataMover script against the 
-- database containing the File Parser definitions you wish to extract.   

SET LOG xxxx_Export.LOG;
SET OUTPUT yyyy_EXPORT.DAT;

EXPORT SCCFP_CNVR WHERE SCCFP_CNVR_ID = aaaa;
EXPORT SCCFP_CNVR_FLD WHERE SCCFP_CNVR_ID = aaaa;
EXPORT SCCFP_CNVR_VAL WHERE SCCFP_CNVR_ID = aaaa;

EXPORT SCCFP_CNTXT_DFN WHERE SCCFP_CNTXT_ID = bbbb;
EXPORT SCCFP_CNTXT_REC WHERE SCCFP_CNTXT_ID = bbbb;
EXPORT SCCFP_CNTXT_RF WHERE SCCFP_CNTXT_ID = bbbb;

EXPORT SCCFP_PS_MAP WHERE SCCFP_MAP_ID = cccc;
EXPORT SCCFP_PS_MAPFLD WHERE SCCFP_MAP_ID = cccc;

EXPORT SCCFP_MAP_DFN WHERE SCCFP_MAP_ID = dddd;
EXPORT SCCFP_MAP_REC WHERE SCCFP_MAP_ID = dddd;
EXPORT SCCFP_MAP_FLD WHERE SCCFP_MAP_ID = dddd;
EXPORT SCCFP_FILE_SGT WHERE SCCFP_MAP_ID = dddd;
EXPORT SCCFP_FILE_FLD WHERE SCCFP_MAP_ID = dddd;

Import File Parser Definitions Using DataMover:

-- Use this script to import the File Parser definition data (.dat) file 
-- into another database.  
--
-- Step 1) Save this script with a meaningful name; something reflective of 
-- the File Parser definitions  being imported.     
--   
-- Step 2) Change the string 'xxxx' to a meaningful name for the import 
-- log. Add/prefix a path if you do not wish to use the default path defined 
-- in Configuration Manager.     
--   
-- Step 3) Change the string 'yyyy' to the name of the .dat file being 
-- imported. This is the name of the file exported 
-- by FILE_PARSER_DEFN_EXPORT.dms. Add/prefix a path if you do not 
-- wish to use the default path defined in Configuration Manager.
--
-- Step 4) If you are importing any conversion definitions, change the 
-- string 'aaaa' to the value of the conversion ID.
--              Else, delete the DELETE statements containing the string 'aaaa'. 
--              Delete the IMPORT statements containing the Record Definition 
--              beginning with 'SCCFP_CNVR'.     
--   
-- Step 5) Change the string 'bbbb' to the context ID.
--
-- Step 6) If you are importing any Pop Select definitions, change the 
-- string 'cccc' to the value of the map ID.
--              Else, delete the DELETE statements containing the string 'cccc'. 
--              Delete the IMPORT statements containing the Record Definition 
--              beginning with 'SCCFP_PS_MAP'.      
--  
-- Step 7) Change the string 'dddd' to the value of the map ID.
--
-- Step 8) Save your changes and run the DataMover script against the database 
-- containing the File Parser definitions you wish to import.
-- 

SET LOG xxxx_Import.LOG;
SET INPUT yyyy_EXPORT.DAT;

DELETE FROM PS_SCCFP_CNVR WHERE SCCFP_CNVR_ID = aaaa;
DELETE FROM PS_SCCFP_CNVR_FLD WHERE SCCFP_CNVR_ID = aaaa;
DELETE FROM PS_SCCFP_CNVR_VAL WHERE SCCFP_CNVR_ID = aaaa;

DELETE FROM PS_SCCFP_CNTXT_DFN WHERE SCCFP_CNTXT_ID = bbbb;
DELETE FROM PS_SCCFP_CNTXT_REC WHERE SCCFP_CNTXT_ID = bbbb;
DELETE FROM PS_SCCFP_CNTXT_RF WHERE SCCFP_CNTXT_ID = bbbb;

DELETE FROM PS_SCCFP_PS_MAP WHERE SCCFP_MAP_ID = cccc;
DELETE FROM PS_SCCFP_PS_MAPFLD WHERE SCCFP_MAP_ID = cccc;

DELETE FROM PS_SCCFP_MAP_DFN WHERE SCCFP_MAP_ID = dddd;
DELETE FROM PS_SCCFP_MAP_REC WHERE SCCFP_MAP_ID = dddd;
DELETE FROM PS_SCCFP_MAP_FLD WHERE SCCFP_MAP_ID = dddd;
DELETE FROM PS_SCCFP_FILE_SGT WHERE SCCFP_MAP_ID = dddd;
DELETE FROM PS_SCCFP_FILE_FLD WHERE SCCFP_MAP_ID = dddd;

COMMIT;

IMPORT SCCFP_CNVR;
IMPORT SCCFP_CNVR_FLD;
IMPORT SCCFP_CNVR_VAL;

IMPORT SCCFP_CNTXT_DFN;
IMPORT SCCFP_CNTXT_REC;
IMPORT SCCFP_CNTXT_RF;

IMPORT SCCFP_PS_MAP;
IMPORT SCCFP_PS_MAPFLD;

IMPORT SCCFP_MAP_DFN;
IMPORT SCCFP_MAP_REC;
IMPORT SCCFP_MAP_FLD;
IMPORT SCCFP_FILE_SGT;
IMPORT SCCFP_FILE_FLD;