FME Form

Hi, I have a question regarding the “create spatial index” option in the spatial database writer for Oracle.If you’re truncating an spatial table with an existing index. Do you still need the create index option on or is it redundant? And if not, is there any performance loss in keeping it on?

Hello. I have created some geometries (using Bufferer and Extruder) from 2d coordinate points. Can anybody let me know how I can export them as IFC Geographic Elements in an IFC file?

Hi , I have geospatial pdf has coordinates and I have shape file with other coordinates . i have read the pdf file with reader geospatial pdf and i can see that it has many layers and some data at pdf does not exist in my shape file and some exist  i would like to change coordinates of geospatial pdf to same coordinates as shape file .How could I achieve that ? the shape file consists of lines and polygons (Buildings) and points some of buildings and lines ,i can find also at pdf file but in other coordinates .it locates far away of each other . i have used pdf reader ,parameters coordinate page point and enable non spatial read meta data objects ,Map frames The type coordinates of geospatial pdf is unknown for me .which transformers could be useful to move geo pdf to same location of coordinates as shape file ? i am thinking if there is any transformer to compare between shapes and find which polygon is exact as other then provide shape coordinates to pdf file fme 2021

Hi Team, I have a electric lines and electric devices . I want to split the lines where the device exist . I used the point on line overlayer with 0.001 tolerance . But its creating many new lines with 0.001 feet (less than a feet) lines .Ideally this shouldn't be . Its creating the issues when building the Utility network . can you please help me on this ?  

Good afternoon! Our organization recently realized that we will not be able to make lots of copies of our data into hosted feature classes to AGOL using ArcGIS's Collaboration, as we cannot turn on versioning for our data.  Therefore, we are exploring other ways to make nightly copies of our SDE data up into ArcGIS Online as hosted feature classes. I know that FME can do this, but I am curious if anyone has experience doing this or has any tips. I am relatively new to FME, so I've been looking into a few things but I'm not sure the best route.  For some context: We currently have about 120 or so layers we'd like to update nightly. Only a few of them are heavily edited, some of them are only edited about 4 times a year at most. There are also several layers that have thousands of edits a day.  My thought is to push edits via Change Detector, but the thought of setting up a change detector for over 120 layers is quite daunting. So, I was considering going the "Dynami

Hi, does anyone know the meaning of this error message I keep getting:An error occurred. Here is the information that FME was able to find on the error. Skipped 1491038/1512811 rows in column recordid.Does the problem lie with features number 1491038 until 1512811? Or any time comumn Recordid has value between 1491038-1512811? Or only feature 1491038 of 1512811 features. It's an error I keep getting and those exact numbers come up. The dataset I am trying to reed is a Parquet dataset. 

Hi all,I have succesfully transformed IfcDoor-entities into (shapeless) dwg-blocks with the extracted information being written into the dwg-block. Now I would like to rotate the block parallel to the respective door. But I do not konw how to retrieve this information. I thought I could derive the rotation / orientation information from the footprint (identifiy the longest line-segment of the edgecurve), but I dont know how to do that either. Can anyone give advice on this matter?thx in advance!

Hi, I have a workbench that processes data of X number of rows. At the conclusion I would like to send an email to summarise what was done. I would love something like: Hi Ben,  We have just updated the table with 32 new rows. Here is a summary of the data added: ASSET ID | NAME | DOB 150 | Ben | 02/02/1992 151 |Tony | 01/01/2001 .... .... 183 | Michelle | 03/03/1983I have added a statistics calculator to my workbench, this is currently able to give me the summary (total number of rows) to include in the opening sentence, but I am not sure how to add the 32 rows to the email, formatted as a table. I know this has to be such a simple task, I just cant work out how to do it! Thank you.    

Hello , i would like that each point to find the neighbor point .each point connects with other by a line .so I have a starting point ,i should find the neighbor point and the neighbor point find the next neighbor and so on .my problem : how to let each point to stop looking for the neighbour point if the next point is a starting point because some points are connecting to starting point FME 2021

Not sure if, while renewing, the new license overwrites the older one or do we do it manually?If the license is ok, is there a mistake in how I am using workbench?The license we have is a temporarily renewed free trial license. The error message in the image shows that. Please advice on the same.

Hi, what is the best way to avoid loading in a complete huge singel Parquet file (58 million records). My memory keeps running out. I have the option to split the data into smaller pieces with a Tester transformer selecting the data on date and then saving it to further process, and have done that with a child-parent workspace, and a tester + published parameter for the dates. But it still seems to go wrong due to memory problems. The process takes very long to save by date, especially loading in 58 million records before running the data through the tester. I would love tips on splitting up the data before loading in the complete 58 million records. or any other tips for dealing with Parquet files.  

