Exporting to Google Cloud Storage (GCS)

Owned by Juliane Wetzel
Apr 30, 2020

Requirement: Configuring Google Cloud Storage as a Connection

A Google Cloud Storage connection with Datameer X must be created before exporting data. 

INFO

Learn about setting up a connection between Datameer X and Google Cloud Storage.

Configuring Export Jobs with Google Cloud Storage

To export a worksheet through a GCS connector:

  1. Click the "+" button and choose "Export Job" or right-click in the file browser and select "Create New" → "Export Job". The 'New Export Job' tab appears in the menu bar.
         or 
  2. Select the workbook to export from in the browser by clicking on "Select". The dialog "Select Workbook" opens. 
     
  3. Select the workbook and confirm with "Select". The name of the workbook appears in the workbook field. INFO: To take a step back during the whole process, click on "Cancel".
     
  4. Click "Next". 
     
  5. Select the worksheet to export from the drop-down menu. You will be guided to 'Connection' settings. INFO: Only kept sheets are available for export. If the drop-down is missing the sheet you want to export, modify the workbook settings to keep the sheet. 
     
  6. Select the GCS connector by clicking on "Select Connection". The dialog 'Select Connection' opens. INFO: If there's a preselected connection, you'll find it listed under 'connection'. INFO: If you haven't create the connection to GCS yet, you can do it here by clicking on "New Connection". 
     
  7. Select the relevant GCS connection and confirm with "Next". The selected connection is displayed under 'Connection'. 
     
  8. Select the file type in the drop-down and confirm with "Next". You will be guided to 'Data Details'. INFO: The selected file type must be congruent to the file type of the workbook. 
     

  9. Fill in the file path in the GCS. Activate the 'Replace data' checkbox optionally. INFO: If the data is being exported to an existing file path, the previous data is written over by the current export. 

    Example:

    /exports/%year%%month%%day%T%hour%:%min%/12354-%id%.csv → This file is being written to a new directly each time the export job runs. A new file is created each time and the old file is not deleted. 

    /exports/12354/%year%%month%%day%T%hour%%min%-%id%.csv → This file is being written to the same directly each time the export job runs. The incoming export job overwrites the previous export job.
     

  10. Fill in the advanced settings within 'Maximum file size(MB) and 'File name consecutive numbering(Digits)'. 
     
  11. Adjust the prefilled input within the section 'CSV', if needed and confirm with "Next". You will be guided to 'Mapping'.
     
  12. Have a look a the preview and decide which columns will be included and whether empty data is being accepted. INFO: All checkboxes are activated by default. 
     
  13. Decide how to handle invalid data and confirm with "Next". You will be guided to 'Schedule'.
     
  14. Select the schedule method for when the export job runs. You will be guided to 'Save'. INFO: You can add advanced schedule information, if needed. 
     
  15. Add a description. INFO: Activating the checkbox 'Export now' will start the export immediately after saving.
     
  16. If needed, add your email address in section 'Notification' and confirm with "Save". The dialog 'Save Export Job' opens. INFO: Datameer X can only send email notifications, if an email server has been configured.
  17. Select the place to save the export job under 'Data' → 'Export Jobs' and name the export job, confirm with "Save". The export job is shown in the file browser. 
     

    Â