Admin – Data Import

Session 1

Data Import Tools Overview

This session will provide you with an introduction to the data import tools within the Unit4 ERP toolkit:

You will cover:

• Common Data Import Tools
• Excel Work Sheets
• Running the BIF Process
• Running the Data Load Process
• Comparison of BIF & Data Load
• Running the Excelerator Process

Session 2

Introduction to the BIF (Batch Input Formatter)

This session with introduce you to the BIF, and the batch import processing elements needed to use this tool:

You will cover:

• Importing Data using Batch Input6
• Loading Customer Data Using
• Writing your Data Import File
• Running the Batch Input Process
• Checking Maintenance of Batch Input
• Checking the Customer Master Files
• Loading a General Ledger Journal
• Write the File to the Data Import Folder
• Creating the Data File
• Running the Batch Input Process
• Checking the Loaded GL Transactions
• Checking the GL Transactions

Session 3

Data import using the Excelerator add-in tool

This session will give you an understanding of the importing process using the Unit4 ERP add-in Excelerator.

You will cover:

• Introduction to Excelerator
• Using Postback

Session 4

Introduction to the Dataload tool

This session will give you an understanding of the Dataload tool which is a separate Unit4 module for importing data using standard system functions.

You will cover:

• Importing Data Using Data Load
• Loading Attribute Values
• Create the New Attribute
• Writing the Data Import File
• Running the Data Load Process
• Checking the Attribute Values
• Importing Data into Flexi-Fields
• Confirming the Flexi-Field Group Name
• Creating the Schema / Control Sheet
• Creating the Data Sheet
• Completing the Flexi-Field Load
• Importing Flexi-Fields

Premium Education training subscription

Part of the College of System Admin

Premium Education training is a people-centric approach to driving training and development by always learning; learning all ways. Our subscription-based training services gives the employee and employer a suite of Unit4 training allowing the flexibility to empower your employees for effective, efficient, and proficient use of technology and solution platforms at their fingertips.

More details about Premium Education will be coming soon. Watch this space!

In the mean time if you would like to know more email [email protected]

Cancellation policy

All courses are delivered virtually, price per person plus VAT. On site training is available on request. Please read our cancellation policy and booking terms and conditions before checkout.

Language

Interactive workshop with an experienced consultant. All Embridge Unit4 courses are currently delivered in English.