Using readers and writers to extract and load data.
Recently active
Setting NoData and Adding Alpha Bands to Remove Black Borders (safe.com)I have already checked the method suggested in the above link, but didnt work.
Hi, I have a very simple point dataset which I am publishing to AGOL. It publishes fine first, but when trying to overwrite it, it gives the attached error (Fme_error1). The error is strange as it mentioned FMELine, even though it is reading in a point dataset and writing to geometry type "arcgisonline_point". I have tried changing the geometry type to multipoint but it still fails. Attached also is a picture of the workbench. Any ideas please?
Hi all, I have a geodatabase which contains point, relational table that has been created. At the moment I have to manually publish the feature layer via ArcGIS Pro. I have tried to see if I can create a workbench. I have got everything working in terms of writing to the feature service but the attachments unfortunately do not come through. Is there a limitation to the ArcGIS Portal Feature Service writer for this?
I am new to FME. I have no idea which translator should I use and how to set the workspace. I would be very grateful if anyone could give me an instruction.
Hi guys, I'm struggling with getting coordinate system information in my GEOJSON file. As mentioned in documentation I've tried to add attributes json_crs_type und json_crs_properties attributes to my features, but the GEOJSON writer ignores these attributes and passes my attributes on to "properties" section of every feature. { "type" : "Feature", "geometry" : { "type" : "Point", "coordinates" : [ 630533.503899999, 475902.4741000012 ] }, "properties" : { "json_crs_type" : "name", "json_crs_properties" : "LL84" } }, Could anylone tell me how to configure my features to get the crs information to my file like in example below?{ “type”:”Feature”, “crs”: { “type”: “name”, “properties”: { “name”: “urn:ogc:def:crs:OGC:1.3:CRS84” } }, “geometry”:{ “type”:”Point”, “coor
Hello, On our server running FME Desktop 2021, we have both ArcGIS Pro 2.8 and ArcGIS Desktop 10.8.1 with background geoprocessing installed. When trying to connect to our ESRI enterprise geodatabase with an SDE direct connect file to a branch versionned dataset (https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/overview-of-versioning-in-arcgis-pro.htm), I have the following error: "This version of the Geodatabase client is incompatible with the dataset and cannot open it.It could have failed to open because it contains ArcGIS Pro-only features, for example Arcade expressions. If this is the case, please install ArcGIS Pro or Pro-compatible ArcGIS Server and 64-bit FME". So it does not recognize that ArcGIS Pro is also available in addition to ArcMap.Is it an expected behavior ? Can I somehow tell FME to use the one of ArcGIS Pro ?I would like to ideally keep both ArcMap and ArcGIS Pro as I still have many python script written with arcpy from ArcMap.
I have been trying to add file names into my shapefile using FilenamePartExtractor but it is not working...creating only blank records. Does it work on Mac.??
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 AttributeTrimmer with no luck. The "N" before the GlobalID in the message is not present in the data, and I have no idea why it shows up here.
. 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