Using Spreadsheets for Data Import
Published by Jerry Sweeney April 14th, 2006 in Chip eServices News, Web VideosCopy this hyperlink to a browser to see a Web video on data import to the Chip eServices Suite using Excel 2003 and Web services.
Data import to the Chip eServices Suite using Excel 2003 and Web services
Very interesting indeed. I had kown that Microsft had made it’s Office application suite XML-compataible and it’s great to see a successful implementation of a Web services integration project using the concept. I’d imagine that there are plenty of Chip eServices customers who will leverage this technology. Setting up the system for customers has in the past been quite a tedious job with plenty of importing to SQL etc. This concept offers two main advantages as I see it 1) validation of the uploads is now automated through Web services and reduces the possibilities of errors 2) Removes the need for Chip eServices employees to spend time importing data. Another great advantage is one that was outlined in the webcast in that spare parts suppliers or manufacturers may utilise the spreadsheet to do across the board price changes quite quickly and effortlessly. I am sure that the technology could also be used in many other areas of myRMA.net such as Part Numbers, Critical BOM’s etc. Great work!