KR19980079304A - How to fill out a form - Google Patents

Abstract

It does not require any special knowledge for writing a program, and it is possible to easily design a data printing screen for a designated form.

An item name corresponding to a field name of a database file prepared separately is displayed while displaying a designation form of an arbitrary format in which necessary items such as a warp wire have been printed on the screen 44 of the display 12 as an image image 46. 54 is provided with a data check box 50.

When the item name 54 is selected, the printing position is sequentially designated in the designation frame 52 formed, and then, from the designation position, the printing format data associated with the database file is automatically generated.

Description

How to fill out a form

1 is a flow chart schematically showing the basic configuration of the present invention;

2 is a schematic view showing the configuration of a personal computer to be used;

3 is an explanatory diagram showing a configuration of a database file;

4 is a block diagram showing a configuration for realizing a designated document creating function;

5 is an explanatory diagram showing a designation state of printing items on a screen of a display;

6 is a flow chart showing a schematic flow of a formatting process.

* Description of the symbols for the main parts of the drawings *

10: device body 12: display

14 Printer 16: Image Scanner

18: indicating device 20: keyboard

22: external storage device 24: database file

26: Field 28: Record

30: Customer Information 32: Product Information

34: transaction information 36: format setting unit

38: slip printing unit 40: image data input means

42: display means 44: display screen

46: image image 48: printing data indicating means

50: Data checkbox 52: Designation frame

54: Item Name 56: Grip Mark

58: gangster 60: automatic generation of the print form data

62: print data input means 66: data processing means

68: printing means

[Purpose of invention]

It does not require any special knowledge for writing a program, and is intended to enable the design of a data argument screen for a designated form easily.

[Technical field to which the invention belongs and the prior art in that field]

The present invention is a method of creating a slip sheet which prints data on various slips as well as slips used for accounting. Especially, a method of adding data later to a printed slip printed on the first side prepared by a customer is added later. It is about. Conventionally, the printing for this kind of book is written by hand when the number of sheets to be printed is small or when it is necessary to print several sheets in the same format as the Japanese type. As a result, the corresponding method has been generally implemented.

[Technical problem to be achieved]

However, with the inexpensive use of computer devices, personal computers have been introduced for accounting processing even in small-scale establishments, and printers have also been requested for designated manuals that have been written by hand.

However, the format of the provided sheets is diversified, and even if the same format is used, for example, it is difficult to process unified data such that the number of rows of data to be stored in each length is different.

The present invention has been made in response to the above-mentioned demands, and it is possible to automatically display a designation table of an arbitrary format in which a necessary item such as a warship is printed in advance as an image image, and to automatically designate a printing item and a printing position of data on the image image. Therefore, it is an object of the present invention to provide a method of creating a book that can easily design a print screen for designating a designated book without requiring special knowledge for creating a program by configuring the print program of the book.

[Configuration and Function of Invention]

The journal creation method according to the present invention uses an image image 46 of the journal to be used on the screen 44 of the display 12 illustrated in FIG. 5, for example, as the flow is schematically illustrated in FIG. 1. The process of displaying, the process of specifying the printing position of data on this displayed image image 46, and the coordinate position on the screen of the said image image 46 and the specified printing position on an actual long list form A step of calculating the print position of the data, a step of automatically generating the format data for printing from the calculated print position, and a process of printing the eye data on the sheet according to the generated format data.

The image image 46 described above is created by using, for example, an image scanner to display a form to be used, and the data to be printed on the form is selected from a data group stored in advance. do.

The data group constituting the print data is constituted in a database format in which a plurality of sets of fields in which the contents of the data are identified by the field name and the field name are set in advance as shown in FIG. The printing element of the data specified in (46) is characterized by being specified by the field name. In addition, when the item name 54 corresponding to the field surface is displayed in a menu format during the above-described printing process of the printing part, and the specific item name 54 is selected therefrom, the excretion position and size on the screen 44 can be arbitrarily selected. The changeable frame 52 is preferably formed integrally with the item name 54 selected as shown in FIG.

Moreover, the printing data specified on the above table includes the data of the first group in which one record of data is limited and printed for one sheet of paper, and the data of several records for one sheet of paper can be printed. After the second group of data is provided, the above-described print factor is specified, and the print factor is further designated for each group of data, while the automatic generation of the format data described above corresponds to the data format of each group. In this way, the calculation operation of the print position and print content is performed.

On the other hand, in the second group of data, if only one row is specified, the plurality of rows are processed in correspondence with the number of records of data to be printed.

The above-mentioned print data may be input indirectly into the database file 24 through a separately prepared data input screen, and through the input screen of data having the print position specified in the specific process of the print site as an input range. It may also be directly input into the database file 24.

