Using transformers to modify data.
Recently active
I have a single band numeric raster on which I wish to cap the max values. I read in as tiff and then run through the RasterExpressionEvaluator with a simple if statement as follows:The output I send to the data inspector - but this is where it gets confusing as all the cells which have values greater than or equal to 20 are now set to NoData (0) and are NOT set to 20.0:In effect the @if statement seems to be ignoring the 'else' option. What am I doing wrong?
Hi, How I can test if unique values have different values in another field. Example: Field1 Field2AB1.... 1AB1.... 2AB3.... 3AB4 ....4AB5.... 5AB6.... 6AB7.... 7AB8.... 8So, AB1 has in field 2, values 1 and 2. So I want to filter that separately. Values can be changed, so I want generic solution. Can anyone help me with that? Thank you
Hi community,first of all, I whish you the best for the new year... Second, I have to create some report based on features retrieved by a first query.These features will be the "header" of the report page.I will have as much page as I have feature. The report "body" will be build according to query besed on the feature. So for example I will have: 1) 3 features : AAA- BBB- CCC==> 3 PDF pages with AAABBBCCC. The body of the pagze will be a query based on: Get info from AAA==> Create a table in the pageGet info from BBB==>Create table in the pageGet info from CCC==> Create table in the page... and At the end the 3 pages will look like: {MAIN_FEATURE_ID} TABLE WITH DATA---I already had a look at the PDFPageFormatter but I don't understand how it has to be configured. I hope you understand what I want to achieve.Thanks in advance for your help.Best regards,Steph.
Dear Sir or Madam:I am using FME to convert s57 to shapefile, but I cannot save the information below IFMEPloygon( the information in the red rectangle in the below picture).Can you give me some tips?Thank you very much.
HI there,I'm using S3Connector to download files from a bucket to a folder location defined in the "Download as File" parameter. These files may have special characters in the filename, such as: "%", "(" and ")" and they get converted to "_".Example: "1110716% - (Copy).dwg" --> "1110716_ - _Copy_.dwg" Is there some way to handle these characters?Or if there's a set list of characters that the transformer is treating these characters this way so I can set up rules down the pipeline to treat them as underscores? This is happening on FME Desktop and Server: 2020.2, Build 20787 Thank you,Janet
Hi,I would like to check if some points (around 2,000) overlap with building areas (around 54 million). When running the PonitOnAreaOverlayer it takes about 1.5 h to run as the transformer needs to count all the polygons, too. Is there a possibility to stop the transformer running after the points went through? I am still a beginner to FME, so there is probably only one single click to do...Best,Jo
I've noticed that FME converts AutoCAD text into a point at the bottom left justification of the text even though my CAD drawing has the text justified middle center. Is there any way to adjust where FME reads the text into a point? Thank you. Tyler FME(R) 2020.2.1.0 (20201130 - Build 20806 - WIN64)
Dear FME community, I have a question regarding a road network: I have a single road (top blue line) which is called "B 101". The road system has something like a positioning. Each road segment is divided into meters called "the stations", which are similar to a kilometrage on a highway, but the calculation of the stations restarts at every network point (the small red circles). They begin with the start position of 0 (attribute VST -> "FROM station"), and have different end positions (attribute BST -> "TO station") according to the length of the road. In the example the road goes from 0-1000, and therefore it is 1000m long in total. The station number increases with each full meter, the count direction is indicated by the ">" sign. In my workspace, I'm splitting these roads into smaller road segments. The blue road is split for example into the red road part, the brown and the green road part. The red part is not needed
Hi there, I have been using FME mostly for basic spatial and non spatial transformations, However this is my first time dealing with BIM formats. The case is that I am trying to transform an IFC file (extracted from a Sketchup project and georeferenced from a topographic survey) to a ESRI File Geodatabse (File GDB). Checking in Data Inspector, I noted the feature position is in Kara Sea, near the north pole, when It is supposed to be in the southern hemisphere, in Chile.Anyway, I generated a direct workspace and runs fine in the Workbench, and in ArcGIS I confirm the the same result of Data Inspector. Then I tried to reproject It to ArcGIS coordinate system; removed the original coordinate system and tried to set another one but I could not be able to match the proper position in both ways. What could I do to match the BIM file in the desired position?I have a point feature class with the coordinates of the BIM features, taken from a field survey. I can't edit or modify the IFC fil
Hey, we are working on ceiling grids in Revit and heard about FME can convert 2D grid objects to 3D and furthermore creat ceiling plates. Is there anyone who have worked on this before? I'm new to FME 😝
I have a lot of workspaces running off a lot of Oracle tables in a lot of different databases. When I run a workspace in which an attribute defined in a Reader doesn't exist in the source, I get this message in the log:2021-01-06 11:31:24| 1.4| 0.0|WARN |Oracle Reader: Column 'COLUMN_2' specified on Feature Type but does not exist in table 'TEST' and will be ignoredWhen I run a workspace in which the table no longer exists, or I lost access to it, I get no message at all and the workspace just treats it as reading 0 rows from the source. Is there a way to configure FME so that these cases will cause the translation to fail? I know I can do post reading checks to make sure rows came through and each attribute isn't missing, but I have a whole lot of these so it would be nicer if there was just a switch I could flip somewhere.
i tried to convert AutoCAD file with multiple views to MicroStation file using FME but the output file came with only one view ( which is model view) my question is can i convert this file and the output come with all view ?
hi! I have a very large text file which i would like to split. I tried using attributesplitter, but this transformer deletes delimiter. I want to keep it;)I also tried stringreplacing the delimiter by adding a new delimiter. Like this: <OLD DELIMITER> changed in <OLD DELIMITER><NEW DELIMITER). When splitting using <NEW DELIMITER> i can keep the old one... BUT... this proces is very very slow, since i have millions of delimiters. Also using old delimiter, then losing it, and then adding it back in again, takes ages... any idea's??? prolly there is a python trick. But i'm a complete noob;) thanks and cheers,ronald
Hi, everyone, I have road data of 2 cities, roads at their boarder may have same attributes like name, width and lane and I want to know if their attributes are the same. If there's only 1 road on each side, it's easy by using list. But like the figure below, if there're more than 1 road on each side, I can't find a way to build the right list. Maybe road A in city 1 and road D in city 2 are same road, or road A in city 1 and road C in city 2 are same road, so I want to build two lists with road attributes( road A and C, road A and D). No matter I use PointOnLineOverlayer or Intersector, I can only build a list with all roads attributes in it. Road A, B ,C ,D intersect at same point on the boarder. Can anyone help me out? I want to build 4 lists, A and C, A and D, B and C, B and D
I was wondering if anyone had any information on best practices for junctions and bookmarks use when building Custom Transformer? I have a pretty excessive custom transformer built that takes hours to complete. It is a looping transformer that utilize multiple blocking transformers (Group By), list, and many pipelines branching off junctions. I am trying currently taking steps to tune its performance. The log file had junction appearing over and over, leading me to suspect that eliminating them will reduce overall compute time. I am experimented with collapsed vs expanded bookmarks using cache feature, and yet to find differences--my logic was collapsing bookmarks reduce feature caching, therefore speed up compute. Thanks and cheers!! -Alex
For what specific reason to connect an "inspector" transformer instead of viewing the data through the "magnifying glass" of the last transformer? What is the substantial difference between the two methods?
I have FME running as container, which uses FTP to connect and get a files from FTP location. we are migrating the FME to Azure Cloud and deploying container in VM. we would like to use azure file share instead of FTP. could anyone help us on this ?
Hi all, I have an FME process that I run nightly to refresh a polygon feature class in my SQL Server geodatabase. What I'm trying to do is truncate the feature class first and then insert new features into the feature class. It has worked successfully in the past, but it's not working properly at the moment. The truncate call fails and features get inserted into the feature class. Since the truncate is failing, now I have duplicates in the table. Please see the logs below.. 2021-01-04 10:59:26| 248.2| 0.0|INFORM|Geodatabase Writer: Truncating table/feature class `GISO.Cadastral_FME'2021-01-04 11:21:04| 303.4| 55.1|WARN |Geodatabase Writer: An error occurred while trying to truncate table/feature class `GISO.Cadastral_FME'. The error number from ArcObjects is: '-2147154945'. The error message from ArcObjects is: {Table schema changed after cursor declared [42000:[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Could not complete cursor operation bec
How can I correct the timing of the data flow in this case? In the first "run" the data stream does not pass through the FeatureMerger. I think the problem is the 2DGridCreator which creates 100,000 cells before the FeatureMerger and which takes a long time. In the attached image I show how the transformation is after the first "run". Which transformer should I insert? And where should I enter it? Should I use the "TimeWindower"? How?
Hi everyone,I have 2 datasets:1. Polyline set (with x,y,z coordinates)2. Points set (with x,y,z coordinates)The second dataset I generated by using my FME workbench to extract the vertices from dataset 1 (with the chopper transformer), and setting its z to the correct value that it got from a 3th dataset (with neighbourfinder) which contained the "right = measured by a surveyor" z value for dataset 1.Now I have dataset 2 that contains points with the correct x,y,z, and a dataset 1 that contains polylines which vertrices correspond with the points from dataset 2, except for the z value.Is there a transformer that sets the z value of vertices from dataset 1 to the z value of any point from dataset 2 which overlap/ are the same as that vertex?thanks in advance.
Hi everyone, I have a points shape (.shp with Z value) that contains a field with measured Z-values (called Zvalue and is a float), which I copied from a different point shape in my workbench. The idea is that the Z value (the coordinate) is set to the value in it's Zvalue field. Does anyone know how this is done in FME?
I have 78 cells divided into 9 groups (attached image), and I need to dissolve in 9 rectangular in the right order (ascending), but, if I dissolve, it doesn't make it in a order ascending (attached images of attributes). Any advice?
Hello there is there a way we could build a 3D model of an entire city, from Pointcloud data and 360 images, the goal is to have a 3D model close to reelThe mobile Mapping that generates point cloud is done for the entire cityThanks
Look at the picture please
I have a polygon dataset, which amongst other things needs to have the coordinates of its vertices rounded to a centimeter. It seems that CoordinateRounder is not topology-aware, so I end up having self-intersections, which I cannot (completely) repair afterwards. I'm new to FME, so maybe I am missing something here?