hello everyone
I need a web based application for private use, where i can load a list of work orders in an excel file and it will find the addresses and display as pins on a map of our area. Each pin will need to be able to be assigned a color or numbers we can easily change to assign different techs to the workorder. clicking on a pin would open a popup with the workorder info , and another link would bring up the tech info from a database already built elsewhere and connect to [login to view URL] other database tracks paymnet and inventory and where the tec h is currently working, so this project will need to connect to that database to check the techs tables to be able to display a highlited pin indicating the tech is currently there, and if clicked it will show the techs inventory. if a tech completes the workorder thru the other databse, it will be cleared from the map.
after loading a file of workorders into the databse, the reassigned jobs willalter the original file and it can be exported in the same format with the rearranged techs and workorder pairings. any bad dat will need to be able to be manually pinned and have the addresses altered. or pin drop override so we can move the pin in case of a seperate billing address but the service address is elsewhere.
if you would also like to build the main database that this map app is connecting to, then bid on my other project aswell.
low bids win with fast completion times.