Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.

TOPIC: Preventing Lookup to Fail

Preventing Lookup to Fail 2 years 8 months ago #2317

  • Heinz
  • Heinz's Avatar
  • Offline
  • New Member
  • Posts: 11
Hi there,

I use a Lookup function in my script, but when it fails (so it does not find a value) the entire process stops.

To try and prevent this, I though of using a SQL function that does a count of the number of items that woudl match the lookup, based on the same input value on the record.

SQL: SELECT COUNT(*) AS totalFound FROM wscalllog WHERE leadid = 1

I then send that to a IF / THen ELsE and filter if the value = 0, thus, if no value will be found, teh record should be ignored.

Everything seems ok, but when I run the script, I get a "The adapter does not support the Execute function - and it then shows the SQL with a parameter replaced?


I also include my script, but modified it to remove the MySQL password - but I can not provide valid test data since its contains cleint info, but I am sure you will be able to figure out what I am after.
Attachments:
The administrator has disabled public write access.

Preventing Lookup to Fail 2 years 8 months ago #2318

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
Hi Heinz,

The solution for your inquiry is quite easy, you just have to switch in the SQL Heater the side where the SQL statement should be executed. The Excel Adapter currently doesn’t support the Data Lookup functionality.



But it should be a easier way to use just one SQL Heater instead of the Lookup Heater. Note: The Lookup Heater is outdated because the SQL Heater is more flexible.

I’ve modified our FlowHeater Definition. I’ll think it should be clear how it works.

File Attachment:

File Name: LookupProblem.fhd
File Size:15 KB
Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.076 seconds