Huwise discussions

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

We would like a way for our users to favorite a dataset, as well as provided feed back as to what they liked about it.

We are setting up a process to update the resources for our datasets using the Automation API. I am looking for best practice advice. Here is what we currently do, starting with a dataset_id and a file that we want to upload: Retrieve the dataset_uid using the endpoint /api/explore/v2.1/catalog/datasets/{dataset_id}. Retrieve the currently used resource_uid of the dataset using the endpoint /api/automation/v1.0/datasets/{dataset_uid}/resources, with the dataset_uid from step 1. Upload the file to the dataset using the endpoint /api/automation/v1.0/datasets/{dataset_uid}/resources/files, again using the dataset_uid from step 1. From the response I get the file_uid of the uploaded file. Update the dataset resource using the endpoint /api/automation/v1.0/datasets/{dataset_uid}/resources/{resource_uid}, with the dataset_uid from step 1, the resource_uid from step 2, and the file_uid from step 3. Republish the dataset using the endpoint /api/automation/v1.0/datasets/{dataset_uid}/pu

Hi everyone,I regularly use the "Analysis" tab to create visualizations on our datasets, and I encounter two unexpected behaviors when switching from Standard Mode to Advanced Mode. This limits the customization of our charts.I would like to share these two cases to see if other users are experiencing them or if an improvement is planned:1. Missing Breakdown options In Standard mode, I have access to a full list of options for my data breakdown.However, as soon as I click on "Edit in advanced mode", some of these breakdown options disappear from the dropdown menu and are no longer selectable.  2. Redundant label display on the X-axis When creating a time-based chart, the X-axis label displays correctly in Standard mode. When switching to Advanced Mode, the display changes and seems to force the display of the precision (e.g., year/month), creating an unaesthetic duplicate with the main label. Even when tweaking the "Axis precision" option, I cannot find a way to hide this duplicate or

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

Hello,Is it possible to get a descending order by date using the OdsDatasetContext widget in a custom view ?I have tried something like below :<ods-dataset-context context="ctx" ctx-dataset="own_base"   ctx-parameters="{'sort':'-start_date'}">[...]</ods-dataset-context>but it’s not a success…Thank you for your help.

HiI’m working on accessibility fixes for a client who is using a portal theme.Apparently, many of the issues originate from the portal theme. So I would need to edit the HTML in many places, and in some cases even add JavaScript.Currently, I can’t find any way to change the HTML, and I saw in the documentation that adding JavaScript isn’t allowed for security reasons, which I understand.So I was looking into how I can contribute to the theme, but I can’t seem to find how to do that. That’s why I opened this topic.Thanks for the feedback.Matthias

We are evaluating our move to the marketplace experience and support have been wonderful in helping achieve some of our goals that we’ve always wanted.One, is to have a couple of feeds on the front page showing the latest datasets but also latest publications (a new asset category we have created).Supports suggestion was to setup a couple of new contexts fed from a dataset of datasets. Which weve done and got so far but realised a dataset of datasets is just that. datasets only. Not assets. Also looking at the API I cannot see a way to actually query the asset catalogue. Question is: Has anyone successfully implemented a feed of various assets powered by the catalogue itself and not having to maintain a separate dataset? Attached is my current code block that reads from a dataset of datasets and incorporates the suggestions from support. Although the refine.category doesnt work as dataset of datasets doesnt include anything but datasets and also no category. Also the Asset slug wont wo

Dear Support Team,we have received the following request from a user regarding dataset https://data.bs.ch/explore/dataset/100120/, which we would like to forward to you for further investigation.The user reports an inconsistency in the handling of the field vu_jahr: The field is defined as a date in the dataset schema. However, when exporting the dataset, the field appears to be delivered as a string. When querying the dataset via ODSQL (using a SELECT vu_jahr GROUP BY vu_jahr query), the result returns proper datetime values (e.g. 2011-01-01 00:00:00+00:00, etc.). This inconsistent behavior causes issues in the user’s synchronization process. While they have implemented a workaround on their side, they asked whether this could be fixed at the platform level.Example query used by the user:https://data.bs.ch/api/explore/v2.1/catalog/datasets/100120/exports/csv?lang=de&timezone=Europe%2FBerlin&use_labels=false&delimiter=%3B&select=vu_jahr&group_by=vu_jahrCould you

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!

