# Trying simple dataset add, having script probelms **URL:** \ **Category:** Ignition\ **Tags:** ignition81\ **Created:** [January 16, 2024, 4:48pm UTC](https://forum.inductiveautomation.com/t/trying-simple-dataset-add-having-script-probelms/84330 "2024-01-16T16:48:46Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Barbara\_Frumas](https://avatars.discourse-cdn.com/v4/letter/b/94ad74/32.png) [@Barbara\_Frumas](https://forum.inductiveautomation.com/u/Barbara_Frumas)\ **Post date:** [January 16, 2024, 4:48pm UTC](https://forum.inductiveautomation.com/t/trying-simple-dataset-add-having-script-probelms/84330/1 "2024-01-16T16:48:46Z")
So one window, one text input, one drop down, and a timestamp. here is my code below: ```auto ds = system.tag.read("[default]MyData").value numbers = event.source.parent.getComponent('Text Field').text dropselect = event.source.parent.getComponent('Dropdown').selectedLabel newVal = ["numbers", "dropselect"] system.tag.write("[default]MyData", system.dataset.setValue(ds, row, col, newVal)) # below is alternate ending, neither worked. ds.data = system.dataset.addRow(ds.data, 0, newVal) ``` thanks in advance dataset has one extra column for timestamp. ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [January 16, 2024, 4:58pm UTC](https://forum.inductiveautomation.com/t/trying-simple-dataset-add-having-script-probelms/84330/2 "2024-01-16T16:58:26Z")
Why are you trying to put a list (two values) into one specific cell of a dataset? ---
**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Post date:** [January 16, 2024, 4:59pm UTC](https://forum.inductiveautomation.com/t/trying-simple-dataset-add-having-script-probelms/84330/3 "2024-01-16T16:59:02Z")
Some general tips when trouble shooting and asking for help on forums: - reduce the example to the minimum. Don't introduce things that have nothing to do with the problem you're trying to solve: text fields, dropdowns... etc. Especially when you're not using them (`numbers` and `dropselect`) - include the whole thing. You're using variables that are not declared in the code you posted (`row` and `col`) - deconstruct the process and check things at every step. - explain what you actually want to do. All we have to figure it out here is your code, which is not very descriptive, and if it's wrong then there's no way for us to really understand what it's supposed to do. The title says you want to add things, but nothing in the code actually adds anything. ---
**Author:** ![Barbara\_Frumas](https://avatars.discourse-cdn.com/v4/letter/b/94ad74/32.png) [@Barbara\_Frumas](https://forum.inductiveautomation.com/u/Barbara_Frumas)\ **Post date:** [January 16, 2024, 5:00pm UTC](https://forum.inductiveautomation.com/t/trying-simple-dataset-add-having-script-probelms/84330/4 "2024-01-16T17:00:38Z")
Thought that was what I needed to do reading on the forum. i just have a text input box, drop down, and submit button. when i submit I want a new row to be created with time stamp , text, drop down selection. then I want to view that dataset in a power table. ---
**Author:** ![Barbara\_Frumas](https://avatars.discourse-cdn.com/v4/letter/b/94ad74/32.png) [@Barbara\_Frumas](https://forum.inductiveautomation.com/u/Barbara_Frumas)\ **Post date:** [January 16, 2024, 5:04pm UTC](https://forum.inductiveautomation.com/t/trying-simple-dataset-add-having-script-probelms/84330/5 "2024-01-16T17:04:02Z")
I am using numbers and dropselect though? I thought row and col were generic? if I set row number will it add or overwrite? ---
**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Post date:** [January 16, 2024, 5:06pm UTC](https://forum.inductiveautomation.com/t/trying-simple-dataset-add-having-script-probelms/84330/6 "2024-01-16T17:06:23Z")
Then you'll need `addRow`. Note that you'll probably need to supply a value for every column, which is why your attempt didn't work. > [@Barbara\_Frumas](#): > > I am using numbers and dropselect though? No you're not. Your `newVal` variable is a list with the literal strings `"numbers"` and `"dropselect"`, not the values from the variables. `row` and `col` have no special meaning. ---
**Author:** ![Barbara\_Frumas](https://avatars.discourse-cdn.com/v4/letter/b/94ad74/32.png) [@Barbara\_Frumas](https://forum.inductiveautomation.com/u/Barbara_Frumas)\ **Post date:** [January 16, 2024, 5:08pm UTC](https://forum.inductiveautomation.com/t/trying-simple-dataset-add-having-script-probelms/84330/7 "2024-01-16T17:08:45Z")
Can I supply a value for every col in the statement? or do I need a separate add for every col? couldn't find an example of multiple in one statement. ---
**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Post date:** [January 16, 2024, 5:10pm UTC](https://forum.inductiveautomation.com/t/trying-simple-dataset-add-having-script-probelms/84330/8 "2024-01-16T17:10:09Z")
> [@Barbara\_Frumas](#): > > ```auto > ds.data = system.dataset.addRow(ds.data, 0, newVal) > > ``` Your `addRow` attempt might also have failed because of that `.data`. Is your `MyData` tag just a dataset tag ? > [@Barbara\_Frumas](#): > > Can I supply a value for every col in the statement? or do I need a separate add for every col? couldn't find an example of multiple in one statement. Just one call is enough. The function does what its name says: It adds a row. ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [January 16, 2024, 5:10pm UTC](https://forum.inductiveautomation.com/t/trying-simple-dataset-add-having-script-probelms/84330/9 "2024-01-16T17:10:47Z")
What you're looking for is `system.dataset.addRow()` ```auto #get the original dataset value ds = system.tag.readBlocking(['[default]MyData'])[0].value #get the values from the components to insert in the dataset #You will need to wrap them in a list. numbers = event.source.parent.getComponent('Text Field').text dropselect = event.source.parent.getComponent('Dropdown').selectedLabel newRow = [numbers,dropselect] #add row to dataset and write to the tag system.tag.writeBlocking(['[default]MyData'],[system.dataset.addRow(ds,row=newRow)]) ``` ---
**Author:** ![Barbara\_Frumas](https://avatars.discourse-cdn.com/v4/letter/b/94ad74/32.png) [@Barbara\_Frumas](https://forum.inductiveautomation.com/u/Barbara_Frumas)\ **Post date:** [January 16, 2024, 5:11pm UTC](https://forum.inductiveautomation.com/t/trying-simple-dataset-add-having-script-probelms/84330/10 "2024-01-16T17:11:39Z")
its a dataset memory tag Do i just newval1,newval2,newval3 ? ---
**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Post date:** [January 16, 2024, 5:13pm UTC](https://forum.inductiveautomation.com/t/trying-simple-dataset-add-having-script-probelms/84330/11 "2024-01-16T17:13:06Z")
Here's an example that adds a row to a dataset: ```python ds = system.dataset.toDataSet( ['name', 'value', 'something'], [ ['foo', 21, 'a'], ['bar', 12, 'b'] ] ) ds = system.dataset.addRow(ds, ['pox', 42, 'c']) ``` Maybe it will help make things clearer ? ---
**Author:** ![Barbara\_Frumas](https://avatars.discourse-cdn.com/v4/letter/b/94ad74/32.png) [@Barbara\_Frumas](https://forum.inductiveautomation.com/u/Barbara_Frumas)\ **Post date:** [January 16, 2024, 5:13pm UTC](https://forum.inductiveautomation.com/t/trying-simple-dataset-add-having-script-probelms/84330/12 "2024-01-16T17:13:23Z")
> [@lrose](#): > > ```auto > #get the original dataset value > ds = system.tag.readBlocking(['[default]MyData'])[0].value > > #get the values from the components to insert in the dataset > #You will need to wrap them in a list. > > numbers = event.source.parent.getComponent('Text Field').text > dropselect = event.source.parent.getComponent('Dropdown').selectedLabel > > newRow = [numbers,dropselect] > > #add row to dataset and write to the tag > system.tag.writeBlocking(['[default]MyData'],[system.dataset.addRow(ds,row=newRow)]) > > ``` I got ```auto Traceback (most recent call last): File "", line 13, in TypeError: addRow(): takes no keyword arguments ``` ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [January 16, 2024, 5:14pm UTC](https://forum.inductiveautomation.com/t/trying-simple-dataset-add-having-script-probelms/84330/13 "2024-01-16T17:14:47Z")
just remove the `row=` May need to include 0 for the index. ---
**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Post date:** [January 16, 2024, 5:14pm UTC](https://forum.inductiveautomation.com/t/trying-simple-dataset-add-having-script-probelms/84330/14 "2024-01-16T17:14:50Z")
> [@lrose](#): > > `system.dataset.addRow(ds,row=newRow)]` remove the `row=` bit: `system.dataset.addRow(ds, newRow)]` But you'll also need a value for the timestamp column > [@lrose](#): > > May need to include 0 for the index. nope it's optional. The function will append the new row to the end of the dataset if the row index is not provided. If you want the row inserted at the top or anywhere else, then indeed you'll need to provide the index. ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [January 16, 2024, 5:18pm UTC](https://forum.inductiveautomation.com/t/trying-simple-dataset-add-having-script-probelms/84330/15 "2024-01-16T17:18:47Z")
> [@pascal.fragnoud](#): > > nope it's optional. The function will append the new row to the end of the dataset if the row index is not provided. Yeah, I know it's optional, but "generally", if an optional parameter is skipped then you need to provide the keyword argument which is why I included it. Kind of weird that it doesn't accept keyword arguments, that seems to go against the standard. ---
**Author:** ![Barbara\_Frumas](https://avatars.discourse-cdn.com/v4/letter/b/94ad74/32.png) [@Barbara\_Frumas](https://forum.inductiveautomation.com/u/Barbara_Frumas)\ **Post date:** [January 16, 2024, 5:21pm UTC](https://forum.inductiveautomation.com/t/trying-simple-dataset-add-having-script-probelms/84330/16 "2024-01-16T17:21:21Z")
> [@pascal.fragnoud](#): > > system.dataset.addRow(ds, newRow)] ```auto timestamp = "[System]Client/System/CurrentDateTime.Value" newRow = [numbers,dropselect,timestamp] ``` i get cannot coerce error on timestamp ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [January 16, 2024, 5:21pm UTC](https://forum.inductiveautomation.com/t/trying-simple-dataset-add-having-script-probelms/84330/17 "2024-01-16T17:21:35Z")
Guess I missed the timestamp need as well. Here is corrected code: ```auto #get the original dataset value ds = system.tag.readBlocking(['[default]MyData'])[0].value #get the values from the components to insert in the dataset #You will need to wrap them in a list. numbers = event.source.parent.getComponent('Text Field').text dropselect = event.source.parent.getComponent('Dropdown').selectedLabel newRow = [numbers,dropselect,system.date.now()] #add row to dataset and write to the tag system.tag.writeBlocking(['[default]MyData'],[system.dataset.addRow(ds,newRow)]) ``` ---
**Author:** ![Barbara\_Frumas](https://avatars.discourse-cdn.com/v4/letter/b/94ad74/32.png) [@Barbara\_Frumas](https://forum.inductiveautomation.com/u/Barbara_Frumas)\ **Post date:** [January 16, 2024, 5:23pm UTC](https://forum.inductiveautomation.com/t/trying-simple-dataset-add-having-script-probelms/84330/18 "2024-01-16T17:23:05Z")
> [@lrose](#): > > ```auto > #get the original dataset value > ds = system.tag.readBlocking(['[default]MyData'])[0].value > > #get the values from the components to insert in the dataset > #You will need to wrap them in a list. > > numbers = event.source.parent.getComponent('Text Field').text > dropselect = event.source.parent.getComponent('Dropdown').selectedLabel > > newRow = [system.date.now,numbers,dropselect] > > #add row to dataset and write to the tag > system.tag.writeBlocking(['[default]MyData'],[system.dataset.addRow(ds,newRow)]) > > ``` getting ```auto Traceback (most recent call last): File "", line 13, in ValueError: Cannot coerce value '' into type: class java.util.Date ``` ---
**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Post date:** [January 16, 2024, 5:23pm UTC](https://forum.inductiveautomation.com/t/trying-simple-dataset-add-having-script-probelms/84330/19 "2024-01-16T17:23:42Z")
Because that's a string, not a timestamp. If you want to get the value from a tag, you'll need to use one of the tag read functions: ```python tstamp = system.tag.readBlocking(["[System]Client/System/CurrentDateTime.Value"])[0].value ``` or maybe use `system.date.now` to get the current time. ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [January 16, 2024, 5:24pm UTC](https://forum.inductiveautomation.com/t/trying-simple-dataset-add-having-script-probelms/84330/20 "2024-01-16T17:24:07Z")
You grabbed it before I corrected the `()` I left off of the `now()` function. Try again. And also remove the comma at the end of the list, if you didn't already. That's what I get for going fast. uggh [Next page](https://forum.inductiveautomation.com/t/trying-simple-dataset-add-having-script-probelms/84330.md?page=2)