FME Form

hello i am trying to write something in excel format but the result are like in the picture, how to write the data from the start of each rowplease suggest 

Getting the below error when trying to write the IFMEMultiSolid to Multipatch. I’ve tried to deaggregate the geometry but that didn’t work.The 'HAS_Z_VALUES' keyword is set to 'AUTO_DETECT'. With the exception of MultiPatch feature classes, the dimensionality of new feature classes will be based on the first feature written to the feature class. (Features with no geometry are considered 2D)A default z-value of '0' will be used for all 3D features where z-values are not providedEsri Geodatabase Writer: Not simplifying geometries being writtenTransactions are being used by the Esri Geodatabase WriterEsri Geodatabase Writer: The field 'OBJECTID' in table 'Dissolved123' will not be updated since it is not editableProcessing on a solid has failed. The solid may be too complex, not closed, or not orientable.Esri Geodatabase Writer: Failed to write geometry to MultiPatch feature class `Dissolved123' +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `Diss

Hi, I am trying to do check if data is correct in one of my tables compared to another one. To do that, I thought about merging/joining the two tables based on columns and conditions. The common column between the two tables is the City Code (postcode). Then I need to compare landmark values, which represent the location of objects in space. I managed to join them based on the City Code column but I don’t manage to do the landmark values comparison yet.  More context:My actual data is fields of grass along roads. Each section of road belongs to a city (City Code) and is separated into categories of landmarks. For example a road within city 1 is separated into groups of landmarks ranging from 1 to 1.5;  2 to 3; etc.; and the field X is situated at a specific landmark value 2.5.So the field should be in the landmark range 2 to 3 because its landmark value is higher than 2.  The tables: The first table has 3 columns and links city code and landmarks to a unique ID: City code: the city pos

Hi, I have a geojson including an attribute with datestamp values. An example value is 202410231836 (year, month, date, hours, minutes - yyyy mm dd hh mm). These are important as I’m running testFilters with it.  However I would also like to create a parallel attribute showing an easy to read UK date value from it. So, 202410231836 would convert to ‘31/10/2024 18:36’.I’ve been looking at DateTimeConverter transformer but couldn't work out what import format to use and what output format to pick - assuing that DateTimeConverter is the one to use.Any advice would be appreciated. Thanks,Stuart 

Hello FME community,When creating a DWG file I would like to write some attributes to it. It is important that the written attributes appear in the properties of the object.The following picture shows more precisely what I mean. I want Attribute 1 and Attribute 2 to be appended to the DWG file.Does anyone know how I can attach attributes to the DWG file.Thank you

Hello Forum, I have a workspace which reads in a tab file with a start_date attribute and end_date attribute. These are populated with datestamp values (e.g.: 202410281200). That reader flows to a TestFilter which determines if today is before the start date. If so, these records go to a new output writer for sites not yet started. If today is beyond the start date. These then go on to a second testFilter, which determines if the end date has been reached or not. If the end_date has been reached, then this goes to an output writer for historic sites If the end_date has not yet been reached, then this goes to a output writer for live sites. These test Filters are doing exactly what I want them to do. However it can be the case that sometimes there are no sites where the start_date has not yet been reached. In these cases I need the output to be an empty table. However, I’m finding that the flow is failing to overwrite any previously created tables where, for instance, at a time when it

Hi.  I’ve a FGDB how contains polygone and line feature,.I need to create a separate shapefile for all feature of the FGDB.After that, I’ve to create a zip with all the shapefile. Can i do that with FME ? Thank for help

Hello everybody, i want to know if someone know how i can to do to rename a value in an attribut ? which name for the transformer ? thank you !! Bonjour tout le monde, je voulais savoir si quelqu’un savait comment modifier une valeur dans un attribut ? quel transformer dois-je utiliser ? Merci par avance.

