importer for your xlsx to parse into mongodb
MIT License
CLI for importing xlsx documents into mongodb or into straight json obj. Also you can run xlsx reports based on your db collections. You can create data from scratch and create custom schemas.
Try it out and let us know your thoughts
$ npm i -g mongoose-xlsx-data-importer
mongoose-xlsx-data-importer $ MXDI
? What do you want to do? (Use arrow keys)
❯ Parse XLSX Data to File
Parse XLSX Data to Mongoose
Export Mongoose Collection to XLSX
Check Mongo Connection
Check Path
Exit
How to write your excel files
//NOTE the TAB name is the key to the Mongoose Model Name
people,1_name = {people:[{name:'jason'}]}
firstname = {firstname:'jason'}
name.first = {name:{first:'jason'}}
Gotchas
Capitalization - you must keep it consist
Schemas - you must create the schema with all fields if you wish to save all of the data
MLab - Yes you can connect to other servers just make sure your uri is absolutely correct & test with the check connection feature first
Custom Schema - We recommend just leaving the default value null but cause he have noticed odd scenarios with doing anything else
Xlsx tab names - properly name those as the schema names
N/A
Express Middleware
Frontend Gui
Create and save schema files
Refactor
Update with Standard JS
The MIT License (MIT)
Copyright (c) 2014-2015 Green Pioneer
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Support and contributions from the open source community are essential for keeping Mean Stack JS up to date. We are always looking for the quality contributions and will be happy to accept your Pull Requests as long as those adhere to some basic rules:
Before you create a new Issue:
standard
to verify your style - npm install -g standard
if you dont have it already