Best Answers

Dear All,I've a question about choice parameter in FMEServer.I've published a workbench with some parameters. One paramter is a choice list (single). When I use the interface all is ok because I can specify only the items in the list. Now, I have some procedures that call the workbench by rest api. I've expected that FMEServer checked the submitted parameters with the list in the choice list but this didn't happen. I have to check in the workbench the input paramters?

FMEServerLogFileRetriever has been extensively used in our FME server jobs since FME 2016. It simply takes a FME server job id and returns the job's logfile content. I have been doing FME server and desktop 2019.2.1 to 2020.1.3 upgrade testing, and found this transformer works fine in desktop 2020.1.3, but breaks on the FME server 2020.1.3. The error is "FMEServerLogFileRetriever (ServerLogFileRetrieverFactory): Unable to use web connection to connect to FME Server. If connecting to FME Server 2013 or older, use direct connection." Anybody ran into this issue?

Hello I'm hoping that someone could shed some lights on this issue which I'm experiencing and not related specifically to FME 2020.2 So basically if I make a change in a Reader / Writer, i.e. changing the path of the destination then (Re)/Publish the workspace, I can see the changes made in FME Web UI but in Automations, the settings remain unchanged. That is problematic. I changed the DFS path from "MVGIS02-Data" to "GIS-Data". FME Server WebUI Automations Log Similar behaviour occurs when a Writer's connection is changed in Desktop then Published, FME Server does not pick up the change. So I'm having to replace the existing Writer for it to work. ThanksSameer 

Every single time I try to log into the FME server I get a failed login. The second time it succeeds.Every time. Unless i leave chrome open. Then I can log out and log back in without a problem.Using LDAP. No other issues with LDAP anywhere. This is always the message:"LDAPException(resultCode=85 (timeout), errorMessage='A client-side timeout was encountered while waiting 10002ms for a response to simple bind request with message ID 2 ....." A time out message and authentication failed.I did a little reading on it and found a bunch of inconsistent java mumbo jumbo. Anyone have ideas on how to fix this? Its super annoying. Thanks!!

I have 1000 users who I have created user accounts and have their details in a excel sheet.The excel sheet contains their username and password along with email.I am trying to figure out what is the easiest way to send each user their username and password without individually doing the task. I am struggling to understand where to get started with this apart from using the emailer option.  This is a possible example https://www.extendoffice.com/documents/excel/3560-excel-send-personalized-email.htmlThank You

I'm using FME Desktop 2020.2. I have added a CAT reader and set the boundaries and attribute names. I needed to change the attribute names so I used Update Feature Types - this was correctly reflected in the reader on the workspace, all of the new attribute values are displayed. However, if I go back to the Update Feature Types to make any other changes I'm shown the original attribute names and attribute types from when the CAT reader was added. It did not save the changes correctly. I noticed an earlier post about this which was resolved in 2016, so not sure if this is similar or if there is something else I'm missing. Thanks for the help!

i have a number of .bat files that launch python files. im trying to replace windows scheduler with FME and i am having trouble figuring out how to schedule a new task. i am using FME Workbench 2020.2.

HelloI want to do the samples of https://playground.fmeserver.com/by myself. Is there a demo or test server available? I want recreate the javascript and python samples. 

I have a CSV file with attributedata that's structured kind of like this: apple man woman 1234-567\\1apple man woman 1234-567\\1Bapple man woman 1234-567\\12apple man woman 1234-567 child 890.1234-567apple A3 1234-567 I'm only interested in the 1234-567 number sequence, since this is an ID I need to match further along. The rest of the attribute data can be deleted. The number sequence seems to always have 4 numbers before the hyphen and 3 numbers after. The hyphen isn't essential and can be removed. The number are the most important How do I go about it? Do I need a stringreplacer or more than one?I tried this with stringreplacer, mode= regular expression, text to change set to: (?<!\\\\)[0-9]+But what do I fill in at replacement text? If I fill in a regular expressions in that field, it returns the regular expression...! I'm using fme desktop 2019  

Hello, After struggling with several transformers, I can't figure out how to simply remove duplicates from 2 identical Excel files with exact same column names, etc ... but with different numbers of rows. First file contains 3130 entries and second one 2926. What I want is to be able to extract the 204 missing lines to check their differences. In my small brain, a simple transformer that checks missing entries between two columns and group them in an inspector should exists but it seems not to be complicated enough ... ;o) Thanks for any help

Dear community,I have a table with two records for which I want to get only the record where _min in row 2 is less compared to _min in row 1 (or using _max). Hence, for the table below I want to get the second row and all attributes from that row. Any ideas? 

I see the file geodatabase writer has pre and post writer SQL options. So I assume I can do some deletion before inserting. Can I do "delete from table where attribute = 'attributeValue'"? Not sure what the syntax should be. 

 Hello, Is it possible to view the html dashboard pages outside of the FME Server admin pages? For example I am intrested in writing a custom dashboard to FME Cloud and would like to share a direct link to it with some users, without requiring them to log in to FME Cloud/Server etc. and dealing with the UI. Is this possible? Thanks.

