New features in TRANSACTION version 10.6/10.7 > Advanced mapping > Mapping Google spreadsheets

Back to

Advanced mapping

Mapping Google spreadsheets

You can use any TRANSACTION script with Google spreadsheets.

To map a Google spreadsheet

  1. In the Mapper, change the source type to Google Spreadsheets and map the fields to columns.
  2. In Google Docs, an additional column, the Error Warnings column, is available to differentiate any Google warnings from other messages. Log and Error Warnings columns can be mapped only as downloads.
  3. To save the sheet, click Save. If you are not already signed in, the Google sign in dialog box appears. Enter your Google Documents credentials. Select Stay signed in to stay signed in during a current session.

    Each file saved to Google must have a unique name. You cannot save an existing file in Google with the same name. This means that if you update mapping, you must rename the file.

  4. The Google Spreadsheets dialog box appears. Click Owned by me to view all your folders. If you have just signed on, folders must download. Although Google spreadsheets appear to have 256 columns available for mapping, some columns might not be present in your spreadsheet. If you have mapped to a column that is unavailable, you are notified which columns and cells are unavailable. You can choose to continue mapping and add these columns later or you can map one of the available columns.
  5. You can also open an existing Google spreadsheet and map it to the TRANSACTION script.

Also in this section

Editing in the Mapper

Filtering mapper settings

Advanced looping capability

Limiting input fields

Setting conditions: IF statements

Validating data

Validate by list

Compensating for missing SAP screens and fields

Undo and Undo All

Mapping long text

Converting data types to strings

Attaching documents

Auto mapping

Downloading from SAP

Editing a TRANSACTION script