Data

Is there a practicable way in FME to extract 3D objects or solids (indoors and/or outdoors) from point clouds?I found posts back from 2015, lots of feature requests and ideas. What's "State of the Art"?Inside / outside of FME... (conc. Revit but also other data models)Bye, Marion

Hi, I have a question about FME desktop 64 bit. Will be possible in the future integrate FME desktop to ArcGIS PRO like for 32 bit version into ArcGIS desktop? The reason is that ArcGIS desktop is stopping slowly supported and if you would use ArcGIS interoperability you have to pay another licence. The basic functions which allows FME integration in to ArcGIS desktop are great and I would have them also in ArcGIS PRO.Thanks,Miloš

We have just installed FME Server on a local server using the express option but did not see any settings for the Postgres database?Is there a way to find out the login / connection details for the Postgres Database?Is it automatically set-up for PostGIS?

I'm insert:Writer FileGDB (ArcObjects)Set Feature Class to fme_feature_typeDuplicate the OutputIn the navigator is only one Feature Type visible. In FME 2016 there are two. FME 2017 ignore the second output.It's a bug?

Hello there is there a way we could trigger a workspace as soon as a record is added to google sheetThanks

I have set up a file geodatabase reader (ArcObjects) and pointed it to read one feature class in a file geodatabase. The feature class has 50 features. When I run the process, it reads 100 features. I tried deleting one feature from the feature class, and now it reads 99 features, while ArcCatalog shows only 49 features in the feature class. This issue has not been consistent -- sometimes if I change the settings of another file geodatabase reader (pointed at a different file geodatabase) in the workspace, the problematic reader will only read 50 features. I am trying to use dynamic inputs, passed to the reader from a scripted parameter. Why is this happening, and is there an easy solution? I am using FME through ArcGIS's Data Interoperability extension, version 10.5. It is FME version 2017.0.0.1 (20170316 - Build 17271 - WIN32) and at this time upgrading is not an option for me.

I'm having difficulty accessing data with a WFS reader. I can read the feature types, and the translation is 'successful', but returns 0 features. I can load the WFS in QGIS too. I've tried amending various parameters without success, including: connection timeout length, max features, ignore application schema (this worked with the previous version of the WFS), and using a search envelope. The WFS is: https://environment.data.gov.uk/spatialdata/historic-flood-map/wfsWould really appreciate if anyone can nudge me in the right direction!  

Hello again.I'm using several translations involving HTTPCallers and other transformers -- all of which work successfully with FeatureWriters saving to ESRI Geodatabase (File Geodb Open API) feature classes. I'm running into a problem saving to ESRI Geodatabase (ArcSDE Geodb), however, where the translation never completes, and the log ends with the following:Successfully imported schemaImportError: No module named siteThis seems to be Python-related from what I have found, even though I do not use the PythonCaller or anything Python-related in my workspace. I can't seem to find a similar problem to mine.Yesterday I installed Python 3.6, which I assumed may be causing this. So I uninstalled it and made sure Python 2.7 was still present (it is). The Python interpreter preferences in FME still point to Python 2.7. I tried changing those to 3.6 to match the version I had previously installed, which did not help.I had complete success with one translation, but all others have the same symp

I'm getting warnings in my logs when using the PDFwriter (in the FeatureWriter) and the mapnikrasterizer. Both in FME Workbench and FME server (Cloud) i got these errors.2019-09-25 13:00:58|  33.6|  0.0|WARN  |PDFWriter: Unsupported font family 'Arial'.  Reverting to 'Helvetica'2019-09-25 13:00:58|  33.6|  0.0|WARN  |... Last line repeated 10 times ...and2019-09-25 15:54:14|   0.3|  0.2|WARN  |MapnikRasterizer (MapnikFactory): The specified font 'Tahoma,Standaard' could not be loaded.  Using default font 'FreeSans Medium'2019-09-25 15:54:14|   0.3|  0.0|WARN  |MapnikRasterizer (MapnikFactory): The specified font 'Tahoma,Standaard' could not be loaded.  Using default font 'FreeSans Medium'I tried all the available options in the font menu but got no result.

Hi,i need some help to read and write PNG File with GRAY8 band.if i use the normal PNG Reader then i got a fully black image.i experiment a little bit with the raster and rasterband transformers, so that i got a nearly good solution, but not the same as i open the file with paint.in attachment there are 2 example files and my current experiment bench.can someone help?

Anybody know how to pull down e.g. https://sampleserver6.arcgisonline.com/arcgis/rest/services/Census/MapServer/3/query?where=1%3D1&text=&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&relationParam=&outFields=STATE_NAME&returnGeometry=true&returnTrueCurves=false&maxAllowableOffset=&geometryPrecision=&outSR=&having=&returnIdsOnly=false&returnCountOnly=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&returnZ=false&returnM=false&gdbVersion=&historicMoment=&returnDistinctValues=false&resultOffset=&resultRecordCount=&queryByDistance=&returnExtentOnly=false&datumTransformation=&parameterValues=&rangeValues=&quantizationParameters=&f=kmz as a kmz file in FME?Works through the browser but I'm unable to get kml feature reader or http Caller to work successfully as a file. My resultant f

This is being raised when using an Esri ArcGIS Portal Service Feature Writer. 24,000 features out of 94,000 are successfully written before this is raised by FME Desktop 2019.1.00

