Skip to main content

Managing data portal

Manage workspaces, users and requests

  • 31 Topics
  • 53 Replies
31 Topics
danny.oneill
danny.oneillGuide
asked in Managing data portal
Managing updating of flat file datasets

I would like to garner some ideas on how y’all manage updating static, flat file datasets on a regular basis.Most of ours pull from the source via API. But a few require us every week/month/year to download a flat file from the source to then re-upload to our platform.At first I thought a simple calendar with what needs doing when would be a good idea. But, some datasets dont drop on a regular schedule or can be delayed. So if I have a calendar entry saying “Download X data today” and its not there. It doesnt get done and I forget that ive not actually done that. So I need some way to check it off.How do you all efficiently manage your flat file updates? What tools or methods do you use?

80
danny.oneill
Johannes Hool
Johannes HoolGuide
asked in Managing data portal
Best Practice for Updating Dataset Resources with the Automation API

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

262
Johannes Hool
O
opd_2025Seeker
asked in Managing data portal
"Invalid value for sum of offset + limit API parameter" error with exports endpoint

I do not see any limitations on the offset and limit parameters for the exports endpoint. However, when I make the following request:https://data.longbeach.gov/api/explore/v2.1/catalog/datasets/lbpd-ripa-data-annual/exports/csv?offset=1I get back a CSV file with only 2 rows and the 2nd row says: “Streaming interrupted due to the following error: Invalid value for sum of offset + limit API parameter: 83714 was found but <= 10000 is expected. (error_code: InvalidRESTParameterError)”I thought the 10000 limit for offset+limit only applied to the records input. Is that wrong?If it’s useful, I am able to retrieve the entire dataset at once:https://data.longbeach.gov/api/explore/v2.1/catalog/datasets/lbpd-ripa-data-annual/exports/csv?offset=0

161
Y
Community Manager
A
astefaniukSeeker
asked in Managing data portal
ods-chart formating CSS custom library not working

Hello, I am trying to change the thickness of the line in one of my ods-charts. I saw in the documentation that I can use a custom css library to change the formatting (ods-chart: Custom CSS Library – Codelibrary).I added the class="large-chart-series" to my ods-chart and it worked well when I was running the website locally.However when I try to implement the changes in the code editor on the ODS portal I am getting an API error:Is using the custom css library depreciated?What else can I do do change the format of my charts?Below I am pasting the code for the ods-chart I was working on. Thanks for the help  <ods-chart class="large-chart-series" single-y-axis="true" single-y-axis-label="" display-legend="true" label-x="" scientific-display="false" align-month="true" class="no-bg" > <ods-chart-query context="eolienperiodique" field-x="timestamp"

121
A
Gabriellabrowne
GabriellabrowneSeeker
asked in Managing data portal
Optimizing Opendatasoft Dashboards for High-Performance Data Visualizations

Hello Opendatasoft Community,I've been exploring the capabilities of Opendatasoft for creating dynamic dashboards and interactive data visualizations. The platform's flexibility in handling diverse datasets and its user-friendly interface have been impressive. However, as I delve deeper into more complex data representations, I'm curious about best practices to ensure optimal performance and responsiveness.Specifically, I'm interested in strategies for: Efficiently managing large datasets to prevent lag in visualizations. Implementing real-time data updates without compromising dashboard speed. Utilizing Opendatasoft's API features to enhance data interactivity. Given the platform's robust features , I'm confident there are effective methods to achieve these goals.On a related note, I've been considering hardware upgrades to support more intensive data processing tasks. Would investing in an i5 gaming laptop provide the necessary performance boost for handling complex data visualiz

130
Gabriellabrowne
Gabriellabrowne
GabriellabrowneSeeker
asked in Managing data portal
Smooth Experience Using Opendatasoft on Laptop i5

Hi everyone,I just wanted to share a bit of my experience using Opendatasoft recently, especially from the perspective of someone working on mid-range hardware. I’ve been working with open datasets for a local community project and found the platform intuitive and responsive even without using high-end specs.To my surprise, running Opendatasoft on a laptop i5 has been smooth and reliable for most common tasks like publishing datasets, generating charts, and using API features. I expected some lag with large datasets, but it's been manageable with some minor tweaks like closing background apps and using lightweight browsers. This gives me confidence that the platform is well-optimized for a wide range of devices.Credit to community.opendatasoft.com for being a helpful source of guides and best practices. I believe users who may not have access to premium hardware will still find the platform very usable and efficient, especially if they're handling structured or moderate-volume data.Tha

