Authoring

Hi all, The image you can see the attribute table of my datasets. I would like to change the attribute position based on a logic like thisIf the position of an object is UNDEFINED, I would like to find an object that has same _id value and then if the object with same _id's position is RIGHT, assign the position value as LEFT. For example, the object with _id_rule 14 has position as UNDEFINED, so i would like the find the other object that has _id 11 (it is common in both object). In my case, It would be the object with _id_rule 10. Then I would like the check the position value of the object with _id_rule 10. If it is RIGHT, I would like to change UNDEFINED value to LEFT for the object with _id_rule 14I have tried to use combination of tester & sampler but could not figure out so far. Any idea? Thanks in advance.

Good afternoon, I'm trying to add FME Server Job Id to a report in Excel, but it doesn't seem to be populating. I have $(FME_Job_ID) assigned to the correct field. When I look at it in desktop, It is not set. I don't think I need to set it as I'm not in FME Server. Does the Job Id automatically get placed in the $(FME_JOB_ID) parameter? Or do I need to place something in it? Thanks,David

Hi All, I have been "gifted" 500gb of contours (as 20,000 20meg shapefile tiles) and have been asked to create a single dataset (merge and dissolve/union for loading into a ESRI database.) I have read many of the FME articles on BIG data processing and Lightspeed Batch Processing...So its a shapefile to FileGDB transform essentially. I always like a challenge so i have had a think on how to achieve this...Use Fme to process the data in batches, ie merge and union the first 500 shapefiles into fme FFS format , then the next 500 etc, then merge the FFS into larger and large FFS'S then write it all out eventually to FGDB. Pros - process it locally, easy to setup and let run. Cons-not sure if merging then dissolving over and over again is more efficient than doing it all at once or will be sloooow?  Use FME to create 20,000 GeoJson csv's for upload to google BigQuery and use ST_UNION_AGG function on the data using Googles infrastructure

I managed to get my first FMEAR model of a campus with 3D buildings and roads on FMEAR app for Android. I was wondering what those different coloured meshes indicate, when trying to project the AR model on a surface?It will be nice, if there was some more documentation on the FMEAR in addition to what is available. ThanksSRG

Hi, I would like to delete some files in the temporary resources folder using the FMEServerResourceConnectorTrying to populate the object id:Object IDThe Object ID of a file or folder on FME Server to delete. If valid credentials have been provided as a web connection, you may browse to a location.With:$(FME_SHAREDRESOURCE_TEMP)/mapper/downloads/$(UUID)/data/xxx/@Value(filename_field).datHowever it doesnt delete the file, not reporting anything.Any idea what I am doing wrong here?Thank youOliver

I created a workspace to pull aerial imagery stored in a number of different folders. As a result I have 3 FeatureReaders, and in order to get the imagery to write with .tfw I need the schema output port to be connected to the writer. The problem is I need to run the workspace and wait to see which FeatureReader is going to first output a file and then ensure this is the schema output port running to the writer. I want to start using this workspace with WorkSpaceRunner but unless it is completely automated I won't be able to? Am I going wrong somewhere, is it possible to fix this? I don't want to have to wait and manually connect the schema output port.  Also with the same workspace, I have noticed a change (bug?) since I upgraded to 2019.0. In 2018.1 when I uploaded a particular AOI shapefile the output came from the TIFF_READER (see image below), but now (2019.0) it comes from the Feature_Reader_2. There is no reason for the change, it should be sending the vast majority thro

I have never been able to work out how to expose the attributes of FFS stores in FME. When I open a FFS in data inspector and click on a point i can see the attribute, but when using a reader it is not possible to expose it.See screen shots clearly in the FFS in data inspector   But cant see it in the FFS reader at all? any ideas on how to expose these?  

