Skip to main content
Solved

How to import/run multiple tests using values in a spreadsheet?

  • October 3, 2022
  • 3 replies
  • 74 views
bush_walker
Contributor
Forum|alt.badge.img+2

Hi everyone,

 

I have a workspace where I am trying to test some element attributes to see if they match certain conditions/values. So kind of like:

 

Location: Melbourne (fixed for all elements in file)

Asset type: various (varies per element)

 

I have around 80 of these attributes to test. The tests parameters are contained in an Excel file, i.e. I have a file that has the following columns:

 

  • Attribute Name
  • Attribute value (either has a value that I want to check against if Fixed)
  • Attribute type (contains term 'fixed' or 'varies')

 

Other than writing each individual rule into the Tester, is there a more efficient way to do this, particularly as the parameter spreadsheet may update and I want to avoid re-writting all the tests?

 

Thanks in advance for your help! Amit

Best answer by markatsafe

@bush_walker​ You can sometimes use DatabaseJoiner or FeatureJoiner to do a lookup on the speadsheet. If the match fails then you know the 'element' didn't math on in your list. InlineQuerier also allows a wider range of join expressions. If you can attach a sample of the data and lookup someone could probably create a minimum working example for you

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

redgeographics
Celebrity
Forum|alt.badge.img+59
  • redgeographicsCelebrity
  • Celebrity
  • 3699 replies
  • October 3, 2022

You could try a FeatureMerger or FeatureJoiner, have it match on all those attributes. If it doesn't match, it means that feature failed all tests.

FME rocks! \m/
M
Forum|alt.badge.img+2
  • markatsafe
  • 1891 replies
  • Best Answer
  • October 3, 2022

@bush_walker​ You can sometimes use DatabaseJoiner or FeatureJoiner to do a lookup on the speadsheet. If the match fails then you know the 'element' didn't math on in your list. InlineQuerier also allows a wider range of join expressions. If you can attach a sample of the data and lookup someone could probably create a minimum working example for you

bush_walker
Contributor
Forum|alt.badge.img+2
  • bush_walkerContributor
  • Author
  • Contributor
  • 2 replies
  • October 5, 2022

Thanks for your help @Hans van der Maarel​ and @Mark Stoakes​  - I used the FeatureMerger to achieve what I needed. See screenshot below, I'm testing custom IFC fields (converted from traits attributes) against a test in the Attribute Manager.

 

image

Community Stats

32,061
Posts
121,727
Replies
39,688
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.