Best Answers

Geometry replacer is not working for me. Both features contain FME Binary geometry. I have tried renaming the attribute, cloning, etc. How does this work? Thanks,@larue

I have a data set with numbers in x y z sequence separated by "," representing 3D geometry polygons and points. It was originally WKT and had been formatted to work with Dynamo (Revit).  Here is a sample of a point:841.99951171875 678.6250000000001 -132 Here is a sample of a polygon:409.000000000001 473.499999999999 372,409.000000000001 797 372,487 797 372,487 871 372,1275 871 372,1275 476.286679607417 372,1275 461.500000000111 372,409.000000000001 461.5 372,409.000000000001 473.499999999999 372 My hunch is to chop everything up into x y z attributes and then reconstitute into points/polygons. Using two AttributeSplitters, I can create a list, but then, how do you assign these numbers to x y z in sequence? It is so close to WKT, maybe there is an easier way? Thanks,@larue​   

Greetings,Is writer to PostgreSQL inherited table is supported by FME desktop. It's not working and return error.Regards,Maha

I have two FME servers, one test and one production. Both have version 2020.1.3 and a recent installation of ArcGIS Pro 2.6. I have a workspace, also in 2020.1.3 with Python Compatibility set to "Esri ArcGIS Python 3.6". The workspace works fine on desktop which has Pro 2.6 installed. The workspace is published to both servers. It runs without any problem on the test server, but on the production server, it gives this error as shown in attached. It does not generate a log file either. It seems the production server does not know the existence of the Pro 2.6 installation. I have no problem launching Pro 2.6 on the production server. Do I need to do some special configuration on the FME server to work with ArcGIS Pro? I don't think I did anything special on the test server, and yet it works fine with Pro.

I would like to get one single MSI package please.

Hi,I can call a WCS by means of my browser, using a getcoverage request. The service returns a geotiff, for example, that i can save to my disk.It would be great to use FME instead. However, I only find WMS and WFS Reader.Do you know a way to do it anyway, do I have to use the HTTPcaller?Best wishes!

Hi I would like to filter my pointclouds based on the minZ from a corresponding DTM.  So the height difference in the area's is not that big. Therefore we could use the minZ from the whole DTM. If it can be done to do it for each rastercel, I'm also interested.  I want to use that minZ value to filter/split/test my pointcloud. I can't seem to find the right transformer to do this.  Like for the pointcloudfilter. I'm feeding it the pointcloud and from the raster(DTM) side an attribute (minZ). The filter won't accept the attribute.   This is what I have right now:   

Greeting. I have a file from autocad (.dwg) from which I would like to extract the postal address numbers in the form: NR.20, NR.16a, NR.83I would like to remove from the column special characters such as: ???, / , or - as well as text names like TEREN VIRAN For example I have NR-130-TEREN-VIRAN, I wish to have just NR.130Or: from NR-137/F I wish to have NR.137FAll the best. 

I have an FME Server App configured to run a workspace. That workspace may run an FME Job Submitter that runs another workspace. The second workspace has a data download service on it. How can I get the App to access the data that is made available from the second workspace triggered by the Data Download service?

