This site uses cookies. By continuing to browse the site, you agree to our use of cookies. Find out more about cookies.
Skip to main content
Metadecidim's official logo
  • English Triar la llengua Elegir el idioma Choose language
    • Català
    • Castellano
Sign Up Sign In
  • Home
  • Processes
  • Assemblies
  • Initiatives
  • Consultations
  • Conferences
  • Help

Propose new functionalities for Decidim software

#DecidimRoadmap Designing Decidim together

Phase 1 of 1
Open 2019-01-01 - 2030-12-31
Process phases Submit a proposal
  • The process
  • Debates
  • Propose new features
  • News
chevron-left Back to list

Import proposals from spreadsheet

Avatar: Antti Hukkanen Antti Hukkanen
27/11/2019 14:14  
Finished

It is very common that municipalities still collect ideas on paper, as unfortunate as it is in a digital era. Not everyone has the necessary digital skills to use Decidim and some people are concerned about entering their personal details to any digital system.

Therefore, admin users want to bulk import paper collected ideas to Decidim.

The import document should contain the following columns:
- Proposal title
- Proposal body
- Proposal category ID
- Proposal scope ID

The import should work per component and the proposals should be imported to that component.

Similarly to the participatory texts, the admin user should be shown a preview of the proposals to be imported before actually importing them.

The admin user should be able to also define under which user these proposals are imported to similarly as it is possible to select for normal proposals (his/her personal name or a group he/she belongs to).

This feature should be an admin feature available under the proposals admin panel.

  • Filter results for category: Proposals Proposals

The development of this proposal has finished

  • Reviewed by @product and accepted in the main project
  • Funded by Mainio Tech
  • Developed by Mainio Tech
  • Available in release 0.24 via  #7084

List of Endorsements

Avatar: Decidim Product Decidim Product verified-badge
Avatar: Virgile Deville Virgile Deville
Avatar: Pauline Bessoles Pauline Bessoles verified-badge
Avatar: Csaba Madarász Csaba Madarász
Avatar: Pierre Mesure Pierre Mesure verified-badge
and 2 more people (see more) (see less)
Endorsements count5
Import proposals from spreadsheet Comments 3

Reference: MDC-PROP-2019-11-14939
Version number 3 (of 3) see other versions
Check fingerprint

Fingerprint

The piece of text below is a shortened, hashed representation of this content. It's useful to ensure the content hasn't been tampered with, as a single modification would result in a totally different value.

Value: 75230df8bb46f267af492efd75b41cd5635e8c7c5a9e12c7e6ae4933d9b72f45

Source: {"body":{"en":"It is very common that municipalities still collect ideas on paper, as unfortunate as it is in a digital era. Not everyone has the necessary digital skills to use Decidim and some people are concerned about entering their personal details to any digital system.\r\n\r\nTherefore, admin users want to bulk import paper collected ideas to Decidim.\r\n\r\nThe import document should contain the following columns:\r\n- Proposal title\r\n- Proposal body\r\n- Proposal category ID\r\n- Proposal scope ID\r\n\r\nThe import should work per component and the proposals should be imported to that component.\r\n\r\nSimilarly to the participatory texts, the admin user should be shown a preview of the proposals to be imported before actually importing them.\r\n\r\nThe admin user should be able to also define under which user these proposals are imported to similarly as it is possible to select for normal proposals (his/her personal name or a group he/she belongs to).\r\n\r\nThis feature should be an admin feature available under the proposals admin panel."},"title":{"en":"Import proposals from spreadsheet"}}

This fingerprint is calculated using a SHA256 hashing algorithm. In order to replicate it yourself, you can use an MD5 calculator online and copy-paste the source data.

Share:

link-intact Share link

Share link:

Please paste this code in your page:

<script src="https://meta.decidim.org/processes/roadmap/f/122/proposals/14939/embed.js"></script>
<noscript><iframe src="https://meta.decidim.org/processes/roadmap/f/122/proposals/14939/embed.html" frameborder="0" scrolling="vertical"></iframe></noscript>

Report inappropriate content

Is this content inappropriate?

Reason

3 comments

Order by:
  • Older
    • Best rated
    • Recent
    • Older
    • Most discussed
Avatar: Csaba Madarász Csaba Madarász
30/06/2020 16:59
  • Get link Get link

is there anything new about it? I think it would be a very useful feature.

Avatar: Pierre Mesure Pierre Mesure verified-badge
08/12/2021 11:51
  • Get link Get link

I realise today that the export function doesn't export proposal coordinates (latitude, longitude, address) and that this import function doesn't seem to import coordinates. Does anyone have a tips on how to import many proposals with coordinates from a file?

Avatar: Pierre Mesure Pierre Mesure verified-badge
08/12/2021 11:59
Edited
  • Get link Get link

@ahu, @lahdeero, I can't see a specific mention to the fields that are imported in your code. Do you think it could work if I added columns in my file with coordinates? Would your importer take them into account?

EDIT: I found this proposal creator here that does seem to imply that only specific fields are imported: https://github.com/mainio/decidim/blob/df123794a0c332b2eab53d0218a3298c275bf381/decidim-proposals/lib/decidim/proposals/proposals_creator.rb#L33

Add your comment

Sign in with your account or sign up to add your comment.

Loading comments ...

  • Terms and conditions of use
  • About the community
  • Download Open Data files
  • Metadecidim at Twitter Twitter
  • Metadecidim at Instagram Instagram
  • Metadecidim at YouTube YouTube
  • Metadecidim at GitHub GitHub
Creative Commons License Website made with free software.
Decidim Logo

Confirm

OK Cancel

Please sign in

decidim Sign in with Decidim
Or

Sign up

Forgot your password?