Hi,I am trying to figure out how to have multiple lists in a single email. I have a ID field for features missing invert elevations, being passed to a list builder, list concatenator, to an attribute manager (to insert some text before the ID's), and then the Emailer transformer.I want to include the construction drawings each ID has, so I am using a DuplicateFilter and going through the same series of transformers but the emailer sends out 2 different emails, each with the different list. I am testing on FME 2018.1 and will be publishing this to FME Server 2018.1 as well.Thanks!

Does anybody have a 2019 or 2018 FME Server Test Plan to include security and usability that I can learn from and adjust to my specifications? Thank you!

I have a published python scripted parameter that is supposed to return the current date and time. The parameter is later used in the dataset field in a FeatureWriter at the end of the workspace.   Testing the workspace in FME 2017.1 is fine, but running the workspace in 2018.1 doesn't work - FME EXE stops immediately after starting translationHere's the script used by the parameterfrom datetime import datetimereturn datetime.now().strftime('%Y-%m-%d_%I%M%p')I have the preferred python interpreter set to Esri ArcGIS Desktop Python (2.7)I'm very new to python so apologies if i'm missing something obvious. Thanks!  

Hi there,I have an existing spreadsheet and need to add in rows of information from a different spreadsheet based on the column value from the existing spreadsheet. I need to then write this to Excel again.Any suggestions?Thanks

I'd like to generate a map of municipalities in the northern part of The Netherlands using D3.js. Because FME 2019 now has a TopoJSON writer, I would like to build my map using a TopoJSON file. So I created a really simple workspace, with only a WFS reader, OrientationExtractor and TopoJSON writer.The WFS URL is:https://geodata.nationaalgeoregister.nl/bestuurlijkegrenzen/wfs?cql_filter=gemeentenaam IN ('Het Hogeland', 'Loppersum', 'Appingedam', 'Westerkwartier', 'Groningen', 'Delfzijl', 'Midden-Groningen', 'Oldambt', 'Veendam', 'Pekela', 'Westerwolde', 'Stadskanaal')I am only interested in the feature type 'gemeenten'.D3.js expects the winding order of polygons to adhere to the left-hand rule. I use the OrientationExtractor to make sure they all do. I verified that the orientation of all polygons is 'left_hand_rule'.In the TopoJSON writer I specify that geometry should be reprojected to WGS 84 and that a bounding box should be added to the TopoJSON file. However, when I try to visualiz

HelloI'm new to FME Server, so this is probably an easy question:Is it possible to cancel a running job or to kill jobs in the queue (in the FME_Server User Interface)?.I searched for the answer in the forum, but I didn't find one (that I understood...)Thanks, Vera 

I'm converting some DGN files to GDB and want to name the output files with the input filename. I have extracted the input file to an attibute called "_rootname" and done a fan out in the writer on the attribute name as shown hereThis works fine. But I want to zip the output file at the same time. What settings should I use? I've tried various things but can't get it to work. 

Hello Everybody,I have a question about routes which i haven't found on the forum yet. To start with i have a number of addresses, a dataset of the local road network and a dataset which contains only the highways. The thing i would like to calculate is what is the shortest route from each address to the nearest highway, using the road network.  I have been experimenting with the shortestpathfinder but i'm struggling with how to find the nearest route instead of a point.  Any suggestions how to solve this problem is welcome, Thanks, Jan

I'm using FME Desktop to run Validation Checks on a large ESRI SDE network. The intention is to run the checks daily on recently edited data. While a filter can be applied on some checks (i.e.: checking attributes are valid), others need to be checked across the full network, i.e.: a Point Feature added today needs to be checked against the full Line dataset to ensure its location is valid - a Valve must be located at the end point of 2 Mains, etc.These large filters are difficult to process so I was hoping to use Workspace Runner to split the workspaces by location, so instead of say: A. Checking all Valves in the whole network against all MainsWeB. Check all Valves in Polygon 1 against all Mains in Polygon 1C. Then check all Valves in Polygon 2 against all Mains in Polygon 2D. etc. etc.I'm not that experienced with FME but are there any tutorials or can anybody tell me how to do this using the Workspace Runner and say the Clip transformer. I've seen the following but don&

having issues getting the parallel processing to work properly when using raster mosaic tool. Trying mosaic a large volume of images via this tool and improve efficiency. 

HelloI seem to be too tired or lost in confusion ... I want to set the "Output Contour Interval" in ContourGenerator via an attribute.Problem: It only allows fixed input or a predefined parameter. So I tried to put this into a Custom transformer, publish the parameter and set it from "outside" ...BUT: no success. Also for the Custom Transformer parameter I can only use a parameter. Next try: @Value(attribute_name) also doesn't work I hope there is a more flexible way to control the ContourGenerator output than to put it into its' own workspace ?!B.T.W. same situation for DEMGenerator and maybe other similar tranformers ... 

My workspace has a published parameter `area` which can have the values `country` or `province`. It also contains a SpatialFilter transformer that only needs to be executed if `area = province`. How do I evaluate whether this condition is met only once for the entire dataset? Because I have hundreds of thousands of features, I don't want to evaluate the condition for each feature seperately. I would like to do conditional processing on the *dataset* level in stead of the feature level, so Tester and TestFilter are probably not the solutions I'm looking for.

Has anybody else noticed their reader/writer/transformer annotations drifting in FME 2019? I shall admit I can be a bit pernickety about layout, so I do find it mildly annoying to find that my aligned annotations suddenly have drifted upwards when I open my workbench anew.

Hi,I'm thinking if use database connections are better than published parameters or privates one and use it in embed connections. Database connections are usefull in case of maintenance, but I think are less usable as embed parameters.The main question is about accessing database connection parameters from other transformers or from attributes (programmatically i.e. python). I'd like to use the host parameter set in database connection parameter for setting other variables and have a dynamic workbench in function of the host value.With classical embed parameters is easy but with embed connections I think that is not possible.I hope my question is clear.Thank you for any suggestions about it.RegardsGiosia 

I have just upgraded (in-place, express install) FME Server 2019 Upgrade. I am able to log in with my AD Creds to get to the FME Server GUI, but when connecting to FME Server through Workbench I am unable to log in.

Hello all,I am struggling to get the CAD layer attributes that are associated with my DWG drawing to come into PostGIS.Initially all I want to do is get the DWG into PostGIS with all the associated CAD attributes, from there I will then use it to do more validation but I am stuck just getting the first part to work. I have a DWG reader that writes each layer to the same layer name in PostGIS but not sure if I am missing something either in FME or in the set-up in PostGIS. Currently all I get is the lines or points but all the attributes are empty. Any assistance would be very much appreciated. 

FME 2019.0 build 19238 64 bit on Windows 10I experienced that the display suddenly blackouts and then FME Workbench silently closes immediately after executing the Full Screen command. Could you please test just clicking the Full Screen tool button?

Hi FME Workbench doesn't work on one of our computer. He crash when a user try to use à ASC file. We has been try to reinstall FME but nothing change. On all other computer FME work fine, and they are all install with the same package. If anyone have a idea :) Thanks. Crash log: Commencer le traitement…FME 2017.1.2.1 (***** – Build 17725 – WIN64)FME Desktop professional Edition (floating)Permanent License.Machine host name is : ******Operating System : Microsoft Windows 8.1 64-bit (Build 9600) Creating reader for format : Apic Exchange Format (ASC)Trying to find a BUILTIN plugin for reader named ‘APIC’Trying to find a DYNAMIC plugin for reader named ‘APIC’Library ‘ourAPPVpath\\FME\\APIC.DLL ‘ was found but could not be loaded. Ensure that all the dependent modules exist for this library.This FME edition does not recognize the ‘APIC’ reader. Please ensure that the current platform supports this reader, the reader name is spelled correctly, and that you have installed all required pl