Getting text from excel or CSV file for text field

[Reid Kleinschmidt]

Hello,

We currently have 2D interpolation functions being used to look up airport information such as latitude, longitude, elevation, etc.  Each row in the table is an airport and each column is a runway.  The current implementation has two drop-downs.  The first is an airport selection and the second is the runway selection.   This methodology works but we do have some work-arounds since dropdown items cannot be populated by an external file, thus the runway dropdown with the available runways cannot be populated based on the available runways for that airport.  Our current work-around is to have a default list of numbers 0-11 where each number corresponds to a runway which works, but the user doesn't know what runway is index 0 and what runway is index 1-x.

Is there a way to do a lookup similar 1D or 2D lookup but return a text string from an excel file?  My intent with this string was to set the 'Text' property of a text field which would then list out that index 0 = RNWY x, 1= RNWY y, etc once the airport is selected and help act as a decoder ring.  I know something like this could be done as an derived parameter with IF/ELSE statements, but this would require ensuring that the excel files and parameter are synched which isn't ideal.  It would be better if all the runway information could be driven from the excel files.

Do you have any alternative suggestions for doing this that could be primarily driven from lookups of different files?

Thanks you,

Reid

[Chant, Adam]

Reid,
If the Airports do not often change then they can just be added to the Dropdown as a comma separated text strings to the ListItems property. This can also be a Derived parameter of type ascii and a DataSourceArguement of the same comma separated text strings. However, for it to be a Derived parameter the IadsDropDown UpdateRate must be set to 1 or else the control will update so often it will be impossible to select the desired index.

Then either the ValueIndex property by way of GetValue("displayname","propertyname") or OutputName by way of GetUserInput(“OutoutName”) can be used as a Derived parameter to feed any additional display objects or even interpolate functions.

 

An alternative to this would be to use the Test Point System to import auxiliary information to the PlannedTestPointsExUserGroup Table that can be queried using the  GetTestPointInfoEx("UserGroup", "ColumnName", ValueToReturnIfNotExists) [Returns test point information from PlannedTestPointEx table]. That way when the Test Point is selected the corresponding row of the PlannedTestPointsExUserGroup Table is selected and the values for each cell is accessed via the GetTestPointInfoEX(…) function.

 

Please take a look at the IADS Help section “Test Point Import Wizard” or search help for “plannedtestpointex” to see the exact methodology used for this feature.

 

Thank you,

Adam Chant
Project Engineer, IADS

Curtiss-Wright
190 Sierra Court A-3 Palmdale, CA 93550
T: 661.273.7003 x 2210
ach...@curtisswright.com

iads-s...@curtisswright.com

 

From: ia...@googlegroups.com <ia...@googlegroups.com> On Behalf Of Reid Kleinschmidt
Sent: Wednesday, July 1, 2026 8:34 AM
To: IADS <ia...@googlegroups.com>
Subject: [IADS] Getting text from excel or CSV file for text field [EXTERNAL]

 

WARNING: This message came from an external source. Please exercise caution and proper judgment when opening any attachments, clicking links or responding to this message.

---

 

--
You received this message because you are subscribed to the Google Groups "IADS" group.
To unsubscribe from this group and stop receiving emails from it, send an email to iads+uns...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/iads/1ec05b58-94b8-4543-82a5-ee2706bdd323n%40googlegroups.com.

---

This e-mail and any files transmitted with it are proprietary and intended solely for the use of the individual or entity to whom they are addressed. If you have reason to believe that you have received this e-mail in error, please notify the sender and destroy this e-mail and any attached files. Please note that any views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of the Curtiss-Wright Corporation or any of its subsidiaries. Documents attached hereto may contain technology subject to government export regulations. Recipient is solely responsible for ensuring that any re-export, transfer or disclosure of this information is in accordance with applicable government export regulations. The recipient should check this e-mail and any attachments for the presence of viruses. Curtiss-Wright Corporation and its subsidiaries accept no liability for any damage caused by any virus transmitted by this e-mail.

For information about how we process personal data and monitor communications, please visit https://www.curtisswright.com/privacy-notice/default.aspx