FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
Take a look at the available examples for the MySQL Adapter , maybe your question can already be answered here: CSV text file import , data migrating , exporting only new records
  • Page:
  • 1

TOPIC: Preventing Lookup to Fail

Preventing Lookup to Fail 5 years 3 weeks ago #2317

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:

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

Preventing Lookup to Fail 5 years 2 weeks ago #2318

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.
Attachments:

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

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

Copyright © 2009-2019 by FlowHeater GmbH.
All rights reserved.

Follow us on

twitter  facebook

YouTube

 de en