Data

Is it possible to read from Excel documents that are protected by a password?

I'm try to establish an SHP-Minecraft translation, but in the 2016 version of FME, I had some trouble with the AttributeKeeper. I have an input SHP (point), connected with a coordinate extractor. After that, I attached an AttributeKeeper. I want to keep some SHP attributes, and the coordinates, extracted by the CoordinateExtractor. For some reason, the Keeper lost the XYZ coordinates. If I took try the same in FME 2015, the keeper will keep the attributes. Is it a version error, or I missed something?The following pictures shows the connection, and the settings. In the keeper, I cannot tick the mother attribute, just the children attributes (XYZ).Thanks for your help.Bálint

I would like to write the name of an ESRI file geodatabase (FGDB) at runtime based on the current date/time, for example C:\\Temp\\Output_20151207131034.gdb. How best to accomplish this? It's easy to do so with datasets and feature types but not the FGDB itself. Any suggestions would be appreciated.Thanks,Aaron

HelloI am trying to convert a json file into an excel spreadsheet with each json attribute in it's own column. I am playing around with jsonflattener and attributeexposer however this has been quite difficult. I was wondering if any expert could help. Many thanks! @takashiHere is a view of the json file

Hi,I'm constructing a workspace to import some XML files, and converting them to proper spatial features for storing in SQL Server. The XML format gives me some headaches, unfortunately.One of the XML files contains named nodes with XY attributes, the other file contains polylines with references to the named nodes. I got the start and end points handled, but the intermediate points are stored as an XML group of node names with zero or more items. The order of these are of course important.When importing the XML these items get converted into a list attribute, but what is the best way to convert this list of names to intermediate nodes in the geometry ?I've twisted and turned my head around this problem, but I can't decide whether the best course of action is to create helper features from the list, or create a list from the XY node features, or something entirely different. And if it's at all possible or feasable to handle fetching the XY via node names in a custom tra

Hi,I have tons of styled MapInfo datasets need to transfer to ArcGIS format, and I hope keep these styles automatically in ArcGIS. As there are some styler transformers, such as MapInfoStyler, KMLStyler, is there any way to create common style for ArcGIS shapefile/geodatabase.Looking forwards to hearing any suggestions.@takashi I followed your answers to solve many questions, hope and appreciate you may have solution for this question.

I am writing to a feature class in a geodatabase. My workspace is going to run everyday. Most of the feature classes should be overwritten. However, in one particular feature class, it is not overwriting, but appending. What can I do?I am using FME 2016.

I am using an Excel file and an ArcSDE geodatabase to detect the changes using change detector tool. The output is an excel file with the changes. The tool runs fine on the small excel file, but as soon excel file exceeds 50000 records the error appears.

Hi all,I was wondering if there is a way to influence the creation of DWG files, without the use of a template file, so that it would be displayed in meters as working units in Microstation?

On my server machine I can use direct connect in ArcCatalog to connect to a Geodatabase, Using the same parameters (sde:oracle11g:<dbinstance> )in FME Server causes an abort with the message "Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147155644'. The error message from ArcObjects is: {Server library could not be loaded}".  On my local machine where I author my workspaces I can run the workspaces in FME Desktop using direct connect.  ArcGIS version 10.0 FME Server 2012 sp3  Any suggestions why FME Server direct connect won't work? 

Why are old questions getting bumped to top of the list? There doesn't seem to be any activity

Hi, I want to transform a 2D gml file to a 3D Citygml file. The data I have is a road feature and are polygons. I tried a lot, but till now didn't really find out how I can do that. Can anyone help me, the best would be a step by step explination. Thanks a lot!

Hi, fellow FMEers. I have a simple yet complex problem that I need to solve with SQL (SQLite) for my FME-script to run efficiantly. This may not be the correct forum, but since there are so many talented people here who enjoy helping out and solving complex problem I thought I'd give it a try here anyway. I have data I want to aggregate but in subgroups - taking z-level into account. It's a geological profile where I want to simplify the incoming data before I create my profile. Example datax, y, z_from, z_to, value1,2,1,2,A1,2,2,3,A1,2,3,4,B1,2,4,5,A1,2,5,6,A1,2,6,7,A1,2,7,8,Cwith SQL I want to aggregate on value but only rows that are adjacent (sort of a dissolve but on non-spatial data). And I want to calculate (also in sql) the correct z_from- and z_to-values. So the result from the example data above should be:x, y, z_from, z_to, value1,2,1,3,A 1,2,3,4,B1,2,4,7,A1,2,7,8,C Any help on this will be remembered for all eternity.Peter

Hello,I want to export Smallworld (4.3) objects to a Esri Geodatabase (Personal Geodb) with FME 2014. Creating the database with the objects seems to go without a lot of problems, but the objects don't have any geometries. During the initial setup and run of my workbench, the logfile showed that the attribute 'fme_db_operation' needed a value, so I added a 'INSERT'. This helped in creating the database, but the geometries weren't created.When using Smallworld 4.0, I didn't have those issues when exporting to the same format, so I don't really know how to get the correct result. Any ideas or suggestions?Thanks a lot!Luc

We have dgns that have multiple models (both design and sheet models). When I am writing these features to another file (fairly obscure Graphic Technologies, GTViewer files) it takes the elements from all of the models in the DGN. How can I set FME to only read the features from ONLY the "default" model?

