Transformers

I have a input data file with a unique ID (BORRHAL_NR) with 2 variables (Date/Granvattenniva). I am using a python caller in a CT to generate a chart with matplotlib. I would like to produce as many charts as unique IDs, and I am using the group by in the custom transformer but even though it produces in this case 4 charts I see that is using all data from all unique IDs in those charts (except for the first one that is actually correct).Any ideas?I am using FME 2022.2.4. (Build 22792)

I used points geometry to create my .shp file. I got the visual preview from the read file. But after extruding, I am not getting anything and it's not showing any error. I want to create 3d cesium tiles.

Hi there, I have a whole lot of OBJ's of course they don't have any coordinate system, but they are tiled, so the first is 0,0 the second is 100,0 etc. I want to move these obj's around the world, I thought to just use an offsetter, but it scales the OBJ down.In ArcGIS PRO I can just move this over the map, and I hoped that the offsetter did something similar.I guess this has something to do with the world not being flat, but is there an easy fix for this, or even a hard fix. I really don't care which coordinate system, I can always reproject it. Thanks :-)

I encountered a challenge with writing to Excel using a template in FME. Despite setting it up correctly, FME wasn't reading the Excel template sheet. This issue persisted in FME 2020 but seemed to be temporary solved in the 2022 and 2023 versions.Progress Made:Identified a Excel plugin we use at work in Excel as a potential cause.Our IT support thinks the windows update for Excell 2023 is the probably reasonExplored potential reasons like multiple Python versions, recent Windows updates, and potential conflicts in the .xlsx files. However I dont want to uninstall my python versions due to other development projects. Cant uninstall windows updates since its restricted due to company policyReinstalled FME to overwrite any potentially corrupted files without success.Various troubleshooting attempts: rebooting, re-saving the FME workspace, re-saving the .xlsx save to 2007 xls template, etc.Upon uninstalling the excel plugin, FME 2022 and 2023 began working normally, but the issue pers

Hello, I use the Affiner Transformer to transform from a local coordinate system to the RD83 national system. Now I want to reverse the transformation, but I don't know how to adjust the 6 parameters. A/E = 1.00002B = -0.00002C = 5300000D = 0.00002F = 5600000 Can someone help me please? Thank you.

Hi, I'm having trouble appending one feature from a geodatabase, with another feature from a different geodatabase. To put it simply I want to turn 2 features into 1 feature. I'm using the terminology ("append") from this article, so I hope I've phrased this question correctly Combining Multiple Streams of Data (Append vs. Merge or Join) (safe.com). The schema is the same, I've attached a .gdb with the example data within it. Note: this is part of a much larger question, of how to append two separate .gdbs together (both with the same schema), but I figured I'd start on this mirco level and expand what I can learn from this forum to solve the bigger task at hand. I've attached a pic of the my attempt (this mess may or may not help) Thanks for your assistance​

I have an IFC file containing information about sewage pipes. In theory, it should contain two types of object classes (with geometry), namely IfcDistributionChamberElement (Manhole) and IfcPipeSegment (pipe). These classes use their subclasses as connectors, namely IfcDistributionPort (at each object node). Finally, these IfcDistributionPorts should be connected to each other using a relationship class called IfcRelConnectsPorts. In IfcDistributionPort have attribute named FlowDirection with value (source or sink) like in or out. The attached image shows a depiction of the connection.My question is how to create a shapefile containing line features to represent the flow direction so that when I upload the shapefile into QGIS, I can use arrow symbols on the lines.

When I configure the parameters in FeatureReader to resolve domains and subtypes, it seems to have done it because when I connect it to an attribute manager I can see resolved fields. However, when I finish my process and connect them to a FeatureWriter the User Attributes tab doesn't show that it's going to assign domains to the fields that have been resolved.  I'm using FME Form 2023.1.0. I've had success dealing with domains using these two transformers before I upgraded to 2023.1. Also not sure if it's relevant, but I'm working with an ArcSDE GeoDB. 

