Skip to main content

Recently active topics

32
darioschiraldi99
darioschiraldi99Seeker
 Organize data
Dario Schiraldi - How do I perform a data join in SQL or Python?

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 

60
darioschiraldi99
Y
yvonneGuardian
 
Secure datasets markerOpen

It would be great for datasets which are not set to public to be marked as “private” on the Explore page view.Currently as an administrator, I have to click “Edit” and then to go to the security tab to see if this is set to be on:Access restricted to allowed users and groupsIt would be awesome if on the Explore page it had some sort of corner marker or indication that the dataset is in someway restricted.A couple of example options to mark a dataset 

3
434
Y
danny.oneill
danny.oneillGuide
 Share data
Shaping data to work better with the AI tools

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?

20
danny.oneill
P
Community Manager
PaulineCommunity Manager
Perform joins with large datasets using the new processor 🚀

The previous limit of 100,000 records is gone. 🎉Enrich your data now using large datasets with large reference datasets such as France’s SIRENE (a directory of ID codes for every business in the country)— without compromising performance!        👉 To try out the new processor, check the user documentation.👉 To understand potential impacts, watch this video.

130
P
Community Manager
Nadia VBX
Nadia VBXSeeker
 
Gestion multilingue des métadonnées schéma standard ODS Vs schémas spécifiques + possibilité de mappingOpen

Bonjour, la gestion multilingue n’est possible que pour 6 métadonnées du schéma standard ODS et pour aucunes métadonnées des schémas spécifiques DCAT ou autre.A Bruxelles, nous devons publier ces métadonnées en français et en néerlandais (langues locales officielles) et idéalement en anglais (langue internationale) et permettre aux utilisateurs ou autres institutions belges et européennes de les harvester.Est-ce que des développements sont prévus au niveau de la gestion multilingue des métadonnées chez tous clients Opendatasoft ?Comment configurer du mapping automatique de champs du schéma standard vers un schéma spécifique ?Merci d’avance pour votre réponse,Nadia

2
61
Valentine
ODS Team
P
paulpainterSeeker
 The world of data
Studio Maps to provide summarised number at point of location

Are there plans to add more mapping capability for Studio Maps - for example clusters, dots and shapes and heat maps - same functionality that is shown in Map Builder? 

10
P
R
RyanGuide
 
Favourite/Subscribed dataset functionalityOpen

Hi!Im aware that users can subscribe to datasets, given us a easy method to contact, but could we possible add a subscribed filter for users within the data catalogue? This way users can take advantage of the feature as a “favourite” kind of functionality, and aid with their navigation. I think it would also increase the % of users that then subscribe to datasets, making it easier for us as admins

1
41
E
M
mandresyandriSeeker
 
Problème height embeddedOpen

Bonjour, Nous avons un souci pour les widgets qu’on développe en page custom.En effet, quand on essaye de les intégrer dans une page, la fonction height=”fit-content” n’est pas prit en compte. Bonjour,Nous rencontrons un problème avec les widgets que nous développons pour les pages personnalisées. En effet, lorsque nous essayons de les intégrer dans une page, la fonction height="fit-content" n'est pas prise en compte.Nous avons rencontré ce problème notamment pour les résultats des élections. Quelqu'un aurait-il une solution ?Je vous remercie. Je vous remercie

3
295
M
L
LucasSmetSeeker
 
Improve and automate "follow datasets"Open

The “follow dataset” option is great but can be time consuming and sujbect to errors. To mitigate for this, an example of features : For each dataset, allow the admin to chose between sending notifications automatically or manually For the automated part, allow the admin to chose the frequency of notifications : “for every update” (might ne be ideal for datasets updated daily), “max once a day”, “max once a week”, etc For each dataset, allow the admin to save a default text, ideally with multilingual option and rich text instead of plain text

2
20
L
Y
yvonneGuardian
 
Notification to Admins - storage quotaOpen

We would like a notification email or otherwise when we are nearing the capacity of the portal limits.

4
70
Y
Y
yvonneGuardian
 
Field name information popupOpen

We moved from CKAN to ODS and really miss one of the features of having the ability of “information” or “tip” popup on each of the metadata fields  

2
50
Y
D
Domi SchusterSeeker
 Share data
Refinement by excluding a value possible?

As I’m trying to create a page with the code editor, I’m facing an issue with the refinement of datasets.To automate a line chart for different contexts, so that I can select one dataset of a list of many datasets and use the same ods-chart tag, I want to refine all the contexts before referencing on them in the chart widget. But the important aspect of my question is this: For this refinement, it would be more convenient for me to define the values that should be excluded, instead of the ones that should be included.Is there a possibility to do so?Thank you all in advance! :)

112
D
D
Domi SchusterSeeker
 Share data
Series breakdown: unselect some facet values per default

I want to display the evolution of population in all districts of Würzburg with a line chart. For that I use this dataset.In order to compare the districts, I created a series-breakdown on “Stadtbezirk” facet. But since there are 13 districts, this looks a little bit confusing. At the moment, one could unselect several districts by hand by clicking on them in the legend. In this case, it would be more convenient, if there are all but a one ore two districts unselected by default.Is there any possibility to implement this in the HTML or CSS-Code?At the moment, the code for the chart looks like this:<ods-dataset-context context="stadtbezirkehauptwohnsitzaltersgruppen" stadtbezirkehauptwohnsitzaltersgruppen-dataset="stadtbezirke_hauptwohnsitz_altersgruppen"> <ods-chart scientific-display="false" align-month="true"> <ods-chart-query context="stadtbezirkehauptwohnsitzaltersgruppen" field-x="jahr" maxpoints="0" timescale="year" series-breakdown="stadtbezirk">

