msb-public
/
app-ideas
mirror of https://github.com/florinpop17/app-ideas
2
1
Code Issues Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'this-that'
${ noResults }
app-ideas/Projects/JSON2CSV-App.md

2.6 KiB
Raw Permalink Blame History

JSON2CSV

Tier: 1-Beginner

Developers and end users are both experts in their own domains and as such, each speaks using a domain-specific language and terminology. This also extends to the tools used to manipulate data. Developers have found JSON to be a universally accepted method for transferring data between applications. End Users, on the other hand, rely on spreadsheets to organize and analyze data.

The objective of JSON2CSV is to help bridge the gap between JSON and CSV by converting JSON to CSV to make it easier to review data in a spreadsheet. It allows the user to paste JSON into a text box to generate its equivalent CSV.

Constraints

  • You may not use any libraries or packages designed to perform this type of conversion.
  • If you choose to implement this in JavaScript don't use complicated looping in your first implementation. Instead, use Object.keys() and Object.values to generate CSV for the header and data rows.
  • Nested JSON structures are not supported.

User Stories

  • User can paste JSON syntax into a text box
  • User can click a 'Convert' button to validate the JSON text box and convert it to CSV
  • User can see the converted CSV in another text box
  • User can see an warning message if the JSON text box is empty or if it doesn't contain valid JSON
  • User can click a 'Clear' button to clear the contents of both the JSON and CSV text boxes.

Bonus features

  • User can enter the path to the JSON file on the local file system in a text box
  • User can click a 'Open' button to load file containing the JSON into the text box
  • User can see a warning message if the JSON file is not found
  • User can enter the path the CSV file is to be saved to in a text box
  • User can click a 'Save' button to save the CSV file to the local file system
  • User can see a warning message if the CSV text box is empty or if the save operation failed.
  • User can convert CSV data to JSON. See CSV2JSON

Useful links and resources

Example projects

Try to complete your JSON2CSV implementation before reviewing the example project(s).