Pre-step 3: Populate Seedlists

Search Knowledge Base by Keyword

< Back

MySQL_Tables_Create.sql runs as part of the initial set-up and only defines the seedlist tables but does not populate them. To load data into the tables you should run command script Mask_InsertLists.cmd which is in

C:\VIPTDM\SubsetCloneAndMaskRun\Mask\MySQL\EnvironmentPrep

Input: Seedlist folder containing .csv files (C:\VIPTDM\SubsetCloneAndMask\EnvironmentPrep\Seedlists)

Function: This step runs SQLMask.enc.vip which reads each .csv file in the seedlist folder. The file name is used as the seedlist name and the contents of the file are inserted into the database seedlist table.

Note: Pre-steps 1-3 must have been run before running the remaining Masking steps.