Question

How can i modify FME Quick translator ,looking for name inside the excel source file

  • 14 February 2020
  • 4 replies
  • 3 views

Badge +13

 

How can i modify FME Quick translator .i want to add one more connect with source excel file

i want to write field name so it will look for the name of this field in the source excel file and the code will work only depend on this name for each parameter inside the work space ,

so i want to add one more command line called write name on this page .

Thanks for help


4 replies

Userlevel 2
Badge +16

I do not think this is an option using FME Quick Translator.

But when you run the same workspace using FME Workbench, you can start with a Tester transform, testing the mentioned attribute Has a Value (= not null, empty or missing).

If the Tester fails, you can follow up using the Terminator, causing the process to stop.

Hope this helps.

Badge +13

I do not think this is an option using FME Quick Translator.

But when you run the same workspace using FME Workbench, you can start with a Tester transform, testing the mentioned attribute Has a Value (= not null, empty or missing).

If the Tester fails, you can follow up using the Terminator, causing the process to stop.

Hope this helps.

sure,we have .i saw before oneday on quick translator so i am asking about the idea .how can i do that . and i do not have enough experience for doing that. and thanks for ur reply

Userlevel 4
Badge +13

You'd need to make a workspace that does the translation from Excel to Excel using FME Workbench. Then within that workspace you'd need to make a "published parameter" https://knowledge.safe.com/articles/1287/published-parameter-examples.html that takes the field name, and build logic around that. After that you can run the resulting workspace in the quick translator and it will prompt you.

Badge +13

You'd need to make a workspace that does the translation from Excel to Excel using FME Workbench. Then within that workspace you'd need to make a "published parameter" https://knowledge.safe.com/articles/1287/published-parameter-examples.html that takes the field name, and build logic around that. After that you can run the resulting workspace in the quick translator and it will prompt you.

Thanks for ur reply . i will try ur suggestion

Reply