Parse xml / match records in sql / insert rows - quick task..
$30-250 USD
已完成
已发布将近 12 年前
$30-250 USD
货到付款
Part 1:
Have a quick task of parse a sitemap xml - has <loc>string</loc> obviously..
Need to insert all rows into sql server (will change connection string when done, you can use local sql express to test)..
You will need to pull down a sitemap file to test..
Add columns for tofetch (bool, default null), fetchedby (varchar(50) default null), lastattempt (Datetime, default null), error (bool, default 0)
Clustered index on id (ident column).
Create an index on loc
Part 2:
Read a row from an existing table
Replace \/ with / (stored wrong in db)
Check your table for matches
If matched set tofetch=0
Create a test table for this and populate with some rows..
Deliverables:
C# Project
SQL Create scripts
We will then compile, change the connection string to our sql server, and test then pay.
NOTE: Would like to have this script DONE today so please only bid if you can start immediately.