INCATools/table-editor

Name: table-editor

Owner: INCATools

Description: Lightweight CSV/TSV editor that supports autocomplete and is guided by a DOSDP-aware YAML configuration.

Created: 2017-01-31 00:15:06.0

Updated: 2017-06-16 15:45:52.0

Pushed: 2017-12-11 20:06:35.0

Homepage: null

Size: 3146

Language: JavaScript

GitHub Committers

User	Most Recent Commit	# Commits

Other Committers

User	Email	Most Recent Commit	# Commits

README

table-editor

This lightweight web application is intended to be deployed as a static single-page website, where the site can then be used to view and edit spreadsheet-formatted data while supporting autocomplete and selection from semantically associated ontologies and dictionaries. Both TSV and CSV are supported, and are collectively referred to as XSV in the software and documentation.

The initial specification for this table-editor is drawn from https://github.com/INCATools/intelligent-concept-assistant/issues/2

Current Limitations

• Autocomplete is hardcoded to use the Monarch autocomplete server, rather than being dynamically parameterized via a URL parameter.
• Selecting a cell should pop up the autocomplete menu immediately, rather than requiring a character be typed.
• Currently, the suffix ' label' on a column indicates that it is non-editable and derived from the root column name (e.g., 'location label' is derived from 'location'). This heuristic should be replaced by guidance from the DOSDP YAML file.
• Some of the buttons and panels in the UI are to help debug this application, and not necessarily part of the final UI. For example, the display of the raw and parsed YAML is unnecessary.

Usage

Examples

The app has a few preloaded examples of YAML and CSV.

Load File or Drag-and-Drop

A local XSV file can be viewed through the app by using the 'Load File' button or by dragging and dropping a file onto the dropzone

Load URL

A remote XSV file can be loaded via URL.

Note that if the remote file is hosted on a website that does not support CORS, then the request will be rejected. Such files can be copied locally and then viewed that way, however.

The url parameter

The table-editor app is designed so that the URL pointing to the app can be amended with an optional url parameter that points to a XSV file, subject to the same restrictions as Load URL above. For example, suppose this app is hosted on https://github.com/INCATools/table-editor and a desired Table file is hosted on http://www.example.com/MyTableFile.gv. Then the following URL will launch the table-editor app and cause it to load and render the specified file:

https://github.com/INCATools/table-editor?url=http://www.example.com/MyTableFile.gv

Requirements to build

This is what I use, you may get lucky with slightly older/newer versions. Don't even bother trying Node 0.1x.

• NodeJS 4.5.0
• NPM 3.10.8

Requirements to run

Tested on MacOSX Safari, Chrome and FireFox. Requires some form of http-server. npm run dev will invoke the WebPack server for auto-bundling during development, and this is sufficient for demo purposes.

Building

able-editor/ # If you aren't alread there
install
run build    # 'npm run fastbuild' to avoid minification

Running

run dev
 http://localhost:8085/webpack-dev-server/table-editor # On MacOSX
ternatively, point your browser to:
http://localhost:8085/webpack-dev-server/table-editor

Sources

• Environmental Conditions
• UPHENO

Dependencies, Licenses, Credits

• Angular
• Bootstrap
• https://github.com/nodeca/js-yaml
• https://github.com/danialfarid/ng-file-upload
• https://github.com/mholt/PapaParse
• https://github.com/angular-ui/ui-grid