Difficulty to import project update

dopol
Topic Author
Offline
New Member

26 Aug 2020 17:43 #1 by dopol

Difficulty to import project update was created 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

The topic has been locked.

babynus
Offline
Administrator
Moderator

28 Aug 2020 17:23 #2 by babynus

Replied by babynus on topic Difficulty to import project update

Just remove the extra unexpeted ";" at the end of each line.

Babynus
Administrator of ProjeQtOr web site

The topic has been locked.

dopol
Topic Author
Offline
New Member

28 Aug 2020 18:20 - 31 Aug 2020 17:55 #3 by dopol

Replied by dopol on topic Difficulty to import project update

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 :
www.php.net/manual/en/migration74.deprecated.php

Could it be such files in PHPoffice ?

Thanks.

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

The topic has been locked.

ashofphoenix
Offline
Premium Member

03 Sep 2020 07:55 #4 by ashofphoenix

Replied by ashofphoenix on topic Difficulty to import project update

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

The topic has been locked.

dopol
Topic Author
Offline
New Member

03 Sep 2020 09:03 #5 by dopol

Replied by dopol on topic Difficulty to import project update

I have also tried with comma with same results.
the curly brase caracters are { and } ;-)

The topic has been locked.

dopol
Topic Author
Offline
New Member

03 Sep 2020 09:21 - 03 Sep 2020 09:21 #6 by dopol

Replied by dopol on topic Difficulty to import project update

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 ?

Last edit: 03 Sep 2020 09:21 by dopol.

The topic has been locked.

Moderators: babynus, protion

Time to create page: 0.077 seconds

Difficulty to import project update

Attachments:

Attachments:

Attachments:

Cookies settings

Functional Cookies

Session

Other cookies

Difficulty to import project update

Attachments:

Attachments:

Attachments:

Cookies settings

Functional Cookies

Session

Other cookies

Login Form