FME Form

I know StringSearch can look at that one selected column but I'm looking for a transformer that will search any column for a value? (similar way Visual Preview can find ??? in "any column")

The input looks like this:The result must look like this:

I'm using a geospatial pdf writer to export a map that was styled with a PDFPageFormatter. The PDF opens correctly in Adobe reader, but not in a webbrowser (Chrome/Firefox). After removing the layer by flattening the pdf (using an online tool or Ghostscript) opening the PDF in a webbrowser is possible. Is there a possibility in FME to flatten the PDF, the PDF-writer always demands a layer name... So writing without creating a layer is impossible.

Hello,Can anyone explain the difference shown below? Inside a standard workflow, the SchemaScanner captures the order of the attribute names correctly as they appear on the input file. However, when used inside of a custom transformer, the incoming attribute names are sorted alphanumerically. Does anyone have any ideas why this is happening? 

Hi Community, How can I read / expose the element information from a DGN file? Need to be able to read General > Description as the following screenshot shows:I have already played around with the Reader DGN parameters (e.g. read tag attributes, Read XAttributes, etc) with no success.  Any help would be much appreciated. Thank

Hi!I would like to export my datas (only attributes) on a jpeg file.I would like to create a sort of table like on excel, with blacks border and dimentionnate the columns in order to not truncate the datas. And then export an jpeg file.I used ExcelStyler and an JPEG writer, but it failed because it's not an raster format. So I tried with ImageRasterizer but I don't succeed. I'm not use to manipulate raster format. So could you give me advices to suceed?Thanks !

Is it possible to add a pdf as an underlay in a dwg file with FME? I am setting up an automated process for creating dwg-files. Im adding vectordata from a database but i would also like to include a pdf created with arcpy in my dwg. I can see from the format docs that there are attributes for xref:s but i can't figure out how to do it. I have the necessary coordinate information to place my pdf correctly, just not a way of adding it. If it's not possible to create xref:s with FME, is it possible to simply update the xref information in a template dwg-file (including position)?

I had two features that both had FME Geometry of single point that I merged together with FeatureJoiner. The result of join I have single feature with FME Aggregate, with both points inside that. My question is that I want to get the distance (preferred in feet) between the two points that are now inside a FME Aggregate.  I figure the easiest way to do this is with Python caller. I tried looking at the forum question below calling Python. However, I couldn't determine how to use it to get both my FME Points out of FME Aggregate. https://community.safe.com/s/question/0D54Q00008z6yR3SAI/distance-calculation-per-pipe-segment If there are other suggestions, please let me know.  I'm attaching a sample FFS file with the data points. Can open and see the features each have FME aggregate with two FME points inside that.

I am currently creating a network by running nodes to a central point, using a 2d Grid as my network. I am noticing that points that should follow a similar route, sometimes take a slightly different path see below. I'm wondering if there is anything i'm missing to try and avoid this?  

For example, I have two features with different code in their field "code".These two areas overlap when I use the transformer "AreaOnAreaOverlayer"and I have a field named "overlap" where it writes "2".  But now, I would like a field to know if these overlap include the same code of no. In this example, the features (area) haven't the same code. Thank you!

Currently, we have FME Desktop 2012 installed in our system. I would like to know, that if I install FME desktop 2020.2 in the same system, will the activation key remain same or will it differ? Please suggest.

Hey everyone, I am trying to write a file to a temporary filepath in my PythonCaller script and I thought that using the TempPathnameCreator transformer might save me some time coding something which is a basic function in FME. Unfortunately if I try to write the file to the location I get a python error that says that the location does not exist. I have used the OS python package to test if the temporary path is valid and it is not. Am I using the TempPathnameCreator incorrectly and is it logical that my PythonCaller is unable to write to the temporary location?

Hi I need to post requests to SOAP to retrieve some information about Planning cases back in XML and I have read the article: https://community.safe.com/s/article/working-with-soap-services Our process is more complicated as I need to log in and out of SOAP at the start/end of the process.  I created steps in a TestCase in SOAPUI and it worked and I have set up a workbench with the following transformers: CreatorXML Templater (for login)HPPTCaller (for login - cookies enabled)XML Templater (to Get data)HTTPCaller (to Get data)XML Templater (to logoff)HTTPCaller (to logoff) While this worked for retrieving one planning case I actually need to retrieve information on multiple cases but cannot get this to work. I tried two things: 1) I created a spreadsheet with multiple planning case references in, read this into FME (replacing the Creator) and changed the value in XMLTemplater to use the attribute value (using fme:get-attribute), instead of a hardcoded value.This appeared to be attempti

Hi Community,Based on the Figure 1 table, two fields exist as mentioned and I want to find the results as mentioned in Figure 2I tried so many transformers and had no luck.Figure 1Figure 2Please help me with how to get the results.

