Transformers

Hi guys,I'm trying to create a point table from a Road Polyline Table. Desired result:-Point layer where the roads intersect (Cross) with Attributes. (Point Object, Road A, Road B) Can someone please help me achieve this?? Thanks in advance. Tim  

Hello, I would like to process an excel file within FME, using python caller. First of all I wold like to find a string srt= "number: " in the excel, get the position of it (like A1) and define a cell that containes the value (like A2) and save the value as an attribute number and the value. Could you give me an example python script, please?

Hi, I am currently trying to get the shortest route of a fiber network that is in the forum of an autocad file. I created the topology using the topologybuilder transformer and I sent my edges to the networktoplogycaluclator which produced a network id while I sent my nodes to an attribute filter that filters out the hub. However, when I try to calculate the shortest toute using the shortest route transformer, I send my hub to the network port while I send my network lines to the from-to port. The results do not create a path (only nopath and <rejected>). I tried multiple ways such as putting a snapper before the shortest path but that also failed. Is there anyway to generate a path to the hub?

Hello All, Im trying to extract the points (in order) of an AutoCAD line. Ive managed to extract the points, the coordinates and do most of the workflow, but I cant get the Point ID.  In the attached, Im looking for an additional column that will give me Point IDs 1,2,3,4 etc per l;ayer. 

Hi!I would like to compare 2 datasets. I have 2 lists : dataset1 = the referenceobject 1 : this object have 2 attributes and 2 layers associated :_listattrib{0}.ATTRIBUT (string) = ATT1_listattrib{0}.LAY (string) = LAY1_listattrib{1}.ATTRIBUT (string) = ATT2_listattrib{1}.LAY (string) = LAY2 dataset2 = the data to checkobject 1 :fme_attrib_info{8}.field_name (encoded: UTF-16LE) = ATT1fme_attrib_info{8}.layer (encoded: UTF-16LE) = LAY3 I would like to find if the object1 from the dataset 2, has the same attribute and layer values than in the dataset1.Here, I would like to show that the association ATT1/LAY3 is wrong. The correct association is ATT1/LAY1. I find a solution with concatation, featuremerger and listsearcher but I would like to have a more correct solution, like use a Listsearcher but with a pair of values. I find something with PythonCaller but I don't use to write on Python.https://knowledge.safe.com/questions/3825/search-nested-list-elements.html  Thanks! 

