Why my configuration's label variable displays %connection_number% instead of the actual number.

[Clint-Bai]

here is my config

for comments and # for configuration. Paste CSV below.

label: %hostname%

style: shape=%shape%;strokeColor=#5073;verticalLabelPosition=bottom;verticalAlign=top;align=center;aspect=fixed;

namespace: csvimport-

connect: {"from":"remote","to":"local","invert":false,"label":"%connection_number%","style":"curved=1;endArrow=none;endFill=0;dashed=0;strokeColor=#E50B0B;"}

width: 50

height: 50

ignore: local,shape,remote,connection_number

nodespacing: 50

levelspacing: 10

edgespacing: 10

layout: auto

CSV data starts below this line

local,hostname,shape,remote,connection_number
device 01,device 01,"mxgraph.cisco19.rect;prIcon=fabric_interconnect;fillColor=#FAFAFA;strokeColor=#5073","device 02,device 04","6,4"
device 02,device 02,"mxgraph.cisco19.rect;prIcon=fabric_interconnect;fillColor=#F0F0F0;strokeColor=#5073","device 03",4
device 03,device 03,"mxgraph.cisco19.rect;prIcon=fabric_interconnect;fillColor=#E6F0F6;strokeColor=#5073","device 01",6
device 04,device 04,"mxgraph.cisco19.rect;prIcon=fabric_interconnect;fillColor=#FBFBFB;strokeColor=#5073","device 05",
device 05,device 05,"mxgraph.cisco19.rect;prIcon=fabric_interconnect;fillColor=#EAEAFA;strokeColor=#5073",,

[0trm]

The connect label is plain text; placeholders are not replaced in it. Use sourcelabel instead, which fills %...% from the connector's source row (targetlabel does the same from the target row):

# connect: {"from":"remote","to":"local","sourcelabel":"%connection_number%","style":"curved=1;endArrow=none;endFill=0;dashed=0;strokeColor=#E50B0B;"}

Keeping connection_number in ignore is fine: ignored columns are removed only after the connectors are built.

One catch with your data: device 01 has two remotes but one connection_number cell, so both of its connectors get the label 6,4. The value list is not split per target. Give the second connection its own columns and a second connect line (multiple are allowed):

# connect: {"from":"remote","to":"local","sourcelabel":"%connection_number%","style":"curved=1;endArrow=none;endFill=0;dashed=0;strokeColor=#E50B0B;"}
# connect: {"from":"remote2","to":"local","sourcelabel":"%connection_number2%","style":"curved=1;endArrow=none;endFill=0;dashed=0;strokeColor=#E50B0B;"}
# ignore: local,shape,remote,connection_number,remote2,connection_number2
local,hostname,shape,remote,connection_number,remote2,connection_number2
device 01,device 01,"mxgraph.cisco19.rect;prIcon=fabric_interconnect;fillColor=#FAFAFA;strokeColor=#005073",device 02,6,device 04,4
device 02,device 02,"mxgraph.cisco19.rect;prIcon=fabric_interconnect;fillColor=#F0F0F0;strokeColor=#005073",device 03,4,,

That gives 01→02 6, 01→04 4, 02→03 4, 03→01 6 (checked on 31.6.1). The options are described in the CSV example's comments (Editor.js); the label handling is in importCsv.