Transformers

A colleague upgraded another software on our FME server and somehow changed the setting on 100s of workspaces to Translation: Rejected Feature Handling:Continue Translation but they should be Terminate Translation... anyone able to batch change them back? I have tried - changed the default in FME Options, rebooting.... Thanks!This was on FME Desktop 2017

Hi,We currently have some issues about transferring SLD (Styled Layer Descriptor) styles between QGis and Geoserver. Their syntax support doesn't seem to be completely in sync. So we might need to tweak the SLD files when transferring them.Now, SLD files are XML files, so it would be entirely possible to let FME do the "dirty work".But before venturing into this, I'd appriciate hearing about whether anyone has looked into this issue before? And if so, what the pitfalls are. Or if there are other more beneficial avenues to follow?I can see that there are multiple suggestion about support for SLD, so this ties into that. Even an SLD format reader/writer perhaps ? Don?? :-)Cheers.

Hi, I have a Esri FileGDB with style information in a *lyr file. I want to use this data in QGIS and therefore I need to convert the *lyr file in *qml or *sld.Is there any possibility to do this with FME? Or does someone know another way for the conversion?Thank you and best regards.

Hi, I am parsing a 3D CityGML model that mostly have a texture for each IFMEFace. That is great, but sometimes there are duplicate IFMEFaces, one with texture and another without, which I can filter out those untextured ones using GeometryPropertyExtractor. But other times, there are untextured IFMEFace with no duplicates that I still like to keep, which the GeometryPropertyExtractor filters out regardless. How can I achieve this?I tried the Matcher but I think I just want either the SingleMatched or NotMatched output, not both.Thanks for any help.My current setup:

Hi everybody, I need to align two multi-band raster with the same resolution. Is there an FME equivalent of Q-GIS raster alignment tool ?

I have a lot of lines with two attributes Attr. 1 Count from 1 to xxxxxxxAttr. 2 Range set default as 0Now i have to make a loop workflow... -Select lowest number from attr.1 and set attr.2 with "1" now go all other lines through and check if there is a segment equal than the first feature we selected (many lines have same segments...in the end i want only 1 line per segment )if there are detected same segments delete these linesafter that select the next lowest number in attr. 1 which are still available and set attr.2 with "2"and so on and so oni will try it by myself, but any ideas are welcomeCheersFranco

The next query results in an error (ORA-00900: Invalid SQL-statement.)FME_SQL_DELIMITER /beginupdate tbx.ext_compare_person set   gesnam_d           = tbx.diakriet_cip(gesnam_d,sourcekey,'GNAAM'),     gesvor             = tbx.diakriet_cip(gesvor,sourcekey,'VNAAM'),     gesnam_d_p         = tbx.diakriet_cip(gesnam_d_partner,sourcekey,'GNAAM_P')where organisatiecode = 'ABDC'and   applicatiecode = 'ABC';end;/commit;/What am I doing wrong?Thanks in advance.

I have a polygon layer that has various geometry issues, mostly self-intersections. I have used the GeometryValidator to clean these up, but it has had the unfortunate consequence of filling in the holes. This is because they are not proper holes, but "fake" ones created by digitising a zero width corridor. So the hole boundary is actually part of the exterior boundary (highlighted in example below). The corridors are detected as self-intersections. Is there anything I can do to output the polygons with proper holes, or at least detect the polygons with fake holes so they can be edited manually? There are too many self-intersections reported by GeometryValidator to use for manually repairing the holes.I've found this similar topic but I'm not quite sure if @offermann82 is looking for the same solution...https://knowledge.safe.com/questions/59610/how-to-split-polygons-with-holes-that-touch-the-bo.htmlI think I want the opposite of what DonutBridgeBuilder does...ht

