ftpxmlconverter

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.

To Use:

• clone the repo
• npm install
• ftp the file to your desired location
• update the ftpConnection and connection in index.js for the ftp and mysql connections.

Packages

• fs
• ftp
• mysql
• xml-to-json

File

• 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.

MySQL

• The sql folder holds the sql export of the database.