It is also possible to convert data of a general format provided from another system into the data format of the database file 24 and input it.

[Configuration and Function of Invention]

Hereinafter, the present invention will be described in accordance with an example performed on an accounting processing generation system such as an invoice or a delivery slip, but not limited thereto, such as documents to be submitted to the government office, documents with pre-printed fixed items are submitted from the other party, It applies to the preparation of various forms for which the use of the document is compulsory.

In addition, the slip issuance system according to the present invention. As schematically shown in FIG. 2, its function is realized by application software in a general personal computer, and as a function in an accounting system generally used conventionally, or alone. It can be implemented as a function of.

As a peripheral device to be used, a display 12, a printer 14, and an image scanner 16 are provided as peripheral devices for the device body 10 having a built-in CPU. By the keyboard 20, inputting of text data is enabled by the keyboard 20, and the inputted data is accumulated in an external storage device 22 such as a hard disk. Although a general purpose is used, it is a matter of course that a dedicated device that specializes in its function for accounting or other purposes can be performed in approximately the same way.

Here, the journal issuing system includes one or several database files 24 having one or several fields 26 for storing data, as shown in FIG. By reading and writing the individual data specified in the filter 26 and the record 28 while associating each other with each other, arbitrary data processing stored in the database file 24 becomes.

The filter 26 set in the database file 24 for the document processing includes the customer information 30 such as the customer name or address, the product information 32 such as the name of the product to be traded or the unit price thereof, or a piece such as an invoice or a delivery note. Each time a document is issued, transaction information 34 such as a billing date or a transaction product recorded is set as an individual database file 24 or a data table.

As described above, in addition to the system preparing the field 26 of the specific content to be individually processed as the ticket issuing system in advance, the user can use the setting appropriately without setting the content of the data in advance. By providing a field, all the item names which require data processing at the time of document processing are covered.

For the data specified by each of the field names described above, the system prepares a general input screen of the data, and contents fixed to some extent, such as the customer information 30 and the product information 32, are stored at the start of the system. In addition, in the case where the daily information increases, such as the transaction information 34, the latest data is added to the database file 24 by adding, deleting, or updating the necessary data whenever the transaction occurs through the input screen. Preserved in the phase.

The data on the database file 24 is displayed on the display screen 44 of the display 12 according to a format prepared in advance by the system side or newly designed by the user, as in the past, or a printer ( 14) are printed as various documents such as invoices and bills of delivery.

If necessary, the relationship between the data on each database file 24, such as transaction selection and monthly transaction amount, is statistically processed, and the result can be displayed in a graph or tabular form.

The present invention enables the printing of data according to the form when the form of the document is designated from the customer side and the form itself is printed in advance, and the data needs to be added and printed later. It is characterized by the issuing function of designated documents.

FIG. 4 schematically shows each means constituted by the hardware displayed in FIG. 2 and the software running on the apparatus main body 10, in order to realize the above-mentioned designated document issuing function. The printing unit 38 is provided, and both of them are operated in conjunction with each other.

As the formatter 36 schematically shows the flow of the operation in FIG. 6, in step 1, image data input means 40 including an image scanner 16 for the document provided from the client side. Is installed inside, and the display means 42 displays the image image 46 at a ratio equal to the magnification of the actual size on the screen 44 of the display 12 as shown in FIG. After the display, in each step from step 3, the print data indicating means 48 is used on the screen 44, and the type and location of the data to be printed are manually specified.

The printing data indicating means 48 superimposes the document displayed as the image image 46 on the screen 44 of the display 12, and designates the recognition point using the instruction display 18. Step 3 In order to specify the contents of the data to be displayed in (), for example, a data check box 50 displaying the item name 54 in the form of a selection menu, and one item name 54 from the check box 50 are selected. A designation frame 52 for designating a printing position of data to be formed is provided.

The item name 54 displayed in the data selection box 50 is for specifying the data on the database file which can be printed on the document, and uses the field name of the database file prepared by the system side as it is, or the customer side. It is determined by attaching a name for specifying this field surface separately.

In addition to the system side preliminarily selecting and preparing an item name 54 specified by a specific field surface which may be printed on the document, the user can select an item name 54 that is required by the user. ) Is displayed only in the data selection column 50.

When a specific item name 54 is selected from the data selection box 50 using a mouse, the pointer of the mouse is a rectangular designation frame 52 having a grip mark 56 around it as shown in FIG. ), And the entire table image displayed on the screen 44 can be freely moved.

For example, if "account name" is selected as the item name 54, in the invoice illustrated in Fig. 5, the place of description of the account name is specified on the upper left side of the slip indicated by a dashed line. Position after performing (52).

