search

ethersheet-collective / EtherSheet

Online spreadsheet collaboration in real time using node.js. Similar to etherpad-lite but its a spreadsheet!
https://ethersheet.org
BSD 2-Clause "Simplified" License
198 stars 24 forks source link

CSV Import does not work for 'large' files #8

Closed cooperq closed 10 years ago

cooperq commented 10 years ago

Files of more than a few lines break csv importing.

cooperq commented 10 years ago

Fixed in f88c94ac4e89103d4f35c0734d45a4c41aef2b67

matthieuroussel commented 10 years ago

Hello, I have a csv import issue, maybe you can help :

npm ERR! ethersheet@0.0.5 start: node app.js npm ERR! Exit status 8 npm ERR! npm ERR! Failed at the ethersheet@0.0.5 start script. npm ERR! This is most likely a problem with the ethersheet package, npm ERR! not with npm itself. npm ERR! Tell the author that this fails on your system: npm ERR! node app.js npm ERR! You can get their info via: npm ERR! npm owner ls ethersheet npm ERR! There is likely additional logging output above. npm ERR! System Linux 3.10.23-xxxx-std-ipv6-64 npm ERR! command "/usr/bin/node" "/usr/bin/npm" "start" npm ERR! cwd ~/EtherSheet npm ERR! node -v v0.10.32 npm ERR! npm -v 1.4.28 npm ERR! code ELIFECYCLE npm ERR! npm ERR! Additional logging details can be found in: npm ERR! ~/EtherSheet/npm-debug.log npm ERR! not ok code 0

Also, I was wondering if I could copy (I did not do it) my ether pad config for ether sheet (changing just the port) so I could have https set the same convenient way as it is in ether pad.

Thanks

cooperq commented 10 years ago

You can not copy your etherpad config unfortuantely. The only thing that etherpad and ethersheet share is a name prefix. As for the problem importing a CSV, would you be willing to send me a copy? Or try it out on the ethersheet.org website and tell me what happens?

matthieuroussel commented 10 years ago

It works fine on ethersheet website. I don't know well how to fix this.

cooperq commented 10 years ago

I think the fix for this is to update ethersheet. You can get the latest version here: https://ethersheet.org/releases/ethersheet_latest.tgz Just unpack that and then run install.sh

I would reccomend backing up your current installation first, just in case something goes wrong.

matthieuroussel commented 10 years ago

So I did what you said and that is what I have after I "npm start"

/home/mroussel/EtherSheet/lib/server.js:37 if(err) throw err; ^ Error: Access denied for user 'ethersheet'@'localhost' (using password: YES) at Function.Client._packetToUserObject (/home/mroussel/EtherSheet/node_modules/ueberDB/node_modules/mysql/lib/client.js:387:11) at Client._handlePacket (/home/mroussel/EtherSheet/node_modules/ueberDB/node_modules/mysql/lib/client.js:300:43) at Parser.emit (events.js:95:17) at emitPacket (/home/mroussel/EtherSheet/node_modules/ueberDB/node_modules/mysql/lib/parser.js:71:14) at Parser.write (/home/mroussel/EtherSheet/node_modules/ueberDB/node_modules/mysql/lib/parser.js:576:7) at Socket.emit (events.js:95:17) at Socket. (_streamreadable.js:764:14) at Socket.emit (events.js:92:17) at emitReadable (_stream_readable.js:426:10) at emitReadable (_stream_readable.js:422:5)

npm ERR! ethersheet@0.0.5 start: node app.js npm ERR! Exit status 8 npm ERR! npm ERR! Failed at the ethersheet@0.0.5 start script. npm ERR! This is most likely a problem with the ethersheet package, npm ERR! not with npm itself. npm ERR! Tell the author that this fails on your system: npm ERR! node app.js npm ERR! You can get their info via: npm ERR! npm owner ls ethersheet npm ERR! There is likely additional logging output above. npm ERR! System Linux 3.10.23-xxxx-std-ipv6-64 npm ERR! command "/usr/bin/node" "/usr/bin/npm" "start" npm ERR! cwd /home/mroussel/EtherSheet npm ERR! node -v v0.10.32 npm ERR! npm -v 1.4.28 npm ERR! code ELIFECYCLE npm ERR! npm ERR! Additional logging details can be found in: npm ERR! /home/mroussel/EtherSheet/npm-debug.log npm ERR! not ok code 0

cooperq commented 10 years ago

Looks like it is having trouble connecting to your mysql server. Make sure that mysql is running and you have the right username and password in config.js

cooperq commented 10 years ago

@matthieuroussel I found a bug in the release script for that version of ethersheet. Please re-download the tarball from https://ethersheet.org/releases/ethersheet_latest.tgz It should work now.