Hello FME Community!  I´m looking to read AutoCAD Civil 3D files from a folder and convert them to another version ex Release2013 into another folder.  I´ve understood that you should use write AutoCAD DWG/DWF, since there is no Civil 3D writer. However you can´t select a folder to write to, only specific file destination? Is there another way around this?  I tried taking another route, by using "Fanout Dataset" on the Writer. Which kinda solved the folder issue, but the created file got the same result as below.   Also.. When I simply try to overwrite an identical dwg file with another dwg file to get the desired version, the new file lose everything that was in it and instead only gets a layer named surface. Does anyone know how to resolve this?  I simply want to copy dwg files and write them identically into a new folder, but in version Release 2013/AC1027.  Any form of hint is greatly appreciated!

Hello,I am trying to open IFC 2X3 files of 2MB size that have been exported from Aecosim and FME 2019.0 returns an error. or returns only the semantics of the IFC.I am able to open successfully other IFC files that were created some months ago, so this is quite unexpected considering I have not changed the parameters that I was always using. As I suspect this is quite an abstract question and testing with the model would be necessary, would it possible for a colleague of FME to assist due to data confidentiality issues?Of course, any advice is greatly appreciated. Thank you for your time. Kind regards, George Floros

Hi, I have hit the maximum row limit for an excel spreadsheet with the excel output writer (1,048,576 rows). Is there an easy option to overflow the rows into another spreadsheet?Should I use a row counter and tester to overflow the data to another spreadsheet?

I want to run bunch of postgreSQL SQL's through a file using psql command.To check whether psql works in SQLExecutor, I tried putting below statement SQL executor.psql -c 'SELECT * FROM testdb.test'; However, I got below error.psql -c 'SELECT * FROM testdb.test';'): 'ERROR: syntax error at or near "psql"LINE 3: psql -c 'SELECT * FROM testdb.test; ^'A fatal error has occurred. Check the logfile above for details Can you please help.

I am fairly new to FME and I am attempting some of my first translations from SHP files to Oracle Spatial Tables. Everything completes successfully apart from the following errors I get several times through the translation:BADNEWS: An error occurred while fetching from query `SELECT table_name, column_name, DimInfo, SRID FROM USER_SDO_GEOM_METADATA' : OCI_NO_DATA (ocistmt.cpp:663)I get additional errors when publishing after writing the features to the DB:118904) Invalid geometry for component view V_STREETCTR_LN, FID 104594211, CID 1, and LTT_ID 0 - No geometry was produced, probably because of a mismatch of G3E_COMPONENT.G3E_GEOMETRYTYPE and the actual geometry, or because of an un-supported SDO_GType.I have tried this across multiple features and run into the same problems each time.Has anyone run into these issues translating from SHP to Oracle using FME?Sample Workspace:Log:

I am using LDAP/Active Directory (Tech Preview) Transformer to access users for an entire organisation. When I use DN as ou=Users,ou=branchname, ou=departmentname,ou=Department,DC=domain,dc=domainname=ca, i get users listed from that branch only. However, I am interested in pulling out users from the whole organization which has many departments and branches. Any help is appreciated.

Hi,I have a very large CityGML dataset consisting of millions of features. I would like to split this into smaller datasets so that each dataset contains at most a few hundred features, grouped by location (eg, possibly turning each city block into a separate CityGML file). The goal is to turn each CityGML dataset into a Cesium 3D Tileset :CityGML -> [CityGML] -> [B3DM]Any help would be appreciated. Thanks!

Greetings,I am trying to create an FGDB empty geodatabase with feature datasets, feature classes & attributes. I have all these information stored in a xls file, I want to read this xls and create the FGDB accordingly. If anyone has a workflow, please share. Thanks in Advance.  

Hi,I have a lot of DXF Files in different folders. The DXF files have all the same layers.I don´t need every layer of the files for my work. So I want to read every DXF file, filter the layers which I need, summarize them to different groups and store them in a new file.How can I built such a workbench?Thanks and best regards.   

Is there any transformer that help me to change from any of the python valid formats for GUIDs to the arcpy valid format to insert it in the geodatabase?The valid formats from python are:{00010203-0405-0607-0809-0a0b0c0d0e0f}00010203-0405-0607-0809-0a0b0c0d0e0f000102030405060708090a0b0c0d0e0f{000102030405060708090a0b0c0d0e0f}the valid format received by the geodatabase is:{00010203-0405-0607-0809-0a0b0c0d0e0f} thanks!!  

Today is 2019-SEP-20%Y = 2019 / Year%b = Sep / Month%a = Fri / Day Name%d = 20 / Day%u = 37 / Week of Year??? = 3 (3rd Friday of September)What I'm trying to find this is the 3rd Friday this month?ie2019-SEP-06 is the 1st Friday of September2019-SEP-13 is the 2nd Friday of September2019-SEP-30 is the 3rd Friday of September2019-SEP-27 is the 4th Friday of September

I need to read an Excel spreadsheet. I use user defined parameters to set a filename and a sheet name.This is a simplified workflow:This is a parameter I use: and this is schema settings for FeatureReader It gives me the following error: Here is my test example

Hello,  I am new to FME Server and would like to know if there is a way to filter the output of a workbench with automatons?  I my case i have two Schedule triggers that run a workspace. When the workspace if finished it updates a Excel file on a network drive. Now I would like to filter the contents in the Excel file so that i send an email to one person or another depending on what values are in the updated Excel.  IS this possible with automatons?