search

italia / daf-ontologie-vocabolari-controllati

Elenco di ontologie e vocabolari controllati. Per maggiori informazioni, si veda il readme principale e quello di singoli vocabolari/ontologie, ove presente, e la seguente documentazione
https://github.com/italia/daf-ontologie-vocabolari-controllati/wiki
Creative Commons Attribution 4.0 International
80 stars 52 forks source link

Verify CSV format #125

Closed ioggstream closed 2 years ago

ioggstream commented 2 years ago

I expect

CSV files to be well-formed

ioggstream commented 2 years ago 
# -------
# invalid: VocabolariControllati/classifications-for-transparency/transparency-obligation/transparency-obligation-administration.csv
# -------

====  =====  ==========  ======================================================================================================================
row   field  code        message                                                                                                               
====  =====  ==========  ======================================================================================================================
1379      1  type-error  Type error in the cell "040102 040201" in row "1379" and field "id_obbligo" at position "1": type is "integer/default"
1476      1  type-error  Type error in the cell "040102 040201" in row "1476" and field "id_obbligo" at position "1": type is "integer/default"
1573      1  type-error  Type error in the cell "040102 040201" in row "1573" and field "id_obbligo" at position "1": type is "integer/default"
1670      1  type-error  Type error in the cell "040102 040201" in row "1670" and field "id_obbligo" at position "1": type is "integer/default"
1767      1  type-error  Type error in the cell "040102 040201" in row "1767" and field "id_obbligo" at position "1": type is "integer/default"
1864      1  type-error  Type error in the cell "040102 040201" in row "1864" and field "id_obbligo" at position "1": type is "integer/default"
1961      1  type-error  Type error in the cell "040102 040201" in row "1961" and field "id_obbligo" at position "1": type is "integer/default"
2058      1  type-error  Type error in the cell "040102 040201" in row "2058" and field "id_obbligo" at position "1": type is "integer/default"
2155      1  type-error  Type error in the cell "040102 040201" in row "2155" and field "id_obbligo" at position "1": type is "integer/default"
2252      1  type-error  Type error in the cell "040102 040201" in row "2252" and field "id_obbligo" at position "1": type is "integer/default"
2349      1  type-error  Type error in the cell "040102 040201" in row "2349" and field "id_obbligo" at position "1": type is "integer/default"
2446      1  type-error  Type error in the cell "040102 040201" in row "2446" and field "id_obbligo" at position "1": type is "integer/default"
2543      1  type-error  Type error in the cell "040102 040201" in row "2543" and field "id_obbligo" at position "1": type is "integer/default"
2640      1  type-error  Type error in the cell "040102 040201" in row "2640" and field "id_obbligo" at position "1": type is "integer/default"
2737      1  type-error  Type error in the cell "040102 040201" in row "2737" and field "id_obbligo" at position "1": type is "integer/default"
2834      1  type-error  Type error in the cell "040102 040201" in row "2834" and field "id_obbligo" at position "1": type is "integer/default"
2931      1  type-error  Type error in the cell "040102 040201" in row "2931" and field "id_obbligo" at position "1": type is "integer/default"
3028      1  type-error  Type error in the cell "040102 040201" in row "3028" and field "id_obbligo" at position "1": type is "integer/default"
3125      1  type-error  Type error in the cell "040102 040201" in row "3125" and field "id_obbligo" at position "1": type is "integer/default"
3222      1  type-error  Type error in the cell "040102 040201" in row "3222" and field "id_obbligo" at position "1": type is "integer/default"
3319      1  type-error  Type error in the cell "040102 040201" in row "3319" and field "id_obbligo" at position "1": type is "integer/default"
3416      1  type-error  Type error in the cell "040102 040201" in row "3416" and field "id_obbligo" at position "1": type is "integer/default"
====  =====  ==========  ======================================================================================================================
giorgialodi commented 2 years ago

Sorry @ioggstream these validation errors are only in the "transparency-obligation-administration.csv" file? Because that file was generated by running some sparql queries (so from the turtle file); thus, I need to better understand. Probably, it is easier to open it with open refine and fix some validation issues.

ioggstream commented 2 years ago

Sure. Let's focus on the quick fixes for now.

ioggstream commented 2 years ago

Other typos: columns on multiple rows when converting from XLS to CSV

giorgialodi commented 2 years ago

@ioggstream I remember this has been fixed, right? Can we close it?

ioggstream commented 2 years ago

I have to run the csv-validator :)

ioggstream commented 2 years ago

Closed in favor of #172