Im looking to programme something that will automatically retrieve certain data from within a word document that is sent in a standard format daily, and then storing this data in a database.
Thats all I need help thinking about at the moment, the next phase of the programme will be to plot the coordinates(which are given in email) for each of the entries on a map, and then display a little point on the map which can be hovered over, bringing a popup box up which then displays other information which came with the coordinates, such as information, dates, times and its unique identifier.
Basically im flirting with the idea of making something that I can load the daily email we get at work with all the NOTAMs(notice to airmen) into, which then processes the individual ones and plots them automatically, replacing the need to replot them everyday, and having to sort through them manually for anything that is on aircraft flightpaths.
Other handy features will be that it can automatically flag up anything within certain areas, streamlining work for other flight planning tasks.
Anyway the question.. what would you as a programmer use to get the information from word into a database, and would there be something you would prefer to use to do the whole thing with, including the plotting and everything.
Im not that clued up on programming anymore, havnt done any since I finished uni last year, and didnt really touch it too much over 3rd and 2nd years seriously, but I learn fast and im willing to learn.
Not so much a deadly serious project, just something Iv flirted with doing as it will make life at work easier, and look great for me if I do it well, itll also give me something to do when im bored too.. even at work where they wont mind me sitting playing with it!
Thats all I need help thinking about at the moment, the next phase of the programme will be to plot the coordinates(which are given in email) for each of the entries on a map, and then display a little point on the map which can be hovered over, bringing a popup box up which then displays other information which came with the coordinates, such as information, dates, times and its unique identifier.
Basically im flirting with the idea of making something that I can load the daily email we get at work with all the NOTAMs(notice to airmen) into, which then processes the individual ones and plots them automatically, replacing the need to replot them everyday, and having to sort through them manually for anything that is on aircraft flightpaths.
Other handy features will be that it can automatically flag up anything within certain areas, streamlining work for other flight planning tasks.
Anyway the question.. what would you as a programmer use to get the information from word into a database, and would there be something you would prefer to use to do the whole thing with, including the plotting and everything.
Im not that clued up on programming anymore, havnt done any since I finished uni last year, and didnt really touch it too much over 3rd and 2nd years seriously, but I learn fast and im willing to learn.
Not so much a deadly serious project, just something Iv flirted with doing as it will make life at work easier, and look great for me if I do it well, itll also give me something to do when im bored too.. even at work where they wont mind me sitting playing with it!
