This looked promising but, the javascript version of SocialCalc doesn't seem to be available anymore. My attempt to visit SocialCalc.Org lead me to http://www.socialtext.com/ which is a commercial enterprise.

Is SocialCalc available as a download?

Comments

infojunkie’s picture

infojunkie
Location Vancouver
commented

If you follow the installation instructions on the module page, you should not encounter problems (AFAIK). Or if you did so, which step did not work for you?

mcfilms’s picture

mcfilms commented

Step #2 gets me:
* Pull the SocialCalc code from the SVN repo (revision 65 is one that works well for now):
$ svn co -r 65 https://repo.socialtext.net:8999/svn/socialcalc/trunk socialcalc

I have never used a SVN client on my Mac. However, I was able to go to https://repo.socialtext.net:8999/svn/socialcalc/trunk
and pull each file down and put it in a directory called socialcalc. I even downloaded the .xo archive and moved the image folder from that to my socialcalc folder.

I then moved the socialcalc folder into the sheetnode folder and uploaded into sites/all/modules. In my D6 admin I enabled the sheetnode module and got a page full of errors. The primary one being the chunk was too large for the database. I panicked and turned the module off. I know enough to know that I don't know enough.

But out of curiosity, where might I have gone wrong? Was it the manner I downloaded the svn? Or was it that I didn't apply any patches? Or was it where I put socialcalc? Or was it that I didn't add any of the Java capabilities? I didn't think I needed them, since I'm not importing exporting XLS.

I have a spreadsheet I'd like to try out as a node. I'd love for it to do simple math (adding cells basically). But I think I'm over my head. I'll probably have to use a table and do the adding offline for now.

mcfilms’s picture

mcfilms commented

Uh-Oh...

Even though I have disabled the module, I continue to get the error...

Warning: Got a packet bigger than 'max_allowed_packet' bytes query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:1532609:\"Got a packet bigger than 'max_allowed_packet' bytes\nquery: UPDATE cache_menu SET data = 'a:929:{s:12:\\"image_attach\\";a:26:{s:5:\\"title\\";s:21:\\"Image attachment view\\";s:13:\\"page callback\\";s:23:\\"image_attach_view_image\\";s:16:\\"access arguments\\";a:1:{i:0;s:14:\\"access content\\";}s:4:\\"type\\";i:4;s:6:\\"module\\";s:12:\\"image_attach\\";s:14:\\"load_functions\\";s:0:\\"\\";s:16:\\& in /home/ringlead/public_html/includes/database.mysql.inc on line 128

This can't be good.

infojunkie’s picture

infojunkie
Location Vancouver
commented

You need to clear your logs. Unfortunately, Drupal 6 doesn't give a way to do this through the UI.

WARNING: the following contains dangerous instructions that might cause you to lose data. Proceed with caution and at your own risk.

If you're using MAMP, open up phpMyAdmin that is installed by default, find the database of your Drupal 6 installation, and then find the table called "watchdog". Once you have that table in the main view of phpMyAdmin, you should find a red tab called "Empty". Clicking this tab will empty your logs.

infojunkie’s picture

infojunkie
Location Vancouver
commented
Status: Active » Closed (fixed)

Closed unless I hear back from the poster.

mcfilms’s picture

mcfilms commented

Yes might as well close it. I gave up on the idea of using a SheetNode for now.

Two things that might be done if one wanted people to USE SheetNode and/or socialcalc in Drupal

1. Provide a way to download the best, correct, patched, working version of the SocialCalc. The link recommended by Sheetnode:
https://repo.socialtext.net:8999/svn/socialcalc/trunk/
Leads to a long list of files. Do you need all of them? some of them? Who knows?

2. If there is absolutely no way to provide SocialCalc properly configured as a download, perhaps consider a simpler module that is stand-alone. Or if SocialCalc is absolutely required, its installation should be documented in a much more detailed manner. I had questions above go unanswered.

I realize I am using open-source software and I didn't pay anything to make such demands. However, if the goal is to get people to USE this module, I think a little more user handholding is needed. (at least in my case).

infojunkie’s picture

infojunkie
Location Vancouver
commented

1. The instructions in sheetnode clearly indicate what you should do to pull SocialCalc from SVN. Why try to second-guess these instructions? Do you actually care which files are required or not? As far as you're concerned: they are all needed.

2. I don't know what you mean by "simpler module". Developing the equivalent of SocialCalc would take months, and the whole point of open source is to reuse existing components.

To sum up, I don't think you had your expectations right. As is explicitly mentioned on the sheetnode page, installation of this module is not easy. And the fact that there is no official release of the module, only dev releases, also indicates that this module is not ready for production. So unless you were ready to get your hands a little dirty with assembling the components, you shouldn't have bothered with this module.