In Progress

Excel to XML conversion program, Visual Basic

Jax Music Supply is an online based guitar and accessories retailer. Started in 2007, we market on a variety of web based platforms including eBay, Amazon, and our website. We are in the process of upgrading our tools to allow easier automation. To that end, we need a bulk upload function for one of our marketplaces.

Generally speaking, the software would allow the selection of an Excel worksheet (either Excel 2003-2007 and/or Excel 2010. The Excel sheet would have the necessary information to be uploaded (we will provide example). The program would then convert the information, row by row, to an XML format and submit it to a web service for bulk listing. Return information from the XML submission would need to be logged into either database or excel file.

Graphics will need to be transmitted as well. We would like to be able to provide a URL to a graphic image in the spreadsheet the program should be able to grab the image at that URL that can then be converted into base64 as a CDATA type in the XML stream.

The solution needs to be coded in Visual Basic 2008. We will need a copy of the source code when complete. The code must be well documented with a general description of the class/module/function (at the beginning) including what it does. Code should be well documented with logical variable names and a comment describing what the variable is used for (obvious variables such as iCounter are exempt from this requirement). Failure to document code properly will result in poor feedback.

We have tested example code for connecting to the webservice that will be provided upon acceptance.

Skills: .NET, Excel, Visual Basic, XML

See more: excel xml conversion, visual basic xml program, visual conversion excel xml, convert excel xml, code convert excel xml, excel xml visual basic, convert visual basic xml, excel xml 2008, visual basic 2010 excel xml, visual basic convert excel xml, convert excel 2007 file xml, visual basic excel xml, visual basic xml conversion program, excel xml web, xml to xml online, what is exempt, visual basic for website, visual basic 2008 online, visual basic 2007 online, service stream, program c++ online, program c# online, online visual basic 2010, online submission service, online it program

About the Employer:
( 19 reviews ) Midlothian, United States

Project ID: #1155943