In Progress

XML Parse read and post to a SQL Database

I'm looking for a script or compiled (vb.net only) with source code that will process and XML file and write the records to a SQL 2008 database.

I have already created the tables (1) and have the connection info ready. Your code will open the xml file (sample attached) and based on the parent node in XML, will write the values to the columns in the database. There is one table. The XML report will have other values but I only care about what is in between <items></items> The rest of the data can be dropped.

Earnings

I may run this script daily and the report may have same data so your script/exe will need do a lookup and find if the record already exists in the database. You can do this by a lookup on certain fields Example for Items Ordered it would be ASIN, Tag, and Date.

This is pretty straight forward and simple for someone that knows how to parse XML files and write to a database.

/****** Object: Table [dbo].[tbl_AmazonEarnings] Script Date: 11/08/2012 17:22:37 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tbl_AmazonEarnings](

[ID] [int] IDENTITY(1,1) NOT NULL,

[ASIN] [nchar](10) NOT NULL,

[Binding] [nvarchar](50) NULL,

[Category] [int] NULL,

[OrderDate] [date] NULL,

[Edate] [int] NULL,

[Earnings] [decimal](19, 2) NULL,

[LinkType] [nvarchar](5) NULL,

[Price] [decimal](19, 2) NULL,

[Qty] [int] NULL,

[Rate] [decimal](19, 4) NULL,

[Revenue] [decimal](19, 4) NULL,

[Seller] [nvarchar](50) NULL,

[SellerTag] [nvarchar](50) NULL,

[Title] [nvarchar](max) NULL

) ON [PRIMARY]

GO

For clarification, I want a ASPX (vb.net) file to upload this XML to a SQL database connected to same server. I should be able modify the ASPX VB file and put in my own DSN connection string and XML upload button will upload. Thanks.

Skills: .NET, ASP, Visual Basic

See more: sql price, sql create table price, read find and write, rate visual basic, open source sql, may 11. 2008, how to write vb net code, how to write vb, how to write simple report, how to write code in vb net, how to write a simple report, how to null a script, how do you write a report, how do i write a report, how do i find a seller, how can one write a report, find someone to write a code, c read example, care connection, what is object, what is node, what is a asp, xml post, visual identity, sql database report

About the Employer:
( 25 reviews ) Daytona Beach, United States

Project ID: #2632854

Awarded to:

HenrichCristian

.Net developer with experience in SQL Server and Xml parsing.

$40 USD in 2 days
(5 Reviews)
3.7

6 freelancers are bidding on average $63 for this job

ITservice

Hi Will be interested doing the similar project again. Thanks

$100 USD in 2 days
(73 Reviews)
6.5
Rahul2012

[url removed, login to view]

$50 USD in 1 day
(24 Reviews)
5.5
RainbowTechs

Ready to start work. Kindly check your PMB.

$100 USD in 2 days
(8 Reviews)
4.7
nnquy

Expert in VB.NET, ready to start now

$35 USD in 3 days
(6 Reviews)
1.6
cristynel

This is very simple...If you accept the price...chose my offer. Thanks!

$50 USD in 2 days
(0 Reviews)
0.0