Transformers

Hello I'm working on an BIM/GIS integration approach. I need to integrate my revit model in a 3D GIS environnement mainly in ArcGIS pro and use it for spatial analysis. Any suggestions about the best approach ? should i simply import it, use data interoperability extension ( quick import ) or convert it to citygml or file geodatabase ? I'm struggling to understand these different formats and I'm new to this. Please Help.

I tried to use DateTimeCalculator, but it has an error output as 'invalid input' but I cannot see where it is.I attach the details. 

I am using "Esri Geodatabase (ArcSDE Geodb)" reader and writer (For read and write features dynamically), but empty feature classes not listing under feature types.

Hi!I see that AreaBuilder transformer does not work with 3D lines and cannot generate 3D area. But what is the solution here or what alternative exists in FME?I have a data set with roof lines that describe roof shape. In the last 3 months I have tried many possible combinations of transformers and tested many parameters but never got the desired result.Anyone can help me with this?

Hi, I need to understand some FME log statements that is :  INFORM|Combiner: The following attributes will be generated with default values because they are required but not present on the feature: fme_rejection_code When writing output to the ArcSDE writer, which is set to Insert and Update, I use Attribute remover to remove attributes that I do not want to write, but I forgot to include fme_rejection_code in a list of attributes to remove. I am concerned that the writer will include this attribute in the feature class. I realized I had forgotten to remove a couple more attributes from in attribute remover. Is it going to break something at the back-end ArcSDE. I dont see any new attributes added in the feature classes though.I appreciate any assistance on this issue. Thanks,

I have 3 questions with regards to converting ifc to citygmlI did a conversion from ifc to citygml, but when I look at the converted citygml model, I only see some attribute information displayed. Is this a proof that converting ifc data to citygml will definitely eliminate some semantic aspects?How to display volume information of each converted room from ifcspace ? Is it because the space modeled in lod4multisurface cannot be determined in volume? (The conversion scheme I made refers to the conversion scheme found on the fme website and the experiment that has been carried out by the geobim project). previously I also converted ifcspace to Room element. The room is modeled in lod4solid on fzk software and I can see the calculated volume resultI converted the ifcslab element into a citygml model, but when making a conversion scheme to citygml, the element must be modeled on the floor surface element. If it is not modeled on the floor surface, the conversion results cannot be displayed

I have a workbench that has a ESRI Reprojector that reprojects from HARN to Web Mercator before publishing to out to a service in ArcGIS Online.Each time get the error:Reprojector: Invalid reprojection parameters%0 Writer: Failed to reproject feature with coordinate system '%1' to '%2'. Verify that the coordinates and coordinate systems are valid, and try againARCGISONLINEFEATURES writer: A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for detailsCnxParcel_Overlay (SpatialRelationshipFactory): A fatal error has occurred. Check the logfile above for details Scott

Hi,I have a set of regular polygons of 4 vertex like shows attached figure.I have to split each of these polygons in 2 parts following red line shown in attached figure. Also, I have the condition to cut in parts of specific amount of total polygon area, for example: 20%. It's important to say I don't have the red line. It's only to explain how to cut the polygon. I tried PolygonCutter transformer from FME Hub but needs to have the line, so maybe the question was how to create the cutter line?  I look forward to hearing your expert suggestions, thank you!

Hi Everyone, I am trying to link a custom transformer, instead of having it embedded in my workspace.  But when I right click on the transformer only "Edit" is shown. The action for embedding or link is not shown (as in the tutorial link below) Any Idea where I am going wrong? Has the UI changed in FME 2022? I tried following this article:https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Desktop/Workbench/custom_transformer_embedding_linking.htm CheersFred

How to convert a .tiff file to .MBTiles using FME?

I can't find SweptSolidBuilder in the latest beta, only PipeReplacer is present but it is more limited (at least as far as I tested it. Will SweptSolidBuilder make a come back this year?

Is there a way to follow/get email notifications of any posts that involve certain keywords?SDO_GEOMETRYOracle SpatialEsri's SDE.ST_GEOMETRY(Possibly SQL too)Thanks.

Hi Everyone, I have a problem. I want to merge our line database with OSM. Is there any options to, make a if condition. What I need: If geometry is same, and the street name. Thanks.

Hi all,I'm trying to use the AmazonAthenaConnector but I'm not sure what the correct settings are. Firstly, what do I need to put in the Bucket / Path fields? Secondly - when I try adding values in these field and run the translation I'm getting the following error:  Invalid bucket name "all-product-athena-result/": Bucket name must match the regex "^[a-zA-Z0-9.\\-_]{1,255}$"Error encountered while calling method `input'AmazonAthenaConnector_2_CALLER (PythonFactory): PythonFactory failed to process feature Thanks,Ed  

Hi  i have values as example as below and would like to round upto 3 decimal evenly. 1968.741344 5977.675803 1968.93 5983.1  Am using above transformer to round up but it returns 1968.7415977.6761968.935983.1 AND i want  1968.741344 >>>>>>>> 1968.741 5977.675803 >>>>>5977.676 1968.93 >>>>>>> 1968.930 5983.1 >>>>>>. 5983.100

