SAP Mass Uploader – VBS Recorder

Complete guide to installation, recording, Excel mapping, execution, and troubleshooting.

System Requirements

Operating System

Windows 10 (64-bit, version 1903 or later) or Windows 11. 32-bit systems are not supported.

SAP GUI

SAP GUI for Windows version 7.50 or higher. SAP GUI Scripting must be enabled at the SAP system level (profile parameter sapgui/user_scripting = TRUE) and at the user level in SAP GUI Options → Scripting.

Microsoft Excel

Microsoft Excel 2016, 2019, 2021, or Microsoft 365 (32-bit or 64-bit). .xlsx and .xls formats are supported.

Runtime

.NET Framework 4.8 or higher. Available via Windows Update or Microsoft's website.

Permissions

The user account must have rights to run SAP GUI Scripting. Contact your SAP BASIS team if you receive a scripting error on launch.

Installation & Activation

Installation

Download the installer from the Download page. Run SAPMassUploader_Setup.exe and follow the installation wizard. Administrator rights are required for installation. The application is installed to %ProgramFiles%\SAP Mass Uploader by default.

First Launch

On first launch the application will run in Trial mode (7-day evaluation, limited to 50 rows per execution). No activation is required for the trial period.

License Activation

To activate a purchased license, go to Help → License → Activate License and enter your activation key. The key is validated online. An internet connection is required for activation. The license is bound to the machine hardware profile.

Transfer / Deactivation

To move your license to another machine, deactivate it first via Help → License → Deactivate. You may reactivate on a new machine after deactivation. Each Professional license allows one active machine at a time.

Recording SAP Transactions

Prerequisites

Ensure SAP GUI is open and you are logged into your SAP system. SAP GUI Scripting must be enabled (check SAP GUI Options → Scripting tab).

Start Recording

Click the Record button in the SAP Mass Uploader toolbar. Navigate to your SAP transaction (e.g., FB50, MM01) and perform the operation manually, entering sample values in each field.

Stop Recording

After completing the SAP operation, click Stop in SAP Mass Uploader. The recorded script will appear in the Script Editor pane for review.

Editing Scripts

You can review and manually edit the generated VBS script in the Script Editor. Add conditional logic, custom wait timers, or error checks as needed.

Saving Scripts

Save your recording as a .saprec file using File → Save Script. You can maintain a library of scripts for different transactions.

Excel Data Mapping

Loading Excel File

After recording, click Load Excel in the Data tab. Select your workbook and choose the target sheet. The first row is treated as the header row by default.

Mapping Columns

The mapping editor shows all recorded SAP field placeholders on the left and your Excel column headers on the right. Drag and drop columns to their corresponding SAP fields, or use the dropdown selectors.

Data Transformations

Apply formatting rules per field: date format conversion (e.g., DD.MM.YYYY → YYYYMMDD), leading zeros padding, text trimming, and value substitution maps.

Preview

Use the Preview pane to see how the first 5 rows of your Excel data will be substituted into the SAP script before executing.

Saving Mappings

Save the Excel mapping configuration as a .sapmap file for reuse. Attach mappings to script files so the full workflow can be reopened later.

Mass Execution

Execution Settings

Configure execution speed (delay between rows in milliseconds), row range (e.g., rows 5–200), and error handling behavior before starting.

Starting Execution

Click Execute in the Run tab. SAP Mass Uploader activates the SAP GUI window and begins processing each Excel row sequentially.

Progress Monitoring

A real-time progress bar shows completed / total rows. The log panel streams execution status per row including success confirmations and error messages.

Pause & Resume

Execution can be paused and resumed at any time using the Pause button. This is useful if SAP requires manual intervention mid-run.

Error Behavior

Configure how the engine handles SAP error messages: Skip & Continue (default), Stop on First Error, or Retry N Times. Error rows are collected separately.

Logs & Reports

Execution Log

Each execution generates a timestamped log showing per-row status: SUCCESS, ERROR, or SKIPPED with the SAP message text.

Export to Excel

Click Export Log to save the execution results as an Excel file. The export includes original row data alongside execution status and SAP messages.

Error Rows

Error rows are extracted to a separate Excel sheet for review and reprocessing. Correct the data and re-run only the error rows.

Troubleshooting

"SAP GUI Scripting not enabled" error

Go to SAP GUI Options → Scripting tab and check "Enable Scripting". If the option is greyed out, contact your SAP BASIS team to enable the server-side parameter sapgui/user_scripting.

Application fails to connect to SAP GUI

Ensure SAP GUI is running and a session is active. Close and reopen SAP Mass Uploader after starting SAP GUI. Antivirus software may block SAP GUI Scripting automation — add an exception if needed.

Execution stops mid-run

Check for SAP modal dialogs (e.g., session timeout or confirmation popups) that the script does not handle. Add script steps to dismiss these dialogs, or increase the row delay setting.

License activation fails

Verify that your machine has an active internet connection. If behind a corporate proxy, configure proxy settings in Help → License → Proxy Settings. Contact support if the issue persists.

Ready to get started?

Download the free 7-day trial and automate your first SAP workflow today.