Best Answers

I have to write multiple consecutive datasets (adjacent tiles) to Aircom Enterprise files.Is there any possibility to merge new data of adjacent tiles to the existing clutter file in the folder instead of overwriting it?

Hi, I have a workspace that snaps my "From-To"-line to the end-point, which is working fine.However, I have some adresses which I want to route to the nearest object. So therefore I would want to start the line from the nearest position possible in the network, not from end-point (because the distances can vary very much between them).I´ve tried the "LineDivider" to create more lines and therefore get more end-points, which works, but seems to be a little bit over-worked.Is it possible to snap the "From-To"-line to a vertex of the network (instead of the end-point) in any other way, run the "ShortestPathFinder" and get a result?  (I´ve tried the "AnchoredSnapper" with "Vertex snapping", but that only generates a "NoPath").It seems odd only to be able to find the shortest path from end-point to end-point. 

Hi there,I have a text file containing 1 line with a length of ca. 40 billion characters. I need to parse the line into seperate lines, each 256 characters long.I have tried multiple configurations looping with the AttributeSplitter (to parse the lines into a list and write it ) in conjunction with the StringReplacer (to erase the characters parsed) but I keep hitting resources limitations, mainly memory.I am running it on a 64bit OS machine with 16Gb RAM, but apparently that is not enough.Has anybody done something similar and can share some insights on how to keep the memory eating capacity of FME down to the minimum?Is there a better way to parse the file, than standard FME transformers?Any help is appreciated.Itay

Hi,How can I split a large dataset into multiple CSV datasets?I have to split them so that each record contains max 5 million datas (rows).I have about 25 mils of data. So need to have about 5 separated CSVs.How can I set the writer (or reader) or maybe which transformer ta add to splitt them after writing 5 mils of them?Thanks a lot!

Hi,I tried several times to get a flat table of this JSON-File: . It comes out of an API-Request and has this structure:Target is a flat table with this columns to be able to join it with the corresponding shapefile:stundebstidheighttimesliceWIND_6HRISK_WINDBREAKAGE_BEECH_MAX_6HRISK_WINDBREAKAGE_SPRUCE_MAX_6HPROB_GUST_100kmh_MAX_6HPROB_GUST_75kmh_MAX_6HPROB_GUST_60kmh_MAX_6HThought about something like this within the JSON-Extractor:But can't get it to work like I expected.Looking forward to your help.Best regards, Christoph

Hi all, I'm trying to detect the changes between the on premise data (SQL Server 2017) and AGOL (ArcGIS Online) data. The schema is the same, of course the field types are slightly different.  I've noticed that ChangeDetector is constantly reporting a large number of changes, and closer inspection highlighted the problem, that the GEODATABASE_SDE reader into the sql server is reporting that the datime2 field type (CreatedAt) is of type date in FME reader, and is actually truncating the data into the date only.  So if let's consider a single record:FME reads it  from AGOL: 20190101000000  from DB: 20190101SQL Server reads it as 2019-01-01 00:00:00.0000000  Hence reporting is as a change.  How can I force the reader to use datetime2 instead of just date?

Hello,I am curious of there is a setting or ability to ignore "insert errors" related to primary key constraints in a SQL Database. The workspace writer is doings its job by not allowing duplicate keys to be created but I would like to override/ignore these errors to allow the workspace to continue and finish successfully.I know I could use an UpdateDetector or reader from the destination to prevent these inserts from hitting the writer but this will really slow down the process to read all existing records to perform this compare. I was hoping to set a SQL writer or workspace property to allow the workspace to continue when a duplicate key is encoutered. Any tips or techniques for this situation without actually reading the destination and comparing the input records?Thanks Ronnie

Hello.. I was wondering if it is even possible to create a time lapse map scene for construction happening across BC over time. Please have a look at the snapshot of the video. This is something i am looking for. Any ideas folks?Thanks in advance

i have group of values with different color codes. When I run the transformer, it considers only first row color for all bars. Actually Bar colors should vary based on color attribute , Really appreciable if anyone can help on this ?

I have a long running workbench on the FME server. Is it possible to take actions if a job submitted is canceled?proposed workflow1. submit a job2. cancel a job3. write into a file information regarding the job that was cancelled (is possible to do it inside the same workbech? is possible to do it with another workbench? a subscription could help??) [EDIT]:The idea is that step 3 is automatically triggered after the cancellation of the job, that is what I mean by "React".[EDIT]: I am using FME Server 2018.1.2 - Build 18590 - win64: I notice that JOBSUBMITTER_ASYNC_JOB_FAILURE topic is not triggered when a job is canceled.thanks for any hint provided. 

Hi there,I've been using the adjacent feature functionality and I'm really impressed with how useful it is once I wrapped my head around it. However, I'm a little stuck now.Here's an example of what my data looks like:WeekPlaceLength% Difference1Village1298938.438-2Village1299198.1190.023Village130032.0970.091Forest11038.854-99.152Forest11036.975-0.023Forest11140.5470.94 So the "% Difference" I'm calculating via adjacent features in an AttributeCreator (Just to get the % difference of length based on the length of the previous entry:New AttributeAttribute Value% Difference@round(@mult(@div(@sub(@Value(Length),@Value(feature[-1].Length)),@Value(feature[-1].Length)),100),2)  This all works perfectly and exactly as I hoped for, except the issue of having "99.15 % Difference" when going from Village to Forest. That number is huge and not actually something I'm interested in, as I want it to "Start over" once it gets to a new "Place

Existing FME Desktop and FME Server version 2015.1 will support Windows Server 2019??

