I will go in details in what I want to do; Please any input from you will be appreciated. Currently, we use basic scripting to get the machine report for each month, and through excel we manually clean that report before sending it to the customer. The following lines is a sample of the raw data we get:
1192,3371,Small Straight Truck,9168917,5675,2018,5,1,6,56,
1192,3371,Small Straight Truck,9168917,5675,2018,5,1,6,57,
1193,3371,Small Straight Truck,9168917,5675,2018,5,1,7,2,
1194,0110,Small Straight Truck,9168307,5675,2018,5,1,7,44,
1195,3371,Small Straight Truck,91602666,5675,2018,5,1,10,6,
1196,0110,Small Straight Truck,9123355,5675,2018,5,1,10,36,
1197,3371,Tractor Only,164514,5675,2018,5,1,10,47,
1198,3371,Small Straight Truck,91603981,5675,2018,5,1,11,47,
Now, the customer doesn’t want to wait till the end of the month before viewing his data and in addition to that, he wants to view his data whenever he wants. That’s why we want to build a website. The website will get the file containing the customer data, process and clean up the file and display it on a table for the customer to view whenever he logs in. besides just displaying; we need to provide a button that will enable him to download a clean pdf/exxcel copy of that wash data.
Like I said earlier, the file is stored in the HMI, and the ewon access it through ftp server, here is how we get It:
f$="/SDMemory/"+m$+"/document.html"
GETFTP f$,"/usr/Penske_SoMilwaukee.html"
As you can see from the data above, we need to process line by line and the functions given by basic for such data processing are very inefficient.
Java would have been perfect for this task unfortunately; the Java ewon development tool kit has been deprived of all those nice functions which are useful for data processing.
The database was meant to be able to make the pdf or excel copy of the report that is each line we process is orderly stored in the DB; then we retrieve it to build our pdf when requested. Please, if you think of anything that can help me please let me know.
I have a quick question, If I host my website on a server different from EWON, will I bbe able to use the API you mentioned earlier to grab those files from the HMI?