Hello , I would like to generate constant unique id for lots of points or lines that has not get  the id yet and keep the same constant unique for each time running FME (no change)i do not want any changing of id for each running Fme .lines or points should get constant unique id and after one month when I run Fme workspace and there are new lines or points .FME should provide the same constant unique id for old points or lines that provided them before and provide new constant unique id for new lines or points .The problem I am generating points that they are not exist before at GIS data and I am not able to save the points with id in Gis database but I want to keep the id for each point without changing in Fme thanks in advance fme 2021 

Let's assume we have a feature attribute called "two_digit_number". The attribute can have any integer value from 10 to 99. The condition "not an unlucky number" is met, if the value is not "13".  I was wondering if I could represent this condition in a single line of my SchemaMapper's lookup table? Something like two_digit_number != 13.  I could probably use a "TesterFilter" to filter out features with unlucky numbers before they enter the SchemaMapper - however, in my project I have dozens of attributes that need to be handled in a similar way. I would have to send all of them through a "TesterFilter". And this is what I would like to avoid. I am excited to learn if there is a simple solution I may have overlooked.

Hi, I want to find duplicate addresses in the data based on duplicate address numbers.The way that I found in ArcGIS Pro is using spatial join of the layer with itself using attribute matching “address number”. This way if a point has a duplicate with the same address number in the same location, is joining with the point with the same address number and if a join count is more than 1 display, there is a duplicate. I am looking for a way to do the same step in FME. I used SpatialFilter but did not get a result. I really appreciate any suggestion for doing this analysis.Also, in ArcGIS Pro, it is possible to join spatially "within a distance". Is this option available in FME?

Hello ,i have self intersection at specific line .but Geometry validator did not catch it .I have read at other article that it is better to use chopper vertex 2 and snapper segment to let geometry validator to detect self intersection issue ?I have tried it but it does not work .is there other suggestion that I have to try ?FME 2021thanks in advance .

When converting a Cloud Optimized TFF to a Geospatial PDF, the output resolution is very pixelated (see attached file). How can the output Geospatial PDF resolution be specified?GeoPDF Resolution Example

I need to select the lines that fall entirely within a specific polygon and update their data with the respective polygon name. I attempted to use a spatial filter, but it didn't work as expected. When a line intersects two polygons, the filter selects and attributes the line to only one of the polygons, which is causing issues. I also tried using the NeighborFinder without success. I've attached a screenshot to illustrate a line segment that should not be selected within this polygon.

I see an idea to add/support bulk mode in the PythonCaller has just been updated to "Released" - https://community.safe.com/s/bridea/a0r4Q00000HbriAQAR/support-bulk-mode-in-pythoncaller I'm wondering what the usage of the bulk mode is in the PythonCaller, by design the PythonCaller iterates over each feature individually, therefore going against the idea of bulk mode.    

Dear all,I need to add multiple REVIT/IFC files into an ArcGIS WebScene. I am trying to determine the most efficient way to achieve this.From my understanding, the process should involve the following steps:Read multiple REVIT/IFC files from a given folder. Transform these files into Multipatch and save them into a Geodatabase. Publish the layers.Do you think it is feasible to obtain such a result?Many thanks.  PS: I found this post which contains a similar request: 

I need to create a JSON attribute with a key that only has an empty object as its value as you can see at key1.{ "key1": {}, "key2": { ... } "key3": [ ... ]}Problem is that the JSONTemplater turns empty objects into null. An empty object is valid JSON and is very different from the value null so this behavior is completely incorrect.How can I set an empty object as a value inside a JSON attribute?I tried using the JSONUpdater but it works in the same way. If you set value type to JSON/XQuery it replaces the object with null. If you set the type to plain text, it only creates a string “{}” containing two curly braces.

