Differences

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

--- tools:orsee:payment [14.06.2021 22:31] – s1111233@tu-dresden.de
+++ tools: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 18: / Line 18: @@
 This list contains the data that will be exported for payment:
 ^ Field Name in Excel ^ Excel ^ ORSEE ^
-| Last Name | cell B1 | cell B1 |
+| Last Name | obligatory | from ORSEE |
-| First Name | cell B2 | cell B1 |
+| First Name | obligatory | from ORSEE |
-| PSP/ Source of Funding | cell B3 | cell B1 |
+| PSP/Source of Funding | obligatory | no ORSEE entry |
-| Date of Birth | cell B3 | cell B1 |
+| Date of Birth | voluntary | from ORSEE |
-| Nationality | cell B3 | cell B1 |
+| Nationality | voluntary | no ORSEE entry |
-| Street Address | cell B2 | cell B1 |
+| Street Address | obligatory | from ORSEE |
-| Postcode | cell B3 | cell B1 |
+| Postcode | obligatory | from ORSEE |
-| City/Town | cell B3 | cell B1 |
+| City/Town | obligatory | from ORSEE |
-| Nationality | cell B3 | cell B1 |
+| Country | obligatory | from ORSEE |
+| IBAN | obligatory | from ORSEE |
+| Payment Amount| obligatory | no ORSEE entry |
+| Impersonal Account | default: 613390 | no ORSEE entry |
+| Payment Reference | default: Probandengeld | no ORSEE entry |
+| Payment Pattern | obligatory | no ORSEE entry |
+| Error Note | voluntary  | no ORSEE entry |
+| 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 |}}