The designation frame 52 is capable of fine adjustment of its size and position until it is confirmed, and the determination state can be returned to the indetermination state, and the selected item name 54 is written in the frame 52. It is easy to see if an item is currently set in the document.

In step 5, the format required for printing, such as the character size to be printed for each designation frame 52, the character spacing, or the printing position of filling the right or the left in the frame, can be individually set. Fine adjustments can be made so that characters such as numbers to be printed are not duplicated in the fixed printed portion, including the cross-section 58 separating each line previously printed on the slip.

By the way, in each data on the database file 24 specified by the item name 54, data types, such as a character type, a resin type, a date type, or a logical type, are previously individually designated. In the date data, the calendar year issue and the month date are integrally stored, but the date described in the document is often required to be printed in the state in which the year and month date accompanying the arc are separated.

Therefore, in the date data such as "billing date", it is possible to specify which item of the date is printed for each designation frame 52 again.

In numerical data, items unique to numerical display, such as presence or absence of a separator, can be displayed in the logical data as the designated items by the point corresponding to the logical value or the type of the printing mark such as "x".

In addition, when two or three date data of which the width | variety of the designation frame 52 is below a set value are set continuously, you may comprise so that a year and a day may be displayed separately. As described above, the database file 24 can be used to print corresponding to the contents of the stored data, and at the same time, various marks including the same character string, numerical value or symbol can be printed for all the documents. By the way, the data to be printed on the slip includes the data of the first group that selects and prints only one record in the database file 24, such as the name of the customer, and the data of the number of unspecified records, such as the data described in the transaction specification. Recognition order for each classification is classified into the data of the second group which may cause the factor demand for Is different.

In this embodiment, every time one designation frame 52 is determined, or after all designation frames 52 are determined, the item names 54 are divided into three divisions in step 6 of FIG. Classify.

On the other hand, in the print form data automatic generation means 60, in the above-mentioned first group data, in step 7, for example, the designation frame 52 whose upper left corner of the document displayed on the screen 44 is the origin. Step 9 is performed to detect the position coordinate of the position, calculate the position of printing on the actual document from the position coordinate, and extract and print the data on the database file 24 specified by the item name 54 at the position. ).

In the second group of data, it is specified that all action values that can be printed at the time of specifying the printing position in step 4 of FIG. 6 using the above-described printing data indicating means 48 are specified by the designation frame 52. Rather, it positions only the best one row and numerically specifies the maximum number of rows and row pitches that can be printed.

By specifying the print position in this manner, the format data automatic generation means 60 repeats the data of the required number of records within the range not exceeding the specified maximum number of rows at the designated row pitch, based on the print position of the top row. The format data to be printed is created in step (8).

In addition to specifying the maximum number of printable rows directly as described above, the format data can be created to detect the designation frame 52 specifying the lower limit of the print position such as the total amount of money, and print them to the front of the row. .

Also, the printing line pitch is determined by detecting the vertical width of the designation frame 52 by matching the vertical width of the designation frame 52 to the maximum value of one line on the table. In addition, instead of setting only one line in the designation frame 52, it is also possible to set in advance the designation frame 52 all the lines which may be printed.

On the other hand, in the third group of data, in addition to the specification by the designation frame 52 of the printing position, it is possible to specify the item names 54 to be calculated with each other and a calculation expression as necessary. Therefore, in the form data automatic generation means 60, arithmetic expressions of the data specified in the designated item name 54 and form data which are the argument coordinates of the data calculated by the calculation are created.

As described above, the form data generated by classifying the data into groups of data are integrated in step 9, and the data is stored in step 10 again, and then the data processing means 66 in the next slip printing unit 38 is used. Used for printing.

In addition, the automatically generated form data can be newly created in accordance with the above-described procedure. A basic program prepared by using a memory variable in advance of the item name 54, the argument coordinates, or the number of iterations is prepared in advance. It is also possible to prepare the required format data by substituting the variable with a mark for the value.

The slip printing unit 38 has a function for enabling manual entry of arbitrary data to the printing position configured in the format setting unit 36 by printing data input means 62 such as the keyboard 20, and printing. Before printing by the means 68, the display means 42 has a function of confirming the content of printing in advance, and a function of actually printing using the printing means 68.

The data input function uses the format data created as described above, but does not use the print data stored in the database file 24, or the data to be stored in the database file 24 is still prepared. It is mainly used when it is not done.

When this function is selected, the image frame 46 of the designated document is set as a background, and the range of the designation frame 52 is specified as the data input position in the first group of data, and the maximum number of rows in the second group of data. The data entry screen with the data entry frame is displayed.

