FME Form

Is it possible to write an AutoCAD Map 3D dwg with an attached FDO connection?I have a library of predefined .layer files containing the connection prepared.

I am migrating data and are using a dynamic workflow. When I am using the PostGIS writer it run smoothly. But since i need post processing after writing to DB I sat up the FeatureWriter identical to the PG one. But the writer fail du some encoding issues on attributes with Nordic characters in their nameFeatureWriter (WriterFactory): POSTGIS writer: Internal Error: Failed to copy attribute 'FØRSTEDATAFANGSTDATO' to 'fã˜rstedatafangstdato'I cant see this being about case sensitivity since there is no issues using the regular postgis writer.Any ideas how this can be solved? Looks like a bug to me? 

In FME Desktop 2019.2 b19825, the Microsoft SharePoint List Reader/Writer offers SAML as an authentication method for reading from our corporate SharePoint sites.   This method is now absent in 2021.2 b21784 and none of the other authentication methods seem to be working for me. Why was this option removed and is there a workaround to getting FME Desktop to connect to SharePoint sites using normal SPOL credentials.  

I need a polygon or closed polyline of the extents of this data; using max and min (x,y) gives a bounding box which means further down my pipeline, data is being written to areas that should take "No Data". How can I grab extents from the point cloud to use it as a breakline? Pictured; point cloud, and point cloud overlaid raster output, showing data written outside the point cloud extents

Hi, We have tables of values with colors in Excel that we would want to integrate in a mxd.I though to export them automatically in jpeg files. It would be easier after to integrate images in mxd.How could I do that with FME? Thanks !

i want to merge multiple pdfs in order sequence and in one booklet how i can do please help me

I was following to do a tutorial on "Extracting Data within a Clipping Polygon using FeatureReader" but I do not know how to create published parameters from the Navigator. I am knwe to FME. Can you please help.Regards 

