aarong
March 21, 2023, 2:40pm
1
Hi All,
I have been following these threads
This is a follow on from [Best way forward:
I’ve hit a wall and it seems I’m bugging a person a little to much @hmwillett (Sorry)
I can get it to create a row after it calls the function by using
It creates the row:
My parameters of row-add
DataView: SerialNumberSelection
{
"Company": "{callContextClient.CurrentCompany}",
"SerialNumber": "{FuncDS.Col0}",
"Scraped": false,
"Voided": false,
"PartNum": "{SNFormat.PartNum}",
"SNPrefix": "",
"SNBaseNumber":"{FuncDS.Col0}",
"SourceRowID": "00000000-0000-0000-0000-000000000000",
"TransType": "PUR-STK",
"PassedInspection": false,
"Deselected": true,
"RawSerialNum": "{FuncDS.Col0}",
"KBLbrAction": 0,
"PreventDeselect": false,
"PreDeselected": true,
"NotSavedToDB": true,
"SysRowID": "00000000-0000-0000-0000-000000000000",
"RowMod": "A"
}
I have tried changing up the value names from FuncDS to CSVRows etc - This is the only difference.
I have a CSV with x3000 lines of serial numbers and I can only make it add one. I am aware there is a foreach loop of condition-dataview but I can’t seem to get this to work correctly.
Is someone a bit more hands on than myself with Kinetic able to support me? Obviously not @hmwillett - I’ve annoyed her enough already.
Thanks
klincecum
March 21, 2023, 2:50pm
2
I’m pretty sure that will have to come into play soon.
Lets see a snippet of the dataview that comes back from your function.
klincecum
March 21, 2023, 2:51pm
3
Also, please create a row manually, and lets see that dataview.
aarong
March 21, 2023, 2:57pm
4
{
"OutDS": {
"CSVRows": [
{
"Col0": "TEST9991"
},
{
"Col0": "TEST9992"
}
]
}
}
klincecum
March 21, 2023, 2:59pm
5
Show the eventnext properties, and the row-add properties
aarong
March 21, 2023, 3:01pm
6
{
"Company": "{CallContextClientData.CurrentCompany}",
"SerialNumber": "{CSVRows.Col0}",
"Scraped": false,
"Voided": false,
"PartNum": "{SNFormat.PartNum}",
"SNPrefix": "",
"SNBaseNumber":"{CSVRows.Col0}",
"SourceRowID": "00000000-0000-0000-0000-000000000000",
"TransType": "PUR-STK",
"PassedInspection": false,
"Deselected": true,
"RawSerialNum": "{CSVRows.Col0}",
"KBLbrAction": 0,
"PreventDeselect": false,
"PreDeselected": true,
"NotSavedToDB": true,
"SysRowID": "00000000-0000-0000-0000-000000000000",
"RowMod": "A"
}
klincecum
March 21, 2023, 3:06pm
8
Tried OutDS.CSVRows.Col0 ?
klincecum
March 21, 2023, 3:09pm
9
aarong:
You’ve got errors further up the chain, need to backup and fix before we start screwing with rows.
Show how you have that erp-function set up.
aarong
March 21, 2023, 3:12pm
10
Those errors are normal according to @hmwillett
aarong
March 21, 2023, 3:35pm
15
{
"CSVRows": [
{
"Col0": "100001"
},
{
"Col0": "100002"
},
{
"Col0": "100003"
},
{
"Col0": "100004"
},
{
"Col0": "100005"
},
{
"Col0": "100006"
},
{
"Col0": "100007"
},
{
"Col0": "100008"
},
{
"Col0": "100009"
},
{
"Col0": "100010"
},
{
"Col0": "100011"
},
{
"Col0": "100012"
},
{
"Col0": "100013"
},
{
"Col0": "100014"
},
{
"Col0": "100015"
},
{
"Col0": "100016"
},
{
"Col0": "100017"
},
{
"Col0": "100018"
},
{
"Col0": "100019"
},
{
"Col0": "100020"
}
]
}
klincecum
March 21, 2023, 3:38pm
16
No, the properties of the erp-function widget. In app studio.
hmwillett
March 21, 2023, 3:46pm
18
aarong:
Those errors are normal
Not normal per say, but they will show up whether your stuff is working or not. They can be a red herring and are to be ignored. I’ve never had to do anything with those errors.
1 Like
aarong
March 21, 2023, 3:47pm
19
I’m been sitting here since 7:30am…
It still isn’t working
klincecum
March 21, 2023, 3:50pm
20
aarong:
image400×511 4.96 KB
The problem is a disconnect with this, and the reference to it in the row-add.
I don’t mess with it enough, so I can’t put my finger on it, but something here is wrong.
