Learn About Patents Around the World

 
 
 
IN THIS SECTION
3 posts
GL
Last seen: 09/05/2022 - 10:19
Joined: 03/28/2018 - 05:26
issue in rawinventors.tsv ?

dear all

when uploading in MySQL rawinventors file I find one more field than in the description (deceased)

most of all in my system (win64) a carriage return char is found in RULE_47 field, making upload impossible without a manual correction

(see example below)

uuid    patent_id    inventor_id    rawlocation_id    name_first    name_last    sequence    rule_47    deceased
0000hccb98m2kc6g1v7128k5w    7646155    4341225-2    omi6wqlrblholsssk9qx0dz5b    Samuel G    Woods    0    
    NULL

any suggestion?

thanks

GL

 

 

Sat, 06/22/2019 - 16:00
Russ
Last seen: 03/21/2024 - 09:05
Joined: 11/14/2017 - 22:15
I was able to load the first…

I was able to load the first 100,000 lines of file into a mysql table by saying "Lines terminated with: \n" .  The import failed when I left "Lines terminated with: auto".  The whole file is large than allowed for import by my isp (1000M) but I was able to load a shortened file that contained carriage returns as you noted.

Russ

 

 

Fri, 06/28/2019 - 15:01
PVTeam
Role: moderator
Last seen: 04/24/2024 - 12:31
Joined: 10/17/2017 - 10:47
Re: Response to ISSUE IN RAWINVENTORS.TSV

Hi,

Thank you for bringing this up! We have resolved the carriage return issue in rawinventors.tsv. You can now access the fixed file through the bulk downloads page.

Thanks,

PVTeam