Authoring

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

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’ r

Hi- I have a lookup table I'd love to FeatureJoin in somehow, to rename the original columns to what's shown in my external lookup table. Unfortunately there is no predictable pattern to the renaming, so I can't realistically use BulkAttributeRenamer to do a pattern/rules-based renaming. . and at 118 columns, am hoping not to have to use AttributeManager or AttributeRenamer addressing each column manually. Any suggestions for using an external lookup table to do this? Thanks in advance!

In my workbench, all "Not Merged" / "Rejected" paths etc, redirect to a FeatureWriter that logs errors to the database.However, the PythonCaller only has the "Output" path - how would I capture and log these exceptions?Could I do something like this?Update PythonCaller to Catch the Exception and store detail in an Attribute (don't raise exception) try: ...except: feature.setAttribute("Error", sys.exc_info()[0])Use Tester to check if Error Message existsFork based on Error contentsWire-up to exception-logging path

I've been having trouble with FME 2018 and database connections. I don't want to move to 2019 because my company's FME server is 2018. FME 2018 build 18552 works on my other machine which has previous versions of FME installed. I've been working with a previous post with no success: https://knowledge.safe.com/articles/65806/workarounds-to-known-issues-in-fme-2018x.htmlAny other ideas?

I have a scheduled workspace running in FME Server. Upon success or failure, it posts to the same topic that runs another workspace. This workspace uses the FMEServerLogFileRetriever to pull the Feature Written Summary and then uses the FMEServerNotifier to run another topic that sends an email with the Feature Written Summary as the content. Right now, I'm querying the last job_id run in the fme_job_history to get the info. But, if more that one job runs at the same time, the logic gets a little fuzzy. It would be better if I could just pass the job_id from one workspace to the next. Is this possible?

Hello FME CommunityWe are currently doing an FME Server upgrade and I would like to confirm an assumption - I haven't found this information on the forum or documentation yet, so it may have been implied already.I am wondering if we can upgrade and keep our old Job history / logs from the old version? (We are currently running 2016, and upgrading to 2018)Since the Backup / Restore didn't restore job logs to our Test server, and it also wouldn't make sense if old Job IDs are duplicated in the new system, I'm assuming that they will not be saved automatically.Thanks!Ray

We have excel sheet with so many mappings ,Users will provide 3 inputs and based on the mappings it will generate 2 outputs. Please let me know if FME can be used for the above task ?  Thanks! Regards,Vighnesh

I am try to make a web connection between FME and OptenText Content Server. But still don't succeed. The thing is, I need to get data from the content server using REST API then manuplate it in FME. This link is to the Content server API references ( https://developer.opentext.com/webaccess/#url=%2Fawd%2Fresources%2Fapis%2Fcs-rest-api-for-cs-16&tab=501 ). Did anyone of you guys make this connection or can give me hints on what should I do?

I have a workspace with a published parameter setup to receive a name from the user that is then appended to the file name in an Excel writer. It works just fine in FME desktop, but when the workspace is published on FME Server it doesn't.In the writer destination file I have ./Filename_$(value).xlsxIf I set the value parameter to "apples" FME Desktop generates a file named Filename_apples.xlsxFME Server creates a file named Filename_$(value).xlsxDo I need to use escape characters or something to force FME Server to use my parameter?FYI I'm using FME Server 2018.0 and publishing using the same version of FME Desktop.Not a critical issue, but I'm curious why it's not working.Thanks

I'm wondering how others go about managing FME's Database Connections in their environment. Imagine you have hundreds of SQL Server databases. Most are named users... some are Windows Users. Passwords are changed from time to time and this presents a problem for managing the named users. One solution is to have one domain service account that can access all the different databases (on different servers, with different instances, and then the database specific permissions for this user). This is a heavy task for the DBA to set up but once it is set up, authentication from the FME engine takes care of itself and the FME admin doesn't have to manage the connections for the purpose of password changes.The other way is for the FME Admin to manage the changing passwords inside of FME's Database Connections command. This is a daunting task when dealing with more than 200 databases. Are there other ways you can think of to managed ch

I have a unicode string that looks like:Lat: 49° 16.578', Lng: -123° 7.3'In a standalone Python script I can find the unicode characters by putting this at the top of my script:# -*- coding: utf-8 -*-However, this doesn't work in the PythonCaller. Is there a way to do this?

I have a PATH reader reading in a folder named base which contains a folder named folder1 that contains some txt files. I have a filecopy writer containing the location where I MOVE folder1 to. I have an attributecreator to modify the filecopy_dest_datase attribute to folder1_datetime.Each time I run the workspace, the folder1 and its contents are moved to the new location named folder1_datetime - looking good. The problem: an empty folder named folder1_datetime is created in the same location as the fme workspace .fmw file. Why is this empty folder created in the location of my workspace?Thanks,Alex

I am trying to delete features from two SDE feature classes using a list from a spreadsheet. One table works the other one does not. I have tried both a feature writer and an SDE writer. I get an access denied error. I have even used the schema owner and still get the access denied error. The transaction type is set to versioned edit session. Any idea as to what I am missing?

Hello FME community,In order to configure HTTPS we followed the steps in the admin guide at http://docs.safe.com/fme/html/FME_Server_Documentation/Content/AdminGuide/configuring_for_https.htm. After this configuration we get an error on running services with the GUI button: "There was an error submitting the job." We've looked at the following troubleshooting guide: https://knowledge.safe.com/articles/49624/fme-server-and-https-troubleshooting-guide.html, however we couldn't explain the error message. Does anyone know a solution for this error message?