260
Gabriellabrowne
R
Rahel RusterholzSeeker
asked in Managing data portal
Text length

Is there a limit to the number of characters in text columns? I have long texts in a column and these are cut off in the tooltip and in the table preview. Is there a solution so that the whole text is displayed?

646
R
T
TristanSeeker
asked in Managing data portal
Stop auto unzip

HelloI want to publish a dataset that is in a ZIP format. The source is a URL that I don’t want to share for safety/server load reasons. Unfortunately, ODS unzip it automatically.I just want an other URL pointing toward the same zip file… is it possible?Thank you Auto-translation 🪄BonjourJe souhaite publier un jeu de données au format ZIP. La source est une URL que je ne souhaite pas partager pour des raisons de sécurité/charge du serveur. Malheureusement, ODS le décompresse automatiquement. Je souhaite simplement une autre URL pointant vers le même fichier zip… est-ce possible ? Merci 

523
A
ODS Team
A
antoinebugeiaSeeker
asked in Managing data portal
API for style sheet

Hi,we would like to use ODS API to implement CICD on the style sheet of our portal.We are waiting since severals years now for this feature to appear in automation, I guess it won’t happen.Anyway ODS made previously a GH repo with a snippet of how to use management api to update the style sheet :https://web.archive.org/web/20201013231909/https://github.com/opendatasoft/ods-portal-devkit#expandUnfortunatly this repo is now deleted and the files ont the repo are gone.Is anyone aware on how to use the management API for the domain_theme ?

803
G
S
Steve CrawshawSeeker
posted in Managing data portal
Height of map in custom views

When you include a map widget in a custom view for a dataset you may notice that the height is not optimal for screens. You can change this with the following css in the Custom View tab of Visualisations in the backoffice. Adjust the min-height value to suit. .odswidget-map {    height:-webkit-fill-available;    min-height: 600px;}.odswidget-map__map {    height: 100%;    min-height: 600px;}

130
S
R
RenatoFSeeker
asked in Managing data portal
Where are the filter settings?

Since you updated the backend and put the schema into a separate tab, I am only able to access the filter information through the explore api. Where in the new backend do I find the filter settings (in the web interface)? Also, and related, where are the facet settings in general?Regards,Renato

442
R
Christian Trachsel
Christian TrachselSeeker
asked in Managing data portal
Order of the Facets with the new backend

Hi how does I sort the facets. The button doesn’t work like I thought. when I push the UP button, nothing happenAuto-translation 🪄Bonjour, comment trier les facettes. Le bouton ne fonctionne pas comme je le pensais. Lorsque j'appuie sur le bouton UP, rien ne se passe

622
Valentine
ODS Team
R
RenatoFSeeker
asked in Managing data portal
Opendatasoft Documentation

HiWhere do I find the documentation for opendatasoft? Right know, I would like to know how exactly RTP behaves. E.g. what happens when I push a dataset with data that is already present, that is updated, or with just a few updates?But I am more interested in where your documentation is located. I am looking for something similar as the Automation v1 API documentation: https://help.opendatasoft.com/apis/ods-automation-v1/. When I have similar problems in the future, I would like to know where to search for the solution instead of asking in the community each time I run into a problem. Best,RenatoAuto-translation 🪄BonjourOù puis-je trouver la documentation d'opendatasoft ? Je voudrais savoir comment se comporte exactement RTP. Par exemple, que se passe-t-il lorsque je transmets un ensemble de données contenant des données déjà présentes, mises à jour ou avec seulement quelques mises à jour ? Mais je suis plus intéressé par l'emplacement de votre documentation. Je recherche quelque chose

434
R
Guillaume Perrin-Fabre
Guillaume Perrin-FabreSeeker
asked in Managing data portal
Support extension Chrome Opendatasoft

Icons I was using the Opendatasoft Chrome extension until now (it’s very helpful to get the datasets in use on a page, or to go directly to the backoffice of the page)But it’s not supported anymore: Is there a way to make it available again?Thanks in advanceAuto-translation 🪄Icônes J'utilisais jusqu'à présent l'extension Chrome d'Opendatasoft (très utile pour récupérer les jeux de données utilisés sur une page, ou pour accéder directement au backoffice de la page)Mais elle n'est plus supportée : existe-t-il un moyen de la rendre à nouveau disponible ? Merci d'avance

562
Guillaume Perrin-Fabre
Yiu-Shing Pang
Yiu-Shing PangSeeker
posted in Managing data portal
Data catalog search result

