Transformers

I have a network of (electricity) lines (306 in total) and with Neigbourhoudfinder i determined what line is collest for all 800 proporties in a small village. It gave me and x and y coordinate on the line. Now I want to determine a total value per line (values of all properties that have an x and y coordinate) on the line. How can i achieve this?

Is there anyway to configure the StatisticsCalculator on a dynamic set of attributes?I would like to generate a histogram of attribute values, where the attribute name is determined at runtime. Bonus if I can process multiple attributes at once.

Hello FME'rs,  What I'd like to do is intersect two line feature classes to produce an intersection POINT output feature class.    This is a relatively simple task to perform in the Arc geoprocessor (overlay->intersect).  However, my first few attempts with FME (using lineonline overlay) doesn't quite yield the results I want as it appears the give me the intersection points as well as ALL the start/end points of the intersecting line segments.  Can someone kindly point me in the right direction?  Thank you :) JP

For a school assignment I am trying to make a functional FME model. As topic I chose the electrical grid. I chose a village were there are 8 transformation stations and about 300 different line segments. For alle 300 lines I determent which transformation station is closest.  I know want to number the line segments that "belong" to the same line. e.g. a1 to a10. Is that possible?

How do I set the coordinate system of a dynamically created empty feature class (polygon) in a file geodatabase? I store dynamic attribute names and data types in a spreadsheet, import those into an AttributeCreator > then create the empty feature class using a FeatureWriter, but the output feature class says coordinate system is 'Unknown' when I open it in Data Inspector. 

hi everybody... I'm doing 3d visibility analysis. I have points data and dem data as in the screen image. I need to do an analysis for each point and I need to save all visible areas as a single shp...can you help me please

I'm interested in using FME to connect to a number of remote hosts to run a few command line commands, and returning the results back to the workflow for further processing. The remote host devices are network elements running an abbreviated version of Linux. Can PythonCaller be used for this purpose? The SSH connection must be completed through an intermediary "jump box". Any ideas will be appreciated.

I have hunted through docs but am struggling with dates. I can't do date comparisons in the InlineQuerier (see q linked below) so need to change dates to integers to compare using SQL, but can't figure out how to do that. I also want to be able to convert dates to months for comparison e.g. testing 15 September 2022 vs 30 September 2022 should return TRUE. Still new on the FME journey and any help much appreciated - or a pointer to docs. Thanks, Philip Q. on dates in InlineQuerier using SQLLitehttps://community.safe.com/s/question/0D54Q000080hMJ7SAM/testing-for-between-dates-supplied-by-external-file

Hi, at the FME UC last year there was discussion about a the potential to create a Custom Transformer and in the process consume a swagger/OpenAPI definition. I've been looking at the FME Transformer Designer in the FME 2023 beta and so far I can't see anything which would indicate that this is doable.  Am I missing something? anyone else know anything more about this?

I am going through a list of CAD files, how to keep running the workspace even if it hits an error?

Dear Sir/ Madam, I have two indoor map data. One is the indoor network for the entire floor. Another one is the POI (My interested points A & B). I would like to use ShortestPathFinder to see if the network is routable.  However, I am not sure why I am not able to use the "ShortestPathFinder".  My ultimate goal is to check all my POI points are routable. Could someone please give me a hand? Since I cannot upload the zip file in this forum. I have upload my data on Google drive. https://drive.google.com/file/d/1nYZaHHyXM6DhMzfH_abuBgPPtc55Jpkk/view?usp=sharing Thank you and I am really appreciate your help.  

Hello,is it possible to write an Excel file to a SharePoint site? I don't believe I wish to create a SharePoint list or a lookup but simply overwrite an existing file in a folder sat in SharePoint.I can read a file from SharePoint in just fine using a Reader and just need the equivalent to 'write' I have tried the SharePointOnlineConnector but it's not outputting a file like I would expect.Thanks.

I was surprised using FME 2021 in BATCH mode to find, that DataInspectors (which were active by mistake) wrote all their data to FME_TEMP, and to make it worse the data was NOT removed afterwards. This way my FME_TEMP got filled up with 250 GB of trash and broke my workflow due to lack of disc space. Is this supposed to be normal behaviour lately, or is it a BUG ?Remark: I use Windows 10

Wondering how the schemaMapper can replace the field name for 165 Census fields within the Attribute Manager environment? Seems the examples require remapping the entire list? Is this kind of like a tabular Join in GIS?

