Using transformers to modify data.
Recently active
Hi, How can you see if a line is a multiline or a polyline?I have a shapefile where i have both but it's creating problems so i have to detect the multilines en make polylines of them.I would think that i should use de deaggregator?
Hi all, I'm using the AmazonAthenaConnector to query an Athena database.In the Translation Log I'm seeing: "2023-03-10 09:04:27| 6.1| 0.0|INFORM|AmazonAthenaConnector: Query ran successfully. Run time: 5.225 seconds. Data scanned: 27694.09 kB" I'd like to use the info on the file size / Data scanned to do some cost calculation. 1: Is there a way to incorporate the output of the Translation Log as attributes in the workbench? Alternatively I guess I could load the .log file in a workbench and use that for the calculations... 2: I am wondering , can I run the main translation AND the .log file in the same workbench? (wait for the main translation to have finished so it can read in the log file and perform operations on that.)
I plan to use this method after a transformer "AttributeFilter".So the the number of cases the valeu of an ttribute varies define the repetition number the transformer .
Morning all,I have points (A) at the intersections of streets/lines. Also I have points (B) scattered everywhere. I need to keep location points A at intersections but would like to bring attribute information from points B. Point A can get all other points around it and stacked at this location.
Hello everyone.I used this tutorial in order to convert 2d Polyline with Z value (for example, polylines of rooftops), in order to transform them to 3DML file.I succeed to do that, but I have a small problem.The exported 3dml's height is penetrate the terrain surface because the FME don't know what is the absolute ground height. The question is how can I fix this problem? There is an option maybe to insert height surface? (You can see that the problem may accrues because Extruder don't know what is the absolute ground height) This is my schema: Thanks a lot!
Hi,The listsearcher makes it possible to search in a list for a certain value on 1 Attribute.Is it possible to do this (without listexploder) to search in a list for values on different attributes?list example:_names{0}.LC = Arabic_names{0}.NA = Latin_names{0}.PN = true_names{1}.LC = Arabic_names{1}.NA = Arabic_names{1}.PN = true I want to search in names list where PN = true & NA <> Latin and get that indexback. In this case it would be 1If it's not possible in FME, how would I do this via python in FME then?
Hello.I've read in 52 gpkg files into one featureReader. I now want to translate the 52 gpkg files to 52 tab files. But to avoid creating 52 separate featureWriters I want to do this in one featureWriter. Is this possible? If so, how? Thanks.
Hello, could i get some tips for Validating IFC files.
I am trying to reproject coordinates that are in NAD27 to NAD83. I am not sure about what I am doing wrong?I am using the FME Desktop 2021 version.
I am using an HTTPCaller to return some XML which I then want to turn into attributes. I can extract the Project fragment below using the XMLFragmenter (with Projects/Project in the Elements to Match parameter) but I haven't figured out how to directly extract the children into fragments or directly into attributes. Using Projects/Project/* doesn't work. For instance, I want to extract ProjectNumber and Status more directly into attributes. So far my solution has been to use a StringSearcher and SubstringExtractor to get each attribute. That's a tedious way to do it. Any advice on a better way? <?xml version="1.0" encoding="UTF-16"?><Project ProjectId="508DKDS6B2KA" ProgramId="YAK0C5V4UNVH" ProjectNumber="EST-00001" Status="Cancelled/Archived" StatusTimestamp="2021-04-01T12:23:55-06:00" LastChangeTimestamp="2021-06-29T14:15:01-06:00" ></Project>
Does anyone have an example of how to successfully write out to 12d XML?
I have a polygon .kmz over a portion of New Jersey USA setup as LL-WGS84. I need to create a 3m x3m grid across the polygon. I am using a Reprojector to *XY-MT* and then a 2DGrid Accumulator to build the grid. The resultant process only creates 1 grid. What am I doing wrong?
I haven't changed anything to these Excel writers, but after having added some transformers to the workspace they suddenly all start writing to column E instead of A. Even after having disabled the new transformers they still do that. I can't find any setting explaining this (I haven't set a start column, for instance).
Hi, I'm wondering if something is possible at all in FME. I have two parallel 3D lines on a railroad. A "left" line and a "right' line. I want to create a new line at the center of these two lines (the railroad center)Once this is done I would like to resample all three lines together so that they all have vertexes that are perpendicular to the center line. This is exactly what the Topodot tool "center line extraction" does if you adjust element vertices. I was wondering if it is possible to do in FME so I can automate it. I don't have any python skills to make something The result would look like this Any advice would be appreciatedThanks
When working with XSD Driven XML Writer I noticed that I don't get an error message when I have a typo in the feature_type name or attribute name. It simply does not add it to the output. And this makes it very difficult to find bugs and problems. Also the validation of the XML ends with a message that "something went wrong". But no details where and what. Is it possible to list all items that could not be found in the XSD?Maybe some setting in the FME Desktop general settings? Thanks.
I am sending the FuzzyParrelLineFinder 3 features that are lines with 2 coordinates only (i.e. start and end points). The coordinates are identical. The lines are 64 m in length and I am using the parameters of: Sampling Distance = 1 and Search Distance = .30. The FuzzyParrelLineFinder is not identifying the lines as matching. Are there situations where the FuzzyParrelLineFinder doesn't work or have I miss-understood the parameters?
I recently received the subject error. The error occurs when inspecting any downstream table of an AutoCAD dwg reader. The workspace appears to run successfully, then while scrolling down the transformer inspection table (in visual preview), the inspector suddenly throws an error and breaks out of the visual inspector table into the translation log showing the subject error. Clicking back on the table, and no records are shown past 100 (there are actually 1000s of records). Any ideas about what is going on? Thank you,TylerFME Workbench 2022.1
The Z-coordinates are not the same and varying. The points are located within a buffer of 0.1meter and extend over the entire area of the polyline. I have to join them based on a search area I think of 0.1 meters. The points are created from a las and transformed using the pointcloudtopointcourcer. As an example, I would like to have for this polyline which has 5 vertices 5 unique z-values from the closest points.
I have a highway line feature class and a highway distance markers point feature class with points created at 2km intervals along each highway line. I am being requested to create a rotation value to apply to each point on the line that is equal to the perpendicular angle on that line at each point. This angle value will then be used to apply label rotations to ensure each label comes out perpendicular to the line feature it is on.
Hi, has anyone had an issue with updating a non-spatial Oracle (19) table. The table has been registered in SDE, hence has OBJECTID also.There is no failure, but the record is not updated. If I use an SDE writer with update operation, it works fine, but takes over an hour for 300K records. I am using FME Desktop 2022.1Any ideas ?
How can I publish images to arcgis server image using FME? I'm newbie on arcgis server image. Thanks
I can group separate features together for labelling purposes and this is what the attribute looks like as an autocad_mtext_string However, I can only assign one colour by using this approach.How can I assign separate colours to lines of text within a grouped mtext string so it looks like this?
Hello,I am using the chart generator with some small numbers to make a scatterplot. I can't figure out how to display the axis values in scientific notation. See the example chart generator output image below using some made up values. The Y axis values range from 1.0e-3 to 1.0e-9. I would like to change the axis values to scientific from decimal. Thanks for the help
Hi,I am having an issue where I want to remove duplicate values from the results of the change detector and merge them all in to a single row to remove duplicate entries. I have provided an example below.If you need more information just ask. Thanks.
Hello fme team, I have a line of length 100M, When i load to fme the defualt measure is 0-100, the real measure position of the line is start = 15.0 and end = 16.0, the line has attribute columns start and end in the attribute table. Any idea how i can assign the start and end as measure values instead of the default measure 0-100? regards,Keller.