If the data required for this data entry frame is directly inputted through the keyboard 20 on the screen 44 and then confirmed, the data input frame is to be stored as the database file 24. As in the case of data input by the input screen prepared by the system side described above, data is stored while predetermined relation is given to the field 26 specified by the item name 54. On the other hand, if data saving is not selected, the data is temporarily stored and then enters the printing process, and the printing operation by the printing means 68 according to the input data is executed.

The print content pre-check function draws out from the database file 24 to be printed on the image image 46 of the designated document and displays the image image according to the format data. The format setting state is displayed as an image superimposed on the designated document displayed as the background, so that the printing state can be confirmed in advance before printing on the lower surface 44 of the display 12.

The printing function makes it possible to actually print data on the designated sheet by using the printer 14 of the printing means 68.

That is, the necessary print data is retrieved from the database file 24 using the transaction line name or the document number as a retrieval key, and the print contents are displayed as an image image on the screen 44 using the pre-confirmation as described above. Only the print data portion of the image image is output as image data to the printer 14, whereby the print operation superimposed on the designated document is executed.

When the printing position shift occurs due to the difference of the printer 14, the printing content is made into all the display data, and the printing position on the document can be fine-adjusted in the row and horizontal directions.

The printing of the printing data to the printer 14 is developed as an image image once on the screen 44 as described above, and then only the data to be printed is output as the image data. The character data including the control code of 14 may be output to the printer 14 as it is. In addition, in the above-described embodiment, image data of the designated payroll is displayed on the screen 44 using the image scanner 16, but not limited thereto, image data of the designated payload prepared separately may be used. .

In addition, it is also possible to reuse a design screen of a form previously created using the above function, change a part of it, and save it as a separate file.

In addition, data used for inputting the print data from the keyboard 20 by using the input screen and separately prepared in a table calculation software or a database software in another data format is, for example, a comma separated CSV format. The data can be extracted in a general data format, and the data can be converted into a data format of the database file 24 or a data format usable for other journal arguments.

In addition, in the above-described embodiment, the case of making one form at one time is exemplified. However, the present invention is not limited thereto, and it is possible to continuously create a plurality of forms. The multiple sheets can be made for individual contents, for example, only the total amount should be written on the first sheet, and the details should be prepared in one related form, such as when writing in the second and subsequent documents. It may be. In addition, these various types of titles can be given names that identify individual contents, and the contents can be displayed in a tree form on the screen for storing and selecting the contents of the sheets, so that the relation between the related sheets can be clearly recognized. At the same time, the withdrawal can be made easily by simply selecting the chapter name.

[Effects of the Invention]

As described above, the present invention only displays a designation form of an arbitrary format in which a necessary item, such as a warp wire, has been printed in advance on the image image 46, and only specifies the printing item and the printing position on the image image 46. By designing the form data for the print of the form automatically, the print screen for the designated form can be easily designed without requiring special knowledge for creating a program.

Claims (7)

Displaying an image image 46 of a document to be used on the screen 44 of the display 12; The step of specifying the printing position of the data on the displayed image image 46 and the coordinate position on the screen 44 of the image image 46 and the printing position specified above are used for the data on the actual long list. Calculating a printing position; A step of automatically generating form data for printing from the calculated printing position; In accordance with the generated form data, a step of printing the eye data on a sheet form, At least one part of the data to be printed on the sheet in the printing step is composed of a database form consisting of a field name and a plurality of sets of records in which the contents of the data are specified by the field name in advance. A book creation method, characterized in that the printing element point specified in (46) is specified by the field name. The method of claim 1, The item name 54 corresponding to the field surface is displayed in a menu form during the above-described specific process of printing the above-described printing elements, and if a particular item name 54 is selected therefrom, the arrangement position and size on the screen 44 can be arbitrarily changed. The form creation method in which the frame 52 is formed integrally with the selected item name 54. The method of claim 2, The print data specified in the above table includes data of the first group in which one record of data is limited and printed for one sheet of paper, In one sheet of data, the data of the second group in which data for several records can be printed are provided, and after specifying the above-described printing point, the printing place is designated for each group of data again. In the above-described automatic generation of format data for printing, a table making method which is a calculation operation of printing positions and printing contents in correspondence with the data format of each group. The method of claim 3, wherein A method for creating a journal in which the second group of data is processed in rows according to the number of records of data to be printed when only one row is specified. The method according to any one of claims 1 to 4, The above-mentioned printing data is indirectly inputted in the database file (24) through the data input screen prepared separately. The method according to any one of claims 1 to 4, The print data creation method described above is inputted directly into the database file (24) through an input screen of data having the print position specified as the input range in a specific step of the print position described above. The method according to any one of claims 1 to 4, The print data creation method of the above-mentioned printing data converts the data of the general format provided from another system into the data format of the database file (24).