General

I’m stuck with something I thought should be straightforward. I need to create backup copies of existing feature classes hosted within an SDE. Backup copies will need going into a Feature Dataset ‘ss’ that sits inside the same SDE hosting the feature classes. FC1 will have fields ‘Field1’, ‘Field2’ and ‘Field3’, and FC2 will have fields ‘Field4’, ‘Field5’ and ‘Field6’. I can do this easy if I read and write these two feature classes as Individual Feature Types, however I was hoping for a more elegant way to do this with Single Merger Feature Types and a Dynamic Writer that would fan out the individual feature classes honouring their schemas. When I try this second approach, resulting FC1 backup copy will have its fields ‘Field1’, ‘Field2’ and ‘Field3’, but also ‘Field4’, ‘Field5’ and ‘Field6’ that have been transferred from FC2’s schema. Same goes for FC2 which will also have FC1’s fields on it. What am I doing wrong?

Have to execute a procedure in FME, doing that but its giving an error in SQL executor 'ORA-00900 - invalid SQL statement' however working fine in Oracle Toad, any leads how to do in FME?

I have dynamically reprojected tables from MSSQL database and then written into another MSSQL database) with same table schema. I can see the new tables exist in the SQL server. Also When I am checking the tables on FME workspace by using CoordinateSystemExtractor, I can see the tables are reprojected. But the data is not displayed on QGIS, though attribute table can be seen. Also in QGIS layer property option, the CRS system is still showing the old one. Can anyone kindly tell me what could be the likely reason/s?

I am trying to generate CESIUM terrain files to be able to serve files locally offline. I am currently testing with data from maps Canadas HRDEM (https://open.canada.ca/data/en/dataset/957782bf-847c-4644-a757-e383c0057995) they provide a index file and directory of GeoTiff files. I need to convert this to CESIUM terrain tiles. Can FME do this or does it only do visualization for things "on" the terrain such as buildings etc.

I am updating multiple Workspaces to the newest version of FME Workbench 2022.1. Updating the transformers has proceeded well except for the Clipper transformer. I found that v14 takes substantially longer to process the data than v13 in all workspaces tested. In one example, v13 took 22 seconds and v14 was stopped after 10 minutes. Any suggestions? One item noted, when using v13 all 16,076 values are received from the PointOnArea transformer before Clipper starts processing; whereas, v14 appears to process one at a timev13v14 Update Settings

i am trying to get the data from https://www.nhc.noaa.gov/gis/ website which working fine but problem is that if on the website there is no current storm then in over ARCgis data also delete I m sharing the was can you check for me as I am new

I am just looking into the idea of using desktop instead of a 32-bit engine and if someone has experience with this, good or bad.

Hi, I have a question as I'd like to use a tool based on ArcGIS Pro: Integrate (Data Management) with FME environment but can't find it - is this tool available with FME? Thank you.

Hi,I have two line shape files. File 1 is the duct layer and file 2 is cable layer. When cable layer is drawn on duct, cable vertices must be coincident ( snap) to duct vertices. How to find the cable vertices that are not coincident with duct? Thank you for the help

Is it possible to sort by multiple columns with the Inspector? Don't need the Sorter. I'm looking to take a quick peek at the output in a few different way, not push final output to a writer. Using FME 2020.1.2.1 (b20624).

I am using 'AGOL Feature service reader' to fetch data from Survey123 survey results feature service. When I export to excel using Survey123 the labels are being shown as headings, but while writing using FME displays the attribute names instead of Label. Is there any way by which I can export with Labels as headers using FME?

Is there a possibility to iterate trough attribute values in a shapefile. I want to pass each value trough a WFS query.

I am creating texture atlas (using FME 2022) from cityGML files at the time of tileset (cesiumjs) creation. But I am not able to find the texture atlas. I want to know where it gets stored?

Hi,I was trying to use below python code in FME. But it is throwing an error i.e. '<TypeError>: bufsize must be an integer'. Can anyone help me on this to get it resolved? I will provide the complete script on request if required.Thanks in advance#Code used in python callerarg1 = ['pg_dump', '-t', 'schema1_table1', 'server1_conn','|','psql', 'local_conn']proc = subprocess.Popen(arg1,cwd=directory, shell=True,stdin=PIPE) #where #server1_conn = "host=<server_host> port=<server_port> dbname=<server_db> user=<server_user> password=<server_pwd>"#directory = C:\Program Files\PostgreSQL\14\bin 

Currently imported a 'subledger' text string via Attribute Manager. Need to have leading zeros added to the left so it is always 8 characters. For example, '1046' should be '00001046'. Please advise which Transformer should I use. Also another 'subledger type' text sting is dependent on the above 'subledger' field. If no subledger, it shows blank. If something in the subledger, then 'W' should show under 'subledger type'. Please advise how to achieve. Thanks.

I am reading non pyramid tiff files in CRS EPSG:3844 and I am trying to write to Geopackage Tiles with pyramids using Incoming Feature Tiling Scheme to keep the original CRS.Using RasterPyramider the output is one raster for each pyramid level, that translates to many tables in Geopackage Tiles and it defeats the purpose.How should I aggregate/combine the level rasters to write a consistent GPKG file (directly)?

Attached workspace created using workflow option "Single Merged Feature Type" for Personal Geodb Reader.  Steps to experience the issue.Execute the enclosed workspace in FME Desktop 2022.1View the cached features of reader (Click on the tiny magnifier icon on the reader)Even though FEATURE_TYPES published parameter was set to Highways, data attributes of Highways feature class were not shown in the table under Visual Preview panel.You may check the issue by passing a different Personal Geodb and Feature type(s)

How to rectify this error?

Hello I want to automatically add a tree to a class I want in classified point cloud data, how can I do that? Can you write me the order of the FME conversions, thank you very much in advance for your valuable information.

Hi,I have a MicroStation file (v8) with a table in it that I need to extract to csv. Can someone please advise? I am using FME2020.1 and I have attached the dgn.Many thanks,Chris 

I've encountered this error a few times and can't figure out what exactly is going on. 2022-08-16 08:34:06| 51.4| 0.0|ERROR |Esri Geodatabase Writer: Feature Type Definition 'Output' was requested, but not defined. Please visit https://www.safe.com/support2022-08-16 08:34:06| 51.4| 0.0|ERROR |BADNEWS: GEODATABASE_SDE writer: A fatal er I have an SDE writer after a reader that is reading a PNG. From what I understand it might do with the fme_feature_type being a PNGRaster but if i change or remove it I get the same error.

Hello, I have a (excel)list of points [x,y,z] which was recorded along a cable. The recording was done contiguously both upwards and downwards. Unfortunately without marking the reversal points. The starting point of the cable is the first point of the recording in the list. If I now generate a line from the point list using FME, I get a 3D line which runs both upwards and downwards. My goal is to split this line into two lines, but I haven't found a transformer that will give me the inversion point. My idea for determining the reversal point would be to determine the reversal point based on the distance to the starting point. The reversal point would then be the point from the point list with the greatest distance to the first point in the point list. How could I solve this elegantly in FME?Thanks a lot for your support

I can reproject CSAR point clouds but I can not write them to the CSAR point cloud format, only to ASCII XYZ.