Transformers

I am trying to use the HTTP caller to post the zip file via FME server Rest API. If someone has any starting tips, I would appreciate it. Thanks

Hello, fellow FME-ers! I have a question for you. When I use the HTTPCaller I want to send a request and then control the time out length before I receive an answer. From what my college and I can read in the documentation there is no way to do this?

I'm using a DatabaseJoiner to look up rows in an Excel file. This Excel file has about 6,000 rows and about 20 columns. I have an integer FME attribute that finds a matching field in a row in Excel. About 5 'Fields to Add' are concatenated into a new FME attribute. This works great! I have 4 more FME attributes that contain 1 to 5 comma separated lookup values. One sample value looks like this: 13045,52136,38010. I need to look up a row in the Excel file (for each of the 3 values in this example), then cancatentate the 'Fields to Add' then cancatentate the three final strings into one big string. Do I have to expand "13045,52136,38010" into three new attributes then use each of them in the DatabaseJoiner and create a string attribute for each of them? Since I have 4 FME attributes that contain 1 to 5 comma separated lookup values, this means that I'll need to add 20 (4*5) integer attributes for lookup and 20 (4*5) string attributes for output? That is 40 temporary attributes. Is there

Hi everyone, I want to search for all Feature Classes in our SDE and list out only the ones that have a field name 'SDE_UPDATE' (date field) with a criteria that queries the ones that have been updated in past 10 days. Any example workbench to share?

We have done: Register an app and make sure the FME has permission to use the app. Make sure the user is allowed to access the data.

The file gdb is a handy conversion template that avoids a lot of painful domain reformatting.

It is to identify the sum of which group. Otherwise, the result is a list of values (for sum) but not possible to identified which value is for each group of features.

Is it possible to generate a horizontal bar chart with the HTMLReportGenerator?

Hello to all, I'm stuck since yesterday on a problem I can't solve. I want to transfer the attributes of a 2D representation of the roofs of the buildings of a city to their 3D version. I have my 2D data in .gpkg and my 3D buildings in .dwg. According to my geometryfilter, the roofs are surfaces and the 2D data are areas. Everything seems to work on the first objects, my attribute replicates correctly on the concerned roofs, but I still get an error, when processing the 1145th object in my clipper. The error is "Attempted to access the value of an uninitialized optional object". I guess some of the geometries may have a problem, but even with GeometryValidators to filter my 2 data sources, nothing changes. What method would you recommend to fix this problem? Are there better ways than GeometryValidator for this kind of problem? Thank you in advance for your answers.

I am new to Json queries. I am trying to extract the details from a arcgis feature service as a spreadsheet for the ESRI living atlas requirements. I have gotten really close but I want my features and tables to be in their own column (second screenshot is what I want). What I am getting is the feature layer AFTER its attributes, and in the same column. I am hoping the resulting table can go into the corresponding feature layers metadata page, as they are manually updated at the moment. There is probably a way to do this using substring extractor, but I was hoping I could do it using json as I have to replicate this for 10 more data products.

Dear readers, A strange thing occurs today. In an an AttributeManager, I changed the value of an output attribute, from a fixed string to using a user parameter, partly. The original string was: mkdir "Y:\\Basis\\Kunstwerken\\@Value(KWK)\\@Value(KW_CODE)" I substituted the part in bold with a user parameter (in bold, too): mkdir "$(Kunstwerkmappen)\\@Value(KWK)\\@Value(KW_CODE)" Now, here's the funny thing. If I provide the user parameter with the original string, the result is (one record as an example): copy "I:\\BEHEER\\Temp\\Ferdinand\\LM_fotos\\Pictures_LM249DrempelsZestienhoven\\061720122651.jpg" "Y:\\Basis\\Kunstwerken\\Gemalen\\KGM-231\\061720122651.jpg" All seems fine. But the idea is to be able to change the value of the user parameter. So I tried filling in "I:\\BEHEER\\Temp\\Ferdinand\\LM_fotos\\Kunstwerken" (without the quotes) I get this result: copy "I:\\BEHEER\\Temp\\Ferdinand\\LM_fotos\\Pictures_LM249DrempelsZestienhoven\\061720122651.jpg" "I:\\BEHEER\\Temp\\Ferdinand\

Why isn't this easier in FME? I've tried lots of examples on the Hub, but can't get any of them to work. The Attribute Pivoter is difficult to use and never gives me the results I need. I can perform this very easily in SQL. I'm trying to turn my rows Vxx into columns with the value of Litres, grouped by all the other rows. Any idea how I can achieve this? Thanks in advance!

Hello, Following this example as a starting point: https://community.safe.com/s/article/how-to-read-all-feature-classes-from-multiple-esri I am able to convert all of the feature classes in a file GeoDatabase to shapefiles. In production, the workflow would actually import the feature classes into an Enterprise GeoDatabase, while reprojecting the geometry as well. After making the modification to the above example so that the output is directed to our EGDB and then running the workspace, the log indicates a successful connection, however it subsequently fails with a very unhelpful message, "Error running translation". Below is a screenshot of the workflow, modified to test for particular feature classes (as well as a disconnected reprojection step, as I'm not sure if simply placing it between the FeatureReader and Dynamic Writer would work, considering the dynamic nature of the workflow that would input to sources to the reprojector). And the EGDB writer properties and parameters: Also

