Hi,

Was missing in the deployment directive.
Fixed in V3.4.2

i'm a noob so pls forgive me if this is too obvious..

i'm using deployment of 3.4.1

rexeh said he tested this release from GIT & works.

should i just upgrade to 3.4.2 to fix this issue?

is it only affecting xlsx? or also csv import?

i'm having some difficulty with both imports after reading the manual several times.

Hi,

Reported issue only concerns Import in XLSX format.
Import in CSV format works well.

You should migrated to last release : V3.4.3.
It may soon become new stable release.

upgraded to v3.4.3

tried your suggestion:
export activity table to csv
edit csv < add a new record without an id or reference
save as csv
import csv as activity

returns:
"invalid controls.."

reference attached screenshot image & csv file

Issue confirmed and recorded as ticket#1165.

Hi,

As a first workaround, replace caption "planning mode" with "idActivityPlanningMode".
Import will work.

Hi,

First fix : in /model/Importable.php, replace line 113

if ($subfld!='id' and substr($capt,0,1)!='[' ) {

with

if ($subfld!='id' and substr($capt,0,1)!='[' and ! isset($captionArray[$capt]) ) {

I still face strange behaviour : planning dates are not set at first insert, but are correctly set on update.
Still investigating before deploying a patch.

this worked for testing so far. we will be trying a very large import tomorrow morning. hope it works! :unsure:

V3.4.4 fixes this issue !
😉