Best Answers

On the FME Server VM I have setup, the 64 bit Oracle Instant Client isn't being recognized by FME Server. I have the PATH environmental variable set to the folder. I also installed Desktop on the same VM and it has no problem connecting to Oracle databases.  What else can I try? This is the error I get when running the workbench in Server:Oracle client libraries (e.g. oci.dll) could not be loaded. Ensure that the 64-bit client is installed and properly configured, and the PATH environment variable includes the file path to your Oracle client. Refer to https://community.safe.com/s/article/how-to-setup-an-oracle-instant-client-for-use-with for more informationThe Oracle Instant Client setup is the "Basic Package" Version 21.9.0.0.0 FME Server2022.2.4 Build 22792 - win64 FME Desktop2022.2.4.0 (20230303 - Build 22792 - WIN64)Database Edition

Hi Community, I'm working on a workflow that needs to write a final Feature class based on a particular hierarchy. The workflow includes a few 'AreaOnAreaOverlayer' steps + ListConcatenator to indicate which parcel overlaps which, below a screenshot with the desired hierarchy:1 - Most important parcels A2- Middle important parcels B3- Less important parcels C  I can't run dissolve + clip as need to keep the overlapping information to be 'listconcatenated' so decided to use a Sorter (alphabetical order) to obtain the desired order but isn't working 😞 as there's areas where the parcels C are on top of the parcels B. Below an example where the overlap in the middle between 2 parcels (B + C) should be assigned to B but for some reason is CThere must be a way to tell FME please write parcel A on top of parcels B and then parcels B on top of parcels C and parcels A on top parcels C. A>B>C Thanks a lot in advanced 🙂

Hi, we have a citygml file that contains a bridge. The validation by "citydoctor " showed no errors. Now we wanna extract the geometry. FME can read the file without error. But only a core element is shown and I cannot get the geometry!By the way we got the same result with the template bridge from the university (KIT)! Does anyone have any ideas or tipps for me?Thanks in advance.

So the result should be a point cloud that has points in a grid of 1m x 1m. Personally I would make a DEM with cell size 1m, but that's not what they want. So I have a boundary of the project area. I make a 2dgrid with cell size 1 meter. I clip the grid, because it's made on the hull of the project area and not the project area itself. Then I use the grid to make points in the center of each cell and also use the grid to clip my point cloud. I use the pointcloudstatisticscalculator to get the mean of the z values within one cell of the grid. So I can use the X en Y from the center point and have to add the Z from the statisticscalculator. I merge the data together based on the counter I added. Then I use the vertexcreator to make points with the correct X, Y en Z. If I inspect these, everything looks good. In the data inspector we see that the points have the correct X, Y en Z.The problem is that I can not write the data as point cloud. Not as xyz file and not as las file. I

Hi Community, Classic issue with the PointOnAreaOverlaye where I have got one location where the same centroid is shared between two parcels and want to bring the information from point to area. Attached two screenshots that explain the situation. In theory...by creating a list and exploding should work but doesn't give me what I want as the output contains 2 parcels overlaps where there're two points Example 1) I need to bring the assign the point info to each of the parcels. As you can notice the point on the left is shared between two parcels.Example 2) Also, I need to bring the assign the point info to each of the parcels. As you can notice the point on the right is shared between two parcels.I have tried to 'Generate List on output Area' and then explode but the 'element_index' and '_overlap' are different so can't use a tester to filter the list.I have also tried NeighborFinder to filter only those centroids at the middle of the parcel . Thanks

I am trying to add an ArcGIS Server Feature Service reader to my workspace. I just need one of the layers from the service. Several of the layers have the same name but are differentiated by their parent layer (which are scale dependencies). FME Desktop Help claims it shouldn't be a problem, stating "The reader resolves ambiguity by appending the layer ID to the end of feature types if multiple layers share the same name. If a layer ID is present in the feature type, the ID takes precedence over the name." That doesn't appear to be happening because I receive the following when I select my desired layer and try to add it: "ArcGIS Feature Service Reader: Found multiple layers/tables that match the feature type 'Stations, PNM (4)'. They are: 'Stations (4), Stations (10), Stations (16), Stations (22), Stations (28), Stations (34), Stations (40)'. Resolve the ambiguity by specifying the layer/table ID in the feature type." Ok, but how? I do so in

