An app to view and add notes to items from a CSV file
skapauan / csv-item-notes Goto Github PK
View Code? Open in Web Editor NEWAn app to view and add notes to items from a CSV file
License: MIT License
An app to view and add notes to items from a CSV file
License: MIT License
Sometimes when saving a file with the "only items having notes" option selected, it appears to include all items instead.
This is observed on at least two different Android devices, Pixel 3a and Asus Zenpad Z8.
Expected behavior: The saved file should have no items and/or a dialogue should warn that there are no notes fields.
Configure note fields to have at least one text field. Add notes to an item, then remove them. Save a file with the "only items having notes" option selected. The item is included in the file even though it no longer has notes.
Remaining TODOs in openFile.ts:
Since PapaParse can process TSV files, there is no reason not to allow TSV files to be opened and saved.
After a file is opened, the user should be able compose, save, and/or run a procedure to do certain basic processing, including:
Feedback was provided that the ability to add items would be very useful, as there may be one or two items that were missing in the original CSV, and it would be a pain to load a whole new CSV just to fix this.
Given the ability to add items, a user may also expect the ability to edit and remove items.
The app should be able to open a CSV file from a Google Drive link, assuming that file has public view permission.
If the file is not a CSV or does not have public view permission, then an appropriate error message should display.
The Google Drive link should be remembered in the text field in case the user wants to get updated data from the same link.
Feedback was given that there should be a more direct way to open a file. The procedure of placing the CSV file into the device filesystem, opening the app and going to the open file screen, and navigating the filesystem to get to the CSV file to open, is complicated for users.
There are two common methods to achieve this:
The second option seems more useful to the organization due to not requiring a server, and the flexibility to distribute the file via any kind of app (email, cloud storage, etc.)
A typical Android user might interpret the "Save As File" functionality as saving a persistent file on the device that can be found in the common filesystem, such as the Download folder.
However, "Save As File" only creates a temporary file and offers "View file" and "Share file" buttons to interact with it. The user would have to perform extra steps to create a persistent file (for example, viewing the file with Google Sheets and using that app to save a copy.) Many users would not interpret that this is the case, causing confusion and possibly accidental loss of data.
The following would be a better UI flow for Android:
Device: Asus Zenpad Z8, Android version 7.0
App version: v0.2.0-beta
Open the app for the first time, and attempt to open a CSV file. The loading bar shows progress, then after the loading bar is full, an error is displayed:
"Error loading file
Unknown Error"
Afterward, the intro screen is still displayed, indicating that the file was not opened successfully.
The following bugs are observed on iPad. Fixing these should be sufficient for basic iOS support.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.