Data

Hi every one , i hope you re doing well .I am FatimaZahra , i am new to FME and I need some help . i am working on my graduation project which is developing a web app that can convert any ifc file to a citygml file . For that, someone was telling me to use FME Workbrench to generate a conversion model then getting its python code in order to insert it finally in the back-end of my web app. But honestly i have no idea about how can i proceed , if some one can help me please . Wish you a Good day .  

Hi, I am very new to FME so please bear with me while I try and explain what I am after. I have 215 projects that are pinned to an individual lat long. I have multiple geospatial data sources that contain various polygons of areas. I am using spatial filters to see if a project has intersected passed or failed in that filter. For the 215 Projects, I would like to create an KML with a token radius, say 500m that shows all of the other polygons around that project for that distance. If I combine all of the polygons into one KML centred on the project, the file is massive. I just want a KML reduced to the polygons that are within 500m of the project centred on the project.

What is the best management practice for setting attribute data types prior to writers, preferably at the reader? My specific issue de jour is an attribute (data e.g. 1023, 1034, 1002.1) that is reading in as real32 but indeed they need to be strings for my use case. A custom python transformer (type casting to strings) changes the values to strings '1023.0', '1034.0', '1002.1', due to real32 initial type, which won't work. I need strings '1023', '1034', '1002.1'.  Thanks for reading and any response is appreciated. TylerFME Desktop 2020.2

Hey guys, I've brought some data sources casted through a query (SQLexecutor transformer with a Creator) from a postgresql DB. Applied some transformations, such as AttributeManager, and generated some IDs by adding columns with counters. And the FeatureWriter wants to write everything casted as "Text" on Automatic Attribute Definition. Before I switch to "Manual" and cast everything (again), I just wanted to know if there's a way to have the FeatureWriter recognize the casting brought over from the query. Thanks and all the best!

Hi team, Are there any example workbenches suggested where it is possible to convert an ifc file to a geodatabase?

Is is possible to expose a shapefile's FID field?Shapefile readers do not list it and I can't find how to expose it.I need to store that field's value in a control field to keep track of the original features.

Hi,I imported a .DWG file with 2500 area features and want to assign them a colour to get, lets say, grey areas. I found this article and tried to apply this solution with the DWG styler in FME Desktop 2021. However, only my lines get the chosen colour, the areas remain the same without any colour. See attached my DWG Styler settings and a screenshot of my dataset. Any ideas? Current output:DWG Styler:

I have a photomesh that looks fine as obj or gltf and when I upload it to Cesium Ion through the webinterface.However, when I use the FME 3DTiles writer and upload that directly, the textures are not illuminated correctly.Is there anything I can do to get FME to output the photomesh correctly?

I am trying to update an ESRI SDE database with data from an ESRI GDB. The matching key between the two datasets is GlobalID. I use an ArcSDE writer and FME 2019.1.Settings in the Writer:When I try to update or delete data in the SDE, I get an error like the following:No rows matched UPDATE query to table/feature class 'XXX' where upper(GlobalID) = N'{C1BD1C13-4C4F-4C05-B3D8-F051F7B0A33F}'The GlobalIDs do exist in the SDE database! I have checked this multiple times.I can update data between two GDBs with the exact same data without problems, so I suspect there is something in the way GlobalIDs is read in GDB vs. SDE databases that do not match. I have tried adding/deleting the brackets {} on the input data using

. Hi,I have a server that is now in Azure which is connected only by Active Directory (Not SQL or Window Auth) .But this option is not available in FME 2018, Is there a work around or I am missing something? 

When using the IFC STEP/XML reader and writer as a just plain import > export, I've noticed that some IfcWallStandardCase are automatically converted to IfcTrapeziumProfileDef although the export object name is IfcWallStandardCase. Therefore some the IFC is broken as some object's can be displayed anymore in other software (xBIM Explorer). The issues occurred on a more complex workspace but I've tried it on the most simplified workspace, and there I do have the same issue.   Is this a bug or can i do something to fix this?

I'm writing and IFC file and I am writing objects into IfcProxy as there's no other fitting IFC Type at the moment. To better define the type, I am using the default ProxyType attribute. When I write ProxyType as attribute in FME, the IFC file breaks. I can see the information added in the file but apparently the syntax is wrong. The FME output looks like this:#674=IFCPROXY('b4I2bLVTRhe0Uu99isXLTw',#24,'Stone | CCC','Wastewater asset ID: cac582d1-373d-4ff8-bada-9727e139562a',$,#673,#672,.Sewer.,$);In this case ".Sewer." is the ProxyType value. Then I change the IFC file to contain this instead:#674=IFCPROXY('b4I2bLVTRhe0Uu99isXLTw',#24,'Stone | CCC','Wastewater asset ID: cac582d1-373d-4ff8-bada-9727e139562a',$,#673,#672,'Sewer',$);After this change (replacing . with ') the IFC file works and the ProxyType information can be read. Is this a bug or a mistake on my side?

Are FME Desktop and FME Server 2021.0.2 compatible with MSSQL Server 2019? Thanks for any reply!

Does anyone know how to how to create ESRI feature class and Attachment table from a ArcGIS Online Hosted feature service with attachments? I am trying to find the most efficient way to move a hosted feature layer with attachments to a Geodatabase to create a feature class with attachments.

