Best Answers

Hi All,I have created a workflow that reads a few large GIS datasets in vector format across different areas. To avoid reading all the records in the dataset and reduce time I have used the FeatureReader transformer which is connected to the layers and an Area of Interest. The Spatial Filter option is ‘turned on’ as Boundary Boxes OGC-Intersect to read only those records within the Area of Interest. The problem is still takes ages to read,I have got a few FeatureReaders within the workflow and I was thinking to use only one FeatureReader (as all the data comes form the same GDB) to improve the performance, Any ideas to improve the performance of the workflow?

Our FME Server was patched and rebooted, which left it in a bad state. The automations and schedules kept triggering jobs but no jobs were running. It wasn’t noticed over the weekend and we now have over 160,000 queued jobs and I can’t get the FME server to respond (it hangs at the login screen, API calls just hang). I’ve restarted services, the machine etc etc. I think the issue is the fmejobrestore starts restoring all these jobs to the queue when I restart the fme server services. I’d like to cancel all the queued jobs in the back end database. Can I remove the records from the fme_jobs table? Will this cause any issues? Thank you!Kathy

Good evening at everyone.I have a shapefile of buildings in the reference system Gauss Boaga Italy Monte Mario 1 (EPSG:3003) [1]If I reproject these data in ETRS89 UTM 32N (EPSG:25832) using the proj4 library (with QGIS or PostGIS) and I obtain a very valid result [2], which overlaps with the orthophotos in coming from the WMS. [3]I tried to configure a custom SRID [4] by entering the 7 reprojection parameters used by the proj4 library contained in QGIS or PostGIS [5]I tried to reproject with FME using my custom srid, but the result is very different [6]. Is something wrong with the custom configuration [4] or fme  transformer [7]?Thank you!In the zipfile: [1] original.shp[2] reprojected_with_qgis.shp[4] MyCoordSysDefs.fme[6] reprojected_with_fme.shpother references:[3] http://pubblicazioni.provincia.fi.it/geoserver/wms?request=GetCapabilitieslayer=orto2016[5]"+proj=tmerc +lat_0=0 +lon_0=9 +k=0.9996 +x_0=1500000 +y_0=0 +ellps=intl +towgs84=-104.1,-49.1,-9.9,0.971,-2.917,0.714,-11.68 +u

Is it somehow possible to receive a connection from another party using OAuth2?Do I need to add a specific user to the user list? Do I need to create an application?Could it be done using a webhook or an automation? Or should i build a webhook or automation and use that as a trigger to connect to another location using OAuth2? The other party does not want to send data to my FME Server without using OAuth as a security measure.

Hey. I need some advice, or at least direction, on how to solve a complex problem. See attachment: I have a track. The track consists of waypoints, the waypoints are minisegments which consist of a startpoint and an endpoint and these minisegments form one big segment and these big segments form one complete track. The direction of the "flow" of the points is determined by the number of startpoints and endpoints, see below, where we see that the only possible direction is from A to E, since it must connect startpoint to endpoint between the minisegments, which form one segment out of three. The waypoints of one of the segments at the level of the points that make up the minisegments look like this - A, F, C, E: Startpoint: AEndpoint: FStartpoint: FEndpoint: CStartpoint: CEndpoint? EThe problem I'm solving is that some segments have this sequence of startpoint and endpoint reversed in the source data, so that the sequence of points of one of the segments would look like this: E, C, F, A

Hi everyone, is there a way how to integrate Flow Apps through iframe into another web site page. There is a block in CORS setting Flow Apps strict-origin-when-cross-origin. Any idea? Kindly regards

Is there a possibility to schedule the workbench on our local system rather than putting it on the server due to data confidentiality issues?

Can Imagefetcher download the images from a excel thst have google drive image link

I have 4 files I need to rename. To rename them I need to add the values of an attribute in a table to each of their names; please refer to the screenshot for this example:SS000001.PNGwould be renamed 18085SS000001.PNG by adding the value from the STCLID Attribute in the table in the screenshot to the filename.  Seems as a first step would be “move” the values in the STCLID attribute to the <missing> rows? What is the best way to go about this? 