Since there is a limit on download I need to add a search envelope on my WFS and WMS import. I got this working in 2 ways: using the search envelope in the parameters of the reader or the XML filter expression. "<Filter>  <BBOX>   <ValueReference>Geometry</ValueReference>   <Envelope srsName="urn:ogc:def:crs:EPSG::31370">     <lowerCorner>159221.09606242698 220934.16757763177</lowerCorner>     <upperCorner>160221.09606242698 221934.16757763177</upperCorner>   </Envelope>  </BBOX></Filter>" My question is how I can use calculated coordinates as an input for this reader. Since the coordinates of the bounding box will change.(I know it has something to do with user-parameters but I can't get any number in the expression or parameter of the search envelope.) Thanks

It seems to me like I'm looking for a transformer very similar to the ExpressionEvaluator with 'Evaluation Mode' = 'Overwrite existing Attributes', only without the numeric evaluation (that doesn't seemingly 'wrap' the expression in a arithmic editer). I thought about posting an idea about this (e.g. create new transformer or add parameter 'evaluation mode' = (text|arithmetic) to ExpressionEvaluator), but just wanted to check if I'm maybe overlooking existing functionality. Attached is a workspace that illustrates the numeric evaluation possibilities in the ExpressionEvaluator, and an example of how I would like to have the option for a 'text evaluation' possibility to e.g. add '_concat_@CurrentAttribute' to each attribute in the selected group.  

When I use any SQL reader if I limit the attribute in the "User Attribute" tab with the option "Exposed Attributes": FME seems (regarding perf) to use a query like "Select Attrib1, Attrib2 from..." in place of a "Select * from ..." when I use Feature Reader It fetch all column even if I output to generic port and expose only some attribute. I have some Huge binary and text collumn that I dont need and I fetch thru a slow connection. Any Idea ?

Hi! I'm trying to define the encoding for my shp but directly on the dbf and not on the cpg. I choose UTF-8 on the parameters and I always have a .cpg file. I looked on the shp writer help and I saw this sentence :"The output Shapefile .dbf will contain the language driver ID for the selected or detected encoding, if no language driver ID is available for the encoding, a .cpg file may be generated instead." I don't understand what is a "language driver ID ". Can you explain ? Thanks!

Hi,I have been using FME 2020.1 for about 6 months now and suddenly today the Feature Count numbers disappeared while running a workbench (and after the workbench finished running). The Feature Counts appear if I run the workbench in Feature Cache mode, but not in normal mode. I'm not sure if I unknowingly changed a setting but I didn't think I did. I am using version FME(R) 2020.1.1.1 (20200817 - Build 20614 - WIN64).Has anyone else encountered this problem?

I am wanting to search a PostGIS database using a Contains or Like query to search strings for a partial match. My last attempt is proprietor_1 LIKE '@Value(Name)' I also tried CONTAINS(proprietor_1, '@Value(Name)') proprietor_1 is in my PostGISName is in my routine Any assistance with queries would be great.

Consider for example the case with a FeatureMerger or a FeatureJoiner. I have always been wondering how the groupBy is executed here. Is this on a single port (e.g. Requestor or Left) or across multiple ports. Especially in combination with the option 'Process when group changes'.  I made a small illustration workspace, with the merging application inspired on 'a hiccup' I came across today where I wanted to accumulate incoming attributes at a 2DGridAccumulator, but there is no default field/option for this (an idea on this was already created, see; https://community.safe.com/s/idea/0874Q000000TlLbQAK/detail).  To see differences in results, I changed the order of the features entering the supplier input port of the FeatureMerger, and for whether features should first route to the Requestor, or first to the Supplier port. In the cases when the feature order going to the supplier is changed (case 1 and 2), I see that most features don't merge, but I don't underst

I would like to rename a large dataset of many columns using a lookup file (csv or xlsx) - is this possible? I have explored the ..Mapper transformers, but am unable to get them to work in this way. The only method that appears possible at the moment is through the AttributeRenamer, but am finding this rather tedious entering one by one. The Import facility on this transformer only appears to name Input and Output Attributes with the same names when I use it.Happy to be corrected in my use of this transformer!The column name lookup I have structured in a spreadsheet as below;

I have been trying to report an issue related to a backup file which is bigger as the 5MB. Following https://community.safe.com/s/article/upload-a-file-to-the-safe-software-support-ftp I have tried to upload the respective file through the given `curl` command. But whatever I try, I keep getting "Failed FTP upload: 553". I tried both zipped and unzipped, where the zipped file is around 6GB. Is there anything I can do to overcome this and continue with problem report?

I have a workspace that I am running locally on my computer. This workspace is connected to an sde database on Amazon EC2 instance. This workpace is very simple translation just a reader and a writer, the purpose of the workspace is to completely delete all features from the sde database. However when I publish this workspace to FME Server the translations fail due to this error. 2020-10-18 05:39:39 | An error occurred while attempting to open the table,[...]. The error number from ArcObjects is: '-2147216057'. The error message from ArcObjects is: {Invalid parameter value passed to function}2020-10-18 05:39:39 | It could have failed to open because it contains ArcGIS Pro-only features, for example Arcade expressions. If this is the case, please install ArcGIS Pro or Pro-compatible ArcGIS Server and 64-bit FME Has anyone had an error like this before? I just don't know why desktop workspace works fine but once it is published to FME Server the workspace no longer functions,

Hi All, I have a Child workbench which takes input as SDE FeatureClasses and Creates FGDB. i am passing all feature classes dynamically to the writer (all different types like points, polygons and polyline featureclasses). My SDE Feature Class has Long Attribute(Fields) Names and I required to create FGDB Feature Classes with Short Attribute(Fields) names. I have a web service which gives JSON output of Short Names. For each feature class, i need to connect to web service and get short names, create FGDB feature class with these short names. Could anyone have an idea how can I dynamically update FGDB feature class?

Hello,this was supposed to be an easy one, but I can't figure out how to detect overlapping polygons. Why is there no "Requestor Overlaps Supplier" in SpatialRelator according to this spatial predicates. How am I suppose to detect overlaps?