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]
[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 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>
Section 8 <section-8-filed-in>
Section 8 partial <section-8-partial-accept-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>
6 freelancer đang chào giá trung bình $446 cho công việc này
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
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.