FME Form

Hello,I'm attempting to write a dataset to AGOL. This dataset comes from another system with ~25,000 records. So far I've been reading this dataset and processing it with my workbench without error for a some time now. Last week it began to fail with the error:"ArcGIS Online Feature Service Writer: Encountered an unexpected error. The error code from the server was '400' and the message was: ''. Details: 'Field WORKDESC has invalid html content.'"The datset has a field WORKDESC that contains freeform text entry where staff describe the details of a building permit. I suspect from my troubleshooting that somewhere along the line a strange character has been entered that the AGOL writer is interpretting as html content.I'm looking for some tips/suggestions as to however to 'clean' this field so that this error doesn't hurl my workbench. However, I don't really want to manually dig through the dat

Hi FME Community,I have converted my Excel file into a CSV file. I would like the heading to be automatically deleted.In the picture I have shown with red marking which part has to be deletedI would be grateful if you could tell me whether there is a solution.Thanks in advance

Hi,I have a scripted python parameter which generates a unique id. This parameter is used in a lot of SQLexecuters to to create and insert into temporary with this id in the name of the table and such. When I run the workspace it works fine, but when I put feature caching on the value of the parameter seems to change each time it's used in a SQLExecuter. Is this a knwn issue? Is there a simple work around?I use FME 2021.1.3.0. I don't know if it worked before. Thank you,Arno

I have a basic project as shown in the screenshot. In this example there are 54 items that need data cleansing (at the rejected port), I am wanting to send ONE email at the conclusion of this run, with a list of all the Property Numbers that were captured here.  If I add an emailer at this 'rejected' port I will get 54 emails. I am assuming there is a simple way to list then expand into the body of a single email? 

I have created a "i3s_terrain_mesh" out of a DEM. Following the description on this page, the terrain mesh would replace the existing terrain in the scene viewer. In case we talk about the ESRI ArcGIS Portal/Online Web Scene Viewer, how would that work?  As far as I understood, only elevation layers can take over this job when being added to the scene. Even turning an input into an "i3s_terrain_mesh", we deal with an SLPK, that has to be shared and published on the Portal.In a web scene, such an added SLPK is not interpreted as a layer that can be added to the "Ground" - replacing the default terrain 3d elevation coming from ESRI. Have you any ex

Hello, so I want to find a missing value as all the "Unit" must be in sequence in each floor.​Here are my rules:All the units should be assigned sequentially to the corresponding floor, meaning 1/F: Unit = 0001, 0002, 0003, till to the largest number in the data2/F: Unit = 0001, 0002, 0003, till to the largest number in the data​I have "FloorNo_FromFloorPolyID", meaning the level of floors."Test_Unit_No" meaning the numbering of the unit.​I want to find out the missing unit number of each floor as the input data will have a lot of floors in the future. As the sample shown below, Floor 10 is missing Unit 0001 to 0004.​Could someone please give me a hand. Should I use python caller? Yet I have no clue how to write script ... please help.​Thank you in advanced.

How convert to complex XML to creating relational database tables ? using xml hieararchy

I have xml file and convert relatinal database tables for using xml hierarchy(parent-child) so is there any automation tool for this process ?

Hi all!My CAD layer is a mapimport from shapefile. So, it basically still has attributes when I converted to a layer with point type. When I wanted to export again to shapefile through FME, I don't know how to retain those attributes.  In CAD, actually you can use MAPEXPORT to retain attributes, but then it will be time-consuming if you need to export one by one when you have many.  So guys, do you have a solution for me to solve this problem? Thanks in advance!

Hi all,I have a CSV which I read into FME desktop. It is bore hole data with attributes:site: Adepth: 0depth: 20depth: 30end depth: 35 I want to select the max(depth) for each 'site' and update that value to be 'end depth', then proceed with other transformations. Note sure what transformer to use to do this?I've looked at Tester, inlinequerier...help ? thanks

