Using transformers to modify data.
Recently active
Hi community, I have a data set that contains polygons which have arcs in them and others that do not. I'm looking for a way to select or filter the polygons that contain the arcs so I can do some editing on them but I'm not sure how/if I can extract these attribute properties to work with. Below are two sample images of properties that I'm referring to. Any help would be appreciated.
An obvious issue that needs a warning.If you have a single Server Engine and want to call a Workspace through FMEServerJobSubmitter. You cannot make use of FMEServerJobWaiter. It'll never complete as you only have a single engine.
Hoping someone can point me in the right direction, please.I have a workspace published on the FME Server and I want to be able to run this with the Property Number already populated from the URL.Thank youTim
I am reading in many autocad dwg files. I can extract the coordinates and reproject same. however i need to identify the CS prior to reprojection. These are all Autocad Map drawings with a coordinate system defined for each. the coordinate extractor does not recognize the CS. value is missing.
Is it necessary to use FME desktop to publish modified FMWs up to the Server repository, or can I simply use a file a manager to over-write the existing server workspaces with updated versions off my desktop?
Hello, I am currently trying to open a MRF file with FeatureReader. Usually, when i use FeatureReader, there is a particular output port created on the transformer.In this case, I only have the following output ports :SchemaGenericInitiator.Those outputs do not contain any geometry. When configuring the transformer, I do the following actions :I set the format to "Meta Raster Format (MRF)"I set the dataset I go into "Parameters...", and I set the Feature Type Name to "From format name"I set "Feature Types to read" to "mrf"I set "Features to read" to "Schema and data features"I set "Accumulation mode" to "Only use result".If I run this transformer, it does not fail, but there is no geometry output. If I use a MRF reader it works fine : when opening the inspector, I can see my data and click it. Sadly, this is not the process logic, I must use a FeatureReader. Did I forget to set some parameter ? Ho
Hi, guys.SolidBuilder transformer can construct a solid from surfaces.My question is, how does SolidBuilder transformer work? For example, by inputting 11 faces (as shown below), two small bodies, instead of a large one and a small one, can be built. But how does it implement? (Provided, of course, that the boundary point coordinates of each face can be matched)
I would like export from file e57, rotation (e57_rotation_w, e57_rotation_x, e57_rotation_y and e57_rotation_z) and translation (e57_translation_x, e57_translation_y, e57_translation_z) for the six images in the file. I can see this information in FME Data inspector but I can't see this information in FME Workbench.Thank
I have this Geometry and these Numbers:I want in my Attributes:ID | Right | Left | Up | Down13 | 14 | | | 1914 | 15 | 13 | | 20 How can i get the neighbors?
Hi.I'm looking into the streaming capabilities of FME Server, and is wondering whether a workspace may return more than one type of information as a streaming service.Streaming requires designating one writer in the workspace to be the streaming output, but that also limits the output to a single format. If your workspace is capable of outputting multiple formats, this seems to be a no-go in a streaming context.Does an "anything-writer" exist, that'll just pass anything on, textual or binary, as-is to the output ?Or alternatively, can a workspace switch the streaming target writer on-the-fly based on some condition at runtime ?Cheers.
I am using a matcher transformer to match multiple shapes. I have two shapes that are almost a match but are off by .001 of a decimal. In the parameters, I have setting the Vector Tolerance to 1, .01, .001, .00001 and each of those make them a match. We are unsure of how much vector tolerance we should allow because we want these shapes to be as close of a match as possible.
I'm translating dwgs into Esri file geodatabases. I am aware that i can set a search envelope on the reader but this is only useful if I know the extents of the the dwg. In my case I have 100's of dwgs with different extents and in many cases completely incorrect extents for the projection they are in (they could also be in one of 3 projections).The majority of the data in the dwgs is in the correct spatial location but there are spurious points, lines and polygons way off in areas outside of the project bound. This results in feature classes with inconsistent extents. Is there a way to filter the extent prior to processing so that only features in an extent containing at least 90% of the data is processed? I have started with a few things like counting the features and getting the coords and creating a bounding box....but i was wondering where to go from there? Any suggestions would be most appreciated.
Hi,I am using FME Desktop 2020.1.0.1 Build 20596 (64bit) and the Geometry Validator seems to not fix the Self Intersecting 2d polyline even though it comes out of the repaired port. Is this a bug or is there anything that I am doing incorrectly or missing a transformer? And what other solution can be done to fix this? Need a little help, please. Thanks Lex
I can't drape features from the BGT-downloader on a surface. When I inspect the features z-coordinate I can see he drape the features, but when I see the dwg-output not all the features are draped.Who can help me?I've attached the workbench and files.Thanks!
When doing the comparison, how to specify that my unique keys are going to be 2 columns? 1 column can have the same value in multiple rows, but there can not be two rows with the same value in the two columns. Example: This can happen 1 | apple | red | 2 | apple | green | This can not happen 1 | apple | red | 2 | apple | red | So in order to check which row has changed and update it or leave It unchanged, I need to specify two unique keys in ChangeDetector. I have specified the two columns in *Update Detection Key Attributes* but not working as expected May you advise? Thanks
Hi,Is it possible to see the table name of a SourceDataset geopackage in the command-line ?I have a geopackage 'biotopes.gpkg' containing several biotopes tables.The command-line only indicates the geopackage as source :--SourceDataset_OGCGEOPACKAGE "E:\\biotopes.gpkg"I would like to see something like--SourceDataset_OGCGEOPACKAGE "E:\\biotopes.gpkg\\biotope1"so I could choose the table of the geopackage in order to do some batch proccessing with a loop on the biotopes.Any idea ? Thanks.
Hey folks, I'm (relatively) new to FME and have had no formal training so I'm flying a little bit in the dark here. I'm curious as to the amount of time our dashboards run on Server and a few of the pre-existing dashboards (AverageRunningTime, DailyTotalRunningTime etc.) look as though they can tell me this, however they only give me data for the past day. Is there a way to modify these dashboard so that I can interrogate or view the data from the past, say, month?Thanks all! Marty
Hi guys.I would like to know if anyone has used FME on Debian 10? It was indicated to me that there is a problem with a library on Debian 10, but was not told what library it was, or if there is a workaround.I was told "You may be able to deploy it but may encounter an issue with running workspaces " Anyone know if this has been resolved?
Hi,I have extracted spatial features from a non Geospatial PDF as a vector file. I am now trying to georeference this in FME and cannot figure out how. Does anyone know how I can georeference the PDF to begin with, in FME? So that I can extract the vector features thereafter...I have tried this already...1) Converted the PDF to a GEOTIFF format2) Georeferenced in ArcGIS using the Georeferencing Toolbar3) Converted back to a PDF 4) Tried to read the features in FME but it did not work. FME was unable to find the spatial features (such as lines, polygons etc.) Any help would be much appreciated! Thanks.
Hello, I have a list of points and their geometry:Point IDStreet NameRegion 1Street AA 2Street A A 3Street B A 4Street B A 5Street C B 6Street C B 7Street A C 8Street A C I would like to create points that are located midway between points that share the same street name and region. In this case, I would like to create a center point between Point 1 & 2, another one between Point 3 & 4, another one between Point 5 & 6, another one between Point 7 & 8. There are always exactly two points sharing the same street name and region, never more or less. What transformers could help me? Thx.
Hi I am using FeatureMerger to merge attributes and geometry as followsTable1:ID1 Value1ID1 Value2ID1 Value3 Table2:ID1: Code1ID2: Code2ID3:Code3 I would like to end up with 9 records in the outputExpected result:ID1 Value1 Code1ID1 Value1 Code2ID2 Value1 Code3ID1 Value2 Code1ID1 Value2 Code2ID2 Value2 Code3ID1 Value3 Code1ID1 Value3 Code2ID2 Value3 Code3 I have tried various options in FeatureMerger, but I am still missing records in the outputThis seems to be in the Used Supplier port. Any suggestions ?
Hi.I'm trying to use SqlExecutor to update a table in my MS/SQL database. The table has a Danish character in it's name (Graveforespørgselssvar), but the database has collation Danish_Norwegian_CI_AI, so that's perfectly acceptable.But FME fails, because it mangles the name as UTF-8 (Invalid object name 'dbo.Graveforespørgsselssvar').I then tried to instead add the complete command as an attribute, and use AttributeEncoder to encode this attribute to both "Latin-1 Western European (iso-8859-1)" and "Windows Latin-1 (windows-1252)", both of which do contain all Danish characters, but it still yields the same error.Why do FME insist on sending SQL commands as UTF-8 even though both the attribute encoding and the database collation dictates otherwise ?It looks like a severe bug to me.
Hello,I'm using a SQL Executor transformer in my workspace. It is very very very slow (10 features in 10 minutes, I have 200 000 features to read).I have 2 readers and 1 writer from PostgreSQL spatial tables. I created indexes in geom attribute (gist) and primary key (btree) for the 2 readers.The SQL script is :update ref_assainissement.fildo SET nodterrain = 't' FROM ref_assainissement.canaexp WHERE idfildo = idfildoaval OR idfildo = idfildoamont(so very simple)Any idea ? Thank you !
Hi Guys, I am reading in JPG's and writing to a TAB file with attributes.I want to convert the EXIFF date format to DD/MM/YYYY with time if possible.The format EXIFF provides is YYYY:MM:DD HH:MM:SS eg 2020:06:03 08:55:21Can this be done in the feature writer? eg changing the value with a @Value(jpeg_exif_datetime,%d/%m/%Y) command is this the right approach?Dave
FME Server 2019.2.1 any antivirus or windows defender exclusion needed for FME Server/Desktop versions