Export Data to CSV and Excel 🚀

Export Data to CSV and Excel: Feedback and Collaboration Welcome! 🚀

We propose a feature that enables exporting data to CSV and Excel files directly within the DocumentDB for VS Code extension. Here’s what we envision and how you can contribute to shaping this capability.

---

Proposed Feature Overview

Export your data to CSV or Excel with flexible and user-friendly options. This feature is designed to enhance data workflows, catering to diverse user needs—whether managing complex NoSQL documents or traditional relational data.

Core Features

1. Export from Multiple Contexts

   • Export data from the tree view or query editor/collection view.
   • Tailor exports to suit your workflow, whether for specific resources or detailed query results.

2. Full vs. Filtered Data Export

   • Export entire datasets or specific query results.
   • Filter and refine exported data to match exact requirements.

3. Customizable File Output

   • Define file names, paths, and save locations to align with your organization system.

4. Data Preview Before Export

   • Preview your data to validate its accuracy before exporting.
   • Adjust configurations easily for precise results.

5. Field Selection

   • Choose which fields to include for full customization of the export.
   • Reduce noise by excluding unnecessary attributes.

6. Advanced Data Handling

   • Embedded Objects: Export as nested structures or flatten for simplicity.
   • Arrays: Expand into rows/columns or keep compact for analysis.
   • Custom Formatting: Apply rules for date, numeric, and text fields.

7. On-the-Fly Filtering

   • Add filters directly during export to refine results without modifying original queries.

---

We Need Your Feedback!

Discussion Areas

We aim to build this collaboratively, starting with the ideas outlined above. Your input can make this feature more robust and aligned with community needs.

Here are some specific ways you can contribute:

• Do you see additional use cases we haven’t covered?
• Are there specific challenges you face when exporting data that we should address?
• What’s your preferred handling for complex structures like arrays and nested objects?

Join the Conversation

Leave comments, suggestions, or additional feature requests directly in this issue. Every suggestion is valuable and will help shape the final implementation.

---

How It Will Work

1. Schema Discovery

   • A unified abstraction layer (SchemaScanner) will normalize schemas across SQL and NoSQL databases, simplifying export workflows.

2. Preview and Configuration

   • Users will preview data and toggle fields to customize outputs.
   • Flexible settings ensure usability across different database structures.

3. Export Process

   • Data will be generated into CSV or Excel formats based on user configurations.
   • Options for advanced filters, formatting, and output destinations will be included.

---

Draft Development Plan

1. Requirements Finalization

   • Confirm supported databases, workflows, and key scenarios.

2. Schema Abstraction

   • Implement SchemaScanner to unify relational and NoSQL schemas.
   • Build adapters for DocumentDB, MongoDB databases, SQL, and other databases.

3. Preview and Field Configuration

   • Develop an interactive UI with React and SlickGrid.
   • Enable users to configure exports dynamically.

4. Data Export Logic

   • Build functionality for CSV/Excel generation.
   • Address nested and hierarchical data structures.

5. User Experience Enhancements

   • Add tooltips, validation, and performance optimization for smooth usage.

---

What’s Next?

This is just the starting point. We anticipate multiple iterations based on your feedback. Each iteration will refine functionality, ensuring it meets community needs and delivers a reliable user experience.

We look forward to hearing your thoughts! Let’s work together to create a flexible export feature for the DocumentDB for VS Code extension. 🌟