I created trees in citygml based on point data. The tutorial is described here:https://hub.safe.com/publishers/con-terra/templates/citygml-create-solitaryvegetationobject-with-implicit-representationWorkflow:Result: No I will set a color for this trees. Unfortunately it is not working with appearance setter. No appearance is set inside citygml file. In the description it is written: "tree models: can be any kind of 3D object (Sketchup, OBJ, DWG, ...) but currently does not work with geometry containing color appearances" So does anyone know if this is possible maybe? We need to color this trees Hope someone has ideas how to solve this kind of problem?

Hi friends, I would like to filter roads (Name) that passes through more than 2 suburbs (Suburb). I do not see a straight solution in Tester. Can anyone please give me a clue to about this issue? best regards,FS

This process used to work fine but I realised lately since updating the database connection due to SQL server moving I see it does not update the table like it used to. It stops working at the GeometryExtractor but no errors.  I do getEND - ProcessID: 888, peak process memory usage: 226836 kB, current process memory usage: 93912 kB Can that cause the issue and what would be a way around this issue? Regards, Josh

I m trying to get the data from KMZ and push it to the ArcGIS portal everything is fine but getting errors in the writer<class 'FMEobjects.FMEAggregate'> cannot be converted to esriGeometryPolygonanyone knows where I'm wrong

We want to convert a GDB to SHP file with field type string and length>254. How can we keep the data with maximum size 254, but not ignore the dataThanks

I have data in S57 format coming from the UK Hydrographic Office (UKHO) which I need to read into FME.When I try to read them in I get the following error message: DE4OS09G.000 isn't an S-57 data file, or catalog.Failed to obtain any schemas from reader 'S57' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. I tried to read them with FME 2022.0.0.2 (20220518 - Build 22343 - WIN64), and as I point out in the question, the access to the files is restricted. There is at least an UPN (User Permit Number) needed to read the data. I do have one, but no possibility in FME to make use of it.

We have a FME server installation which has been active for a couple of years now without issues. Today I got a message from our sysadmin that the machine where FME server is installed is running out of disk space.It turns out that in the Postgress database that is installed with FME server large files were created. I can't find any logging that would explain how and why these files were created. Everything appears to be running smoothly. Does anyone know a possible cause for this and how to remove these files in a responsible manner? Edit: So, I have been able to connect to the Postgress database using PgAdmin4, installed with fmeserver. It appears that since some time every second a couple of error messages are written in the table fme_sysevent_history. That table is now 11 Gb. So that mystery is solved 🙂 (apparently it has something to do with https://community.safe.com/s/article/FME-Server-Engine-ERROR-Missing-or-expired-workspace-chaining-context ) So I'd like to t

BADNEWS: Cannot convert null string into an integer(C:\\code\\fme\\foundation\\framework\\util\\stf\\stfutil.cpp:346) class StatusInfo *__cdecl STF_stringToUInt(const class ObsoleteString &,unsigned int &)... Last 2 lines repeated 6 times ...​this error often display,when read excel 、shp 、 dwg file​

Hi all, I will create trees[citygml] based on point geometry. On the internet I found this tutorial: https://hub.safe.com/publishers/con-terra/templates/citygml-create-solitaryvegetationobject-with-implicit-representation Unfortunately *SKP format is not supported for my fme version. So I have tried it with obj models. But this doesnt work for me! I got this rejection code: INVALID_SHARED_ITEM(SharedItemIDSetter). How can I solve this problem? Workflow:

I am trying to create a new attribute for each element in a list. The tables below show the desired outcome. Here is an explanation.For every item in the MASTER list I am loading its corresponding detail list and saving it as a parameter. I want to take the corresponding list and transform it to the example below. I could accomplish this with a database view or query, but would like to be able to do it in FME. I can assume that all ITEM_NAME values are known, which means all the possible attributes that I need to add could be added ahead of time if needed. Note that for every record in the master list, it won't have all of the possible ITEM_NAME values. My process right now is very brute force, and I am thinking there may be a transformer I haven't found that does this or a variation of this easily.  MASTER ListIDNAME1Bill2Sally DETAIL ListMASTER_IDDETAIL_IDITEM_NAMETYPECOLOR1AShirtLongRed1BPantsJeansBlue2CShirtShortGreen2DPantsDressPurple2EHatBaseballRedTransformed Mas

I've got a set of polygons from a PostGis DB and want to write them to DGN. On one level, I've got the polygons and on another level, named label, I want to put out a text string from an attribute. Some of the polygons have more than one entry here, which leads to stacked texts - I've used a centerpoint replacer, labelpointreplacer and dgnstyler. I guess when only having two or three entries, I could solve the problem by subtracting a fixed value from "igds_insertion_y", but I don't know how many entries will be there in advance and already encountered some cases where a polygon had 40 to 50 entries I have to write one below the other.