UltimateForms Smart Import Pro

Smart Import Pro
Set up automatic import of emails and database items into any SharePoint list or library to generate or update list items or documents
Smart Import Pro, a component of UltimateForms, automatically imports emails and data from line-of-business applications into SharePoint lists and document libraries.
  • Import emails with attachments
  • Import items from any database (MS SQL, Oracle, OLE DB, ODBC, My SQL)
  • Import items from any SOAP and REST web services
  • Import items from comma and tab delimited text files
  • Import items from Excel files
  • Import into any list, wiki library or document library
  • Specify you own schedule for imports
  • Specify unlimited import profiles for a single list
  • Use the imported data to generate new list items, wiki pages or document, update existing ones or automatically sync lists
  • Extract data, such as IDs from any text, e.g. email "Approve item #12" to approve an item with ID 12
  • Map imported data to list columns the way you want
  • Set conditions on which items to import
  • View import history with a click
  • Localized into English, French, Spanish and German
Read our blog entry for step-by-step instructions on how to build the service center business application.

When you want to initiate a business process based on information coming from an email or from a line-of-business application, you need to get that information into a SharePoint list first. Unfortunately, the incoming email feature of SharePoint is cubersome and limited and will only work with document libraries and discussion boards. Importing data from databases requires external tools or custom development

With Smart Import Pro, you can define import profile using just your browser. Create a new profile, set up a schedule, point it to a mail account or a database and decide what you want to do with the incoming data (create new items, just the way you want them or update existing items, you can even extract the ID of the item to update from any text fields, such as email subject line). That's it, your import profile is ready to start working, no hassle.

  • Generate service requests based on email messages
  • Start your business processes based on SQL triggers and data

Blog

Features

Feature Image Our Product SharePoint Native
Import emails into document libraries caption   Included  
Import emails or database items into any list type   Included  
Update existing item with the imported data   Included  
Automatically sync list, creating or updating items as necessary   Included  
Set up multiple profiles and multiple email accounts for a single list caption   Included  
Set up multiple Create and Update actions for each profile caption   Included  
Works with any POP/Exchange account caption   Included  
Works with any database (MS SQL, Oracle, OLE DB, ODBC) caption   Included  
Works with SOAP and REST web services caption   Included  
Set up condition to filter the items to import caption   Included  
Imports attachments from emails and binary files from DB caption   Included  
100% web-based, no client installation caption   Included  
Localized into English, French, Spanish and German caption   Included  
Note: unless specifically stated otherwise, all products require only SharePoint Foundation 4.0/5.0. Microsoft SharePoint Server 2010-2016 is supported, but not required. Except for SharePoint 2013-2016 apps, all of our products must be installed as farm solutions.
Some apps can be used both on Office 365 and on premises, but most will not work on premises. App support must be enabled on your on-premises farm. You can install app both from the Office Store and by downloading the .app file from our website, in some cases the latter option provides more functionality, but also requires your consent to a higher level of permissions.
Want to get notified when new versions come out? Subscribe to our RSS feed now!
Version Release Date Changes
1.13.1 05-Sep-2018
  • Adjusted access to SharePoint-located files, using API first
  • Fixed: column recognition in delimited text files
1.13.0 17-Jul-2018
  • Added: import Timer jobs are now site-collection scoped, instead of web application
  • Added: option to import from Excel files
  • Added: profile description field
  • Added: Run now option along with a schedule type of None
  • Added: capabilities to export and import profiles
  • Added: MySQL provider. See documentation about connector configuration
  • Added: enhanced logic to handle column types in text files importing and headers row recognition
1.12.1 04-May-2018
  • Fixed: file import failure on date-time values
  • Fixed: issues in editing file import profiles
1.12.0 14-Feb-2018
  • Added: keeping Actions when data source information is changed. Non-existing fields will be marked with ???
  • Added: option to add and override request headers for REST and Webservice imports
  • Added: disabling throttling on import log list
  • Added: enhancements in parsing Json response of REST imports
1.11.4 08-Jan-2018
  • Enhanced REST import logic
  • Fixed: making Update date column setting optional in service profiles
1.11.3 22-Nov-2017
  • Added: support for schema names in DB profiles
  • Enhanced old log entries removal logic
  • Fixed: reset of Associated Items column value
1.11.2 11-May-2017
  • Added: option to specify value for Created By field in Create item action
  • Added: option to specify Folder path in Create action
  • Added: generating an initial value for Associated items columns
  • Fixed: replacing all blank space character with a space in StripHtml
  • Fixed: deleting emails after import
  • Fixed: preventing log errors when there no emails to import
1.11.1 10-Jan-2017
  • Fixed: handling empty values in conditions
$35.38
per server per month, includes support
No Credit Card. No Obligation.

We offer special discounts to non-profits, educational or government organizations

$849
Perpetual license for one server, including first year of support
$149
Developer License per server
$169
Annual Support Renewal per server

Copyright © 2018 - Infowise Solutions Ltd

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.

Eastern time zone (GMT-5)