FME Form

Hey all,I am trying to set up a workspace to update, insert, and delete a heap of our ArcGIS Online feature layers once a week or so.I have been able to set it up once using the AGOL feature reader into the change detector in a similar way to How do I write updates to an existing ArcGIS Online feature service? (safe.com).I am unable to add dynamic layers using the AGOL feature reader, thus limiting my ability to update multiple features using it. My question revolves more around how to cycle through multiple layers and add to the change detector.I have tried setting up a CSV with the required information and then using a standard feature reader, but that does not bring the attributes that are used to compare in the change detector.Has anyone done a similar project or have an idea on how to Have it work? Cheers 

Hello FME friends,After a week away, here's a very full edition of What's Up Wednesday.  Certification Program UpdatesAs of this week, you'll notice major changes to our FME Certification program. Firstly, there is a new trail on the FME Academy to help you learn the required skills to pass the exam:  Yes, that says 62 hours, but that's if you are starting from scratch with no FME skills. If you're considering certification, I expect that you would have completed many of these modules already, or have the equivalent amount of training and/or experience. Secondly, the FME Certification exams are now being "proctored". This means that automated software monitors your exam to ensure the right person is taking the test and does not receive outside help.  It's not that we don't trust you, but we think certifications have more value when carried out under secure conditions like this. It also lets us process your applications quickly and provide interacti

 I have used text adder to create name of polygon at the middle .So i have points geometry as name of each polygon at middle of polygon and polygon borders.i would like to merge both of them and have point and borders in one layer .How could I do it ? i would like to keep only attributes and rows of polygon borders .there is id common between polygon borders and points  Fme 2021 Thabks in advance

I have a dataset with a messy 'comments' column. I want to extract numbers from these comments, but only when the come before a ceratin word. For instance, a comment could be: on januari 21, 16 boats passed or21 boats passed on januari 12 2017 I only want the numbers when they come beofre the word 'boat'. Is there a way to do that?

I have migrated data into Utility Network but have a large amount of duplicate stacked point features. They all need to remain but the network topology will remain dirty unless I find a way to make these duplicate XY's unique. After testing a few manually, it seems to work if I add a z value of 1 to only the duplicate points and revalidate topology. So if I could add a z-value of 1 to only the duplicates using FME, it would solve my issue. Any help is greatly appreciated!

I am trying to read in a csv and write the contents into a javascript file. It works at least 90% of the way and looks like this when I export the features:[ { feature1: value1, feature2: value2 }, { .... } ] I would like to insert the text "var data = " at the beginning of the file, like so:var data =[ { feature1: value1, feature2: value2 }, { .... } ] Is it possible to insert this text in the file before the JSON writer writes out the contents?  Another detail is that this CSV file has over 5 million rows. It is difficult to open the file and write in the text or use powershell commands. Any help is appreciated!

Hey everyone I am completely new to FME capabilties. We currently use Civil 3D 2023 and were looking for a simple way to create a geospatial PDF from a Civil 3D Drawing (DWG) file. Just wondering what solutions FME offers for this? Thanks everyone!

I have been using this transformer for quite some time and have been living with the pain.i have done some more testing with it and discovered that if i don't use recurse there is a significant performance gain with a giant functionality loss!it can take anywhere from 5 minutes to HOURS to get a response from the initial read in dektop. slightly better in server however i am ussually not waiting on it at that point (if i need it to work i publish to server and walk away) it may be tomorrow before it completes.are there any workarounds. i have considered trying to use a system caller to just do a dir and get really bad data back and rebuild it from that. 

Hi, we're getting an out of memory issue running a workbench in 2022.2 that runs fine on the same computer in version 2021. Has the way the vertexd creator processes data changed?

Can I use FME AR offline?

Hello I have to migrate a MySQL DB to a Postgres DB. The input DB contains about 200 different tables. Some fields of these tables contain url. Before migrating these urls, I would like to validate them. I have created a workspace which works perfectly fine using a sequence of transformers HTTPCaller transformer.Before publishing it to FME Server, I would like to define some parameters amongst which the name of the table and the name of the field containing the url to check. Is there a way to do this? I have tried to use published paramaters which is ok for the fieldname but I cannot see how to do it on reader feature type. Thanks in advance for your help.I would like to create a workspace using a MySQL DB containing about 200 tables as input to let user define the table (and the field)

For some reason the .fmw script does work on FME desktop ( 2021.2.3) and does yield an output (in my case a geojson). When I import the script on FME Server (version 2021.2.4) then the script is completed without raising any error, but doesn't write the file on a map. I am quite sure that  the Published parameter "Destination JSON file" is correctly written. When I look at the view details tab after the script has been completed, I see a lot of statements with Nuke or TeeFactory. I read on the following link in the answer of merlingeorge: https://community.safe.com/s/question/0D54Q00009fDZGRSA4/disabled-nuker-1-50-teefactory- that it might have to do with version incompatibility. Might that also be the case in my situation? I would assume there wouldn't be much differences between FME desktop 2021.2.3 en 2021.2.4. By the way, some lines below have been omitted due to security concerns. 40 2022-12-1 15:38:40 | Creating writer for format:41 2022-12-1 15:38:40 | Creating reader for format

