Best Answers

Hello,my first problem: Writing a GeoJSON in the right order. Simple example:I want a output in the order A,B,C (like I set it in the writer). But the GeoJSON file is A,C,B, because the first row in B is empty. Second Problem: When the B column is empty. Only A and C is written. How can I get an empty column in the writer? Thanks for your feedback!

I would love an example workspace if possible.

FME Server 2017.0 Does anyone have insight on what permissions are required for the FMEServerJobWaiter to work? I have tested with other admin level users and there are no issues using this transformer. FMEServerJobWaiter(ServerFactory): <servername> - Waiting for job #384798 to start; polling every 10 second(s)...FMEServerJobWaiter(ServerFactory): <servername> - Failed to wait for job #384798FMEServerJobWaiter(ServerFactory): Reason - user '<username>' is not authorized to perform this action

Hi all, I have an issue in new FME. I'm trying to set up User Published Parameter that will give user list of attributes available in workbench. But after choosing a Type: Attribute Name it doesn't see any attributes available. As my input I use shp files. Is it a bug or I didn't do it properly? Regards

Hi I have two tables, one with sites (2000+) and one with various Planning Allocations each with a Field specifying which it shows. The sites and allocation areas do overlap each other I need to find the percentage of each site covered by each allocation, 0 is unnecessary as an output It is expected that the percentage will exceed 100% in some cases (where a site is allocated twice) Any help with this would be great Thanks in advance Adrian

Hello all,I am trying to join lines that have the same bearing (angle) but I am finding that the orientation of some are reversed.I have created two attributes bearing and back-bearing and have been successful joining based on one or the other when they are oriented the same way, but am stumped how to join when the orientation is different. In the example below the two pink lines are the same (but reversed) angle)The above shows the bearing in the first is equal to the backbearing in the second  Any assistance would be very much appreciated.RegardsDean

I need to make an export of my data with a format like this:   I want the output to be in seperate files (fanout) based on a single row value per group I grouped the data by groups, so each group has unique attributes. How I can fanout and get the filename to be a single row attribute? ('bestandsnaam'), so in this case '504.pfrl' 

Hello, We were using fme server 2016. Now we moved to 2019. We tried it with FME REST API v 3 and it works great but my question is:  Is FME 2019 compatible with FME REST API v2? Can I communicate wit hfme 2019 using rest v2?  Thanks for help with that.

Within more than 2500 Features in one Polygon shapefile I used a SpatialRelator Transformer to find out intersected polygons followed by ListExplode Transformer. The result as following example:  My target is to select intersected features of highest related_candidates number (3 for above example). In some cases the highest related_candidates is 4 or more.Does anyone have any ideas or potential solutions? @mark2atsafe @egomm @david_r @jlutherthomas @jdh @takashi @redgeographics @danilo_fme

Just want to confirm when the Windows version of FME Desktop 2019.0 sends https connections from httpcaller, does it use the Windows Certificate Store or the CA Root Certificates from Mozilla? I have the impression that the Windows version is using the Windows Certificate Store. However, I saw the message "added 135 certificate(s) from CA file 'C:\\Program Files\\FME\\ssl/cacert.pem'" Thanks, 

I've got an excel spreadsheet of data with a primary key column, a foreign key column, then various other columns that may or may not contain data. I'm trying to create a single attribute that lists all of the columns/attributes that do not contain data for a given PK/FK combination (i.e., are null/empty/missing).PKFKAttribute1Attribute2Attribute31A DATADATA2ADATA  3BDATA DATA4BDATADATADATA So the output would look like this...PKFKList_of_null_attributes1AAttribute12AAttribute2, Attribute33BAttribute24B  Any ideas? I can't seem to wrap my head around this. My first thought was to attribute all null/missing/empty attribute values with a unique identifier, then replace all real data values with an empty field so that I can drop those attributes with a ListConcatenator.Right now my workflow for that includes a NullAttributeMapper to replace null/missing/empty values with a specific unique character (lets say "X"), a stringreplacer & regex to replace all data valu

Hello Team,Present i am working on the FME Version: FME(R) 2015.1.1.0 (20150715 - Build 15515 - WIN64). I could able to zip a downloaded file through HTTPcaller by using feature reader and single writer(text file) in independent workspace. Selected output as compressed Zipoutput in the writer parameters.But when i did the same thing with my master workspace which is having a custom transformers and ArcSDE writer at that time i am getting output as text file with the .zip extension which is not compressed. I assume that output just updated with .zip extension and it got corrupted. Can somebody help me to resolve the issue?? Thanks..Nagendra

Hello Team,I have archived a .jxl using ZipArchiver, After zipping the required file can we delete input file from source location.Thanks,Nagendra

Hi FME Community!My goal is to construct CityGML Terrain model (dem:TINRelief) from really accurate TIN data created with 3D modeling software.I have found certain ways to construct CityGML Terrain with FME but it always starts with generating TIN surface with the TINGenerator. I don't want to construct TIN again in FME environment. Because if I do so, the TIN is not anymore as accurate as it was in the beginning. Is there any other way to get CityGML Terrain model than generating TIN again with FME?

Hello I have just upgraded to FME Desktop 2019.1 and am getting a few errors when running a published workspace in FME Cloud.How is FME Cloud Upgraded? and is it necessary to keep the two in sync?