The PDF-reader seems to have disappeared from FME Form 2024 for Mac (silicon). It worked fine in the 2023 version. I took a look at the writer, and there is no dot under Read there either. Has this reader been removed for some reason? Or is this a bugg?  

Hello Community,I have a question and looked for answers but didn’t find it yet.It must be simple for someone but I have not yet figured it out. I tried attribute transposer, aggregator etcI have a table with a feature which has an ID here shown as Feature 1,2,3 and multiple columns with values for each month of the year.It is like so: What I yould like to get is the following:In the end I need a row for each column corresponding to the feature it is refering to.I found some sort of a possibility but it it very “manual” an inelegant in FME as I have to create each month manually and associate a date etc. If someone has a better idea, I am very interested about it. It would help me in the long run as I may have a wrong approach to transposing data with FME.Many thanks to all the contributors. Best regards, Thomas

Hi there,I have a small project where I've performed a join between two tables (Table1 and Table2) using the CityName field as a common identifier.However, I've noticed some minor inconsistencies in the city names between the two tables, resulting in 10 unjoined features.Is there a transformer or method available to manually specify that the X row from Table1 should be joined with the Y row from Table2?Regards   

How long in terms of days is a log file saved after an Automation is run? is the log file overwritten the next time the same Automation runs? or is the log file archived somewhere? Also, the log files in Resources referenced below, how long are they saved? how often are new ones created and saved?Files & Connections - Resources - Logs - Engine - OldFiles & Connections - Resources - Logs - Core - Old

 Dear FME community,I hoop you will help met with the problem I am try to solve . I am reading WFS data which has more than 200,000 records. I just want to replace one of the fields from my own Excel file. I used to Attributevaluemapper to replace the value of fieldname owner with the value name owner from my exce list. I am not succeeding Do you have any idee how to tackle this?Any help is apricated and thanx in advance!! 

Hi all,I’m using: FME(R) 2024.0.1.0 (20240328 - Build 24202 - WIN64)I do want to know if there is the possibility to use the HttpCaller to launch chunk of requests. My DELETE request: https://xyz.api.here.com/hub/spaces/@Value(space)/features/@Value(xyz_id)each request sends to that Hub the action to delete each Feature by its ID (xyz_id).I need to delete around 4M records, and running the workbench feature by feature, takes days.Is that possible to get it faster? Thanks for you help,Juanma

My customer want me to automate a report how many times diffrent map services has been reqested.It’s on a unfederated arcgis server with arcgis server manger.In arcgisserver manager i can export this information one by one to a csv file and get how many times a service has been requested in a set time period.I need to find a way to automate this process. Is it possible to retrieve this statistics using FME and then print it to an Excel file? Then on FME-server I need to get a report every month how many times diffrenbt map services has been used. 

Hi Community, I am developing a workbench which is reading and writing data to ArcSDE Geodatabase. As per the information which is available in the Knowledge base I need to have ArcGIS Enterprise(Server) Software to be installed and Licensed in the same machine of FME Flow installation. Here my question is:  If I have the ArcGIS Server License which is installed in some other machine, can I assign the License with the FME Flow machine?

Hi, I have acheived an attribute update in an existing table in QGIS.The transfert to PostGis works well when I use "Insert" and "Drop and Create" handling.However, I can not figure out the operation with "Update" and "Use existing" in order to properly transfert the updated value of the attribute code_dep. Any help is welcome.

My goal is to split the green polygon at the edge of the pink polygon. However, the pink one is not aligned properly. The black line indicates the cutting line I want to achieve. I am thinking of creating a buffer around the pink dataset, however only at the top and bottom border. At the left side, where the cutting line is present, a buffer is not allowed. When such a buffer is created I could use an Intersector probably to split the green polygon. Any support is appreciated! 

I got this question from a colleague. I know after reading in a dgn file you can aggregate features together based on igds_model_name, but I was wondering if there is a way to make a distinction/aggregation based on the type of model (drawing, desgin, Sheet). Within Microstation you have to attribute msdModelType which can contain the following values that correspond to Sheet, Design, Drawing:1) msdModelTypeSheet for Sheets2) msdModelTypeDefault3) msdModelTypeModel I was wondering whether there is an equivalent for that attribute within FME desktop or whether there is another way one can make distinction between those three type of models (Sheet, Drawing, Design).

