Using readers and writers to extract and load data.
Recently active
I'm curious to know if someone in the community has attempted to do transformation from xml to jsoninsights appreciated
Does anyone have a good way to extract the center point of a text string from DWG format?In the past I've had very good luck in DGN format using a Bounding Box and Center Point Replacer.However in these DWG's I have, the Bounding Box appears incorrect. In the image the problem is exaggerated, I believe Inspector is enlarging the texts compared tot he DWG size. The closest thing to the center point I've found is the upper right corner of the BB, but results are inconsistent, especially for text placed at an angle. Image shows text string, insertion point, BB calculated by Bounding Box Replacer, and the BB center.
I am new to fme and trying to read kml files from an http address, where the files may be spread out through different directories.I would like to recurse through the directories and find all the .kml files and write the placemarks out to a AGOL feature service.My issue is I do not know how to gather the .kml files from the http address. I keep getting errors about reading from the address and 404 with the http response. Should I be using the HTTPCaller, or can I simply use the FeatureReader or a direct KMLReader?I have tried all three, but with no success. Any help would be appreciated.
Hello, I have just started doing a bit of raster analysis in FME and was wondering if there was an alternative to the zonal statistics tool in ArcGIS? I have a raster grid containing landuse areas and need to sum them up to calculate total area, a tool to sum an entire raster (minus nodata values) would also do the job. Thanks very much, Ed
Hi, I want to be time efficient when updating a very long domain list in a SDE Geodatebase. I have created the new domain values in an excel document and would like to empty the current domain list and refill it with the values in this document. The geodatabase of course contains a name for the domain list, a field for the code and for the description. The excel i structured in the same way; a column for the code and a column for the description. Therefore it's essentially a copy/paste job from excel to geodatabase. Can anyone suggest at workflow with translators that can do such a thing?In the future it would be hugely beneficial for me to have a workflow that would read through the list and only add/write the values from the excel file that are not already in the domain list. Thanks for your time and tips,Sofia
When writing kml folders, how do I control the order they appear in the GE table of contents. It doesn't seem to be the order they are in the workbench or the creator number. Also I'm currently not getting any shape to kml translation, missing something easy in there. The goal is to eventually spilt nautical chart outlines by scale (ive done this in another workbench) and then conditionally pipe them to each folder by scale, but one thing at time.
Hi How can read an Access DB stored in Sharepoint of my company ? Thx Francesco
I know I'm well behind the times but has the formatting of an output (writer) ESRIJSON changed since FME 2012? If i use FME 2102 to extract 1 polygon from an ArcSDE 10.1 database and write it to ESRIJSON, attempting to use the standard ESRI "JSON to Features" (ArcGIS 10.4) tool errors out with a :"ERROR 001558: Error parsing json file ......". Is there a difference in output format since FME 2012?
We just upgraded our AutoDesk products to 2019. Is there an FME plugin for Revit 2019...or will the 2018 plugin work with Revit 2019?
I have not seen a straight conversion for DWG to IFC. I have everything I need in the DWG, I just want to turn it into an IFC. there are no attributes or any other data besides 3D geometry.I'll settle for FBX to IFC, OBJ to IFC, DXF to IFC, etc.
Hi i have attached 2 ways i carried out my transformation from esri shapefile to citygml. The first way is shown below in the attachment. However, I am not able to upload the final citygml file into an online portal as it says there is an error with the file. I am not sure where i went wrong in my transformation. Can someone please help? Thanks.For the second way, i just used attribute creator and geometry setter after i extruded and then used the citygml writer to write the file. The forum that explains this is as follows. https://groups.google.com/forum/#!topic/fmetalk/R6QGevN7uGY
I am unable to run data from a PostGIS reader through a change detector against another reader type and get a match. I have an AutoCAD line layer that has been loaded into a PostGIS_linestring feature. When I compare the two features using the change detector, there are no matched features. I have tried several things:Removed all attributes from each featureExtracted the geometry to an attribute and only compare on that attributeForce both feature to 2DI have also tried pushing the AutoCAD data into SQL Server (GeoMedia format) and using that to compare against the PostGIS feature, with the same results.Can anyone provide any suggestions? Has anyone successfully used the change detector against a PostGIS reader?
I have a workspace that converts data from an IFC file to PostGIS. The IFC file contains data I would like to convert in IfcPropertySingleValue elements. Multiple IfcPropertySingleValues are combined in an IfcPropertySet, which is related to a IfcBuildingElementProxy element by means of a IfcRelDefinesByProperties. Converting the IfcBuildingElementProxy elements works, but I would like to have the related data in the IfcPropertySingleValue elements too. How could that be achieved? The classes IfcPropertySingleValue, IfcPropertySet and IfcRelDefinesByProperties do not show up as feature types in the IFC reader.
We are using FME to export some graphic geometry objects to microstation format. We are successful in writing simple text elements(single line text) using "igds_type = igds_text". But we have some multi text elements to be exported which we could not write using "igds_type = igds_text". Since this requires to build a complex element with a group of text strings under a text node, we thought we can do it using igds_multi_text type. So, we wrote the following code in VB. Dim fmeFeatureObj As FMEOFeature fmeFeatureObj.geometryType = FME_GEOM_POINT fmeFeatureObj.attribute("igds_type") = "igds_multi_text" fmeFeatureObj.attribute("igds_text_elements{0}.igds_text_string") = "Line1" fmeFeatureObj.attribute("igds_text_elements{1}.igds_text_string") = "Line2" //{comment: Set other attributes like size, font, rotation, justification for the "igds_text_elements{0}" and "igds_text_elemen
I've just updated from 2018.0 to 2018.1, and now the MS Access reader is very very slow. Prior to the update, it would read in a matter of seconds, now the same file is a matter of minutes.I've checked, and can confirm that both FME & MS Access are 64-bit, I have the correct linking files, and yet reading is still slow.Can anyone advise any other elements to check?
How can we fix an error like:plugins/udatasmith_fme.dll' was found but could not be loaded. Ensure that all the dependent modules exist for this libraryI already know the answer, but I wanted to share it with all of you good folks in case it's a problem for you too!Quick fix: Install Unreal Studio (https://www.unrealengine.com/en-US/studio) or install DirectX SDK from https://www.microsoft.com/en-ca/download/details.aspx?id=6812 The Details:Most likely your computer already has the necessary DirectX components, either from an Unreal Studio installation or from another application. However, there are some cases where these components may be missing. For example, you are likely to encounter this issue when running a Windows Virtual Machine.In any of these cases, you can install the necessary XINPUT1_3.dll by installing Unreal Studio or the DirectX SDK from the link given above. A bit of trivia: XINPUT1_3.dll is used for getting mouse input in DirectX-based games.
Hi, Im having trouble writng to dgn with fanout on fme _feature_type, I get 0.0|ERROR |Couldn't extract a numeric level from the feature type `M-Korbanelinje' see the image below. It works fine If I dont use the fanout and just write everything to the same layer. In dgn v8 it works fine to use the fanout function for the layers within the file, why does it not work in dgn v7? Anyone that knows about this? Best/ Johan
HyI need to read several excel files and remove a lot of columns (fields) so the usage of attribute manager isn't efficient How can do this in smart way ? thx Francesco
Hello everyone. I know there are several questions posted about this same topic but I can't seem to get things working for my particular KML/XML description. I used this tutorial to get most of the way there: https://knowledge.safe.com/articles/19918/how-to-expose-feature-attributes-from-kml-tag.htmlI posted there in a comment but I figured I'd start a new question since this is more specific.I'm stuck on getting either the XQuery or the XML flattener to work. When I convert the description to XML, this is how it is formatted:<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"> <head> <title></title> </head><body> <b>V18279201018990_000.jpg</b><br /> <i>Latitude:</i> 37.424416°<br /> <i>Longitude:</i> -82.930091°<br /> <i&g
Hi everyone, I'm newbie here.I would like to writing CityGML also writing corresponding ADE Schema file.So, where can i start? Are ADE and CityGML files writing together? or can i write seperate and then communicate both files? Could you shine for this case i'll glad to you. Best Regard.
Hello everyone.I have run into a problem while validating dgn data. I need to check for elements that have specified graphic group, however I have run into a problem where cells seem to show igds_graphic_group = 0 even though in my editing software I see that it has graphic group set to non-zero value.I have tested this in FME 2016.0, 2017.0, 2017.1.Bellow is a snippet of one file I am working with (there are many more, over 8000) where I have encountered this problem. This is what I see in my editing software (MGEO, which is local version of microstation)No matter if I expand named cells, or keep just insert points of the cell, I always get igds_graphic_group = 0. Lines work just fine, there I get graphic group I see in my editing software. Any help is really welcome.Thanks,Radek
How to convert mySQl database to Mongodb?
Hi,I am using FME Desktop 2017.1 and trying to output a Microstation V8 DGN file with curves instead of line strings. I have exposed and set the igds_type attribute to 11 (ie: curve) but the output DGN now has no lines at all. Does anyone have any ideas?Thanks
Hello, do I have to use a dynamic reader when the name of an input shapefile changes but the schema does not? I use a workspace that reads a shape that gets updated every two months. I assumed that it suffices to link the new shape in the input parameters but no features are read due to the new filename. To prevent this I either create a new shp reader everytime or I create a workaround with a Creator/FeatureReader/AttributeExposer combination. Both solutions don't seem very elegant and I'm sure I'm doing this the wrong way. Is there a simpler way using a dynamic reader? Thank you for your help. This really irks me as I'm not a newcomer to FME.
I have LAS files that do not have any x,y,z fields to hold such values (seen in the image). Any way to fix it? I want to then export the x,y, z values to a csv file if possible or use it for further analysis.