FME Form

I have a workbench that reads features from a table from Microsoft SQL Server Non-Spatial and writes (Feature Operation: Update) into the same table. I have read and write permissions, reading is working fine but writing gets the following error message:Microsoft SQL Server Non-Spatial Writer: Connection failed. <connectionstring>. Provider error `(-2147467259) Named Pipes Provider: Could not open a connection to SQL Server [53]. ' Failed to open writer Failed to open writer f_22(CreationFactory): Failed to open writer I've tried several things, but none of them is working. I've read this https://knowledge.safe.com/articles/281/failed-to-connect-using-sql-server-2012-native-cli.html and this https://knowledge.safe.com/questions/39002/connection-issues-to-ms-sql.html Our settings in SQL Server: 'Named Pipes' is Disabled and 'TCP/IP' is Enabled. We can enable 'Named Pipes', but the server service then needs a restart (we don't want to restart

We have a unique number 0 and 00 to identify paying customer.I set (0 and 00) in the AttributeFilter but both values end up on either 0 or 00 depending on wich one in the list comes first.What am i missing here? or should i set up a tester instead for each number or text value? /Tim

Hello! I am using GeometryReplacer to convert a CSV file with a column containing WKT geometry. The column in question has the name "GEOMETRI, LINJE" and contains a linestring. When using GeometryReplacer, the result is a point with a point that seems to be the centre point of the coordinates of the linestring. As an example, the string LINESTRING (280696.375713613 6653063.17617913, 280698.536236071 6653059.93539544, 280707.427616957 6653067.91270913, 280704.353027305 6653070.5718137, 280696.12642256 6653063.17617913) converts to a point with coordinates 280701.671, 6653065.356, neither of which appears in the original linestring string. The coordinate system used is ETRS89.UTM-33N, which I set using a CoordinateSystemSetter before the GeometryReplacer. All of the LINESTRING () WKT-geometries become points. Does anyone have any insight as to why this happens and what I can do to make sure that GeometryReplacer produces the expected linestring instead of a point? Thanks!

 IMX Writer: Detected in invalid table names 'RoofSurface'. This writer expects only specific table names. Please add a new IMX writer to see the valid table names I guess it has something to do with the original tables from my citygml. but how to tackle this issue? 

I would like to combine lines on the attributes in column A OR B OR C and so on. The "combine on attributes" is an AND condition. What would be the cleanest workaround to achieve this?

When I run the tool the "Band 0" values are staying the same after the reprojection transformer is run, any tips to get the new values for "Band 0"?

Hello,After migrating to FME 2022.2 (desktop and server), I get errors on each workspace that uses Oracle Spatial FeatureReader with a spatial filter:I tried these workspaces on FME 2022.0 and everything works fine...I don't really feel like reinstalling another version of FME Server, so any solutions/workarounds are welcome :)(Using spatial SQL queries instead of FeatureReader is not an option)

I have a workbench that uses the FileCopy writer to move and rename an uploaded excel sheet, this works well when testing through desktop but when run via FME Server (the file is uploaded into a parameter) the following Warning is thrown and the file doesn't get moved; 2022-12-8 13:48:54 | File Copy Writer: Ignoring the destination filename 'DummyFile.xlsx' because the source dataset '""C:\\ProgramData\\Safe Software\\FME Server\\resources\\system\\temp\\upload\\Data Updates\\Geo-CustomerServices-TradeEffluentImportToSQL.fmw\\dbryant\\DummyFile.xlsx""' was not a file. Destination file names are only used when the source dataset is a file Is this a known limitation of FileCopy? I could use a SystemCaller and/or Python to get the same result but equally feel that this should work.

I see how I can create a geometry using a creator where I can specify the geometry parameters. For example, creating an Clothoid by specifying Start X, Start Y, Direction etc. But these are all values that must be hand entered. How can pass these values into an "inline" Creator to set the geometries accordingly? I see 2DArcReplacer etc but not one for Clothoids. Is there a GeometryReplacer of sorts that would let you specify the type of geometry desired and which incoming attributes to assign to the relevant Geometry Parameters?

I need to convert a csv file into a shapefile in a .Net 6 windows application. I am looking for some assemblies or source code that does to use in the application. Does FSE provide such assemblies or have source code that can use the does this?

How to convert ArcGIS Online Quick Capture Latitude and Longitude coordinates to a projected X and Y coordinates?

Hi, This question is linked to a previous question I posted on the community, about the number accuracy of the Esri ASCII GRID writer of FME. Please see that question for more details and screenshot, but a quick recap of it; when I created a dummy raster with Real32 interpretation, in which an original pixel value would be '0.0250313',the rounded pixel value would become '0.025',but the Esri GRID File seems to convert to Real64 interpretation and stores the value as '0.02503128908574581',whereas I would like the rounded value '0.025' to be written to the file. I noticed that this could save up to 50% in the file size. I suppose that this item is related to the Floating Point Precision and String Formatting in FME. Now I have been investigating some options for an efficient workaround to this question. I.e. to be able to create Esri ASCII Grid files that don't write out pixel values with 16 decimal values. I came up with two methods, but I think they

In the Translation Log, it shows ArcMap 10.8.1, how do I change that to Pro 3.0.3, basically how do I move off ArcMap.

I'm trying to create a count that changes whenever it sees an empty row in a dataset. For example, I have the first 3 columns and would like to create a column similar to Test2 (see image below) that has a new count whenever there is an empty value in Test in the preceding row. Any ideas would be greatly appreciated!

I recently upgraded my FME Server (to 2020.2.4) and the unwanted file hierarchy for FileCopy output datasets in Data Download Zip files have returned! I now have an additional folder (called FILECOPY_1) in the output zip from a Data Download Service on Server. I've updated the Writers in Desktop (2020.2.4), but the edit functionality (Publish --> Edit Register Services --> More) seems to do nothing for the structure of the zip file for FileCopy outputs anymore after publishing (the old way is outlined here: https://community.safe.com/s/question/0D54Q000080hM9QSAU/how-can-i-change-the-folder-structure-returned-in-the-zip-file-from-fme-servers-data-download-service). I this a known bug, and is there a fix please? Many thanks!

simple question: Why does reading this netcdf fail with any (combination of)setting(s)? It works fine in Qgis https://www.ncei.noaa.gov/data/international-comprehensive-ocean-atmosphere/v3/archive/nrt/ICOADS_R3.0.0_1750-07.nc

I have put all of my parameters into the Private panel in the Parameters Manager, but they still display in FME Server 2021.1 unless I uncheck Published. What is the value of having to do both?

Here is the background. Esri uses subtype/domain objects in its GDB implementation instead of native RDBMS' relational tables with foreign key constraints. The result is often "nu-disciplined" databases from the RDBMS standpoint. I hope to create relational tables to protect data assets by extracting all the domains in our GDB.

Is there a way to read and use AutoCAD's SHX Fonts with FME? I need to be able to read in a DWG, determine the font used and recreate a map, currently trying to use the PDF Writer, using the original AutoCAD SHX font.Using the PDFStyler I can choose / define a Windows Font but can't figure out if and how the AutoCAD Fonts can be defined.  

I currently have multiple processes set up where predefined FGDBs can be loaded into Oracle using FME (server). I need to extend this so I can load ANY FGDB and I am struggling to find a way to do this dynamically. Ideally I would split out a uniqueID and Geom to load direct into Oracle and split out the tabular data into a CSV as I have a dynamic process set up for non-spatial data already. This way I can easily join the spatial and non-spatial programmatically in Oracle. Thanks

Hello FME community, I'm trying to delete or merge some layers of DWG files and write them back as DWG files. during the transformation I lose my blockreference and the blockreference is written as a polyline. I would like to know how the blockreference can be written as a block reference. the first picture refers to properties in the source and second shows properties after transformation.   

Hi All, I'm trying to identify whether a coordinate system in DWG is set to a User Coordinate System (UCS) or a World Coordinate System (WCS). Essentially want to query this in a tester transformer. Thanks in advance for any help!

I created a Service account called svc_fme, and it has write access to a folder. The service account is what is setup for running the FME Server components except DB. Thinking same logic as Esri Service access for FME Service. I have an ETL on FME Server that is not writing to the desired location. How do I set this up?

I am getting following error while executing the workspace on FME server. However, workspace is working fine on the Desktop. Please suggest.The error number from ArcObjects is: '-2147221230'. The error message from ArcObjects is: {}

I am trying to setup SSO/SAML on FME server. We already have https enabled and I am able to login using the AD credentials.We are following below documentation and for FME server setting, it says to go to Authentication services which I am unable to locate under user management. Is there anything that I am missing or anything that I have to enable ? https://docs.safe.com/fme/html/FME_Server_Documentation/WebUI/SAML-Configuration.htm Thanks