Hi, how can i order the nodes on a line. I put line segments into the topologybuilder to generate its topology. in the result i got an orderd line (see attachment) but unfortunatly the nodes are not really ordered (see second attachment). can somebody explain how can i get the right order of the nodes on the lines? thanks in advance

Hello everyone, I have to extract information from a web page that shows a map with a database connected to a list of projects in the area, could anyone tell me how to do it? Here you are a print screen of the web page

Workspace I meant: ttps://hub.safe.com/publishers/con-terra/templates/citygml-create-solitaryvegetationobject-with-implicit-representation#description

I'm an FME newbie and am trying to do the equivalent of a join in GIS, where I have a key field in my source data and a key field in my joining data. The issue here is that the fields in these layers are of different data types (source = int, join = char). I tried to use the featurejoiner for for this, but no joined attributes came across in the output. I'm assuming this is because they are of different data types. How can I get around this without having to write a new dataset that has the char attribute converted to int as an intermediary step? Is there a way around having to do this?

Hi all, I would like to: list feature classes/layers from a file geodatabase. Sort. Keep first N tables and drop the rest. All is good till dropping the tables . So my question is how to drop a list of tables in a File Geodatabase I looked at SQLExecutor and there is no option for Esri File geodatase. In the geodatabase writers you can only "Drop and Create" tables. This example seems promissing, except I would need to update the User Private Parameter with an sql of tables to drop, and it does not seem to be working in that direction : workspace variable => Published Private Parameter. Or does it? https://gis.stackexchange.com/questions/251542/how-to-delete-a-single-feature-class-from-a-geodatabase-using-fme Just to mention that in this example, if I hardcode the Published Private parameter with list of tables to drop it works "FME_SQL_DELIMITER ; DROP TABLE first_table; DROP TABLE second_table;" All suggestion are welcome and thanks in advance

I am looking for suggestions on how to create Response Areas based on a Road Network and Station Points. For example: DATA INPUTS: 1) Greater Geographic Region Polygon - basically the greater region of interest. 2) Road Network within Geographic Region - network has topology, along with speed and time cost attributes. 3) Station locations - they may or may not fall exactly on the network. How can FME take the Greater Geographic Region and split it into sub regions; one region for each station based on the drive times out from the station. The result is a Station Response Area.

I am reading a CSV file. The data does not have a header record and in the Fields setup of the reader I select None for the field Names Line (default is 1.) The data preview shows the first record being read at that point. However, when I save the reader and preview the data it starts at the 2nd record.

I'd like to create a string attribute with a specific length. I'm using an Esri AGOL writer to create and write to a feature service. In AGOL, I want the Field length of this string to be 12. In a PythonCaller, I'm using: objText = '00123' feature.setAttribute("TextField_test", 'ABC' + objText) In AGOL, this creates a field of string type with a length of 254. In an AttributeCreator (before the PythonCaller), I created the 'TextField_test' attribute with a value of @string(12). This creates an attribute a value of '@string(12)' which is obviously not what I want (the python overwrites that value). In AGOL, this creates a field of string type with a length of 200. I understand that I could the User Attributes in the AGOL Writer to Manual and change the attribute to Width to 12, but I also have an Excel Writer and would have to set the Cell Width to 12 as well. During development, I'm adding and removing many attributes, and I don't want to manually change my attributes in multiple write

I have a Geopackage with lots of tables and would like to speed things up by only reading the needed tables for later processing. The 'Where' field only applies to table content, I want to filter on table names. I would like to use a wildcard to import layers containing a certain string. Example In a dataset all hydrographic layers might contain the string 'hydro' I would like to use sql to only import these layers by using something similar to 'LIKE %hydro%' edited by including an example Edit 2: I realise I made a huge, and embarrassing, typo. The file I am working with is a geopackage, not a gml... *facepalm*

Dear, I have a workspace that reads a in a postgis database with an SQLExecutor. It all runs smooth. However I want to make my workspace generic, so that it can use other input data from different databases/schemas in the future. That is why I put everything to read in user parameters. That being said I encountered the following problem. My workspace runs fine with the original data. However when I change the name of the schema of my input data, and I change it in the SQL executor accordingly, I get the following error: 'Error executing SQL command ('select version(), postgis_version()'): 'ERROR: function postgis_version() does not exist' When I try to read in the schema with the changed name with a PostgreSQL reader, it works just fine. However this is not desired, since my data contains geometry. Does somebody has any clue what can be the cause for this? Attached you can find the logfile and some screenshots. I tried running it both on the 2021 version of FME desktop as the 2022 vers

I am using NeighborFinder to find adjacent horizontal (or vertical) lines. I create a list and the transformer automatically supplies the angle value for each item. I want to remove any list item which does not have an angle value of 90 or 270. The ListElementFilter has been very helpful, but it seems to only filter one value at a time. I also tried AttributeManager to conditionally change the list{}_angle value to 90 when it finds 270, but no luck there. Would this be a Python situation? Any help is appreciated.