Import Parts, Customer Order Lines, Engineering Masters, Defaults, & MORE

Introducing GingerHelp’s Excel to VISUAL ERP Import Application that provides the ability to do mass imports of data from Excel spreadsheets into Infor VISUAL Enterprise ERP.

Start with an Excel Template…

Then, Enter Your data…

Finally, Run the import application

The Excel to VISUAL Import application will then processes the Excel template, importing the data into the Visual database.

The Excel to VISUAL Import application will log each part and/or item to the application window and an ExcelToVISUALImport_Results.txt log file. It will also log any errors that occur during the import process and indicate where to look in the Excel template.

The process begins with an Excel template:

Engineering Master Templates examples:

Defaults - Single values used on one or more templates:

Hover Notes – Offer support on select fields:

The Excel to VISUAL Import application will then processes the Excel template, importing the data into the Visual database.

The Excel to VISUAL Import application will log each part and/or item to the application window and an ExcelToVISUALImport_Results.txt log file.

The Excel to VISUAL Import application will also log any errors that occur during the import process and indicate where to look in the Excel template.

Settings will allow a user to save a password and an Advanced User – which is password protected – to either set the Maximum Import Rows or Disable Max.