I have encountered a problem when formating a datetime. A log is raising a warning when the value is null. In order to avoid warnings in log I try to setup a condition in AttributeManager. I would like to reuse (copy/paste) the condition definition so I try to use "@CurrentAttribute". It's working as expected in Attribute Value part, but not in the test condition (see attached image).If I use @CurrentAttribute() ATTRIBUTE_HAS_A_VALUEI get <null> results despite the attribute has a value. Any suggestion how to set up the condition for current attribute correctly? 

Hi all.An I correct in assuming, that FME cannot handle non-point geometries, i.e. with multiple nodes, when some nodes have Z values, and some don't ?I'm seeing that GeometryReplacer adds dummy Z values (0) where they're missing when importing from WKT og GeoJSON.Is this a problem with the transformer only, or a more general problem with the handling of Z values ?In a system we're running on FME Server, I need to replace any missing Z values with an official fixed value: -99. This is done using the 3DForcer. But if I can't control missing Z values during import, things are very problematic.I made a small test workspace, and ran it in 2020.2 and 2022.2, and both exhibited the same behaviour.Cheers

Hi all.I have two sets of automations, where all automations in set 1 needs to be all done before initaiting all automations in set 2.I'm wondering what the best practice is for this scenario ?I tried to include an active wait mechanism in the set 2 automations, but then they just got started first, blocking the set 1 automations.I'm starting all set 1 automations with a single (topic) trigger, as they may run in parallel, and I can start all set 2 automations with another single trigger. But all set 2 need to wait for all set 1 to finish, and that I can't do with triggers as far as I know.All help and suggestions are appreciated.Cheers

I would like to insert to a Postgres table where ther is set up an trigger event with hstore function to write to another table. While running in common SQL client with "public" search_path, there is no problem.I can't make it run in FME workspace, always getting an error:ERROR:  function hstore(vfk.par) does not existwhere "vfk.par" is the table I'm writing to. I have tried to add search_path "public" setup in "SQL To Run Before Write" but with no luck. Any hints, please?-------EDIT: In another workspace with another schemas but with similar tasks it runs without errors as expected. The triggers with its functions are almost identical.

I'm wondering to what degree items uploaded to FME Hub are checked? Are they considered "safe to download" or "use at your own risk"? Imagine a wild scenario where I would upload a custom transformer with a SystemCaller in it that formats the c drive, will that get flagged or not? (and what if I password-protect it?)

Hello I’m new to FME.  How do you rename a source_file  (MapInfo.Tab) and copy it to another folder using a Filecopy writer? I've seen similar questions to this but I still don't know how to do it. I managed to replicate the Filecopy following the instructions here: https://knowledge.safe.com/articles/How_To/Including-files-dynamically-in-a-data-download-result .However, I want to rename my MapInfo tab file (which I am copying with the Filecopy) and I’m not able to do this. This is what my process looks like:  The source table is named Car_Parking.Tab and I want it to be CARPARKING.Tab  in the output folder. Landmark is copying fine and I don’t need to change the name. These two are part of a bigger workbench which copies many files.  For now Car_Parking.* is copying as Car_Parking.* to my output. I did try various things -changing the _filename_part in an attributecreator, Fanout options (I managed to create a  CARPARKING folder )- Creating a Path and file name reader... etc-

Hi when I reproject dwg file from NAD27_MTM_zone_10 to NAD_1983_CSRS_MTM_10 using Csmapreprojector, it reprojects all elements of DWG files execpts Arcs. is there any setting that handle this issue?

Hi community! I would like update a column in my table with a variable. For that, I put in a VariableSetter my value that I retrieve after a Tester and with a VariableRetriver I recall my variable, and I want to insert this value of this variable in all the lines of my Code_Comma column.But it's doesn't work.Someone can help me please ? Thanks    

