Address geocoding project

Job ID: 38643971

Budget: €250 – €750 EUR

The aim of the project is to create a nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps:
1. Retrieve the xls file from the mailbox - cron every hour
2. Normalize the xls file for integration into a MySQL table
3. Configure access to SQL database from JavaScript.
4. Insert data into table via SQL query
5. Retrieve addresses to be geocoded from the SQL table.
6. Use Google Maps API to geocode each address.
7. Insert the geographical coordinates (latitude and longitude) in the SQL table.


Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mode of delivery, Drop sequence, PP number, Delivery date, Weight, Volume, Addressee, Name of addressee, Deliver address addressee, ZIP/postal Code, Delivery info, Number of cartons/units, Total ADR.

The data is sorted using the “Mode of delivery” information, which allows deliveries to be grouped by truck.
During the day's import, only lines with “Mode of delivery” information beginning with the letter Q should be imported.
A SQL table will be created in the database. Each day, with each file sent, data will be added to the table.
Related categories: JavaScript Node.js