SET SAFETY OFF
SET SESSION Table Import
SET FOLDER TO /Raw_Data
COMMENT
**************************************************************************
*****     TABLE IMPORT TEMPLATE
*****     
*****     This script sets up a dialog for importing data.  The design
*****     is for the user to place the data file in the project directory
*****     and import from there.  Variables defined in the dialog box are:
*****     
*****     Name of the File to Import:   v_file_name
*****     Name of the Output Table:     v_table_name
*****     
*****     The beginning of the import command line is to demonstrat where
*****     the variables are inserted in a standard import command line.
*****     
*****     Developed by Randall Shane, PhD
*****                  Base XVI, LLC
*****                  www.basexvi.com
**************************************************************************


DIALOG (DIALOG TITLE "Daily CSV Load Script" WIDTH 538 HEIGHT 301 ) (BUTTONSET TITLE "&OK;&Cancel" AT 444 12 DEFAULT 1 ) (TEXT TITLE "INSTRUCTIONS" AT 12 16 ) (TEXT TITLE "1)  Place the file in the project directory." AT 24 52 ) (TEXT TITLE "2)  Remove the spaces in the file name and replace them with underscore." AT 24 88 ) (TEXT TITLE "3)  Paste the name of the file here:" AT 24 124 WIDTH 174 ) (EDIT TO "v_file_name" AT 264 120 WIDTH 257 ) (TEXT TITLE "5)  Hit 'OK'" AT 24 196 ) (TEXT TITLE "This script will import the daily file, perform an interim conversion of data types and yield a completed table when done." AT 24 244 WIDTH 501 HEIGHT 27 ) (TEXT TITLE "developed by Randall Shane, PhD of Base XVI, LLC  {rshane@basexvi.com}" AT 132 280 WIDTH 386 RIGHT ) (TEXT TITLE "4)  Type in the name of the output table here:" AT 24 160 WIDTH 220 ) (EDIT TO "v_table_name" AT 264 156 WIDTH 250 )


IMPORT v_table_name v_table_name.FIL FROM v_file_name ...