I'm trying to load a vector tiles from the URL below but keep getting workspace generation errors. Can anyone tell me if this is possible please? I'd like to load at z=14 for the area of England and then merge the tiles into a single file to save locally.https:\\t1.mapstack.org\tilesets\trees-lidar-2022-ds\tiles\{z}\{x}\{y}.pbfMany thanksRob

For a studie assignment I was free to choose a topic and I chose this. At the moment I have (shp) files with:Property data (e.g. how much solar panels per property with how much WP)Electrical Grid (for the area of interest I have all grid lines - like a road network. Not included are the lines to the properties themselves, but the lines that run under the sidewalk in a neighbourhoud).Transformation Stations (on the gridlines there are a number of transformation stations that are connected). For each property I want to determine a point on the grid lines where the would be connected. And If I have that point I want to determine which transformation station is closest. I thought about LRS and Network Service Area, but after a few night looking for clues on the Internet and trying I have been able to figure out how to start.  Is there someone who can give me tips on how to start en proceed? I have only had a basic leasson

Hello. I have a question about one solution. I have duplicate points with the same name, but with at least different geometry. I need to filter these duplicate points relative to this one coordinate. Passed will be the point with the same name that is closer to this coordinate. I am attaching the fmwt. Thank you very much.

Is there any way to extract only the exterior wall boundary along with its door, window, and other related elements? Please share some ideas I really appreciate your kind support.

Hi there! I have a point cloud representing a dense forest. I am trying to get the 3D convex hull of the point cloud (as a mesh). I have already tried PointCloudToPointCoercer (individual points) into HullAccumulator but the results are unexpected and do not contain the whole point cloud:  Using the Minimum Bounding Volume tool in ArcGIS Pro does the trick, but since the rest of my workflow is in FME, I would like to avoid this option. Is there an FME alternative to this tool? Here is the result produced by Minimum Bounding Volume in ArcGIS Pro:  Hope someone with knowledge of 3D models in FME can help. Thank you!

Hi guys,i have different excel files which i have to split in separate excel files (fanout with row C), name them as Row C input (PA9-BK.....) and keep the formatting...first two columns (the grey ones should stay in all files) and the rest (green colours and so on) should also keep in the new files. how is the plan for that? i have searched some articles but not found the right one.....sry cheers, thx and greetz FRanco

I have an issue trying to get a DGN file into Revit for placing rebar and steel detailing. I've tried the following:Import an IFC from designer - model breaks and has strange behavior.Convert DGN to a DWG file via FME and import to Revit - broken model no resembling original. Has anyone developed a workflow or know a good way to achieve a stable DGN to Revit workflow maintaining most of the original integrity without bugs etc.? Thank you!

Hi, guys, i'm new here. When i make a hatch in Autodesk CAD, and then translate it into GDB via FME, then i use FME exporting to .dwg file, when i zoom in to a very large scale, the new geometry's boundary line doesn't fit the original one, the area of the hatch also changed a little, but the line or arc don't change when i do the same. Can anybody tell me how to make it right? THANKS!!

I am using InlineQuerier to lookup a value and add it as an attribute to my base table (Cities). For audit purposes I want to lookup multiple values and add multiple attributes before performing calculations. Currently I am using a separate InlineQuerier for each additional attribute. Can it be done in one? or using other tools? As an example say the base table is Cities, and I want to look up several different price indexes in a CityIndex table based on specific dates, and add these to the base table. See pictures. To add one attribute I can use an InlineQuerier function:Select Cities.*, CityIndex.IndexValue as Index_at_20210630from Cities Join CityIndex on CityIndex.City = Cities.Name where IndexDate = "20210630" But how can I add multiple attributes - see desired state screenshot attached? Many thanksPhilip (6 month FME user)    

Hi everyone,I am trying to split a large table into multiple files and was playing around with the dataset fanout feature. My table has multiple header rows that contain explanations of each attribute that I wish to keep in each file created by the fanout but I cant seem to make it work.  An alternative that I can also see working is to add a static Sheet to each fanout-file which then contains these explanations. I wasnt able to make that work either though. Any help would be much appreciated.

Hi, we have some PoylgonZ geometries with multipe polygons per building. For each polygon we have different heights. Now we are creating building models in citygml with citygml_lod_name = lod1Solid. This is working already with this workflow:But now we have for each solid one building element. Then I thought on the transformer aggregate to aggregate the solids for each building (by gmlid).But then I have MultiSolids which I can´t write to CityGML (lod1Solid). How can I create only one Solid for each building?Or do I have to use lod1MultiSurface?