I get the following error when I feed XML as an attribute from the XML updater. Reading in an XML file is no issue though.This FME edition does not recognize the `' function. Please ensure that the current platform supports this function, the function name is spelled correctly, and that you have installed all required plug-ins 

Hi all, I have created a Choice user parameter and am importing the contents of the choice list (or dropdown) from a spreadsheet.The Import appears to decide itself how it wants to sort the contents of the list. Is there a way this sort can be turned off?I have already sorted the contents of the spreadsheet into the order I want, but the import kind of ruins this order, and then I am forced to manually reorder with the up and down arrows. This isn't too bad with a very small list, but is pretty frustrating with a much larger list (which I have). Plus I know I am going to have to refresh the contents of this list semi-regularly in the future.Does anyone know of a way around this? thankskeith 

I am trying to extract the 1st and 4th word but it just keeps grabbing the first 4 words, I've tried without the ^ and it doesn't work

Hello , i am new with working with geospatial pdf files.I have Problem that geospatial pdf has no real coordinates .My pdf consist of lots of building ,i am asking if I provide one building with real coordinates manually Will be possible to change coordinates of all other building to real coordinates automatically .what should I do to change coordinates of pdf to real coordinates ,any ideas ?Thanks in advance .FME 2021

I have situation wherein I need to add fields to all the feature classes within a SDE. I cannot seem to figure out how to loop through the SDE, and operate on one feature class at a time, though. My first thought was to generate a list of all the feature classes in the SDE using two FeatureReaders, but then I was not sure how I would iterate through that list.  Any assistance would be greatly appreciated. Thanks!

So apparently, FME does look for fields that might be a good candidate for creating a point geometry in both Excel and CSV readers (see https://community.safe.com/s/question/0D54Q000080hfENSAY/excel-format-of-attribute). This means that if in an Excel or CSV file, there is a row with column names such as X and Y, FME will automatically try to create a point with the contents of these cells. In the top-rated answer of the above link, it is mentioned that for the CSV reader, this will only occur if the option "Scan for types" is activated. This option does seem to be missing for the Excel reader, though, or am I overlooking something? I have the problem that I am using a FeatureReader to dynamically read from an Excel file (the specific file is only known at translation time, not before) and FME unwantedly tries to create point geometries for the features. The sheet of the Excel file might contain X and Y columns, but these are usually empty and surely not any spatial data. Nev

This is not a real question, it's more an assesment. In FME 2022, it seams that every query run with SQL Executor/Creator is run as a prepared statement (see here for more information on PostgreSQL https://www.postgresql.org/docs/current/sql-prepare.html). The problem is that only certain query can be prepared, not every one...Some of my queries can not work anymore like every "CREATE" queries that can not be prepared into PostgreSQL. Is there a way to disable this behaviour ?  For me it's a critical problem because some times we need the queries to be run as we write them, not like the database want to redefine them.

We have one floating licence and it is now stuck on an old laptop and won't release it. Can I force it to release either from the device or from the licence server?

With a postgres writer it appears that if Bulk Insert is set to Yes, if you attempt to write a string value of NULL to a varchar column that has a Not Null constraint it is interpreted as a genuine null and results in a fatal errorError was 'ERROR:  null value in column "value" violates not-null constraintIf Bulk Insert is set to No, the value is written as a string as expected Is this a known issue? This is in FME(R) 2021.2.6.0 (20220727 - Build 21821) so may have already been addressed.

Hi, I'm running into an issue that I don't understand the solution to.Using the geometries attached here, I can not clip the geometries using a tolerance of 0.001 .It does not give an error, it just gets stuck.If I dissolve the clippers before clipping, it does work. So I'm guessing there's something 'wrong' with the geometries (there is a strange pointy shape in the polygon) and the chosen tolerance, but I don't know why it gets stuck. I'm guessing the pointy-bit is too small and falls under the tolerance? I'm using fme 2022.1.2. Workspace attached and data attached.

Hi, see the attached, I'm reading MVT Tileset and want to fan out the output file GDB dataset on zoom level and fanout the feature types too on fme_feature_type, I get an error saying the schema doesn't have the correct element, but it does! All help appreciated. The fmw is self contained, it downloads MVT tilesets (not too big).The error at write time is:ERROR |Esri Geodatabase Writer: Feature Type Definition 'bl' was requested, but not defined. Please visit https://www.safe.com/support

Hi,I have a process where I am using a DEM to apply values to vertices of polylines using vertexextractor, point on rasterextractor etc (see below). But I end up with gaps where the z value has been attributed as -32767. These have occurred where the vertices are just outside of the clipped DEM - is there anything i can do to interpolate?

Hi all,​I have a lengthy workbench running. I can see the temporary files being written to the relevant 'wb_run...' folder specified in the translation log. The workbench has just finished writing outputs of an AreaOnAreaOverlayer, and those outputs are now being used as the input to a Dissolver, which is in progress at the moment. I can see a 29GB file named 'FME_OBJC_DissolverInputAreas...'. Is this a temporary hold of the AreaOnAreaOverlayer output features? If so, is there any way to use this temporary file and access/export the features in it? In case it is relevant - I have feature caching turned off. Thanks!😀

I am looking for some suggestions on how I could create a workspace that would detect no intermediate junction between linear objects that share connectivity between them and are of a different asset group and/or asset type. an example would be a HV conductor connected to a LV conductor without a point feature in between.All suggestions welcome.thank you :)