Transformers

I'm trying to call a PowerShell script using the System Caller transformer. The syntax of the system caller command line is: C:\\Windows\\System32\\WindowsPowerShell\\v1.0\\powershell.exe -ExecutionPolicy Bypass -file "C:<path>powershell_script.ps1"I'm using it to access ProjectWise and run some process. I have tested it with PowerShell and it only works with Admin rights. However it does not work within FME and does not recognize the Powershell module commands for ProjectWise. The error I get is:'New-PWLogin : The term 'New-PWLogin' is not recognized as the name of a cmdlet, function, script file, or operable'I have tried running the workbench with Admin rights but it still gives the same error.

Hi I tried to install NLP Trainer on my desk but I received an error (probably python installation)  Francesco 

Hello everyone, I have a workspace that takes 2 point feature classes from a geodatabase and calculates the Root Mean Square Error (RMSE) of the x and y coordinates (i.e. sqrt( x(observed) - x(predicted))**2/n)). As part of this calculation I would have to do a truncated mean calculation where I would drop the top and bottom 10 % of records of residual X,Y values and then calculate the RMSE on the remaining 80% of the records. I understand the statistics calculation for truncated mean but I am not sure how to do this in FME workspace. Any help/suggestion is greatly appreciated. Thank you!

How do i compare data row count from two tables across two databases? Basically i am trying to load data if source has more rows than target table.

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