View ProjeQtOr On SourceForge.net
ProjeQtOr free project management software - Difficulty to import project update - ProjeQtOr
 

Difficulty to import project update

More
26 Aug 2020 17:43 #1 by dopol
Hi,
I try to update a unique field in project elements. I prepare a csv and xlsx file with only 2 columns : Id and contractCode. As I try to import, an error is raised.



I try to import an update file in csv or xlsx with the same results :

My csv file edited with npp:
id;contractCode;
48;"100000";
17;"25000";
74;"25000";
54;"15000";
...

The Log lines corresponding :
2020-08-26 17:33:35.462 ***** ERROR ***** [V8.5.3] ERROR *****
2020-08-26 17:33:35.470 ***** ERROR ***** [V8.5.3] on file 'C:\inetpub\wwwroot\projeqtor\external\XLSXReader\XLSXReader.php' at line (256)
2020-08-26 17:33:35.476 ***** ERROR ***** [V8.5.3] cause = Array and string offset access syntax with curly braces is deprecated

Should I look for a problem on the server or the file is not correctly constructed ?

configuration : Windows Server 2016, IIS-fastcgi, PHP 7.4.8, postgresql 12, projeqtor 8.5.3

Thanks for your help
Attachments:

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

More
28 Aug 2020 17:23 #2 by babynus
Just remove the extra unexpeted ";" at the end of each line.

Babynus
Administrator of ProjeQtOr web site

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

More
28 Aug 2020 18:20 - 31 Aug 2020 17:55 #3 by dopol
Hi, thanks for your answer,
But I had already tested without the ending semicolon. After my first unsucessful tries (xlsx, csv), I added the semicolon after I looked at the format of the csv exported in tabular screen.

After the modifications, I have the exact same error raised :
2020-08-28 17:59:02.429 ***** ERROR ***** [V8.5.3] ERROR *****
2020-08-28 17:59:02.437 ***** ERROR ***** [V8.5.3] on file 'C:\inetpub\wwwroot\projeqtor\external\XLSXReader\XLSXReader.php' at line (256)
2020-08-28 17:59:02.443 ***** ERROR ***** [V8.5.3] cause = Array and string offset access syntax with curly braces is deprecated

As php raised a deprecation alert, I was wondering if it could be the installation on the server with an encoding problem ? or the use of php 7.4 ?

What I have found concerning 7.4 and this deprecation :
https://www.php.net/manual/en/migration74.deprecated.php



Could it be such files in PHPoffice ?



Thanks.
Attachments:
Last edit: 31 Aug 2020 17:55 by dopol.

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

More
03 Sep 2020 07:55 #4 by ashofphoenix
hint :
give a try to real "Coma Separated Value" without curly braces ? just separate your colum with a ',' and don't use any curly braces ' " ' .

'cause as it said,

dopol wrote:

2020-08-26 17:33:35.476 ***** ERROR ***** [V8.5.3] cause = Array and string offset access syntax with curly braces is deprecated

Thanks for your help

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

More
03 Sep 2020 09:03 #5 by dopol
I have also tried with comma with same results.
the curly brase caracters are { and } ;-)

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

More
03 Sep 2020 09:21 - 03 Sep 2020 09:21 #6 by dopol
Hi,
I manage to mount a VM with ubuntu / apache/php 4.3/posgresql12/projeqtor8.5.3.
I have no problem with the import of the file.

The file which raise the exception and deprecation issue ,(projeqtor\external\XLSXReader\XLSXReader.php) has this 256 line:


Should be :
$index += (ord($col[$i]) - 64) * pow(26, $colLen-$i-1);

I don't understand the error on my production server (windows/IIS/PHP/...) and not in my VM, as I use the same import file. Could it be that php is tweaked in ubuntu package to accept this deprecation ?
Attachments:
Last edit: 03 Sep 2020 09:21 by dopol.

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

Moderators: babynusprotion
Time to create page: 0.047 seconds