We recently upgraded from 2018 to 2019.1.3.1, a workbench that worked fine in 2018 is now have python issues both in Server and desktop. What could have changed and anyone know how to fix it?   2019-10-29 10:37:06| 46.1| 0.2|FATAL |AttributePivoter (PythonFactory): PythonFactory failed to close properly2019-10-29 10:37:06| 46.1| 0.0|ERROR |BADNEWS: A fatal error has occurred. Check the logfile above for details auto __thiscall STFDynamicFactory::doneAllGroups::<lambda_faaa637947b31c6de3e253c564f4e0ca>::operator ()(void) const(c:\\code\\fme\\foundation\\pluginbuilder\\pluginbuilder_cpp\\dynafact.cpp:169) - auto __thiscall STFDynamicFactory::doneAllGroups::<lambda_faaa637947b31c6de3e253c564f4e0ca>::operator ()(void) const(c:\\code\\fme\\foundation\\pluginbuilder\\pluginbuilder_cpp\\dynafact.cpp:169)2019-10-29 10:37:06| 46.1| 0.0|ERROR |AttributePivoter (PythonFactory): A fatal error has occurred. Check the logfile above for details2019-10-29 10:37:07| 46.5| 0.0|ERROR

Hi,I'm attempting to connect to an AWS S3 bucket from FME desktop (2018.0). (Colleagues have informed me that the situation is no different in FME 2019). The system proxy settings are controlled via a PAC file as part of group policy. I know that the proxy is NTLM, and as far as I can tell there is no way that FME can pass on authentication credentials correctly and so connections are always refused. I have tried the various settings within tools>FMEoptions>Network Proxy> but I always receive the same connection error -'Unable to execute HTTP request: 'I can navigate to the bucket via the browser with no problems. As at here https://knowledge.safe.com/questions/31838/s3uploader-and-network-proxy.html is it simply the case that the S3 tools do not work with an NTLM proxy? Is the only alternative (in my case to pay for) a proxy authentication bypass?

Hello, I am looking for a way to generate a precision code for GPS coordinates of parcel fabric. Is there any way to generate a code for the accuracy of coordinates like a range of number for example 1-7 where 1 signifies most accurate while 7 signifies least accurate.. I am re projecting my data from to LL84. Any suggestion?

I want to open version 2015 FMW workbench file in 2019 version. Is backward compatibility will support?

Hi, I'm trying to calculate average response times for my city's fire department. I'm not sure which transformer is best to use? I've used the date time converter to change the data that is coming over in seconds to minutes but then I need to do a) calculate the average of those individual response times and/or b)subtract the difference between two fields and then c) calculate the average of the difference.  Thanks in advance for any help. 

Hello,I have a workspace for converting DGN vector data into a LandXML surface file built by a fine FME support tech. It works great, but I'm now noticing that the coordinates in the output file have 10 decimal places. We really only need 3 places, which would shrink our files dramatically. I tried adding the coordinate rounder in a few places, but the final coordinates are not changing. Not sure where to look to fix it. I'm not able to add attachments or I would attach my workspace (nothing happens when I click on "attachments). Thanks!!

Hi All,I could use some assistance on the problem I am facing.The data I have looks something like this.RA, B, C?, ?, ?I want it to look like this.RA?RB?RC?How would I go about doing that? Regards,

Is there any way to integrate linkedin and facebook with the FME 2018? Make searches for words identical to the tweetSeacher transformer..

Hello Community, i'm struggling with this Question:Is it possible to write a B3DM-File (Writer: Cesium 3D Tiles)from "KMZ with Textures" to "Cesium 3D Tiles WITHOUT Textures" ? If the answer is YES - How should my workbench look ? With best regardsMichael.

I have a workbench that tries to write features to an existing hosted feature layer in ArcGIS Online and also to an enterprise geodatabase. The enterprise GDB write is successful but the AGOL write fails with some odd errors about needing to reproject the data (which makes sense since AGOL uses WGS 84 Web Mercator Aux Sphere and my data uses our local StatePlane projection). I added a Reprojector transformer (tried both the regular Reprojector and the ESRIReprojector) and both don't solve the issue.What makes this really weird is that in earlier steps in my workbench, when I click on the inspector icon in any transformer available, the visual preview shows up for about a second, then suddenly the transaction log pops up and shows "Worker <some 4 digit number that always changes>" then a few lines of generic info about coordinates of a single record. Here's an example:Are these issues related? Am I doing something really wrong?

Hi, By default autocad_line gets writen in Autodesk DWG/DXF as line if it has 2 vertices or polyline if it has 2 or more vertices according to https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/acad/Lines.htm  Is there a way to treat and write lines as polylines regardless of number of vertices in Autodesk DWG/DXF. Cheers,Želimir.  

Everything is in the title, I have several operations on a single input dataset branching through several levels of operations. Ultimately I have some mongodb writers and python callers loading transformed data. I want to be sure that one python caller won't start before another one has ended (the first one will create documents, and the second one pushes elements into arrays within those documents).

I have a process that writes a number of text files. Just figured out how to populate an email with a number of pieces of information about each runtime, time, feature count, etc. But it's basically sending the email in parallel with the writer finishing up. I would like to have the writer trigger the email, similar to how it's described here.https://knowledge.safe.com/questions/4963/sending-mail-in-fme-desktop.htmlI can replace my TXT writer with a feature writer and write to TXT but there appears to be no fanout feature with the FeatureWriter? if that's so, is there another way to have the email kick off only after text writer completes?