Sorry Team, This is not one question.
I have one fme file, which writes (conventional writers)to 50 PostGIS tables. I need table names and total features written counts from fme.Since I am writing to a staging database, I need to do validation of counts, before making / swapping these tables as the main tables for the application.
once I am okay with the previous counts(count from the previous run) and current counts(comparing prev run with the current fme run), we are copying the tables to the main DB.
table1 100000
table2 50
table3 6895698
....
like this
to write these info (table_name , total_count)to one more postgres table ie fme_written_status table.
I know our feature writer does this job, but I need to replace all the writers.
summary port gives this output with total_features_written.
But not one feature writer, I need 50 separate feature writers. because summary port gives total, not table-wise.
can I replace all normal writers to feature writer transformers in one go?
can I achieve this using one features writer by grouping table names?
otherwise, fme will open multiple Postgres connections.
I am also thinking...
after fme is done, why don't we read the log file(anyway it is a text file) and get the table names and their counts using regex search? Has anyone done this before?