Importing Excel Spreadsheets using an UBE

[pfaloney]

We will be starting the process of moving from 8.12 to 9.1 and are looking to "retire" very old VB6 (yes 6) programs by converting them to UBEs. This will allow for better auditing of what is imported.

I have already resolved how to handle multiple files in the drop zone but have not figured out how to handle Excel files without converting them to a text format (.txt or .csv) or creating a custom business function (which we really do not want to do).

Screen Imports will really not work either since a single like will populate multiple tables.

Anyone have any solutions?

 

[jdelisths]

How about the best of both worlds? Let the user use Excel and upload the data straight to EnterpriseOne with full auditing and no circumvention of JDE application logic. Take a look at our Excel upload videos at: http://www.youtube.com/user/aelliuslynx

 

[Scott Beebe]

There is no STD way to pick up and import excel files in E1 except via the grid. You will need to use a custom tool as explained Hari or create something custom.

 

[DBohner-(db)]

Patrick,

I confirm with Scott - no native functionality.

It would be seriously interesting to see how someone would complete an Excel (XLS) import from inside the toolset, though.

(db)