{"id":5912,"date":"2022-06-06T02:05:20","date_gmt":"2022-06-06T00:05:20","guid":{"rendered":"https:\/\/smartdatamodels.org\/?p=5912"},"modified":"2022-06-06T15:51:23","modified_gmt":"2022-06-06T13:51:23","slug":"draft-you-data-model-from-a-csv-payload-test","status":"publish","type":"post","link":"https:\/\/smartdatamodels.org\/index.php\/draft-you-data-model-from-a-csv-payload-test\/","title":{"rendered":"Draft your data model from a csv payload (test)"},"content":{"rendered":"<p>There is a new service for the creation of schema of a data model when the input is a csv payload.<\/p>\n<p>It is available in the home -&gt; Draft a data model -&gt; <a href=\"https:\/\/smartdatamodels.org\/index.php\/create-data-model-from-csv-payload\/\">Create a data model from csv payload<\/a><\/p>\n<p>If you detect any issue or you want to make a suggestion, please send it to <a href=\"mailto:info@smartdatamodels.org\">info@smartdatamodels.org<\/a><\/p>\n<p>test it here<\/p>\n\n<div class=\"wpcf7 no-js\" id=\"wpcf7-f4960-o1\" lang=\"en-US\" dir=\"ltr\" data-wpcf7-id=\"4960\">\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\/5912#wpcf7-f4960-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=\"4960\" \/><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-f4960-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;:4960,&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=\"5175b92fb9\" \/><input type=\"hidden\" name=\"wpcf7cfpdf_hidden_name\" value=\"document-pdf\" \/><input type=\"hidden\" name=\"wpcf7cfpdf_hidden_reference\" value=\"ae43733b\" \/><input type=\"hidden\" name=\"wpcf7cfpdf_hidden_date\" value=\"04062026\" \/><input type=\"hidden\" name=\"_wpcf7_recaptcha_response\" value=\"\" \/>\n<\/fieldset>\n<p><label> Name of the entity\/class<br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"entity\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"EntityName\" value=\"\" type=\"text\" name=\"entity\" \/><\/span> <\/label>\n<\/p>\n<p><label> header (name of the fields separated with comma)<br \/>\nid,type,field1,field2<br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"header\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text\" aria-invalid=\"false\" placeholder=\"id, type, field1, field2\" value=\"\" type=\"text\" name=\"header\" \/><\/span> <\/label>\n<\/p>\n<p><label> payload (csv values separated with comma)<br \/>\nurn:ngsi-ld:entityName:001, entityName, value1, value2<br \/>\nonly the first line<br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"payload\"><textarea cols=\"40\" rows=\"10\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-textarea\" aria-invalid=\"false\" placeholder=\"urn:ngsi-ld:entityName:001, entityName, value1, value2 only the first line\" name=\"payload\"><\/textarea><\/span> <\/label>\n<\/p>\n<p><label> Your email<br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"email\"><input size=\"40\" maxlength=\"200\" class=\"wpcf7-form-control wpcf7-email wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-email\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"yourmail@yourdomain.com\" value=\"\" type=\"email\" name=\"email\" \/><\/span> <\/label>\n<\/p>\n<p><input class=\"wpcf7-form-control wpcf7-submit has-spinner\" type=\"submit\" value=\"Submit\" \/>\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=\"66\"\/><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>There is a new service for the creation of schema of a data model when the input is a csv payload. It is available in the home -&gt; Draft a data model -&gt; Create a data model from csv payload If you detect any issue or you want to make&#8230; <a class=\"continue-reading-link\" href=\"https:\/\/smartdatamodels.org\/index.php\/draft-you-data-model-from-a-csv-payload-test\/\">More&#8230;<\/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":[105,107,109,113,115,119,117,88,143,111,125,182],"tags":[],"class_list":["post-5912","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","category-smarthealth"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":548,"url":"https:\/\/smartdatamodels.org\/index.php\/updated-the-csv-examples\/","url_meta":{"origin":5912,"position":0},"title":"Updated the csv examples","author":"maestro","date":"08\/08\/2020","format":false,"excerpt":"Every data model has a directory with examples of the payloads (json and jsonld) in key-values and normalized formats. But it also includes examples of csv that it could help to connect the data models for other platforms. Now, these examples are re-created automatically once a day. The naming convention\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":7671,"url":"https:\/\/smartdatamodels.org\/index.php\/release-source-code-for-some-of-the-services-for-python-developers\/","url_meta":{"origin":5912,"position":1},"title":"Release source code for some of the services. For python developers.","author":"maestro","date":"22\/11\/2022","format":false,"excerpt":"In the tools option of the main menu, there are a few services to help you to use, create and debug your data models. Although working, some of these services are limited. We are releasing the code for some of the services to allow you to contribute with improvments. It\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\/2022\/11\/python-logo-master-v3-TM-flattened-300x101.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2205,"url":"https:\/\/smartdatamodels.org\/index.php\/new-service-generate-a-ngsi-ld-payload-keyvalues-format-compliant-with-a-smart-data-model\/","url_meta":{"origin":5912,"position":2},"title":"New service: Generate a NGSI-LD payload keyvalues format compliant with a Smart Data Model","author":"maestro","date":"28\/04\/2021","format":false,"excerpt":"There is a new service for users, which is the ability to generate an example payload compliant with a specific data model in key values format. Previously it was available the normalized format. Options are located in the main menu (Generate NGSI examples) NGSI-LD normalized format NGSI-LD keyvalues format","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\/04\/NGSI_examples-150x150.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1842,"url":"https:\/\/smartdatamodels.org\/index.php\/alpha-version-of-the-service-for-generating-an-ngsi-ld-payload-based-on-a-smart-data-model\/","url_meta":{"origin":5912,"position":3},"title":"Alpha version of the service for generating an NGSI-LD payload based on a Smart Data Model","author":"maestro","date":"03\/03\/2021","format":false,"excerpt":"This is an alpha version (so you can expect errors and not being complete). Use it at your own risk. Please report errors and suggestions at info@smartdatamodels.org Call: https:\/\/smartdatamodels.org\/extra\/ngsi-ld_generator.php Parameters: (Mandatories) schemaUrl: The link to the RAW version of the json schema (see example) email: your email Example: https:\/\/smartdatamodels.org\/extra\/ngsi-ld_generator.php?schemaUrl=https:\/\/raw.githubusercontent.com\/smart-data-models\/dataModel.Streetlighting\/f56f5a7933ab05d7fce1d5adc0847f25a099cdb4\/StreetlightModel\/schema.json&email=alberto.abella@fiware.org Use\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":32569,"url":"https:\/\/smartdatamodels.org\/index.php\/use-smartdatamodels-in-your-local-ai-agent-with-this-mcp-server\/","url_meta":{"origin":5912,"position":4},"title":"Use smartdatamodels in your local AI agent with this MCP server","author":"maestro","date":"16\/03\/2026","format":false,"excerpt":"With this MCP configuration file you will be capable to use Smart Data Models locally in your AI agent. { \"mcpServers\": { \"smartdatamodels\": { \"type\": \"http\", \"serverUrl\": \"https:\/\/opendatamodels.org\/mcp\/v1\" } } } More information here These functions are available 1. search_data_models Search the Smart Data Models (SDM) catalog by keyword, domain\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\/2022\/01\/SmartDataModels_logo.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":18419,"url":"https:\/\/smartdatamodels.org\/index.php\/use-smart-data-models-as-a-service-first-draft\/","url_meta":{"origin":5912,"position":5},"title":"Use smart data models as a service. First draft","author":"maestro","date":"04\/06\/2025","format":false,"excerpt":"In the data-models repository you can access to the first version to use smart data models as a service. Thanks to the works for the Cyclops project. The files available create a wrap up around pysmartdatamodels package and also add one service for the online validation of NGSI-LD payloads. Here\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":[]}],"_links":{"self":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts\/5912","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=5912"}],"version-history":[{"count":2,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts\/5912\/revisions"}],"predecessor-version":[{"id":5921,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts\/5912\/revisions\/5921"}],"wp:attachment":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/media?parent=5912"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/categories?post=5912"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/tags?post=5912"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}