UltimateForms: Import
Set up automatic import of emails and database items into any SharePoint list or library to generate or update list items or documents
UltimateForms:
Import
, formerly 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
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
- 2/6/2023 : Build Your Own Offline PDF Forms for Automatic Import to SharePoint
- 11/29/2022 : Advanced import options for Exchange Online
- 1/8/2021 : Importing SMS text messages into SharePoint
- 6/8/2018 : New features in our Import component June 2018
- 5/29/2018 : Automatically import Excel files into SharePoint lists
- 12/13/2016 : New - import CSV files into SharePoint
- 11/18/2016 : Importing data from Microsoft Azure's cloud MSSQL Database
- 11/16/2015 : Importing emails into SharePoint lists
- 9/24/2013 : Automate business processes with $Extract function
- 7/25/2013 : Synchronizing DB tables with SharePoint lists
Features
| Feature | Image | Our Product | SharePoint Native |
|---|---|---|---|
| Import emails into document libraries |  |
|
|
| Import emails or database items into any list type |
|
|
|
| Update existing item with the imported data |
|
|
|
| Automatically sync list, creating or updating items as necessary |
|
|
|
| Set up multiple profiles and multiple email accounts for a single list | |
||
| Set up multiple Create and Update actions for each profile | |
||
| Works with any POP/Exchange account | |
||
| Works with any database (MS SQL, Oracle, OLE DB, ODBC) | |
||
| Works with SOAP and REST web services | |
||
| Set up condition to filter the items to import | |
||
| Imports attachments from emails and binary files from DB | |
||
| 100% web-based, no client installation | |
|
|
| Localized into English, French, Spanish and German | |
|
Note: unless specifically stated otherwise, all products require only SharePoint 2013 and up. Except for SharePoint Online apps, all of our products must be installed as farm solutions.
Want to get notified when new versions come out? Subscribe to our RSS feed now!
| Version | Release Date | Changes |
|---|---|---|
| 1.18.4 | 27-Mar-2023 |
|
| 1.18.3 | 02-Mar-2023 |
|
| 1.18.2 | 13-Feb-2023 |
|
| 1.18.1 | 12-Jan-2023 |
|
| 1.18.0 | 15-Dec-2022 |
|
| 1.17.2 | 06-Sep-2022 |
|
| 1.17.1 | 21-Aug-2022 |
|
| 1.17.0 | 11-Jul-2022 |
|
Although this feature can be purchased and installed separately, we highly recommend always installing the complete UltimateForms suite. It will ensure you are not limited in any way when implementing your business solutions and achieve the best possible result.
$35.38
per server per month, includes support
No Credit Card. No Obligation.
We offer special discounts to non-profits, educational or government organizations
