New features in our Import component June 2018
Vladi Gubler
Vladi Gubler
June 08, 2018 | Products


Just a couple of updates in our Import component. As you know, it's a great tool for setting up automated processes of importing data from a variety of external sources: emails, databases, Excel files, text files and web services. You can use it to create Help Desk solutions, approve your items by simply responding to an email, syncing data from external applications and much more. And with our advanced mapping and conversion capabilities, you are not limited to simply dumping your external data into SharePoint lists; you can filter, execute calculations, update existing items and parse emails, giving you the full control you need to create sophisticated, connected applications that run in the background and require no human intervention.

With our new version (already released in O365 and coming soon on premises), we now support the following features:

  • Exporting and importing import profiles - you can now export your existing import profiles and then import them anywhere. You can import into the same list to create a copy that you can then modify or you can import into a different list, even on a different tenant, to transfer your settings without having to recreate the whole profile by hand.
  • Smart data type recognition in CSV/TSV files - until now, when you set up an import of a comma-separated or tab-separated files, we used the first row from the file to determine what data type each column contains. Our product ensures that all column mappings are done in accordance to the data type, so for example you won't be able to map a text column to a date field in SharePoint, as it would result in errors when trying to import. The issue with only analyzing the first row was that it was not always a good indicator for the rest of the file. For instance, the first row might contain a numeric value in a column, but some other rows might contain text for the same column. If we designate this column as a number based solely on the first row, it will cause errors when we reach a row that contains text. Now we will scan the entire file and ensure that the data type of each column remains consistent and always defaults to text if more than one type of data is found. That ensure smooth and trouble-free operation and less administrative overhead.

I would like to take this opportunity to give a short explanation in regards to Start Time and Last Update date parameters of the import profile. Our component has a built-in ability to import data incrementally, skipping over items already imported in the past. This way we ensure that the import process runs faster and creates no duplicates. We do it by allowing you to designate one of the columns in the data source as an Update Date column, basically Last Modfied date of an item (you don't need to do that when working with emails, as we will just use the date the email was delivered). On the profile itself we store the latest item's date under Start Time property. When we run the import, we make sure the items being imported are newer than Start Time and then update Start Time accordingly. This property is required on some data providers (such as emails, where it's configured implicitly or database, where you are required to provide it); on others, such as CSV/TSV files, it's optional. If the Last Updated property is not set, we will always import the whole file. Start Time can be specified when you first create an import profile and cannot be changed afterwards, as later it's used for internal logic. By default, when you create a profile, Start Time will be set to the current time, but you can change it if for example you want to import a backlog of items.


Add your comment

Comments are not designed to replace support calls. If you have a specific issue with one of our products, please send an email to to open a support ticket.


Build powerful business applications in SharePoint using only your browser.
100% No-Code Solution

It's never been easier, to create, innovate and share, all you need is your web browser!


Address business process pain points immediately. Save time and money.

Fantastic Support Team

Facing difficulties installing the application? Contact our fantastic support team.

Related Topics

What is right for you?

Online Trial

Not ready to install yet? Create a trial site in our environment
  • Full control of the site and its settings
  • Optionally pre-install one of our solution templates
  • Site provisioned instantly
  • Automatically removed after 30 days
  • Available to everyone!


There was an error processing your request.
Please contact us for further details.


Install in your own environment, on Microsoft 365 and on premises
  • Start working with real users and data
  • Install online or on premises
  • Register for 30 day trial
  • Seemlessly convert to paid license
  • Requires administrator permissions


Download link has been emailed to .
If you do not receive it within 5 minutes, please check your spam.
The link is valid for 72 hours.
If you are having problems, please contact us.


There was an error processing your request.
Please contact us for further details.
Technical details:

Request a Live Demo

Book an appointment for a one-on-one with an ULTIMATEforms expert trainer.

Test drive the awesome power of ULTIMATEforms

Learn how to quickly and easily turn time-consuming business processes into automated, efficient workflows.

Have a strong start

Only thirty minutes of well-coached time can translate into great future savings in time and money. So, sit back and enjoy the ride.

It's Free

Learn how to address business process pain points immediately. Save time and money.