How to update records, if they exist when importing CSV?

yannicko · October 1, 2019, 5:49am

Hi Teodor,

Good Day! Need your help please. when i assign the query to condition, this throws error. i must be missing some part. can u plz support.

Teodor · October 1, 2019, 5:54am

Hello,
Where is the {{id}} coming from? What do you want to check with your condition?

yannicko · October 1, 2019, 6:00am

Sorry one screenshot was not latest one. my objective is to updated of the record exists and insert if its new record. So What i did,

added one query in steps before condition to check if the record exists already in CSV table? (Screenshot # 1)
then i added condition and assigned query to it as condition. (Screenshot # 2)

Teodor · October 1, 2019, 6:27am

What if you change the condition expression to:
{{query_checker.length > 0}}

yannicko · October 1, 2019, 6:36am

Hi Teodor,
I tried but now error is different. if i dnot use any conditions, table gets records successfully but obviously on each upload records duplicated.

Teodor · October 1, 2019, 6:39am

You want to insert the records if the length is not > 0, so if the query length is > 0 there is a record returned, i.e. the record exists.

So the condition must be:

then -> update step
else -> insert step

As for the error message @patrick will check this.

yannicko · October 1, 2019, 6:56am

Hi Teodor,
Thanks for your support. Yes i tired this
Then --> update and else --> is insert and still same error. i was keep trying and i found that this only comes when update is used. if i just add insert in then and there is not update at all, no error comes but objective is not achieved. Perhaps i am missing something. appreciate support plz.

screenshots without update.

Teodor · October 1, 2019, 7:00am

As i explained in my last post:

As for the error message @patrick will check this.

as this seems to be some .NET specific error.

yannicko · October 1, 2019, 7:53am

Thanks Teodor

patrick · October 1, 2019, 8:13am

Does the update have no conditions? For the checking the error I will need the original .NET exception, it should also be in the returned data.

yannicko · October 1, 2019, 10:26am

Hi Patrick,

there were no conditions in update. Sorry i have lost the page as in my case it was OK to upload new file and overwrite all previous data. so i did created two steps, (1) truncate table (2) insert new CSV again. I don’t need to keep old records every time CSV is uploaded.

yannicko · October 7, 2019, 2:51am

Hello Patrick. I was building similar logic and came across same issue. now i have full exception. Please see below

{
“message”: “Unable to cast object of type ‘Newtonsoft.Json.Linq.JValue’ to type ‘Newtonsoft.Json.Linq.JContainer’.”,
“lastAction”: {
“name”: “update_csv_header”,
“module”: “dbupdater”,
“action”: “update”,
“options”: {
“connection”: “users_connection”,
“sql”: {
“type”: “update”,
“values”: [
{
“table”: “menu_headers”,
“column”: “prod_mast_menu”,
“type”: “text”,
“value”: “12085”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_serial”,
“type”: “text”,
“value”: “P040012”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_airline”,
“type”: “text”,
“value”: “3J”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_airline_desc”,
“type”: “text”,
“value”: “3J”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_class”,
“type”: “text”,
“value”: “J”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_class_desc”,
“type”: “text”,
“value”: “BUSINESS CLASS”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_type_code”,
“type”: “text”,
“value”: “KB”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_type_desc”,
“type”: “text”,
“value”: “CONTINENTAL BREAKFAST”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_desc”,
“type”: “text”,
“value”: “PLASTIC LUNCH BOX 258X203X50”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_desc_2”,
“type”: “text”,
“value”: “BASE + CLEAR LID DESTER”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_unit”,
“type”: “text”,
“value”: “EA”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_client_code”,
“type”: “text”,
“value”: “JUB J KBC0”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_eff_from”,
“type”: “text”,
“value”: “8/13/2008”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_eff_to”,
“type”: “text”,
“value”: “12/31/2019”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_rotation”,
“type”: “text”,
“value”: “JUB JC CONTINENTAL BREAKFAST ALL CYCLE”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_load_scale”,
“type”: “text”,
“value”: “@100%”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_flt1”,
“type”: “text”,
“value”: “”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_flt2”,
“type”: “text”,
“value”: “”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_flt3”,
“type”: “text”,
“value”: “”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_flt4”,
“type”: “text”,
“value”: “”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_flt5”,
“type”: “text”,
“value”: “”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_weight”,
“type”: “text”,
“value”: “”
},
{
“table”: “menu_headers”,
“column”: “equipment_number”,
“type”: “text”,
“value”: “”
},
{
“table”: “menu_headers”,
“column”: “equipment_item_code”,
“type”: “text”,
“value”: “”
},
{
“table”: “menu_headers”,
“column”: “equipment_description”,
“type”: “text”,
“value”: “”
},
{
“table”: “menu_headers”,
“column”: “equipment_description2”,
“type”: “text”,
“value”: “”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_equipment”,
“type”: “text”,
“value”: “”
},
{
“table”: “menu_headers”,
“column”: “prod_mast_image”,
“type”: “text”,
“value”: “”
},
{
“table”: “menu_headers”,
“column”: “prod_seq_no”,
“type”: “text”,
“value”: “80”
},
{
“table”: “menu_headers”,
“column”: “rotation_cycle_code”,
“type”: “text”,
“value”: “CYCALL”
},
{
“table”: “menu_headers”,
“column”: “qty”,
“type”: “number”,
“value”: “1”
},
{
“table”: “menu_headers”,
“column”: “airline_item”,
“type”: “text”,
“value”: “”
},
{
“table”: “menu_headers”,
“column”: “zero_price”,
“type”: “text”,
“value”: “N”
}
],
“table”: “menu_headers”,
“wheres”: null
}
},
“meta”: [
{
“name”: “affected”,
“type”: “number”
}
]
},
“orgException”: {
“ClassName”: “System.InvalidCastException”,
“Message”: “Unable to cast object of type ‘Newtonsoft.Json.Linq.JValue’ to type ‘Newtonsoft.Json.Linq.JContainer’.”,
“Data”: null,
“InnerException”: null,
“HelpURL”: null,
“StackTraceString”: " at DMXzone.ServerConnect.Database.SqlBuilder.Parse(JObject sql) in d:\Develop\DMXzone Server Connect\ASPNET_Source\DMXzone Database Connector\Database\SqlBuilder.cs:line 75\r\n at DMXzone.ServerConnect.Module.DbUpdaterModule.Update(JObject options) in d:\Develop\DMXzone Server Connect\ASPNET_Source\DMXzone Database Updater\Module\DbUpdaterModule.cs:line 43",
“RemoteStackTraceString”: null,
“RemoteStackIndex”: 0,
“ExceptionMethod”: “8\nParse\nDMXzone.ServerConnect.DatabaseConnector, Version=2.1.0.28051, Culture=neutral, PublicKeyToken=null\nDMXzone.ServerConnect.Database.SqlBuilder\nDMXzone.ServerConnect.Database.SqlBuilder Parse(Newtonsoft.Json.Linq.JObject)”,
“HResult”: -2147467262,
“Source”: “DMXzone.ServerConnect.DatabaseConnector”,
“WatsonBuckets”: “AQAAAEMATABSADIAMAByADMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAHcAMwB3AHAALgBlAHgAZQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADEAMAAuADAALgAxADQAMwA5ADMALgAwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADUANwA4ADkAOQAxADMANQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEQATQBYAHoAbwBuAGUALgBTAGUAcgB2AGUAcgBDAG8AbgBuAGUAYwB0AC4ARABhAHQAYQBiAGEAcwBlAEMAbwBuAG4AZQBjAHQAbwByAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADIALgAxAC4AMAAuADMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADUAZAA2AGQAMgA4ADkANwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADQAYgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAFMAeQBzAHQAZQBtAC4ASQBuAHYAYQBsAGkAZABDAGEAcwB0AEUAeABjAGUAcAB0AGkAbwBuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA”
}

yannicko · October 7, 2019, 4:59am

Hi Teodor.

Good Day!

i have just found that using “.length > 0” is resulting below error that i reported to Patrick. However when i used “.value” attribute. this worked well.

-------------- adding below as 3 replies are possible only
Hi Teodor,

script time filed gets empty automatically. even if i have saved action file.

patrick · October 7, 2019, 12:06pm

It is the database update action that is generating the .NET error, with the change from .length to .value in your condition it will be always false and do always a insert action, that is why you don’t have an error there.

Can you check if you have the latest files from you Bin folder uploaded to your server, the error you have should have been fixed in the latest version.

I will check the issue with the script timeout not being set.

yannicko · October 10, 2019, 6:52am

Hi Patrick, you are fully right “.value” attribute was not working as you explained already. but my problem still remain.

I did removed the uploaded file on server manually from my hosting to make sure latest file is uploaded.
i did removed the steps, created new action files.
my wappler version is also update.

When i use “.length > 0” it throws same error i mentioned in above posts. when i do not use “.length > 0” just select query as TEODOR helped us in above posts, it shows different error (screenshot 2). please support.

zitroware · October 29, 2019, 5:04am

I have encountered before if the output of a query is null no matter what expression you use it doesn’t go to the “else” part. I don’t know if this will help but what I have done is to use “count” to know if a record exists, as in the following:

In this way, I am sure count will always be either >=1 or a 0.

TomD · October 29, 2019, 8:50am

There are probably a number of ways to do this. I just use the query as the condition and it works fine.

The query is simply:

Hyperbytes · October 29, 2019, 12:15pm

I have also had issues with detecting empty queries in then past. While it is not in the picker using {{query1.length}} will give you the result you want