Ask questions, get answers and engage with your peers
Engage in discussions, seek advice, and find answers to your FME queries.
Discover more about the FME Community and how it can benefit you.
Submit ideas, share feedback, and influence the future of FME.
Get the latest news on FME's evolving features and capabilities.
Find out about upcoming events or webinars and secure your spot.
Delve into insightful articles about the possibilities and advancements in FME.
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!
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
There is a custom transformer named RandomPointGenerator which can generate random points in polygons. However, it can only use the same single integer value for all polygons. If the possibility would exist to create N number of random points, where N is an attribute value different for each polygon, this transformer would be much improved.
Hi, when opening fbx in FME, I see a property with a description of the material in the geometry parts (pay attention to the line highlighted with a marker) FME has a python interpreter, with its own classes and functions.I have already pulled out the coordinates of the points, in the code belowimport fmeimport fmeobjectsFeatureProcessor class (object):def __init__(self):passesentering def (self, feature):all_geom = function.getGeometry()first_part = all_geom.getPartAt(0)if type(first_part) == fmeobjects.FMEMesh:meshs = first_part.getAsMultiSurface()vertices_list = first_part.getVertices()textur_coord_list = first_part.getTextureCoordinates()textur_length = len(textur_coord_list)if textur_length > 0:for trian_mesh in first_part:ver_index = trian_mesh.getVertexIndices()textur_index = trian_mesh.getVertexNormalIndices()newFeature = fmeobjects.FMEFeature()pnt1 = vertices_list[ver_index[0]]pnt1_t = textur_coord_list [textur_index [0]]newFeature.setAttribute('X1',pnt1[0])newFeature.setAt
We're using FME Flow 2023.1.2.We have got a Windows Share registered as a custom resource at FME Flow, which is locally accessible as a UNC path. I'm looking for a way to reference the custom resource in such a way that it locally uses the UNC path and at FME Flow automatically uses the resource. I believe I can use Deployment Parameters for that.When I create a Deployment Parameter and use it as part of the path in a FeatureReader, it doesn't recognize the file I'm trying to reach, though I did fill in the local value of the Deployment Parameter.Deployment Parameter Value: $(FMEShare) Deployment Parameter Local Value: \\computername\shared_folder\ Reader Path: $(FMEShare)Subfolder\file.xlsxI tried to create an attribute _pathExcel that is set to the path I tried to fill in in the FeatureReader. Locally that worked, but at FME Flow I got this error message:Too many recursive macro substitutions -- line currently is: `$(FMEShare)'How can I tailor this method to get it to work? Thanks!
We are trying to use GoogleDriveConnector to update a folder within a shared folder on Google Drive. Unfortunately, when uploading the folder to the shared folder, it creates another folder with the same name as the one we’re need to update. We’d preferably like to overwrite this folder, or delete the Google folder before uploading, or something.There is a delete in GoogleDriveConnector but you have to have the exact Google id for that folder, which will change each time the FME is run. So we can’t automate weekly since we won’t know what the id will be each time.If neither of those options are possible (overwrite or delete), is it possible to upload to Google with a new name for the folder (like with a timestamp) so that we all know which is the most updated? (We can manually clean it out after that if need be.) This is less preferable, but right now I’m looking for any solution that may help our needs.Thanks!
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’m having trouble writing dynamically to a SDE feature dataset using the ‘truncate’ option in FME 2023.1. The features are written, but there is no ‘truncating’ taking place before the writing and instead the data doubles up... It works as expected in FME 2021.2.6 however, maybe due to the different way in which the feature dataset is specified in this version under ‘Table Creation Parameters’. How do I make it truncate also in 2023.1 version? Current set up in writer for FME 2023.1:
I’ve been using the CESIUM 3D Tiles transformer, and my experience has been somewhat tricky because of (I hope) the version that FME writes (1.0). I wonder if future versions of FME will support the 1.1 version to help resolve some issues I’ve encountered, such as the structure of the .json output or to be able to select the type of geometry compression, like Draco, Meshopt, or Quantization.
Hello, I have the following JSON file (sample) where by te attributes names are under “Channels” while the data values are under records. This JSON come to me as a API call and have no way of modifying the source. Using FME 2019 { "deviceID": 12345, "channels": [ "RecordTime", "Status", "Current Total Average Main", "Current Total Average Load1", "Voltage Total Average Total", "PhaseAngle Total Average Main", "PhaseAngle Total Average Load1", "Voltage Total Instantaneous Total", "Current Total Instantaneous Main", "Current Total Instantaneous Load1", "PhaseAngle Total Instantaneous Main", "PhaseAngle Total Instantaneous Load1", "ModemSignalStrength Total Average Total" ], "records": [ { "recordingTime": "2002-03-03T00:00:00", "status": "None", "values": [ 2.781, 0, 237.95, 37.4, 0, 238.27, 2.804, 0, 37.66, 0, 14.82 ] }, { "recordingTi
I have a DWG file with unknown CS but I know the CS it just needs to be assigned to the DWG. When I set the CS when I read the DWG then it appears in the correct location on the Earth but once I try to write it, it doesnt write the CS info and it appears again in the false location on Earth! I also tried “CoordinateSystemSetter” but with no success. On FME it appears good while transforming but not in the resulting DWG. Any Idea?
I’m looking to determine the number of line segments (green) to the end of a network branch (road network) from a given point in the network (red dot).Ultimately, I want to do this to be able to determine if a network branch is a dead-end up to a certain threshold of number of road segments (i.e. 30 segments, but would not consider 5000 to be a dead-end...threshold to be determined)I feel like using the StreamOrderCalculator to determine the Strahler Order is almost what I want except that loops may be present (as shown in teal) which removes that option.I’ve tried various things with the Stream and Network transformers, but can’t seem to figure it out.I’ve also tried with a PythonCaller, but I really struggle to translate a Python solution on dummy values to one that actually uses features and their geometry. I feel like I spend hours fiddling with syntax.Any ideas would be greatly appreciated. Thanks.
Enter a reward code and click submit to redeem the code for community reputation and badges.
Click the button to retrieve your own personal webinar transcript.
Click the button to find out which badges you have, and which you are yet to earn.
Earn bonus reputation and a lovely badge for answering these specific questions.
In-depth courses for all FME skill levels.
Explore our extensive collection of how-to guides and tutorials.
Log an issue with us. Our support team is ready to help.