Kinetic - Looping through rows - SelectSerialNumbersEntry

Kinetic ERP
,
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

image

image
image723×290 14.2 KB

It creates the row:

image
image893×192 3.05 KB

My parameters of row-add

DataView: SerialNumberSelection
Values:

{
    "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.

image
image855×101 2.73 KB

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
Aaron.

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.

3

Also, please create a row manually, and lets see that dataview.

4 
{
  "OutDS": {
    "CSVRows": [
      {
        "Col0": "TEST9991"
      },
      {
        "Col0": "TEST9992"
      }
    ]
  }
}
5

Show the eventnext properties, and the row-add properties

6

image

{
    "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"
}
7

image
image519×690 32.5 KB

8

Tried OutDS.CSVRows.Col0 ?

9

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.

10

Those errors are normal according to @hmwillett

11

image
image843×217 4.23 KB

12

Show me anyway.

13

It’s above in yellow :smiley:

14

The properties dummy.

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"
        }
    ]
}
16

No, the properties of the erp-function widget. In app studio.

17

My bad :smiley:

image
image400×511 4.96 KB

image
image396×583 7.18 KB

image

18

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
19

I’m been sitting here since 7:30am…

It still isn’t working

God Damn It Ryan Reynolds GIF - God Damn It Ryan Reynolds Michael Bryce - Discover & Share GIFs

20

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.