--- title: "Configuration Raw Data Export" slug: "configuration-raw-data-export" updated: 2024-07-04T10:25:58Z published: 2024-07-04T10:25:58Z canonical: "docs.mapp.com/configuration-raw-data-export" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.mapp.com/llms.txt > Use this file to discover all available pages before exploring further. # Configuration You can schedule automatic raw data exports at specific intervals based on your configurations in Mapp Q3. To set this up, follow these steps: 1. Log into Mapp Q3. 2. Go to *Configuration > Raw Data Export*. The configuration dialog for raw data exports will open. These necessary settings are described below: ### **Raw Data Export** Configure the basic settings for the raw data export. 1. Under the tab **Raw Data Export**, make the following basic settings: ![](https://cdn.document360.io/554b9b98-6720-4d8b-9919-c7b203d72648/Images/Documentation/8afe2ce3-04c5-44a9-a931-0d5650341c2e.png) | Parameter | Description | | --- | --- | | Enable Raw Data Export | Activate the feature using the corresponding radio button. | | CSV Field Separator | Specify the character that separates the individual table entries from each other. Select the separator you want from the drop down list: - Semicolon (;) - Comma (,) - Space - Tab - Custom > [!WARNING] > The following characters cannot be defined as separators: > > - Hyphen (-) > - Tilde (~) > > A semicolon automatically replaces these. | | CSV Field Delimiter | Specify the character used to delimit table entries (that is, the character before and after each table entry). Select the desired field delimiter from the drop-down list: - None - Apostrophe (') - Quotation marks (") - Custom > [!WARNING] > The following character cannot be defined as a separator: > > - Hyphen (-) > > Please use only those characters as "Custom characters" that do not appear in the table entries. Furthermore, field separators and field delimiters must differ from each other. | | Dispatch Window | Specify when a raw data export is to take place: - **Daily** The data tables contain the data for the previous day. This includes data from all sessions that were started in the period. Therefore, data records from the following day may also be included if a session lasts beyond midnight **Example** A user starts a session at 11:45 p.m., which lasts 30 minutes, i.e., ends at 00:15 a.m. > The export takes place as soon as the data for the previous day has been entirely written (daily closing). - **Daily at 00:00 o'clock** The data tables shall comprise the data set from 10:00 p.m. on the penultimate day to 10:00 p.m. on the previous day. - **Hourly** The tables contain the data of the closed sessions of the last hour. > [!WARNING] > This option is not available by default. For activation, contact the Mapp Support Team. - **Custom** The period that the data tables are to cover can be set individually. With the button [Start export] you initiate the export ad-hoc, see [Custom Export](/v1/docs/individual-exports-and-export-status). > This process may be carried out a maximum of 10 times per day. Further execution can take place immediately - there is no need to wait for the tables to be received for any previous export. | 2. Click **Save**. --- ### **FTP Account Data** Specify the connection details for the target server where the raw data tables will be sent. ![](https://cdn.document360.io/554b9b98-6720-4d8b-9919-c7b203d72648/Images/Documentation/8f75e9f7-f260-4ff0-8dcd-2a7b2f91b70e.png) Proceed as follows to configure the FTP access data: 1. Make the following settings: | Parameter | Description | | --- | --- | | Data Source | Select the protocol with which the data is to be sent: - FTP - SFTP - FTPS (SSL) - FTPS (TLS) | | Host | Specify the IP or URL of the server on which the data is to be stored. | | Remote Path | Select the directory on the target server in which the raw data files are to be stored. The directory must always be specified as absolute. | | Login | Specify the user to be used to login to the server. > [!WARNING] > The selected user must have write permissions on the specified target server. | | Authentication | Select the authentication option using the corresponding radio button: - Password - Pivate key | | Password | Enter the password or private key (in the case of SFTP with key pair). | | Port | Usually, the default ports are specified. However, you can define alternative ports. | 2. The button **Test connection** allows you to check whether the server can be addressed with the entered data and whether it is possible to change to the specified directory. 3. Click **Save**. --- ### **Export Data** Select which raw data tables should be included in the export. ![](https://cdn.document360.io/554b9b98-6720-4d8b-9919-c7b203d72648/Images/Documentation/96edfadc-c7a9-48b9-922d-da6f91222873.png) 1. First, select via the corresponding radio button whether an export summary file should be created or not. > The export log file is a CSV file that contains the following information: > > - exported tables > - export time > - number of rows in exported tables > - file size This file is transferred last and only when all tables have been successfully transferred and can be used as a signal to start further processing for systems that process the raw data. **Example log file** ![](https://cdn.document360.io/554b9b98-6720-4d8b-9919-c7b203d72648/Images/Documentation/83d98c4c-361c-4fbc-a88c-e7db96dafec4.png) 2. Use the radio button to select which tables the export should contain. 3. Click **Save**.