Hi all,Is there any suitable transform for following scenario?. Like I have a shape file which have data with some attribute and I have an excel file which holds same attribute data like present in shp file attributes. I want to filter those attribute matching feature.all related suggestions are welcomes!Thank you in advance,Saravanakumar 

Does anyone know if the newest version of FME still supports QUADRI- and QMS-files? I tried to add a QUADRI-file as a reader, but I get the following error message:  "Failed to obtain any schemas from reader 'GDMMAPPERQUADRI' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading." 

Hello. I saw that in the latest version of workbench 2021.1 that the sorter doesn't work well on number values. The sorter stops at 99 while the highest number is higher. Now i filter all values below 100 and then the next stop is 999, etc. Do you recognise this problem? Greets, Jacob

Whenever we try to use a Reader or Writer to connect to ArcGIS Portal we're getting the error "Type 3, Number 1, Message: Failed to get authorization header" when using the [...] file browser button in the Service Parameters dialog.(Workbench >> Add Reader >> Esri ArcGIS Portal Feature Service >> {add portal url} >> Parameters >> {select auth type: Web Service} >> {select portal web connection} >> [...] file browser >> >>> ERROR)We've verified the portal Web Connection works (Tools >> FME Options >> Web Connections >> Manage Services >> {select portal connection} >> Test). How to troubleshoot this further? FME Workbench v2020.2. I'm not sure of the ArcGIS Portal version. I think 10.8.1.

I have a single table, TABLE1. I have a field named STE. I would like to select the values of STE that are NOT NULL, then add the selected values in STE to the ADDR field in same table. What is the most suitable transformer(s) to go about doing this?

I have two Geodatabase Feature Classes, FC1 and FC2. I want to relate the GIS_ADDR field in FC1 to the ADDR_BASE field in FC2.  Once the relate is established, for the matching (selected) records in GIS_ADDR in FC1, I will then update the ADDR_SRCE field which is currently empty with the value "ADS"; for the records that do not match I will add the value "Res".  I know how to do this in ArcGIS Pro. What is the best approach to do this in FME?

I've got an issue with the stringsearcher. It does not seen to work as I expect it do do. It might be my regex skills, but I think I tried all possibilities. What  I've got the following text: "324324" "maatvoering; hoogte; bouwhoogte; maximum bouwhoogte (m)"="8", "maatvoering; hoogte; goothoogte; maximum goothoogte (m)"="4" asdfasdf sadfsadfsf 343244 In this text I would like to find the first number after it finds the word 'goot' in the text. In this example this should be the bold number 4. I'm trying to do this with the following expression: (?=goot.*")[0-9]*(?=") But it does not give any results as you can see in the screenshot below. Any ideas what I'm missing here? 

I am able to upload PDFs to SharePoint using FME, but the content I get from another system's API is coming in as a BLOB, then I have to convert this binary to Base64 then convert again to Unicode or Binary (System Default) like this:The output of the BinaryEncoder transformer is testably correct:BUTT the TextDecoder is producing a trimmed output:When I upload this file to SharePoint it is incomplete and lacks the actual PDF content, but is openable and not corrupt.  Is there a known limitation here, a setting that can be changed, or alternative workflows that would work here? Thank you

 We may not have the certificate on the date we plan on doing the installation.

Hi All,  I'm trying to find a way to snap a point on a line segment to a point on one of the line ends, based on whichever one is closer. The points on the line segment and the line itself share a common asset ID, but the points on the ends of the lines are strictly geometry. The only attribution is a unique ID, but it doesn't relate to the line or the point on the line at all.  Right now I am using a spatial relator on the lines and end points. I now have, per each line segment feature, a list of end points that touch it.  I want to find a way to use NeighborFinder (or anything else - i'm open to ideas) to say "ok, where the line asset ID and the on-line point asset ID match, find the closest line end-point from the list. I've attached a small diagram/graphic to illustrate what I'm on about.  Any help would be appreciated!

Hey All. I've been looking through the tutorials to set up custom transformers because I wanted a programatic way to define workflows and I was planning on encapsulating/stitching together a Reader, GeometryFilters, and Writer into one custom transformer that took input files, output folder and various other runtime arguments as parameters. The reason for this is to be able to dynamically define the links between workflow steps, whereas now it would require a lot of manual UI work to define a workflow that worked for a file with 1 specific set of features. Is this the right way to be thinking about this problem?

Hello, I'm trying to snap two line feature layers to one of two separate point feature layers. In the line layers there is a owner1 field and a owner2 field, on the point layers there is a ownerid. Hopefully the screen shot below helps clear it up a bit. I tried using the anchoredsnapper using the owner1 and owner2 as the group by and a snapping tolerance of up to 75 feet which is much larger than I should need. I had the line layers going into the candidate and the point layers in as the anchors. I have not used this transformer before so I'm not sure if i'm using it correctly. I'm getting features to snap, but most com out as untouched. I expected that to have far more of the lines snap. Any help of ideas would be appreciated, thanks. field. I want the point features to be what the lines snap to. Either of the owner fields in the line layers can match the owner field in either point layer.

Hello  I have a number of connectors which touch a main line but do not split it.  I want to be able to select the connectors that are not currently attached to a node and snap their vertex to the closest node point as shown by red dashed lines.  I assume I have to form a relationship between the connectors and the main line and then the main line and the node points?  Or can it just be undertaken using X,Y co-ordinates and proximity.  Any help greatly appreciated.