Data

Hello,I am converting Microstation DGN (V8) to AutoCAD Map DWG (2010) file, reading DGN file as group by Schema - Level NamesIssue is OD that is created also has some Tag/DGN internals as attribute.e.g.CONTRACT_NO, CONTRACT_NO_name, CONTRACT_NO_prompt, CONTRACT_tagset_name, CONTRACT_NO_tagtype, CONTRACT_NO_value, igds_color etc.In above list only CONTRACT_NO should be created as OD attribute rest is not required, How do I restrict it not to write these Tag internals.I have used Attribute remover, bulk attribute remover , schema from Table but it has no effect on how the OD is created.FME Vversion = 2016.1RegardsZubair 

I convert shape files to autocad.....have given the different shape files an certain color index and write that index in the autocad_color attribute. But the default_color which is given in the Format parameter in the output autocad file is e.g. red and every layer is shown with red color in the layer table....the laye ritself has the right color (given by me)...how can i change that default_color? I want that every layer has the right color also in the layer list  Thanks and greetz Franco

Hi thereWhen I try to translate some TAB files to shape files in FME, I keep getting the errors:ERROR 3: InitBlockFromData(): Invalid Block Type: got 0 expected 2 ERROR 5: GetNextFeatureId() failed: unable to set read pointer to feature id 1GetNextFeatureId() failed: unable to set read pointer to feature id 1 Closing native MapInfo readerFailed reading feature from MapInfo fileCould anyone please tell me what this means?

Why is FME imported data into SQL Server not being found by QGIS? I've imported some MapInfo format data into SQL Server 2014 using FME. In SQL Management Studio (SSMS), I can do a query and the spatial results tab shows the various polygons as expected But if I switch to QGIS and connect to the database, but the data set isn't showing I have also loaded data using ogr2ogr and those data sets are showing, and can be displayed on a map in both QGIS and SSMS So why aren't FME loaded data sets showing?

Hey guys I'm converting an Esri Personal Geodatabase (.mdb) file into an Esri Geodatabase (.gdb)file. I need to include a new column in the new .gdb populated with data from another table. The column will be populated according to keywords within one of the columns in the original table and one way I have figured to do this is to run SQL Executor however, it doesn't look like SQL supports .mdb files. Is there any other way to do this or how can I work around SQL? I know this is a bit of a confusing or vague question but I'm very new to the world of FME and SQL

How do I view a seed file in Data Inspector to check the igds_textstyle_id?

I'm building a QA data validation tool and the first step in the process if the data aligns within the extent of the state of Alabama and more importantly in the rightful location. How do I determine this considering that the DGN files may have different coordinate references, ie. local coordinate, grid, state plane, etc.

I've tried searching for this ArcObjects error and couldn't find this issue. My FME workspace works fine on Workbench but I'm having problems with it on FME Server. When I run it on the server it fails and I get this message:Could not create the File Geodatabase '~'. A possible reason is that you may not have permission to create the Geodatabase. The error number from ArcObjects is: '-2147467259'. The error message from ArcObjects is: {}What does this mean? I couldn't find this in Esri's list of error codes.

I am using the Esri Geodatabase (ArcSDE Geodb) writer in FME Desktop 2015 to write to an Oracle Esri geodatabase. However, when I put the workspace into FME Server I get the message: ERROR 0.0 1.7 2016-06-28 12:42:21 Unable to perform licensing related tasks. Please ensure that ArcGIS is correctly installed Is there another geodatabase writer that I can use for this task, or do I need to install ArcMap on the FME Server?Thanks

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).

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

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 A

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