{"id":9154,"date":"2023-07-03T09:02:24","date_gmt":"2023-07-03T07:02:24","guid":{"rendered":"https:\/\/smartdatamodels.org\/?p=9154"},"modified":"2023-07-02T04:07:55","modified_gmt":"2023-07-02T02:07:55","slug":"new-version-of-the-spreadsheet-for-drafting-data-models","status":"publish","type":"post","link":"https:\/\/smartdatamodels.org\/index.php\/new-version-of-the-spreadsheet-for-drafting-data-models\/","title":{"rendered":"New version of the spreadsheet for drafting data models"},"content":{"rendered":"

You can see in the main page an image like the one below.<\/p>\n

It takes you to a google spreadsheet where you can draft simple data models even without knowledge of json schema.<\/p>\n

Json schema is the format that stores the master description of the data models in the Smart Data Models.<\/p>\n

Now there are two additional tabs, ADOPTERS.yaml<\/a> and notes.yaml<\/a> which helps you to fill those files which are mandatory to be present but empty if you do not want to disclose your use case or you do not need to add additional explanations about the submitted data model.<\/p>\n

Note: if you want to use the spreadsheet you need to:<\/p>\n

– Create a local copy in your google account<\/p>\n

– Allow the scripts to be executed<\/p>\n

– Fill the yellow cells and click on the buttons<\/p>\n

\"\"<\/p>\n

Feedback is always welcomed at info@smartdatamodels.org<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

You can see in the main page an image like the one below. It takes you to a google spreadsheet where you can draft simple data models even without knowledge of json schema. Json schema is the format that stores the master description of the data models in the Smart… More…<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","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":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[84],"tags":[],"class_list":["post-9154","post","type-post","status-publish","format-standard","hentry","category-governance"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":1641,"url":"https:\/\/smartdatamodels.org\/index.php\/create-your-data-model-with-a-google-spreadsheet\/","url_meta":{"origin":9154,"position":0},"title":"Create your data model with a google spreadsheet","author":"maestro","date":"15\/02\/2021","format":false,"excerpt":"NEW VERSION!! This post became obsolete, go for the new master sheet \u00a0 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\u2026","rel":"","context":"In "Cross Sector"","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\/image.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/image.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/image.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":1619,"url":"https:\/\/smartdatamodels.org\/index.php\/alpha-version-for-drafting-a-data-model\/","url_meta":{"origin":9154,"position":1},"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 "Cross Sector"","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":9154,"position":2},"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 "Internal"","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":10389,"url":"https:\/\/smartdatamodels.org\/index.php\/the-smart-data-models-initiative-embraces-json-schema-as-the-core-component-for-interoperable-smart-solutions\/","url_meta":{"origin":9154,"position":3},"title":"The Smart Data Models Initiative Embraces JSON Schema as the Core Component for Interoperable Smart Solutions","author":"maestro","date":"15\/07\/2024","format":false,"excerpt":"The Smart Data Models (SDM) initiative, led by FIWARE Foundation in collaboration with IUDX, TM Forum, and OASC, has firmly established JSON Schema as the core component and single source of truth for creating exports in YAML, SQL, and soon RDF. This strategic move aligns the SDM initiative with the\u2026","rel":"","context":"In "Cross Sector"","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":9154,"position":4},"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 "Cross Sector"","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":[]},{"id":10581,"url":"https:\/\/smartdatamodels.org\/index.php\/updated-all-data-models-to-the-last-version-of-json-schema\/","url_meta":{"origin":9154,"position":5},"title":"Updated all data models to the last version of json schema","author":"maestro","date":"16\/09\/2024","format":false,"excerpt":"NOTE: We did yesterday 17-9 the changes. Unfortunately we made a mistake and now we have to revert all these changes, do it again properly and push. this Friday will be ready if not earlier. NOTE2: It is already updated. Its Wednesday 15:30. Hopefully this time we made no errors.\u2026","rel":"","context":"In "Cross Sector"","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\/2024\/09\/json_schema.jpeg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts\/9154","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=9154"}],"version-history":[{"count":1,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts\/9154\/revisions"}],"predecessor-version":[{"id":9155,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts\/9154\/revisions\/9155"}],"wp:attachment":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/media?parent=9154"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/categories?post=9154"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/tags?post=9154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}