Data

Do you know, if it's possible to write simple html code in the prompt of the parameters for a workbench in FME Cloud. I do it in Desktop (to have text color, bold or italic) and it's works good. But in FME Cloud the html is not translate. HTML Code in FME Desktop HTML Code in FME Cloud Have you got an idea for this issue ? Thank you Damien

Reading an AutoCAD dwg, how do you get the entity handle of a piece of block text while also retaining an attribute to relate the text to its block? In my workbench I have the following parameters, which seem applicable, set: - Expand Blocks into Entities: Yes - Read Visible Attributes as Text Entities: Yes This gets me the block text entity with its autocad_entity_handle attribute set, but none of the attributes I can tell relate it back to the block from which it was exploded. It would seem that the autocad_block_name and autocad_block_number attributes would do this but they don't get populated. I am using FME Desktop 2016.1.1.0.

Hello everybody! I try to solve one big problem... I work with workspace which export some spatial data and all I need to do is to create envelope around exported data. BUT, I need the envelope which is composed by predefined AUTOCAD BLOCK in separate DWG drawing (e.g. frame or drawing stamp; block is everytime centered into 0,0 coordinates)... To better imagination I attached picture, where I decribed my aim. I would appreciate every help. Thank You so much! Lubo

Hi, I have to merge two tables with the common field.. one is from plain sql database and other is feature class.. Here I am using Feature Merger transformer..But I have to query the data in feature class using wild card search (data) from table1. SQLDatabase-------------------(Select Code from Table1) | | FeatureMerger ----> I want to query the data FCField like Code | | FeatureClass -----------------(Select FCField from Featureclass) Any help would be highly appreciated. Cheers, Srikanth Dasari

I have a large number (~1000) Excel files that I need to import into a database table. They are many different formats, so using a reader with a defined schema will not work. I would like to have the output contain the following attributes: Filename Sheetname RowNumber ColumnNumber (preferably as a number but could be letters as used in excel) value (as text) I've tried numerous things and searched through many posts. It seems like this should be a simple task, but the Excel Reader attempts to detect a "schema" for a sheet, and it uses values it finds wherever in the excel as attribute names. Any suggestions would be greatly appreciated.

Hello, I get Geodatabase Error (-2147024894): The system cannot find the file specified. Could not open File Geodatabase dataset `\\\\coacd.org\\dfs\\PDRD\\IT_Services\\GIS_Group\\Programs\\Zoning\\test.gdb' for writing when using FME Server. This works on my desktop. I've checked on permissions, and was told I have modify privileges. I tested that by writing a shapefile to the Zoning folder and that worked. As you can see I am also using the UNC path. I've also played with both the arcobjects and API writers. I have a sample workbench that I am testing. I would appreciate anyone looking at that or giving me some clues on this issue. Thanks!

Hi I have an issue with NULL geometry features in ArcGIS. Such point features occur when I write them without a geometry to a ArcSDE DB by using FME. We found out that not only FME has problems reading such NULL geometry features (when using an ArcSDE Reader), but also when reading them through ESRI Mapping Services. However, when using an empty geometry instead of a NULL geometry, no errors occur. In the Oracle database, a NULL and an empty geometry are differently defined: NULL geometry: NULL Empty geometry: MDSYS.SDO_GEOMETRY(3001,2056,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,0,998,1,1,1),MDSYS.SDO_ORDINATE_ARRAY(1,1,1))Is it somehow possible to write empty geometry features in FME (2016/2017)? Greetings, André

I have made an aggregation of lines that I have saved in MS SQL. when I then make a STGeometryType () on the table I find that a GeometryCollection has been formed. I want to avoid this and instead save it as a MultiLineString. However, I do not find any settings where I can control this. (then I will do the same for points and spaces to completely avoid GeometryCollection.)

Power BI allows the developer to access data either by a direct connection to a database or by importing a dataset from a database. The import makes the operations in the Power BI report faster because the app doesn't have to go directly to the database, but the data is not fresh. Are any plans to create an FME writer that could access and write to Power BI to emulate the import process? That way an FME script could be run on a regular basis to refresh the imported data.

I keep getting this error when trying to write out large amounts of data from a workbench to the Default version of a versioned feature class in a SDE:|Error while retrieving an ArcObjects update cursor for the table/feature class 'ILMOCDBO.gtlf_ln'. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error [[Microsoft][SQL Server Native Client 11.0][SQL Server]The app domain with specified version id (11) was unloaded due to memory pressure and could not be found.] [ilmoccmp.ILMOCDBO.gtlf_ln]} From what I've learned, that error means that the SDE ran out of RAM on the server that it is installed on. This happens because when FME is writing out the data, it is being written to a view in the SQL and the view lives on RAM while this happens. The error occurs when trying to write out large amounts of data, but can vary depending on the size of the data being written out and the amount of free memory. What I am looking for is a way to

I have a published parameter of type "Choice with alias (Multiple)". In this parameter, I import all the towns, departments, regions... of France (like 40 000 lines) from a postgre table. When I run the workbench in FME Desktop, it takes a little time to filter the values according to what I'm writing and to select them but it can be ok. But in FME Cloud, it's very very very long and I can't really use it. I've try with a list without the towns (7 500 lines), it's better but still not usable.... Have you got an idea for my problem ? I know it's a big list for a parameter but it's the goal of my workbench. I have a table of 19 000 000 lines and I have to do a filter according to selecting territory by the user. Thank you Damien

Hi all, I'm trying to process one DWG and create another DWG. There are some blocks inside and I used DWGStyler to make it all right. And that works. But there are also a number of zero-length lines for which I want to stay lines in the output DWG. Instead, they are turned to points and converted to blocks. I've tried to set the advanced parameter "output zero length lines as lines" but it is not working. No matter what I do, they become points and convert to block in output. Their position is identical to block position. I need them to stay there, and stay as lines or points but not to convert to blocks. Any advice what to do? Thanks.

My workspace has two readers - Oracle and Postgres. Sometimes the Oracle reader feature has records and sometimes it doesn't. I'd like for the Postgres Reader feature to be read only when the Oracle reader feature has records - i.e. to be dependent on there being records in the Oracle reader feature. Is this possible to do?

All: I have an issue with the following error on my Windows 2010 R2 Standard 64-bit server running FME Desktop version 2017.1.0.0 (20170731 - Build 17539 - WIN64). When I have the same version of FME running on another PC, the workspace runs fine without a hitch. I can't seem to figure out the problem. Please note, I do have FME 2013 on this same server but the PATH for the environment variables have the 2017 path established before the 2013 path. Please Help!!! :) ----- Python Exception <ImportError>: No module named parser Could not create Python Reader `GOOGLESHEETS' A fatal error has occurred

