When using the Generic Import wizard with the Aptify Desktop interface to import a Microsoft Access/Excel 2013 or 2016 file, the import may fail if running the 64-bit version of Microsoft Office 2013 or 2016. The error that is generated is: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The import fails because the user's computer has the 64-bit version of Access/Excel 2013 or 2016 installed, while the Aptify shell requires the 32-bit version. The current workaround for this issue is to install the 32-bit version of the Access Database Engine Redistributable on the user's computer. You can download the redistributable here: https://www.microsoft.com/en-in/download/confirmation.aspx?id=23734. Once the Access Database Engine Redistributable is installed, the user's computer must be restarted. |
After you have created or identified a suitable Import Source for your import file (see Creating Import Sources), you can run the Generic Import wizard.
Follow these steps:
For example, if the data in the Culture source column is text (such as Spanish) and this column maps to a CultureID linked field, then Aptify can lookup the ID for the Cultures record whose name is Spanish and return the appropriate ID. This ID can then populate the CultureID field in the new record created from the import data.
The Lookup feature applies only to entities whose Name field is Unique (in other words, the Unique option is selected on that Entity Fields record that also has the Is Name option selected). This feature does not support entities whose records can share the same name. |