Using readers and writers to extract and load data.
Recently active
Hi,I'm hoping someone can help me. Is there a way of converting dgn to dwg (including references) or are there issues? I've been searching online and can't seem to find a simple way. I've managed to get the basics but can't seem to get the reference files to come through. Am I missing something? Is there a way to bind them as they go into the DWG?Apologies, I don't use FME enough to remember all the transformers.
I have a 3D model with buildings originally from las data. The model is in polyface .dwg format and for performance improvements I want to split the model into separate buildings. How would I go about something like this? Is there some way of splitting this data using a 2D grid? If so, how do I handle buildings that are being cut into two? Other suggestions?
Can I use a Azure SQL Database (PaaS) as FME Server system database similar to how I use a on-premise Microsoft SQL Server Database?
Working with 2 tables and , my goal is to be able to get a final table that looks like the following table .As observed in Ctable, it is a joined table of Atable and Btable, the values from the Btable are empty except for the depth field. My goal is that for each in Btable.xlsx, the needed values will be sccraped from the nearest value in range to it from the Atable.xlsx e.g. (Depth100 in Btable will get the following values NS(ft), EW(ft) and Date from Depth 206 of Atable, since 206 is closer to 100 than any other numeric values in Atable, 500 depth in Btable will get it values from 492 depth of Atable and this will occur for every depth in the Btable of depth values.Suggestions are highly appreciated on how to get this to work in FME.
I have some data I need to extract some text from, it looks like this: ABC1D, 520 [78580]|XD, 2-6 [DEAD]Info in the brackets can also look like [211 X] and [95338 CO]What I'm trying to do it drop everything except for what is in the brackets, and then filter out/ignore DEAD, and use the number to join(or query, I'm not sure which would be best yet) to another table; or in the case of 211 X match to a different table, or 95338 CO would trigger the workbench to write to a table in SQL. But for now what I need is to get that number in the bracket out to use in FME. Thank you
I am am trying to convert a IFC-file into a CityGML-file. For inspiration I am relying heavily on the intermediate guide for BIM to gis. Now when I am trying to convert the IFCBeam entities into CityGML BuildingInstallation however the workbench crashes and I get the following error:Error running translationI have to the best of my knowledge not changed the writer in any way from the tutorial except for the output-file path and the projection system. Every other geometry I am using seems to convert nicely.I am unfortunatly not at liberty to share the data file. However I have copied the log into two files: Log 1 is the log where I have disabled the beam and the workspace will excecute Log 2 is the log of when IFCBeam is enabled. Which leads to the workbench crashing and I get the "Error running translation"-errorSo my questions are as follow:What does the error mean?How can I solve it?Thanks in advance :D
Hello.We are converting LandXML to 3D tiles and found that 3D tiles generated are not correct. The gltf meshes inside the b3dm files are empty, and we think that property should be populated. The geometry from the LandXML reader is GML dimension 3 geometry. The 3D tile writer is writing these geometries correctly for polygons.Is this a bug or an enhancement to the 3D tile writer?
I have 2234 las datasets covering around 2000 km². I want to reduce the amount of tiles by 1/8 thus increasing the area per tiles by 64.Which workflow could I use to merge neighbouring tiles without overlaps?
I'm new to FME and am trying to transform data in SQL Azure (spatial) and I do not want FME to convert my original types to CURVEPOLYGON. If the original was a MULTIPOLYGON, I want it to remain a MULTIPOLYGON. Even cleanup from the GeometryValidator seems to convert some geometries to a CURVEPOLYGON. How can I prevent this?
Hello, I have two shape files. One file contains more than 1400 points and another is smaller and it has 300 points that are dislocation of some of those 1400 points. I would need to calculate the differences between those points that are from shape no1 and same points that are present in shape no2. I taught that it can be done by NeighborFinder but I am not sure how. Any help and hints is more than welcome. Thank you in advance, MaliodPalube
When use generic reader on dataset on local disk works fine but when hit through URL and workbench gives back this "Generic Reader: No valid reader name specified, guessing reader name from dataset" and failed to load dataset
My goal is to provide a live updating KML file to be displayed in Google Earth for Chrome. My process is to create a KML file and then upload to Google Drive. The problem is that the new upload becomes a new file with a new location, so Google Earth doesn't know where the latest KML file is. Instead, I just want to update the existing file. Maybe GoogleDriveConnector doesn't have that functionality?One option would be to create a Google Drive API Python Script, but that doesn't seem very FME-ey. Thank you for your assistance.
My FME Server Dashboard is showing 3 months of logs, is there a way of only showing the last 2 months of logs?
I am trying to add an ArcGIS Server Feature Service reader to my workspace but get the following error when I click to get the Layer List: Python Exception <HTTPError>:401 Client Error: Unauthorized. I suspect the issue is a dash in the URL, which goes something like https://server-new/arcgis/rest/services/MyMapService/MapServer. I can't add any of the map services from this ArcGIS Server. However, we have several other ArcGIS Server environments and I don't get the error with any of them (and none have dashes in their names). Could the dash be the issue? (FME Desktop 2016.1 - build 16492)Thanks,Aaron
Hi All,I am comparing pdf's and getting the changes (Added/Deleted). It works fine. Only one scenario I was facing the issue with different scale pdf. (one is 640km scale and another one is 360km scale) this case I am not able to find the changes. Could anyone can help with this?
Hi,I´m using FeatureWriter to save my DWG file, but after executed my workspace, the DWG file show me all features duplicate. If I use the writer REALDWG work good, but I need to use FeatureWriter because it´s possible use autocad_source_filename for Template File.Why all features are duplicated in FeatureWriter? Thank´s
Hello.I'm trying to convert Land XML to 3D Tiles and running into some problems. I've tried both Cesium ION Connector and Cesium 3D tile writer, and an EsriReprojector to convert state plane coordinates to WGS 84 .Both complete the conversion without errors in FME. However, each method has some additional issues. Using the 3D Tile writer, I use a Land XML Reader, to EsriReprojector, and directly to 3D Tile writer (do not use ION connector). I cannot see the3D Tiles in Cesium. I do not get any errors in Cesium and Cesium viewer is successfully loading the tiles.I've also tried LandXML, to CityGML, to 3D Tile Writer, but that does not create a data Directry. Creates the tileset.json file though. Using the Cesium ION Connector, I followed this example:https://knowledge.safe.com/articles/81161/uploading-assets-to-cesium-ion.htmlI converted the Land XML to CityGML, then push that to the Cesium ION connector. When I go to the Cesium ION account assets, an error is displayed about
Hi all, After some investigation I found out my Excel reader file contains "line breaks" causing FME to write the content of a single Excel cell to multiple lines. Is there a way in FME to clean line breaks? Thanks, Ed
Generate Unique id in ArcGIS for Sql database.
Hi, I have a problem with writing components to a pointcloud (.csv) file. I made a workbench that merge 2 pointclouds using the pointcloudmerger. The pointclouds contains depth information of a river and represent 2 different periods. There is partly geographic overlap of the information so a made a merge that results in 3 outputs (merged based on X and Y, not merged and unreferenced), with a pointcloudCombiner the 3 outputs will be combined to 1 pointcloud and a pointcloud writer write the new created pointcloud (.csv). The problem is that in the new pointcloud only a few components (x, y, z and z_last) were stored. The original pointclouds contains a lot more components (depths from every measuring period and more) and I see these components in the data inspector but not in the new created pointcloud, is there a possibility to store the original components also in the new created pointcloud? The attached picture shows the output of the new created pointcloud and the data as shown in
i need export alias from a empty gdb. How i can not read any feature. how can i do to export it... thanks
I have exported some buidlings in format CityGML from a different software. The format contains no semantics or attributes and I therefore want to continue to work with the file in FME.When I view the file in Data Inspector I can see the buildings in 3D and I see that it is a IFMEBRepSolid. However when I try to work with the file in Workbench (e.g. transforming CityGML -> CityGML or try to run through GeometryValidator) I get message "There is no geometry in this view".And clues to what can be wrong? I have attached a sample of the 3D-buildings. I am using FME version 2016.1. Thank you!
Hi,I need to georeference a tiff image of a town in Illinois in WGS 1984 Web Mercator (auxillary sphere). The county's data is in NAD 1983 StatePlane Illinois East FIPS 1201 Feet. ArcMap's georeferencing tool is not able to accurately make the tiff image into a map and I think the difference in projection is the reason. So I have downloaded the map of the town from OpenStreetMap. I did a conversion in FME of the attributes I thought would be relevant: Here's the output for the highways attribute in Inspector with Inspector's Background Map:Here are the format attributes I am exposing:The geometry for every attribute is point. I do not understand why a boundary, highway or a route would be represented by a point. Highway has the most features and the other attributes' features all occupy the same spot as a highway feature. My goal is to get a map that in web mercator spheroid projection that I can use to georeference the tiff image. Is this possible? Thank you..
Hello.I'd like to convert LandXML to CityGML. I've tried a direct conversion, but the CityGML Feature Writer is writing geometries that are unsupported by Cesium.How can I extract the coordinates out of the LandXML and write a CityGML line string?
Hi.My model is complicated and I need to simplify it.If FME can do the job, I will be grateful.Thanks a lot.