Using transformers to modify data.
Recently active
Hello,I have a .cal file saved in python to create a unique identifier. How can I use this in FME? I didn't create this so I don't know how to tie this to the field needed. In Arcmap I could just right click the field I want this to go in and field calculate it, but how would I use this to update attributes with nulls in a specific field within fme. import uuiddef f(): return "{" + str(uuid.uuid4()).upper() + "}"__esri_field_calculator_splitter__f()
I've offset a number of yellow polys in this example 3 original inputs in the one layer.I would like to subset this by selecting only the polygons that are mutually exclusive i.e. select only the polygons on the bottom left that do not overlap the other 2. Then all the polys on the top middle that do not overlap with the bottom left and right and so on.Here are some of the end results that would work in teal. I did this manually but there would be more of each.
I have created a mesh in pythoncaller and included already earned uv coordinates. Everything looks good after python, but if I try to write a file to any 3D format, then UV does not hang out. Have used: FMEMesh.appendTextureCoordinates FMEMesh.appendVertex
hello. Im using InlineQuerier in a worbench where I have changed the attribute naming. Therefore, I dont want to read from a reader but from a transformer just before the InlineQuerier. Is it possible? Mnay thanks
Hello,What is the trick to create a polygon from a set of coordinates and make sure FME read the points in the order to create the required polygon where _result field can be used as ID and acknowledge the order in which polygon should be created ? I went thru a bunch of transformers, but I did not succeed with any... I went thru several articles from the knowledge center as well, but cannot figure it out. Hope the question makes sense.Thank you for your inputs, regards.
Hello,I am trying to run an FMW file using a batch script and although I can run the batch file manually and it will run successfully without any hiccups and in very little time (2-3 mins) when I try running the same batch script as a Scheduled Task it takes way too much time to run (I haven't even let it finish as it was running for over half an hour) and doesn't look to run the same way (their log files differ).I would love some help to get this working properly. I know FME Server does this much easier but our office doesn't have the resources (or business requirements) to purchase Server and so I'm stuck trying to make this work with a Scheduled Task. Any help would be greatly appreciated, thank you.
Good afternoon, I am currently experiencing a issue with fme server job submitter and feeding user parameters via a csv file.I have a workspace on a 2018 server that works fine if the user runs the work space directly from the repository and within the workspace the user can select from a variety of user parameters to extract data based on date, format, projection etc.when i try to run that workspace via a server job submitter using a csv file containing all the parameter details it appears that the server job submitter is truncating or moving the parameters to the next parameter. This appears to be happening with part of the date formatting. if i remove the date formatting out of the csv then the server job submitter appears to run correctly. the date format is needed as our data base is quite particular about extracting in that particular format.below is a snip from the log file. you can see that the server job submitter appears to moving the data within the parameter to the next par
Hi everyone,I've got numerous of bridges as Polygones that are to short. I need to extend the bridges along a vector or line feature that I allready got. If the Polygones would only consist of 4 edges I could solve the problem, but they do not. Please help if you got any advice or idea!
Hi,I've got the following script in an SQL Executor:update tbx.ext_compare_person set gesnam_d = tbx.diakriet_cip(gesnam_d,sourcekey,'Gesnam'), gesvor = tbx.diakriet_cip(gesvor,sourcekey,'Vornam'), gesnam_d_partner = tbx.diakriet_cip(gesnam_d_partner,sourcekey,'GesnamPartner')where organisation = '1234'and applicationcode = 'ABC'Parameters are:When I execute the script via "Run" (test in SQL Statement) it runs perfectly. It updates the correct rows. But when I run the translation complete, it doesn't perform as tested (it updates nothing).What is the best solution here? Am I doing something wrong?Thanx in advance, Erwin
I am struggling to create an ERS header (using desktop 2015) without the huge datafile when I generate large ECW mosaics, can anyone help please? At the moment the ERS file is being generated at the point where the ECW file is being created after the JPEGs pass through the RasterMosaiker, I need the .ERS header to go with the .ECW
My features have an attribute _mapsheet. When I use the inspector I can see the _mapsheet attribute is populated when it comes out of the FeatureReaderBut then when I check the attribute after it has been through the RasterExtentsCoercer (which I have named RawRasterExtent in my workspace) the attribute is no longer populated.I had this workspace working in FME 2017. Is this a bug in 2018? Or is there something extra I need to do.TIA
Hi,I have a table of locations that I'm trying to split into from_location and to_location columns as shown below. Starting with: Location1234Want: from_locationto_location122334Thanks for your help!
I have a set of approx 2000 rectangular polygons I need to offset where overlaps exist.Approx 50 have overlaps as below.I'm using a custom transformer written by somebody else in this forum to create offset candidates. This has 2 numeric fields I can use to find the optimal offset location i.e. distance and angle (closest to the right). These could be incrementedin a loop for e.g. until no overlaps exist. e.g try a counter clockwise loop of the closestset and if overlaps still exist then try the same on the next closest set until a non overlapping candidate is found.I've had partial success however I am not sure how to design a workspace thatwill offset 1 polygon at a time. i.e. it needs to select a candidate offset based onmin distance and min angle (closest to the right) then compare that to all otherpolygons (no overlaps) then apply the offset.Subsequent offsets would need to check for overlaps against existing 2000 polygonsbut also against all those that have already been o
I have been supplied a LAS files to extract features from. FME has been able to do a pretty good job at it and I have been able to extract the likes of Road Markings and Signs from the pointcloud. However, I am hoping that there may a few more idea of refining the process to get "nicer" features from the data.For the road marking, I really want a process that looks at the outer points and removes all the vertices in between. I can't seem to find a "generalization/smoothing" that does it nicely. (Thanks to @dmitribagh for the initial workspace) For the signs, I have just have got to the point to of extracting from the LAS. So I need to create into a vertical surface/polygons. I have an idea to extract the full surface in much the same way as above, although to I believe for each sign, I will:- User Centrelinereplacer to extract the angle of the sign.- coordinateswapper, so that I am looking down on the sign face- Rotate the sign using angle to look at the full
Hi all,I am wondering how is the best way to create a new column in fme with say last modified date and then extract the last time excel file was saved into the column for each record?Thanks
Hello! I used Clipper to divide the lines with the areas. In some places as a result of "outside" I got lines consisting of two elements.How can I remove parts of lines that do not get red line? I used Chopper to separate the lines and then I wanted to filter the data through Spatial Filter (by "filter intersects candidate" where Filter is a red line) but it doesn't take into account Chopper's separation..Thanks for your help
I have a database with polygons. The data is three buffers (dounuts) around some points of interest with a unique location id. All donuts should get data from one or two of the neighbouring donuts.This is the starting table (first four attributes are the starting ones):idlocation_idbuffer_nrimportance_valueimportance_value_new110111022 (10+7+5)21012712 (7+5)3101355 (5)410212034 (20+11+3)510221114 (11+3)6102333 (3)7103123-etcMy table is sorted on location_id and buffer_nr. Basically:for each buffer_nr=1 I want to create a new value based on the sum of all importance_value with the same location_idfor each buffer_nr=2 I want to create a new value based on the sum importance_value wwith buffer_id 2 and 3.
I am using an Rasterconvolver for image recognition - the input image raster is a 8bit grey value. After transforming i'll do get an 64bit result. How can I manage it, to get the same output depth ?
Hello! I need to get a sum of some features. Please have a look at the picture, it is maybe easier to understand what I need. I need to get a sum of these houses therea are in the different parts of city. The problem is that the name and amount of streets are allways different. I do not know how to automate it.. Any ideas?
Hello all,I have an issue with StringPairReplacer. I want to use the word boundaries function in this transformer but it's not available. PairsBeforeAfter1TransportTrans.2WorkWks.ResultBeforeAfter1Deniz TransportationDeniz Trans.port2NetworkNetWksI want to manipulate only "Transport" and "Work" words not "Transportation" and "Networks".Is there any workaround for this issue? StringReplacer is not easy to use for a huge abbreviation list. I need to add hundreds of StringReplacer transformer for each case.Thank you
I am trying to keep elevation values (attribute; autocad_elevation) of a .dwg file in my conversion to a shapefile. I specified in the writer parameters (under the user attributes tab) that the value should be ;left pointing yellow arrow to autocad_elevation. After conversion, I open the .shp in ArcGIS and see that all the attributes I specified are there, but still with no values. Any Help?thanks!
I have 1,392 .asc files that I want to mosaic into a single .asc file.The input files are tiles of a 1m DEM.I am using a ESRI ASCII Grid reader to open the 1,392 files together, then a RasterMosaicker to merge them together, and a ESRI ASCII Grid writer to output the result.I get this errorEsri ASCII Grid Plugin: Fail to open the Esri Ascii Grid reader on file `\\\\podcisilon\\Groups\\Geospatial_GIS\\ALS\\2014\\LGA_Brisbane\\Products\\DEM_1m\\SW_507000_6964000_1k_1m_DEM_ESRI.asc'ESRIASCIIGRID writer: Failed to get tile of size 1 rows by 54000 columns at row 18000, column 0A fatal error has occurred. Check the logfile above for details
Trying to do a simple .dwg to .shp conversion. I have multiple inputs, how can I ''batch'' select format attributes so that they are kept in the shapefile writer? For now, in the feature type parameter,I choose "select all'' to include all autocad and fme specific attributes. But how can I do this if my .dwg has hundreds of feature types? hope this is clear.thanks!
After setting up HTTPS, I am getting 'Error Submitting job' message. The FME Engine log contains: FME Engine failed to register with FME Server 'localhost' on port 7070. Maximum number of allowable FME Engines reachedIn the list of engines, there is only 1 engine.I have followed the following steps and the certificate generated looks fine i.e. no errors on the browser.http://docs.safe.com/fme/html/FME_Server_Documentation/Content/AdminGuide/configuring_for_https.htmAny suggestions ?
Hi!I'm trying to create in FME Desktop a published parameter that contains the date time now as a default value.After publishing my script on FME Server, when I go on the web page calling that parameter, I'm not getting a value. I get the function string.I tried to choose a Date type in my user parameter, but I only get a calendar.Any idea how to get the current date time in a user parameter?Thanks!