377
edits
Changes
Jump to navigation
Jump to search
Seems to contain instructions for making maintenance fee and fee code tables in table - but how do we parse the original data? http://mcnair.bakerinstitute.org/wiki/Patent_Expiration_Rules
Redesigning Patent Database (view source)
Revision as of 14:18, 27 April 2017
, 14:18, 27 April 2017→For the USPTO Maintenance Fee Data
===For the USPTO Maintenance Fee Data===
Download the file manually from https://bulkdata.uspto.gov/data2/patent/maintenancefee/and replace existing place file in McNair/Patent Data/Maintenance Fee Data.Then, go into the file and add headers for each column separated by spaces (make sure that each header lines up with the start of the column. To see an example of how to do this, look at the example file MaintFeeEvents_20170410-wHeader.txt under McNair/Patent Data/Maintenance Fee Data. Then, run the normalizer on the text file. To do this: Open up powershell
Schema for maintenance fee table, called according to documentation:
feecode | character varying |
Based off opening the text file mentioned in the instructions in the above link and the new text file I downloaded from USPTO bulk, that text file is already in the correct format to load into the database using the code in Patent Expiration Rules.
