Using transformers to modify data.
Recently active
Hi, I have a dataset I want to check matches with another one. In particular I need to make sure that if the business area names match between the 2 datasets that the sub-business area listed is one named under that business area. For example if in the 1st spreadsheet;Business area = Environment, Sub-business area = River or Forest Business area = Air, Sub-business area = Quality or Pollution.Then in the 2nd spreadsheet, if the Business area is Environment then the sub-business area should only be River or Forest. If is it Quality then I need to know this is incorrect. Also is there are way of doing this without having to list out all the sub business areas (e.g. if you used a tester with environment = river, forest,etc).Thanks in advance and also happy to clarify if what im asking isn't clear.
We use a Directory and File Pathnames to extract filenames and path_created_date and store the value for all new files in a database.When we move to summer-time and winter time, it seems that FME gets 1 hour different and adds all files again. So I have checked the following, to see if the timezone settings were off:FME Server: own custom server - Western europe standard time - UTC+1 Database: MS SQL - Not sure File server: - Western europe standard time - UTC+1This is really annoying - and it would be great with a universal solution. Any tips or someone had a similar issue?
In a control file (.fme) in which I chose the source file and the destination directory, I would like the log file to be in the same directory as the destination directory. How can I do ? Thank you
@takashi As you have probably worked out I'm fairly new to more than push button FME. This should be really simple and probably is but I want to expose a numeric raster band value and create an attribute from it so that when I covert the raster to polygons I have the value as an attribute of the polygons. I have tried using attribute creator but can't work out the syntax. This leads on to another probably basic and related question: I want to replace values in a raster based on ranges of numbers - eg 0-12 becomes 12 and more than 12 but less than 20 becomes 20, etc. I can string together multiple instances of RasterCellReplacer to approximate this but there must be a more efficient way using RasterExpressionEvaluator for example. Again my syntax to do this is lacking. Any resources for a self-taught FME'r on that front that start at the basics?
I'm now working with localization of FME Descktop 2017.1. It's also a good opportunity to take a closer look at what's new. I would post something I noticed through the job.FME 2017.1 build 175391. ListBuilder The "Input Ordered" parameter seems to be shown at a wrong location. 2. NeighborFinder It's great that the new parameter "Take Measure/Z From Candidate" has been added. However, I'm not sure if it's reasonable that "Yes" is set to the parameter by default. How do you think about this? possibly to be continued...
Hello. I am using FME 2017.1The issue I am trying to resolve is stopping the ArcGIS Transformations window from popping up when I add a shapefile that was created by FME. The FME shapefile is in the correct projection (same as the dataframe) but the FME PRJ file is slightly different than the ArcGIS PRJ file. I am assuming that this is what is causing the Transformations window to pop up. So, my question is: how do I create a PRJ file from FME that is the same as what ESRI expects so that the Transformation window doesn't pop up in ArcGIS?Here are the details of what I have done:Right now, the projection I am using from ESRI's ArcGIS is not in FME. The FME projection that is the same as what I am using is 10TM115-83.I created a Custom Projection by created a .fme file and putting it into the following directory (C:\\Users\\<<USERNAME>>\\Documents\\FME\\CoordinateSystems) as suggested on this form:http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workb
Hi,I have a point Shapefile that I would like to recreate in raster, specifically, ESRI Ascii Grid format.However I am having issues in that when I use the 'NumericRasterizer', some of the resultant cells in the raster are up to 0.25m away from the original location of the points. Is there any way that I can set the rasterizer (or use a different transformer) to force the resultant cells to be overlaid exactly on the original points (ie: points will lay in the centre of the cell)?Thanks
I am tryintg rasterize one dwg. I am using this scheme that can be seen on screenshot but unfortunately I am getting blank result. Does anybody have an idea what could be the problem?
Hello,this time I do not come up with a problem but with a request for ideas/opinions etc.The scenario:static geographic locations, where samples are taken on a regular and irregular basis are hold in different database environments such as Oracle Spatial and Smallworld Data Stores. The measuring values are hold in an Oracle non-geographic environment. There is an ID that connects both "worlds" (yeeepie!). Probably there will also be non-static sample places (ad hoc samples) in the future whose positions are not yet stored anywhere. Here, the question how the data will be georeferenced, has to be answered first. For this scenario I exclude these sample positions.The idea now is to join both worlds (geographic and non-geographic data) and visualize it in a map environment. Visualize in this context means:- overlay the sample positions with any WMS (own and third party) - delimit the sample positions by location and / or attribute(s) - select which type of, e.g. biological para
Whats the minimum FME Desktop / Server version to use with ArcGIS 10.6?
Hi all,Upon creating rgb values it appears that the lueb and green channel are reversed.When I create the values with an expression evaluator and set them on objects (linear), the gradient is correct.In the raster however the blue and green are reversed. (swapping green and blue channel values corrects this)Is my observation correct? Is this intended?
I have two input files, and I want to check whether or not the address in one input file (comprised of a street attribute, number attribute, postal code attribute etc.) matches the adress in another input file (also comprised of more or less the same columns). It's a string/text object, so I don't need it to be an exact match.I've already tried feature merger, but it seems as if feature merger only accepts exact matches. I could be mistaken of course.
I have line feature which I have cut down from the administrative boundary and I need the result which have only the administrative Areas outside of line Buffer Areas.I used Generalizer,Bufferer, dissolver then Clippers("Clippers First" to the Clipper Type parameter in the Clipper). Dissolve areas are in Clipper port and the administrative boundary areas in the Clippee port, then shows this error and all dissolve area comes on the rejected port of Clipper and output is written only the administrative boundary.ClipperVector(ClippingFactory) Extra clipping feature encountered and ignoredClipperSolid(SolidIntersectionFactory) No clipper supplied for group,all clipees will be treated as OUTSIDEhave anyone any suggestions?
Hello everyone,I need the [B] (Green) areas, the administrative Areas outside of road Buffer Areas. Be precise, I need an area which have no Road.Therefore, I used:Bufferer -> Generalizer -> Clipper ("Clippers First" to the Clipper Type parameter in the Clipper)->Buffer areas are in Clipper port and the administrative boundary areas in the Clippee port and output is Esri Geodatabase (File Geodb API).Unfortunately, the Clippers is too slow. After 14 hours, it finished only (clipping group 16985 / 33079)I have total 60001975 buffer road. How can I improve the speed of the Clipper and get my desirable output.Thanks
Hi, I have a simple txt with many coordinates like (no header):554174.746999408, 5598075.08612377, 554175.302999408, 558090.53212377, 554177.963999408, 5598129.63312377, 554182.011999408, 5598160.71912377, 554182.176999408, 5598181.49312377, 554180.422999408, 5598212.50312377, 554172.863999408, 5598249.02912377, 554167.975999407,I want to validate that geometry. I tried using different readers (txt, csv) and transformers like stringreplacer. I found this question https://knowledge.safe.com/questions/39344/use-of-the-geometryreplacer.htmlbut could not modify my workbench with success.Any hints on that?
Hi, My linked custom transformer ('ColorAndReproject') is used in many places in my workspaces and I am regularly working on it. This is why it's not embeded.I have installed it with double-clicking the *.fmx file.It's stored in a "Shared FME Folder".The workspace does exactly what is expected if I run it in the workbench or if I run it with a *.bat file.Sadly it does not work when the scheduler kicks-in during the night and tries to run the script (*.bat). The scheduler is a special Windows user with some admin rights.I get this error log :The custom transformer 'ColorAndReproject' referenced by this workspace could not be found. The custom transformer must be installed before the workspace can be runProgram TerminatingThere are other workspaces run this way with no problems. But none have a linked custom transformer.Any Ideas ?Thanks for your help !edit : it seems the real problem is that each user executing a script with linked custom transformer should have FME configured to have
I think this could be either a bug, or an issue with my understanding.image below, why would the exact same feature class, put through the exact same geometry validator yield different results between readersTop scenario in image is with Geodatabase File ReaderBottom in image, is with File GDB reader
Trying to get some calculations done.But as soon is the band and the attributes are combined the calculation fails.The pic shows the expressions.The first 2 get a values rest drop to No Data.Tried rounding using int8, 16 etc. , ceiling. Every time same result.Tried different interpretations.The input is a DEM; min= 0 and max 519 (Real64) Any tips on this?The calculation is a non-iterative variant for gradients. These work neatly in python script I made (did not invent the calculations , mind you)tx for any thoughts!
Does anyone think it is possible to take annotation that is a single feature but contains multiple words (of different rotations) and create a new feature for every word with a new textpoint geometry and rotation for that word?For example the following is a single piece of text that is curved to follow the road.I want to separate this into two objectsNew location for the second wordNew rotation of the second wordI haven't attempted this yet but wondering if its something that could possibly be achieved in FME Thanks
I am new to FME and need to perform an intersect with a specific cluster tolerance. In ArcGIS Pro you can set the cluster tolerance during an intersect (http://pro.arcgis.com/en/pro-app/tool-reference/analysis/intersect.htm) but I don't know how I can reproduce this in FME? The clipper does not have this option and there is no "cluster tolerance" transformer. Any suggestions?
In a workspace, I retrieve by spatial relation (AreaOnAreaOverlayer followed by a Sampler, SpatialRelator after InsidePointReplacer, ...) an attribute value in a table and a shape that have nothing to do with the table and the source shape. So I create a second workspace in which I retrieve the previous attribute value in the table and the original shape by a Joiner. How can I do this in one workspace?
This might be the most stupid question ever posted but I do find this problematic. I've had difficulties with this many times over the years which leads me to the conclusion that I'm not using best practice. On FME Server (Windows) I want the user to input a folder and then I want to read several pdf-files (for uploading to S3) from this folder. When run I get all errors despite how I format the path. So, I'm guessing I have configured FME Server wrong. I've tried UNC-paths as well. This will be a difficult task to solve in this forum I guess.Another option would be to input a zipfile with all the pdfs neatly zipped into it. What would be the best practice for this? That is my question.
Hello everyone, I am working with line geometry as a reader. Then i buffered the line feature and used generalizer (with Algorithm: Douglas Generalize, share boundaries: No, Tolerance:30), to simplify the buffered line feature and need a output with Esri Geodatabase (File Geodb API). But it shows the errors:Failed to write Geometry to feature class 'way_r' with geometry type 'esriGeometryPolyline'. Dropping containing featureI have also attached the ERROR text. Please help me.Thanks.
Hey, i use an Attribute Remover to get rid of Attributes i dont need. Although, when i use a User Parameter to declare what Attributes to remove it doesnt work. If i preselect them in the Parameter Editor of the Transformer it does. Any ideas?
Hi ,We have 100's of layers and to maintain the data quality we have to perform spell checking on the attribute tables. So my question is is there any way we can check all the attributes string values through FME or is there any spell check transformer. There is always a possibility to have typo or misspell, so cleaning thinngs using FME will be great.