I have two versions of GeoJSON data for the same floor where I need to identify changes for both geometries and attributes (example original data has 73 rooms and later modified like two rooms merged into single,two more rooms created by partitioning of one room and revised data makes it to 72 rooms). Now I have tried to check these changes using Change detector tool the output result differs for attributes and geometries.I have used latest beta 2019 desktop as the enhanced version of Change detector available.Please suggest me I have attached the workbench snapshots with results.Where for only attributes I get fairly good result for deleted,added areas but not for the updated areas. Where for only geometries I get everything to be updated .Please note the work-space reads original data queried from SQL database and the revised data from GeoJSON reader but both data has been extracted as GeoJSON with parameter precision 7 in the workspace.Please suggest how to get the proper result.

For example if one: I want to merge a feature with an attributevalue that is called "East Dartmoor" to a feature with an AttibuteValue called "East Dart". Would it be possible to add a wildcard to the feature merger?

I have a table A like:123 and a table B like: 111222333 I would like to run a process on each row at a time in table A e.g. join to another table B that matches then run a process on the match, write some features, then proceed to the next record in table A i.e.2 and run the same processes on matches in table B i.e. 2 and so on..I don't know how to do this in FME without writing a cursor or loop in a script. Hope it makes sense.

I work with geometries (routes) whose vertices have 4 dimensions: XYZ and M (measures). How can I round M coordinate values stored in the data to a specified number of decimal places? The coordinate rounder only covers XYZ dimensions.

I have a pressing deadline but I have no PERL skill and need this attribute trimmed - Lot/Plan(separators).an example of an attribute:1/AB842550I am duplicating the column Lot/Plan(separators) into two columns - Lot and PlanAll characters to the left of this symbol "/" are the Lot numbers required in the Lot columnandAll the characters to the right of this symbol "/" are the Plan numbers required in the Plan column. Any and all help would be greatly appreciated.Thanks peter

Has anyone gotten FME Server to work with the Atos DirX Directory 8.4 server using LDAP v3? The LDAP server is on-site (not cloud).We are able to set up a successful connection but as soon as we try to import users and groups into FME Server 2018.1 it crashes with an unhandled exception in the logs:(Active Directory) Searching using filter "gdiReader"...Thread stack trace:getStackTrace(Thread.java:1559) / ensureNotNull(Validator.java:60) /createSubstringFilter(Filter.java:633) /searchUsers(FMEUidActiveDirectoryConnection.java:942) /searchForUsers(LdapSearchServer.java:411) /executeRequest(SecurityRequestsDispatcher.java:928) /handleRequestSecurity(FMEServer.java:384) /handleFMEServerClientRequest(FMEServer.java:285) /handleFMEServerClientRequest(RequestHandler.java:98) /processClientRequest(RequestHandlerBase.java:856) /readClientRequest(RequestHandlerBase.java:589) /handleClientRequest(RequestHandlerBase.java:772) /run(RequestHandlerBase.java:946) / run(Thread.java:748)LDAPSDKUsageExc

Hi!I have a question about how to convert a PNG palette to RGBA.My input features is in palette format (int8) storing all the RGBA values in one band.Now I would like to export it in PNG-format with the RGBA-values stored in four different bands instead. Does anyone know how to do it?

I have a feature class. There is a ID field in this feature class, like below: 101L1101L2101L3101L4101L5101L6101L7101L8101L9101L10...102L57102L58102L59102L60102L61102L62102L63... I plan to add a new field called AZIMUTH. I need to use ID field above to find the "next" feature, for example, if current feature ID is 101L4, I will try use 101L5, and use this "next" feature and current feature to calculate AZIMUTH. Can you tell me how to find 101L5 in this case? Better use transformers. If not possible use python is also OK.

I have a CSV file with Lat/Long for a point features and String for radius of exposure, I wish to create buffer for each well since their radiuses are different, I followed a tutorial but all the buffer went to one single point. Each point has 3 different radius, so I need to do this 3 times. In the attached tool I only used one radius at a time, this is for sensitive radius. The lat log is originally stored in NAD27 DD.

