{"id":1641,"date":"2021-02-15T18:23:09","date_gmt":"2021-02-15T17:23:09","guid":{"rendered":"https:\/\/smartdatamodels.org\/?p=1641"},"modified":"2023-03-13T19:18:17","modified_gmt":"2023-03-13T18:18:17","slug":"create-your-data-model-with-a-google-spreadsheet","status":"publish","type":"post","link":"https:\/\/smartdatamodels.org\/index.php\/create-your-data-model-with-a-google-spreadsheet\/","title":{"rendered":"Create your data model with a google spreadsheet"},"content":{"rendered":"<p>NEW VERSION!!<\/p>\n<p>This post became obsolete, <a href=\"https:\/\/smartdatamodels.org\/index.php\/mastersheet-for-submission-of-simple-data-models\/\">go for the new master sheet <\/a><\/p>\n<p>&nbsp;<\/p>\n<p>This is a resource, especially for those who have limited knowledge of JSON schema.<\/p>\n<p>If you want to create a basic version of a data model (not all JSON schema is implemented), you can use a copy of <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1TwXCBI-oedpf9RYpYlLNZnz5Pxl6o6kxHXKINRdJi5c\/\">this spreadsheet as template<\/a>. This spreadsheet is always available at <a href=\"https:\/\/bit.ly\/schema_sheet\">https:\/\/bit.ly\/schema_sheet\u00a0<\/a>short name.<\/p>\n<p><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1TwXCBI-oedpf9RYpYlLNZnz5Pxl6o6kxHXKINRdJi5c\/\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1620\" src=\"https:\/\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/draft_schema.png\" alt=\"\" width=\"1084\" height=\"527\" srcset=\"https:\/\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/draft_schema.png 1084w, https:\/\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/draft_schema-300x146.png 300w, https:\/\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/draft_schema-1024x498.png 1024w, https:\/\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/draft_schema-768x373.png 768w, https:\/\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/draft_schema-720x350.png 720w, https:\/\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/draft_schema-150x73.png 150w\" sizes=\"auto, (max-width: 1084px) 100vw, 1084px\" \/><\/a><\/p>\n<p>You need to fill the blue cells for these parameters:<\/p>\n<ul>\n<li><strong>Subject<\/strong>: Official Subject where this data model should be allocated. (Check the <a href=\"https:\/\/github.com\/smart-data-models\/data-models\/blob\/master\/specs\/AllSubjects\/official_list_data_models.json\">official list<\/a>)<\/li>\n<li><strong>DataModel<\/strong>: Official data model name (Only one word i.e. WeatherForecast, no _).<\/li>\n<li><strong>Title<\/strong>: use to be the name data model name with spaces. (i.e. Weather Forecast)<\/li>\n<li><strong>Global Description<\/strong>: General text description of the data model. (2 lines is nice)<\/li>\n<li><strong>Property name<\/strong>: Exactly this, the name of the property. Use camelCase. It would be good to <a href=\"https:\/\/smartdatamodels.org\/index.php\/ddbb-of-properties-descriptions\/\">check here<\/a> whether this property already exists (you can copy and paste). Use those you need and leave one empty after those you filled. Properties below an empty property name are ignored.<\/li>\n<li><strong>NGSI type<\/strong>: (Property, Relationship or Geoproperty)<\/li>\n<li><strong>Data type<\/strong>: Type of data in the property. (array and object are not fully implemented)<\/li>\n<li><strong>Other restrictions<\/strong>: If you are unfamiliar with JSON schema leave it empty.<\/li>\n<li><strong>Description:<\/strong> Official description of the property.<\/li>\n<\/ul>\n<p>Once you&#8217;ve got the schema, grab some examples (It is always good to review the <a href=\"https:\/\/bit.ly\/contribution_manual\">contribution manual<\/a>) and you can make a Pull Request on any of the subjects of any <a href=\"https:\/\/github.com\/smart-data-models\/data-models\/tree\/master\/specs\">domain<\/a> in Github. Or just use <a href=\"https:\/\/smartdatamodels.org\/index.php\/submit-a-data-model\/\">this form<\/a>.<\/p>\n<p>NOTE 1: The first option will be attended quicker than the second.<\/p>\n<p>NOTE 2: Do not write out of the blue cells (it will be ignored). And do not add or remove cells. The converter script looks for these precise locations in blue.<\/p>\n<p>NOTE 3: Your spreadsheet has to be made public. (anyone with the link), otherwise, the script will not be able to retrieve your data.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1648\" src=\"https:\/\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/image.png\" alt=\"\" width=\"624\" height=\"240\" srcset=\"https:\/\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/image.png 624w, https:\/\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/image-300x115.png 300w, https:\/\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/image-150x58.png 150w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/p>\n<p><strong>Call:<br \/>\n<\/strong><\/p>\n<p><strong>Parameters<\/strong>: (Mandatories)<\/p>\n<ul>\n<li>sheetUrl: The url of the spreadsheet (if not it takes <a href=\"https:\/\/smartdatamodels.org\/index.php\/draft-a-data-model\/\">default spreadsheet<\/a> in the menu)<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Output<\/strong>: A json schema based on the properties defined in the database. This is an alpha version so errors are not managed.<\/p>\n\n<div class=\"wpcf7 no-js\" id=\"wpcf7-f1631-o1\" lang=\"en-US\" dir=\"ltr\" data-wpcf7-id=\"1631\">\n<div class=\"screen-reader-response\"><p role=\"status\" aria-live=\"polite\" aria-atomic=\"true\"><\/p> <ul><\/ul><\/div>\n<form action=\"\/index.php\/wp-json\/wp\/v2\/posts\/1641#wpcf7-f1631-o1\" method=\"post\" class=\"wpcf7-form init\" aria-label=\"Contact form\" novalidate=\"novalidate\" data-status=\"init\">\n<fieldset class=\"hidden-fields-container\"><input type=\"hidden\" name=\"_wpcf7\" value=\"1631\" \/><input type=\"hidden\" name=\"_wpcf7_version\" value=\"6.1.5\" \/><input type=\"hidden\" name=\"_wpcf7_locale\" value=\"en_US\" \/><input type=\"hidden\" name=\"_wpcf7_unit_tag\" value=\"wpcf7-f1631-o1\" \/><input type=\"hidden\" name=\"_wpcf7_container_post\" value=\"0\" \/><input type=\"hidden\" name=\"_wpcf7_posted_data_hash\" value=\"\" \/><input type=\"hidden\" name=\"_wpcf7cf_hidden_group_fields\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_hidden_groups\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_visible_groups\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_repeaters\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_steps\" value=\"{}\" \/><input type=\"hidden\" name=\"_wpcf7cf_options\" value=\"{&quot;form_id&quot;:1631,&quot;conditions&quot;:[],&quot;settings&quot;:{&quot;animation&quot;:&quot;yes&quot;,&quot;animation_intime&quot;:&quot;200&quot;,&quot;animation_outtime&quot;:&quot;200&quot;,&quot;conditions_ui&quot;:&quot;normal&quot;,&quot;notice_dismissed&quot;:&quot;true&quot;,&quot;notice_dismissed_rollback-cf7-5.9.4&quot;:true,&quot;notice_dismissed_rollback-cf7-5.9.5&quot;:true,&quot;notice_dismissed_rollback-cf7-6.1.4&quot;:true}}\" \/><input type=\"hidden\" name=\"redirect_nonce\" value=\"5f6e1f7efb\" \/><input type=\"hidden\" name=\"wpcf7cfpdf_hidden_name\" value=\"document-pdf\" \/><input type=\"hidden\" name=\"wpcf7cfpdf_hidden_reference\" value=\"f69eed22\" \/><input type=\"hidden\" name=\"wpcf7cfpdf_hidden_date\" value=\"04122026\" \/><input type=\"hidden\" name=\"_wpcf7_recaptcha_response\" value=\"\" \/>\n<\/fieldset>\n<div class=\"divTable\" style=\"border: 0px solid #000;\">\n\t<div class=\"divTableBody\">\n\t\t<div class=\"divTableRow\">\n\t\t\t<div class=\"divTableCell\">\n\t\t\t\t<p>This form generates a json schema based on the properties of a google sheet (Based on <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1TwXCBI-oedpf9RYpYlLNZnz5Pxl6o6kxHXKINRdJi5c\">this template<\/a>)\n\t\t\t\t<\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t<div class=\"divTableRow\">\n\t\t\t<div class=\"divTableCell\">\n\t\t\t\t<p><label> URL SHEEET<br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"sheetUrl\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" value=\"\" type=\"text\" name=\"sheetUrl\" \/><\/span><br \/>\nUrl of the sheet (it has to be public) <\/label>\n\t\t\t\t<\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t<div class=\"divTableRow\">\n\t\t\t<div class=\"divTableCell\">\n\t\t\t<\/div>\n\t\t\t<div class=\"divTableCell\">\n\t\t\t\t<p>&nbsp;\n\t\t\t\t<\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t<\/div>\n<\/div>\n<!-- DivTable.com -->\n<p><span class=\"wpcf7-form-control-wrap wpgdprc\"><span class=\"wpcf7-form-control wpcf7-wpgdprc wpcf7-validates-as-required\"><span class=\"wpcf7-list-item\"><input type=\"checkbox\" name=\"wpgdprc\" value=\"1\" aria-required=\"true\" aria-invalid=\"false\" \/><span class=\"wpcf7-list-item-label\">By using this form you agree with the storage and handling of your data by this website.<\/span><\/span><\/span>    <\/span>\n<\/p>\n<p><input class=\"wpcf7-form-control wpcf7-submit has-spinner\" type=\"submit\" value=\"Submit\" \/><br \/>\nAfter clicking it will appear a message confirming the submission\n<\/p>\n<p>It will take a while to redirect to the feedback on a specific page\n<\/p>\n<p><B>Thanks for being patient<\/b>\n<\/p><p style=\"display: none !important;\" class=\"akismet-fields-container\" data-prefix=\"_wpcf7_ak_\"><label>&#916;<textarea name=\"_wpcf7_ak_hp_textarea\" cols=\"45\" rows=\"8\" maxlength=\"100\"><\/textarea><\/label><input type=\"hidden\" id=\"ak_js_1\" name=\"_wpcf7_ak_js\" value=\"89\"\/><script>document.getElementById( \"ak_js_1\" ).setAttribute( \"value\", ( new Date() ).getTime() );<\/script><\/p><div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div>\n<\/form>\n<\/div>\n\n","protected":false},"excerpt":{"rendered":"<p>NEW VERSION!! This post became obsolete, go for the new master sheet &nbsp; This is a resource, especially for those who have limited knowledge of JSON schema. If you want to create a basic version of a data model (not all JSON schema is implemented), you can use a copy&#8230; <a class=\"continue-reading-link\" href=\"https:\/\/smartdatamodels.org\/index.php\/create-your-data-model-with-a-google-spreadsheet\/\">More&#8230;<\/a><\/p>\n","protected":false},"author":1,"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,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[105,107,109,113,115,119,117,88,143,111,125],"tags":[],"class_list":["post-1641","post","type-post","status-publish","format-standard","hentry","category-cross-sector","category-smart-cities","category-smart-energy-domain","category-smart-environment","category-smart-manufacturing","category-smart-robotics","category-smart-water","category-smart-sensoring","category-smartaeronautics","category-smart-agrifood","category-smartdestinations"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":1619,"url":"https:\/\/smartdatamodels.org\/index.php\/alpha-version-for-drafting-a-data-model\/","url_meta":{"origin":1641,"position":0},"title":"Alpha version for drafting a data model","author":"maestro","date":"14\/02\/2021","format":false,"excerpt":"In case you are not an expert for creating a JSON schema (one of the elements of a data model) On this page, you have a spreadsheet for helping with the first steps. 1.- Fill the spreadsheet with the names of the properties for your model 2.- fill the NGSI\u2026","rel":"","context":"In &quot;Cross Sector&quot;","block_context":{"text":"Cross Sector","link":"https:\/\/smartdatamodels.org\/index.php\/category\/cross-sector\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/draft_schema.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/draft_schema.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/draft_schema.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/draft_schema.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/draft_schema.png?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":1727,"url":"https:\/\/smartdatamodels.org\/index.php\/new-option-for-drafting-a-data-model\/","url_meta":{"origin":1641,"position":1},"title":"New option for drafting a data model","author":"maestro","date":"19\/02\/2021","format":false,"excerpt":"In the front page, there is a new option that allows you top to directly create a copy of the template sheet for creating new data models. Remember that this spreadsheet is done for those unfamiliar with json schema (the official format for the smart data models) to allow them\u2026","rel":"","context":"In &quot;Internal&quot;","block_context":{"text":"Internal","link":"https:\/\/smartdatamodels.org\/index.php\/category\/internal\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/instructions.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":3889,"url":"https:\/\/smartdatamodels.org\/index.php\/new-tool-for-simplified-creation-of-a-data-model\/","url_meta":{"origin":1641,"position":2},"title":"New tool for simplified creation of a data model","author":"maestro","date":"09\/03\/2022","format":false,"excerpt":"The creation of a data model requires two mandatory files, one example and a JSON schema containing the definitions and data types of the elements in the entity. However, the JSON schema creation could be somehow demanding. The new tool opens the door for people with only basic knowledge of\u2026","rel":"","context":"In &quot;Cross Sector&quot;","block_context":{"text":"Cross Sector","link":"https:\/\/smartdatamodels.org\/index.php\/category\/cross-sector\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10263,"url":"https:\/\/smartdatamodels.org\/index.php\/metadata-of-the-catalogue-available\/","url_meta":{"origin":1641,"position":3},"title":"Metadata of the catalogue available","author":"maestro","date":"01\/02\/2024","format":false,"excerpt":"Now in the tools menu (currently the last option) you have a complete list of the most relevant links to the assets of the data models compile in the Smart Data Models initiative. You can check in the main menu -> Tools\u00a0 -> Metadata of the data models The information\u2026","rel":"","context":"In &quot;Cross Sector&quot;","block_context":{"text":"Cross Sector","link":"https:\/\/smartdatamodels.org\/index.php\/category\/cross-sector\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2644,"url":"https:\/\/smartdatamodels.org\/index.php\/new-method-for-drafting-the-json-schema-for-a-new-data-model\/","url_meta":{"origin":1641,"position":4},"title":"New method for drafting the json schema for a new data model","author":"maestro","date":"09\/06\/2021","format":false,"excerpt":"A new tool (capable of the creation of more complex data models) is available at the menu \"Draft a data model\". It is an external tool that simplifies the json schema needs. Hope it speeds up the development of new data models and simplifies it for newcomers to this syntaxis.\u2026","rel":"","context":"In &quot;Cross Sector&quot;","block_context":{"text":"Cross Sector","link":"https:\/\/smartdatamodels.org\/index.php\/category\/cross-sector\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":8429,"url":"https:\/\/smartdatamodels.org\/index.php\/mastersheet-for-submission-of-simple-data-models\/","url_meta":{"origin":1641,"position":5},"title":"MasterSheet for submission of simple data models","author":"maestro","date":"13\/03\/2023","format":false,"excerpt":"We have released a master sheet that simplifies the contribution to the smart data models. It uploads the data model to a new repository called drafted. The video help is also available Steps for using the spreadsheet 0.- Make a local copy in your google account and grant permission the\u2026","rel":"","context":"In &quot;Cross Sector&quot;","block_context":{"text":"Cross Sector","link":"https:\/\/smartdatamodels.org\/index.php\/category\/cross-sector\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2023\/03\/sheet.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts\/1641","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/comments?post=1641"}],"version-history":[{"count":6,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts\/1641\/revisions"}],"predecessor-version":[{"id":8431,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts\/1641\/revisions\/8431"}],"wp:attachment":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/media?parent=1641"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/categories?post=1641"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/tags?post=1641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}