0

Decision Tool - Is Regex - failure

Wynand Vermaak 6 months ago in Studio / Toolbox 0

Morning everyone,

Context: Business is looking at saving messaging cost, by sending an email instead of an sms - as it works out cheaper. In the business we do however face a concern with regards to the correctness of the email addresses captured by agents. We are now looking at reporting on incorrectly captured contact details in an attempt to increase the success rates of contacting our customers.  

Approach: We looked at using the decision tool's Is Regex functionality, with regular expression /^\w+([\.-]?\w+)*@\w+([\.-]?\w+)*(\.\w{2,3})+$/ to validate an email.

Problem: We found that the functionality is not working as expected - when entering a valid email address the validation fails instead of passing.

I have attached a sample workflow to demonstrate the concern: EmailValidation.bite 

designer execution studio tool workflow
+1
Not a bug

Advanced Recordset Tool fails

Anonymous 7 months ago in Studio / Toolbox updated by Ashley Lewis 6 months ago 2

When the advanced recordset tries to process a recordset that does not exist it does not throw an error but instead makes the rest of the workflow unresponsive.

0

Get Web Method Tool does not provide / map an output at design level when using Generate Outputs on Warewolf 2.8.4.0 - execution level is fine

Wynand Vermaak 8 months ago in Studio / Toolbox updated 6 months ago 2

Hello Team,

The Get Web Method Tool does not provide / map an output when using "Generate Outputs" on Warewolf 2.8.4.0, however execution level works fine for tools that were mapped with certain previous versions of Warewolf.

Example of Mapped output on Warewolf 2.8.3.19:

Image 1106

Example on Warewolf 2.8.4.0:

Image 1107

Herewith a recording with Yogesh regarding the topic - Catch-up; Masi, Wynand and Igor-20230720_100030-Meeting Recording.mp4

designer explorer studio tool variables workflow
+2

Date and Time Difference tool counts wrong difference and wrong date format

Anonymous 9 months ago in Studio / Toolbox 0

Problem:
I checked date difference and date format in Utility - Date and Time Difference example of Warewolf where I found it calculated wrong difference and also date format was not correct.

Warewolf Version I am using is 2.8.1.3

Current Date: 3rd July 2023
Date Format passed in example is: yyyy/mm/dd 12h:min:ss am/pm
New date should be like 2023/07/03 but in example it was resulted 2023/03/07.

Image 1103



Date Difference:

Image 1104


Image 1105

0

Couldn't find full date in SQL Server tool

Nikita Jani 9 months ago in Studio / Toolbox 0

Warewolf version I am using is 2.8.1.3.

Millisecond part is being eliminated while getting records from database. While in my case millisecond is required. 

Image 1099

0

Can we please confirm that the condition "If there is no error" on the Decision tool recognizes and catches all HTTP error codes

Wynand Vermaak 11 months ago in Studio / Toolbox updated 6 months ago 2

Hi team,

We recently ran into a number of issues, and upon investigating we've come to the conclusion that the "If there is no error" condition on the Decision Tool doesn't catch all API HTTP errors - the ones we've experienced a number of times is 400, 404, 500, 503, 504.

I have attached a sample workflow, as an example, indicating the standard way we map our API GET or Post tools. Can you please use a similar setup during testing to confirm if all HTTP errors are recognized and caught?

Regards,

Wynand GetCustomerDetails.bite

execution studio tool web workflow
0

Split Tool Splits Date values incorrectly

Anonymous 11 months ago in Studio / Toolbox 0

When splitting a string in WW version it converts value into Date time format as shown below and Datetime is incorrect

Version: 2.8.3.7

"TU015725753-1,1649998986,Savings,470010,A ROUX,2023-05-05,230.000,202305,8,TU015725753-1"

image

0
Under review

Word Document reading, Checkbox reading

Jeremy James 1 year ago in Studio / Toolbox updated by Gandalf 1 year ago 1

I would kindly like to know if you have in your "ToolBox" along with your Control flow tools, have the ability to open and read the contents of a word document or bonus points a PDF?

Could you kindly point me to one of your example videos demonstrating that? Our customers are dealerships and have a significant amount of paperwork that needs to be automated.

They primarily rely on checkbox inputs on their paper forms.

tool
Answer
Gandalf 1 year ago

There is no tool that does it explicitly. If you are paid subscriber, we could build one for you.

0

Post Tool - Various issues

Wynand Vermaak 1 year ago in Studio / Toolbox updated 6 months ago 1

Hello,

I recently started working on a certain part of the Price Increase Journey that worked last year. What has changed since then? Only the Warewolf version. The workflow in question is the GetPdfLinkDetails which contains an API Post to a 3rd party provider - InsideData. Please note that this API response is an escaped json format. For the sake of completeness, I'm using Warewolf 2.8.1.63.

In the latest version of Warewolf, the API doesn't return a response in Warewolf. Whether the default - output to variable or output to object is selected, as per the below screenshots: 

Image 1074

Image 1075

However, we are able to get a response in Postman as per the following screenshot: 

Image 1076

I then decided to downgrade Warewolf to a version prior to Dev2's Post Tool changes. Once downgraded, upon opening the workflow, I get the following error: 

Image 1077

When I tried to delete the former Post Tool, highlighted in red, in order to drag on a new post tool, I get the following error: 

Image 1078

This concludes the issues experienced. The following is additional information to help with the troubleshooting:

1. The API in question can be called via a post request to the following URL: 
https://generic.insidedata.co.za/ID.Generic.API.TheUnlimited/IDServiceRest.svc/CreateDistributionWithShortener.

The request body is as follow (Please note - should be in Raw Text format - Not JSON:

{
"PassPhrase":"B7CC5331-12A8-46AA-A5B0-D6AB6D4AFC93",
"BusinessID":"TheUnlimited",
"Campaign":"TUG - Price Increase",
"BatchName":"PostMan Test - 2022-08-01",
"DistributionMethod":"SMS",
"DistributionTemplate": "TheUnlimitedInsurance",
"CompositionTemplate":"PriceIncrease",
"TransformData":true,
"Approval":false,
"ArchiveOnly": true,
"LoadData":{
"SourceDataType":"CSV",
"CSVData":"TUS000721271;Journey Test;R20.0;R132.0;March 2023;Yes! You get INSTANT CASH BACK on selected groceries like bread, milk, nappies and more!",
"Customer":{
"Reference":"TUS000721271-2",
"Name":"Journey Test",
"Surname":"",
"Initials":"",
"Title":"",
"Language":0,
"EmailAddress":"wvermaak86@gmail.com",
"NumberMobile": "0726105303"
},
"Reference":{
"RefAmount1":"20.0",
"RefAmount2":"132.0",
"RefDate1":"March 2023",
"Version":"1"
},
"Distribution":{
"SendSMS":true
},
"ExternalID":1234567890123,
"IsValid":true
}
}

Lastly, the workflow in question is:

GetPDFLinkDetails.bite

explorer studio tool workflow
0
Under review

Warewolf Changes format of dates when receiving from stored procedure

Elmo 1 year ago in Studio / Toolbox updated by anonymous 1 year ago 1

I have a stored procedure that outputs a date format of yyyy-MM-dd, my system regional settings date format is set to yyyy-MM-dd

When Warewolf receives the dates from the output of the stored procedure it uses a different date format not set by me or the database. I have attached sample workflows and the stored procedure to test with

see image : 

Image 1060

Image 1059

 Resources.zip