Authoring

Is it possible to expose fme_basename on schema features, when reading in just a schema using a FeatureReader? I've tried exposing it on the reader parameters for an excel file, but it does not come through. Adding an AttributeExposer reports it as missing.Thanks

I use FME 2020.1.3.What I want to do is to use a FeatureReader to read a PostGIS DB depending on created attributes ( usual generic approach) and to write them to an other PostGIS DB with an FeatureWriter, using Published Parameters to define the destination. As I use the generic port as outpur from the FeatureReader, the data loses its data-type information. I know, that those informations are given through the Schema port of the FeatureReader and that there is a way to merge them again to the data.I found serveral post about this topic (https://community.safe.com/s/question/0D54Q000080hbiSSAQ/generic-attribu

I know how to use ListConcatenator in order to concatenate all list values into a single attribute. However, what can I do if my feature has multiple list attributes? I want to concatenate all values of all lists into respective single attributes. The resulting single attributes should have the names of the original list. I don' know the names of the lists in advance.Examples:colour{0} = 2 colour{1} = 3 colour{2} = 2single attribute colour = 2,3,2shape{0} = triangle shape{1} = square shape{2} = circlesingle attribute shape = triangle,square,circleThanks for any help

Hi All, I tend to use the workspace description parameter to track my overall changes and updates to the workbenches I create. This is handy for me to have a way to track things within the workbench itself, without having to keep notes elsewhere on what i've done. However, it's not exactly easily "user facing" for the others in my organization. I'd like to be able to pull the overview, help and history from the workspace parameters in order to have them exported out alongside the reports that i'm generating if possible. I don't see them stored as standard parameters that FME can fetch in something like ParameterFetcher. Perhaps this information is accessible in the FME python API somehow?

This is my initial data:Name,Value sza034,ber_afu sza033,ber_awn sza034,ber_afl sza033,ber_afu sza034,ber_afu sza032,ber_awn sza034,ber_afl sza033,ber_fff sza033,ber_bgt sza033,ber_afu sza033,ber_jijThe result has to be a matrix, with a row for each unique name and a column for each unique value.the fields in the matrix have to be filled with "yes" or "no":Name,gschber_afl,gschber_afu,gschber_awn,gschber_fff,gschber_bgt,gschber_jij sza034,yes,yes,no,no,no,no sza033,no,yes,yes,yes,yes,yes sza032,no,no,yes,no,no,noBy using the Aggregator, AttributeSplitter, ListDuplicateRemover and ListSorter, I managed to get for each name a list with its unique values. But how can I write this matrix now?Thanks in advance.Vera

Hi All, I'm trying to create a series of basic maps to illustrate address points which are broken into clusters. The cluster size range from 16 to 600, some clusters are beside each other in built-up-areas.  When processing each cluster it seems the extent(or boundbox) of each map clips layer data in overlapping areas. Can anyone suggest what i may be doing wrong? or another approach. Many thanksKieran  

I am using a FeatureReader to read a Postgres db table. As I want the workspace to be easily migrated from developement to production system, I use Published Parameters to supply the connection parameters, meaning I use a parameter committing the name of a FME-DB-Connection and two parameters (Published_Parameter_Schema.Published_Parameter_Table) for the Feature Types to Read. Unfortunately, no output is generated from the generic port (no error message in the transition log), even if I expose the attribute within the FeatureReader or with an AttributeExposer afterwards.As a workaround, I use a AttributeCreator to commit the Published Parameters for the schema and the table into attributes before using them as input for the FeatureReader. With exposing the attributes from the Postgres-DB inside the Transformer, this works fine. But I keep wondering, why it doesn't work using Published Parameters directly? 

Having an issue using a FeatureWriter with the following parameters (see screenshot):Feature Operation = fme_db_operationTable Handling = Use ExistingUpdate Spatial Column(s): NoRow Selection = WHERE clause  I have features coming into the FeatureWriter that are both fme_db_operation INSERT and UPDATE (see 2nd screenshot). My understanding of the Update Spatial Column(s) parameter is based on the help that states "Update Spatial Column(s) is a writer format parameter that is in effect only when the feature operation for a feature is Update".   However, with this set to No, my Inserts don't get geometry (writing to ArcSDE)

Hi guys, I'm looking for a way to adjust vertex order in triangles. First point should be the one with smallest angle between two edges. Remaining vertixes are to be oriented counter clockwise. Is there a build in transformer that offers such functionality or does anyone have a ready to use solution/idea? Thanks in advance!

Hi All,I have a point feature service on AGOL which gets populated daily with new points, data and attachments.I'm trying to make a WHERE clause for an AGOL reader so FME only reads data from the last 3 days. According to ArcGIS dev page https://developers.arcgis.com/rest/services-reference/query-feature-service-layer-.htm , the WHERE clause should look like this EditDate > CURRENT_TIMESTAMP - INTERVAL '03' DAY  .However, FME gives me a fatal error.Simple queries like EditDate > '2020-03-05 00:00:00.000' work just fine.EditDate is esriFieldTypeDate and it comes into FME as '20200305235154.156000' P.S. the script will be published to FME Server (Cloud), so

I have two tabels (please see attached image), and I would like to do the following: If ID(table 1) = Connection (table 2) fill this ID from (table 1) as a New ID attribute in (table 2) anyone can help? Thanks is advance!

I have a CSV with 4 columns, UTF-8, 52000 rows. Nothing too intense.  If I start a new blank FME workbench, drop on a FeatureReader, specify the input format as CSV, and select the csv file (which is not open in any other application), and then click ok, FME Workbench shows a brief dialogue stating "reading features", and then I get the spinning wheel of death, followed by an eventual crash.  Is this a known bug, should I be looking for something else?

Hi all.I'm importing some DWGs and DGNs, merging all features from all files, and adding fme_basename and fme_dataset to the input. This works fine, until output.The output writer featuretype lists the two attributes under "Format attributes" with a green arrow. The writer featuretype dropdown also lists them. And the User Attributes are set to "Automatic".But the writer fails to output the fme values to the database tables. Only the "autocad"/"igds" values are output.What am I missing here ? Shouldn't the fme attributes be included in the output ?Need I do anything else to make this happen ?Cheers

Hello,I have a set of features, composed of polylines with 50 points each. With each point, i would like to keep an argument in the form of a list, so that each line has a list of argument from the points. The list is created using the PythonCaller:listdistances=[str(distance[0])]for i in range (1,n-1):      intermediaire=0      disabs=float(distance[0])+i*pas      listdistances.append(str(disabs))      while float(distance[intermediaire]) <= disabs :        intermediaire += 1listdistances.append(str(distance[-1]))newFeature.setAttribute('listedistance{}',listdistances) So it is clear that the list is full of str format. The list is made and kept for all the next transformers and works with them. But it is not kept once it goes through a writer. When I open it on the data inspector afterwards, the 55 attributes go down to 5, as the 50 in the form of a list disapear.I tried to use a

Hi I am trying to read attached CSV file using FME 2020.1 Can some pls advise the correct parameter on the reader to all the values from this csv file. I have tried various options. It either doesn't read it at all, or misses few columns

Hi all,I've run into a bit of an issue where I've got to figure out the following. Bear with me, as my thought process is still recovering - Each month Postcodes and data come to us, and these are in a zip file.I read in the starting path with the "Path" reader as the names are not the same each month. That's the key for this approach. It could be something like "Postcodes_Nov20.zip" for example.Parsing that detail, using the Unzipper, I unzip the contents to a working folder.#I feed these through, with the path_windows value, to the FeatureReader, as it holds the complete paths in; eg - Z:\\FME\\Working Folder\\Postcodes_Nov20\\data\\Part1.csvThese are then connected to a FeatureReader, but it's just parsing the same file path, and not the CSV files. I've attached the workspace, as well as the FeatureReader parameters, as this has stumped me and is just the sta

Hi list.I have a workspace, that fails when running. It fails in an Emailer, that I just added last week. The relevant excerpt from the log file is shown here:2020-11-30 17:38:49|   5.6|  0.0|STATS |Emailer_CATCHER (TeeFactory): Cloned 0 input feature(s) into 0 output feature(s)2020-11-30 17:38:50|   6.0|  0.4|ERROR |Python Exception <ModuleNotFoundError>: No module named 'fmepy_emailer'2020-11-30 17:38:50|   6.0|  0.0|FATAL |PythonFactory failed to load python symbol `fmepy_emailer.Emailer'2020-11-30 17:38:50|   6.0|  0.0|FATAL |Emailer_CALLER (PythonFactory): PythonFactory failed to close properly2020-11-30 17:38:50|   6.0|  0.0|ERROR |Emailer_CALLER (PythonFactory): A fatal error has occurred. Check the logfile above for details2020-11-30 17:38:50|   6.0|  0.0|ERROR |Emailer_CALLER (PythonFactory): A fatal error has occurred. Check the logfile above for detailsThe Python scripting is set to 3.7+, and the Em

Before i start delving into the .fmw files, does anyone know how to identify if a Feature writer has it's Attribute Definition set to Automatic,Manual or Dynamic either using the .FMW reader or reading the .fmw as a text file

This question contains a few moving pieces - all in the hope of improving bulk insert operations.  Background: FME Desktop is on a dedicated workstation with 16gb ram and 2.1gb latent memory usage (ie 14gb physical ram is almost always available for FME to use.)I'm attempting to use FeatureReader to read/write a 1.5gb CSV (10m rows, 15 columns) to a MSSQL server. The writer is Microsoft SQL Server Non-Spatial. The SQL Server writer has Bulk Insert set to Yes, and I've tried Features per Transaction from 500 to 5000 rows. The SQL server has more than enough free space in it's current *.mdf that it is not trying to increase size, the table is set to truncate on insert, and there are no indexes, constraints, or keys at the time of insert. The SQL server has almost no load on it at all (extremely underutilised!), but in any case is on a large machine (20gb ram, 8 core), and the database itself has virtually no usage.  The insert

I have a Custom Transformer with a loop in it. It contains Blocking Transformers, so it is linked. I would like to pass the number of iterations to the main Workspace, but I do not find how to expose the Attribute that I have set in the Advanced properties of the Custom Transformer:the only reference that I found is: https://knowledge.safe.com/questions/4722/accessing-iteration-coutn-parameter-is-it-possible.html of @gio. Do you remember how you solved it in the end? Thanks in advance.

Hi, I don't seem to get column width in Excel writer to work with a number other than zero. Too big a number gives an error, zero works to adjust the width to cell contents, but it does net seem to react to smaller numbers. Does anybody have an idea?

I have a SystemCaller transformer that runs a script external to FME, and this script writes out a 2gb csv file.  My aim is to use a CSV Reader and an SQL Writer together to get this in to a database.  The issue I'm facing is that the CSV Reader seems to be a starting point, and I cannot connect the output side of the SystemCaller to the input side of the CSV Reader to indicate that it should run once SystemCaller is complete. Is there a strategy that can be used to overcome this? I'd prefer to keep things in the one workflow if I can.

I have a newbie question.  Can I instruct FME that I wish it to finish all previous steps (transformers), before proceeding with the next step? By way of example I have a workbench that gets a list of files from FTP, downloads those that match a regex pattern (might be a few hundred mb), unzips them, and then needs to call a SystemCaller for some custom code to run. I need all the FTP files to be downloaded, and all the files to be unzipped before I run the next bit of code. FME wants to slide each file right the way through the workflow individual of each other. So, I might wind up collecting 10 files before I can run the SystemCaller, but I do need the 10 files present.  Something along the lines of "If there's 10 things on the input side, you need 10 things on the output side before proceeding".

Is it just me or FME 2017.1 gets slower when adding a FeatureWriter or FeatureReader in the workbench?When I mean slower, I mean everything in the software is slower. Even at the point of crashing the application.Processing time stay normal though.I've experimented this on several desktop, not just mine.

I have a workspace that reads from a spreadsheet and dynamically makes attribute names based on a date column, with the values of the attributes being the services offered on that date, as shown.While the Feature Inspector sees these attributes, they are not exposed in the canvas and the writer is not aware of them, even when I make a dynamic writer and set Schema Sources as "Schema from first feature". Doesn't work with AttributeExposer either, as it does not see these dynamically generated attributes.The spreadsheet will have different dates every year. Is there a way to write these attributes dynamically into the writer?Thanks