Hi FME'ers! I seem to have a problem doing such a simple task as reading a feature service from ArcGIS Online.  I get the error: 2021-05-12 09:56:45| 1.7| 0.0|INFORM|ArcGIS Online Feature Service Reader: Getting feature results 0 to 999 of layer/table '<table name>'2021-05-12 09:56:53| 1.7| 0.0|ERROR |Python Exception <KeyError>: 'GlobalID'2021-05-12 09:56:53| 1.7| 0.0|ERROR |A fatal error has occurred. Check the logfile above for details Has anyone come across this before? Googling the error messsage gets me nowhere. The FS has export rights.  Im using fme 2020.2.4.0 (20210304 - Build 20825 - WIN64). Best regards,Anne Kathrine

Using the 'Autodesk AutoCAD DWG/DXF Reader/Writer' we're reading DWG files. Normally this works as expected, but sometimes the DWGs are corrupt. Instead of FME automatically recovering these DWGs, it would be better to fail immediately, as the recovered DWG might miss data, in our experience. I could not find any relevant options in the docs at https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/acad/acad.htm or a related question on these forums. Hopefully somebody can shed some light on this. Thank you in advance. 

I have a polygon that has 200 Zone and Bottom fields as Zone1, Zone2, Zone3,...., Zone200 and Bottom1, Bottom2, Bottom3,...., Bottom200 . I am trying to split the polygon to 200 units and create fields called "Zone" and "Bottom". Then populate these fields as Zone1/Bottom1 for unit 1, Zone2/Bottom2 for unit 2 and so on.I am at the writing the attribute stage. I was able to get the values but I couldn't set the values to the final attributes. I attached the workbench template.My current code looks like this:import fmeimport fmeobjects def processFeature(feature):        for i in range(1, 201):        zone = "Zone" + str(i)        bottom = "Bottom" + str(i)        zoneValue = feature.getAttribute(zone)        bottomValue = feature.getAttribute(bottom))        feature.setAttribute("Zone", zoneValue)        feature.setAttribute("Bottom", bottomValue) 

I'm doing a simple translation of a polygon dataset from MapInfo TAB to ESRI SHP. However, there's a date field in the MapInfo table (in the TAB file it looks like: DATE_ESTAB Date ;) showing the dates as I want them dd/MM/yyyy e.g. 26/11/1990. I'm trying to use the datetimeconverter, with the output format as %d/%m/%Y and input format as Autodetect FME and ISO. In the Writer I've set the attribute Type to Date and also set an expression @DateTimeFormat(@Value(DATE_ESTAB),<%d/%m/%Y>). But the features don't get this far as all features are output through the Rejected port of the transformer. I know I'm doing something wrong, but it looks like the MapInfo Date format isn't being recognised. When I try to use the FME Universal Translator in MapInfo, the dates come out by default as 1990-11-26 in the Shapefile, which is not what I want.I would be grateful for any help!Thanks

Hello,I'm looking to read all DWGs in a folder and convert them to feature classes inside one GDB, with the feature classes named as the DWG filenames. Currently, I've set my reader to read all DWGs in the folder and put as 'Single Merged Feature Type' so that it's a single input port. Then I followed this thread to use the FilenamePartExtractor transformer and set the fme_basename to the dwg file name. After it's run, it only outputs one feature class instead of multiple. See below for my workflow.   Please advise on where I'm goin

Hello,I am trying to merge features where it has a closed polyline and it's derived center point (using CenterpointReplacer) where they are separate attributes in each respective feature. I am using a _count attribute to join on, by FeatureMerger, but it does not pick up the polylines (Requestor), only the points (Supplier). The end result should be separate columns for polyline and point in the same feature.Any help is appreciated. Thanks, @larue​   

My overall goal is to convert a DGN model to json and OBJ files, which seems to work well for most primitive types of my model (like line segments, arcs, polygons etc.), but not for meshes. When I inspect the data in FME, the coordinates in IFMEmeshes seem to be off by a couple orders of magnitude, I cannot confirm whether the underlying geometry is still correct and it's just shifted or if the data is completely useless.I've tested it with both dgn V7 and V8, various parameter sets for the reader and multiple models and the problem remains the same in all cases. As far as I know I'm using the latest stable version of the software on Ubuntu, but according to my colleagues the bug can be reproduced on Windows machines as well.  In Microstation the model is correct and if I export it to an OBJ file I still get the correct geometry, but obviously that way I lose all the additional information from the model regarding the levels etc. If I e

Why does my AutoCad reader turn a single text object into 2 distinct rows if it contains a space character? I would assume that my reader would output just 1 row with autocad_text_string = '1-500 EE'.

I seem to hit a limit of 100,000 features ​when extracting an oracle spatial database of over 150,000 features into PostGIS.The workbench shows only 100,000 and in QGIS the feature count is also 100,000.How can I ensure all features are extracted?Thanks.​

I have the following situation. There are multiple excel files with multiple sheets in it. All sheets have the same template. So i use a dynamic FeatureReader to read all the data at ones. And update a single value based on another value in that sheet. There are two problems:1. Is that in cell B1 there is a 'project-name' that is different for every sheet in the dataset.In FME it is not possible to set it to always use the column name as Attribute name so it will use B1 value as column name. Now i have lots of column names that I need to expose and rename. But I don't know on forehand what they will be. A setting that FME will always use column name as attribute name is wanted here. 2. When writing the data I want just one cell to be updated. So I use a dynamic filename and a dynamic sheet name. Then I use the Column Name and xlsx_row_id to identify the cell to update.Then i get the error:Column name 'xlsx

Hello everyone, I want to change the name of the shape file to "asd.shp" rather than "Table1". I need a solution suggestion for this. Also, I don't want to see all the columns in the excel list in my shape file, I need some of them.