Creating a New Data Import

Follow

You can easily and seamlessly import data for opportunities, sales plans and solutions into WorkSpan using the new self-service data import feature.

You can map data from your internal CRM, other systems and external data sources and load it into WorkSpan safely and confidentially for your sales plans, solutions and opportunities.

This helps regular and periodic refresh of your data from your internal CRM and other systems, while keeping your data safe and secure.

Data validation is done to ensure a clean import of your data. Records that fail data validation are not imported and notifications for corrections are displayed against those records for you to retry.

Creating a New Import Configuration

Steps:

  1. Go to Home > Setup >Data Import
    Dataimport.gif
  2. You are navigated to the Data Import Landing Page.

    importconfiglandingpage.gif
  3. Click +Import Config. Create Import Configuration screen opens.

    createimportconfig.gif
  4. Enter the Import Configuration Name.
  5. Select amongst Plan, Solution or Opportunity in What are you importing?.
  6. If you want mapping for your custom fields, create a template and then select that Template. If selected, fields from the template will be included for mapping. Otherwise, only standard fields from the object that you have selected are listed for mapping.
  7. Attach your data file. You can only attach .xls files.
  8. After a file is attached, the Match Object By field is highlighted. Choose the parameter by which you want to match. 
  9. In Set who can access this import configuration:
    1. Specify the Owners. Owners can create the import map.
    2. Specify the Users. These users can run the import, i.e, upload a different file, see the preview and submit the import, but cannot edit field mappings.
    3. In Share with Companies, select one or more companies with whom you want to share this import configuration. The job submission page specifies who is added on each created object. All users from the selected companies can run the import process.
    4. Click Next.
  10. Create Import Configuration screen opens.createimportconfig2.gif
  11. You can match fields in WorkSpan to the fields from your import file by dragging and dropping appropriate fields to the target rows in the WS Fields column. Each row on the right represents a particular column in the file.
  12. If you want to map nested fields like metrics within your solution or sales plan, go to the Additional tab and select the fields.
  13. You can also search by field names.
  14. It is required to click the Validate Data button before saving the configuration or submitting the job. This is done to confirm if data matches. Any error messages on field matching will be shown. You can remove mapping (association) of the incorrect fields by clicking X next to the field or correct the data and retry.
  15. You can also clone a data row. This allows one input column value from the file to be mapped to multiple WorkSpan fields.
  16. You can Save and Submit your Import job. Submit an Import Job screen is shown.

    submitimportjob.gif
  17. Confirm your data selection and click Next. Submit an Import Job screen is displayed listing the matched fields.

    submitimportjob2.gif
  18. Click Save and Submit Job button. Confirmation message is shown. You can navigate to the Jobs page to see the status of your import job.
2 out of 2 found this helpful

Comments

0 comments

Please sign in to leave a comment.