Using readers and writers to extract and load data.
Recently active
Hi, there is a revit model that is normal when exporting ifc, but some models are lost when exported as rvz files. Lost this part of the model is mainly the use of structural framework order to create the components, especially the arc-shaped parts easily lost.IFC4RVZRevit File:revit file_google driverevit file_one driveThanks.
The FME tell me that translation was successful when I converted COLLADA to Cesium 3D Tiles. But I want to look at the model of 3dtiles through FME Data Inspector, it's failed. I tried to apply this 3dtiles format model to the my project, it's also failed. I can ensure that my collada model has no problems.The FME also tell me that translation was successful. I don't know why the 3dtiles format model will go wrong. I want to know where the problem is and how to solve it.
I want to extract the osm pbf file to gdb for the writer output OSM highway_poly line feature with max speed and Surface. Is there a way to extract the osm pbf file to file gdb?thanks in advance.
hi,I'd like to create a fillet (like the autocad command) between 2 polylines ? is-it possible?desired is the red arcs. thanks
I have about 11 thousand SHP files with unique names and a XLS list with ID that contains in ID field of SHP. How can i select this SHP files that is in XLS list and write them into another folder?
I've correctly installed Oracle 11g Express Edition database on my machine. After successfully connecting to my database, why can't I use FME's Oracle writers? I get an error message that says my data type is not supported by my Oracle version, and that I should use Oracle 11g.
Hi,We have a large dataset containing about 35.000 buildings in KML + Collada file format.After converting process of this file (KML to Cesium 3DTiles), we have noticed that file size of B3DM files are very large for cesium platform. B3DM file sizes vary between 37 KB and 278 MB. File size of JSON file is 156 KB. Do you have any suggestions for optimizing B3DM file sizes for best performance on web?
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