Stage Table Statuses

You may notice that next to each staging table, there is a status defined for CSV uploads. These statuses drive the Upload options you can select. The following table defines each status.

 

Status

Explanation

CSV Needed:

The initial state of a table. No data has been loaded. The only Upload option available is "New Data."

CSV Uploaded:

The state of the a table after CSV Needed. This is also the status after uploading data to Stage_GL_Data. Upload options with this status are Append, Merge, or Overwrite.

CSV Overwritten:

Existing data was deleted from the table and replaced with the data file associated with this status. Upload options with this status are Append, Merge, or Overwrite.

CSV Appended:

Data from the file related to this status was added on top of any existing data on the table. Upload options with this status are Append, Merge, or Overwrite.

CSV Merged:

The app compared data from the file related to this status from existing records on the table. Records that do not exist were added. Upload options with this status are Append, Merge, or Overwrite.

CSV Upload In Progress:

Only for Stage_GL_Data. The Monitor Service has picked up the file and is sending it to Stage_GL_Data.

CSV Upload Failed:

Only for Stage_GL_Data. The Monitor Service attempted to send the file's contents to Stage_GL_Data but failed. Expand and check System Messages to see what failed.

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk