Organize data

In the past we were able to draw a polygon in a geographical map (e.g. Germany Postal Codes). This was used to extract a specific list of postal codes and areas based on the polygon. Right now it does not seem to be possible to draw those polygons on the map anymore. Is there a way around it or a possibility in the future again? 

For a spatial dataset, I can add an additional geographic projection e.g. 27700 for BNG in the backoffice. But this doesn’t appear in the export tab as an option, and my testing shows that the export is still in WGS84 - the default. Am I missing something or is this feature not working in the marketplace experience?

dans la vue personnalisée, la légende apparaît systématiquement réduite : je souhaite que la légnde soit systématiquement affichée eau complet sans devoir cliquer sur le terme x éléments de plus quel paramètre dois-je imposer au code html ?merci à vous 

Hi allWe would like to have a data type “URL” for our datasets. I have found a setting for the licenses that we can freely add and remove, but I haven’t found one for data types. There are datatypes that we never use (JSON, IP-address), and others that we would like to have, such as URL.Where can we add new data types in the backoffice?Or do we need Huwise to add that? If so, the base type of URL should be a string. Our dataportal is here: data.bs.ch Best regardsRenato

Bonjour,Je souhaite signaler un bug concernant la gestion des traductions lors de la modification de la description d'un jeu de données.Comportement observéLorsque je modifie la description en français et que je sauvegarde, la traduction en allemand est automatiquement effacée. Le problème se produit également si je modifie les deux langues dans la même session sans sauvegarder entre les deux : la traduction allemande disparaît à la sauvegarde finale.Étapes pour reproduireOuvrir un jeu de données disposant d'une description en français et d'une traduction en allemand Modifier la description en français (onglet Information → Description) Sauvegarder Aller voir dans l’onglet Traductions → Description La traduction en allemand est effacée Contournement actuelLa seule solution de contournement consiste à :1. Copier manuellement la traduction allemande avant toute modification2. Effectuer et sauvegarder la modification en français3. Recoller manuellement la traduction allemandeCe contournem

Users sometimes report confusion in Huwise around configuring processors.We just updated the documentation for a specific processor to help make it clear, but here’s the key thing to understand about processing and types: The bottom line — processors run before types are appliedWhat you see in the interface may reflect the schema type, but processors still run on the original source value until typing is applied at the end. Source data is ingested (raw values) Processors run on those raw values Schema types are applied afterward In more detailHuwise runs processors on source values before schema typing is applied. This means the value displayed in the interface may already look typed, while processors are still using the original underlying source value.So if your source contains values like 0, 1, 0.0, 1.0, "No", "False", etc., processors operate on those underlying values, even if the field is typed as Boolean in the Schema.As a result, a value may appear as false in the interface

Hi all,If a dataset contains both a geopoint and a geoshape, is there anyway to select which will be displayed when you add it onto a map for example ? By default it seems to show the shapes Thanks RyanAuto-translation 🪄Bonjour à tous,Si un ensemble de données contient à la fois un géopoint et une géoforme, est-il possible de sélectionner celui qui sera affiché lorsque vous l'ajouterez sur une carte par exemple ? Par défaut, il semble afficher les formes Merci Ryan

Hello,I have a dataset with a “date” variable and I would like to dynamically assign the start date of my graph as the last date in my dataset -20 years. I can use an ods-adv-analysis to obtain the latest date in my dataset, but I can't subtract 20 years from it. Furthermore, I can hardcode the start date, but not using a dynamic variable:<div ods-adv-analysis="maxdate" ods-adv-analysis-context="pibcroissancetrimestre" ods-adv-analysis-select="max(date) as maxdate" > {{last_date = maxdate[0].maxdate; ""}} {{last_date}} {{ pibcroissancetrimestre.parameters['q.from_date.date'] = 'date>=2005-09-30T00:00:00+00:00 '; ""}}Can someone help me fix this code?Thanks in advanceNathan

HelloWhen I add a territory for a dataset, and retrieve the dataset through the API, then I get a random code (e.g. ch_80_2477 ). It is quite cumbersome to map these by hand, but I’ve done it for ~10 cities and regions. Now, we have a new dataset with a lot more territories, and it would be cumbersome (and unnecessary, honestly), to map these by hand. Where can I find a list with all of these codes, so that I can import them and use them in my code? Do these follow a public standard?Thank you!

Is there a way to add metadata and dataset schema translations (e.g. in english or italian) via the Automation API?

