| Project: | Sheetnode |
| Version: | 6.x-1.x-dev |
| Component: | Core |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
I've been pulling my hair a bit on this and hoping somebody can help me.
I'm pretty sure I have PHP / Java Bridge working and I can access and use http://localhost/sites/all/modules/sheetnode/socialcalc/ssctrltest1.html without apparent error. It was a beast to install however, quite a step away from my relatively clean LAMP system ... I couldn't find a dependable & appropriate .deb archive anywhere and so had to build this from scratch, I think I got it but there is no easy way to know for sure.
Firebug shows one error, but it seems to be a biggy :-) Drupal is not defined and the offending line is just below the Input Filter section as
<script language="javascript" type="text/javascript">
Drupal.behaviors.sheetnode = function(context) {
Drupal.sheetnode.start();
}
</script>All of the expected js files exist and except that this speaks about behaviors whereas your previous issues that seemed similar didn't, I think this shows a proper installation. EXCEPT that sheetnode_xls does not show up in the settings ... it can be enabled and disabled as a module but there is nothing in /admin/by-module once enabled and nowhere to set the POI directory. PHP Java Bridge module and setting is there and all is green in the status; Apache Poi is red with " Apache POI is NOT found: " and no extra text. BTW: sheetnode_ods behaves the same but I didn't install ODFDOM and so am not particularly concerned about that.
I've tried disabling and uninstalling all sheetnode modules but reenabling them has not made a difference. While I haven't tried the views integration, everything else seems a bust. I would really like to use this module, it would solve another problem for me very well, but I seem to be at an impasse. I'm sure it's pilot error but I'm not sure what I've done.
Comments
#1
It occurred to me as I was going through this that the "Drupal not defined" error was because I had changed my page.tpl.php (a long time ago) to put $scripts at the end of the file ... moving it back to the beginning showed the spreadsheet in the create node formso that mystery is solved however, I still don't have a sheetnode_xls setting and so can't do the import/export thing I'd so much like to do.
#2
Please try the dev release. Version 1.3 is pretty old so I'd rather help you with the latest one (where many issues were solved).
#3
Sure...I was trying to stay with what I thought was stable, however other than the fact that the spreadsheet has lost the "clipboard" tab, there is no noticeable difference with this version. Still no POI / Sheetnode_xls setting (and, of course, Apache POI complaint in /admin/reports/status) and still not getting the save to work. I think the preg_match error is because the save isn't working and so an "edit" has no data at all.
I've included a screenshot of the spreadsheet just to verify that it is displaying correctly, this is from /node/add/sheetnode
#4
Did you try going to admin/settings/sheetnode/xls explicitly? I found a problem that it doesn't show up as a link on the admin page, even though admin_menu.module (which I always use) displays it.
I will address the inability to save in your other issue.
#5
That worked, thanks, I should have thought of that... you probably know this but /admin/settings/sheetnode redirects to /admin/settings and there is no "sheetnode" nor "sheetnode XLS" listed there.