Find Jobs
Hire Freelancers

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

$250-750 USD

Finalizat
Data postării: aproape 8 ani în urmă

$250-750 USD

Plata la predare
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>
ID-ul proiectului: 10607896

Despre proiect

5 propuneri
Proiect la distanță
Activ: 8 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
Acordat utilizatorului:
Avatarul utilizatorului
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 în 28 zile
5,0 (7 recenzii)
5,0
5,0
5 freelanceri plasează o ofertă medie de $470 USD pentru proiect
Avatarul utilizatorului
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 în 6 zile
5,0 (22 recenzii)
5,4
5,4
Avatarul utilizatorului
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 în 15 zile
5,0 (22 recenzii)
4,9
4,9

Despre client

Steagul UNITED STATES
undefined, United States
4,7
2
Metoda de plată a fost confirmată
Membru din mai 25, 2016

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.