Jump to navigation Jump to search
Then, run the normalizer on the text file. To do this:
Open up a command line or powershell e: cd .\McNair\PatentData/Maintenance Fee Data perl -file=MaintFeeEvents_20170410-wHeaders.txt
Schema for maintenance fee table, called according to documentation: Column | Type | Modifiers ---------+-------------------+-------Where "MaintFeeEvents_20170410-wHeaders" is the name of the file with the added headers at the top. This script will put the normalized (cleaned) file in MaintFeeEvents_20170410-wHeader-normal.txt (basically appends "-normal" to whatever file name you pass it). patent | character varying | appnum | integer | size | character varying | filedate | date | gdate | date | feedate | date | feecode | character varying | To then make a table out of the normalized text file, use the SQL detailed on the following page.
Based off opening the text file mentioned in the instructions in the above link and the This will create entirely new text file I downloaded tables from USPTO bulkthe maintenance fee data. To avoid repeating data, that text file is already we will most likely just replace the existing tables in the correct format to load into the database using with the code in Patent Expiration Rules. Seems like it was cleaned first though, and there doesn't seem to be a way (currently) to specify where we want to start loading new data into the databasetables.
===For the USPTO Historical Patent Data===

Navigation menu