FME Form

I was installing a Python module and pipeline (spaCy and en_core_web_sm.whl) into FME2023.2.4.  spaCy installed fine, but pip would not install the pipeline and I got this message: Since then, my FME 2023.2.4 will not work, at all.  No translations will work.  I made a blank Workspace with just a Creator and still immediately got:  “Error running translation”.What’s going on?  Did I break it?  Do I need to reinstall? My FME2023.2 works fine with the same Workspace.Any help is appreciated.

Hello,I’m trying to read specific feature classes from an SDE database using a user parameter within a feature reader.I’ve not had a problem with this previously so not sure if it’s a bug (I’m using FME 2023.1.2.0 (20231110 - Build 23641 - WIN64) The issue I’m having is:When selecting feature classes manually in the ‘Feature types to read’ section of the Feature Reader window I can select as many as I want and they’ll all read fine.When using the user parameter (please see settings in screenshot below):Selecting one dataset reads fineSelecting 2 or more feature classes I get the error “Error creating feature dataset 'feature class a feature class b'. The table name or field names may be too long or invalid for the server” Thanks for you time 

FME(R) 2023.1.1.0 (20230928 - Build 23631 - WIN64) FME FormHello,I have a set of QAQC workspaces that I’m trying to run in sequence with workspace runners. I have a parent workspace that, using scripted parameters, generates a bunch of output file names where I’ll write the results of the various workspaces, and runs workspace 1, then workspace 2 then workspace 3. I only want to run workspace 3 if my tests ‘Pass’ in workspace 2. So I write out a CSV file called _qaqc_status.csv in workspace 2 with ‘Pass’ or ‘Fail’ as the only attribute; the file location is in with the data and is variable.The problem comes when trying to read the parameterized file name ($(QAQC_STATUS_CSV)) with a FeatureReader; I get  the following error message   Worker 27572 > CSV reader: Failed to open file '' for reading. Etc, etc.and my CSV doesn’t show up on the output ports. If I hard code the FeatureReader dataset to an existing csv it works fine.Any help is appreciated, or even a workaround suggestion. Th

I am trying to join a SharePoint table with no geometry to a set of polygons (about 2000 rows). The table has unique project titles for for each polygon that I want to use as a join field; but the polygons themselves are stored as fgdb files deeper within the SharePoint file structure and they are a non-standardized legacy dataset that I am trying to aggregate (hence why I am transferring them all over to SharePoint as the first step).  When writing the fgdb’s I am also exposing the file path as the fme dataset field, so the unique project id’s in the table are a part of that file path. I am trying to use the string replacer to replace all the characters leading up to, and after, the project title with nothing so that only the project title is exposed. Sadly I can’t just count the characters as there are different folders within the file path with different names and character lengths so now I am trying to come up with a more complicated regex expression that will trim the start and th

Hello allI’m trying to achieve the above, so far I’m struggling on how to find out the KML reader ‘placemark name’ property, to write it as a DWG layer name.Could anyone point me out on how to do that? Thanks

 Hi, How can I shorten a line by 10 cm on both sides?

Hi.I’m using the snipper transformer to extract portions of a line at specific values from the attribute table.I set these parameters for the transformer. I set these parameters for the transformer.The problem that I noticed is that the program considers the first vertex of the line as 0 and the last one as the maximum, and the snipper will split between these two values.Is there a method to define the start value using another value, not 0? I would like to start from 4.21 km.Thanks.

Unable to connect to ArcGIS Online services through FME Form. This issue began at approximately 4pm AEST on 5th June 24. No connection issues were apparent earlier in the day. Can anyone suggest a solution to this? I’m unable to add a new connection or use an existing.Wondering if this is an FME or ESRI issue?Updating access token for 'BCT Enterprise'JSON Error: Access to this application has been blocked. Please contact your administrator to allow access to this app.Unable to update access token for 'BCT Enterprise'Python Exception <FMEWSException>: Type: 4, Number: 1, Message: Failed to get authorization query string.An error has occurred. Check the logfile above for detailsMany thanksFME version 2023.2.2.0

Hello ,i would like to create new points and new lines in FME and write the output in Esri arcsde (I have license for that )I have to write the new data in Feature class and and table class and establish a foreign key  relationship between the data between the two classes .      1. is there other classes should I write the new    data into it ? what should be i edit in workbench and the next steps to show the data in arcmap without any problem ? Arcmap generates obj_id when we add the new point ,will be possible to write obj_id that not used before in arcmap ? does anyone did a simple workspace ,could upload it to understand the idea ? thanks in AdaVance Fme 2021

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: