Authoring

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

Hi I'm new to FME and have been unsuccessful in figuring this out.My workspace originally had a choice user parameter where the user could choose a single string (eg. AA) which was then used to read GeoTIFFS that have that string in their filename.Now I want to have multiple choice, and I have changed the user parameter to be a Choice (Multiple). So the parameter ends up looking something like this: AB EB TTI'm trying to figure out how I can now have the workspace loop through and execute the transformers on each choice one at a time.TIA

I can't inspect any of the features in a custom transformer when caching is on. It works in the Main screen but not in the custom. Any insights? Am I missing something? I don't see any settings for it.

I have a JSON file, structured like this:{  "W-Number": {    "EP1": [      {        "timestamp": 1407859200000,        "value": 1.35      },      {        "timestamp": 1407862800000,        "value": 1.44      }    ],    "EP2": [      {        "timestamp": 1407859200000,        "value": 1.58      },      {        "timestamp": 1407862800000,        "value": 1.63      }    ]  }}I want to turn it into a table, like thisW-Number | timestamp | valueEP1 | 1407859200000 | 1.35EP1 | 1407862800000 | 1.44EP2 | 1407859200000 | 1.58EP2 | 1407862800000 | 1.63What I managed so far: used JSONFlattener, then AttributeExposer to expose (see below*). Then I used a ListExploder; it works when I specify e.g. W-Number-EP1{}, which gives me a table for the timestamp and value of EP1, h

Hi There, I am trying to create my own folder structure with the help of this article:https://community.safe.com/s/article/create-specific-directory-structure-in-the-data-do?t=1604933837460Setting the FME_SERVER_DEST_DIR to the FME_SHAREDRESOURCE_TEMP\\myfolder still sends all the results into a fme engine folder (fme_temp/engine/fmeengines/localhost_Engine4/_auto_zip_dataset_1604932399611_14776.zip) and the download zip file still contains the standard writer folders (ACAD_1, ACAD_2, etc) and not the expected myfolder name.Another issue I have is that using the filecopy writer to copy 2 files from the FME Server resources into the data download zip file results in an empty zip file. Did anybody

I have a workspace with several SQLCreators that executes a query to retrieve data from a postgreSQL/PostGIS database. After some manipulation of the data I then am sending it to a FeatureWriter (to FFS) and all the data types are defined as varchar(200) when many of the original attributes from PostgreSQL/PostGIS are of different data types.  I have looked through documentation, searched in community and it appears my only option is to change/switch the featurewriter from "automatic" for Attribute definition to "manual" and define everything by hand. It doesn't appear that "dynamic" option will do what I need either as some of the original attributes being pulled for the PostgreSQL/PostGIS database have been renamed. (i.e. select attr555 as display_name from mytable)  Is there another option than manually changing the data type for each feature within the featurewriter?

Hi, I have a problem that I can't figure out how to approach. I have polygon Shapaefiles of fields on a farm over a number of years (one file per year) with attributes specifying what crops are grown on each field that year and a unique ID for each field. I would like to merge these into one file where each field has an attribute for each year specifying the crop grown.The problem is that the fields are not constant over time. Exemplified in the fig below. A field may be broken up into multible fields (case 1) or the oposite merged into a bigger field (case 2). The fields may also change in size and/or geometry (cases 3 and 4). The fig also tries to illustrate the result I am looking for. If the geometry changes according to these cases the fields generally recieve new ID:s. Any ideas on how to approach this problem? 

We are converting files from KML/KMZ format to MapInfo in a batch operation. We have our C# program calling the FME as a console application with parameters, for every file. Everything works fine except sometimes the the KML input file has errors in it and the FME convertor exists with an error I can see in the console screen.Is any way I can programmatically detect when the convertor has problems and skip the file from my side of the code? Is any message send back to the console in case of success or fail? It should be a correct way to get the result since I can see it in the console, i am just looking for the supported way.Below is an example how we call the FME workflow:string inputPath2 = "C:\\Users\\Breazuo\\Documents\\FME\\Workspaces\\ogckml2mapinfo.fmw" +                    " --SourceDataset_OGCKML " + "\"" + path + "\"" +                    " --DestDataset_MAPINFO " + "\"" + FMEOutputDirectory + "\""; System.Diagnostics.P