Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
sheet field is not appearing in the sheetnode content type
sheet field is not appearing in the sheetnode content type
Comments
Comment #1
apoc1 CreditAttribution: apoc1 commentedAny update on this?
Comment #2
infojunkie CreditAttribution: infojunkie commentedYes, 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 CreditAttribution: 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
infojunkie CreditAttribution: infojunkie commentedWow thanks binarydru - it's great to feel appreciated :-) I'm glad you find the module useful.
Comment #5
infojunkie CreditAttribution: infojunkie commentedPHPExcel integration now functional in 7.x-1.0-alpha2.
Comment #6
apoc1 CreditAttribution: 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 108
Comment #7
infojunkie CreditAttribution: infojunkie commented@apoc1 thanks for your feedback. Did you set the PHPExcel path at admin/config/system/sheetnode/phpexcel?
Comment #8
apoc1 CreditAttribution: 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
infojunkie CreditAttribution: infojunkie commentedIf 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 CreditAttribution: 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 2139
Comment #11
infojunkie CreditAttribution: infojunkie commentedThat'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 CreditAttribution: apoc1 commentedmy memory limit is at 128M at the moment, that should be enough I suppose?
Comment #13
infojunkie CreditAttribution: infojunkie commentedEnough 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?