Associated Items
List Search

Setup the Smart Import (3/4)

In the previous section we created our custom list with the fields that will enable the Smart Import to function correctly.  In this section we will setup the Smart Import to pull records from the database.


To access the Smart Import Pro you need to go to the List tab then click on the Design button, this will take you the Infowise Ultimate Forms Designer.


Once in Infowise Ultimate Forms Designer go to the Configure Import and Export section and click on the Import link.


Here we are going to enter:

Name: The name you want to give this import.

Polling Schedule: This is the frequency in which you would like the data imported.

Type: Database/Web Service will get us connected to Azure

Connection String: This is the connection string that we got from Azure, you can also use whatever connection work to connect to your database.

The we are going to hit the Connect button to in order for Smart Import Pro to test the connection and bring back import database information that will enable use to finish the Smart Import.


Next you will need to pick a date column that keeps track of changes in MSSQL.


In the Actions Settings we are going to pick what data is imported/synchronized and under what conditions.  

Sync list item/document - By choosing this action we are choosing to import and synchronize the same fields under the same conditions. Smart Import also provides separate actions just for Create and Update.  By splitting up the action you get the option to choose different fields and conditions to create or update.

Values to set - These are the values we are going to synchronize.

Item - This is the Primary Key field we are going to use to positively identify a record and determine if we need to import or update the fields.


After we hit the Add/Update Profile button at the bottom of the page the Smart Import will begin to run.  In the next section I will show you how we verify the import.



Last modified: 5/15/2019 8:33 PM

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 support@infowisesolutions.com to open a support ticket.
Infowise logo
© 2005-2021 Infowise Solutions Ltd
Microsoft partner logo
GSA Schedule
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.