Project: XML to SQL ID: 1229455482

PROJECT DETAILS

Comments (0)

	Status:	Closed (Chosen Programmer: takman; Paid; Rated 10 out of 10)
	Budget:	N/A
	Created:	12/16/2008 at 14:24 EST
	Closed:	12/26/2008 at 15:14 EST
	Project Creator:	jmicheal Rating: (1 review) Rated 10 out of 10 for this project.
	Description:	I'm fairly new to the XML stuff and we have a problem. We have a program that exports our articles from different categories into different XML files. These are then uploaded to our site through FTP. I've been trying to use several posted examples using SQLXMLBulkLoad to batch load the files. Y'no read all the XML files in the directory and then import them into the SQL database. I'm just not having any luck and we're running out of time. We're needing a programmer to get it done for us NOW since we can't afford the time for my learning curve. If anyone could help please let me know and your rates. Samples of the XML files are attached. The tags in the XML to the SQL the database fields as follows: SQL Database name: NEWS SQL Table NEWSARTICLES These are the XML to SQL fields and SQL data types. XML=article_title to SQL=article_title (data type nvarchar) pubdate to release_date (data type datetime) aricle_cat to article_cat (int 4) article_publish to article_publish (bit 1) article_frontpage to article_frontpage (bit 1) article_headlines to article_headlines (bit 1) article_body to article_body (ntext) uniqueid to issue_id (int 4) So, we need a VB and/or ASP script to import all the different named XML files that were uploaded to a directory and import them into an existing SQL database. It would be great if we had a VB script, then we could schedule it to run and ALSO an ASP script to run from the web. (please no ASP.NET) It's running on a Microsoft 2000 Server with SQL 2000 and IIS5. I need something ASAP!!! Thanks Micheal Additional Info (Added 12/17/2008 at 10:58 EST)... Just to clarify some responses: This needs to be in VB/ASP and be very easy for the user to start. If VB then we could set the script up to be scheduled to run. If I also has the ASP version, we could then have a user run it from a web page. The various named XML files are uploaded to a directory. The script needs to read all of the files in that directory and import them directly into the SQL database. Just a note, I had part of a script working with SQLXMLBulkLoad on the SQL Server. This was the preferred method from my research on the web. Again this need to be VB/ASP script Thanks again Micheal Additional Info (Added 12/17/2008 at 11:03 EST)... Attached file: XMLVBExample.vbs File info: Example that will import 1 file but I need it to do all
	Tags:	XML, ASP, SQL, Visual Basic

Messages Posted: 42

PROJECT BIDS

	Programmers	Bid	Delivery Time	Time of Bid	Rating
	rishchand	$30	1 day	12/21/2008 at 9:53 EST	(No Feedback Yet)
	Hi Greetings from KLYMB solutions!!! Please read PMB for more details
	msayed	$30	1 day, 1 hour	12/17/2008 at 2:26 EST	(2 reviews)
	Hello Please Check PMB
	deeptitech	$75	3 days	12/17/2008 at 12:17 EST	(No Feedback Yet)
	Will be delivered as per your expectations..
	mrajeshku	$80	2 days	12/16/2008 at 16:03 EST	(No Feedback Yet)
	Ready to work.
	takman	$94	1 day	12/22/2008 at 11:01 EST	(4 reviews)
	Hi, Please check PMB. Sample ready. Regards
	sweety	$100	Immediately	12/23/2008 at 10:26 EST	(No Feedback Yet)
	I am ready to help you to complete this project. I can try to deliver the work ASAP. 100% satisfaction guaranteed.
	shashisoftware	$100	3 days	12/16/2008 at 15:22 EST	(13 reviews)
	please check PMB. Thanks
	pacex	$145	3 days	12/16/2008 at 15:39 EST	(88 reviews)
	WE ARE READY TO START!!
	chell	$175	1 day	12/17/2008 at 15:03 EST	(24 reviews)
	Here is the expert to complete this task in a day. Please check your PMB for more details. Thanks Chell
	rgltd	$180	4 days	12/16/2008 at 14:37 EST	(20 reviews)
	can be done quickly . thanks in advance ..
	maborakprogrammer	$200	3 days	12/16/2008 at 15:56 EST	(96 reviews)
	Easy.
	ts2001	$200	5 days	12/16/2008 at 21:28 EST	(10 reviews)
	I can do a VB script for XML data parsing and import into MS SQL database.
	delta1	$220	3 hours	12/16/2008 at 14:44 EST	(105 reviews)
	Please see PMB, thank you.
	majic	$240	2 days	12/23/2008 at 16:09 EST	(No Feedback Yet)
	Solid solution - will deliver - can deliver.
	qualityengineering	$300	1 day	12/22/2008 at 11:03 EST	(2 reviews)

		Related Projects:	pst to sql database AEP SQL injectION XML & osCommerce integration IM-XML with OSCOMMERCE XML Request Response Converted	More...