Automate XML-CSV conversion and File Upload

Job ID: 32652972

Budget: $12 – $30 SGD

I need a freelancer who can show me how to do the following task. Final result includes the step by step task and final script needed to perform the following tasks:

How to convert
1. Download JD Central feed by the link below
- http://tdc.jd.co.th/productFeedV2.do

2. Filter out non-fashion products by product type field
<g:product_type>
- Extract products for Clothing/Bags/Shoes for Women &
Men’s fashion
Extract following fields in XML
<g:image_link>
<g:link>
<g:title>
<g:sale_price>
<g:id>

3. Change field name and convert XML to csv file
1) image_link -> image_url
2) link -> product_url
3) title -> name
4) sale_price -> price
5) id -> product_code


4. create 1 converted csv files: jd_th_feed.csv
5. Upload the converted csv to the upload folder of the file server for example (http://54.xxx.xxx.xxx/upload)
6. Automate No.1 ~ 5 at 18:00 SGT everyday
Related categories: XML Shell Script Scripting Automation