NodeJS Ftp to a location download a xml file. Take that file and convert the xml to json. Store the original data and the json in mysql.
- clone the repo
- npm install
- ftp the file to your desired location
- update the
ftpConnectionandconnectionin index.js for the ftp and mysql connections.
- fs
- ftp
- mysql
- xml-to-json
- Copy test.local.xml-1487188889557 to test.xml and then upload to the ftp location.
- Or use other xml file. If you want you can delete the downloads folder it will be created automatically when ran if it does not exist.
- The sql folder holds the sql export of the database.