Hi All, I'm very new to FME so excuse my noobiness. I'm bring in a roughly 20 shapefiles and running them through a attribute filter to pull out the ones with a matching project number, from there i'm exporting them out as a .csv.  As it currently stands all results are put into one spreadsheet. not ideal. i would like them all in one spreadsheet but as separate tabs for each individual layer. As a work around i've made each layer its own attribute filter running to its own .csv writer, then i'm copying them into a single spreedsheet.

Is there a way to create a raster of polylines, showing the counts rather than density per area magnitude? I have 17,000 lines and I'm trying to recreate the below graphic/visualization: 

I have hundreds of shapefiles in different folders and subfolders. I would like to create an excel file that shows three columns: ​Col1 = Name of .shp fileCol2 = Geometry of .shp fileCol3 = Directory/Path of .shp file For Transformers, I think I need to start with Creator - FeatureReader, then I get stuck.

I have a json-file (see attachment) that contains the coördinates of a circular route. It looks like this:{ "segments": [{  "geometry": {   "type": "LineString",   "coordinates": [    [50.814103, 4.521174],    [50.81309, 4.521811],    [50.80626, 4.536902],    [50.80482, 4.538866],    [50.80573, 4.541452],    [50.80621, 4.543173],    [50.80705, 4.545501],    [50.80755, 4.546541],    [50.80777, 4.546841],    [50.80919, 4.547739],    [50.8096, 4.548199],    [50.81052, 4.550243],    [50.810663, 4.551096]   ]  },  {  "geometry": {   "type": "LineString",   "coordinates": [    [50.810663, 4.551096],    [50.81065, 4.555264],    [50.81071, 4.555622]   ]  },... I want to convert it to an ESRI line feature class, but I'm stuck. The geojsonreader gives no error, but also no result as reader.  Json-fragmenter gives me the list of vertices in an attribute, but I can't fix it to convert these points to

Is it possible to change the name of a repository on FME server (2022 to be specific)? If so how?

Is there a possibility to suppress annoying WARN messages of the 'Autodesk AutoCAD RealDWG DWG/DXF' FeatureReader? Please see the following example:I use the AutoCAD reader to read features from an DWG file. I am only interested in the features of one specific layer (specified by a user parameter):Hence, the AutoCAD reader reads the file and skips all layers but the specified one.  In the log, the reader starts writing which layers are skipped. These messages are written at 'Information' level. After writing the 10th skip message, it writes a message "Further instances of this message will be suppressed" on WARN level. -----As text:2023-03-23 14:17:38|  1.8| 0.0|INFORM|AutoCAD Reader: Successfully opened the 'Release2018' AutoCAD file '<SOME_PATH>'2023-03-23 14:17:38|  1.9| 0.1|INFORM|AutoCAD Reader: Features for feature type '0' will be skipped based on the feature types requested2023-03-23 14:17:38|  1.9| 0.0|INFORM|AutoCAD Read

How do I Copy SHAPE column from an ESRI GDB feature class to a non spatial Postgres database?

Hi,I have a workflow where I need to forecast particular values. The formula to calculate this forecast value (in Attribute A) needs to reference the previous feature in Attribute A, but the AttributeManager doesn't allow you to reference ajacent features (in this case, previous) for the same attribute. Is there a way I can do this? I wonder if a looping process would help. Thanks

I have a request to convert some postgis geom data into TopoJSON. However they want the output to be single combined file similar to what is produced by https://mapshaper.org/ I can easily create individual TopoJSON files in FME. (Simple read postgis and connect to TopoJSON writer.) But I have not figured how I can produce a combined file with multiple objects in it like what is done with mapshaper.org site.  I uploaded sample TopoJson output files from FME and the sample combined file from mapshaper.  I figure this will likely need some type of python code, which is fine, but I'm hoping to not install any additional modules outside what FME provides.  Currently using FME 2020.2. That is what company uses. But I can use new FME version if it had options for doing this in some update.

Hello all, When will FME (server and desktop) be supported on the new Ubuntu LTS release 22.04? Thanks for your interest, Martin

Is it possible to add transfomer with PC sound notification? Eg. If unexpected path event was detected or a scound notification to the data inspector new window opening?