Hi all,i would like to concatenate values from 2 lists (maybe 3 later) from 2 fields. The values are in multiline. I can get values with attributesplitter and a listconcatenator but after that, i don't find the solution! After the 2 listconcatenator, I tried the featureMerger but It don't gives me the two new values -concatened and _concateneddate.If someone could help me, it would be very nice!Thank you!

FME workbech READER (raw excel file) TRANSFORMER WRITER ( Desired or Expected RESULTS) SETTING1st row is merged 2nd row id columns names I want the data to be inserted / updated from ROW 3 keeping the first 2 rows same.  Note : Everytime i run FME the number of ROW records will change so results should dynamicaly upated and NO APPEND . WRITER SETTINGS TEMPALTE :

Hi,Could I have some explanation why HTTPCaller does not bring any data from a simple GET from this website: https://www.puntopack.es/buscar-el-punto-pack-mas-cercano/?codePays=ES&codePostal=32005 Not sure if there are any parameters that I'd need to add.The REJECTED ERROR value: "HTTP/2 503"_fme_rejection_code: "NO_RESULT" Uploaded a screenshot of the HttpCaller.Many thanks in advance!J. 

Hi I noticed that the epsg code 7791 is missing in FME 2021.1.2.0. How can read the EPSG database to add it? https://epsg.org/home.html thx Francesco

I'm running a transformer created specifically for some middleware (CTGENIE) that was created for Frontier Communications. It is crashing during translation; the translation log reports that the job succeeded, but there was nothing that was written to the database. It also crashes FME when the transformer is present in the workspace and I try to save it. I have attached the log, but it doesn't seem to offer any clarity on how to get this to work. Best, Alex

Hi all, I have a situation where I want to dissolve adjacent tile polygons based on a count value. For the example below I would expect the total sum to be no more than 100. Less is fine. The less polygons I end up with the better, but optimization (doing several passes) to figure out the best possible result is not that important. It's sufficient to start from one corner and simply add until all polygons have been dissolved. Also there could be a situation where the polygon has a larger count (110 for example) than expected. In such a case it would be left single - as it is.So any ideas on the simplest approach in doing this? I expect some kind of loop function in needed. Not very familiar yet with those...Thanks for any advice!Attached is an example shape file to play with...

Hi all.I'm tasked with updating a table that contains 10+ geometry fields. I'm opening it as a non-geometric table, extracting one (of two) geometries, and reprojecting this to a variable projection, based on other field data and/or coordinate values.This all works well, but when I try to update the targeted geometry field in the database table, all hell breaks loose in FME.I've tried to use the formats "Microsoft SQL Server Binary", "OGC Well Known Binary", and even "OGC Well Known Text".I usually get an error message about mixing image and geometry field types, but now it just times out all the update commands.I've tried using a writer with "update", and the DatabaseUpdater, but both errs, so I've ended up with a SqlExecutor (with an UPDATE command), which unfortunately times out.What is the proper way to accomplish this task ?

Hi.When reading multiple geometries from a single table, they're joined together in a single aggregate geometry collection.The individual geometries can be extracted by using a Deaggregator, with each separate geometry having its original field name as its "name". Writing multiple geometries back to the table requires the geometries to be aggregated, and a MultipleGeometrySetter set to Yes.If updating such multiple geometries, I assume that FME extracts each geometry from the aggregate, and updates the (geometry) field values designated by the individual "geometry name" as field name ?So, if I have a table with 3 geometry fields (A, B, and C), and want to use geometry A to update field C with a new geometry, should I create an aggregate with all 3 (original A and B + new C), or can I just include the new C value in the aggregate when updating ?Cheers.

Hi,I just added an end-sql statement to some workspaces, each with a comment on the preceding line. The comment is a T-SQL line comment on a separate line, i.e. with prepended "--" (two dashes).This fails, as it seems FME gobbles up the first dash before execution, rendering the complete statement invalid.If this WAD og a bug ?Is it possible to add comments as "/* ... */" instead, or would "--- ..." (i.e. 3+ dashes) work ? It also doesn't look like line-feeds in the statement are respected, so maybe line comments are a complete no-go ?CheersLars

Hi FME wizards, I am trying to do a datum transformation on multiple files in a nested folder structure and save the outputs using an identical name and folder structure, but in a new directory location. I've created a replica of the folder structure using DOS commands and trying to replace the existing root folder with a new one.  I'm reading the source files in from a CSV, then creating a new 'outpath' attribute in AttributeManager using the StringReplacer to replace the source root level directory, e.g. the part in bold C:\\Project\\CurrentDatum\\Model\\file.ext with C:\\Project\\NewDatum\\Model\\file.ext. The source and destination directory are Published User Parameters and I use the following in the text editor: @ReplaceString(@Value(_dirpath),$(Source_dir),$(Destination_dir)). When I view this as a new attribute, the directory appears correct. I've used similar logic in Python and it works great but not sure how to link it to my outputs in FME. This is my cur