administrationMAIN_orange.png

AD-201: Data Import and Export

This class will cover the methods provided by SAP for the import and export of data into a Business One database.  It includes the Data Transfer Workbench, Copy Express, and the Data Import/Export utilities (Import from Excel and Import/Export Transactions).

    Target Audience

  • IT Managers
  • Power Users

    • Prerequisite

  • General knowledge of Business One data entry procedures
  • Understanding of Business One tables and fields
  • General knowledge of Microsoft Excel

    • Course Content

  • Overview of Import and Export Tools
    • Pros and Cons
    • What NOT to do
  • Using Data Transfer Workbench
    • Uses of DTW
    • Installation and Login
    • DTW Templates
    • Populating DTW spreadsheets
    • Running DTW
  • Using Copy Express
    • Uses for Copy Express
    • Configuring the Add-On
    • Copy Express Setup
    • Populating DTW spreadsheets
    • Running Copy Express
  • Data Import/Export
    • Uses of the Import/Export Utilities
    • Data Import
      • Import from Excel
      • Import Transactions from SAP Business One
    • Data Export
      • Export Transactions to SAP Business One
dashes.png
$250.00
Administration 201 - Data Import and Export
This class will cover the methods provided by SAP for the import and export of data into a Business One database. It includes the Data Transfer Workbench, Copy Express, and the Data Import/Export utilities (Import from Excel and Import/Export Transactions).