Best Answers

I have the following SQL being used by a SQL Executor; FME_SQL_DELIMITER ;DROP TABLE dbo.[PREMISE_CONTRACT_ROLLBACK];SELECT * INTO dbo.[PREMISE_CONTRACT_ROLLBACK] FROM dbo.[PREMISE_CONTRACT]; It runs successfully using the "Run" option when I'm accessing the transformer itself. However, if I just add a Creator > SQL Executor > Logger and run the workbench, the following error occurs;Microsoft SQL Server Non-Spatial Reader: Query failed, possibly due to a malformed statement.  Query Text `SELECT * INTO #fme_tempAdoDataTypeTable_spatialReader FROM ( SELECT * INTO dbo.[PREMISE_CONTRACT_ROLLBACK] FROM dbo.[PREMISE_CONTRACT] ) AS customQuery WHERE 1=0'. Provider error `(-2147217900) Incorrect syntax near the keyword 'INTO'.'Microsoft SQL Server Non-Spatial Reader: Getting Custom SQL schema failed. Make sure all columns are named (any ambiguous columns, e.g. GEOM.STBuffer(1), must have an AS clause). If there is an ORDER BY clause, either remove it or add a TOP clauseIt looks like FME 

I have a number of DXF input files feeding a workspace that writes to a SQL Server File Geodatabase. These DXF files are sometimes there, sometimes not. The fme workspace fails with a Fatal Error when the Input Reader fails to find the dxf file during "version check". As failure occurs before there is opportunity to incorporate a transformer, I can't use FileExistanceChecker or other file exists processes. Is there a workflow I can use to ensure the translation continues if the input file is missing?

Dear learned friends, I am attempting to automate the cleansing of a polygon dataset that contains a large number of overlaps. I have managed to identify where instances or overlap occur by using the AreaGapAndOverlapCleaner transformer and then overlaying the output from this against the original data set.I also have a point geometry dataset that contains an attribute linking it to a parent polygon. Many of these points reside within the identified overlapping areas.I now need to 'cleanse' the overlaps within the polygon dataset, but need to apply some intelligence to the process so that the assets within the overlap instance are retained within the correct parent polygon.Hopefully the simplified attached picture will explain this - the red and the blue polygons are overlapping, and the point assets (black dots) within this overlap contain an attribute stating that they relate to the red polygon.Thanks,RB

I tried installing the safe.robj-detect-pkg in to FME desktop 2019.2 build 19801 and I got the following errorRasterObjectDetectionModelTrainer.fmx ignored because it was created with a newer version of FME WorkbenchI downloaded and installed 2019.2.1 build 19813 and the same error occurredTransformer safe.robj-detect-pkg.RasterObjectDetectionModelTrainer version 1 in file C:\\Users\\apadilla\\AppData\\Roaming\\Safe Software\\FME\\Packages\\19813-win64\\transformers\\safe.robj-detect-pkg\\RasterObjectDetectionModelTrainer.fmx ignored because it was created with a newer version of FME WorkbenchTransformer safe.robj-detect-pkg.RasterObjectDetectorSampleGenerator version 1 in file C:\\Users\\apadilla\\AppData\\Roaming\\Safe Software\\FME\\Packages\\19813-win64\\transformers\\safe.robj-detect-pkg\\RasterObjectDetectorSampleGenerator.fmx ignored because it was created with a newer version of FME WorkbenchTransformer safe.robj-detect-pkg.RasterObjectDetectorSamplePreparer version 1 in file C

Hello Team,While installing FME Server 2019, System was asking to uninstall existing setup of 2015. Is it okay to uninstall it? Is there any further consequences with this action?Thanks in Advance

Hello Team,We have installed FME Server 2019 and published a workbench which was running fine with the FME Server 2015. But in newly installed 2019 server it was throwing following error. oordinate system named NiSource_AE_US_Foot does not exist.2019-12-12 08:49:53| 23.7| 0.0|WARN |Failed to get parameters for coordinate system `NiSource_AE_US_Foot' -- No definition was found for coordinate system `NiSource_AE_US_Foot'2019-12-12 08:49:53| 23.7| 0.0|INFORM|FME API version of module 'GEODATABASE_SDE' matches current internal version (3.8 20190621)2019-12-12 08:49:53| 23.7| 0.0|INFORM|Writer `GEODATABASE_SDE_1' of type `GEODATABASE_SDE' using group definition keyword `GEODATABASE_SDE_1_DEF'2019-12-12 08:49:53| 23.7| 0.0|INFORM|FME API version of module 'GEODATABASE_SDE' matches current internal version (3.8 20190621)2019-12-12 08:49:53| 23.7| 0.0|INFORM|An ArcGIS license is already checked out. The product checked out is 'Advanced'2019-12-12 08:

