Configuration parameters for importing data [upload_data.bat]
These parameters are specified on the client side [upload_data.bat/sh] and as background process parameters for XMDBToolBkg.Import BKG process:
- uploadTableName: The name of
the table where you can send the data. For example; uploadTableName =
alex_application_filter.
Note: Not required to be specified in the XMDBToolBKG.Import Bkg process.
- uploadFileName:The location
of the file that must be uploaded to the table specified in the
uploadTableName. For example; uploadFileName = C:\\Docs\\data.txt.
Note: Not required to be specified in the XMDBToolBKG.Import Bkg process.
- purgeData: If the purgeData parameter is set to 1, the data in the table specified in uploadTableName is purged (deleted) before the new data specified in the data file is inserted in the table. If you want to preserve the data in the table, set the purgeData to 0 or just comment it out (include # in front of purgeData parameter). For example; purgeData = 1.
- compress: For compressing data. The default value is true.
- uploadModule: The name of
the module to be uploaded. This parameter takes precedence over
uploadTableName. For example; uploadModule = PSO_CONFIG.
Note: Only available for use with XMDBTool client upload_data.bat/sh.
- uploadFromThisFolder: The
name of the folder where all the data files are part of the uploadModule
reside. For example; uploadFromThisFolder = C:\\Work\\UploadFromHere3.
Note: Only available for use with XMDBTool client upload_data.bat/sh.
- logFileLocation: The name
of the folder where the log files are directed after an upload run. Must be
used for a single table upload or multiple tables module upload. This parameter
is not mandatory. For example; logFileLocation =
C:\\Work\\ClientInterfaceTool\\UploadFromHere.
Note: Only available for use with XMDBTool client upload_data.bat/sh.
- chunkSize: This parameter allows uploading large number of files. Customers must set the chunk size (in number of lines). Default is 100000 lines.
- im_logMerge: If it is set to true, the log files are merged in one file. Else for each run, there is separate log file generated, each log file is time-stamped. Default value is set to true.
- im_delimiter: The delimiter used to import the files. By default, its bar (|).
- debugInfo: This parameter is used to get additional logging information. Default value is false. Set it to true to get more information.
- chunk - This parameter is used only with the XMDBToolBkg.Import background process. If this is set to True then the import file is chunked into small parts before being processed.