Chip eServices Blog

Many companies use spreadsheets to upload and download data from myRMA.net. Downloading data to a spreadsheet is pretty straightforward as myRMA.net simply exports a CSV file. Uploading data is a bit more difficult because the data needs to be validated and existing records need to be updated rather than re-inserted.

Last week we had a reported problem from a user that had difficulty uploading model numbers using the template spreadsheet that we supplied. That spreadsheet template was developed in April 2006 and nobody had reported a problem since. The user confirmed that he was using Office 2007. We had developed the template using the VB scripting language in Office 2003.

It turned out that Office 2007 is far more picky about XML schema definitions than Office 2003. Darren explained it to be but I don’t understand the details. Suffice to say, all our template spreadsheets now work with both Office 2003 and Office 2007.

Job done…..