Data Upload

Key features

Users can access the tool from within their web browser
Access as a separate web page or access from within EOne using Café One
Log in with your JDE user credentials authenticated against JD Edwards
Simply drag and drop your preformatted Excel templates onto the “drop area”
Automatic push of the data from the Excel template to the AIS Server
Data is entered in forms as if users are doing manual entry
Application of native JDE EOne validation rules apply

More benefits

Easily edit existing data
Quickly add new data records
All data is validated online
No more manual entry – automate mass uploads
No modification to JD Edwards EnterpriseOne necessary

The challenge

You’d like to add supplier items to your item master and item branch file along with the new supplier pricing catalogue? Or you have to change address book classifications for a whole set of customers and no mass update program is available? With this JDE E1 add-on you can update or add data records in JD Edwards EnterpriseOne on the fly, online, and validated against standard JD Edwards EOne constraints.

How it works

Add your data to the Excel template and then either drag and drop it into the add-on software or upload it via your file explorer. The add-on software communicates with your JD Edwards EOne system to either add, update or delete your records. If errors occur, a detailed list shows you which records had issues. Simply correct the data in the Excel template and drop the sheet again.

A whole set of template forms for Item Master, Item Branch, Address Book, Supplier and Customer Master as well as Manufacturing Data, Forecasting, Cost Components and many more are already available. Additional form templates are developed on request.

JD Edwards integration

This add-on is a cloud solution that connects to your JDE E1 environment. All you need to run it is a web browser (such as IE, Firefox or Chrome).

On the more technical side-of-things this solution is using JD Edwards EOne Application Integration Server (AIS), so that no modification to your JDE environment is necessary.