Using readers and writers to extract and load data.
Recently active
Hi. I need to convert V7 dgn file to work in V8 Microstation. I don't know how to do it. Im new to the FME. If someone could give me instructions on what buttons to push? :D
I receive an empty shapefile from our client and if I don't add any features, have to rename it.Since FME is feature based it won't write to a new shapefile if empty. The shapefile can also not contain a null feature so the NoFeatureTester or a null Creator is not an option.I'm currently on FME version 2019.2.1 How can I write empty shapefiles?
Hi! I'm trying to get the effing per-cell formatting to work in Excel but I'm not succeeding. My excel output doesn't come out with a yellow background. Please check my screen dumps and help me figure out why!
I am setting up a brand new installation of FME Server 2021.2.0.1 and I can't authorize any ArcGIS Online connections. It gives FME Server OAuth Service Failed. It doesn't matter which user I try to authenticate. This works in my other 2019.1 server, so I know these connections should work.
Hi everyone, I have a workbench that downloads a extent from a bigger database by Esri (by using a Esri feature server reader) and writes it to a file Geodatabase that we host on a server. Our arcGIS users use a layerfile in ArcGIS pro that uses the file GDB as source. I use windows task scheduler to run a batch script that starts the FME workbench every month (at mightnight, when no users are logged in). For some reason the file geodb still has locks active during that time, which cause the overwrite database function in the FME writer to fail. Is there a way to update the file GDB while the locks are active, or a other way this problem can be solved?
Hi, does anyone have any experience with the following error: - "Unable to connect to the File Geodatabase at '------'. Make sure the correct filename was specified, and that the geodatabase wasn't saved with a newer version of ArcGIS than the one installed locally. The error number from ArcObjects is: '-2147220893'. The error message from ArcObjects is: {}A fatal error has occurred. Check the logfile above for details" We have recently just started receiving the error on all workbenches that are reading feature classes from a .fgdb. The error is inconsistent between what database it happens on and when (i.e. re-running workbench multiple times in a row, it may read a few times without issue). We have alot of automated processes that should run in the background that are now failing.We are using FME 2018.1 via ArcGIS Pro Data Interoperability and have recently had a company wide roll out of windows 10 laptops.I believe the issue is somehow related to the
Hi, newish user here trying to figure out dwg to shp conversions. I've got the attached DWG file that has 31 feature types that I need to convert to SHP. But when I run the attached workbench it's projected to 0,0 what am I doing wrong? Thanks
FME 2020: How to label the output in the graphic part based on particular field? For example, in the screenshot below, I wanted to label the polygon based on the “parcelnumber” field but couldn’t figure out how to perform this
I want to create dwg's with object data with FME. The problem I run into is that the names for the layers and the object data table end up being the same, which makes the data hard to use in Autocad Map 3D. I have attached an example workspace to illustrate my problem. What I would like to achieve in this setup would be for the output file to be identical to the input. For this example I start with a dwg with one object data table Vegetation and two layers, Bos_groen and Ruw gras_groen. I read this, do nothing else, and write it to a new dwg. My end result has both polygons in the right respective layer, but their attributes in two different object data tables, with the names from the layer. My problem is illustrated in two screenshots. In my sourcefile Object data table and and layer are distinct values, Vegetation and Ruw gras_groen respectively.In my output the layer and the names of the object data table are both Ruw gras_groen, the other polygon has Bos_groen for both, nothin
FME 2020: How to filter dwg file based on hatches and Areas (polylines)? I couldn’t figure out how to filter dwg file based on hatches and Areas (polylines).
FME 2020: How to filter dwg file based on lines and polylines? I couldn’t figure out how to filter dwg file based on lines and polylines
12d has the ability to close polygon without making the last vertex sit on top of the first vertex. ( ie a square\\rectangular polygon has 4 vertices and 3 segments)When the last segment of this closed polygon has a radius, a 12dxml file when viewed in data inspector or workbench, does not show the last segment as curved. When compared against a polygon that the last vertex sits on the first vertex (ie 5 vertices, 4 segment polygon) then FME displays correctly. When I look at the properties of both strings in inspector, the two different properties are No. of vertices which is 5 and the field under IFME Polygon called Linear Boundary is yes for the scenario of not displaying the curve on the last segment. For the polygon that does display correctly, these two fields are 10 and No. Would appreciate anyone with any 12d knowledge to assist or what the linear Boundary field meansNote uploader wont accept 12dxml file format so you will need to rename the attached to polygons.12dxml to vie
Hello,I'm attempting to write a dataset to AGOL. This dataset comes from another system with ~25,000 records. So far I've been reading this dataset and processing it with my workbench without error for a some time now. Last week it began to fail with the error:"ArcGIS Online Feature Service Writer: Encountered an unexpected error. The error code from the server was '400' and the message was: ''. Details: 'Field WORKDESC has invalid html content.'"The datset has a field WORKDESC that contains freeform text entry where staff describe the details of a building permit. I suspect from my troubleshooting that somewhere along the line a strange character has been entered that the AGOL writer is interpretting as html content.I'm looking for some tips/suggestions as to however to 'clean' this field so that this error doesn't hurl my workbench. However, I don't really want to manually dig through the dataset to find the specific chara
I have created a "i3s_terrain_mesh" out of a DEM. Following the description on this page, the terrain mesh would replace the existing terrain in the scene viewer. In case we talk about the ESRI ArcGIS Portal/Online Web Scene Viewer, how would that work? As far as I understood, only elevation layers can take over this job when being added to the scene. Even turning an input into an "i3s_terrain_mesh", we deal with an SLPK, that has to be shared and published on the Portal.In a web scene, such an added SLPK is not interpreted as a layer that can be added to the "Ground" - replacing the default terrain 3d elevation coming from ESRI. Have you any experiences with this?
I am trying to get the location curve property for walls using FME and Revit Reader. To be clear, this is not the geometry of the wall, but the line Revit uses to create the wall. From what I can tell, the property is not in the actual file itself, but the result of a Revit API method: wall.Location as LocationCurve I use Python scripts in Dynamo, but this is unknown territory for me. Is it possible to install Revit API modules and do something like this?import fmeimport fmeobjectsfrom Autodesk.Revit.DB import * def locLine(feature): line = feature.Location.Curve if isinstance(line, fmeobjects.FMELine): cLine = line.getAsLine()Any insight is appreciated. For now, I will get the lines in Dynamo, export to Excel, and then merge in FME. Not very elegant! Thanks,@lorenrouth
I have a Salesforce custom object with 2 master-detail fields that both have read/write permissions. When I attempt to write to this object, I receive the "REQUIRED_FIELD_MISSING:Required fields are missing:" error. The two fields referenced are the 2 master-detail fields. The fields and the data are present when the write occurs but for some reason I receive this error. Any ideas?
I Have a building with itiff textured polygons. I want to convert that file in to citygml lod 2 format. Anyone please guide me. I am new to this FME.
I am receiving a vaige AreObjects error '-2147216072'. That said, it appears to be different than the other questions posted here (such as this, this, and this). The actual error I'm receiving is "An error occurred while flushing the cursor for the table/feature class 'my_table_here'. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error [[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 5 (""): The supplied value is not a valid instance of data type float. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision.]}"The workflow does write some data, up to 32,000 records into an SDE table using the ArcSDE Geodb writer (there should be 33,001). It will also run without error if I remove a portion of
When using the Mongo3 reader, I have real slow connection via FME Desktop, while these connections in Python or other Mongo clients are really quick. Some examples cases where it is extremely slow:creating a Mongo connection + viewing all the available collectionspicking a collection + displaying it on the Workbenchrunning the FMW file from Workbench, even with filterAll these step can take up to 6min each, for a simple connection. Is there any way to make it faster, like ignoring all the attributes and just use raw JSON (and nothing else)? Listing all the collections from a Mongo server takes a few milliseconds in Python...I use FME Desktop 2019.2.1.0 (20191202 - Build 19813 - WIN64)Mongo version is 4.0.13
I used to convert to/from Norwegian standard format SOSI, but since my latest FME update SOSI seems to have disappeared, I'm left with SOSI/GML which (I think) is not the format I need. What has happened here?
I have created a workspace that converts shapefiles (.shp) into Cesium 3D Tiles using the Cesium3DTiles writer. It works pretty well but I'm wondering if I can control how my geometries are broken up into tiles. I've played around with the area and volume calculator to set the cesium_priority property to control when tiles should appear at different zoom levels but I see tiles that span the whole US for instance and I want to sub divide the tile based on a grid or maybe an attribute. Is something like that possible? This picture shows a volume that spans the US that may have some geometries on the west and east coast. Instead I may want a tile for the west coast and another tile for east coast at this zoom level. I can provide my workspace if needed. Thanks!
Hi,I need help by creating ACAD block in FME. There are more DWG files with buildings, one building per file, filename=BuildingID. I need to merge them into one DWG file, where each building should result into one block with block_name=BuildingID. I can simulate it in ACAD, but I need to do it for hundreds tiles, with hundreds buildings each.Attached are two buildings DWG (5296285, 5356200) and result file with blocks (5300_340000). Thank you very much for any help!
For example, I have a CreateNode Field in one table, I have to filter out Null and populate these null values Using the second table that has the same field name. the output is not something It should be. I have attached a screenshot of my workspace. Any help would be greatly appreciated!
Hello, Can you tell me if FME is compatible with SAP R / 3? Is there a connector for this system in FME? Did anyone used this? Thank you! Nicu