Hi everyone!My current workspace here is designed to convert Esri GDB feature classes into CAD DWG files. As of right now it works but there's a few issues I couldn't solve: The workspace is meant to work as a template without having the user to have to manually change what file they'll be reading each time. Currently it's hard set to a specific point file.There should only ever be 1 single GDB file being processed at a time, but the GDB file is expected to have multiple feature classesWithin each GDB I'm also expecting that I have to deal with incompatible feature classes which simply need to be skipped.Valid feature classes will all have the following attribute fields:FillColorFieldStrokeColorFieldLayerTypeField So I need this template to only process feature layers in a GDB where it contains those 3 field and those fields are not null or empty.  Each feature layer needs to be rendered into their own respective layers.E.g. If a GDB file with polygon and point laye

We are using FME 20222.2 and have created a worskspace to translate an input GML file into a proprietary XML format using a XSLTProccessor. It works as expected.We wanted to add a similar translation to transform an excel file into the same proprietary XML format. However, that requires XSLT 2.0 and it seems the XSLTProcessor only supports XSLT 1.How can we construct an XML based on an XSD and complete the attributes from an Excel file ?Is there some demo/example somewhere ? I didn't find one.

I hope I can explain this in a way that makes sense.I'm working on a fibre network where the main cable(s) leave the 'network hub' and connect to a building at the end of each respective route (see below, network hub = yellow, building = red). The goal is to number every node (ascending) from the end of a branch, working backwards towards the network hub (fibre allocation). What I'm hoping will work is creating a virtual merged line (for every building node) that contains the merged cables along the route back to the Network hub. Once this is achieved, I'm pretty sure I can handle the numbering of the nodes along the way, but even after hours of research I haven't been able to trace the route back from any given node, and merge all cables along the way. Has anyone worked on something similar in the past? Any help at all would be greatly appreciated. Blue below would be an example of one virtual merged line. Thank you in advance.

I have a list of addresses; each address has a lat/long point that closely represents the center point of the parcel of land associated with that address.I have a single line street network (SLSN).With each address point, I would like to create a line (LineBuilder I suspect) from the address point to the closest point/spot on a line segment of the SLSN (which may not be a vertex defined on the line).I say closest to a point within the line (defined or not defined) because that would represent the shortest path from the address point to the SLSN. Once I have these lines built, I will remove the SLSN geometry and add in the parcel geometry and determine the intersecting point of the "newly" created lines (with the corresponding address attributes associated with the line) and the parcel geometry.This intersecting point would be the best approximation of the mid-point of the parcel line segment (for the address) and the corresponding SLSN.Knowing this intersecting point can be u

When the FTPCaller Transformer uploads a file, is there a way to set a parameter where when it uploads the file it actually moves the file out of the source folder and not copy the file?

Hi, I am attempting to load CAD DWG into a File Geo database that has pre defined schema and domains. I get about 117 errors when I attempt this and would like some direction on how to resolve. my writer has an XML workspace Document imported. Am I to use the Attribute value mapper to 'code' all domain or sub type values? Thanks!!

Hi, I have some data placed in around 0,0 in EPSG:3857 -- WGS84 Web Mercator (Auxiliary Sphere) I would like to move that to Vietnam, which means an offset on: By doing this process, the data scales down in size, around 4 to 5 meters.I would expect this to be due the long travel distance, but I really don't understand why, which also doesn't matter for me, but I would like to know if anyone knows how to fix this? Maybe if the data wasn't in 0,0 but closer to the actual place, it wouldn't change the size, so maybe there are some tricks to do this. I created another question which is the same, but I think people skip it, since I'm talking about an OBJ to a new location, so I tested on a File geodatabase, and it's the exact same thing, so it's not an OBJ issue. I actually think it could be easier to trick the OBJ to think it is already in Vietnam, since it don't have any coordinate system, but I have no idea. Thanks.

I have a sorted list and want to output as a PNG, which transformer should I use? I couldn't go direct from a sorter to a PNG Writer?

I am trying to migrate Shapefile to Small world , in shapefile it is WGS-84 coordinate and in SmallWorld it has to be UTM-43N, I got "Smallworld Translator Error: coordinate3d(6.461e+007,1.066e+008,700.0) Incompatible sizes 3 2" how to clear this

