Friday 28th Feb 2020

0 Products |
0.00 ₴

Your Cart

Total
Sum total:
0.00 ₴
Go to cart
Wednesday, 04 December 2013

Structure of files for CashFront 3.5.5.0

Rate this item
(0 votes)

In the process of work with СashFornt(further program) text files are used for storage and exchange by data(contained in the catalogue of synchronization). These files give an opportunity to export new data in the program and import data in external applications(бек-офис). A catalogue with data(Catalogue of synchronization) contains four subdirectories: "Price", "Jornal", "Sales" and "Invoice". These subdirectories serve for consolidation to monotonous information:

"Price" - Contains information about a current price(articles or commodities), discount maps, discounts and bits and pieces of commodities now implementations of the program.

"Jornal" - Contains the accumulated information about the conducted operations in the program(heading of checks), information is fragmented on twenty-four hours, every file contains the programs given about the last twenty-four hours of work.

"Sales" - Contains the accumulated information about the conducted operations in the program(decoding of checks on the articles), information is fragmented on twenty-four hours, every file contains the programs given about the last twenty-four hours of work.

"Invoice" - Serves for the import of data about the articles and bits and pieces from external applications, after the capture of files automatically clears up the program.

For synchronization of data it is assumed to use one catalogue of synchronization a few copies of the program, set on different computers, however it is necessary to notice that such mode considerably reduces the faulttolerance of the system on the whole, work of the system will straight depend on availability of network folder with data. Initially the program was designed on work with an individual catalogue with data, and in such mode the system functions maximally reliably.

Catalogue of "Price" :

Serves for the apartment of files with incoming data from a бэк-офиса, price, discounts and discounts. Can will change a бэк-офисом during implementation of the program.

price.txt: file of data about the articles

disc.txt: file of data about discount maps

promo.txt: file of data about actions and discounts

unsgoods.bin : file of data about bits and pieces of commodity, binary format *

transact.log : Ravine file with information about the last transaction, retires after successful completions of transaction *

* these files it is not recommended to change or create the extraneous programs, they contain official data and participate in transactions.

Catalogue " of Jornal" :

Serves for the apartment of files with going out data from CashFront, contains the identifiers of operations(checks) with descriptions and signs. Can will move away a бэк-офисом during implementation of the program.

The names of files contain the value of date, every file is formed for current twenty-four hours :

ДД.ММ.ГГГГ.txt: where ДД-дата. number, ММ- month, ГГГГ is a year. Data about cotter pins

Participates in unloading of data on фтп ( file of "fcДДММГГГГ.txt").

Catalogue of "Sales" :

Serves for the apartment of files with going out data from CashFront, contains decoding of commodity positions of operations(checks) with identifiers. Can will move away a бек-офисом during implementation of the program.

The names of files contain the value of date, every file is formed for current twenty-four hours :

ДД.ММ.ГГГГ.txt: where ДД-дата. number, ММ- month, ГГГГ is a year. Data about cotter pins

Participates in unloading of data on фтп ( file of "fsДДММГГГГ.txt").

Catalogue of "Invoice" :

Serves for the apartment of files with incoming data from a бек-офиса, after the file locking the program clears a catalogue automatically. Files must have obligatory expansion of "ИмяФайла.INV", ИмяФайла -произвольное, line with the identifier of incoming invoice.

Contains the new articles or changes in old one, an amount, sign of setting of amount, can plug in itself additional data about discounts on a commodity(article).

 

DECODING OF THE FIELDS OF FILES


price.txt: file of data about the articles

For loading of data about the articles(commodities) from the external programs a file is used price.txt. File price.txt intended for updating of costs of commodities and input of new commodities, and also blocking of existent commodities. It a file can be used for the simplified communication of data from a бек-офиса, if cashdesks are located within the limits of local network(the mode of account of bits and pieces is a power-off). In the synchronous mode (two or more than cashdesks that useone catalogue of exchange data) this file serves as for synchronization of the articles between cashdesks. Space of codes can intersect in these files, for the article matters unique steam of codes(a code | is a stroke-code) in case of coincidence information about the article will be substituted for by the last record. Every line in this file means information about a commodity. Information about a commodity divide inter se Example of file fragment is acquainted "|" :

 

2683|4607014270038|Vodka of Немирофф 05Lait|rubble.|45.50|0.00|FISCAL|1|0|0

1037|4607006371026|GOLD 250г Флекс Корн №6|шт.|14.50|0.00|PRINTER|1|0|0

 

Setting of the fields :