Hi,  I am using microsation(V7) reader to read various microstation DGN files in order to get them migrated in some other file formats, while selecting the source files the advaced browser is not allowing me to add folder name, I had to individually select the files, currently I am using FME 2015.1.0.1 the previous FME versions allowed the user to add the path of a root directory under folder so that one can mention the root directory followd by the filter extension and check the subfolder option so that all the files with specific extension which may reside in diffrent subfolders got selected, this kind of facility is not available in this version. Can anybody help me in getting a solution out of this.  Thanks in advance IMRAN

Dear all, I am at my wit's end here.In this article: https://knowledge.safe.com/articles/1207/reading-c...the XMLFlattener transformer is shown. I have made a workflow with the xml from the article as input file for an XMLFlattener to create feature paths at the node 'shipto'. The input file is valid XML. The output of the flattener however is only a _creation_instance attribute with a value of 0. As a test I fed the XML as an XML Reader. Instantly it translates the xml children in the correct feature attributes.What in the world is going wrong here?I have been searching for 3 hours or more, tried the XMLFragmenter but the results are the same. Thanks for any suggestion!The workflow and the xml source file is included herePim Verver

I have 2 input files. One is point cloud, and the other one is the CityGML. In the CityGML, I have the roof surface (polygons), and for point could, I have all the points just above the roof. I wanted to measure the (vertical) distance from roof to each point.I firstly used the SurfaceDraper to drape the points onto the roof, then measure the distance between the draped point and the original points. But it didn't work by SurfaceDraper. Then I wanted to create lines between every initial points and the points on the ground(I set the points' z value to 0). I wanted to use 3DLineOnDTMIntersector to the points on the roof surface with which I can measure the distance.However, I can't even connect the points in point cloud with the points on the ground to make these lines. I tried PointConnect but it can't make separated lines.. Is there any other transformers that can help?Thanks in advance.

Hi all!I've got a point cloud file of an area, and citygml file of this area as well. In the citygml file, I have the roof surface as polygons. Now I am connecting the points in the point cloud with the polygons of the roof surface. I tried several transformers, such as PointOnAreaOverlayer, Interjector, and now SpatialFilter. But as you can see in the below snapshot, the filters are rejected at the first place. I tried to add a BoundingBoxReplacer to my roof surface before the SpatialFilter. But still it didn't work.Thanks in advance.

As a newbie with FME I started with the tutorial BIM to GIS (basic).I used the tutorial field, added my reader and tried to match it in the workspace to the source IFC. However, my IFC (exported from Revit) has very few feature format attributes when the IFC tutorial source has a long list, and the attribute selected in the Tutorial source does not appear in my IFC source.Where does the feature format attribute come from? Is it from the revit IFC exporter, or does it depends from my revit model?Thanks

I am currently running Microstation V8i and all the cells I use have priority information. However, I am running FME 2013 and when I insert a cell, the priorities I have created for them are overwritten with 0 as their priority. Do the newer version of FME recognize the cell priority within a cell object or is there some other way, possibly an igds formatter that I can install that assigns a priority to objects when written into microstation?

I have many (about 20000)xyz files with Schema x (coord) y (coord) z (relative height) and no header. My output should be a gdb with geodb_points geometry.In my workbench I use csvReader so far. Then I use geometrieFilter Transformer. To read all the thounds of files I use a workspacerunner in an different workbench with the PATH reader. result is a gdb with 1000 feature classes. So now I have almost transformed 2/3 of my data (when I saw that huge disc space and stopped to improve workbench) but recognised that fme imported tables instead of feature classes (I guess in case of "wait for job to complete"=no at workspacerunner) .To save disc space I decided to delete attributes (only one left: height) and work with 2DForcer.My question ist now: how can I improve processing time? Using a different reader? Mark Ireland wrote there: http://gis.stackexchange.com/questions/54558/huge-... that xyzReader is much faster than csvReader. If I use xyzpointcloudReader I cannot use x y an

I'm finding FME crashing every time I try to start it.Checked in the application event log and I can see an error reported ...Faulting application name: fmeworkbench.exe, version: 2016.7.19.16178, time stamp: 0x56ecc220Faulting module name: ig7icd64.dll, version: 10.18.10.4176, time stamp: 0x550c0501Exception code: 0xc0000005Fault offset: 0x000000000017325aFaulting process id: 0x1c84Faulting application start time: 0x01d1cba8da8e46f7Faulting application path: C:\Program Files\FME\fmeworkbench.exeFaulting module path: C:\Windows\system32\ig7icd64.dllReport Id: 2f81a12e-379c-11e6-b705-74e54352be0f

I see that ElasticSearch is now supported in FME 2016.1. Is it also supported in FME Server? If so, what version?

Hi, I want to convert KML containing placemarks to CSV, e.g.:<Placemark> <styleUrl>#msn_placemark_circle122</styleUrl> <ExtendedData> <SchemaData schemaUrl="#S_mdm_centroids_BB_SSDDSII"> <SimpleData name="MDM_ID">DE-BB-304102</SimpleData> <SimpleData name="MDM_NAME">Walsleben</SimpleData> <SimpleData name="MDM_lat">52.9507</SimpleData> <SimpleData name="MDM_long">12.66</SimpleData> <SimpleData name="MDM_Direction">SE</SimpleData> <SimpleData name="MDM_CAPACITY">11</SimpleData> <SimpleData name="Import_Type">1</SimpleData> </SchemaData> </ExtendedData> <Point> <coordinates>12.66021255820746,52.95028030420562,0</coordinates> </Point> </Placemark> The output contains all SimpleData but not the actual point coordinates. I have tried workbench and quick trans