Documentation

General information

  1. Introduction

  2. Security

  3. FAQ

  4. Comparison

Documentation for admins:

  1. Creating a Mapping

    1. Data types

    2. Lookups

    3. Empty cells

  2. User Management

Documentation for users:

  1. Importing Excel data

  2. Common errors

Examples

  1. Importing Price Lists

Roadmap

SmartUpload is actively being developed, below you can find our latest release notes and roadmap.

Releases

Version 1.0 - 6 june 2020

The first public release of SmartUpload, which has the following features:

  • Processing Excel files (XLS & XLSX) up to 1.000 rows

    • Including background-processing of the upload job

  • Separation of responsibilities:

    • Salesforce Admins can define the mapping from Excel to Salesforce objects

    • Salesforce Users can upload Excel files using these pre-defined mappings

  • Data validation on Excel files:

    • Configurable data validation on 'Text' fields (using Regular Expressions)

    • Data validation on 'Date' fields

  • Downloading results

    • Download Excel files for jobs that were having validation errors: with highlighted cells & comments to indicate on a very granular level which cells & rows failed.

    • Download Excel files containing the imported/updated rows and any errors that might have occurred

Roadmap

You may always use our contact form if you have any suggestions.

Version 1.1 - planned july 2020

  • Introduction of subscriptions for advanced features.

  • Configurable 'update' behavior when more than 1 record is found for updating (fail / update all / update first)

  • Allow admins to assign mappings to individual users

  • Download a template Excel file for a mapping

  • Automated e-mail notifications of job completion, including the output in Excel format.

  • Upgrade of input file limits to a maximum of 100.000 rows.

Version 1.2 - planned august 2020

  • Related-lookups, to allow you to specify values instead of IDs in your excel, where SmartUpload will populate the field with the corresponding record

  • Multi-sheet imports, to allow you to upload a workbook that imports a complex data structure with parent-child relationships

Version 1.3 - planned september 2020

  • Integration with SFTP, Onedrive and Dropbox for automated processing of data

If you are missing features or have suggestions for the roadmap, please use the contact form to reach out.