Closed (fixed)
Project:
Sheetnode
Version:
7.x-1.0-alpha2
Component:
Core
Priority:
Normal
Category:
Task
Assigned:
Reporter:
Created:
25 Mar 2012 at 22:29 UTC
Updated:
29 Aug 2017 at 10:08 UTC
Jump to comment: Most recent
sheet field is not appearing in the sheetnode content type
Comments
Comment #1
apoc1 commentedAny update on this?
Comment #2
infojunkieYes, I committed a number of fixes yesterday towards this issue, but it's still pre-alpha quality. I'll make an alpha2 release within the next couple of days. If you're feeling adventurous, feel free to try the latest 7.x-1-x-dev.
Comment #3
binarydru commentedThank you infojunkie for continuing to work on this! This is one of my favorite modules and one of the reasons Drupal is so awesome. I love your module so much I am going to Amazon now to buy something for you from your wishlist :-). I encourage everyone else using this module to do the same. People do not realize how much work is needed to write and support a module like this.
Comment #4
infojunkieWow thanks binarydru - it's great to feel appreciated :-) I'm glad you find the module useful.
Comment #5
infojunkiePHPExcel integration now functional in 7.x-1.0-alpha2.
Comment #6
apoc1 commentedHey, thanks for the update. Though, I'm getting an error when uploading a xls of xlsx spreadsheet. For a moment, you see the loading bar, followed with this error:
AJAX HTTP error occured. HTTP-resultcode: 200 Debug information. Path: /platform/batch?render=overlay&id=57&op=do Statustekst: OK Answertext: Fatal error: Class 'PHPExcel_IOFactory' not found in /home/deb53805/domains/hethavenhuis.be/public_html/platform/sites/all/modules/sheetnode/modules/sheetnode_phpexcel/sheetnode_phpexcel.import.inc on line 108Comment #7
infojunkie@apoc1 thanks for your feedback. Did you set the PHPExcel path at admin/config/system/sheetnode/phpexcel?
Comment #8
apoc1 commentedHey , I did config it, and now it works well. The download succeeds but the imported file looks nothing like the original. This is what I get
http://i39.tinypic.com/28t95b5.png
Comment #9
infojunkieIf you want to attach your original file, I can test it. But please open a new issue for it.Yes, I fixed that bug in the latest dev (after the alpha2 release). Please try it.
Comment #10
apoc1 commentedInfojunkie, thanks for your great support.
Everything is working as it should.Thumbs up!UPDATE: I'm testing the module around a bit now and got onto a new bug. Importing smaller xls or xlsx files (- 50kb) give no problems, but when you're trying to import an excel-file which has some more advanced calculations or multiple sheets, I get an error like this:
{"status":true,"percentage":"0","message":"Imported 0 out of 1 files.\u003Cbr \/\u003ENow processing sheet \u003Cem class=\u0022placeholder\u0022\u003Ejanuari\u003C\/em\u003E."} Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 19641681 bytes) in .../includes/database/database.inc on line 2139Comment #11
infojunkieThat's expected. You should increase your memory limit and expect that not all sheets will be easily importable.
In any case, if there are sheets that you *need* to import, you can open up new issues for them, and I am always happy to make the import code more robust and more efficient. The only way for me to do so is using real-world sheets.
Comment #12
apoc1 commentedmy memory limit is at 128M at the moment, that should be enough I suppose?
Comment #13
infojunkieEnough is relative :-) PHPExcel is a memory-hungry library.
Comment #15
rajeshreeputraGetting error @ sheetnode configuration and phpexcel path setup (The path you entered does not point to a valid location. Please enter the location of the extracted CKEditor package.) path is : sites/all/modules/sheetnode/modules/sheetnode_ckeditor/ckeditor.
sheet node field is not available on the sheetnode content type.
Comment #16
rajeshreeputraIs there any initiatives to take this module upto Drupal 8?