Hi there,I am new to FME, so please accept my apology if my question sounds too simple or stupid. I want to calculate two new attributes. Both attributes have different calculations. I am using Expression Evaluator. I can only calculate one attribute. For another attribute, I couldn't find any option to calculate another attribute. Am I supposed to use a new expression evaluator for another attribute? or is there any other way to calculate the new attribute? 

Hello  I 'm tring to set any value to AttibuteManager Transformer as you can see in the attachement. I have created an RandomNumberGenerator to fill a list but it doesn't work. I try also a rand function. Without success. Short, how to set random value in an AttibuteManager Transformer ? (the easiest way ...) Subsidiary question, how to create correct expression with the "text editor_attribute value" ? any help will be welcome.thanks 

I have a range of features e.g. coastlines, country borders each with different attributes. These attributes are currently available in a table under the following structure:Each feature type has a different set of attributes and I can tie the attributes to the geometry using the gsa_shape_set_id.How do I turn this flat table in to attributes dynamically adjusting for the schema of each feature? There are thousands of different features and I don't know the schema before this point.Many ThanksOliver 

I want to run a Workspace with each run a different Shapefiles as Source.I Use the "Directory and File Pathnames" Reader and set it to *.shp.Then i set the Source of the Shapefile in the Workspacerunner to windows_path. And here is the Problem:Now the Child Workspace runs with the Child Workspace Source Shapefile.But so many times as the "Directory and File Pathnames" Reader from the Main Workspace has.It doesnt get that he needs to Change the Source to another Shapefile in the Childworkspace.It only runs 8 times with the Child Workspace Source instead of Using the 8 different Shapes from the "Directory and File Pathnames". What am i doing wrong?

Hi FME'ers,Well, here are the quiz answers for this week. I think Don posed more of a challenge than Dale did last week. You would have needed a perfect score to beat him. Did you do that?First, the answers...Answers1) What is the name of the site for publishing and sharing FME functionality such as templates, transformers, and web services?FME User CentralFME OnlineThe FME StoreThe FME HubFMEpediaIt's the FME Hub:At one time it did used to be called The FME Store, and this community itself has been called FMEpedia and FME User Central at one time (in fact fmeusercentral.com and fmepedia.com will both lead you to this site).FME Online sounds like fun, but has never been a thing, as far as I'm aware.Don's Answer: The FME Hub (Correct) 2) Which of these actors is the odd one out?Eric BanaArnold SchwarzeneggerPeter O'TooleTim RobbinsAnne HathawayDon's Answer: Anne Hathaway (Correct) I know Don is a bit of a movie buff, but I think this one was a pure guess on his p

This may or may not be only answerable by the good people at Safe, but does anyone know where the SQLite database generated by InlineQuerier is created? Is is a temporary physical file, or instead uses SQLite's temporary in-memory (virtual) instance option?Just thinking ahead to some workspace performance tuning options. My workspace InlineQueriers work fairly fast but then the underlying storage is my local PC's SSD so that performance may not translate when executing where the read/write to the SQLite DB involves a different physical file storage environment.

