RodWS

Hi I'm in the early stages of planning a project that will use several netduino's to log and send data up to a main server for various clients to browse. I want to store data to a log in an interim fashion on the SD card - after a set period of time a chunk of older data is deleted to always allow for constant storage. Each device has a handful of sensors sampling data between every second or every minute so keeping say 72 hours of data is not that large - a CSV test sample was <5MB for 24 hours so the SD card has plenty in hand. I want to transfer the data in the log to the server in batches every 60 seconds (about <4Kb), and I want to use JSON to serialise the data up to the main server using a web service. One other thing I'd like to do is remotely view the log on the SD card on any device, I'm not sure if this is possible I don't plan to set the netduino's up as webserver's just push the data up. I am wondering what format I should store the data log in ? Write it straight to JSON or use XML and convert to JSON using JSON.NET or similar ? As I write this logging directly to JSON seems obvious but just thinking about reading the data remotely, would XML offer more flexibility or maybe simply CSV - I'll be looking at the data in column/row fashion to check for consistent readings and any problems from a sensor, etc. Any recommendations appreciated.