Data

FME 2018 seems to have removed my two preferred methods of using bookmarks: 1) Without a filled background - it's too distracting to be always on; 2) No description anymore. Much neater and compact than annotation and the 2018 examples still waste too much space. Can we please have these back as an optional behaviour? I can't even edit workspaces with description anymore!All you are encouraging me to do is to STOP using bookmarks!

I have a problem with writing the multiple sheet output to excel but keeping only the attributes that are relevant to each sheet. For example (as you will see on the image) SAC_NAME should only be in the sheet named Special Areas of Conservation and should not be present in the sheet Wood Pasture and Parkland... and vice versa the PRIHABTXT attribute should not appear in the sheet Special Areas of Conservation... What I get now are columns of empty attributes.I tried to use PythonCaller to remove the empty attributes but it did not work, since the writing actually happens in the writer and PythingCaller is before the fan-out happens (I imagine that before fanout all is in one sheet and none of the columns is entirely empty).

Hi, was wondering whether there is an option to read all the features from a feature class in a SQL Server geodatabase or SQL Server spatial table before they get written to an ArcGIS Online (AGOL) feature layer when I click the run button in the toolbar. The problem I'm running into in our environment is that part way through writing to AGOL I get an error like the following "Microsoft SQL Server Spatial Reader: Query failed, possibly due to a malformed statement. Query Text `[no query]'. Provider error `(-2147467259) TCP Provider: An existing connection was forcibly closed by the remote host.".Thanks.

Hello,I am having issues when using the GEODATABASE_SDE writer in the below environment. I am referencing the sde connection file from a FME Server resource location and then override the credentials within the workspace. The log shows it getting to the below lines and just hanging forever. When I swap out the writer to be SDE30 it has no issues at all and completes as expected.I am at a loss as to what may be going on. I guess I could use the SDE30 writer but I would really like to understand why the more recent GEODATABASE_SDE isn't working. Last three lines of log:-FME API version of module 'GEODATABASE_SDE' matches current internal version (3.8 20170315) -An ArcGIS license is already checked out. The product checked out is 'Advanced' -Installed ArcGIS version is '10.5.1'Environment:FME Server 2017 on windows server 2012SDE database 10.5.1 on top of Oracle 12cAny help would be much appreciated!

Is there a tool or workflow to remove or classify overlaps in a LAS file?

ESRI file geodatabase into MapInfo TAB format. Partial conversion only in that some records have data missing

I'm trying to build an ECW from OS tiff tiles. I get the Change Only Updates so have several folders with the base data and monthly files with the quarterly changes.What I'd like to do is use the latest tile from each of the folders, but I'm not sure how! Is it as simple as sorting in date order, so the newer file are laid over the top of the older?TIABen

Hello,I noticed while migrating some Shapefiles to MSSQL Spatial that there's a Geom column which is added. In which format it is encoded ? And does it countain all the spatial data required informations to restore and draw all the stored features ?thank you

In a workspace I'm writing to a gdb (api), this works fine. If i use this workspace again it results in an error: FME can't write to the GDB. Parameter "overwrite existing database" = "YES"MDB gives no troubles

Hello,I am transforming DGN files to ESRI shape using (Attached bellow). I have a problem with shared cells elements. I am transforming them to point shp but I am losing attribute NAME. I am suspecting that some of the format attributes are not checked. Any ideas how to get attribute that i need?

I am converting dataset from ESRI geodatabase to shapefile, but I am facing the domain problem how could we expose the domain , I am still getting only the code thanks

A customer who is using FME to connect to our recently upgraded database is reporting that a process for pulling data that was working before the upgrade now seems to just hang after a few minutes. We have SQLNET.EXPIRE_TIME=4 in the server's sqlnet.ora which means we check for dead sessions at 4 minutes. The FME log does not report any errors. It just stops logging and performs no more work.

Does anyone have experience getting data from Petrel Studio with FME? Any tips appreciated!Petrel E&P; Software Platform https://www.software.slb.com/products/petrel

I am trying to convert a drawing from Autodesk Plant3D to *.IFC format for consumption by a third party BIM viewer. I want to bring over as much of the intelligence from Plant3D as I can (part names, etc). When I convert from the FBX, all I get are the surfaces as a part name. If I convert from the dwg, everything is still lines. Is there an established method to get from Plant3D to IFC?

i need to classify the lidar point cloud to building alone. in las classify tool it classifies into building trees etc. how to classify only building?

I used a CoördinatExtractor and a ListExploder to get the Coördinates. I create a attribute to write the x and y coördinates in one line. Now the question is how can I create the last line whit only end?example:pnt 111223, 513248pnt 111225, 513256END

Hi I'm trying to split a series of raw point cloud files into files named by Ordnance Survey 500m tile reference, which are provided via a MapInfo TAB file. The point cloud contains X,Y,Z & Intensity. I've tried using the tiler tool, but that only splits by a certain number of rows and columns, any help would be much appreciated.Many Thanks in advance!Dan

Hi, I have a oracle spatial reader setup to read a number of tables. All the tables can read except one table and the reader stops automatically with a error message in the log - Error - Cannot have NULL value for 'x coordinate'. I tried to filter the bad geometries with a where clause like this - SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT( G3E_GEOMETRY, 0.005, 'TRUE') = 'TRUE' . That did not work either and the same error followed. Surprisingly when I used this sql statement at SQLDeveloper, it results in a set of valid records. I am not sure why FME is not able to read these valid records. Appreciate if you could help me out with this.

The idea is that an Excel document with file-paths is used for pushing updates.

The IFC reader needs to have an actual IFC file as its dataset when it's created. How can I create a reader that's able to handle any IFC file that's uploaded to the FME server?After the reader is created it seems that I can change the dataset to be given in a parameter, but I don't understand what the meaning of the IFC file given to the original dataset is.

Our team names have changed and I'd like to clean up the category names. Is this possible without recreating the scheduled jobs? Have I overlooked something simple?

If I leave it as sheet 1 all the hyperlinks work. I have multiple sheets that I will add to the excel file so this function should work fine and has in the past version. Could someone help?

Hi I want to update a view on ArcGIS Online, does anyone know if that is possible?My plan is bring in the data as a feature service and filter the data I want in the view and publish to an existing view? Any help would be appreciated

I'm trying to use views/tables from a PostGIS database that uses the encoding UTF-8, while my system encoding is ISO-8859-1 / Latin-1.It works alright until some views named using exotic letters are run through e.g. the LineOnLineOverlayer transformer, which produces a Python Unicode Error (ordinal out of range).Can I somehow specify in the FME PostGIS reader that the database uses another encoding, or should I submit this behaviour as a bug report?