Execution error? 1st parameter `XZJ' is not a floating point number?BUT I can't XZJ type

Hello @takashi I have an AreaBuilder before the ListCombiner. If areas are built they are then checked if they touch/ intersect via SpatialRealtor. After that the ListCombiner will group on the spatial settings. The problem is that if no areas are built (incomplete), I get the error message "PythonFactory failed to close properly". Is that probably because there is no attribute from built area to compute on in "orderByGroup"?So I wounder if there is a way to not activate ListCombiner (PythonCaller) if AreaBuilder returns incomplete? Please see attached image for log message.Thanks.

how rename feature attribute with python 

How this can be achieved in FME?https://support.esri.com/en/technical-article/000011817Source data – 2D point geometry with attributes 'FROM' and 'TO' (elevation values stored). The goal is to create 3D lines from those values.

Stupid question, but I'm wondering how much post-processing I need to do on the output of a ShortestPathFinder before writing it into say, an FGDB.So, a Path is not a Line feature in FME, it seems to be really an aggregate of its component segments, and each segment has a direction indicator on it so that the Path "knows" how to virtually act as a line with the correct virtual Vertex order, regardless that the component segments that are its aggregate, could alternately be running in opposite directions from each other, and one of a Path's segment's start vertex be an adjacent segment's start vertex as well (ie. The adjacent segments run in opposite direction to each other)However, if I put the output straight to say, SpatiaLite or FGDB, then the writer needs to downconvert the Path to Line. Fine, this is desirable behaviour in my case.My question is though: In what order do the vertices get written? In the direction of the Path, or does it depend on the orien

I can't seem to line up my elements/attributes on this lookup table I'm creating. Thanks in advance!Below is the screenshot of the XML attribute I'd like to create a feature from.Below is the parent-children tree of the elements I want to retrieve from my XML file.This is the screenshot of my workspace and configuration. Enable Flatenning is checked and all options are default.This is the result I'm getting from the workbenchBelow is the expected result  DomainNetworkNamenetworkSourceIdNetworkSourceNameAssetGroupCodeAssetGroupNameAssetTypeCodeAssetTypeNameElectricDistribution6ElectricDistributionDevice1Arrester1Distribution ClassElectricDistribution6ElectricDistributionDevice2Breaker1Air PoweredElectricDistribution6ElectricDistributionDevice3Capacitor1Fixed CapacitorElectricDistribution6ElectricDistributionDevice4Circuit Breaker1Air PoweredElectricDistribution6ElectricDistributionDevice5Elbow1Load BreakElectricDistribution6ElectricDistributionDevice6Fuse1Automatic Secti

 Hello,I am trying to find a soultion of workflow in FME, as to the attached image.My first attempt was to use the "NeighborFinder" and check if a footprint touches another. Then group/ list those (light blue circle). Then perhaps do another "NeighborFinder" check within a i.e. distance of 15, and make that a merged list (dark blue circle).I appreciate any idéas. Thank you!

Just downloaded 2019.2, and quickly run into a big issue - the HTTPCaller query parameter does not save. For example, if I set a pagesize parameter and its value to be 1000, click OK, reopen it, the value is empty. If I open a similar workbench previously saved in 2018.1, which has pagesize = 1000, change it to be 10000, click ok, reopen it, it is still 1000. I am on windows 10.

i have HSN field and some times those are having special characters, if it is not having any special character and it having single special character no need to select. But here which string having more than one special character then select.Special characters: /- HSN1-11-11-11/22/21-2/21/2-2/2 In above table i need to select on yellow highlighted data only \\

I would like to create some viewports that are circular and also one shape like this  Is there an autocad attribute I can set to make viewports in irregular shapes?

Hello. I cannot seem to run any workbench invokving a WFS. It seems to workan extent where it reads the get capabilities to give me the feature list but when i try to run preview or run the workbench, i get the error "HTTP transfer error: 'Couldn't connect to server'" We work behind a proxy but i have configured this in the s, and it works fine for wms, arcgis featur services. Just not WFS. the WFS service itself is fine, i can connect via other software such as QGIS just not via FME http://geoportal.ancpi.ro/arcgis/services/AU/AU_WFS_STEREO/MapServer/WFSServer?request=GetCapabilities&service=WFS Working on desktop 2019.2 Many thanks

with the new 2019 Version there is a new Feature:  i had these and worked with it then the IT reinstalled FME.I still have 2019 but now these Inspectors within the Transformers are gone.Is there an Option to activate or deactivate these?

Hello, here is my problem I can´t get solve: I try the "LineOnLineOverlayer" but I don´t want to touch the red, blue and green line. I have many lines at the same location with different attributes and nodes (black point in the image). After the transformer, the red, blue and green line have new segments I don´t want. Thanks for help!