Best Answers

Hello ,How to convert multi line strings in cell into one line at the same cell ?I have many cells that include the strings in two lines at specific cell includes building CR LFone side i want to change the two lines into one line to be building one side in one line at the same cell CR LF : created from Fme ,I am not sure what does it mean ?fme 2021  

Hello I have several point data sets (different Excel files) that I would like to clean up. I would like to delete points with the same position (X,Y) and only keep the point with the highest height (Z).I am currently deleting points with the same position with the Matcher Transformer. This works wonderfully. Now I have not yet found a way to say that the highest point at the location cannot be deleted. Is there a way in FME to influence the selection of the points to be deleted when cleaning different data sets? The height of the objects is available both as attributes and as 3D coordinates.Thanks a lot

Hi All, I have a record with these attributes: ID, Condition1, Condition2, Conditon3. Condition values are integers. I want to write to an new attribute the name of the Condition attribute with the highest Condition value. IE if records is ID =Bob, Condition1 =20, Condition2=0, Condition3=80 then write out 'Condition3' to my attribute.  I have created a list, sorted the list then used listindex set to 0 which returns highest value but not the attribute name from where it came from. Any help appreciated @takashi Thanks Steve

Getting this error message : "Unable to perform any licensing related tasks. Please check your Esri ArcGIS Compatibility setting. This 64-bit version of FME requires ArcGIS Desktop along with 64-bit Background Geoprocessing; ArcGIS Pro; or ArcGIS Enterprise. Refer to this this article http://fme.ly/qua for more details FME version installed : 2021.2.6ArcGIS Pro installed 2.9.0 Triggering using the command as shown in the screenshot, but it fails with above error message. Any ideas pls? 

I am working as a consultant for Consortech Solutions and I have a client who is trying to make his G3 Smallworld connection work in FME using the SBS Plugin for Smallworld. Unfortunately, the reader in FME doesn't work all the time. When it fails to show the table to choose from for reading data using the SBS plugin for Smallworld reader, the error message returned is "Bad or Invalid License for feature: spatialbiz_read [-12]". What's weird is that sometimes he is able to read his data in FME using that same reader but sometimes it fails to read the data.  Is that something people have experienced in the past and if so, is there a way to solve this issue?

I have a file geodatabase where backups are stored with a date in the name that gives the backupdate, BU_20230724, BU_20230731 etc. How can I select that only the latest will be read for further analysis? Normally, a feature class is selected under Constraints > Tables and you can select the one you need but, the latest Backup will not stay the same during the year. In a automated proces I would like to select the one with the latest date without changing it manually.

HI. Do I still have to manually input using the AttributeExposer transformer, like the answer to the question below? https://community.safe.com/s/question/0D54Q000080hcshSAA/problem-ifc-reading-user-attributes What should I do when a user-defined property exists for each IFC file in the way that the fmw file runs FME Application in the shell and operates? please answer about my question. Regards,Bongsup Kim​

Hello. I´m Topo79.I'm trying to export through pdf_rasterized_pages to an GeoTiff in its real coordinates but it's imposible. I've transformed a gdb into Adobe Illustrator, ffs and GeoPDF at once, but from GeoPDF to georreferenced GeoTiff it isn't posible.Thanks a lot ;)

Hello,I have a main table called "Documents". I need to create a table called "List" based on data from the "Documents" table. Within the "Documents" table, I have a column called "ElaborationType," and within it, the number 1 represents the main document. Numbers 6, 14, 33 represent documents related to the main document, i.e., they are lists. My goal is to generate results in the "List" table where the "RecordID" in that row matches the "ElaborationType" equal to 1, but it also repeats or duplicates that number based on the numbers 6, 14, 33.(EXAMPLE: 2302(6), 2304(MAIN DOCUMENT NUMBER 1), 3177(14) belong to the same group because they are in the same cadastral municipality KO_ID).Within the "List" table, I need to have 2304, 2304 because they are lists for the main document 2304, and they must have their corresponding year from the "FromYear" attribute.Is it somehow possible to solve

Hello,I am currently working with FME Desktop 2022 and I have encountered an issue while trying to generate sequential numbers in a column based on attribute values. I have two tables, "Dokumenti" and "KatOperat," and I need to create a connected table called "ListKatPlana." In the "ListKatPlana" table, I have two columns: "ID_KatOperat", "ID_List" and "creationDate".The challenge I'm facing is generating the values for the "ID_List" column based on the "Koliko" attribute in the "Dokumenti" table. The "Koliko" attribute represents the number of records that should be associated with each "ID_KatOperat." For example, if I have an "ID_KatOperat" of 2304 and the "Koliko" attribute is 9, I need to generate numbers from 1 to 9 in the "ID_List" column for that specific "ID_KatOperat."I have tried using an aggregator to separate th

Hello, I have a client who just installed the latest version of FME Form 2023.0.2.1 Build 23339 WIN 64 and when he runs a workspace, nothing shows up AT ALL in the translation log window. It remains completely blank. We tried using the Log File in the logging section of the Workspace Parameters and when we open this file in a text editor, it is not empty and shows the translation log as expected. I am starting to think it might be just a weird visual bug with FME Form 2023.0.2.1. Did anyone else experienced this bug in the past with 2023.x or any other version of FME Form? I added pictures to show what I mean by a "blank" translation log window and also my client's log settings and log file. Thank you.  

