{"id":27517,"date":"2017-04-10T14:32:49","date_gmt":"2017-04-10T12:32:49","guid":{"rendered":"https:\/\/mamchenkov.net\/wordpress\/?p=27517"},"modified":"2017-04-10T14:32:49","modified_gmt":"2017-04-10T12:32:49","slug":"validating-csv-schema","status":"publish","type":"post","link":"https:\/\/mamchenkov.net\/wordpress\/2017\/04\/10\/validating-csv-schema\/","title":{"rendered":"Validating CSV schema"},"content":{"rendered":"\n

CSV, or comma-separated values<\/a>, is a very common format for managing all kinds of configurations, as well data manipulation. \u00a0As the linked Wikipedia page mentions, there are a few RFCs that try to standardize the format. \u00a0However, I thought, there is still a lack of schema-type standard that would allow one to define a format for particular file.<\/p>\n

Today I came across an effort that attempts to do just that –\u00a0CSV Schema Language v1.1<\/a> – an unofficial draft of the language for defining and validating CSV data. \u00a0This is work in progress by the Digital Preservation<\/a> team at The National Archives.<\/p>\n

Apart from the unofficial draft of the language, there is also an Open Source CSV Validator v1.1<\/a> application, written in Scala.<\/p>\n\n","protected":false},"excerpt":{"rendered":"\n

CSV, or comma-separated values, is a very common format for managing all kinds of configurations, as well data manipulation. \u00a0As the linked Wikipedia page mentions, there are a few RFCs that try to standardize the format. \u00a0However, I thought, there is still a lack of schema-type standard that would allow one to define a format … Continue reading Validating CSV schema<\/span><\/a><\/p>\n\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"Validating CSV schema #CSV #standards","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false,"_links_to":"","_links_to_target":""},"categories":[1,18,133,62,1334],"tags":[3195,3510,3181,1216,1330],"keyring_services":[],"class_list":["post-27517","post","type-post","status-publish","format-standard","hentry","category-general","category-programming","category-sysadmin","category-technology","category-web-work","tag-configuration-management","tag-csv","tag-file-formats","tag-standards","tag-web-development"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t