Hello,Opendatasoft allows a range of filters for dataset searches as such. Using UKPN's data portal as an example:some 33kV results at the beginning. However, it omits datasets that actually contain the search term - such as “33kV” in my example - is there a filter that closely matches best fit? Such that “33kV” results show first? If not, can this be requested as a feature please?   33kV result at the end! Auto-translation 🪄Bonjour, Opendatasoft permet une gamme de filtres pour les recherches d'ensembles de données en tant que tels. En utilisant le portail de données d'UKPN comme exemple : certains résultats 33 kV au début. Cependant, il omet les ensembles de données qui contiennent réellement le terme de recherche - comme « 33 kV » dans mon exemple - existe-t-il un filtre qui correspond étroitement au meilleur ajustement ? De telle sorte que les résultats « 33 kV » s'affichent en premier ? Si ce n'est pas le cas, peut-on demander cela en tant que fonctionnalité ?  ...

371
Y
Community Manager
boris.djakovic
boris.djakovicGuide
asked in Managing data portal
SSO bigger and more present

Hello dear community,Could we make the SSO feature more prominent?Many employees don’t realize that they can use their existing government account to sign in.Currently, it looks like this: But we were thinking about something like that: Best regards,BorisAuto-translation 🪄Bonjour chère communauté,Pourrions-nous rendre la fonctionnalité SSO plus visible ?De nombreux employés ne savent pas qu'ils peuvent utiliser leur compte gouvernemental existant pour se connecter.Actuellement, cela ressemble à ceci : Mais nous pensions à quelque chose comme ça : Cordialement,Boris

361
A
ODS Team
B
BhanupriyaSeeker
asked in Managing data portal
Wanted to add Button in information tab

Is there any option to add button or link a sheet in information tab for each dataset?Auto-translation 🪄Existe-t-il une option permettant d’ajouter un bouton ou de lier une feuille dans l’onglet d’informations pour chaque ensemble de données ?

351
Rémy
Community Manager
David Guillaume
David GuillaumeSeeker
asked in Managing data portal
date selector from minute timestamp

Hello,I have a 'timestamp' column of type datetime with minute precision. I would like to create a selector (<ods-select>) that selects and displays only the days (27/11/2024) and not every minutes. Best regards,Auto-translation 🪄Bonjour,J'ai une colonne 'timestamp' de type datetime avec une précision à la minute. Je souhaiterais créer un sélecteur () qui sélectionne et affiche uniquement les jours (27/11/2024) et non toutes les minutes.  Cordialement,

461
B
ODS Team
T
ThomasKSeeker
asked in Managing data portal
Want to english texts in the export API