Background: I try to update the attributes of features in an ArcGIS Server Feature Service via the REST endpoint. (ApplyEdits) In an attempt to create a generic solution, I write my features to an Esri-JSON, then read the result back in as a text file and use the JSONUpdater and the JSONTemplater to create the JSON ArcGIS Server understands. My goal is to produce the following JSON:[{    "id": 0,    "updates": [{        "attributes": {            "objectid": 1,            "attribute1": "a"        }    }, {        "attributes": {            "objectid": 2,            "attribute1": "b"        }    }]}]My Esri-JSON is:{    "RecordSet" : {        "geometryType" : "esriGeometryPoint",        "spatialReference" : {            "wkid" : ""        },        "features" : [            {                "geometry" : {                    "x" : 0,                    "y" : 0                },                "attributes" : {                    "objectid" : 1,                    "attribute1" : "a"       

Hi there  I receive the following error message in the translation log: LeftRightSpatialCalculator_3_SpatialFilter (SpatialFilterFactory): 'Filters First' was specified, but a 'Candidate' feature has been input before any 'Filter' features. Subsequent 'Filter' features will be ignored.If I change the Base Type to 'Single Base' I receive the following error message LeftRightSpatialCalculator_4_SpatialFilter (SpatialFilterFactory): In processing groups, the following warning "'Filter Type' 'Single Filter' was specified, but no 'Filter' features were input. All 'Candidate' features FAILED" appeared 1 times. when I check the reject output it has the following rejection reason: INVALID_BASE_GEOMETRY_TYPE Would anyone be able to explain what this means please?  Any help is greatly appreciated.  James

Error details:NeighborFinder_<Rejected>(TeeFactory): NeighborFinder_<Rejected>: Termination Message: 'NeighborFinder output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation''NeighborFinder_<Rejected>: Termination Message: 'NeighborFinder output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation'' A fatal error has occurred. Check the logfile above for detailsplease suggest best solution Regards: Rakesh

Hi All,I have 15 ECW files with a total of 20GB~ and another one large area ECW of 44GB.I also have the tif tiles for all of these images, about a total of 200GB and 600GB respectivelyGoal:Long term goal is mosaic 15 files on top of the 1 large file and reproject to use in GIS viewer.Short term goal I would settle for having only the large image reprojected!(and let the App look after the rest on-the-fly) I've only used the ECW files in my attempts so far to mosiac and reproject but the workspace slows dramatically it seems half way through. Then begins to show something like 'retry attempt 2' while processing-ECW writer: Completed 50.83% of intermediate processingAssuming at this point i'm running low on RAM. Using workbench 2019, 64bit, 32GB RAM and 1 TB of spaceI've since doubled my memory to 64, without really any understanding as to what i need. Hoping for some direction as to what resources i need to complete this job (without waiting weeks), or pointers as to

string searcher

Hello FME'ers,I read this great blog post yesterday and wanted to share it with you. As you can see from the content, these folks do use FME in their geospatial infrastructure, and very effectively from what I have seen.It's more about management than technical issues. The article talks about how, to be effective in the future it helps to understand your past. Their biggest problem seems to be keeping up with the rapid increase in demand for their services. I hope that's a problem we all share with them!Anyway, I thought it was an interesting read. Feel free to post any thoughts you have on this topic.Oh, and Happy Talk-Like-A-Pirate Day everyone!Mark

Howdy,I have street light points that I need to match up with their nearest address based upon an address point file. However I need to make sure that the matching address is on the same side of the street. 1) Is there a way to have the neighbor finder tool recognize a street center line geometry as a barrier and exclude a potential neighbor if the candidate angle crosses over a street center line?2) If that can't be done then I'd love suggestions on how to do this most efficiently.  Assuming the NeighborFinder can't evaluate a match based on a line barrier, the first process of achieving my goal that comes to mind for achieving this would be:run the NeighborFinder, then create a line between the street light point and the nearest neighbor address point (PointConnector),check to see if the new line crosses a street centerline (e.g. SpatialFilter),use the results to identify which light point to address point matches ought to be excluded/prevented;re-run the neighbor finder

HiI want to extract some values from an XML attribute, example content is in the attached file.The file doesn't display properly in my browser, download it and use an editor to inspect it.If I use https://www.freeformatter.com/xpath-tester.html with the following queries they work://gmd:title/gco:CharacterString/text()Text='Straßenbaulast'//gmd:organisationName/gco:CharacterString/text()Text='SAALKREIS//gmd:CI_RoleCode/@codeListValueAttribute='codeListValue=http://inspire.ec.europa.eu/codelist/RelatedPartyRoleValue/owner'XMLXQueryExtractor throws errors, e.g.for the first query:`fme_rejection_message' has value `The following error occurred near line 1, column 4 of the query: "gmd": can not expand namespace prefix to URI'Can someone give me some tips on how to handle the namespaces. I find the help a bit short on examples and the W3C resources impervious to reason.Thanks 

So in my workspace I read in an Access mdb file in. Run it through two attributesplitters transformers to split the BlockNO and LotNo fields I the have an AttributeManager transformer setup where I try to clean up and conact the fields back together. I do this be creating 2 new attributes Block and Lot an using a condition statement to reassemble the pieces like this However I can't format the if correctly, every case false and goes to the Else statement producing this type of outputThe "." with no value after it is what I am trying to avoid. Any help would be appreciated. Chris M

Hi FME'ersI've got a speaking slot at an upcoming GIS conference. I do have a number of ideas of what to present, but thought I'd throw it out for suggestions. It's a 20-minute slot and not everyone will be existing FME'ers. It's tagged as a "workshop" slot, but I think it's fairly flexible.I was thinking maybe presenting around an existing blog post:FME Server AutomationsNatural Language Processing With FME A Beginner's Guide to Database Updates with FMEThe Geography of Football Stadiums (as an example of data wrangling/integration with FME)Or I could do a basic Intro to FME workshop, or something with our Data Express app and Server.So, does anyone here have a preference or any other suggestion? I'd like to know what you might want to hear about, or what you would consider presenting in my position; but it has to be something to attract non-FME people if possible.Please feel free to discuss and let me what you think below.ThanksMark

Bonjour. je travaille sur une schematisation. J ai des surfaces qui se superposent. Comment faire pour les surfaces soient au minimum distantes de X metres. ?merci d'avance Hello. I'm working on a workflow. I have overlapping surfaces. How to make surfaces at least at least X meters apart?Hello. I'm working on a workflow. I have overlapping surfaces. How to make the surfaces at least distant from X meters. ? thank you in advance

Does anyone know which attribute (s) you have to work with if you want to be able to get to standing(vertical) text in a dwg export? I have a workspace where I load text (regular text in plan) from a autocad dwg. I want to rotate the text 90 degrees around the x-axis so that it becomes upright (this so that it can be better consumed in eg Navisworks) I have tried with 3D rotator which usually works but it does not seem to work for Text objects.My workaround is the moment to use a Textstroker and then to rotate the polygon objects it creates. The polygon objects rotate just fine with the 3D rotator. However, I would like to have the vertical text as text objects rather than polygons. I know that FME can handle vertical text objects because i tried importing a file with vertical text and export it to a new dwg, the text i still standing. There must be a way:)

I would love to hear from anyone that has some experience in validating data in AutoCAD viewports / paperspace.I have managed to create a workspace that validates the data in model space but where there is additional data in paperspace and viewports is proving a little trickier.If you have some examples or strategies that would be great.ThanksDean

Hello,I have two columns Category and Class already filled. I would like to compare and see if the class entered is in the right category.Example :Category = 10 / Class = 20, 40, 60Category = 11 / Class = 20, 21, 22, 23, 24Category = 12 / Class = 23, 25, 27, 29, 31 Category Class RESULT 10 20 True 10 22 False 11 23 True 12 23 True 10 29 False 12 31 True 10 60 True  Thank you very much in advance for your help.Best Regards

My workflow is simple. I use shp files generated from Land Cover metadata to clip the ERDAS Imagine file and convert it to polygons. Each shapefile contains a polygon as a clipper. As instructed by the forum discussion,1) In Workspace1, I set the workflow options as "Single Merged Feature Type" and I chose one of the shape files in my sample data folder (which contains three sample shp files).The output file is named based on the input shapefile name.2) In Workspace2 - Path Reader setting, I set the dataset folder to sample folder and only read in shp files.3) In Workspace2 WorkspaceRunner setting, pointed the FME Workspace to Workspace1 - tile2polygon.fmwset the shapefile to path_windowsset the erdas img file to the corresponding img fileset the destination folder to an empty folder I run the workspace runner without any issue reported and as I checked the destination folder, there are three files with name corresponding to the input shapefile. However, all three shape file

