sheet field is not appearing in the sheetnode content type

Comments

apoc1’s picture

Any update on this?

infojunkie’s picture

Yes, 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.

binarydru’s picture

Thank 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.

infojunkie’s picture

Wow thanks binarydru - it's great to feel appreciated :-) I'm glad you find the module useful.

infojunkie’s picture

Version: 7.x-1.x-dev » 7.x-1.0-alpha2
Status: Active » Fixed

PHPExcel integration now functional in 7.x-1.0-alpha2.

apoc1’s picture

Hey, 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

infojunkie’s picture

@apoc1 thanks for your feedback. Did you set the PHPExcel path at admin/config/system/sheetnode/phpexcel?

apoc1’s picture

Hey , 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

infojunkie’s picture

If 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.

apoc1’s picture

Infojunkie, 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

infojunkie’s picture

That'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.

apoc1’s picture

my memory limit is at 128M at the moment, that should be enough I suppose?

infojunkie’s picture

Enough is relative :-) PHPExcel is a memory-hungry library.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

Rajeshreeputra’s picture

Component: XLS integration » Core
Issue summary: View changes
Issue tags: +sheet field is not appearing in the sheetnode content type

Getting 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.

Rajeshreeputra’s picture

Is there any initiatives to take this module upto Drupal 8?