User Tools

Site Tools


tools:orsee:payment

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
tools:orsee:payment [14.06.2021 22:43] s1111233@tu-dresden.detools:orsee:payment [23.10.2025 13:47] (current) aguilera_tu-dresden.de
Line 7: Line 7:
 \\ \\
 \\ \\
-From now on, the ORSEE database automatically exports all entries of the particular experiments on every 15th of the month and saves the data of the last 4 months (using the variable date of survey) under the export date (format YYYYMMDD) and the corresponding experiment name (e.g. //20210316 -ITC Biasing 2.0 Eyetracking.csv//).+From now on, the ORSEE database automatically exports all entries of the particular experiments on every Sunday and saves the data of the last 4 months (using the variable date of survey) under the export date (format YYYYMMDD) and the corresponding experiment name (e.g. //20210316 -ITC Biasing 2.0 Eyetracking.csv//).
 \\ \\
 \\ \\
 \\ \\
-**File location:** [[\\vs-grp02.zih.tu-dresden.de\nic_projects\ORSEE_Payments\]]\\ +**File Location:** [[\\vs-grp02.zih.tu-dresden.de\nic_projects\ORSEE_Payments\]]\\ 
-An authorization for this file can be requested by contacting <veronika.wetzlich@tu-dresden.de>.+An authorization for this file can be requested by contacting <jens.strehle@tu-dresden.de>.
 \\ \\
 \\ \\
Line 34: Line 34:
 | Error Note | voluntary  | no ORSEE entry | | Error Note | voluntary  | no ORSEE entry |
 | Date of Data Collection | not in Excel | from ORSEE | | Date of Data Collection | not in Excel | from ORSEE |
 +
 +In this folder (//see **File Location**//) can be found an Excel file (//'NeuSapZahlungen1.2s_js.xlsm'//), which you should save locally.\\
 +
 +With this file you can import several exported csv files, check the IBAN information and send this file to the SFB940 coordination office.\\
 +
 +These respective Excel files can be combined and sent to the SACHGEBIET 1.3 - DRITTMITTELVERWALTUNG. The import of the documents will be done in SG 1.3. only with instruction of the original, which should be submitted on paper at the same time please.\\
 +\\
 +\\
 +The following macros are used by this Excel file:
 +{{ :tools:orsee:orsee:makros_orsee_payment.png?1000 |}}
 +
 +\\
 +To be able to start the macro, click on:\\
 +
 +Datei-> Optionen-> Trust Center-> Einstellungen für das Trust Center-> Makroeinstellungen \\
 +
 +and select option 2 (**Alle Makros mit Benachrichtigung deaktivieren**).\\
 +
 +{{ :tools:orsee:trust_center.png?1000|}} \\
 +\\
 +\\
 +
 +After starting the program, you will see a security message that must be confirmed by clicking the 'Inhalt aktivieren' button.
 +
 +{{ :tools:orsee:sap_payment.png?1000 |}}
 +
 +
 +
 +
 +
 +
 +
  
  
tools/orsee/payment.1623710620.txt.gz · Last modified: by s1111233@tu-dresden.de