82
D
R
rajathjamadagniSeeker
 
More detailed and user-friendly quota limit error messagesOpen

Hi,I wanted to share some feedback regarding the current error message when publishing datasets hits a quota limit: “Someone reached a quota limit when publishing the dataset”.This message is quite vague and doesn’t specify which quota (storage, record count, dataset number, etc.) was exceeded. It also doesn’t offer any guidance on what the user can do to resolve or investigate the issue.For a better user experience, it would be great if the message could clearly state which quota limit was reached (e.g., storage space, number of records, dataset count)This would help users quickly understand the problem and how to fix it, reducing confusion and support requests. Please see screenshot below for reference.  

4
100
R
hindujafamilyswiss
hindujafamilyswissSeeker
 Organize data
What is Schema management for datasets ?

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)

60
hindujafamilyswiss
E
Eva BerrySeeker
 Analyze usage
Automation of dataset usage Statistics

Hello,Using the dataset named “ods-api-monitoring”, I am able to know the number of download for a specific dataset. However, I would like to perform this task every month, that’s why I want to automate this process using python. I tried to filter the dataset and take the link of the csv generated in order to upload it on python. Nevertheless, I have an error while launching the program, it seems that it has a link with the authentification on the plateform. Do we have access to an API for the dataset “ods-api-monitoring” ?  Or is there another recommended way to retrieve this information?Thank you for your help.Best regards,Eva Berry

377
E
Y
yvonneGuardian
 
Custom ordering of FacetsOpen

We would like to be able to add a custom option for ordering of facets.  At this point you can only have the option to order by Alphabetical and order by Number of instances (either ascending or descending).  But imagine if you have a set of facets such as SmallMedium Large None of the options make sense, and yet we would want to order it Small, then Medium, then Large  

2
132
Y
M
Maria SöderlindSeeker
 
Removed users that register again should be visible in the Back office for adminRefused

I invited a user and gave it some permissions.The user created some visualisations and worked with data sets.I removed the permissions.I removed the user.The user could not log in at first, but selected “Forgot the password”. Changed the password and could log in.At this point the user can continue to work on visualisations, and create new ones (on opendata). This is not the problem.The problem is this – the user is not visible in the Back Office when selecting “Users & Groups->Users”.Not even when searching for that specific user. For the user, it looks fine. However…The user goes to “Your account->Settings”Changes the personal information, the name.Presses “Save my information”“Your changes have been saved” is shown.However…nothing is saved of these changes. And the user is still not visible in the Back Office. There is a workaround - the admin can invite the user again. But the main issue remains - Admin should be able to see the user in Back Office since all other users a

1
231
Nicolas Terpolilli
Community Manager
Guillaume Perrin-Fabre
Guillaume Perrin-FabreSeeker
 
New functionality: be able to impersonate one userRefused

Hello the ODS community, Here is a new idea: be able to impersonate one user. For example, I am inviting user XXX on the platform, I add him in different groups (for which we have configured some security on datasets and visualisations). I would like to be able to see what the user XXX will see after accepting the invite. I don’t know if it could help anybody else, but for us it would be very nice to help “debug” access to some datasets/visualisationsThanks!

2
362
Nicolas Terpolilli
Community Manager
Nicolas Terpolilli
Community Manager
Nicolas TerpolilliCommunity Manager
 
Improve filtering in lineage legendRefused

Improve filtering in lineage legend

1
121
Nicolas Terpolilli
Community Manager
A
AgORESeeker
 
Improve reuse declarationReleased

If a reuse is based on multiple datasets (and it’s the main case) you have to declare the reuse for each concerned dataset, which is tedious and does not add value to the cross-referencing of dataAuto-translation 🪄Si une réutilisation est basée sur plusieurs jeux de données (et c’est le cas principal) il faut déclarer la réutilisation pour chaque jeu de données concerné, ce qui est fastidieux et n’ajoute pas de valeur au croisement des données

5
331
Nicolas Terpolilli
Community Manager
Nicolas Terpolilli
Community Manager
Nicolas TerpolilliCommunity Manager
 
Improve how reuses are showcased in a portalReleased

Improve how reuses are showcased in a portal

3
373
Nicolas Terpolilli
Community Manager
P
Community Manager
PaulineCommunity Manager
Schema management for your datasets is changing 🚀News

No more endless scrolling to move a field when managing your dataset schema! With the new interfaces and a dedicated tab, everything becomes simpler and faster.  Schema define the structure of your datasets and we’ve completely redesigned how you manage them for a smoother and more intuitive experience.Discover the updates included in this release. 👇 A new tab dedicated to schema managementUntil now, schema management was accessed via the "Processing" tab of your back office. Moving forward, it has its own dedicated space in the new "Schema" tab.     An optimized visualization and editing experienceIntuitive drag-and-drop management to instantly organize your fields. Seamless navigation, perfect for effortlessly browsing through columns. Simplified editing through a separate side panel.   Faster and more flexible schema management performanceWith schema management now in a dedicated tab, schema changes are now applied instantly, independent of the processing preview's calculation t

1336
Valentine
ODS Team
Y
yvonneGuardian
 
Deduplicated Records - notificationOpen

Sometimes when datasets are loaded there are records which are de duplicated when there is an exact match.. This is great however, we have no idea which record/s get deduplicated and would like to make sure we are fixing data at the source. On creating a dataset/loading a source can we get a notification of the records that are de-duplicated?

2
50
Y
K
kamalhindujaSeeker
 Organize data
Kamal Hinduja Geneva, Switzerland : How Opendatasoft integration with Public Datasets?

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  

201
boris.djakovic

Hello there!

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