Best Answers

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  

In FME Server Notifications I used a JSON Reader to digest the incoming Topic Message and get at the relevant information to pass downstream in my translation. However when I try and create an Automation using the process the workspace fails with a 'file does not exist' error. How can I use the trigger event as JSON to run a workspace in Automations?

Reading/writing files(e.g .xlsx) from /into local drive not working in FME Flow 2023.0 (b23332) but FME Form does read/write the same files from local drive.

I have an excel file that does not have any merged cells. Any cell that is left blank is supposed to take the value from the previous row. How do you do that in FME without looping through a list? This is what I haveAnd, this is what I want (with grey-color being the items I want to automate with FME): 

I have data going through feature writer that creates my csv, that then is uploaded to azure file storage using its connector in fme, once I successfully upload the csv, I want to delete that file from FME_DATASOURCE where I wrote it in the earlier step. How can I do that ?

I am trying to access each row of the excel data I read with pythoncaller. How can I do that         coulumnData = feature.getAttribute('Column1')        data = str(coulumnData).split()        for row in data:            print(row)and how do I read FLOAT values as well? I do not understand what kind of object is returned by feature.getAttribute. If I print coulumnData, it is printed nicely row by row. But, how do I access those row of data? I want to do something like         coulumnData = feature.getAttribute('Column1')        data = str(coulumnData).split()        print(data[10]) 

Hi, I would like to use FME in order to retrieve some data by sending HTTP request to a REST API.  A GET request can only retrieve 1000 entries per call and follow the FIFO method (First In, First Out). So I need to GET 1000 entries, process the data and then DELETE 1000 entries and start the cycle again until there is no data left. I setup a loop in FME:I've read on this forum that a blocking transformer can not be used in a loop without beeing exported, so I've exported the custom transformer GET_API that contains (.FMX): So each loop should produce 1000 features.Outside the loop it works well when I only send 1 request. But inside the loop I get this error message: HTTPCaller is blocking and cannot be used in a loop I can not use a CLONER or something like that since I don't know how many cycle is needed. Do you have another solution ? Is that even possible ?