While I realise there are examples of this elsewhere, the techniques outlined don't appear to work for me. I have multiple CSV files that do not have a header, the first row of data is always being read in as the header row (despite me saying that the data is in row 1) and only columns with null data have "colX" so I don't see how I can use a concatenator alongside a dummy CSV with the true header information. Can anybody provide some detailed directions on how I can import csv's into a database using FME where there are no headers without excluding the first row? Thank you!

I am looking to convert an IFC export from Revit to an ESRI FileGDB Multipart Featureclass and would eventually like to view in ArcGIS pro. Any help or start would be much appreciated, thanks! Link to IFC: https://www.dropbox.com/sh/up76utq2soz6tjc/AADd-jppK5pJ6_q9Qtt6Jufwa?dl=0

I need to implement to load one Excel file into AWS RDS Database. And Excel file have multiple sheets and one sheet have 65000 records. And I don't know how many sheets will be come based on dividing sheets with 65000 records for one file. I searched google and FME knowledge. There is the similar answer which is using Generic Reader for loading all dynamic sheets. But it is not working using Generic Reader. Thus, I would like to ask the way to load dynamic excel sheets from one file to load into the database.

Setting the kml_open attribute causes FME to write an <open> tag to the placemark, but I suspect it should be written to the folder the placemark is in. That would make it unsuitable to be a format attribute since it applies to all features in the placemark. I would argue it's better to make it a feature type property. See https://knowledge.safe.com/questions/58958/how-do-you-specify-the-the-kml-open-attribute-to-f.html?&childToView;=59153#answer-59153 for additional discussion

There is a wonderful page that states that this is possible, https://www.safe.com/convert/dwg/postgresql/ , but I haven't found any additional documentation. I am not super experienced with AutoCAD, nor PostgreSQL. The page states that this can be done retaining details "such as annotation and symbology during the DWG to PosgreSQL translation". Ultimately, I am trying to take multiple DWGs and write them to our PostgreSQL DB into a "Master File" that could be imported, clipped, etc. back into AutoCAD for reuse. Any help on what formats to write to, etc. would be greatly appreciated. Thank you in advance.

I´m trying to input parameters (xmax,ymax,..) automatically from a shape. Is it possible?

FME: 2018, build 18220 If I read from gdb (Esri Geodatabase (File Geodb)) no features are read with option "Individual Feature Type". With option "Single Merged Feature Type" feature will be normal read. The DataInspector works normal. It's a bug?

Is there a way to connect to a mysql server using an SSL connection? We are working with FME 2016 1.3.2, Windows version.

Hello all Am new this type of work(Conversion of BIM models in to GIS) Hope ill get answer here... Please look in to following work flow we are using 1. We are preparing BIM models in Revit 2.We are converting this BIM model data in to RVZ files by using FME converter. 3.We are converting this RVZ files in to GDB data 4.We are adding this GDB in to ARCGIS This is work flow we are following My problem is: Parameters(Type and instance) seen in Revit project are different compared to GDB properties For Example: single door Parameters am seeing in Revit are not totally covered in GDB data and am getting extra properties in GDB data which are not in Revit. So where Problem is happening in which conversion... Please help me out from this issue.. Thanks a lot in advance.

I have footprint of buildings that have attribute base elevation and point cloud of buildings . https://knowledge.safe.com/articles/1353/point-cloud-to-3d-terrain-model-with-buildings-dwg.html from this tutorial I can create only city lod1 . I want to know how to crate shape roof . Thank you