This code imports stop information from a spreadsheet, downloads XML files from NaPTAN website then validates and adds stop information to those XML files.
- Load spreadsheet [✅️Done✅️]
- Download required xml files from NaPTAN [✅️Done✅️]
- Validate entries [🟡Partially done🟡]
- alert if atco codes are already in the xml [✅️Done✅️]
- validate the types for each field [🔴not done🔴] (This should be done with the schema)
- Insert into template [✅️Done✅️]
- Insert completed template into big xml file [✅️Done✅]
- add stops to stop points and areas to stop areas [✅️Done✅️]
- if there is an existing record update instead [✅️Done✅]
- Upload updated xml files using NaPTAN login? [🔴not done🔴]
- Create a basic UI for this [✅️Done✅️]
- Compile UI into an executable [✅️Done✅️]
pip3 install -r requirements.txt
python ExcelToXml.py