Hello people,I am new to GIS and FME. For my study we are using ArcMap. Ik have an shapefile and now I need to create a 5000 meter buffer around the shapefile. Therefore I must use the Bufferertool from FME. The result wil be written to a file geodatabase. Anytime I run the spatial ETL tool from FME I get an error and see no buffer of 5000m around the points of the shapefile.I have ad some screenshot. Does anybody know what I am doing wrong in my setup?Thanks in advance.Tijs

Hello everyone,I am relatively new to FME and have put together a conversion of 4 tables from a sql server database into a couple of embedded collections with a $lookup link in MongoDB. I've had a couple of issues getting the data directly into Mongo, but with a subset I have tested transforming it into a JSON and then loading the JSON into Mongo and that works fine. My issue is seems to be with memory when i try to run the full dataset through. I have been stripping the translation back into smaller chunks so that my machine isn't trying to run the full process at ones, but now I'm at the stage where I cannot strip anything away. The first bit of translation I am trying to do is taking the 6.7M row table and creating unique MongoID's for each row and then saving it as a JSON, which is pretty straight forward. However, each time I have tried to run this with the full dataset I get to approximately 3.5M rows loaded and then the JSON writer closes due to memory issues. Be

I need to create a point/line geometry out of the following input data:a) route: line geometry stored with measure values, including a route id fieldb) point/line event table without geometry, including a reference on the route id field, a measure value field (point event) / a start and an end measure value field (line event)Is there an existing transformer or a common known routine in FME to solve this problem?

Hello,I have a dng file that In print, the text information (i.e. codes) is in rectangular boxes linked (only visually I think) with arrows that point the corresponding geometry. However, When I imported the dng in FME, the geometry remains at the proper spatial place, but all text is moved to (0,0) therefore even the visual connection is lost.What I am trying to do, is to relate the text as an attribute in the geometry. However, it does not look like there is any sort of linking that could help me do this.I would appreciate any sort of ideas on how to process this, my question is too vague so I do not expect a specific methodology set. How could we relate text information from dng with its corresponding geometry?Thank you for your time.

the xml fragmenter refuses to recognize the xml in this doc (see attached). What am I missing?

I have a scenario where I need to convert the bit depth of a raster from 16 bit to 8 bit, or vice versa, but the type should remain the same. ie Gray16->Gray8, Int16 -> Int8, Red8 -> Red16, etc.Given that the RasterBandInterpretationCoercer does not accept attribute values for the Destination Interpretation Type parameter, is there an alternate method to testFilter for all allowed types, and 14 hardcoded RasterBandInterpretationCoercers?

I have an XML extract using a Soap interface that has a section with lists of user defined attributes. I have a schema for these but I am having trouble extracting the contents. I expect to be able to rename the fields based on the order after extraction. For example in the IDENTIFICATION path there are UserFields{1} to {5} that I want to extract and label like this 1 Manufacturer No Alphanumeric 40 2 Manufacture_Date No Date 11 3 Model_Number No Alphanumeric 40 4 Make No Alphanumeric 40 5 Serial_Number No Alphanumeric 40

Hi,I'm trying to download table data from Statistics Finland PX-Web API (documentation here http://pxnet2.stat.fi/api1.html). URL for example for the cube and the table containing population demographic data is: http://pxnet2.stat.fi/PXWeb/api/v1/fi/StatFin/vrm/vaerak/statfin_vaerak_pxt_001.px . Px-Web API can return table data in various formats, including csv and excel.Using HTTPCaller and GET or/and JSON-reader I've been able to receive nested JSON containing list of all the different variables of the desired table, but the problem is that this request does NOT retrieve the actual data.In my understanding I should send a specified JSON-query using GET/POST-command to API to be able to download the actual data. But I have no clue how to do this in FME. I've tried to go through JSON-readers schema scan using JSON-query, and I looked for the HTTPcaller but don't know if Query String Parameters or Body settings could help me with this. JSON-query should look somewhat like this:{  "query