Currency Import - IMPCUR – DOKA-SaaS Help & Support

Why Currency Import ??

Currency Import is an alternative way to add Currency details into DOKA.

Upload saves time and allows many Currencies to be added in bulk.

How to Import Currency :
Importing of currency comprises of two steps mainly
1. Importing of files into the system using SFTP
2. Processing of the Imported file using IMPCUR

Field Mapping

Field Length	Target Field(s)	Realization	Comments
5	-
22	CURCODTXT		Text for Codetable CURTXT
3	-
3	CURNEW\COD		Based on codetable CURTXT
3	-
1		0, 1, 2, 3, or 4	Rounding Position of the currency
1	-
1	CURNEW\DEC	0, 2, or 3	Decimal places the currency. Used for all representational purposes in the system.
1	-
1		1 = If Rounding Position = CURNEW\DEC then CURNEW\RNDUNT = 0.05	CURNEW\RNDUNT (Rounding unit of currency) Rounding unit of currency (e.g.: 0.01, 0.05, 0.10, 1) used in currency conversions into the currency. Rounding is optional, thus depending on the transaction and other factors rounding might be switched on or off.
1		2 = if Rounding Position = CURNEW\DEC + 1 then: if CURNEW\DEC = 0 RNDUNT= 1, if CURNEW\DEC = 2 RNDUNT= 0.01, if CURNEW\DEC = 3 RNDUNT= 0.001, else RNDUNT = 0
1	-
1		1 = 1	Used to define CURNEW\BAS (Exchange Rate Calculation Base)
		2 = 100
		3 = 1000
1	-
9	CURNEW\DIF		This field contains the maximum allowed (plus or minus) tolerance from the last valid middle rate, when importing or entering daily exchange rates. Should an entered exchange rate exceed this tolerance limit, an error message is issued and the entered rate is not updated to the database.
86
139

Let us look into this in detail :

Importing of files :
Follow article FTP - File transfer using Putty to know more about FTP

Please follow the below gif and the step mentioned to upload files into the system :

1.Set up the putty configuration as shown

2.Select the file to transferred .Do a drag and drop

3.Execute the command in DOKA .Incase of Currency upload follow section Processing of files

Processing of files :
Transaction IMPCUR:
This transaction is used to import currency into the database of the application.
The text file to be imported is selected via path and file name and will be imported by clicking the icon.
The log file for this transaction can be displayed by clicking the icon . The log shows information about the updated and added records.
Note: The subdirectory BATIN must be created in the DATA directory of the application. The converted import file has to be in that subdirectory. The structure of the import file has to be available in ASCII format and has to have a .txt extension.

The following steps are needed process the imported file :

1.Navigate to transaction "IMPCUR".

2.Select the file path and file name from the drop down available

3.Click upload Icon on top left