Data

I must be underfed or under caffeinated as this seems to be a simple logical sequence:use workbench to read a fgdb (metadata), use xmlflattener transformer and write attributes to an excel table, however all features are rejected in the XML Flattener:things to note:at the end of the day i am trying to compare a certain subset of the esri metadata attributes and i know the xpaths of the attributes that i want to compare so if there is an easier way to achieve this i am all ears:ex:/metadata/dataIdInfo/idCitation/resTitle /metadata/dataIdInfo/idPurp /metadata/dataIdInfo/idAbs /metadata/dataIdInfo/idCredit thanks

Hi all,are vector draw files supported by FME?I need to convert vector draw files in VDI format to DXF format. The drawings are available in version 4.0, 5.0 and 5.1 and must be converted to DXF or similar format.Any help is appreciated.Thanks in advance.Marcus

Hi all,  I'm trying to overwrite a Hosted Feature Service on ArcGIS Online. One of the layers returns a fatal error which terminates my workbench. Python Exception <HTTPError>: 404 Client Error: Not Found for url: "AGOL feature service details" A fatal error has occurred. Check the logfile above for details.  What I find really odd is that I can overwrite 3 of the 4 layers contained in this same Hosted Feature Service, but not one of them. I.e Bus Service (Hosted Feature Service) - Bus Stops (updates fine) - School Bus Stops (updates fine)- Bus Routes (crashes) - School Bus Routes (updates fine) I'm using FME 2017.1.1 Build 17652  Any help would be much appreciated.

Has anyone had any success connecting to google cloud SQL database using an SSL connection? If so does it work on desktop and FME cloud?Thanks!

Hi,   I'm attempting to convert hundreds of excel files to geodatabase feature classes in a dynamic workflow.  What I've done: In the generate workspace dialogue, Reader - Format: Microsoft Excel, Dataset: my excel files (testing with 5 for now but will have hundreds in reality), Coord. System: UTM83-20. In the parameters, it correctly selects the Easting column as x-coord and Northing as y-coord but incorrectly selects the column "Zn_4A_ICPMS_ppm" as z-coord. I then change the type to "Number" for the first file (only file that is listed in the "Sheets to Read")  Writer - Format: Esri Geodatabase (File Geodb Open API), Dataset: my gdb...with Dynamic Schema selected in workflow options, press ok.  In the writer parameters, I changed the Geometry to gdb_point and also the Schema Definition Name to fme_feature_typeWhen I run it, the log says that the translation was successful and all 5 feature classes show up in my gdb but only the first plots spati

Hi,  I have a workspace set up to convert excel files to geodatabase feature classes with the sheet names being preserved in the output. I'm wondering if there's a way to preserve the actual excel file name instead?   Thanks!

I have a buildings model as LOD2 that I have converted in FME from shapefile into CityGML-format.I also need to add LOD1 budilings to the same CityGML-file. I have created the roofs for the LOD1-buildings and I have the footprints, both files with corresponding height. Does anyone have any advice on how to do this the easiest way or can point me to a workspace (I have tried finding one without success). Is the easiest to generate a new set of buildings? Or can I in my workspace create the LOD1-buildings based on my LOD2-buildings and export them together? Would it be an idea to generate two differnt CityGML-files and then combine them into one model? All buildings have an unique ID associated with them. Has anyone tried this?Thank you in advance :)

Hi everybodyCan you confirm the new capability in FME 2017 to fill a field [xml_geometry ] in schema AIXM 5 only with a xmltemplater. ?How to fill the gml_id field, or srsName, or some traits inside them ( depending the number of feature which are read in input data) ?Have you the possibility to post an example of the use of xmltemplater to fill such xml_geometry nested structures ? (Airportheliport or inspire ?)I have some examples of fields Structure {} written with an xmltemplater. How do i put these fields inside the destination schema ( AirspaceTimeSlice ) without using geometrypropertysetter, aggregator. ....Thanks

We have a schema within Oracle 12c that stores its attributes and geometry in separate ."Electric Central Europe is based on the Utility data model which stores geometry and attribute data separately. The EL_POINT and EL_LINE feature classes represent the points and lines that make up the electric network. EL_POINT features are electrical features such as breakers, switches, transformers and other electrical devices. EL_LINE features are the linestring geometries that represents conductors"how can this be extracted from oracle using FME to export into for example shapefile for cables with attribution and geometry in the same line ?

