View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - 4.0.5 - XLSX Import error - Page 2 - ProjeQtOr
 
 

4.0.5 - XLSX Import error

More
16 Dec 2013 10:02 #7 by babynus
Replied by babynus on topic 4.0.5 - XLSX Import error
Hi,

File can be locked because of previous unsuccessfull import.
Try to move this file manually.

Then restart CRON and try another new import.
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
16 Dec 2013 11:32 #8 by TanCS
Replied by TanCS on topic 4.0.5 - XLSX Import error
Tested using clean installs and the imports were successful (please see the attached log).
Maybe there is a XLS reader bug not closing the file?

Even unsuccessful import, the program should close the file & move it the ERROR folder (according to ProjeQtOr.ppt slide #116).

Please Log in or Create an account to join the conversation.

More
16 Dec 2013 12:24 #9 by babynus
Replied by babynus on topic 4.0.5 - XLSX Import error

Even unsuccessful import, the program should close the file & move it the ERROR folder (according to ProjeQtOr.ppt slide #116).

Yes, but if the bug is the impossibility to move the file, this may be difficult.
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
17 Dec 2013 04:37 - 17 Dec 2013 04:39 #10 by TanCS
Replied by TanCS on topic 4.0.5 - XLSX Import error
Patched.
=== modified file external/XLSXReader/XLSXReader.php
--- external/XLSXReader/XLSXReader.php	2013-12-17 02:57:28 +0000
+++ external/XLSXReader/XLSXReader.php	2013-12-17 02:49:06 +0000
@@ -59,6 +59,10 @@
       return $data;
     }
   }
+  
+  public function closeDaFile(){
+	$this->zip->close();
+  }
  
   // extract the shared string and the list of sheets
   protected function parse() {

=== modified file model/Importable.php
--- model/Importable.php	2013-12-17 02:57:28 +0000
+++ model/Importable.php	2013-12-17 02:48:40 +0000
@@ -432,6 +432,7 @@
 		$xlsx = new XLSXReader($fileName);
 		$sheet1 = $xlsx->getSheet(1);
 		$data = $sheet1->getData();
+		$xlsx->closeDaFile();
 		return $data;
 	}
Last edit: 17 Dec 2013 04:39 by TanCS. Reason: use Code tag
The following user(s) said Thank You: babynus

Please Log in or Create an account to join the conversation.

More
17 Dec 2013 10:52 #11 by babynus
Replied by babynus on topic 4.0.5 - XLSX Import error
Great fix :woohoo:

Will be included in next version ;)

thanks for your contribution.
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.034 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form