I've encountered a problem since upgrading to FME Workbench 2024.0. Previously, I could select Feature Services using Esri ArcGIS Online (AGOL) or FeatureReader without any issues. However, now I'm getting an error resembling the following:"Could not find a Feature Service item matching the Feature Service directive 'Parks and Recreation - Tree Inventory/Tree Taxonomy List(<item ID>)'."Interestingly, removing the quotations and <item ID> in the Constraints parameter allows successful reading. Is this the expected behavior? Do I now need to manually adjust parameters for reading every feature service?Any feedback or advice would be greatly appreciated. Thank you in advance!

I want to update a table from a HTTP request for x times depending on the last update and the current date. What would be the best practice? So I have to fill in the green part in this workflow.  

I am trying to return values for multiple fields (codes), parsing data from one incoming field (NAICS_CODE), using a AttributeManager transformer and SubstringRegularExpression.The field containing the incoming data is called NAICS_CODE and can contain data for up to 30 separate codes.  For example, in one record the field NAICS_CODE has 10 separate codes.  Using an online regex editor, I have the following code, where the index for each parsed field would be 0-9.^\s*(?:\S+\s+){0}(\S+)   THROUGH   ^\s*(?:\S+\s+){9}(\S+)And when I test this code against the following data with the online REGEX editor:236210-DBE/MBE/SBE  236220-DBE/MBE/SBE  238210-DBE/MBE/SBE  238990-DBE/MBE/SBE  335311-DBE/MBE/SBE  335312-DBE/MBE/SBE  335313-DBE/MBE/SBE  335314-DBE/MBE/SBE  335999-DBE/MBE/SBE  423610-DBE/MBE/SBEThe results seem to be what I am looking for, returning the correct code from the field for each indexed value.^\s*(?:\S+\s+){0}(\S+) returns 236210-DBE/MBE/SBETHROUGH^\s*(?:\S+\s+){9}(\S+) retur

Hi there,I don’t see the forest for the trees 🤔Input dataXML excerpt (source https://ifc43-docs.standards.buildingsmart.org/IFC/RELEASE/IFC4x3/HTML/annex-a-xsd.html):<?xml version='1.0' encoding='ASCII'?><xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:ifc="https://standards.buildingsmart.org/IFC/RELEASE/IFC4/3/DEV/9d19c824" targetNamespace="https://standards.buildingsmart.org/IFC/RELEASE/IFC4/3/DEV/9d19c824" elementFormDefault="qualified" attributeFormDefault="unqualified"> <xs:element name="uos" type="ifc:uos" abstract="true"/> <xs:simpleType name="Seq-anyURI"> <xs:list itemType="xs:anyURI"/> </xs:simpleType> <xs:complexType name="uos" abstract="true"> <xs:sequence> <xs:element name="header" minOccurs="0"> <xs:complexType> <xs:sequence> <xs:element name="name" type="xs:string" minOccurs="0"/> <xs:element name="time_stamp" type="xs:dat

I’ve tried searching for answers to this but I’m sure I must be using the wrong search terms as I get close matches but nothing that has pointed me in quite the right direction yet. I’m hopefully that someone can help me understand how to expand the following JSON fragment into a set of features, where each feature contains the same initial set of fields, but only contains one of the final array entries.Here’s an edited example of the JSON I’m dealing with and how I’d like the out to look. {"UPRN":"12345678","CaseNo":"15/01234/ABCDE","Address":"16 Some Rd Surrey SM1 1AA","Name":"Miss T Mountain","DocumentID":["7654321","7654322","7654323"]}I’m trying to extract this into 3 features, each of which includes the uprn, CaseNo, address, name and a DocumentID. I’ve been able to extract the whole array of documentIDs but haven’t figured out how to extract each one in turn and pair it up with the remaining information.The JSON output I’m dealing with contains a number of such records, in each