Best Answers

Hi. I would like to ask for advice. I have one airport geometry and I have for example three runways to this airport (for example BENESOV). I need to write this data into a shapefile including geometry = 3 x BENESOV airport geometry with runway number see printscreen. 204 elements are correct for the input of the shapefilewriter, but we only write elements that have one runway to one airport. Can someone please advise how to solve this? I am also attaching WS in the attachment. thank you very much

Hi,I need to test multiple FeatureCounters with one Tester so that if any of the counters have a value of zero then the test fails. Unfortunately the tests always fails because some of the fields are missing when the counters appear in the Tester's results. The test below is supposed to pass. Is there a way to set this up so that I can get the results that I am looking for?

I've created different user parameters for my workspace. Some specific combinations will lead to an error. The user has to choose the output format (Geotiff, JPEG or JPEG2000) and the color depth (Gray8, RGB24 or palette). JPEG and JPEG2000 don't support palettes, so those combinations will lead to an error. How can I configure the workspace to respond to invalid combinations of output format and color depth with a costum error message in the log file? Thanks in advance!

Hello FME community, I have 200 dwg files that works as tiles (mosaics) for a large area. I want to do a certain process on all DWG files and then save the file with the same name. when I read and then write all DWG files with fme, they are all saved in one DWG file. does anyone know how I can read all DWG files at once and write them to individual DWG files. Thanks for your support 

 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 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!

Can I use FME AR offline?

For FME Server what are the practical differences between internal and remote Version Control? What considerations should we to take into account about when choosing between them?

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? 

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

Hello,I would like to ask about Rest API v3 support. For how long will it be supported yet, before it will be needed to switch to v4?  

I am reading all JPGs contained in a location (including subfolders) and manipulating the attributes. Then, using the filecopy writer, I am moving them to a new location. I am having a hard time getting them to move with the name I am defining in the Text Editor. The original name is retained every time. Does anyone have some advice for me?

Is there an attribute that can read labels, ie. I have some pipe geography with labels allocated from the search engine. They are clunky and are not well placed. I was wondering if its possible to read these and redistribute?

Hi there, I am trying to use FME to automate some user management for FME Server. Specifically I would like to schedule a workspace to remove any Azure users that are not members of a role. I have worked out how to list the users and get their roles, but I can't work out how to go from this json array: ["user:admin","fmeadmin","fmesuperuser"] to the integer value 2. Can anyone please help me drop the "user:..." part from the array and count the number of items that are left over? Thanks!Marc

Hi all, Good morning, The challenge we have is: to put a signature (image) in a particular cell in a table in an MS Word document. We have got something working, but we would like to have your kindly advice. Situation:The signature is read from an AGOL attachment as a blob and with a RasterReplacer and a RasterResampler it is turned into a JPEG (which is visible in the Graphics window). To put this image into the Word document we could use an MSWordStyler where we set Image Source to From Feature.But because of the very specific location of the image in the doc (in this particular cell in this particular table) we use a Python docx solution in a PythonCaller. Question:The solution we have now is to temporarily store the image and then retrieve it to put it on the right location in the doc. And this works... But, but, but wouldn't it be possible - inside the PythonCaller - to read the image "From Feature", like in the MSWordStyler...Any ideas would be highly appreciated. C

Hi, I'm Pol and I'm quite new to FME. In one task I have created voronoi cells from points that share the same value of an attribute and at those points that have a unique attribute value I have created a buffer of a given radius. I did this in order to create an influence map for a certain attribute.The problem I've run into is with the overlapping buffers on the border of the voronoi cells. This is the current result:  this is the desired result:   How can I do it? I've tried the donut builder and the hole extractor but I can't get it to work. Any help is great, thanks in advance. Pol   

Wondering how to create a hyperlink that will show the blue underlined text value in a field and when you hover mouse over the text you will be able to click on a url. My Writer is to file geodatabase. I have a single url that I want to associate with the text values in a field. Attached is what I have done so far using the AttributeManager Conditional Parameters. I do not want the actual URL to appear in the field.  

I have been investigating replacing my use of SQLite Spatial (GDAL) with the new (FME 2022) SpatiaLite Native format.Previously I used to be able to start a workspace with a SQL Creator with a statement like:SELECT id, column, geometryFROM table With a script like that, the old SQLite Spatial (GDAL) format SQLCreator would read the geometry correctly from a database created by a SQLite Spatial writer. However, I can't get the same to work with a SpatiaLite Native SQLCreator selecting from a database created by a SpatiaLite Native writer. Instead of reading the geometry of each feature, it reads a blank string attribute called geometry.Is selecting a geometry with a SQL statement no longer supported? I can probably replace this sort of use with Readers, but would prefer to not.Thanks.

I have a bunch of CSV spatial data that have no street location allocated to them. I was wondering if FME can import a basemap of google earth or google maps of my location and using an attribute apply a street name to my csv points?

My Reader is Excel. My Writer is ESRI File Geodatabase. I use AttributeManager to rename the fields. How do I add field name aliases to the Writer in this situation?

Hello, I'm using a string searcher to find "Dates" out of a "Comments" field. I have a column of all matches (Screen shot attached). How can i extract the most recent date out of all matches? Probably would help if I change "/" to another symbol.

I have an Excel spreadsheet in my Reader. I am using AttributeManager to change field names. I am writing to an ESRI Geodatabase.  FieldX has values of Type 1, Type 2, and Type 3. What is the best way to add a hyperlink to this field? so that values look like Type 1, Type 2, and Type 3 and when clicked the link opens. The hyperlink is the same URL for all the values. I am able to add the hyperlink URL to FieldX in AttributeManager, but the result is it shows the actual URL, not the linked value (Type 1, Type 2, and Type 3) in the field.