|||<Ед>||||<НГ>||

Where:

A code is a number, 5 signs, internal code of commodity

A Stroke-code is a number, 13 signs. stroke-code of packing of commodity

The name is a line, name of commodity

A price is a decimal numeral, cost of commodity

Max. a discount is a decimal numeral, limit of discount on a commodity in percents

A recorder is a line, identifier of recorder

НГ- number from 0 to 5, tax group of commodity

Gravimetric is a number 0 or 1 depending on the type of commodity. 0-piece, 1-gravimetric

Блок- number 0 or a 1 prohibition on an offtake. 0-продажа, 1-запрет on a sale

Information in this file can be contained only about the changed articles, in this case "CashFront" renews these articles only.

disc.txt : file of data about discount maps

For loading of data about discounts(discounts) from the external programs a file is used disc.txtEvery line in this file means information about a discount map. Information about a discount map divide inter se Example of file fragment is acquainted "|" :

 

9900002507140|Алексеев |0,00|14.01.2020 0: 00: 00|0|Kyiv, Саксагнского 10/and 335 кв.|0509999999|14.01.1975 9:04:25|This email address is being protected from spambots. You need JavaScript enabled to view it.|0,00

9900000002107|Boss |10,00|14.01.2020 0: 00: 00|0|Kyiv, Lesya-Ukrainians 13|07756893654|14.01.1961 9: 04: 25|Director of shop|0,00

9900000002091|Генадий |5,00|14.01.2020 0: 00: 00|0|Moscow, etc. Вернадского 95 /156|0978888888|14.01.1968 9: 04: 25|This email address is being protected from spambots. You need JavaScript enabled to view it.|168,00

 

Placing of the fields :

|||||

||<ДатаКлиента>||

Where:

A Stroke-code is a number, 13 signs. stroke-code of discount map

The name is a line, name of client

A discount is a decimal numeral, percent of discount

A Date-date is in the format " of ДД.ММ. ГГ", to that a map is actual

Блок- number 0 or a 1 prohibition on a discount. 0-разрешено, 1-запрет on a discount

An address is a line, address of client

A telephone is a line, telephone of client

ДатаКлиента -дата in the format " of ДД.ММ. ГГ", date of birth of client or date of creation of map

A note is a line, additional information about a client

A sum is a decimal numeral, sum of purchases(for story maps)

Information in this file can be contained only about the changed discount maps, in this case "CashFront" renews these maps only.

promo.txt : file of data about discounts and actions

For loading of data about discounts and actionsfrom the external programs a file is used promo.txtEvery line in this file means information about a certain discount or action. Informationdivide inter se a sign "|" and "*"Example of file fragment :

LMGRI- 83|2|48208642|False|00: 00*24: 00*7*14.01.2020*14.01.2020*Qunty*10,00*>*5,00*%;00: 00*24: 00*7*14.01.2012*14.01.2020*Qunty*50,00*>*10,00*%;

Алексеев|1|9900002507140|False|00 : 00*24: 00*7*14.01.2012*14.01.2020*Summ*100,00*=>*3,00*%;00: 00*24: 00*7*14.01.2012*14.01.2020*Summ*200,00*=>*4,00*%;00: 00*24: 00*7*14.01.2012*14.01.2020*Summ*300,00*=>*5,00*%;

L&M Silver Label grey|2|48207812|False|00 : 00*24: 00*7*14.01.2012*14.01.2020*Qunty*10,00*>*5,00*%;00: 00*24: 00*7*14.01.2012*14.01.2020*Qunty*50,00*>*10,00*%;

Bonus(1111111111111) |0|1111111111111|False|00 : 00*24: 00*7*14.01.2012*14.01.2020*Summ*1000,00*=>*10,00*$;

L&M Blue 83 слим|2|48208659|False|00 : 00*24: 00*7*14.01.2012*14.01.2020*Qunty*10,00*>*5,00*%;00: 00*24: 00*7*14.01.2012*14.01.2020*Qunty*50,00*>*10,00*%;

L&M Blue Label blue|2|48207805|False|00 : 00*24: 00*7*14.01.2012*14.01.2020*Qunty*10,00*>*5,00*%;00: 00*24: 00*7*14.01.2012*14.01.2020*Qunty*50,00*>*10,00*%;

Генадий|4|9900000002091|False|00 : 00*24: 00*7*14.01.2012*14.01.2020*Summ*1000,00*>*5,00*%;00: 00*24: 00*7*14.01.2012*14.01.2020*Summ*2000,00*>*7,00*%;00: 00*24: 00*7*14.01.2012*14.01.2020*Summ*3000,00*>*10,00*%;