Hi everyone,I’m Dario Schiraldi currently working on a project where I need to join multiple datasets, and I’d love to hear your suggestions on the best practices for performing data joins. Specifically, I’m interested in methods for both SQL and Python.I’d appreciate any insights, tips, or resources you have! Thanks in advance!RegardsDario Schiraldi CEO of Travel Works 

Hi,My name is  Prakash Hinduja (Hinduja Family Swiss) , I want to know about the Schema management for datasets and why it is important .  Regards:Prakash Hinduja (Hinduja Family Switzerland)

Hello everyone,I’m Kamal Hinduja from Geneva, Switzerland. I’m new to this community and look forward to contributing positively to the discussions while learning from your insights. Could someone please explain how Open data soft integrates with public datasets? Thanks in Advance!Kamal Hinduja Geneva, Switzerland  

Hi,I understand that geopoint schemas cant be edited when they are the centre of a geoshape, but is there anyway to still be able to edit the description? Mainly to state that this point is in fact the centre of the shape and not a location point (see below) Thanks Ryan

HiI’m trying to join a couple of datasets spatially.In Dataset A I have a geopoint (lat/long)In Dataset B I have a list of attributes in a polygon (shape) I want to use the geopoint in Dataset A as the key for Dataset B and return one or more columns from Dataset B…  Thank you for any options :)

Hi everyone,I'm working with the ODS Automation API (v1) and I'm trying to retrieve the data types of columns in a dataset. When using the `/datasets/{dataset_uid}/fields` endpoint, I receive a list of field configurations that includes annotations (facet, timerangeFilter, etc.) and rename operations, but I'm having trouble finding the actual data types of the columns (like text, date, integer).Here's an example of what I get from the endpoint (for fields related to the ‘end_date’ field, which is of type ‘date’):[{'annotation': 'facet', 'args': [], 'field': 'end_date', 'label': '', 'type': 'annotation', 'uid': 'pr_toc04f'}{'annotation': 'facetsort', 'args': ['alphanum'], 'field': 'end_date', 'label': '', 'type': 'annotate', 'uid': 'pr_adjonu'}{'annotation': 'timerangeFilter', 'args': [], 'field': 'end_date', 'label': '', 'type': 'annotate', 'uid': 'pr_yv06h9'}{'field_label': 'Enddatum', 'from_name': 'end_date', 'label': '', 'to_name': 'end_date', 'type': 'rename', 'uid': 'pr_xh8w8e'}]W

Hi All :)Ive been working on a dashboard based on the mutlple context code libary piece “https://codelibrary.opendatasoft.com/page-templates/dashboard-filter/#code-dashboard-with-filters-on-multiple-contexts-css-content” https://northernpowergrid.opendatasoft.com/pages/la_dashboard/ this is what we have, and it works for the most part, the only problem is i cant select more than one option in the drop down, as the list refines itself when I pick an option. Can anyone assist? Ive set the “multiple” option to true in the ODS-Select part Thanks RyanAuto-translation 🪄Bonjour à tous :) J'ai travaillé sur un tableau de bord basé sur la bibliothèque de codes à contexte multiple « https://codelibrary.opendatasoft.com/page-templates/dashboard-filter/#code-dashboard-with-filters-on-multiple-contexts-css-content » https://northernpowergrid.opendatasoft.com/pages/la_dashboard/ c'est ce que nous avons, et cela fonctionne pour la plupart, le seul problème est que je ne peux pas sélectionner plus d'

Hi,Im trying to add descriptions to my schema, however when I enter my description the apply box stays greyed out.Any ideas why i cant seem to apply this change? Thanks RyanAuto-translation 🪄Bonjour, j'essaie d'ajouter des descriptions à mon schéma, mais lorsque je saisis ma description, la case d'application reste grisée. Avez-vous une idée de la raison pour laquelle je n'arrive pas à appliquer ce changement ? Merci Ryan

Hi everyone,I’ve been working on a project that involves handling large datasets, and I’m exploring how OpenDataSoft can be integrated with cloud computing platforms like AWS, Microsoft Azure, and Google Cloud.Here are some specific questions and thoughts I’d like to dive into:Built-In Connectors or APIs: Does OpenDataSoft provide native connectors for AWS, Azure, and Google Cloud? For example, can it easily connect to services like S3 (AWS), Blob Storage (Azure), or Google Cloud Storage? Setting Up Data Pipelines: How straightforward is it to establish data pipelines between OpenDataSoft and these cloud platforms? Are there any step-by-step guides or best practices for automating data transfers and updates? Real-Time Data Processing: Can OpenDataSoft handle real-time data streaming from cloud-based sources like Azure Event Hubs, AWS Kinesis, or Google Pub/Sub? If so, how is latency managed to ensure smooth operation? Data Security and Compliance: With data moving between OpenDataSoft