Hello everyone,​So I want to do something similar to "IMDF Validator".​My data format is "GeoJSON" in one single file. When I import the data, it will break into 4 feature types. ​I just not sure how to set up something similar to IMDF validator, with "Creator" at the front (just like the picture I uploaded? Also, the user parameter of IMDF validator is set default in ZIP file, yet I have to set it to geojson file.​Should I use Create Custom Transformer? But I am not sure how to set the parameter. It is because my data will be getting more and more complicated. I have to make it more tidy first.​Thank you in advanced. Zach

I'm trying to import a text file without headers to FILEGDB while using the SchemaMapper Transformer to rename the columns. I've followed tutorials and articles but am not successful. Columns aren't being renamed and when I run the workspace no features are written.Any tips would be greatly appreciated. Here are screenshots of my parameters and workspace:

So I have multiple columns of data that return a yes or no value. I'm really only concerned with the yes value.  When the value in the Cut Grass attribute is 'Yes' - i want to replace the Yes with say "cut grass to 100mm"Then i have another Yes value in Remove Flammable materials column and I want to replace the Yes with "remove materials".  Is there a multiple string replacer transformer that I can use.  I need to do this for approx 13 different attributes. I have read about string replacer or attribute value mapper. But whilst string replacer can replace multiple attributes to the same replacement text it doesn't allow for differing replacement text individual to a column.

I am trying to get the location curve property for walls using FME and Revit Reader.  To be clear, this is not the geometry of the wall, but the line Revit uses to create the wall.  From what I can tell, the property is not in the actual file itself, but the result of a Revit API method:  wall.Location as LocationCurve I use Python scripts in Dynamo, but this is unknown territory for me.  Is it possible to install Revit API modules and do something like this?import fmeimport fmeobjectsfrom Autodesk.Revit.DB import *  def locLine(feature):            line = feature.Location.Curve    if isinstance(line, fmeobjects.FMELine):        cLine = line.getAsLine()Any insight is appreciated.  For now, I will get the lines in Dynamo, export to Excel, and then merge in FME.  Not very elegant! Thanks,@lorenrouth

I have set up a python script to run a workspace through the FME Python API using FMEWorkspaceRunner. Python is throwing an error called 'FMEException: 1: Failure running workspace "<my path.fmw>" '. I did some troubleshooting by removing the HYPER writer and replacing with a csv writer, then a gdb writer. Both of those writers worked fine. Also, the workspace works fine without going through the API. Something about the HYPER and the API. Any suggestions or known issues? Thank you, TylerFME 2021Python 3.7

I have time-series data collected at 5 minutes intervals and I would like to summarize or average it to the daily interval. How do I go about it in FME? Thanks

I've configured the SMTP Publisher to receive emails, but when I send them to FME Server I get undelivered responses.  I looked at the email.log for the FME Server Publishers and I see: "WARN Email received for unknown recipient [email address], so dropped  What does this mean?

Hi all. I'm reading five feature types from Oracle using a Feature Reader and I want to suffix each of the attributes in each feature type with a text string.  The reason for this is that I'm running some line on line and line on area transformers and the attributes from each feature type have identical names. The end goal is to generate a dynamic schema (with renamed attributes) on the output tables based on merged feature types from the transformers mentioned above. Is the bulk attribute remover the correct transformer to be using here? Thanks,Michael What have I missed?

Hi, I need to validade if the sum of the numbers is pair or odd. How to make this?

Hi FME Community,I would like to reproject my file into another coordinate system. I am looking for correct coordinate system. ArcMap gives me a correct result. FME gives me wrong coordinate after the reprojector.the pictures show which coordinate systems I used in FME and ArcMap. In addition, my file belongs to Germany. Thanks a lot in advance   

Hello #FMECommunityWelcome to What's Up Wednesday. No FME news today because it's... Community Appreciation DayDid you think we'd forgotten? Last year we declared October 27th as our annual Community Appreciation Day, and we're back this year to celebrate and honour top community members for 2021. What are we Celebrating?Interaction! Interaction between users makes for a strong community. You might have seen our new purpose statement : "We gather together persons with an interest in FME and how it can be applied, to allow them to work, learn, network and socialize together, in a friendly, fun, and collaborative space, so that all members can advance their personal goals, while sharing and building up the wisdom of the

I think it takes a lot of time to convert one by one.

When using Intersector in FME Server 2020.1 Build 20594 - linux-x64 the processes get freeze or sometimes the process restarts without given errors messages, same processes run in FME Workbench in Windows based computers with less resources.

I wonder if aynone has expericence with using asyncio in python FME?I've been trying to decorate with some asyncio.coroutine and do some async def, but I cannot grasp the whole picture on how to combine a syncronized FME project with an async library like asyncio.Anyone who would share their knowledge on this topic would be Awsome!Paal

I am converting ArcGIS data into a V8 DGN file and need to linear pattern a line with an existing cell. I see where you can set the igds_class to 5 (LINEAR_PATTERNED). However, I do not see any options to set the active cell to be a pattern, so the line does not appear in the DGN file. Is linear patterning supported in FME 2020.0.2.1?