Discount on a check|3|0|False|00 : 00*24: 00*0*14.01.2012*14.01.2020*Summ*1000,00*>*5,00*%;

Information in this file is divided into two blocks: the Name type of both индентификатор action and condition of realization of action. For this file composition it is initially recommended to form an action in the program from a built-in editor, and then on character and similarity to form a file from a бек-офиса. After unloading of file an action can be controlled in a menu Service > Discounts. In addition, automatic this file composition is possible if in information contained infile of Invoice.txt to add to the line the condition of discount on a certain commodity(example will be made a below).

Setting of the fields :

|<ТипСкидки>|<ШтрихКод>|<Розрешение>|<БлокУсловия1>; . <БлокУсловияN>;

Where:

The name is a line, name of discount or action

ТипСкидки, number type of discount 0 -

0-Бонус, valid for one occasion discount, after the use becomes inaccessible

1-dynamic(changing depending on a sum or time), discount on a discount map

2 - Dynamic(changing depending on a sum, amount or time), discount on the article(to the commodity)

3-скидка to the amount of sales, maybe only one value with an identifier(ШтрихКод) equal "0"

4-story discount on a discount map

5-special price on a commodity, limitation is possible in time

ШтрихКод is a number, 13 signs. stroke-code of discount or action

Permission is a value "True" or "False", permission on realization of discount

<БлокУсловия1>; . <БлокУсловияN> -блоки terms, there can be an arbitrary amount main that contradictions were not and corresponded to good sense.

Block of terms, this one rule of grant of discount, if a current sale corresponds to this block of terms that the program carries out the summer residence of discount on this sale. If current sale of соотвествует to a few blocks of terms, then the program chooses a condition giving a most value discounts.

In the block of terms syntactic lexemes divide a symbol "*", delimiter between the blocks of terms ";".

Here example of block of condition for dynamic сидки on a discount map, for comfort of reading blocks are placed from a new indention:

00: 00*24: 00*7*14.01.2012*14.01.2020*Summ*100,00*=>*3,00*%;

00: 00*24: 00*7*14.01.2012*14.01.2020*Summ*200,00*=>*4,00*%;

00: 00*24: 00*7*14.01.2012*14.01.2020*Summ*300,00*=>*5,00*%;

In the pointed example a discount on a discount map changes depending on the sum of purchase, from 100 руб 3%, over 100 and to 200- 4%, over 300-5%. The first value means time of offensive of discount, after time of completion of discount. Then day of week, number, 7 means that for all days of week. Then, like period of -число-месяц-год for beginning-completion, value of type of condition "Summ" or "Qunty" for a sum and amount accordingly, and "Price" for the special price on a commodity. Logic of comparison of condition : " is whereupon specified<,>,<,= and.тд", size of discount, decimal numeral and method of grant, "%" by a percent, or sum "$". A block is closed by a symbol ";".


Catalogue " of Jornal": ДД.ММ.ГГГГ.txt,: files of data about cotter pins(operations)

For loading of data about cotter pins from the external programs a file is used ДД.ММ.ГГГГ.txt: where ДД-дата. number, ММ- month, ГГГГ- year. Every line in this file means information about a cotter pin. Information about a cotter pin divide inter se Example of file fragment is acquainted "|" :

 

28.11.2010-11:32: 30#9|Sales|Many|1346,61|0,00|0|Cashier №1 |PRINTER

28.11.2010-11:48: 13#10 |ToCash|Many|100,00|0,00|0|Cashier №1 |PRINTER

28.11.2010-11:48: 22#11 |InCash|Many|- 50,00|0,00|0|Cashier №1 |PRINTER

28.11.2010-11:48: 53#12|Over|Many|a 728,00|0,00|1111111111111|Cashier №1 |PRINTER

28.11.2010-12:29: 32#13|Invoice|Many|a 320,00|16,00|1111111111111|Cashier №1 |PRINTER

28.11.2010-12:30: 13#14|Inventory|Many|728,00|21,84|1122222222222|Cashier №1 |PRINTER

28.11.2010-12:30: 34#15 |Sales|Credit|112,32|5,62|1133333333333|Cashier №1 |PRINTER

 

Placing of the fields :

|||||||

Where:

