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!
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!