Hello,I’m currently working on a dataset with different types of data (e.g., time ranges, numeric values, and text fields) and am facing an issue with sorting these data. I’d really appreciate your help in understanding and solving this problem.Context:My dataset contains the following types of columns:Time Ranges (e.g., "2020-2022", "2023-2024", "2020_2022") Numeric Values Text FieldsI need to sort these columns in ascending order (for numeric and time ranges) and alphabetically (for text fields).Problem:When I mark a column as a facet, the sorting applied works  in the Explore Data  for the faceted filters, but the raw dataset remains unsorted. What I Need:I need a way to:Apply sorting to the raw dataset itself (for both time ranges, numeric values, and text fields), so that the data is organized correctly in the raw dataset as well as in the Explore Data view.Additional Details:I’ve tried using different processors, like Expression or Add Field, to create sorting keys, but none of t

Hello everyone,I’m currently facing a challenge with extracting plain text from HTML content, and I’m looking for some advice on how to resolve it.The issue arises when I try to extract all text segments located between various HTML tags. I’ve been using a regular expression to capture the text, but I’ve encountered a limitation where only the first occurrence of text is retrieved, while subsequent occurrences remain unextracted. The regular expression I’m using is:>(?P<texte_brut>[^<>]+)<This works for capturing the first block of text but doesn’t return the remaining segments found within the other tags. My goal is to extract all text occurrences embedded between HTML tags in a single process.For instance, given the following HTML:<p>Chers voyageurs,</p><p>En raison de travaux sur la commune de Vitrolles, les lignes 7 et 20 sont déviées du 25/09 au 31/12 de 6h à 21h.</p><p><strong>Arrêts non desservis :</strong></p>&lt

Dear ODS-Community,I am experiencing an issue with the configuration of an ODS filter where the chart displays data even though no selection has been made in the dropdown. I would like the filter to have no default selection and for the chart to display no data until a selection is made.Details of the Problem:The dropdown filter is configured to allow the selection of a care home. The filter is initialized with the value "All Care Homes," which causes data to be displayed in the chart even when the user has not made a specific selection. I want the filter to be empty by default and for the chart to show no data until something is selected.Current Code:Here is the relevant code that I am currently using:               <div class="grid">                       <div class="shared-width-ods-selects">                    <div ods-facet-results="reglist"                         ods-facet-results-facet-name="name"                         ods-facet-results-context="myctx0"       

Is there anyway to recover a deleted dataset? May of made a small error!ThanksRyanAuto-translation 🪄Existe-t-il un moyen de récupérer un ensemble de données supprimé ? J'ai peut-être fait une petite erreur ! Merci Ryan

 I have a dataset containing Base64 pictures. I want to show the Base64 picture on the map. But when I try that, it shows the Base64 code instead of the picture. So it will not translate the Base64 code to a picture. However, when I use the Base64 code in the Studio, I can add the field containing the Base64 codes as the picture field in the popup configuration (see example picture).Is there a solution for this? Auto-translation 🪄J'ai un ensemble de données contenant des images Base64. Je souhaite afficher l'image Base64 sur la carte. Mais lorsque j'essaie, le code Base64 s'affiche au lieu de l'image. Il ne traduira donc pas le code Base64 en image. Cependant, lorsque j'utilise le code Base64 dans le Studio, je peux ajouter le champ contenant les codes Base64 comme champ d'image dans la configuration contextuelle (voir l'image d'exemple). Existe-t-il une solution à ce problème ?

Hey everybody!Is it possible to order the legend or/and the stacking of the values so they ar the same:https://data.bs.ch/chart/embed/order-incorrect/ This is the corresponding code:<ods-dataset-context context="myctx" myctx-dataset="100392" myctx-parameters="{'disjunctive.wahljahr':true,'disjunctive.altersgruppe':true,'disjunctive.listenkurzbezeichnung':true,'disjunctive.geschlecht':true,'disjunctive.frauenanteil_liste':true}">    <ods-chart scientific-display="false" align-month="true">        <ods-chart-query context="myctx" field-x="wahljahr" maxpoints="0" stacked="percent" series-breakdown="altersgruppe">            <ods-chart-serie expression-y="anteil" chart-type="bar" function-y="SUM" color="range-Accent" display-units="true" display-values="true" scientific-display="true">            </ods-chart-serie>        </ods-chart-query>    </ods-chart></ods-dataset-context>Maybe there is something I have to do in the correpsonding dataset