Convert CSV file to XML then FTP to server periodically
What I'm trying to do and which i can't really find is the following:
I want to periodically (eg: every 5 mins) convert a CSV file into XML either online without me having to do something or downloading the CSV convert it to XML and uploading it again to an FTP server every 5 minutes. I can't really find a program which does that and not really want to write it myself, so maybe someone ca开发者_运维技巧n point me in the right direction.
Yes this site here does it fairly handy. http://www.creativyst.com/Prod/15/ Programmatically, try using google app engine or use ADO.Net to query the Excel spreadsheet (SELECT * FROM [Sheet1] or whatever) and then just serialise the resulting dataset.
Do you have access to a unix server? I would recommend using shell scripting.
精彩评论