Hi all, I have a very simple requirement, find the closest location on a polygon to some points then move the points to that location, this has been achieved using the NeighborFinder and VertexCreator transformers. Further on in the workspace I need to use a PointOnAreaOverlayer to transfer the polygon attributes to the point layer (I realise that this can be done in the NeighborFinder step but for the sake of this post, lets assume this is not possible). The issue I am coming up against is that even though the new location of the point is determined by the NeighborFinder, in some cases the point and area are not considered to be overlapping by the PointOnAreaOverlayer. This is my very simple demonstration workspace:The initial features do not overlap:Once run through the workspace they appear to overlap:However, according to the PointOnAreaOverlayer, one of the points does not overlap:The point that does not overlap (according to the PointOnAreaOverlayer) is the southern most point (

Hi. I"ve a XLSX files. The XLSX files contain 2 sheets. Each sheets have common field (sample_ID). The first sheet is a description of the sampler, like the report name. In the second sheet it's the result of station. For each station it'S have many result ( 1 to M relation). I want to update a field in the second sheets with the value of the first sheet. But i have a error message (check the Capture files). Thank for help :)

So I have created a work space with an SQL Creator to query a table of inspections I am interested in. It seems to have the proper number of results showing, but I am not sure how to actually view the queried table in the FME interface. I also have a feature class from our SDE in the workspace as well as the table of ALL the inspections. What I want to do is only use the related features that would match to records from the SQL Creator query to export to ArcGIS Online. I also want the full inspection table to also be exported to ArcGIS Online, so that a user can click on the feature and see all related inspections (which should include the one from the SQL Creator). Hopefully that makes sense. Here is what I have so far...what do I do next??  

Hello,I am creating a josn using the json Templater. In my setting i have a subtemplate that must to be an "object" and contain a lot off nested attributes that are "list".In the situation where only 1 attribute is populated, the final result is good (Topology1record.jpg screenshot) but when I have more attributes populated the result is an array and not an object (Topology2records.jpg screenshot). I also attached the templater to show what I did.My final result should be: {  "type" : "FeatureCollection",  "features" : [     {         "id" : "rfs:7BBE13D625241D58",        "properties" : {            "topologyCharacteristics" : {                  "isPaved" : [                    {                       "range" : {                          "endOffset" : 1,                          "startOffset" : 0                       },                       "value&

This seems as though it ought to be really simple but I can't figure out how to do it.I have a number of text files which each define a polygon by listing the coordinates of its vertices. I'd like to build polygons from the coordinate lists.Usually I'd use the VertexCreator to build points/polygons but I can't figure out how to get it to iterate through a list of variable length.Some of the lists are also quite long (20+ coordinates) and it seems there should be an easier way than adding 20+ VertexCreators in series!

I have been trying to implement a similar solution to that posted by SAFE around HTML reporting and the java accordion feature as referenced in https://community.safe.com/s/article/how-to-customize-html-reports The different is that I am using the group by function in the HTML Report Generator The accordion is appearing as expected  but only ever second category is able to expand  I know this is not truly an FME issue but more likely a HTML formatting issue but just wondering if anyone has had success with using the accordion functionality with the group by option in the transformer. The transformer is set up as follows:and the results of each HTML report seem correct Any insights would be greatly appreciated. Thanks Dean

Hi,When I try to run a workspace on the FME server, I receive this error. On my machine, I have ArcMap and Pro installed with 64-bit background geoprocessing. I am also reading data from File Geodb using the Esri Geodatabase (File Geodb) readerArcGIS Enterprise 10.9.1 has been upgraded to ArcGIS Enterprise 11.0, and I am running FME Desktop 2022.0.1.0 and FME Server 2022.0.0.2. It is unclear why I am getting this error. Is it because we have upgraded ArcGIS Enterprise and are using FME Desktop 2022.0.1.0?  Thank you,

I am looking extract data from a csv file, (1) all open orders and (2) all closed orders within the last 90 days. Any recommendations. Thanks

Hi all, Trying to read in UK LiDAR composite data via a FeatureReader and spatial filtering - https://www.data.gov.uk/dataset/01b3ee39-da3f-47b6-83da-dc98e73a461f/lidar-composite-dtm-2022-1m I see there is an Esri ArcGIS Image Server Reader (https://docs.safe.com/fme/2021.1/html/FME_Desktop_Documentation/FME_ReadersWriters/arcgis_image_server/arcgis_image_server.htm) which should help facilitate this - but it is not available on 64 bit. Is there any update as to when this may be supported or a current workaround for 64bit? Thanks!Jack

I have been tasked with sorting out 100s of workbenches. In the majority of them the names of the transformers have been customised and should be in annotations rather than the actual transformer name, for easier readability. E.g. SQLExecutor is actually named Table_xxx or FeatureWriter is Named xxx_Output. I'd like to know if there is an easy way to just revert the names back to the original transformers names. I can't find a way myself, other than manually going through each one and changing it myself. EDIT: This is on FME Desktop 2022.1 Thanks!

I have the following XML:<?xml version="1.0" encoding="UTF-8"?><MyProblem> <Maat Name="MyName1" Description="LetsDoIt"> <Status_Maat Value="Open"/> </Maat> <Maat Name="MyName2"> <Status_Maat Value="Open"/> </Maat> <Procon Description="FinalCheck"/> <Precon Description="StopAndCheck"/> <Maat Name="MyName3" Description="LetsDoNothing"> <Status_Maat Value="Open"/> </Maat></MyProblem>I can extract the Maat with XMLXQueryExtrator by the following expression:/MyProblem/Maat Notepad++ XMLTools says the path to the Description is /MyProblem/Maat/@Description but this gives an error. And no results. What am I doing wrong?

After LineJoiner some lines are joining in the way of making self closing line geometry with start and the end point in the same spot.Is there the way to identify and repair such lines or maybe there is option in LineJoiner to avoid such situations?

Is there a way to read in the data and keep the address field in one column? Any help appreciated.

How to read/write ODS files? Thanks

I'm having a bit of trouble understanding how to extract data from this JSON file my client sent me. It came from Insomnia and I'd be really grateful if anyone could lend me a hand with this.

i use transformer Testfilter to filter type of mutation. Ultimately, I want to know how many mutations there are per type. For that I use StatisticsCalculator.This works fine, except when no value comes from TestFilter. How do I get the process to continue and StatisticsCalculator returns a value of 0?

I have have a set of polygons (actually they are buffers of a point) and I want to buffer these again to leave a ring - just keeping the buffer outside the original polygon. I can do this easily in arc/arcpy by using the buffer type "OUTSIDE_ONLY". How can I get the same effect using FME? I have created the buffers but when I use the clipper to clip one out of the other it clips all the overlapping buffers (which is what I expected) but I can't seem to figure out how to get the result I would like. I feel like I need to split each of the the buffer datasets so that it does the clip on each pair of polygons separately but - I'm new-ish to FME so.... Can't seem to find anything to help online either. This is what I have - the attribute managers are just to fill in an attribute so I can put the two buffers back together in one layer and be able to identify which polygon is which type.This is what I would like to end up with:Not this:

Hi I have installed GoogleCloudPubSubConnector from the hub but I am unable to use it since it keeps failing the test for web service authentication.https://hub.safe.com/publishers/safe/packages/google-cloud-pubsub I can't proceed further, I always receive this error message:Error 401: disabled_clientSign in with Google temporarily disabled for this app. This app has not been verified yet by Google in order to use Google Sign In.  Does anybody encounter this before? Thank you