Import new Comments

Ryan Knuth
Ryan Knuth
  • Updated

What is the Comments importer? 

The comments importer will allow you to bulk add new comments to people and organizations in Wicket. This is done using a templated excel file that’s uploaded. The template is available to you for download when you access the Comments importer.  

Access the Comments Importer

To access this feature, navigate to the Settings area of Wicket beside the search box. Click the gear icon, and select "Data Import" in the dropdown menu.

wicket-admin-data-import-nav.png

Set up your Import Job Type

On the first step of the import process, you will need to set up the type of import you are performing.

wicket-admin-import-setup.png

  1. Select the type of data you are importing from the dropdown (a required field). In this case, we are importing "Comments" data.
  2. Select the action you'd like to take with the data from the dropdown (a required field). In this case, we will "Add new records."
  3. Enter a name for this import job (an optional field).
  4. Click "Next."

wicket-admin-import-step1-filled.png

Organize, upload, and validate your data

The next step is to gather your data and enter it into the provided XLS template.

  1. Download the blank XLSX template by clicking the "Download Comments Import Template" link. This template contains instructions and pre-defined columns based on your Wicket configuration.
    wicket-admin-import-comments-step2-downloadtemplate.png
  2. Populate the template with your data, and save it on your computer.

    Note: It's important to read the General Instructions and Field Descriptions sheets within the template prior to populating your data. The Field Descriptions sheet will specify formatting, expected values, etc. for each column, if applicable. Following these will ensure a smoother data Validation process.

    Important: Prior to uploading the template, delete the "General Instructions" and "Field Descriptions" sheets from the template, or move the "Import Template" sheet to the first position.

    wicket-admin-import-template-sheets-order.png
  3. When you're satisfied with the data in the template, click "Choose File" (Note: this button may be named something else, depending on your browser) to select the file from your computer, then click "Next" to upload it to Wicket.
    wicket-admin-import-choosefile.png
  4. When the file has completed uploading to Wicket, a Validation process will automatically execute. This process checks your data's structure and for any other major issues.
    wicket-admin-import-step2-validating.png
  5. When completed, you will be presented with validation results including a confirmation of the File Size, Number of Records, and the Validation Outcome.

    Passed
    When validation has passed, you will see a green "Passed" outcome. You can now move onto the next step "Job Dry Run."

    wicket-admin-import-step2-validation-passed.png

    Failed
    If the validation of your data fails, you will see a red "Failed" outcome. Wicket will display a list of errors found. Resolve the validation errors by fixing or deleting the erroneous data. You can re-attempt your upload once completed, by clicking "Previous" then re-uploading your fixed file.
    wicket-admin-import-step2-validation-failed.png

Perform an Import Dry Run

The final step in validating your data is performing a dry run of the import. This process simulates the full import in order to check each individual record for compliance against data rules and policies in the template and considering existing data in Wicket.

wicket-admin-import-step3.png

  1. Click "Start Job Dry Run." A progress bar will appear to track the dry run process.

    Results
    When the Dry Run has completed, you will be presented with the results including counts for any failed, and successful records. If any records have failed, a "Download Failed Records Report" link will appear. This report contains a line-by-line breakdown of the issues detected for each row of data. 

    wicket-admin-import-step3-results.png

    If you wish to resolve the failed records, correct them within your XLSX, and re-upload the file to execute the validation and dry run processes again by starting a new import job.

    If there are no failed records, or you would like to continue with the import process with known failed records, click "Next." The failed records will not be imported.

Process Data Import and Complete Job

When you're satisfied with the Dry Run results, you can complete your import job. On the "Job Processing" step, you will be presented with a final confirmation of the number of records that will be processed.

IMPORTANT: This process will import your data, and the corresponding Wicket records will be affected. This action can not be undone.

wicket-admin-import-step4.png

  1. Click "Process Data Import and Complete Job." A progress bar will appear to track the process.

    Results
    When the job has completed, you will be presented with the results including the number of successful and failed records. If any records have failed, a "Download Failed Records Report" link will appear. This report contains a line-by-line breakdown of the issues detected for each row of data.

    Note: After import completion, you will not be able to change or re-run this import job. Failed records can be fixed and re-imported by starting a new import process.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.