FTS H2 Data Logger CSV Imports

[cmcguire]

We modified the FTS_RawFiles task to convert the import ID from the Water Surveys site ID to the GOES ID so that the ZRXPs can be sent right to the hot folder.

Under Advanced Options we checked:
-Strip Defined Values from Outgoing Data (-99999)
-Use Extended Functions

Under the 'Exchange Number structure' we have:

Code Select Expand

Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(<RegExp(<FileName>,"[A-z0-9]+",1)>, "02KF001", "4540E4B0"), "02KF006", "48A7F490"), "02KF010", "4540F914"), "02KF011", "4520239C"), "02KF012", "4550FE8A"), "02KF013", "4555C202"), "02KF016", "4554F562"), "02KF017", "4555B492"), "02KF018", "4831726C"), "02KF020", "4831611A"), "Lanark", "C7C004D6") & "_" & Cell(<CurrentColumn>,1)

Is there an easier way to do this?

@cvance @Dave Eastcott @SteveWKISTERS

[cvance]

Sorry, cmcguire, I don't spend much time dabbling with the advanced configurable converter task types and haven't modified one myself.

Hopefully someone else can chime in that has this experience.

Curtis

[SteveWKISTERS]

Hi Chris,

Do you have a sample file that I can download to check this out? There must be a better way than to run a million Replacement functions, but I won't know until I can mess around with it.

@cmcguire

Steve with KISTERS

[cmcguire]

Thanks Steve,

Here's a typical CSV.  Unfortunately we can't change the file name since it's a WSC gauge, leading to the replace function.  Can the 'Edit Exchange Number Lookup' perform this task?  We haven't been able to figure it out.

[SteveWKISTERS]

I'll take a look at this with Support on Monday and figure out the best approach.

Steve with KISTERS

[SteveWKISTERS]

Hi all,

Please see below for the response from our support team. It seems like you can build up a table mapping of exchange numbers / GOES ID's to ensure smooth transition of the data and avoid a plethora of replace functions.

To do so, simply open KiDAT and navigate to:

1. File > Edit Exchange # Lookup
2. Define the old and new numbers
3. Open the task that requires this mapping, select "Advanced Options" and navigate to "Use Exchange # Lookup".


Cheers,

Steve with KISTERS