I have a process inside a PythonCaller that converts a long pandas dataframe into a wide dataframe that when output, has around 200 columns. The dataframes are transformed back into an fme feature for output. Now I need to expose all 200 column names but need to avoid doing this manually. Is there any way to do this from within the PythonCaller?

I upgraded FME Server to 2019.1 and my streaming services are failing. It appears that 'FME_SERVER_WEB_URL' in the request did not pick up the change when I enabled HTTPS during the install. It is still showing the original HTTP url with Port 8080 (http://SERVERNAME:8080). Is there another file besides fmeServerConfig.txt that needs to be modified? I have a distributed architecture deployment: All components are on a single machine except the Web Services component, that is on a separate machine. I upgraded from 2019.0.1 to 2019.1 and now my streaming services are not providing an output. Thanks in advance.-Mark

I'm testing out the new automations in FME Server 2019 and I am needing to chain workspaces together while passing parameters (file outputs) between them. I am not finding a way to do so without using the FME Server Job Submitter transformer that I have used in the past. Is there a way to pass parameters between chained workspaces in the automations rather than using the job submitter transformer?  I've gone through the tutorials here: https://knowledge.safe.com/articles/87453/getting-started-with-automations.html , but haven't been able to figure that out.  

Can anyone tell me what kind of error this is?CSV reader: Detected excess data and/or delimiters in addition to the defined schema in line 3523 with value '3.53,0,3.53,0,0,0,0,3.53,0,0,0,130299203063,258,201903,0,0,0,0,0,0,0,0,0,0,0,0,0,3.5682002,2302,201903,0,0,89.33,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,42.3025,-83.40304' read from file 'P:\Office Depot\FME Workflows\Local Update Workflows\Sales by BG by Store\Workspace Runner - 7h\3. Workspace Runner\Outputs\Sales_by_Store_by_BG2.csv'.  Excess data will not be read.  This can occur if the file is not uniform in the number of fields per row or if fields have been intentionally removed from the source feature type.  In order to read the excess data, recreate the source feature type and set a larger value for the 'Maximum Rows to Scan' option to scan additional rows for fields.  If the file contains field names, ensure that the field names line represents all of the columns in data rows, or enable the 'Scan for Additional Fields' option.

Using BinaryDecoder; Error: "BinaryDecoder (TextEncoderFactory): Invalid Base64 character 'ÿ'"  Any suggestions?  What to de instead? (using FME 2018 and 2019.2 beta)  Thanks for any help, Marion

Hi,if I click on "Topic monitoring" in the fme server portal I get the error:"There was an error connecting to monitoring service"The port 7078 is open and if I request http://fmedev-test.de:7078/, I get the answer "not a WebSocket handshake request: missing upgrade". So the firewall rules should be right and a telnet command to fme server via 7078 also works.I've also set WEB_SOCKET_SERVER_NAME inUtilities\\tomcat\\webapps\\fmeserver\\WEB-INF\\conf\\propertiesFile.propertiesThe logs from websocket.log in publishers and subscribers are:Opening log file using character encoding UTF8 Tue-13-Feb-2018 02:45:58.721 PM INFORM main 801001 : Publisher "websocket" is starting up ... Tue-13-Feb-2018 02:45:58.721 PM INFORM main 801002 : Publisher "websocket" is updating configurations ...Opening log file using character encoding UTF8 Tue-13-Feb-2018 02:45:52.909 PM INFORM main 803001 : Subscriber "websocket" is starting up .

Hello I have two tables below   This was done in excel, in essence, I want to assign the Pos_ID from the first table to the PosKey in the second table depending on the values on the date/time column on both tables. Is there a way to do this in FME? Thank you 

Hello,I'm trying to find an elegant solution for a feature merge based on the same list, twice.So, data is a shapefile with polygons as features. Each polygon have a _class{}.ID list. The goal is to compare each _class{n}.ID to other polygons (not itself) _class{n}.ID (nmax is different for each polygon), to finally agglomerate their geometry.Issue is that ListBasedFeatureMerger takes attributes as supplier key and not lists.Example:NAME _class{0}.ID _class{1}.ID _class{2}.ID Oscar 27 92 1 Tango 1   Charlie <Missing> <Missing> <Missing> Golf 22 12  Whiskey 92   Hotel 137 4 6  So here, Oscar, Tango and Whiskey would be agglomerated.How could that be done ?Thanks

Currently I am busy with a 4.5 GB point cloud. I want to classify this point cloud into ground points and vegetation points.I tiled my point cloud into tiles of 500 x 500 m and assigned an unique TILE id. Now I wanted to run lasground on the separate point clouds resulting from the tiler using parallel processing. However, it seems that there is no option for this available in the lasground transformer. Is there a workaround for this?

While using FME 2019.0, I have noticed that I now get the following error when trying to write a datetime to a file geodatabase date field."An error occurred while attempting to convert the '' component of a date. A possible reason for this is that the data in the date field may be corrupt"This is not an issue in version 2018.1 or if I write to a text field instead in the 2019 version.I do use the following in an AttributeManager to reformat the datetime"@DateTimeFormat(@DateTimeParse(@Value(Date_Created), %s), %Y%m%d %T)"If I drop the "%T" part then it works but I no longer get the time which I would like to keep.Is anyone else experiencing a similar issue and/or found any resolutions?Regards