An identifier is an unique identifier of check, line(date-time#is a number)

An operation is a type of check, can take on values:

"Sales": offtake

"ToCash": official importation in a cashdesk

"InCash": collection(delivery of money from a cashdesk)

"Over": return of commodity

"Invoice": arrival of commodity, information about an incoming file (*.INV) or the arrival of commodity entered by hand

"Inventory": taking of inventory, identifier of the conducted or got taking of inventory

"Z": зет-отчет with обнулением

A type of Payment is a type of paying for a check:

"Card": card(кредитка)

"Credit": credit

"Chek": on a check

"Many": наличные

A sum of check is a decimal numeral, sum on a check

A sum of discount is a decimal numeral, sum of discount on a check

A code of discount is a number, 13 signs, stroke-code of discount map

A cashier is a line, name of operator

A recorder is a device to that a check is printed, can take on values:

"PRINTER": printing is produced on ESC/POS printer

"FISCAL": printing is produced on a fiscal recorder


Catalogue of "Sales" : ДД.ММ.ГГГГ.txt,: files of data about the sold commodities

ATTENTION! Since a version 3.5.5.0 a file contains decoding of the conducted taking of inventory and arrivals(импортов) of commodity. The identifiers of these operations are contained in the corresponding file of magazine (Catalogue "Jornal

For loading of the commodities given about sales from the external programs a file is used ДД.ММ.ГГГГ.txt: where ДД-дата. number, ММ- month, ГГГГ- year. Every line in this file means information about a sale or return of commodity. Information about a commodity divide inter se Example of file fragment is acquainted "|" :

 

28.11.2010-11:32: 30#9|3373|Авт. выкл. 1р, 02А(шт.) |11,16|1,000|11,16|0,00|PRINTER|3|0,00| 2000020647962

28.11.2010-11:32: 30#9|3010|АВВГ 4*150|74,66|1,000|74,66|0,00|PRINTER|3|0,00|48102568546

28.11.2010-12:30: 34#15 |3009|АВВГ 4*240|112,32|1,000|112,32|5,62|PRINTER|3|5,00|100021541200

 

Placing of the fields :

||||<к-во>||||<НГ>||

Where:

An identifier is an unique identifier of check, line(date-time#is a number)

A code is a number, 5 signs, internal code of commodity

The name is a line, name of commodity

A price is a decimal numeral, cost of commodity

К-во is a decimal numeral, amount of commodity

Сумма- decimal numeral, sum on a commodity

A discount is a decimal numeral, sum of discount on a commodity

A recorder is a line, identifier of recorder

НГ is a number from 0 to 5, tax group of commodity

Max. a discount is a decimal numeral, limit of discount on a commodity in percents

Штрих-код- stroke-code of commodity


  • File of import of data *.INV

file of data about the articles about the amount of commodity(invoice) intended c information for loading of data about the articles(commodities) from the external programs with information about a commodity and amount of commodity. File INV analogical on a structure with files price.txt. Information about the amount of commodity is contained in two additional fields at the end of line, a next to last value determines the method of setting of amount : 0 - an amount to existing("ADD"), 1-устанавливает value of amount from a file("SET") adds. The last value is an amount of commodity. The program uses this file for set mode control of bits and pieces. After the file locking he retires the program. The package loading of a few files is possible simultaneously. For the import of data files *.INV it is necessary to place synchronizations of data in a catalogue, in a directory "Invoice", In case of remote location of client this file is placed in the catalogue of ФТП- of server certain for a certain cashdesk. Example of file fragment :

6096|1000000040364|Marlboro RED|шт.|13.00|0.00|PRINTER|1|0|0|03

A file also supports the transmission of dynamic discount for the article(commodity) in this case to completion of line add the brief record of discount :

|#|False|

00: 00*24: 00*7*16.10.2012*16.10.2013*Qunty*10*<*-10*%;

00: 00*24: 00*7*16.10.2012*16.10.2013*Qunty*10*=>*-5*%;

Where the brief record of discount(in this case raise ) follows after a symbol "", second sign устанвливает actuality of discount, after follows blocks of terms (of см. description "promotxt"). * For comfort of reading blocks set about by indentions, in the real file all must be one line

 

 

Read 3421 times
Cтруктура of files for CashFront 3.5.5.0
  • Default
  • Title
  • Date
  • Random
load more hold SHIFT key to load all load all

Briefly:

Software development for trade;
Supply of computer equipment with installed software;
Control and accounting systems: scales, bar code scanners, check printers and other commercial equipment.

Newsletter

Do not miss our news!

Location:

58000, Ukraine, Chernivtsi
+380 (68) 196 8830
+380 (50) 374 9540
E-mail: office@cashfront.net


facebook business.site youtube twitter