hello all,
I am trying to get FME workbench to output into excel file this part of the log file.
any suggestions very much appreciated.
thank you!
Solved
how to get FME workbench to output the log features read/written to an excel file.
+12- Contributor
- 20 replies
Best answer by david_r
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.
below is what is output to the excel file.
not 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.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+12- Contributor
- 20 replies
hi all,
this is not an answer but very close to what I want FME to do for me.
and the result I am getting is below.
how 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.
+51- Celebrity
- 2077 replies
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
- 8392 replies
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.
The list _feature_types{} will contain the required elements.
+12- Contributor
- 20 replies
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.
The 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.
below is what is output to the excel file.
not sure what im doing wrong...
Do you have an example that I can refer to please?
thanks in advance.
- 8392 replies
- Best Answer
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.
below is what is output to the excel file.
not 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.
+12- Contributor
- 20 replies
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.
below is what is output to the excel file.
not 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.