I'm trying to build an archive off a feature service hosted in ArcGIS Online by getting the changes and writing them to a second hosted feature service. I can get the changes in JSON, but I'm struggling to turn them back into usable features. The format looks like this: "edits" : [      {         "id" : 0,         "features" : {            "adds" : [               {                  "geometry" : {                     "x" : -119.58448584499996,                     "y" : 32.10688862600006                  },                  "attributes" : {                     "OBJECTID" : 93,                     "GlobalID" : "1DF7CAF6-D3CC-4E8D-8FB3-C6714C06890A",                     "IncidentName" : "Testing",                     "Label" : "DIV X",                     "Label2" : null,                     "LabelType" : "Division",                     "Other" : null,                     "CreateName" : "test_nifc",                     "CreateDate" : 1621322205148,                     "EditName" : "test_n

Hi,Does anyone know if there is a way to extract metadata about a Microsoft SharePoint List? In particular, I would like to know the date each record in the list was last modified. I am using FME Desktop 2020.1.1.1 Thanks

Hi guys, I'm struggling with getting coordinate system information in my GEOJSON file. As mentioned in documentation I've tried to add attributes json_crs_type und json_crs_properties attributes to my features, but the GEOJSON writer ignores these attributes and passes my attributes on to "properties" section of every feature.       {         "type" : "Feature",         "geometry" : {            "type" : "Point",            "coordinates" : [ 630533.503899999, 475902.4741000012 ]         },         "properties" : {            "json_crs_type" : "name",            "json_crs_properties" : "LL84"         }      }, Could anylone tell me how to configure my features to get the crs information to my file like in example below?{ “type”:”Feature”, “crs”: { “type”: “name”, “properties”: { “name”: “urn:ogc:def:crs:OGC:1.3:CRS84” } }, “geometry”:{ “type”:”Point”, “coor

​Bonjour/HelloEst-ce possible d'obtenir un tableau excel (ou autre) d'une table avec quelques infos et non pas l'entièreté de la table, par exemple le nombre de champs vides "NULL", la date de la dernière mise à jour (et pas toutes les entités du champ date de mise à jour) et de l'auteur de la dernière mise à jour ? Merci pour votre aide ! 😊  Is it possible with FME to  get an excel with some information like, for exemple I would like a document with the name of my attribute table, the last update date, the number of empty fields ?Thanks for your help !😊

We have 2 fme servers - licenses are set to not expire. What can I do to get production back up and running?

Hi FME UsersI'm reading a Revit-Drawing and try to extract the coordinates of the "Part 0" in the IFMEAggregate (IFME Line). I use a "GeometryPropertyExposer" with the settings shown in the screenshot. But somehow it will not work, and it would be great if someone can help me to solve this. Thank you very much in advance!Dominik

Hi,  I know the ExcelStyler is in beta but here goes the question anyway. Is it possible to style individual cells based on the attribute value?  I have tried different approaches that all color the entire row or entire colum as you see below. Result if I filter through a tester and chose to style attribute "c".   Result if any of the attributes fail the tester, the entire row is colored.  This is what I need, to style individual cells based on their value   Thanks!  /Jacob

Your input would be much appreciated. I don't know how to proceed and would like to avoid manipulating the source data manually to get it to do what I want. I've received data which is formatted in the following manner. I'm posting the first item and closing it off just as it ends in the file with </markers>:<markers> <marker name="Tilburg"    straat="Vloeiveldweg 6a"    postcode="5048 TD"    plaats="Tilburg"    site=""    lat="51.600739"    lng="5.064299"    linkurl="tilburg"    status="0"    dot="red.png"    ></markers> I used an XMLFragmenter and it's configured as:Elements to Match: markers/markerFlatten Options: EnabledFeature Information shows:How do I go about extracting marker.name etc. into their own attributes with values? I've tried various combinations in Elements as XML Fragments but no dice.

Hi list.I'm attempting to run our FME server under a domain account, but can't seem to get it right.I've read the admin guide and done the followingprovided full file access to C:\\Program Files\\FMEServer and C:\\ProgramData\\Safe Software\\FME Server (using default folders in installation) to the domain account.Stopped the three services (appserver, core, engines), but left database service running.Changed logon on the three stopped services.Deleted the log files from C:\\ProgramData\\Safe Software\\FME Server\\resources\\logs\\engine\\currentRestarted the three services.But now the web interface fails, saying it cannot access Core services.I'm sure that I need to do something more, but I'm at a loss about what it is. I've re-read the admin guide, but cannot find anything amiss.Please help.Cheers

I have a CSV with data exported from an old program.  It created two columns.  The first column contains field names and the second contains the values.  It looks a bit like this:FirstName, PaulLastName, SmithBirthdate, 1/1/2020CellPhone, 123-456-789FirstName, MaryLastName,SmithCellPhone, 123-555-1212Each group starts with "FirstName", but each person in the data does not necessarily have data for each of the fields.  (e.g., Mary Smith doesn't have a birthday in the system).  I can use a duplicate filter to get a list of all potential fieldnames, but how do I do the next step?  I want to create a table that has all the data for each person in the list.   In the simplified example, two rows would result.

I have a number of shapefiles which I want to translate to Geopackage.However I want the original shapefile name intact. So just a one on one batch shapefile to geopackage translation I thought that the FME Quicktranslator app would be handy in this situation, however, it asks me to specify a database connection, even though I want all the individually translated shapefiles as separate .GPKG files in a destination folder. In FME Workbench, a specific filename is also required to translate shapefiles into, and there is no way (as far as I can tell) to let this be a dynamic name based on the fme_basename attribute. Note that I do not want to have a single geopackage file with all the shapefiles combined in it. How do I do this? Thanks for your time. 

What is the best management practice for setting attribute data types prior to writers, preferably at the reader? My specific issue de jour is an attribute (data e.g. 1023, 1034, 1002.1) that is reading in as real32 but indeed they need to be strings for my use case. A custom python transformer (type casting to strings) changes the values to strings '1023.0', '1034.0', '1002.1', due to real32 initial type, which won't work. I need strings '1023', '1034', '1002.1'.  Thanks for reading and any response is appreciated. TylerFME Desktop 2020.2

Hello, I have what seems to be a simple task, but so far, have not been able to find the right solution. I have an FME process that creates a CSV file with a header row, but it needs another "header" row above the actual header. Below is an example of the CSV file with the header:TagName,TimeStamp,FieldValue,DataQualityLLSCADA.LL_EX02_BATTERY_VOLTS.F_CV,5/24/2021 12:45:00,6.37,GoodLLSCADA.LL_EX02_CHLORPHYL_UG_L.F_CV,5/24/2021 12:45:00,0,Good The additional "header" row is simply the following:[DATA] Appreciate your time and any assistance, Lowell 

Hi all, I have a list of JSON historical file which contains date and time at the end of the URL. I would like to extract both date and time based on the URL and put it in the table. I've extracted the date and time using the DateTimeStamper, but fails as it only generate current date and time. Is there any suggestions on how can I extract the date and time from the URL?

 I know how to do it with a workspace and HTTPCaller and with the Rest API but I would like to know if it is possible directly through the external action : "Make an HTTP request" and if so how.Thanks!

Hi all,I have a workspace, where I am detecting the hange between my original data in an SDE and revised data coming from a public source.  I'm using the fme_db_operation to push Inserts, Updates and Deletes to my SDE. However it apparantly just keeps adding the data as duplicates.  I have 6 exactly same polygons for each feature, with the only difference being a Version ID... Any thoughts?