Changes

Jump to navigation Jump to search
===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 |
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
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.

Navigation menu