FME Form

Hi, I have looked into several posts here but not really found similar results. I tried to write my DWG into a Map 3D dwg to for example write attributes like creation instance into my DWG which worked really well: Writing attributes to AutoCAD User Properties (safe.com) However, I want to be able to add / edit attributes for my features that are readable by Bentley Microstation . Every result I found is DGN but the format must be DWG. Is there any way to write attributes to a DWG which is readable in microstation? Result above has no attributes or properties so doesn't work. Originally the results I don't want in block but that rule can be bent so every single features can be a block if that is the only way. When I inspect my DWG in Microstation it doesnt have my written attributes, I can only see them in AutoCAD. I want similar like example: In my results with id and count doesnt exist in microstation and only geometry information can be found in properties. Lets say i have 3

Hi there, I'm sorry if I have overlooked the answer to a similar question in this forum. I could not find such a question... When executing the FME workflow from the command line, there is a entry for every 500 features that the reader has processed. With some large data to process, this can amount to many lines in the command prompt window. I cannot scroll up infinitely in this window and it's also not easy to scroll these vast amount of lines if you need to see some other logged output before the FME was started.  Is there a way to configure the logging output so that it will not produce this vast amount of lines? A simple solution could be specifying the logging interval (e.g. increase 500 to 5000) .As an ideal scenario, the Reader-logging is by default using only one line in the CMD window and is always overwriting itself until the next process in the FME workbench starts when normal logging is to resume with starting on a new line every time. 

Recently started using FME (2020.2.3.0 now, but will switch soon to 2022) and was struggling with giving parameters as input for "Feature Types to Read" for "FeatureReader". Input:TGT_SCHEMA = "DATALAKE"TGT_TABLE="GEODATA"$(TGT_SCHEMA).$(TGT_TABLE) is given as input to "Feature Types to Read". Expected behaviour:I want FeatureReader to read the schema and table from parameters to become '"DATALAKE"."GEODATA"'. Actual behaviour:Snowflake Non-Spatial Reader: Error reading schema for table '$(TGT_SCHEMA).$(TGT_TABLE)'. Error: net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error:Schema 'DATALAKE."$(TGT_SCHEMA)"' does not exist or not authorized. We are authorized and problem seems that FME can't parse TGT_SCHEMA correctly while it is defined. It can read $(TGT_TABLE) from parameters though? Workaround:Currently we have a workaround already to make variables from par

I have connected to an API to download data to create an automatic process. The data covers the whole UK so comes group by region in folders, but I can not figure out how to expand these folder to have the remaining SHP files inside for clipping and symbolising etc. Im sure there is a tool for this I am probbaly unaware off. (See image)

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?

Hi Altruist, I would like to bulk reproject on a number of database table in SQL spatial server and write (update) the tables into same database after the reprojection. All tables are in same CRS currently but obviously schema are different. Can anyone kindly suggest a tutorial/workspace of same sort?  best regards and thanks in advance.

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?

hi fellas,I'm trying to translate a dgn file, but it fails to load correctly. when i open the file with Bentley Microstation Connect edition I can see the design, but when i try to open it with fme data inspector it fails to load the design (it loads all the features but they are not shown graphically).attached are pictures to illustrate what I get when trying to open the design with Bentley Connect, and with FME Data Inspector (using v7, v8 and xfm v8 readers).can you help me with the issue? best regards,Sharbel

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 have a file that has been converted from .ifc format to citygml format and I want to convert it to a shapefile. There is a problem with the coordinates and dimensions of the building. If the modeling is done, as shown in the following figure...Suggest me a set of solutions, please.?

Hello,I am trying to set up a simple flow to automatically copy new or changed data from multiple excel sheets into the master Excel sheet that lot of PowerBi dashboards feed from. The flow is simple as follows:-Read from sheets -> Attribute Manager (rename to match main excel) -> Change Detector -> Attribute Creator (fme_db_operation (UPDATE)) -> NullAttributeMapper -> Writer. Problem is at the last stage, the writer is not updating the main sheet and could not find the correct setting messing around with the writer parameters. Any help would be appreciated, I have attached the screenshots below.

In the conversion process of using the same educational model note that using the system Epsg4326 The examination is correct When adding the converter as it is in the lesson, converting from the canvas and using the reader and writer’s coordinate syste

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.

I have a dataset which contain null/non-null values in a particular column, I have to segregate it in the way that if any null value exists, all null/non-null values will go in 1 direction else only the non-null values will go in 2 direction (port), help?

Has safe adopted the standard for related tables in geopackage (writing/reading)?If so, how do I go about it?

Good morning,I’m trying to transfer data from ESRI to PostGis.Unfortunately, I encounter the following error:Error was 'ERROR: value too long for type character varying(50)I understand that the created field is too short but I can’t change it...Thank you for your help.

I'm having trouble pivoting a table. Here is what I am trying to accomplish: Is the AttributePivoter the correct transformer to use? Thanks in advance, M

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.

Good day, I would like to ask. I am currently solving the tracks in the WS in the attachment. I ran into a data "loss" issue happening on featureMerger. Points from the polygon of interest go to the Requestor's input, and points with the same ID as the requestor's input go to the Supplier's input - these points are part of the RouteSegment. Now to my problem. I believe that I don't have all the data on the FeatureMerger output because I only have each point once on the requestor input, however, I can have a point multiple times on the suplier input and it can be part of different routeSegments. At the moment when a point at the requestor input is "reserved" by the first point of the same ID on the supplier, at that moment the rest of the data goes to the Rejected output. I can think of creating X featuremergers, where I would send the rejected data to the input of the supplier and the original polygon_selection_topsky source to the requestor. But I f

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).