Menu ▾ ▴

Tree [5d4b8a] master /
 History

HTTPS git://
HTTPS access

File Date Author Commit
 images 2021-08-09 Udbhav Gambhir Udbhav Gambhir [b28a6c] New Screenshots
 src 2021-08-07 Udbhav Gambhir Udbhav Gambhir [b952a7] Minor changes and version bump
 web 2021-08-07 Udbhav Gambhir Udbhav Gambhir [b952a7] Minor changes and version bump
 .gitignore 2021-08-01 Udbhav Gambhir Udbhav Gambhir [2b8f2f] final nits
 CHANGELOG.md 2019-09-11 unknown unknown [cd146c] Updated changelog
 CODE_OF_CONDUCT.md 2019-05-05 Udbhav Gambhir Udbhav Gambhir [404692] Create CODE_OF_CONDUCT.md
 LICENSE 2019-01-29 Udbhav Gambhir Udbhav Gambhir [f995fb] Initial commit
 README.md 2021-08-09 Udbhav Gambhir Udbhav Gambhir [5d4b8a] Update README.md
 new.nsi 2021-08-08 Udbhav Gambhir Udbhav Gambhir [101daf] windows build settings
 package-lock.json 2021-08-07 Udbhav Gambhir Udbhav Gambhir [b952a7] Minor changes and version bump
 package.json 2021-08-08 Udbhav Gambhir Udbhav Gambhir [2054fd] linux build

Read Me

TriCo-electron-app

Release
Dependencies
Downloads
Last-Release
Platforms

This App Converts your correctly formatted Excel Spreadsheet to a specified table/collection in specified Database in MYSQL/MongoDB.

Do checkout the upcoming features in CHANGELOG.md

Features

  1. Dump your excel/csv sheet into your preferred your DB.
  2. Batch Files support
  3. Do not want to dump the whole file? You can also try selecting a range of columns and rows.
  4. Automaticaly add id as primary key (MySQL)
  5. Scared of loosing your DB? Safe mode backs up the db before processing.
  6. Dump the excel sheet into a .sql instead (MySQL)
  7. History Maintainance.

mysql.png

mongo.png

Excel Formats Supported

Supported Excel formats are XLS/XLSX/CSV

Spreadsheet Format

Please have a look at the sample Excel sheets provided to have a clear view of the File. Microsoft Sample Sheet

Starting The App

sudo npm install -g electron
git clone https://github.com/ngudbhav/TriCo-electron-app.git
cd TriCo-electron-app
npm install
npm start

Installing The App

OS Installer? File
Windows 32-BIT Portable Portable-x86.exe
Windows 32-BIT Setup Setup-x86.exe
Windows 64-BIT Portable Portable-x86.exe
Windows 64-BIT Setup Setup-x86.exe
Linux ZIP TriCo-3.0.0-linux.zip
Linux Debian (Ubuntu, etc.) Setup TriCo_3.0.0_amd64.deb
Linux Redhat (Fedora, etc.) Setup TriCo-3.0.0.x86_64.rpm
Mac OS X ZIP TriCo-3.0.0-mac.zip
Mac OS X Setup TriCo-3.0.0.dmg

Softpedia


Electronjs Link

Do rate and give Feedback!

P.S. This app saves the previosuly entered information in the systems %APPDATA% directory so that the whole information is not typed again.
NOTHING is collected by me. Also, this app establishes connection to the internet to check for the updates.