::: Office-XXI :::

Office-XXI : Entry [login0.php?lang=en] / New company / Your questions The purpose of this Project is a building of the interface between HTML-forms, created by means of any HTML-editor, and database, including all necessary tools for entering, searching for, modification and displaying the information. One of example of the use may be such. We shall expect that your work is consist in communicate with a great number clients and this contacts is consist in periodical meetings or other contacts with clients, revision the data about clients and finally in acceptance of a certain decision about the client. In process of the work you necessary to use the archive a clients in which you will fix all necessary information. You needed to have a possibility for quickly find the necessary card (or record, or page in book) and do the required marks or additions/modification to information. If your work although little looks like above-mentioned i.e. it is connected with any systematized information - this project will do your life much comfortable. The Project consists of the following components: Access autorization Forms description Data processing Access autorization The System authorization access guarantees you preservation of confidentiality to your information. When you first once register for put your organization, you will enter its name and password, as well as will enter any question and answer for it. Hereinafter, for entering in the system you will necessary enter the organizations name and password you has done it first once. If you will forget the password, you it is necessary will write a letter on offered address. The letter must have question and answer entered you when your organization registered first time. If question and answer will be specified faithfully, system will find your password in the database and will inform it to you. Within one organization the authorization system is built on names and passwords of the users, united in the groups. Originally, under the first registration of the organizations, one group "Administrators" and one user with name "admin" and password "admin" will be created automatically. This means that having registered your organizations, you should not postponing login with name "admin" and password "admin" and change the password on the known only you combination of the letters and numerals. Will Login with name "admin" you get all administrator rights and possibility to add the new groups and new users. All users, falling into "Administrators" group will have a administrator rights. The administrator rights are not limited. The users from the other groups can only change their own passwords. All restrictions for access to data for groups spread on all members of the groups. Forms description If you have any HTML document containing form with fields for data entering you may perform the number an actions and establish the relationship between form's fields and database, where will be information kept. First use the menu item "FORMS/Descriptios" and press the button "New". Then enter the name appropriate for your form and install the access rights to the form description. If there is such need, you may assign the owner of the form's description any other user. Press the button "Save" for saving all actions you done. Actuate the radiobutton in the line with entered by you descriptions of the form and press the button "Upload" for unloading the file of HTML document from your computer on web server. On the web server your HTML document will automatically complemented necessary scripts for building of the interface between fields of your form and database. Hereon you may work with information by means of menu item "DATE/Date". For correct processed your HTML document, it must satisfy some requirements. all fields of the form, which contents you want to save in the database, must have an "NAME" attribute. all tags name, exclusive radiobutton's name, must be unique. However if this requirement is not executed, the system will make the unification of the tags names by adding to its unifying symbol set. Radiobuttons names never change by the system. Therefore if in your HTML document there is two radiobuttons groups with alike names, that system will count their as one group. For prevention such error you may check the list of the names of the radiobuttons groups and amount of the radiobuttons in each group. The button "CheckRG" serves for this. If you detect the error, correct it in your HTML document and upload it on the server again. If after any time period you have done the changes to your HTML document and want update interface with database, you MUST NOT delete the available description of the form. Simply unload the changed form again. The Important role in creation comfort in work with data take part the "Fields" button. Having pressed this button, you will open the window with list of the text fields of the form and will be able define their more exactly. The First column with name "UAL" (Use As Link) allows you to mark that field, which you want to see as references to data record. The Second column contains the name of the field of the form. The Third column allows you to elaborate the type of the text field: text, number, date or list. Hereinafter, information, carried in field of the type "number" or "date" will be automatically checked on correspondence to type and in the event of mistake field contents will be displayed by red color and "Save" button will disappear from foot of the page that will not allow you to save the wrong data. After correction of the mistake contents field will be displayed by black color and "Save" button appear once again. For dates is provided two formats: 'dd/mm/yyyy' - an european type 'mm/dd/yyyy' - an american type For division of the day, the month and year can be used following symbols: "/", "." and "-". The Date can be is also entered as 6- or 5-digits number - in this case the last two digits will are perceived as two last digits of the year, the following two digits will are perceived as month or day depending on chosen by you format of the date and the first digits accordingly as day or month. Furthermore, for spare effort you may choose the date from calendar. If you define the type of the field as "list", this signifies that in such field will be displaying the list of the values of any other fields other (or probably same) of the form. The text field of the "list" type will be replaced upon textarea (only for reading) to which will be added "Browse" button. This button will open the window allowing you to marked some values, who form the list. The formed list will be displayed in the textarea field. If since period in you appeared need to add to the form of some any fields or take away spare, or, for example, add the option to the "select" field, you simply do it in the your source file and upload it on the site again. If you have lost the file with your form, you may download it from the site by use "Download" button. The Different forms can be bound by "Parent / Children" relation. This allows unlimited to increase the information space your database and synchronizing the information writing in the different forms. For creating "Parent / Children" relation you can use the "FORMS / Relations" menu item. At the first entering you will see the list of all available forms each of which is assigned status "Free". There is "Make parent" button opposite each free form. Pressing of this button changes the status of the form to "Parent" and brings "Add child" button and "select" field for choice possible child. Performing described above actions is enough for synchronizing the writing the bounded forms. The access to the child-forms is now realized through references at the end of the parental form, but information of the parental form and the child-forms is a united information essence. Data processing Use "DATA/Data" menu item for work with data. Choose interesting you form by radiobutton checked. The "Data" button opens the window of the form. If sizes and/or location opened window you do not suit, use the "Layout" button and change the necessary parameters. The repeated pressing the button takes away the panel of the tuning. Now this window will always be opened in defined place and with defined size. For data entering, the viewing and modification is used same web page. When form page opens first once, it displayed contents last saved record. Press the "New" button for a new record entering. Two buttons: "Clear" and "Prompts" are intended for relief of the viewing partly filled forms and output of the help prompts in the blank fields. For navigation over the records use the corresponding "select" field. The "select" field in the upper left corner allows you to get access to 500 last records. The more universal variant of the access to any writing records is realized by means of query mechanism. For query building in "Data" window choose the form, in which required to produce searching for and press "Queries" button. The window is opened with list all possible for this form queries. You may use any earlier determined query or create new. After adding in queries list new query by means of "New" buttons, press the "Fields" button and define fields checked in this query and conditions of the records selection. The empty query selects all records. In the beginning window will be empty. Press the "All" button and get the list by all fields of the form. Sweep away into checkboxes checked fields and press the "Only" button. On the screen will remain only marked fields. Now define the conditions of the selection for every field. The string of the conditions consists of groups of the conditions united operations '.AND.' and/or '.OR.'. If in string of the conditions there is both operations, that is in the first place executed all operations '.AND.', but then '.OR.'. The group of the conditions consists of sign of the comparison operation (the list possible operations is allowed corresponding "select" field) and expressions. For save of the built query press "Save" button. For its performances - a "Use" button in window of the list queries. The records, selected as a result of performing the query will are represented in the manner of pair {name of the field} = {value of the field}. Thence results the advice to use as names the intelligent mnemonic names. The length of the name must not exceed 31 symbols. The contents of the "textarea" fields you may structured in the manner of set different topics and get the quick access to necessary topic having chosen its name from corresponding "select" field automatically added for every "textarea" field. Every topic must begin with names. The name of the topic must begin with point and end the colon. The name of the topic must start with new line and be a only contents of the line (i.e. after colon it is necessary without fall to press the key "Enter"). After ending of the topic (before entering the name of the new topic) you also must press "Enter". The names topics will come up for list of the "select" field after saving of the form contents. Your questions, comments and wishes you may send on this address .