I've used MapInfo for over 20 years and have used FME only a few times. I've been struggling to get the shortestpath finder to run on a large data set. I've read through many of the Q&A here and the documentation and have done the following: Data sources: TIGER road network To/From line segments. Data prep:1) I ran the TIGER file through the topologybuilder as was recommended. 2) I used the coordinateextractor to pull the start and end node from each road segment (start = coordinate index 0 and end = coordinate index -1)3) I used the neighborfinder to run my TO points file (base) to the nearest start/end node (candidate) and used the candidate x/y coordinates for my new TO location. I then did the same thing with my FROM points file.4) I created a polyline using the new To/From nodes (I did this in MapInfo as I couldn't figure out how to do it within FME) Up till now, everything worked perfectly. I received no errors and the To/From polyline starts and ends along th

Hi,I've been struggling to understand how to generate a pdf report without success.I need to write sections with charts, logos and text in them similar to this based on 50 to 100 attributes:I find it really tedious and complex to generate each section and I can't find any clarifying article or help. If I could use a PDF template it would be much easier but I can't find whether it's even possible. Bearing in mind the amount of attributes to process and show this will take forever.I've been playing with some transformers like PDFPageFormatter, VertexCreator+TextAdder+PDFStyler and with ChartGenerator. I've managed to add some text but charts are shown with a black square.Any advice on how to deal with all this?Thank you.   

Hey Team! I'm scratching my head over a problem that I'm sure one of the gurus on here can help with.  I have some very large spatial files that I need to store in a Snowflake environment. Snowflake has a few big issues when it comes to spatial data. It has very strict acceptance criteria on anything submitted as geometry so we have decided to store all of the spatial information as a binary field to pull out later (using GeometryExtractor) . However when writing this binary attribute to snowflake there is a size limit of 16MB... and when some of your features have over a million vertices this is not really going to work. We are looking into storing the FME binary over a number of attributes (_geom1, _geom2, ect.) to stick back together when needed, but cant get any string based functions to work due to it now being in binary format. I have tried substring extractors and attribute compressors with not much luck. Any Idea?

Hello everyone, I can't seem to find anything about this so decided to post a question here. We've been having issues with some of our automations ever since we upgraded from FME 2020 to FME 2022. These workflows use SchemaMapper to configure and export shapefiles based on a clipped location, and what we've been seeing is that the SchemaMapper will fail (the logs say something like "A required column was not found, row fme_feature_type will be skipped") and a bunch of the shapefiles that should have been clipped and saved in the output folders are missing. I noticed that, even though the Schema Mapper is able to read the Excel spreadsheet we're using (ie. everything shows up properly in the "Parameters" section), once you hit the 'Next' button the Preview appears empty. That is, all the tables show up in the pull-down menu but the view pane itself appears empty (see screenshot 1). And this is what shows up in the Create Attribute Map window (

HI. When parsing Clinic_Electrical.ifc using the attached ifc2obj.fmw, it fails because the material file is not created.I am inquiring as the cause is unknown. please answer about my question. Regards,Bongsup Kim​

hi, i am getting errors, when trying to implement an old workspace, witch was created in datainteroperability extension in arcmap 10.8. Now upgrading to a higher version of python and ArcGISPro i have difficulties with dwg writter. As soon as i add layers from .shp, to dwg writzter i get an error. .shp has correct coordinate system. Also an old model on older version works. Does someone have an idea what could it be? There is a log of an error: FME Configuration: Destination coordinate system set to input coordinate system `_FME_0'Dynamically creating layer `visina_topo_znak'Dynamically creating layer `id_visine'ACAD writer: Splitting bulk features into individual featuresFME Configuration: Using ESRI Reprojection EngineReprojector: Implicit reprojection prohibited from `_FME_1' (GCS: `GCS_Slovenia_1996') to `_FME_0' (GCS: `GCS_unnamed') using the Esri reprojection engine; specify a geotransformation using @Reproject or the EsriReprojector transformerEsri Re

For example the value 1.7 is read as 1.7000000000000002. I guess the json utility is using float data type that cannot store just a 1.7. It stores the closest possible value = 1.7000000000000002. I need to round the value to get rid of the extra digits. But I don't know the string representation of the value in the JSON file . So I don't know the scale of the value. The only possibility I have is to set a fixed number in the AttributeRounders decimal places.This is highly irritating!It would be better if the JSON reader tool would also return the scale of the float so I can round the value properly. Or it would be nice if I could set the tools to return the string of the float value and I do the conversion into a number my self.Do you know a workaround for this problem? 

how can i extract the attributes [Equipment-ID, Cleint-ID, Height and Date] from this xml? Any help will be highly appreciated. Kind regards,Keller.