mysql upload scripts october 2013

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

gianluca.tarasconi
Posts: 62
Joined: Mon Nov 09, 2009 8:48 pm
Location: Italy
Contact:

mysql upload scripts october 2013

Post by gianluca.tarasconi » Tue Nov 26, 2013 10:00 am

dear all

from my blog at this link:

http://rawpatentdata.blogspot.it/2013/1 ... pload.html

is possible to download scripts for mysql that allow to upload last version of patstat


nico.rasters
Posts: 140
Joined: Wed Jul 08, 2009 5:51 pm
Contact:

Re: mysql upload scripts october 2013

Post by nico.rasters » Thu Dec 12, 2013 10:52 pm

You have to add ESCAPED BY '' because the EPO doesn't escape the backslash.
That is the reason behind the 25 delta imp for TLS202_APPLN_TITLE. Some lines end with \", MySQL quietly assumes that the backslash is escaping the double quotes and therefore the quote is ignored as an escaping character and the following line is included in the same record.

I think the PATSTAT documentation mentioned somewhere that all double quotes within texts are replaced by spaces. I think it would have been better to escape them... or to use a tab as a delimiter because then you wouldn't need double quotes as enclosing characters in the first place.

Anyway, if you add ESCAPED BY '' it will work... though I have a feeling the backslash is some sort of typo (it's right next to the Enter button).
________________________________________
Nico Doranov
Data Manager

Daigu Academic Services & Data Stewardship
http://www.daigu.nl/


gianluca.tarasconi
Posts: 62
Joined: Mon Nov 09, 2009 8:48 pm
Location: Italy
Contact:

Re: mysql upload scripts october 2013

Post by gianluca.tarasconi » Fri Dec 13, 2013 8:36 am

I'll try

thanks Nico


Post Reply