Dynamic data import / export


simply more productive
Up to 100,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.
  • Page:
  • 1

TOPIC: Preventing Lookup to Fail

Preventing Lookup to Fail 3 years 7 months ago #2317

  • Heinz
  • Heinz's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 13
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.

Please Log in or Create an account to join the conversation.

Preventing Lookup to Fail 3 years 7 months ago #2318

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 275
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

Please Log in or Create an account to join the conversation.

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.
  • Page:
  • 1
Moderators: FlowHeater-Team
Time to create page: 0.252 seconds