Using readers and writers to extract and load data.
Recently active
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
Hi All,I am trying to convert ERSI shapefile(LOD0) to Cesium 3D Tiles using FME 2017 Writer. Here is my workspace :When i use Cesium to visualize it, bounding volume of tile is skew like this:I use Cesium's Template code to visualize(change url to my tileset path) so i guess my code is fine.Could anyone help me on this?Thank you,
We have an ArcGIS Online hosted feature service that has ArcGIS attachments. Using FME, I have no problem downloading the feature service to a feature class in an ESRI file geodatabase, including the attachments. Now our users edited the downloaded feature class, I will need to upload the feature class to ArcGIS Online to overwrite the content of the previous hosted data. Overwriting the feature data works fine, but I can't find a way to bring along the attachments. I am trying to do a truncate/insert operation. Any idea how to do this correctly?
Hello!I have a layer in AGOL named "park furniture".I want to make a backup via FME to a FGDB named the same.Im wondering if there is any example of a workspace were i can see wich transformers i need to use if i want to make a backup from a feature layer in AGOL to a FGDB. I dont have any schema in the FGDB but want to use the one from AGOL and also transfer the domains and attachments straight into the FGDB. Or is it better to make a copy in Arcgis Pro first and the keep overwrite/update the FGDB. /Tim
Hello we have an AutoCAD drawing that contains some 'wipe out' features i.e. polygons that sit above other data and hide the information that is underneath it. All of the wipe outs have the 'Display but not plot' setting in AutoCAD but for some reason they are not being read into FME.I have the 'Ignore Frozen Layers' and 'Ignore Hidden Layers' settings in the reader set to No but that does not seem to make a difference. The snapshot is an example of where the wipe out is used in the sample drawing Does anyone have any advice on how to read these layers into FME as I need to replicate what AutoCAD does when creating a TIFF / PDF output.
Hi folks, For some unresolved reason, our ArcGIS Server 10.7.1 crashes intermittently. Like randomly after a week or a few weeks or month or two, it just crashes. When I check the Server logs for what appears around the crash timestamp, there are a number of SEVERE errors that follow the pattern of "Error performing query operation Wait time of the request to the service <SERVICE> has expired." It's a specific set of services, enterprise feature classes as their source, usually the same culprits appear in these error messages so I thought it might be associated with some web apps that may be experiencing strangely heavy use at sometimes outside of main business hours. I've already had Esri Tech Support investigate this but they couldn't figure out what's causing the issue either. But I recently changed the source of one of these services to point to a shapefile instead. At the next Server crash, this layer did not have its name show up among the e
Is it possible to transform .gdb files into .ifc files. If yes, what transformers do you use? Sincerely Thomas
This is an error I get when I try to refresh an existing layer in a feature service on ArcGIS Online. ArcGIS Online Feature Service Writer: 'addResults' error for a feature in 'Environmental_Inspections'. The error code from the server was '1000' and the message was: 'String or binary data would be truncated.The statement has been terminated.'Has anyone else run into this?