377
edits
Changes
Jump to navigation
Jump to search
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.
Redesigning Patent Database (view source)
Revision as of 14:25, 27 April 2017
, 14:25, 27 April 2017→For the USPTO Maintenance Fee Data
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 NormalizerFixedWidth.pl -file=MaintFeeEvents_20170410-wHeaders.txt
http://mcnair.bakerinstitute.org/wiki/Patent_Expiration_Rules
===For the USPTO Historical Patent Data===
