{"id":1626,"date":"2021-02-15T17:41:03","date_gmt":"2021-02-15T16:41:03","guid":{"rendered":"https:\/\/smartdatamodels.org\/?page_id=1626"},"modified":"2021-10-27T18:44:19","modified_gmt":"2021-10-27T16:44:19","slug":"create-data-model-from-your-google-spreadsheet","status":"publish","type":"page","link":"https:\/\/smartdatamodels.org\/index.php\/create-data-model-from-your-google-spreadsheet\/","title":{"rendered":"Create data model from your google spreadsheet"},"content":{"rendered":"<p>21-10-21: This resource is outdated and no longer available. It has been replaced by <a href=\"https:\/\/smartdatamodels.org\/index.php\/draft-a-data-model\/\">this simple editor<\/a>, (home -&gt; Draft a data Model) more powerful and simple to use.<\/p>\n<p>If you want to create a basic version of a data model, you can use a copy of this spreadsheet as template . This spreadsheet is always available at https:\/\/bit.ly\/schema_sheet\u00a0short name.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1620 size-full\" 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\" \/><\/p>\n<p>The blue cells are the ones ready for the general information for creating your data model. You cannot add or remove cells, columns or rows, (without changing the script).<\/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","protected":false},"excerpt":{"rendered":"<p>21-10-21: This resource is outdated and no longer available. It has been replaced by this simple editor, (home -&gt; Draft a data Model) more powerful and simple to use. If you want to create a basic version of a data model, you can use a copy of this spreadsheet as&#8230; <a class=\"continue-reading-link\" href=\"https:\/\/smartdatamodels.org\/index.php\/create-data-model-from-your-google-spreadsheet\/\">More&#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-1626","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":1759,"url":"https:\/\/smartdatamodels.org\/index.php\/error-submitting-spreadsheet\/","url_meta":{"origin":1626,"position":0},"title":"Error submitting spreadsheet","author":"maestro","date":"23\/02\/2021","format":false,"excerpt":"The spreadsheet you submitted cannot be found. Did you make it public? Could you check the url provided? Did you use the template? Try again here","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1221,"url":"https:\/\/smartdatamodels.org\/index.php\/procedure-for-adding-new-data-model\/","url_meta":{"origin":1626,"position":1},"title":"Procedure for adding new data model","author":"maestro","date":"02\/01\/2021","format":false,"excerpt":"Supposedly the data model meets the contribution manual requirements these steps should be taken If there is to create new subject warn these points: Rename 'main' branch to 'master' Check that the page for the repo is published. It could take to github up to 5 minutes since you enable\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":8287,"url":"https:\/\/smartdatamodels.org\/index.php\/pysmatdatamodels-documentation\/","url_meta":{"origin":1626,"position":2},"title":"pysmartdatamodels documentation","author":"maestro","date":"10\/02\/2023","format":false,"excerpt":"1- Load all datamodels in a dict like the official list. Function load_all_datamodels() Returns a dict with all data models with this object structure - repoName: The name of the subject - repoLink: the link to the repository of the subject - dataModels: An array with all the datamodels of\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10260,"url":"https:\/\/smartdatamodels.org\/index.php\/metadata-of-the-data-models-catalog-available\/","url_meta":{"origin":1626,"position":3},"title":"Metadata of the data models catalog available","author":"maestro","date":"01\/02\/2024","format":false,"excerpt":"In this link you have all metadata of the catalogue available as a json file. It includes: subject data model version of the data model modelTags title url to $id of the schema description of the data model required attributes yamlUrl link to the yaml version of the schema jsonSchemaUrl\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":11182,"url":"https:\/\/smartdatamodels.org\/index.php\/contribute-with-an-spreadsheet\/","url_meta":{"origin":1626,"position":4},"title":"Contribute with a spreadsheet","author":"maestro","date":"07\/11\/2024","format":false,"excerpt":"","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6408,"url":"https:\/\/smartdatamodels.org\/index.php\/export-of-database-of-attributes-of-the-smart-data-models\/","url_meta":{"origin":1626,"position":5},"title":"Export of database of attributes of the Smart Data Models","author":"maestro","date":"21\/07\/2022","format":false,"excerpt":"For some developers is interesting to access the database of attributes you can search in the main menu -> Search You have it in this link https:\/\/smartdatamodels.org\/extra\/smartdatamodels.json the file (It is a large one). It has a CC-BY license so feel free to use it and we will be happy\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/pages\/1626","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/types\/page"}],"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=1626"}],"version-history":[{"count":10,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/pages\/1626\/revisions"}],"predecessor-version":[{"id":1639,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/pages\/1626\/revisions\/1639"}],"wp:attachment":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/media?parent=1626"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}