Hi All,We currently have a document library on our website, however we have had feedback from customers that its not easy to navigate.As a result we are exploring the possibility of using our Open Data Portal as a home of a new “Technical Library” containing 200+ pdfs etc of supporting documents. Now it seems that after about 80 additional attachments I cant add anymore. As a DNO, we are very cautious around data security so essentially I need a solution where the documents can be stored on the Portal itself in an ideal world, because using options like github, sharepoint etc arent really viable as getting permission would likely be a dead end.Anyone got any ideas or examples of similar resources? Potential to spilt the attachments over multiple datasets but that becomes a bit of a nightmare to maintain/policeThanksRyan

Hello,I am a student and currently working on a data project that involves the use of public datasets hosted on this platform, specifically: OSM France – Parking Area OSM France – Public Service I would like to access these datasets programmatically via your API, but I am unable to locate or generate an API key from my account.Could you please grant me API access or guide me on how to obtain the necessary API key for these datasets?If it requires approval from a workspace administrator, please let me know the appropriate steps or contact.Thank you very much for your time and assistance.Kind regards,Chleo Hinn

Hi !We have recently created a page for our DNOA data report, it all works well and happy with it, apart from one map which doesnt seem to be loading correctly Distribution Network Options Assessment — Open Data | Northern Powergrid The map in question is in the “Network Dashboard” tab, and has a lot of grey space. It works fine if i full screen then minimize again. Any thoughts as to why it appears to stop loading? Thanks Ryan

Does anyone have any tips on how to shape data in our portals to work better with the AI tools? The concern from our leadership is someone will ask a question and if the data contains too many filterable items it could return an incorrect result.Is there any guidelines on how to better shape the data to make it easier for AI to understand and provide results?

Is there any way to retrieve this information via one of the APIs?I have approx 126 datasets and I want to check the refresh schedules set for all of these against the update frequency set in the asset metadata field. 

Hi, I’m Kamal Hinduja , Switzerland(Swiss). Can anyone explain me in details Are there limits on API call rates or data retrieval sizes? Thanks 

I am kindly requesting air quality datasets with variables  PM2.5, PM10, O₃, NO₂, SO₂, etc.) across many locations in Africa.

As there is still missing a button that hides a public dataset from catalog, we’re trying to do a workaround.For that, we would like to incorporate a public dataset of our secondary workspace, which isn’t publicly promoted, into a dashboard/code-editor’s page of our primary workspace. Has someone tried something similar? Has it worked out?My first thought was to do it via “domain” attribute of “ods-dataset-context” widget, but that didn’t work out: <ods-dataset-context context="test" test-dataset="test-index-dataset" test-domain="https://myseconddomain.opendatasoft.com/" ></ods-dataset-context>Thanks for your ideas :)

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

Hi All,Is there any definitions for the possible “Actions” in the portal api monitoring? Ie what defines a “download” etc Thanks Ryan 

Hello everybody,I have 2 maps in my dashboard (2 different years):  I would like to have a shared “location” between those two.For example, if I zoom on the left one, I want the right one to be zoomed also.Is it possible ?Thanks in advance

I have a date selector on a custom view: https://cityobservatory.birmingham.gov.uk/explore/dataset/percentage-universal-credit-claimants-in-employment-wmca-wards-2025/insight/ The date selector is based on the date field which is set to type of month. However its only showing years. How can I have this show months? <div ods-facet-results="date" ods-facet-results-facet-name="date"ods-facet-results-context="ctxfiltered" ods-facet-results-sort="-alphanum"> <ods-selectselected-values="ctxfiltered.parameters['refine.date']"multiple="false"options="date"label-modifier="name"value-modifier="name"placeholder="Date"></ods-select></div>