AnsweredAssumed Answered

Dynamic fields name

Question asked by f.i.sciences on Feb 22, 2018
Latest reply on Feb 23, 2018 by f.i.sciences

Hello community,

 

I'm doing a conversion process that can be hook to any external ODBC source.

So I wrote 'Connector' script that let me dynamically define the source fields names and layout name to read the values needed.

Connector - MySQL.jpg

I use a script to export the 'unique key' from the external source DB and import them in the local DB, creating all needed records. Making relationship from that unique key.

Then a generic script called 'ReadDataSource' do the job in the DB for the rest of the fields needed:

DataSourceIN.jpg

After that, I do the conversion on the data and then I need to export it back to the external source DB.

The problem is that there is no script command 'Replace Field Contents By Name[...]' like the script command 'Set Field By Name[...]' flavor!

Doing a loop for each records (~100,000) and use the script command 'Set Field By Name[...]' is time consuming!

ANY CLUE?

 

Thank you.

Outcomes