hi community, I need some help.I would like to connect my information system to Planning PME via API. For that, I need to get a token.With a OAuth 2.0 protocol, I know how to do but the protocol is not a OAuth 2.0 protocol. I just have a API key and my login ID Perhaps I have to enter these parameters in a HTTP Caller?I attach the API Documentation. Thanks for your help   

Currently I am moving from FME 2018 to FME 2022, but during the FME Desktop Advanced trailhead training it says that some transformers only have cosmetic changes. I want to know what the main, commonly used transformers which I can advise my team to always upgrade in their workbenches. Thank you in advance

I need to convert: { "keys": [ <ordered list of field names>], "values": [ "<ordered list of field values, matching the keys field order> ]} What is the best way to do this in FME? Input example: see attachment  

HelloAs stated in the title, the left pane takes too much space thus making harder to write / review codes. It basically cannot be resized. Noticed this in FME 2023.0.0.3 and 2023.0.1

here's the curl:curl --request POST \\   --url https://api.assetpanda.com/v3/session/token \\   --header 'accept: application/json' \\   --header 'content-type: application/json' \\   --data '{ "email": "username@company.com", "password": "pASSWORD123"}'

Hi community, I've many postgres table in source, with differents structures. I would like to send them in Big Query, with, for each table, the same structure, so I thank to regroup source and regroup target to do that. But, I would like, transform the date format for each postgres field. In fact I know to do that with DateTimeConverter but I've to declare all field one by one. It is possible to do that with "all date fields" ? Thank you for your help.

HiI drew a simple shape with google my map and export it to kml in my browser then i convert it to dwg/dxf with FME quick translator to modify the shape with Autocad, but the original map stretches out and shows a wrong map, it also happens when i convert dwg/dxf files to kml or gpx.how can i fix it?

So when I place a reader und just look at the untransformed model it already has the wrong geometry. Changing the settings for stroking doesnt help. It seems like FME just doesnt like curved volumes, but that seems like a big lack in capability, which seems unlikely, because I havent found anything about this topic here. Is there a way my file can be read correctly or at least closer to the truth? The way it is now, I cant really use it. Here is an example:The color and height difference are intentional. What isnt, is that the lower object lost a few vertices compared to the higher one.

I have files in a folder. I want to select the files with a path_modified_date from the year prior. Example, if the path_modified_date contains "prior year" then zip these files. I know how to do the zip files part.  It is the If the path_modified_date contains "prior year" part that I am having trouble with. The files in question accumulate every year and I would like to set up an automation in FME Flow that runs every March and zips the files from the previous year. I know how to set up an automation. Here is what I have done so far in FME Form. The Tester passed if @Value(path_modified_date) Contains 2022; If I use this workbench as is, every year I want to run the workspace I would need to go in and manually change the Right Value in the Tester to the prior year. I want to know if there is a way where I can automate this portion?I added a Year field to Attribute Manager takes the left 4 digits (the year) from the path_modified_date field. Then I changed the Righ

Dear people, When using the Spatial Relator I get a list of "Spatial Predicates to Test" to choose from. This list is rather limited, it seems to me.  However, the documentation for this transformer describes a "Dimensionally Extended 9 Intersection Matrix (DE-9IM)" at the bottom. This offers more options. But, as far as I can see, the string representation of a DE-9IM is only output as a list attribute with the result. I haven't tried that yet, but I assume that the DE-9IM that comes out corresponds with what is chosen from the list for "Spatial Predicates to Test". Or does it give the exact spatial relationship according tot DE-9IM? Anyway, I would like to compose a string representation of a DE-9IM to use as a spatial test parameter in the Spatial Relator. Is that possible? Kind regards,Ferdinand.

Hi.I have some automations running on 2022.2.2, and had to do a small edit on one of them. Afterwards the automation failed badly.I found that all the workspace actions in the automation had been "cleaned", i.e. set back to their default (workspace) setting of parameters. All of them. And I hadn't edited any of them, just moved some connections.No wonder the automation failed badly, as I'm e.g. using automation writer features to pass information between the actions. And have some global settings too for good measure.Has anyone experienced something similar ?What might have caused this ?Cheers.

Starting out with feature reader, and I am definitely missing something. The input dataset has about 1,600 records. Why is the output at 366,458 (and counting) about 10% of the way through? Thank you,

I would like to convert ecw files into other raster formats, and since I do not know what output format other users prefer, I would like to provide a public user parameter with a list of available raster formats in FME, and use the parameter to specify the format used in the FeatureWriter. Looking at the FeatureWriter I cannot see the possibility of dynamic, or even a selection of output formats. It also seems rather cumbersome to get a list of all raster formats FME is able to write. Is there a possibility to tweak the FeatureWriter to take the format from a user parameter list?

Hello , How to split the content of one column to two columns ?my output of aggregator looks like string12-string56 at same cell in one column and all rows similar . i would like to have two attributes one called base include string12 and other attribute called next include string56 and implement the method for all rows  Which transformer should i use ?how to use it ?fme 2021 thanks in advance