I have a spreadsheet that is getting very busy and I need to move it now to SQL and then have a web page reporting the data.
I need this excel sheet to log the information direct to MSSQL server for the reporting.
I need the vehicles to each have an individual trackable with each of the tasks
I need for each of the locations to report and count the number of buckets placed into them or removed from them.
I need the reports capability at a minimum for the ones shown in the excel file.
Also I need a html or browser version of a live reporting
Web page to be Total movement from a selected date and time with bucket and tonnes and a target tonnes for the period of time. THis should update every 5 minutes.
Location of materials - a live tracker showing the actual current live totals of each of the locations. Need a way to add in new locations and an estimated target material storage value
Need to be able to track the vehicle that is moving the material, where it moved it, and how long it took to move, also the operator driving the vehicle.
Material is not always dirt - Ore or Waste, for drills it it bolts, Upholes, Down holes, face holes
For Agigitator it is Paste fill mix cubic meter
Need also to refer the material as Production or development
Also need the SQL to capture data direct from FTP file transfers and also source other information through an API from Pi, Postgress, Oracle or SQL.
11 фрилансеров(-а) в среднем готовы выполнить эту работу за $152
I am having 4 years of experience in Sql and Plsql programming and also having good experience in loading data to Database tables from flat files.
I am ready for your project now. I can do it and start right now and available for you with fulltime manner. I would like to have a more detailed discussion with you on the chat. Thanks.
I am data warehousing professional with 11 years of experience and i have proven expertise in handling various file formats and develop code to parse various file formats
I am an expert level SQL programmer, with over 15 years of experience coding, able to solve bugs that have stumped other people. I also have extensive experience in Excel and Access.