Hello,I want to extract polygons from a raster by using "RasterToPolygonCoercer" but the result doesn't look very promising and I am lost for ideas.I would be happy for any hint to solve my problem.Thanks :)Input:...and output:

I have field COST like below SN.sFruitCOSTQuantity1Apple20per Peace2Banana3per Peace3Orange8per Peace4Mango50Per KG5Cherry250Per KG6Papaya40Per KG7Graps80Per KG8Dragon200Per KG9Kiwi30per Peace10CustedApple60Per KG11Fine Apple40per Peace12Green Apple25per Peace And i have to read MAX value in Cost field

I need to re project from the Standard Namibian projection to WGS84. THis is a South-Up projection. Now I get this message. Where can I change this setting? Coordinate System `Lo22-15' parameters: CS_NAME=`Lo22-15' DESC_NM=`Namibia Lo22-15' DT_NAME=`Schwarzk' GROUP=`Namibia' ORG_LAT=`-22' PARM1=`15' PROJ=`TM' QUAD=`1' SCL_RED=`1' SOURCE=`Dirk Tietens, GIZ-SLR MLR' UNIT=`GERMANMETER' X_OFF=`616.8' Y_OFF=`103.3'Loaded module 'GEOTIFF' from file 'C:\\Program Files\\FME\\plugins/gdal/GDAL.dll'FME API version of module 'GEOTIFF' matches current internal version (3.8 20190621)GEOTIFF reader: Directive '_READ_OFFSETS_IN_CS_UNITS' has the value 'No'GEOTIFF reader: Opening file 'C:\\Users\\erik.velzing\\Desktop\\Freedom Square 10cm Nov18.tif'GEOTIFF reader: File with negative value for ScaleY in GeoPixelScale tag. This is rather unusual. GDAL, contrary to the GeoTIFF specification, assumes th

Hello,I have six polyline features, where each node of the polyline has a measure(I used MeasureSetter earlier in the workbench)I want to create two new attributes "MIN" and "MAX" where;MIN = the measure value of the first node in the polylineMAX = the measure value of the last node in the polylineI think I need to use the MeasureExtractor to do this? But I cannot get it to workI tried Type: Individual Vertex by Index, with Index: 0 but the result was <missing> 

Hi All,I have my data in the form given below. The data from 1507 to 2451 is a header and the three rows highlighted in green are one set of data and another set is appearing below it with differing values.Now i want to have the data in the format:where A to J are my columns names from the header (A-J may change in number like sometimes A-F or A-I or A-J as well). Value is coming from first row of the set of data and text from the third row of the set of data.Sometimes the data may be missing also. e.g the second row may be missing and only two rows are there. so for that value we have to write nothing in the main table (shown above)I have attached the excel file for reference Kindly help.