Skip to main content
Solved

how to get FME workbench to output the log features read/written to an excel file.

fbastian73
Contributor
Forum|alt.badge.img+12

hello all,

I am trying to get FME workbench to output into excel file this part of the log file.

image.pngany suggestions very much appreciated.

thank you!

Best answer by david_r

fbastian73 wrote:

Hi @david_r​ ,

thanks for replying.

I can see in the summary the features i want to go into the output but was unsuccessful in getting FME to write it to an excel file.

I do a group by and still get other things on the excel file.

I can see what i want on the visual preview as shown below but cannot get that to go into the excel file.

imagebelow is what is output to the excel file.

imagenot sure what im doing wrong...

Do you have an example that I can refer to please?

thanks in advance.

Have a look at the attached sample workspace.

Note, however, that it will only output the number of features written. If you also need the input features, you'll need to add one or several StatisticsCalculators after your input feature types and add the output to your Excel writer.

Alternatively, you can access the counts from the Python shutdown script, see https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Desktop/Configuration/FME_END_PYTHON.htm and the contents of the Python dictionary fme.featuresWritten.

However, getting the values appended to your Excel sheet from the shutdown script might be non-trivial.

View original
Did this help you find an answer to your question?

6 replies

fbastian73
Contributor
Forum|alt.badge.img+12
  • fbastian73Contributor
  • Author
  • Contributor
  • January 7, 2023

hi all,

this is not an answer but very close to what I want FME to do for me.

imageand the result I am getting is below.

imagehow do I get the number in cell C8 to be in cell B8?

and perhaps C column name on cell A8?

is this possible to do?

even if I can get the first criteria and then give cell A8 a name would be fantastic.

any suggestions will be appreciated.

thanks.

danilo_fme
Evangelist
Forum|alt.badge.img+42
  • danilo_fmeEvangelist
  • Evangelist
  • January 7, 2023

Hello @fbastian73​ 

 

There is a interesting post here How to extract and use log information in Workbench (safe.com)

 

I believe that it be use this can be very useful to you.

 

 

Thanks in Advance,

Danilo

david_r
Evangelist
  • david_rEvangelist
  • January 9, 2023

If you replace the writer with a FeatureWriter, the output summary feature will contain all this information, which you can then simply send to an Excel writer.

imageThe list _feature_types{} will contain the required elements.

fbastian73
Contributor
Forum|alt.badge.img+12
  • fbastian73Contributor
  • Author
  • Contributor
  • January 10, 2023
david_r wrote:

If you replace the writer with a FeatureWriter, the output summary feature will contain all this information, which you can then simply send to an Excel writer.

imageThe list _feature_types{} will contain the required elements.

Hi @david_r​ ,

thanks for replying.

I can see in the summary the features i want to go into the output but was unsuccessful in getting FME to write it to an excel file.

I do a group by and still get other things on the excel file.

I can see what i want on the visual preview as shown below but cannot get that to go into the excel file.

imagebelow is what is output to the excel file.

imagenot sure what im doing wrong...

Do you have an example that I can refer to please?

thanks in advance.

david_r
Evangelist
  • david_rEvangelist
  • Best Answer
  • January 10, 2023
fbastian73 wrote:

Hi @david_r​ ,

thanks for replying.

I can see in the summary the features i want to go into the output but was unsuccessful in getting FME to write it to an excel file.

I do a group by and still get other things on the excel file.

I can see what i want on the visual preview as shown below but cannot get that to go into the excel file.

imagebelow is what is output to the excel file.

imagenot sure what im doing wrong...

Do you have an example that I can refer to please?

thanks in advance.

Have a look at the attached sample workspace.

Note, however, that it will only output the number of features written. If you also need the input features, you'll need to add one or several StatisticsCalculators after your input feature types and add the output to your Excel writer.

Alternatively, you can access the counts from the Python shutdown script, see https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Desktop/Configuration/FME_END_PYTHON.htm and the contents of the Python dictionary fme.featuresWritten.

However, getting the values appended to your Excel sheet from the shutdown script might be non-trivial.

fbastian73
Contributor
Forum|alt.badge.img+12
  • fbastian73Contributor
  • Author
  • Contributor
  • January 16, 2023
fbastian73 wrote:

Hi @david_r​ ,

thanks for replying.

I can see in the summary the features i want to go into the output but was unsuccessful in getting FME to write it to an excel file.

I do a group by and still get other things on the excel file.

I can see what i want on the visual preview as shown below but cannot get that to go into the excel file.

imagebelow is what is output to the excel file.

imagenot sure what im doing wrong...

Do you have an example that I can refer to please?

thanks in advance.

thanks very much @david_r​ that was helpful.

cheers.

Reply


Helpful Members This Week

Community Stats

31,040
Posts
117,669
Replies
38,822
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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.