Đã hoàn thành

Create utility which will extract data from huge XML file into database

Technologies to use: vbscript, sql server, xml, SAX xml

1. Create utility which will extract fields into the database table for each trademark.

From the page [url removed, login to view]

Or

[url removed, login to view]

Download and process each xml file to produce trademark historical database.

Create vb script program which will be used to process those files. Files are huge so they must be processed in portions otherwise it will overwhelm the computer. Results of extraction must be placed into SQL tables

Records are in 50+files, Wherein, file 1 has oldest records and file 50 + will have the most recent records. The last file will contain records with status 969 . We do not need those. Whatever is the last record before that will be cutoff line(X). So next year we will need to upload all records where Serial number is >X.

2. List of fields to be extracted.

Word Mark <mark-identification>

Serial Number: <serial-number>

Status <status-code>

Status Date <status-date>

Filing Date <case-file-header><filing-date>

Registration Number <registration-number>

Registration Date <case-file-header> <registration-date>

Owner: <case-file-owners><case-file-owner> --take only first

Owner entry-number <entry-number>1</entry-number>

Owner party-type <party-type>20</party-type>

Owner nationality <nationality>

Owner Entity type <legal-entity-type-code>

Owner Name <party-name>

Owner Address <address-1>

Owner City <city>

Owner Country <country>

Owner Zip <postcode>

Under <case-file> <case-file-header>

Renewal <renewal-filed-in>

Section 8 <section-8-filed-in>

Section 8 partial <section-8-partial-accept-in>

section-8-accepted-in <section-8-accepted-in>F</section-8-accepted-in>

section-15-acknowledged <section-15-acknowledged-in>

section-15-filed-in <section-15-filed-in>

supplemental-register-in <supplemental-register-in>

Each Class of goods—can be multiple

Goods and Services: <case-file-statement> <type-code>GS0321</type-code>

Class <classifications> <classification><international-code> -- multiple

Mark Description <case-file-statement> <type-code>DM0000</type-code> <text>

Kĩ năng: SQL, XML

Xem nhiều hơn: xml use case, uspto zip code, uspto gov, section 8 com, filing data entry, date utility, data entry class, database technologies, data3, computer utility program, data xml file database net, create xml file database record, extract xml file database, sql server insert xml file database, net insert xml file database, inser xml file database, example xml file database vbnet, save xml file database, xml file database using vbnet, dumping xml file database contents

Về Bên Thuê:
( 2 nhận xét ) undefined, United States

ID dự án: #10607896

Được trao cho:

bspanovic

Hello You can look and test one of mine application's on this link: [login to view URL] Log on as jrellsve , paswword is jrellsve I'm Microsoft Certified Database Developer. My Microsoft transcript you Thêm

$500 USD trong 28 ngày
(3 Đánh Giá)
4.9

6 freelancer đang chào giá trung bình $446 cho công việc này

mantislin

Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi

$441 USD trong 6 ngày
(21 Nhận xét)
5.3
BitSDestiny

I am 9+ Years of Experienced Software Developer. ASP .Net , C# , VB .Net , MVC,Visual Basic, Excel VBA , MS SQL Server , MYSQL , Oracle , MS Access, Crystal Report, Telerik , Bootstrap , HTML 5 , CSS , Java Script ar Thêm

$500 USD trong 15 ngày
(21 Nhận xét)
4.8
bhaveshkhatarani

We will complete your project with in your time requirement. we have great skills in Android, iPhone, php, Angular JS,Node JS, Laravel Coddeigniter, Wordpress, Magento , HTML/CSS, Database query, AJAX, Jquery. we Thêm

$611 USD trong 10 ngày
(3 Nhận xét)
3.4
$300 USD trong 5 ngày
(4 Nhận xét)
2.8
andyzav

Hi! I'm a professional software developer with 10+years of experience, including many completed work with SQL. Ready to work on your project, so please message me for details.

$322 USD trong 5 ngày
(3 Nhận xét)
2.6