Patstat 2014b mysql upload scripts

 Autumn 2014 patstat ediction (now onward 2014b) has just been released.
 Here you can download the mysql scripts I made for uploading the files from DVDs data.

remember to customize them for your own upload directory / target library
also note I did not upload TLS 203, 222 and 223 but scripts should work fine

Here below a comparison with expected records and october 2013 version

table	date of files	declared	patstat Y-1	imported	delta imp	delta y-1
tls201_appln	2014b	80025895	76594275	80025895	0	4.48%
tls202_appln_title	2014b	60127407	57335762	60127391	16	4.87%
tls203_appln_abstr	2014b	36607548	33870394	36607548	0	8.08%
tls204_appln_prior	2014b	35035840	33615459	35035840	0	4.23%
tls205_tech_rel	2014b	2149383	2138085	2149383	0	0.53%
tls206_person	2014b	47827725	44730405	47827690	35	6.92%
tls207_pers_appln	2014b	176679567	163534542	176679567	0	8.04%
tls208_doc_std_nms	2014b	22127059	19409591	22127059	0	14.00%
tls209_appln_ipc	2014b	195884529	176153334	195884529	0	11.20%
tls210_appln_n_cls	2014b	22016211	21884148	22016211	0	0.60%
tls211_pat_publn	2014b	90478383	85733781	90478383	0	5.53%
tls212_citation	2014b	160518077	142247157	160518077	0	12.84%
tls214_npl_publn	2014b	25448833	22095090	25448826	7	15.18%
tls215_citn_categ	2014b	23690308	22390889	23690308	0	5.80%
tls216_appln_contn	2014b	2459400	2272520	2459400	0	8.22%
tls218_docdb_fam	2014b	71081760	67766434	71081760	0	4.89%
tls219_inpadoc_fam	2014b	78312042	74865923	78312042	0	4.60%
tls221_inpadoc_prs	2014b	157857976	135555494	135555494	0	16.45%
tls222_appln_jp_class	2014b	304165357	294109156	294109156	0	3.42%
tls223_appln_docus	2014b	39008347	36668997	36668997	0	6.38%
tls224_appln_cpc	2014b	149340067	137478291	149340067	0	8.63%
tls226_person_orig	2014b	52524269	47699382	52524269	0	10.12%
tls227_pers_publn	2014b	210802117	193982180	210802117	0	8.67%