Transformers

Hihow can Export right value of tester into csv file ?ThxFrancesco  

I am trying to setup a workbench for change detection where multiple users will upload data for change detection. I need to be able to handle the following cases1. User 1 adds features to fgdb and uploads. Writer fgdb has 4 features now2. User 2 adds features to a separate fgdb that does not contain user 1 features. Writer fgdb has 8 features now3. User 1 now has fgdb with all 8 records, he deletes two records and uploads. Writer fgdb should have 6 features now.Here is a screenshot of my workbench. I can get item 2 to work but not 3. 

FME'ers!This was asked in some capacity, but I can't seem to get this to work after reading all replies / documentation / trying numerous things.Problem: Split a single polyline into multiple lengths based on a table of measurements.Attempt: FeatureMerger (to get the geometry into the table of measurements)MeasureGenerator (to apply geometry)Snipper (to clip the Merged output based on two fields in the measurement table)Additional Info: Polyline is projected, US Feet, reading from a GDB, writting to a GDB*I assume I'm missing some logic in the Snipper or missing an iterator of some kind? I've tried numerous iterations of starting/ending, etc. My output is the correct number of records but no change to geometry / length) In other attempts, my output was flattened to the end of the polyline (correct number of records, just geometry at a vertex at the ends of the line).Losing my head about this one. Any insight would be massive!Many of you have chimed in previously, and I

Hello,I'm a student from Czech Republic and I'm designing sewer pipes in a sub-programme of AutoCAD. I've exported my project into 3D-DWG model. However I need to export it to IFC so me and my classmates can put it together with other parts of the building as well in IFC.I've read that this software can do this so I've downloaded student version. But I've just started it and I really don't know what to do. https://knowledge.safe.com/articles/595/autocad-to-ifc-conversion-example.html - this tutorial wasn't really helpful neither. Can you please tell me exactly (step by step) how can I transform the 3D-DWG file into IFC? Here's a screenshot of the model:Thank you all for reponses.

HiI would like to transform from DWG to TAB. My DWG's are currently in tile format, they each have a name eg. 1234.dwg and then within that they have multiple levels, so Road, building, Vegetation etc. Would it be possible to get this to directly translate into TAB. With a single tab file and then within the file I would have the multiple levels?Thanks for any help. B

Can I add my own fonts (Truetype or OpenType) to FME Cloud? Where do I place the files?(let's assume I have the relevant license to use the font on a server)

Hello all,Can anyone help me in transforming my feature schema as per the included screenshot? I need to create new field names based on distinct data values held within the existing ‘Attr_Type’ field, and then populate these new fields with the relevant ‘Attr_Value’ value.I’m using FME Desktop v2019.0.2TIA,RB

Hello. I have created this workspace before for other datasets without an issue, but for this particular dataset I'm getting the following error when trying to update or insert:MS SQL Server Spatial (JDBC) Writer: Updating using SQL: UPDATE [lccgis].[DRA_TASWATER_SEWER_LINES] SET [Material] = ?, [Diameter] = ?, [InvertLevelDownSteam] = ?, [InvertLevelUpStream] = ?, [JointType] = ?, [PipeClass] = ?, [SurfaceLevelUpStream] = ?, [SurfaceLevelDownStream] = ?, [Class] = ?, [SHAPE] = ? WHERE [MXASSETNUM] = ?MS SQL Server Spatial (JDBC) Writer: Error writing feature. Error: <null>delete works fine. Any ideas much appreciated.Lara

ESRISHAPE writer: 129837 of 361189 features writtenDBF Writer: DBF file exceeds maximum size of 2 GBUnable to output data to file 'C:\\Madhavi\\gis\\final_version_ sep2019\\Working\\Result\\CSV.dbf'Unable to output data to file 'C:\\Madhavi\\gis\\final_version_ sep2019\\Working\\Result\\CSV.dbf'Destination Feature Type Routing Correlator (RoutingFactory): Unable to output data to file 'C:\\Madhavi\\gis\\final_version_ sep2019\\Working\\Result\\CSV.dbf'Stored 1 feature(s) to FME feature store file `C:\\Users\\q040\\AppData\\Local\\Temp\\wb-cache-Centerline_updated_data-GEFkSH\\Main_CSV -1 2 -1 0 19480448bc73853f0954bf85b3af46ed9e867a09.ffsupdating'Saving spatial index into file 'C:\\Users\\q040\\AppData\\Local\\Temp\\wb-cache-Centerline_updated_data-GEFkSH\\Main_CSV -1 2 -1 0 19480448bc73853f0954bf85b3af46ed9e867a09.fsi'Finished saving spatial index into file 'C:\\Users\\q040\\AppData\\Local\\Temp\\wb-cache-Centerline_updated_data-GEFkSH\\Main_CSV

Hi!I'm looking for the attributes that contain autocad model units and block units.I looked on the attribute to expose but I don't find the answer. I test some attributes but there are only empty on the attributecreator. I checked the attributes on the reader, I use AttributeExposer and AttributeCreator. I don't understand... Thanks!

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