I queried database to get sum of pallets that were transferred in and sum of pallets returned, as these are the quantities I need for my second chart. Also added some security against SQL injection.
CHEP Pallets / Data Analytics / Excel / Logistics Administrator
CHEP Pallets Monitoring And Report. Step 8
In this post I explain why an excel file that should contain 6 months worth of transfers only has 4. Also came up with idea for a new chart.
CHEP Pallets / Data Analytics / github / Logistics Administrator / PHP / SQL / Uncategorized
CHEP Pallets Monitoring And Report. Step 7
I managed to achieve the array structure layed out in previuos post, and it can be sent over to front end. I also learn some new things about arrays and updated my previuos PHP code.
CHEP Pallets / Data Analytics / github / Logistics Administrator / PHP / SQL
CHEP Pallets Monitoring And Report. Step 6
Start to SQL querie database in back end with PHP in order to retrieve the data I need for charts. Will also start to arrange data in a manner that will enable me to send it to front end for the charts to be drawn.
CHEP Pallets / Data Analytics / Logistics Administrator / PHP / Protean / SQL
CHEP Pallets Monitoring And Report. Step 5
After uploading data to database I started running SQL queries and my concerns that it will be difficult to monitos CHEP pallets are confirmed.
CHEP Pallets / CSS / Data Analytics / Excel / github / HTML5 / javacsript / Logistics Administrator / PHP / SQL
CHEP Pallets Monitoring And Report. Step 4
Started coding CHEP pallets report. Already created a website where you upload the transaction report and then upload the chosen columns to database for SQL querying.
CHEP Pallets / Data Analytics / Excel / Logistics Administrator
CHEP Pallets Monitoring And Report. Step 3
Let’s examine the Transaction report excel file from my.chep.com website and determine which columns with data will be used to create the chart.
CHEP Pallets / Data Analytics / Logistics Administrator
CHEP Pallets Monitoring And Report. Step 2
After some consideration I decided that one way to do it is by coding a website to upload an excel file and generate a chart.
CHEP Pallets / Data Analytics / Logistics Administrator / Protean
CHEP Pallets Monitoring And Report. Step 1
Been assigned a task to figure a way to monitor discrepancies in CHEP pallets, but I’m running into quite a few issues.