I'm working with data held within an attribute which contains a strings of varying length. Within the string the data is grouped within pairs of parentheses. Example of data would be (66) (12.36) (534) (1.6667)The number of number characters within the parentheses does differ within the data hence the reason for this post. (I had thought I'd resolved my issue with by utilising a series of stringextractor transformers).I would normally take the data into excel and replace the ( with blank then perform a text to columns with the ( character but I'm trying to learn more about FME.I require 4 new attributes to contain only:Attribute 1 = 66Attribute 2 =12.36Attribute 3 = 534Attribute 4 = 1.667I'm certain that this will be possible and have read some threads on Regex, unfortunately for me I'm not familiar with this language and have failed so far to use the stringsearcher or stringreplacer to resolve my query.I'm sure other people have come across similar data cleanse

Working with AutoCAD Layouts can't set autocad_viewport_center_point_x support upto autocad_viewport_center_point only

Hi,kindly help me convert from DGN to DWG file.I'm following this procedure:Right click on dgn file -> translate with FME quick translator reader - dataset: I browse the dgn fileformat: automatically recognized to Bentley Map XFM design V8writerFormat: I select Autodesk AutoCAD DWG/DXFclick on OKoutput:DESIGN READER: Opening DGN V8 file 'C:\\00 Enrique\\02 Desarrollo Negocio\\Países\\Suecia\\00 E4 Bypass\\FSE901\\Original\\Export\\001D_FU\\004D_5 Tekniska handlingar\\001D_Samordningsmodeller och beskri\\I100K110\\I100K110-01.i.dgn'DESIGN READER: Error opening Design file C:\\00 Enrique\\02 Desarrollo Negocio\\Países\\Suecia\\00 E4 Bypass\\FSE901\\Original\\Export\\001D_FU\\004D_5 Tekniska handlingar\\001D_Samordningsmodeller och beskri\\I100K110\\I100K110-01.i.dgnA fatal error has occurred. Check the logfile above for detailsFailed to obtain any schemas from reader 'DGNV8XFM' from 1 datasets. This may be due to invalid datasets or format accessibility issues due

I want to use feature merger to merge data from a number of excel spreadsheets that all share a common unique ID. Is this possible? I have had success merging two sheets but when I try to merge a third sheet the new entries appear as 'Missing' Am I doing something wrong?

Hi all, Does anyone know how to import spatial data into Postgre? It seems  the option Allowed Geometries is greyed out.   Thanks, Darius

Hello,I am wondering if there is a way to define precision for json files generated with the ESRIJSON writer. I am reading from a 10.1 ESRI File Geodatabase, writing to ESRIJSON and get 4 digits after the decimal, where I'm looking for 10. The coordinate system of the reader is web mercator (meter) - I know 10 digits is unnecessary but am trying to match the format of other files. Using the ArcGIS geoprocessing tool 'Features to json' gives me the 10 digit precision.FME 2012, ArcGIS 10.1 SP1.Any help would be appreciated.Thanks

After I generate the file using the glTF output writer, and tried the Khronos glTF validator it presents me with errors.Not sure if anyone else has this problem. In addition, I cannot load using Cesium or threejs glTF loaders.  

I am trying to transform an ESRI shapefile to a GML.To generate the GML I use a template/schema (supplied by the recipient). Unfortunately the result does not look like the delivered example . Because of this, the file will not be accepted. How can this be corrected? I am fairly new to this so please try to keep it simple. Below is the template/schema 1) First of all the naming is incorrect, rws:Objecten is expected but gml:FeatureCollection is generated.2) Below that, I expect the xmlns extensions to be underneath each other instead of in one line.3) Also gml:id="GML-ID-0" should be behind rws:Objecten but it is somewhere else.4) It also generates gml:boundedBy, this is not in the source data.5) gml:pointProperty is created instead of rws:puntObject.6) Inside gml:pointProperty, naming and positioning is different. Why is this happening and how can I generate a GML that looks exactly like the example XML format?If you need to see/test it for yourself, . Thanks in adva

Hi,Probably this question has been asked before. ...I have a geometry IFME arc well made in the workbench ( arc by centerpoint, or arc by centerpoint with end points ).When i extract this geometry with GeometryExtractor i didn't obtain a <gml: arcbycenterpoint > description but a <gml: linestring > description. Only exception : arc with 3 points.I used 2Darcreplacer to construct this arc.It seems the only solution to obtain what i want is to write an XML templater with the desired squeleton and put the attributes inside. And when i retrieved the geometry with a geometry replacer + geometry extractor It doesn't change.The problem is when i want to aggregate arcs with lines or with arcs again to obtain a complex geometry. With the transformers inside FME it's well made ( 2Darcreplacer, arcpropertysetter. ...) and i obtain a <gml: surface> made with many parts. ( aggregate in FME workbench made of IFME Polygon with IFME Paths made of IFME arc and IFME L

I am new to FME. We want to use it at our office to convert dwg building models with ACIS solids to IFC models (and the other way around). In the process we want to map every DWG layer to an IFC object type (ex: objects in DWG layer A-42------ are converted to IFC walls).I started trying to convert one of our building models, but the IFC output is only 1,5 kB and contains no geometry.Now I am trying to convert a test file containing only two solid boxes, with the same result, and I can see in the log that the objects fail when the IFC file is written.I have tried to convert the same model to Collada format with success, so there is nothing wrong with the reader side, but something goes wrong (or I have not understood some needed setting) when the IFC writer are doing it's job.My conversion log is attached.Hope someone can point me in the same direction!Cheers, Mikael

Hi,I am trying to transform a dwg (to dwg) but I have a problem with hatch features.I noticed when I have hatches with the acad option "Outer Island Detection " as type, I can't write them into my dwg file output. When I swich it to "normal", then I can. I was wonderring if it is posible to handle this option directly in FME before writing the output as I have plenty of dwg with this problem to tranform.Thank you in advance,Fabien 

I've got a MSSQL database that stores JPEG images in a varbinary(max) field. I can of course bring this data into FME desktop with either the SQL Creator or the MSSQL_ADO reader. I also know I can get at the EXIF information using the JPEG reader and exposing those attributes. Where I get stuck is how to get from the fme-binary data into the JPEG reader to expose that meta data. Ultimately I'm trying to extract the GPS coordinates from the JPEG but nothing I've tried has worked. Since this is an ARCmap Feature Attachment table I can't be the first person who wants to extract the timestamp and GPS to verify or update the feature data to which the attachment is associated, but I can't figure it out.

Hi,I have two Microstation V8 file that's suppose line up side by side spatially, but for some reason one file won't line up correctly. FILE_01.dgn looks correct when I view in FME Data Inspector, however FILE_02.dgn shows up as a empty screen. Yet when I open the file in Bently Data Viewer, I can see the data. I suspect it's some sort of Global Origins issues, however, I don't have access to Microstation and not sure how to trouble shoot.Any advice would be greatly appreciated. Regards,Thomas