Trying to access USPTO external database

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

Trying to access USPTO external database

Postby kdawg440 » Fri Aug 17, 2012 6:27 pm

I am trying to access the US Patent and Trademark office database. I am extremely new at this database stuff, But I am a novice programmer. I know HTML and Java.
The XML files can be downloaded here.
http://www.google.com/googlebooks/uspto-patents-grants-text.html

However I do not know how to open it in either base or calc. I do not need the full text/images of the patents, just the owners of each patent, when they were owners, the type of patent(design, or utility), and maybe some other author data.

Please help.
OpenOffice 3.4 on Mac
kdawg440
 
Posts: 2
Joined: Fri Aug 17, 2012 6:21 pm

Re: Trying to access USPTO external database

Postby Villeroy » Fri Aug 17, 2012 8:36 pm

The page does not provide any database access. From that page you can download snapshots of some database in XML format. I don't know which software is supposed to be used with the specific flavour of XML. May be there is some database software for this. Then you may connect Base to such a database.
May be you can write (or download) some XSLT script which converts this specific XML to Calc's specific XML. Then you can view the contents in Calc.
Someone may have written some specific software to handle this XML.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 27899
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Trying to access USPTO external database

Postby kdawg440 » Fri Aug 17, 2012 9:40 pm

Thanks for the reply. Yes the USPTO website has some information on a document type definition (DTD). However Even when I downloaded this file I was unable to get anywhere.

This page has sample documents and DTD's, but you need to go to google for the XML file.
http://www.uspto.gov/products/xml-resources.jsp

There is a .XSL style sheet burried in the files along with various .dtd files. I have learned that .XSL files are used to turn .xml files into other .xml files. (also confusing)

Even whith the DTD the files in google (^see above) cannot be opened in browsers or base or calc.
Last edited by RoryOF on Tue Sep 18, 2012 5:24 am, edited 1 time in total.
Reason: Fixed typo.
OpenOffice 3.4 on Mac
kdawg440
 
Posts: 2
Joined: Fri Aug 17, 2012 6:21 pm

Re: Trying to access USPTO external database

Postby Villeroy » Sat Aug 18, 2012 1:25 pm

XML is no file format. It is a meta-file format. XML lets you define your own descriptive file formats within a clear set of rules. It's completely up to you how to process these data. I can not help without diving into the guts of that particular file format.
The publishing institution is the one and only authority which can be of any help here but the general idea is that you read XML data into your own application.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 27899
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Trying to access USPTO external database

Postby eremmel » Tue Sep 18, 2012 12:12 am

If you know java it is not difficult to write a small java program that takes an URL and DTD (or alike) and writes a csv that can be used as source for calc (and used as a database table). But there is also a tool from oracle that exposes XML files via a JDBC connector. I'm not sure if it is free, but there might other alike solutions. Google is just your friend.
It's Microsoft marketing that tells you computers are qualified for non-technicians
eremmel
 
Posts: 1041
Joined: Tue Dec 30, 2008 1:15 am


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 1 guest