Search the Omeda Knowledge Base
Data Loader – Basic Navigation
Data Loader Home Page
Coming to the Data Loader home page for the first time, you’ll most likely see the following message prompting you to add data files:
If you’re already using the tool, previously loaded files will be listed out starting with the most recently-loaded file. Here, you’ll have access to the following details:
- File: Full file name, date and timestamp of upload
- Template: When applicable
- Owner: Who uploaded the file
- File Status: Where the file is in regards to the data load process
- Template Status: Ready to Map, Active, Active w/Errors, Inactive, or Inactive w/Errors
- Actions Menu: Edit Template, Process, View File State, Toggle Details Pane, Delete
Navigation: Searching / Sorting
As your list of files grows, you have multiple ways to search or sort files to find the file(s) that you want. On the main data loader screen, each column has a searchable header:
- File – This allows you to do a text search for the file titles (e.g. event)
- Template – This dropdown will list all of your available templates and return the associated files
- Owner – This text field will let you type in a username to search for the files that they uploaded
- File Status – This dropdown will list all of the status options a file may have including: Pending, Ready to Process, Completed, Excessive Errors, etc.
- Template Status – This dropdown will let you sort the files by the template status. Options include: Inactive, Active, Ready to Map, Active w/Errors, and Inactive w/Errors
You can combine a number of these headers or use a single one to search and sort your files. Once you have selected the desired headers, click ‘Search’ to apply.
At the bottom of the file list the total files you have uploaded will appear along with the additional pages of files.
The most recent files will appear on page 1. You can use the pages to sort through files in addition to the headers above.
Navigation: Actions Menu
Once a file is no longer in ‘pending’ status, you’ll have the following options from the actions menu:
- Edit Mapping: This will take you to step 2 where you can map the incoming data fields to your Omeda fields
- Process: Once the file has been successfully mapped, you can select this to process the file and formally add the data to your database
- View File State: Use this to review the file once it has been completed
- Toggle Details Pane: This can be access once a file is no longer ‘pending’ and it will bring out an overview pane on the right-hand side of your screen
- Archive / Delete: If the file has been processed you will see ‘Archive‘. If the file has not yet been processed you will have a ‘Delete‘ option. Archive will move the file out of the main list while Delete will remove it entirely from the system.
Navigation: Toggle Details Pane
The toggle detail pane appears from the right-hand side and gives a brief overview of the file that you have selected. You can access this pane two ways:
- Clicking on the file status or template status bubbles for the file
- Clicking Toggle Details Pane from the action dropdown
The toggle pane is divided into the following sections:
- Last Update – This marks the last time something about the file was changed. Most interactions with the file that causes information about it to change will affect this time.
- Last Updated By – This is the user who touched something about the file recently. This user is tied to the “Last Update” timestamp.
- File Type – This is just stating what type the file was identified as.
- Rows – This is typically the number of rows in the file excluding the header row. This represents the possible rows that could be processed. If a row was found in error as part of the upload process, they will still be counted here.
- The “Record” and “Record Errors” counts should total this count.
- Columns – This is the number of headers found in the file.
- Records – This is the number of rows that were successfully processed to the database.
- Record Errors – This is the number of rows that either partially or completely failed to process. This includes any rows that may have been skipped as part of the upload.
Tracking Code & Sample Records:
- Batch Tracking Code – This area will be filled after the file has processed at least once. This will be used to identify records created or changed by this file. This can be used in Audience Builder to look up which customers were involved with this file. This will include existing customers, if they were found in the file.
For additional steps on using Audience Builder to lookup Data Loader files, see Querying Data Loader in Audience Builder (OnQ)
- The Sample Record Preview Card offers one record at a glance. Initially, only the first six headers and their values are shown, but clicking the Show All will reveal any others.
You can add various keywords (separated by commas) to the file being loaded. Much like Keywords for saved queries, this will allow you to search for all associated files with the same keywords within Audience Builder (OnQ).
An additional feature of this pane is being able to add a Note to the file. This is a purely optional space used to communicate something important or clerical about the file and doesn’t need to be used for every file. Only one note can be stored at time. This means the User can edit an existing one or completely rewrite it. Saving a new note will cause the previous note to no longer exist. The user can tell which file has a Note by looking for a sticky-note image among the file list.