In this example, we add CSV download function (data) and CSV upload update function to "customer" model. Transit to "Screen" setting.
Activate "download screen".Leave the default value for the download setting.
Activate "Upload update screen".Leave the default upload update settings.
The download and update upload buttons have been added to the menu.
To make it easier to distinguish on the screen, it is a good idea to change the background color.
Menu is added when building.First I will try "customer download".
As shown in Figure 8, you can narrow down by search criteria. Here, with no data being registered, try pressing the download button.
The following rules determine the download file name.
Try to open it with a text editor.Even if there is no data, you can see that it contains a line called a header.The item name is enclosed in double quotes.
Suppose that you have registered two data in advance.Then it becomes the contents as shown in Fig.The second and subsequent lines are data, which also shows that each value is enclosed in double quotes.
Let's modify the file in Figure 10.An example of sending this file to Wagby and updating it is shown below.
Select "Update customer upload" from the menu.Press the "Select file" button and specify the file shown in Figure 12.Then the file is confirmed as shown in Fig.
Click the "Send update file" button.Then the screen will look like Figure 14.
At the appropriate timing, press the "Refresh this screen" button.When the process is completed, the screen shown in Fig. 15 will be displayed.
|Number of processed rows||It is a line included in the file.Including header lines are also counted.|
|sign up||Displays the number of newly added lines (data).|
|update||Displays the number of updated rows (data).|
|Delete||Displays the number of rows (data) deleted.|
|error||Displays the number of lines (data) in which processing failed.You can check the details by clicking the link "download error processing result".|
I will check the data.You can see that it is updated according to the contents of the file.
The CSV file handled by Wagby conforms to the following specifications.