Hello FME members,I have an IFC file with no coordinate information in the site feature.it is a 3dObject of a parcel that is supposed to represent the surface - but it is just a (3dObject) flat surface with an extrusion of 1]What I have done: I have at least 4 coordinates to transform, I tried to use:the 3daffinewarper, but the transformer showed me an error [because the transformation from 0,0,0 to x,x,444.1 is coplanar - and I only have 4 known points that went from z:1 to z:443] (I also tried 0,0,1 to x,x,444.1, but it didn't work) so I used the affinewraper to send the surface to the correct coordinate system)that worked!i need to know how to get the 3d object to the correct z value to display the surface (3d object) at the correct height.I hope someone can help me.Greetings Michael 

I have several Excel writers in a workspace and one throws the warning below. I checked the parameters and they are all the same. Does anyone know where this can be changed? Thanks!Excel Writer: Invalid value '<Unused>' supplied for parameter 'xlsx_field_names_formatting'.  Reverting to default value 'yes' 

Hi All,I am updating few values in ArcSDE Geodatabase (in flat table) using FME workbench but its giving an below errorerror : Error while retrieving an ArcObjects update cursor for the table/feature class 'gis.xxx'. The error number from ArcObjects is: '-2147220652'. The error message from ArcObjects is: {}Stack  : FME workbench 2021.1 , ArcSDE Geodatabase, Flat table ,MS Sql Server Workbench screenshot :  Error message :    Feature writer properties Till now tried below : Using SQL query its possible to update values in SQL management studio with sde use SDE user has privilege to insert/modify/delete  Workbench has proper permissions to run it Using ArcPro Standard licenses  If we truncate then its truncate the table  Since we are using flat table still use geometry remover to remove additional geometry  Flat table has valid primary key    Any help/inputs/suggestions would be great !!!thanks in advance !!

Hi!I have to extract data and write it into excel sheet. I got to the point where I have the information ready but I need to delete missing values and move the features so the table looks different. I add an example.This is what I get:DaysMonthsCity<Missing>March<Missing><Missing>March<Missing><Missing>MarchParisMonday MarchParisWednesday <Missing>ParisSaturday<Missing>Paris<Missing><Missing><Missing><Missing><Missing><Missing><Missing><Missing><Missing> And this is what I want to write into my writer. DaysMonthsCityMondayMarchParisWednesdayMarchParisSaturdayMarchParis MarchParisMaybe it is easy but I´m still learning... Any help here??Thanks in advance!!

Hello,I have a script which is written like this:import osparent = os.path.abspath('..')file= os.path.abspath('../file_08-06-2024.xls')return fileI would like to replace the date with an attribute defined in a attributeCreator transformer which could change and i write this :file=os.path.abspath('../file_$(date).xls')When i run, it doesn't work. Can you help me ?Thank you.

***UPDATE - PROBLEM RESOLVED***This is a strange one!For this example, I have 2 features. I put a counter to get 0 and 1 for the value. Then I’m updating my JSON with the _count value. The output from the JSONUpdater has SERIALNUM = 1 for both features. If I change the sort, it will set both to 0. I’m passing in the same feature in the Document and Update input ports. I’m not sure the distinction between the two input ports.  

Hi,A very random question. My son has recently started to like making mazes out of Lego for marbles. I was wondering if there was a way in FME I could perhaps randomly generate a maze?I know there are a bunch of generators on the internet, however they do not account for a cell size of 2x2, to accommodate a marble, or a wall thickness of 1. I see there is a generator on FME Hub, but it also doesn’t work because it calls a webpage that doesn’t exist anymore. So I thought perhaps I might have a go but I can’t work out a way to use any maze generation algorithms. I don’t know python, but I’m reasonably handy at desktopIf anything glaringly obvious comes to mind I’d love to hear itThanks

I have a workspace in FME Form 2021. It includes a writer for Automation. This writer creates the keys in the Automation I have created in FME Flow 2021. These keys are based on 4 Attributes I created and renamed in my workspace. When I change the attribute names, run the workspace, and upload it to FME Flow, they are reflected in the writer but are not written to the Automation I created that includes this workspace in FME Flow. The Automation still includes the old key names. ...but...after I run/upload the workspace as explained in the above paragraph, then delete the writer and re-add it into the workspace then run it/upload it again, this then it updates the keys in my Automation.  Has anyone else encountered a situation like this?