FME Form

Hi fellow FME enthousiasts,Another case i'm struggling with today.I have a list of parcels that need to be added into a Excel template. In most cases I can sort the parcels by parcelnumber and concatenate them grouped by the Section number and write them to the Excel.But the field in the template can fit a maximum of 5 parcel numbers. So if there are more then 5 parcels they need to be split in groups of 5. So say i have a file with 13 parcels, I would need to split them into 3 groups (2 of 5 parcels and 1 of 3 parcels). I can get the number of parcels with a StatisticsCalculator, but i struggle with the part where i have to split them into groups to write to the Excel. How would you do this? Cheers!

Hi, I use parallel (//) processing in other workspaces successfully but this is the first time with a Clipper. The tips offered in article: FME Parallel Processing: Tips and tricks for generating groups | Safe Software do not seem to apply, or at least I think they don’t. I am trying to clip an OBJ of  ~12720000 triangles with ~93K polygons of diiferent sizes. The OBJ has no attributes, just geometry. 1st try: link the same modcount (4 groups) to both Candidate and Clipper inputs of custom xformer containing only a Clipper.  The data passess through it without any clipping. The Clipper inside is set as “multiple clippers”; Clippers do not arrive first; Reject only parts, merge-clipper, and the rest is set with defaults.2nd try: cloning the OBJ as explained in article but it slow and eventually crashs as it runs out of memory. I sort of expected it but tried it anyway. I don’t see how I can use the tiling method here.  Am I missing anything else? or maybe there is  an update on setting

The steps I have so far: 2 layersSpatialRelator, which generates the list attributes with the intersects.Then I test the output to find out which features have more than 1 relation (indicating overlapping with more than 1 feature).Then I explode that list and delete the unimportant attributes with AttributeManager. I now have a table like this. First column containing a unique identifier for Layer 1, the second row containing the unique identifier for Layer 2.  A feature of Layer 1 can overlap with multiple features of Layer 2, and vica verca, hence the duplicates on both sides.Layer 1  Layer 2 ID1 123 ID1 345 ID2 987 ID3 456 ID3 123  Now the hard part. I can FeatureJoiner them together, and then dissolve, but then I miss a lot of features and don't dissolve enough overlaps. It doesnt create the perfect output.What I want to achieve: I want all features of Layer 2 to dissolve together, based on the overlaps with features from Layer 2.I added a drawing to visualise wha

Hello fellow FME enthousiasts,I have a case which i can't seem to find a solution for.We have a process that adds a score to incoming records based on certifications added as hyperlinks in a table.During several steps these certifications have to be manually checked by an employee. Finally when everything has been approved the records are written to a central database (this can only be done when all the records have been approved, so the whole dataset has to be kept together during the whole process). Right now i have the process setup to output all data to an Excel table (with a template to make it readable for the employee). Here the employee can select if a certification is approved or not. This Excel table is then put back into the next process untill all necessary checks have been done.Each time a proces is run i would like to check at the end if all records are approved or not. Depending on the outcome two things can happenIf ANY are not approved, ALL records needs to be output t

I have a batch workspace that spawns multiple child workspaces using four separate FMEServerJobsubmitters. I have two engines in FME FLow but the other engine is occupied with other processes so I'm able to use only one engine. As i understood, if i set Wait for jobs to complete to "Yes" and Submit Jobs "In Sequence", FME Flow should spawn a sub-engine that will run the child workflows and once they are ready it will continue the parent process. This is the behaviour that I would need because I only want to continue parent workflow when all the child processes are successful. However, with this setup the first child process enters queue and never starts. It also shows in the parent log file that the submit was successful, but it ends up into queue. I have separate queues for the two engines and both the parent process and the child process are tied to engine2 running in queue2 so it should interfere with the other engine and queue. However, it seems that the par

Hello, I am currently trying to read in a feature class from an ESRI SDE and keep hitting a wall with this error:  The table name 'DBO.Transportation/SidewalkAccessCenterline' could not be found in the Geodatabase as either a feature class or a table. This may be because the current user does not have permission to see 'DBO.Transportation/SidewalkAccessCenterline' I have tried the following:updating FME updating ArcGIS Pro changing Esri ArcGIS Compatibility from auto to arcgis pro changing what user ArcGIS Pro was using Made a new connection file  checked to see if the file was versioned (it is) checked to see if I had read/write access over the folder the connection file was made in (i did)Any suggestions are welcome! Thank you!

I have designed a dynamic workspace to have a bulk transformation on all shape files within a nested folder structure. I have added the original folder location in the reader with checking tick mark for subfolder. Then I have used batch deployment and checked the 'recreate folder structure'. However, the destination files were not written in the similar folder structure as in the original structure.  See how the subfolders within original Asset folder (image 1) were written outside the destination asset folder (second image). Can anyone tell me what was the likely source of this?

When reviewing an old workspace in FME Form 2023.2, I noticed that if I opened a Feature Reader or Feature Writer that previously had an SDE connection file path referenced in the connection parameters that the parameter was now blank. If no changes are made, the workspace runs to completion as normal. No errors are thrown and no transformers are marked as “incomplete” in the navigator pane. This tells me that those pathways are stored somewhere. This does not appear to be an issue with other data types like csv, xls, or file geodatabases. These file types used in a feature reader all have their connection file parameter populated when opened in 2023.2. This does not appear to be an issue if a Reader or Writer is used rather than Feature Reader or Feature Writer transformers. A Reader or Writer configured to work in a previous version of FME using an SDE connection file path is populated when opened in 2023.2.How I would expect to see the connection parameters when settings for the tra

Hi All,I need to run a join between an excel file to a feature class (GDB) with attachments by an unique ID. The GDB has been used to collect data within a Survey123 form.I did some testing but can’t retain the attachments in the final output,Any idea how to retain the attachments after running the join?

HelloI have a simple question, but I’ve found now answer.Is it possible to write a FBX file with transparency, transparent objects?Regards, Hartmut

Hi, I wrote some code to copy feature classes from one gdb to another.Everything runs fine through python, but it fails when I try adding it to a python caller - Specifically, it crashes ArcGIS Application. I have no idea what’s going wrong as I get no error message, only this screen:The odd part is that it manages to delete a layer and then copy the new one across before crashing:Here’s the code i’m trying to run. Apologies in advance for the mess, it’s not my strong point!import fmeimport fmeobjectsimport arcpyimport osimport fnmatchfrom arcpy import envclass FeatureProcessor(object): """Template Class Interface: When using this class, make sure its name is set as the value of the 'Class to Process Features' transformer parameter. """ def __init__(self): """Base constructor for class members.""" pass def has_support_for(self, support_type: int): """This method is called by FME to determine if the PythonCaller supports Bulk mode, which all

Hello ,i have used network topology calculator then aggregator (group by network id ) .i have found that there are some unwanted connecting lines that has same network id .I want to check the reason ?i am wondering if there is a method to find the connecting points that occur to provide each line the same network id as before ?so I  can check them quickly .i am looking for a quick method to find unwanted lines that has the same network id .thanks for helpFme 2021

I am building a workbench that uses spatial filters, I have several readers input to the spatial filters that have different source coordinate systems. Originally, I used the ESRI reprojector to convert everything to 3TM (EPSG: 3776) prior to the spatial filters. This included a file with a source coordinate system of WGS84 Spherical Mercator (EPSG: 3857). However, my end result is about 4 feet off of where it should be. I tried selecting a transformation (I used Pro to see which transformation they used when I used the project tool and selected that one) but the result was still the same. I performed the projection in Pro on the same file and it was successful so it was a bit confusing as to what I was missing in FME. I decided to instead project my other files to WGS84 Spherical Mercator and work within that coordinates system. It was successful. I am guessing I may be using the ESRI reprojector incorrectly, or missing an input. 

I’m reading a geotiff file with embedded scaling and offset,  snippet from gdalinfo:Band 1 Block=1024x1024 Type=Byte, ColorInterp=Red  NoData Value=255  Overviews: 6000x6000, 3000x3000, 1500x1500, 750x750  Offset: -1,   Scale:0.008Band 2 Block=1024x1024 Type=Byte, ColorInterp=Green  NoData Value=255  Overviews: 6000x6000, 3000x3000, 1500x1500, 750x750  Offset: -1,   Scale:0.008Band 3 Block=1024x1024 Type=Byte, ColorInterp=Blue  NoData Value=255  Overviews: 6000x6000, 3000x3000, 1500x1500, 750x750  Offset: -1,   Scale:0.008When working with the data in FME just the the 8-bit value is shown (0-255) when I was expecting values between -1 and 1.   In my particular use case the scaling is constant and I can just apply a correction, but I was wondering if there is a setting I’m missing to have FME apply the scaling/offset automatically.

I am comparing records from two sources. I want to sync the records from one source to the other source. I am using ChangeDetector to do this (Workbench 2023.1).  Output wise, what is the difference between these two workbench configurations? (one with the FeatureJoiner and one without the FeatureJoiner). When I look in the output database, as far as I can tell, I am getting my desired outcome without needing the FeatureJoiner but I want to make sure I am not overlooking something.Is it necessary to use FeatureJoiner on the records coming out of the “updated” port of the ChangeDetector before pushing the records to the ESRI Portal Feature Service writer? The examples I am coming across are using a FeatureJoiner after the ChangeDetector for the updated records e.g.:https://support.safe.com/s/article/how-do-i-write-updates-to-an-existing-arcgis-onlin 

Hi, I have a geopackage with 5 million polygons, some of which are duplicated, but with geometry that isn't exactly the same. In the image below the dark red’s polygones means there duplicates.I trying with transfomer matcher  with this set It works but not all polygones duplicates are deleted. I got something like this I know that at some point some polygons won't be able to be deleted because the geometry is too different.Maybe in can set the tolerance in 4 or more, but i thinkAny idea if it can be done?Thanks

I am trying to update approximately 10 attribute fields in a point layer in AGOL using FME.  When I run the script, it keeps failing and I’m not sure where the hang-up is based on the warning and error messages I am getting.  Below is what I keep getting once my script has failed, with the ones in red being the error messages (the last two bullet points):  Feature Caching is ON The workspace may run slower because features are being output and recorded on all output ports regardless of whether or not there is a connection. ArcGIS Online Feature Service Reader: Reading from from feature service 'https://services1.arcgis.com/9yy6msODkIBzkUXU/arcgis/rest/services/HII_2020_2022/FeatureServer' using filters defined in 'HII_2020_2022' ArcGIS Online Feature Service Writer: Feature Service 'HII_2020_2022' does not support geometry updates. If features contain geometry, the geometry will be ignored ArcGIS Online Feature Service Writer: Attribute 'OBJECTID' on feature type 'HII_2020_2022' is mar

Hi,I am hoping someone can convert a Geodatabase provided by the United Nations (Unitar & Unosat).It is published under creative commons 4.0.The map shows each building damaged in Gaza.I do not have any product that opens Geodatabsae files.I would be appreciative if someone could convert the file into KML so I can open the file in Google Earth.The zipped geodatabase file is 2.35Mb.The link is the location of the Geodatase file. https://data.humdata.org/dataset/unosat-gaza-strip-comprehensive-building-housing-unit-damage-assessment-march-2024#I have also attached two images.The first image shows the page with the GeodatabaseThe second image shows how the UN have used the file to present to the public.I have submitted a request to UNTAR however they have not responded.ThanksHarry Sullivan 

Hi,I’m trying to apply a schema from excel to 2D utility lines so that it applies the schema to the lines and creates 3D pipes of the same size, also adding the metadata.I have an idea of how to put this together, however am struggling to select the right information from the excel and make it dynamic.Example: If find ‘water’ in dwg, then apply a 200mm pipe to the center and add ‘water’, metadata1, metadata2 as attributes to the line. Thanks in advance!

Hello,​I need to print my workbench on size A0. It works fine for size A2 and smaller but for size A0 or A1 the workbench freezes or crashes. I tried with different workbenches , different Pc's and different PDF-creators but no success. I use FME 2019.1.Maybe someone has an idea to solve the problem?​

Hello FME Experts,I'm currently working with road network spatial data, which contains a multitude of line features representing roads. Each road feature intersects with others, and I need to determine the correct start and end names for each road segment (i.e., the names of the roads at the start and end nodes).I'm wondering if there's an efficient way to accomplish this using FME. Specifically, I'm looking for guidance on:How to identify the start and end nodes of each road segment. How to extract the names associated with these nodes.Any suggestions, workflows, or examples would be immensely helpful. Thank you for your insights!Best regards,Vishnu N V

Hi,I am creating some admin areas which feature multiple islands within each admin areas.I am using the Aggregator to group the areas, and that is looking fine in the Inspector.When I come to write these features to an esri ArcGIS Portal Feature Service, I receive the following error:<type 'fmeobjects.FMEAggregate'> cannot be converted to esriGeometryPolygonI am building Homogeneous Collections where possible, but even the admin areas that are made up of a single contiguous area have "fme_aggregate" as "the fme_geometry(string)" attribute in the inspector.

There was a discussion from a year ago that suggested that the Esri Portal Feature Service Reader was updated in FME 2023 build 23210 to resolve domain values when the domain is applied at the subtype level of the featureclass, as it is in the Esri Utility Network.Esri Utility network reader subtype layer | Community (safe.com)I am still having trouble getting a domain resolved that is at the subtype level. Maybe I’m doing something wrong?   FME2023.1 (build 23619)Using the Feature Reader transformer: Portal Feature Service of my UN data, layer is PipelineLineLooking at the attribute material:In the schema result from the reader I see attribute name: materialattribute name: material_resolved  But in the data result I only seematerial: Mand no material_resolved attribute that I can find. But I can see that other domains resolved, like manufacturecomponent

I am trying to bring in some files that are dgn/bentley related (cit and nm1) and I can’t figure out how to read these files or view them. I found in a search this site that says how to read a .cit file but I can’t find this or how to view these?https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/ingr/ingr.htmI do not see this INGR in my lists or anything when I put in reader format .cit 

It may be beneficial to have some sort of limitation stopping brand new members from including external weblinks in their first post/ within the first day that the account is created. If the advertisement/bots become more of an issue, then something like that may help mitigate the problem without being overly limiting on legitimate users.