Hello,I want the texts in English (that are translated from Swedish into English and stored in the portal) when I download metadata from the export API. I want to check the quality of the translations and perhaps improve them using chatGPT,Anyone who have succeded to download the translated metadata with the export API? Please tell me how you did it. Auto-translation 🪄Bonjour, je souhaite obtenir les textes en anglais (qui sont traduits du suédois vers l'anglais et stockés dans le portail) lorsque je télécharge les métadonnées à partir de l'API d'exportation. Je souhaite vérifier la qualité des traductions et peut-être les améliorer à l'aide de chatGPT. Quelqu'un a-t-il réussi à télécharger les métadonnées traduites avec l'API d'exportation ? Veuillez me dire comment vous l'avez fait.

382
T
R
RenatoFSeeker
asked in Managing data portal
Difference between Temporal Period and Temporal Coverage

HelloI wanted to enrich our metadata with the temporal information for datasets where this makes sense. Now, I am a bit confused where I should fill this out. We have two options that have the exact same content, as far as I am concerned. There is:Temporal Period: A text field Temporal Coverage: Two fields (“Temporal coverage start date“ and “Temporal coverage end date“) that are date fields of the form “DD/MM/YYYY hh:mm:ss”Can anyone please elaborate the difference between the two options and their intended use cases, and which field is intended for my use, i.e. to document the first and last date that appears in any date column of the dataset? Best regardsAuto-translation 🪄BonjourJe voulais enrichir nos métadonnées avec les informations temporelles pour les ensembles de données lorsque cela a du sens. Maintenant, je ne sais pas trop où je dois remplir cela. Nous avons deux options qui ont exactement le même contenu, en ce qui me concerne. Il y a :Période temporelle : Un champ de tex

491
Benwa
ODS Team
danny.oneill
danny.oneillGuide
asked in Managing data portal
Delete records with value less than 5000

I am being really dense here. But I cannot fathom how to use the ‘Delete records processor’ to delete all records where the value is below £5,000.I have tried entering = < 5000 into the field but that doesnt function as expected. Is it possible to remove rows based on a filter?Auto-translation 🪄Je suis vraiment un peu con. Mais je ne comprends pas comment utiliser le « Processeur de suppression d'enregistrements » pour supprimer tous les enregistrements dont la valeur est inférieure à 5 000 £. J'ai essayé de saisir = < 5000 dans le champ, mais cela ne fonctionne pas comme prévu. Est-il possible de supprimer des lignes en fonction d'un filtre ?

241
Benwa
ODS Team
boris.djakovic
boris.djakovicGuide
asked in Managing data portal
Multiple links not displayed correctly on opendata.swiss

Hello dear community,I am writing about the Dct:relation-issue that we have. Multiple links are not displayed correctly on opendata.swiss https://opendata.swiss/de/dataset/allmendbewilligungen (see Screenshot).In our data portal, on the other hand, they are displayed correctly, with the semicolon as a separate value https://data.bs.ch/explore/dataset/100018/information/ .Unfortunately, it looks awkward on opendata.swiss, and the link doesn't work either. Here is an example of a dataset from the Federal Office of Public Health that also uses multiple references: https://opendata.swiss/de/dataset/covid-19-schweiz  It would be essential to have the option of providing multiple references to increase data quality and enable users to access comprehensive information. This functionality is crucial for us because we want to showcase our data effectively on opendata.swiss and the European data portal data.europa.eu. By providing multiple references, we aim to enhance the visibility and credibi

1044
Valentine
ODS Team
David Guillaume
David GuillaumeSeeker
asked in Managing data portal
best practive "ods-dataset-context"

Hello everyone,I have a question regarding best practices for using the <ods-dataset-context> tag. I've seen many examples where the entire HTML code is nested within a context tag (containing all the contexts), and I've seen other examples where there are several context tags that nest only the tags using the relevant context. Are there any advantages or disadvantages (especially in terms of performance in a dashboard with many different contexts) to using one practice over the other?I hope my question is clear, and thank you in advance for your responses. Best,DavidAuto-translation 🪄Bonjour à tous, J'ai une question concernant les bonnes pratiques d'utilisation de la balise . J'ai vu de nombreux exemples où l'intégralité du code HTML est imbriquée dans une balise de contexte (contenant tous les contextes), et j'ai vu d'autres exemples où il existe plusieurs balises de contexte qui imbriquent uniquement les balises utilisant le contexte pertinent. Y a-t-il des avantages ou des

782
David Guillaume
danny.oneill
danny.oneillGuide
asked in Managing data portal
Handling news/blog content

How has everyone handled integrating a blog or news items into their ODS based website without the need for an external site like Wordpress.Can anyone recommend any examples of an implementation they find particularly useful or any tips on how they have achieved this.On our site we want to have data and written publications using the pages. But, our leadership would also like a blog like functionality for showcasing news items or other non publication items like opinion pieces or announcements. For me, I like how Portal - News — E-REDES (opendatasoft.com) has handled news and would love to know more how they achieved this as it appears to draw from a dataset but use an ID value in the URL to display.Auto-translation 🪄Comment tout le monde a-t-il géré l'intégration d'un blog ou d'articles d'actualité dans son site Web basé sur ODS sans avoir besoin d'un site externe comme Wordpress. Quelqu'un peut-il recommander des exemples d'une mise en œuvre qu'il trouve particulièrement utile ou de

731
M
ODS Team
danny.oneill
danny.oneillGuide
asked in Managing data portal
Adding linkedin feed to homepage

I see from the code library we have the ability to use the twitter feed scripts but does anyone know if any other options exist that can support Linkedin? Either directly from their site or via other approved aggregators (as only approved scripts are permitted).Auto-translation 🪄Je vois que dans la bibliothèque de codes, nous avons la possibilité d'utiliser les scripts de flux Twitter, mais est-ce que quelqu'un sait s'il existe d'autres options pouvant prendre en charge Linkedin ? Soit directement depuis leur site, soit via d'autres agrégateurs approuvés (car seuls les scripts approuvés sont autorisés).

241
Lauralee
ODS Team

Hello there!

Ask away and you shall receive an answer.
Terms & ConditionsCookie settings
Opendatasoft Terms & Conditions Cookie settings