Integrating CSV Data with Drupal

In this episode of Talking Drupal, we dive into the intricacies of the Drupal marketplace initiative with our guest, Tiffany Farriss, CEO and co-owner of Palantir.net and long-time board member of the Drupal Association. We explore the goals and challenges of creating a trusted Drupal marketplace, discuss how site templates can lower the barrier to entry for new users, and examine the importance of maintaining community trust and the sustainability of Drupal. This episode also includes a spotlight on the Views CSV Source module and an in-depth discussion on community feedback, the potential value and business models for site templates, and the steps needed to make a go/no-go decision on the marketplace by the upcoming Vienna event.

For show notes visit: https://www.talkingDrupal.com/504

• Meet Our Guest: Tiffany Farriss
• Module of the Week: Views CSV Source
• Deep Dive into Views CSV Source
• Introduction to the Drupal Marketplace
• Goals and Challenges of the Marketplace Working Group
• Community Feedback and Sustainability
• Monetization and Fairness in the Marketplace
• Risk Mitigation and Future Plans
• Exploring the Impact of Releases and Usage
• Challenges and Successes of the Drupal Marketplace
• Defining the MVP for the Drupal Marketplace
• Addressing Community Concerns and Governance
• Engaging the Community and Next Steps
• Final Thoughts and Contact Information

Marketplace initiative

Tiffany Farriss - palantir.net farriss

Nic Laflin - nLighteneddevelopment.com nicxvan John Picozzi - epam.com johnpicozzi Norah Medlin - tekNorah

Martin Anderson-Clutz - mandclu.com mandclu

• Brief description:
  • Have you ever wanted to present data within your Drupal website that comes from a CSV flat file, without having to import that data to your Drupal database? There’s a module for that.
• Module name/project name:
  • Views CSV Source
• Brief history
  • How old: created in March 2024 by Daniel Cothran (andileco) of JSI, though I met Danieal at Midcamp earlier this week and he was emphatic that his colleague and co-maintainer Nia Kathoni (nikathone) deserves significant credit
  • Versions available: 1.0.11, which works with Drupal 8.8, 9, 10, and 11
• Maintainership
  • Actively maintained, latest release was last month
  • Security coverage
  • Test coverage
  • Documentation - a robust README
  • Number of open issues: 4 open issues, none of which are bugs
• Usage stats:
  • 56 sites
• Module features and usage
  • With Views CSV Source installed, you can create a view that uses a CSV as a source instead of the Drupal site’s data. You can point to a file within your site’s filesystem, or it can be a remotely hosted CSV. If the file requires authentication for access, it is also possible to include encoded credentials in a header.
  • Now you can use CSV Fields to specify the columns you want to pull into the view, and you can use the “group by” to specify datasets to represent, for example to plot as lines in a chart
  • You can also create filters, either a CSV Field that acts a standard text filter, or a CSV Field Options filter that creates a dropdown of all the unique values in a specified column
  • Your assembled data can be shown in tables or charts, and can also be manipulated using standard view configuration, or using contributed modules like Views Simple Math Field
  • The module also comes with sort and a contextual filter plugins
  • It was impressed by a demo of Views CSV Source in a lightning talk at Midcamp yesterday, so I thought it would be fun to talk about today