Find Jobs
Hire Freelancers

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

$250-750 USD

Imekamilika
Imechapishwa almost 8 years ago

$250-750 USD

Kulipwa wakati wa kufikishwa
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 [login to view URL] Or [login to view URL] 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>
Kitambulisho cha mradi: 10607896

Kuhusu mradi

5 mapendekezo
Mradi wa mbali
Inatumika 8 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
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 can check on this link: [login to view URL] I have 20+ years experience with Access and 15+ with SQL Server. For your project I advice that we build it on Microsoft ASP.NET MVC framework, with HTML5, CSS3 , jQuery and Bootstrap for modern User Interface with Responsive design (for use on any device). As Database I suggest Microsoft SQL Server Database because is fast, native multi user database with excellent backup capabilities. With work I could start immediately. If needed I will adjust my working hour's to your time zone. RGD's Borut Spanovic
$500 USD ndani ya siku 28
5.0 (7 hakiki)
5.0
5.0
5 wafanyakazi huru wana zabuni kwa wastani $470 USD kwa kazi hii
Picha ya Mtumiaji
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 ndani ya siku 6
5.0 (22 hakiki)
5.4
5.4
Picha ya Mtumiaji
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 are my working domain. I am confident to complete the project.
$500 USD ndani ya siku 15
5.0 (22 hakiki)
4.9
4.9

Kuhusu mteja

Bedera ya UNITED STATES
undefined, United States
4.7
2
Njia ya malipo imethibitishwa
Mwanachama tangu Mei 25, 2016

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.