A number is added after the item name for the number of data. Specifically, it is item name , item name //////.
A number is added after the item name for the number of data. Container name /item name, container name /item name// /.
Numeric format does not apply.
For CSV format, the date, time, date and time format format is applied.
In Excel format, date, time, date and time type formats are fixed.They are "yyyy/mm/dd", "h: mm: ss", "yyyy/mm/dd h: mm: ss" respectively.
Item'sContent sectionIs displayed.(Blue frame part in the above figure 1) If there is no registration, the data part is output as blank.
Reference content is output after the defined item name.On the second and subsequent lines, "1" is output to the selected content. If not selected, "0" is output.(Blue frame portion in the upper figure 2)
To distinguish, "(" + item ID + ")" is output after Japanese item name.(Figure 3)
"(" + Item ID + ")" is output after the item name for distinction.(Figure 4)
The model for which the group authority is set includes the item "jgroupidjshparam" to indicate "data owner".This item is required inside Wagby.
If the referring destination of the reference linked type item is repeated, and it is a check box, it is not supported.(It will not be output.)
You can specify the page title and description.(FIG. 5)
Figure 6 shows the screen generated with the settings in Figure 5.
I will explain the download setting in detail.
You can select "CSV (Comma Separated)", "TSV (Tab Separated)", "Excel (xls)", "Excel (xlsx)", "Runtime Specified".
You can specify the name of the file to be downloaded arbitrarily. For details, please read "Design of download file name".
You can specify the character encoding of the download file for each model.When this value is blank, the value of "environment> application> initial parameter> character encoding of CSV file" is used.
For example, if you want to output with UTF-8, write utf-8 in this column.
When checked, the item name in the header section changes to the item ID.
Allow multiple users to download at the same time.This setting is enabled by default.
For items that do not have reference authority, the item name and data are not displayed.However, if you enable this setting, the item name will be output even if you do not have permission.Data is output with blanks.
In checkbox type, "1" or "0" is output for data item.(Figure 3)
When this setting is enabled, data is output together as one.Use "," to separate delimiters between data.For example, "Government Offices, Others" output.
It is also possible to specify the delimiter of the above "Separate check boxes with delimiters and output in one column"."," (Comma) is used when blank.
For model reference items, the content part is output.When this setting is enabled, the primary key of the referenced model can also be output at the same time. The item of the primary key is "item name # id".
By default, double quotation marks are added before and after the column in the download file.When "(none)" is specified in this setting field, double quotes are not output.When this setting is not specified (standard) is double quotation.
When the download file name is blank, the file name follows the following rule.
You can specify a fixed file name.Extension is not required.The file name is as follows.
You can include search conditions as placeholders."Model name _ cp. Item name" will be obtained.Extension is not required. Here is an example.
You can mix placeholders and other characters.
An expression (function) can not be included in the file name setting field.So I will do as follows.
The sample model definition is shown in Figure 8.Item ID "csvfilename" is an item to store the name of the file to be downloaded.
This item is not saved in the database.(Figure 9)
This item is hidden when entering.(FIG. 10)
This item is also hidden when output.(FIG. 11)
This item is also hidden when searching.(FIG. 12)
Specify an expression as an initial value at search time.This is the file name.(FIG. 13)
In the following example, if the name item in the search condition is empty, use the logon account name.Otherwise use the value of the name field entered in the search condition field.It adds the date in "yyyy-MM-dd" format.
In "Screen> Download> Download settings> Download file name", specify this hidden item.
You can individually specify whether to include each item for downloading.
Control "output to CSV" of "Model Item Detail Definition> Output Control> Others".It is enabled by standard.
The sort order of the output data follows the sort order specified in the repository.
If your model includes repeating items and repeating containers, you can download these data independently.
Figure 16 is a model that contains the repeat item "e-mail" and the repeating container item "negotiation history". You can select the content to be output in "download format" under the search condition.
Figure 17 shows an example of downloading the repeat container "Opinion history" and opening it in Excel.
When "All" is downloaded, all repeating items and repeating container items are output together in one line.(FIGS. 1 and 2)
If you download repeating items and repeating container items separately, they are expanded for each line and output.(FIG. 17)
The file name naming convention is as follows.
You can not change the naming convention of file names.
If the model contains repeating items or repeating containers, and these are targeted for downloading, "download format" is always prepared.There is no setting to hide this.
Therefore, in order to hide this item, please avoid it in the following way.
The following problems may occur in environments where Excel starts when double-clicking CSV (comma separated values) or TSV (tab delimited) files.
The way to avoid this problem is as follows.
Type information is reflected in files downloaded in Excel format.
Extension xls formatIf you select, you can handle data items up to 256 columns.(Parts exceeding 256 columns are ignored.)
The maximum number of data that can be handled is 65,536 lines.
Extension xlsx formatIf you select, you can handle data items up to 16,384 columns.
The maximum number of data that can be handled is 1,048,576 lines.
When the authority setting is made for the item, it operates as follows.
When downloading data of model with conditional viewing authority set in CSV format file, careful consideration is required for operation to edit and upload this data.
The following model definition is taken as an example.
|b||Specify conditional viewing authority.Only available when item a is "0"|
We assume the following data.
データ1:id:1000 a:0 b:aaa データ2:id:1001 a:1 b:bbb
If you log on with authorized account and download the data of this model, it becomes CSV as below.
(id),(a),(b) 1000,0,aaa 1001,1,
Depending on the conditional viewing authority, b column of data with "id = 1001" is empty.(Since it does not meet the condition, it can not be browsed)
In this state, correct the a column of data of "id = 1001" from 1 to 0 and update CSV upload. In this case, it is necessary to pay attention to that the value of column b is updated from "from" bbb "originally stored in the database) to" character ".
To deal with this problem please do as follows.
On the search · list display screen, you can download the search results immediately. For details, please read "Screen function> Search · List display (list display)> Download".
When using the Wagby application with the browser on the iPad, change the character encoding of the CSV file to "UTF - 8".
When using the CSV download function from the iPad, it is necessary to press the "return button" of the browser in order to make transition from the download screen to the screen displaying the CSV file.
The character encoding standard of the CSV file is Windows - 31J.It corresponds to the Japanese environment only.
If you include multilingual data,Please change the character encoding of this model to utf-8.
There is a possibility that the Excel file is up before the download of the file is completed.The "open file, save, cancel" dialog is outputted by IE and can not be controlled by Wagby.After such a message is outputted, it seems that there is no problem if it waits for a few seconds and executes it.