Using transformers to modify data.
Recently active
FME Desktop 2020.0.0.0: What is the best practice to fix issues identified by “geometry validator” tool? For example, in the screenshot below, I got 1 failed, 4 invalid, 5 locations. What could be the best practice to fix them? The data is attached
I have a workspace with a single 3D model (a tree) and a point dataset of several thousand points. Is it possible to replicate the 3D model and geo-reference it for every point?
I'm trying to schedule a flow based on an end user's chosen start time (which they'd pick and submit via an FME Server app). To do this, I've built two flows: one that takes all the parameters (including a scheduled start time) and has a server app built in front of it; and a second one that actually does the heavy lifting and is either called via a webhook or is scheduled by FME Server. I've tried to be clever and set a HTTPCaller at the end of the first flow to initiate a new once-off schedule in FME Server, but it's always failing with this error message: "message": "Unauthorized request by user admin due to lack of proper permissions or the object does not exist."Any ideas? Or even thoughts on better ways to do this?
Hello. I am trying to run a bunch of online and zipped INSPIRE GML's through a Feature Reader with the dataset parameter set to a URL defined in an attribute. All is good and stuff is happening for most of the data except the URL's that have a space in them, for example: 'http://www.catastro.minhap.es/INSPIRE/CadastralParcels/02/02024-CASAS IBAÑEZ/A.ES.SDGC.CP.02024.zip' And those get sent to the reject port with the error message: XML Parser error: ''Error in input dataset: 'URL' line: 1 column: 50 message: whitespace expected'' I did check out this one here:How do I remove a non breaking space from an attribute? (safe.com)But no luck , so any ideas?
Hi,I'm looking for the best way to combine raster-DEM data with construction point cloud data (exists only at some places, not covering the whole DEM ) to output a new modified raster DEM. The point cloud data contains vertexes from the construction (which means it also has ground points - but I'm only interested in the surface, where it overlays the DEM). The point cloud has no info saying what type of point it contains. Can this be modeled in a way that only uses the surfaces from the two datasets or do I need more steps than one in this analysis? Any suggestions?
I have polygons on wich I want to calculate some edges infos. However, I want to do the calculation on generalized edges and after bring it back to all orignal edges. For instance:Polygon -> edge -> generalized edge -> chopped to 2 vertices lines -> calculate attributes on lines -> merge attributes to original edges Is there a way at the end I could merge attributes from the generalized line segments to the original line segments?
It seems as though the SchemaMapper is setup for only If-Then statements. I'm wondering if there is perhaps a way to use the SchemaMapper by way of a Contains statement. For example, if Attr1 contains 'xyz', make Attr2='123'. I don't believe this is possible, but was curious if anyone found a work-around to make it work.
Hi. I have a xlsx file with a field containt Path to a PDF. I want to validate if the PDF of the path exist. Can you help me. Thank you.
Hello, I am attempting to test if an input date exists between a date range - I'm struggling to find the correct syntax or transformers to do this (after 40 minutes of trying). Can anyone help? Currently my input is to AttributeCreator the time for now - @DateTimeFormat(@DateTimeNow(),%T)Then so far I have used a Tester to see if it was greater or less than two times e,g, >= @DateTimeFormat(09:00:00, %T) OR <= @DateTimeFormat(09:05:00, %T)But predictably this doesn't work as it will always be greater or less than one or the other. I would like to use BETWEEN (if I was using SQL).Is there an efficient way to do this in FME? Other than converting the time to a number (which would mean regex-ing the leading '0' up to midday) and then comparing numerical values in a (presumably) AttributeRangeFilter?Apologies if I am missing something basic! Help very much appreciated 🙇♂️ 🇬🇧
Hello, here is what I am trying to do in a workbench that is attached here:1) Input data are .xyz file with a list of 3D point coordinates, jpg + jgw files with DEM photo2) I need to create surface TIN + set an appearance to it3) I need to export it into a format that Trimble Connect is able to process.(https://community.trimble.com/viewdocument/supported-files) - There is a list of 3D supported formats The problems that I run into:1) Data need to have a defined coordinate system.1) I need to create a FME Cloud app, where customer is able to run this transformation themselves. 2) The formats that Trimble Connects do not support textured surfaces / solids3) FME Cloud does not support many writers that Trimble Connect would be able to process DGN - FME is unable to write 3D solids (only extrusions, which is not what I need) or meshes, all dgn files that I try to create are after loading simple lines.https://community.safe.com/s/question/0D54Q000080hfr8/dgn-writer-outputs-lines-instead-of
Hello, I am trying to convert text strings like Jan-2019 to date . The text strings don't have the day values. I have tried using DateTimeConverter transformer and the date time functions in AttributeManager but it doesn't work when I specify %b-%Y. However, with the DateTimeConverter, when I convert text values like Jan-05-2019 using %b-%e-%Y , it is correctly converted to 20190105 . How can I achieve the same to convert the dates like Jan-2019 without the day value to 201901 ? Thanks
I am in the process of converting a large Excel file to separate JSON documents for each column in the Excel, keeping a common ID column that each JSON document must contain. The hard way of doing things is using an AttributeKeeper to preserve the common ID column that I need and the specific column that I want to make a JSON document for, with a separate writer for each JSON document. Is there an easier way to do this, similar to a Fanout but instead of grouping by rows of similar feature types I can do it by column?
I have several polygons in my workspace and I want to consecutively clip a subset against each other (see attachment). Of course I can do that all manually but if the input changes, then the workspace has to be adapted each time. I thought of using the aggregator to have the features on "first level" with a list of all features of the second level. Next step could be a custom transformer with a loop. Do you have any other suggestions? I am also not to deep into custom transformers and looping, so any advice is welcomed ;-)
I want to make sure that I have the same number of records in each group. What transformer to use? btw I want to preserve each record's attributes values as I want to write the records to a db later on.
Hi Everyone I have come across an ifc file where the Feature Reader does not find all IfcSpaces when reading a file. Both ifc Viewers DeSite and Solibri manages to read the files, but the Feature reader loads maybe only a third of the objects. My suspicion is that there has been some post editing of the Ifc file by some third party software or created with a plugin EDM? EDM Software:https://jotneit.no/express-data-manager-edm Example of Ifc FileStructurehttps://essxnce.wordpress.com/2019/07/31/190731-searching-how-to-make-ifc-file-from-non-ifc-file/ If someone know how to read there files with success, please give me a shout out! If not, I imagine this needs to become a feature request to be able to read EDM IfcFiles? RegardsFred
I need to convert dwg to pdf and one of the line styles is "- x - x - x - x". I can create different dash line but not sure I can add x in between dashes. I hear there are possibilities of either converting it to raster when writing or keep the vector form. I would love to get some idea on how to do both. Thank you!
Hello, I have a lot of big scripts a lot of test criteria. Is there a way to import test criteria for a tester? I know the import function for the AttributeFilter but that doesn't fulfill my needs.
I'm running JSON Fragmenter to break out an array, and, in the process, it indexes each row of that ID. Is there a way to retroactively put the last JSON Index value of each ID's array into every row associated with that ID? I'm trying to calculate a percentage of where each row is compared to its total. (JSON index [8] of ID XXXX is in the first 2.34% of ID XXXX's total JSON Index.) Thanks, in advance!
I am trying to write a fanout of a large pdf using bookmark data that was merged from a csv file. The fanout works, but the output files give me either blank pages or very blurry/unreadable images. The source file contains many jpegs and was created using BlueBeam. I am able to see raster images using RasterConsumer (filtering to single pages), but the end result is unusable. Here is my workspace with annotations:Surely this is possible?Thanks,@lorenrouth Update:After looking at the data from the GeoSpatial PDF Reader, the issue appears to be the file has multiple formats on the same page. How do I deal with a pdf that has text, image, raster, spatial and vector data all on one page?!?!? If I send spatial data only to the writer, it leaves out an important raster image. If I include the raster, it is output with an unreadable black background and blurry text. If I print the pdf as an image, it looks fine, but there is no text or metadata associated with it, making it impossibl
We have to update email address and phone number employee information in a REST available application from LDAP/AD and want to use FME. With the LDAP reader being in Technology Preview stage we are a little concerned about moving down this path and may have to use a .net application instead. Is there a timeline for when the LDAP/AD reader will be ready? Thanks, Simon
I want to split my shape file to 6 parts. The count is aprox 600000. How to do this using if condition. Pls guide me
I have a layer representing building polygons and another layer showing garden polygons; what I need is to create one merged polygon representing a building and a garden. This is based upon whether the building polygon touches/abuts (borders) a garden polygon, however this must be a 1:1 relationship so if there is more than one garden that the building abuts, then it must choose the garden polygon it has the longest edge with. I have tried to use the NeighborFinder and Dissolver, but it does not seem to work between the two polygon layers. Any ideas are welcome. Thank you.
We use the ProjReprojector to reproject data (FME 2020.1.0.1), using a wkt string. For the UK, a special datum shift grid is specified in the wkt2 string, yet the resulting raster is not located correctly when reprojecting to EPSG:3857. I'm wondering if this issue is related to FME, parameters in the wkt2 string or my (limited) knowledge in this area. When reading the raster, FME reports a crs of _FME_0. I can manually set this to "OSGB-GPS-2015-OSTN15" using a coordinate system setter, yet I prefer to perform the reprojection based on the wkt2 string. Can somebody please assist in how to do this with FME? Attached zip file contains the raster data, the wkt string, a document with the current (and expected) location.
Hi, I have two shape files. One containing roads and one containing the grade of the condition of the road based of an inspection. The shape files share two attributes, starting point of the road and ending point of the road. I would like to add an attribute in the road shape file, which is the grade from the other shape file. Not every road has been graded, but I would like to add the grade as a new attribute for those that have a grade. So, if there is a matching starting and ending point in both shape files, which means that it is the same road, the grade should be printed as a new attribute in the road shape file. I hope this makes sense. Thanks a lot in advance! :)
Here are the BADNEWS errors, these I haven't seen before. Could someone help me out in the right direction where they are coming from or does someone know a solution? 2021-12-09 14:46:38| 4.0| 0.0|ERROR |BADNEWS: An error occurred while fetching from query `SELECT OWNER, TABLE_NAME FROM ALL_OBJECT_TABLES WHERE OWNER IN ('GBIBASIS','PUBLIC') AND TABLE_NAME = 'GB_MECH_LEIDING'' : OCI_NO_DATA2021-12-09 14:46:38| 4.0| 0.0|WARN |(C:\\code\\fme\\foundation\\framework\\util\\dbwrap\\ocistmt.cpp:663) class StatusInfo *__cdecl STFDB_OCIStatement::fetch(unsigned long,unsigned long &)2021-12-09 14:46:38| 4.0| 0.0|WARN |Exception Name: stk::ex::Throwable -------------------------- 2021-12-09 14:46:40| 6.0| 0.0|ERROR |BADNEWS: Cannot convert null string into an integer2021-12-09 14:46:40| 6.0| 0.0|WARN |(C:\\code\\fme\\foundation\\framework\\util\\stf\\stfutil.cpp:348) class StatusInfo *__cdecl STF_stringToUInt(const class ObsoleteString &,unsigned long