Project

General

Profile

Rkeeper csv » History » Version 5

Version 4 (Robertas Virpša, 05/03/2022 12:59 PM) → Version 5/6 (Robertas Virpša, 05/03/2022 01:01 PM)

h1. Rkeeper csv

1) Downolad installation files

!picture273-1.png!

2) Configure FARCARDS.INI

[FarServer]
Type = 1
DLL = Ericsoft.dll
Gate = 1
XMLCP=1251

[LinkDLL]
1 = pds_netk

[pds_netk]
NetServerName=ERICSOFT_RK
ininame=netk.ini

3) Install Farcards.exe with parameter /install (run cmd administrator rights Farcards.exe /install)

4) Go to the directory Ericsoft HTTP service and run EricsoftRK7srv.exe with parameter config (EricsoftRK7srv.exe config)

5) Configure SQL connection

!picture273-2.png!

6) Configure EricsoftSrv.config

<Settings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SaleCatIDs>
<string>12=147</string> *(12 keeper report category code = ericsoft sell item code. For example if you want to split alcohol)*
</SaleCatIDs>
<CurrencyCodesToIgnore />
<SqlConnection>mrFpXilp6ZMwANSBiW4nrqUjIHFj67IS1Bi95mm1H1JEiCmu26Hkg8MQOn6T1dw4LgTSvn/taVPhGiv24+Y7pu9Gmz58DTuBLhcORRt4UM2YQmLZOAnS2xB0mUtwrPGHZUf/9HyEQqtYfBZpEexaNg==</SqlConnection>
<Rk7SqlConnection />
<DefaultProductCode>809</DefaultProductCode> *(default ericsoft sell item code)*
<ExportDir>C:\UCS\Ericsoft\FARCARDS_ERIC\IMPORT\import.csv</ExportDir> *(directory where to export payment file)*
<ExportDirForNonCardTx />
<Rk7SalesCode>0</Rk7SalesCode>
<Rk7SalesAsignToBookingId>0</Rk7SalesAsignToBookingId>
<Debug>true</Debug>
<DBName>HOTEL</DBName>
<Rk7DBName />
<EricsoftUserName>RK7</EricsoftUserName>
<BindToPort>34455</BindToPort>
<HotelID>1</HotelID> *(Hotel ID in database. Default=1)*
<TransVerificationTimeout>30</TransVerificationTimeout>
<SalesExportRoomNo>0</SalesExportRoomNo>
<SalesExportProductCode>0</SalesExportProductCode>
<SalexExportUser>RK7</SalexExportUser>
<SalesExportAtTime>04:00</SalesExportAtTime>
<SalesExportFileName>export.csv</SalesExportFileName>
<LastSalesExportDate>2018-01-01T00:00:00</LastSalesExportDate>
<SalesExportEnabled>false</SalesExportEnabled>
<TimeoutForSalesDbRecord>15</TimeoutForSalesDbRecord>
<DiscountPercentageForPromoCode>10</DiscountPercentageForPromoCode>
<PrefixForProtocolQuery>999</PrefixForProtocolQuery>
</Settings>

6) Install EricsoftRK7srv.exe with parameter install. (EricsoftRK7srv.exe install)

7) Create a workstation in ericsoft

!picture845-1.png!

8) Configure the workstation

!picture845-2.png!

9) Open C:\UCS\Ericsoft\Programs\server.exe with parameter /gui

10) Enable workstation

!picture845-3.png!

!picture845-4.png!

11) Set file directory

!picture845-5.png!

!picture845-6.png!

12) Rkeeper configuration

a) MCR

function MCR1001119(DeviceSignal: Integer; DeviceIdent: Integer; var Parameter: String): Boolean;
begin
Result := True;
if (length(Parameter)=3) then
Parameter:=Parameter;
end;

!picture155-1.png! !picture702-5.png!

b) Interface

!picture702-1.png!

Copy pds interface

!picture155-2.png! !picture702-2.png!

!picture702-3.png!

!picture702-4.png!

Add picture from clipboard (Maximum size: 542 MB)