Data

Hi,  I can't seem to read layer descriptions from DWG files. I have tried different versions of FME, different reader settings and different DWG types with the same result.  It does seem to read a few of the layer descriptions but I have no idea why it would differentiate them as they seem identical when I open the files in AutoCAD.  Has anyone had the same issue?  Thanks!  

I have an elasticsearch instance that requires a password for writing. Am I understanding this correctly that FME can't write to a secure elastic search?

Hi,I don't find out if there is a rule to manage the execution order between a SQLExecutor and a Postgres Writer.I want that the SQLExecutor is executed before the Writer because it makes a backup of the table before writing.And I can't use the "SQL to run before write" field in my writer because I use feature values in my SQL instruction and this field doesn't handle feature values. The strange thing is that in one of my Workspace the SQLExecutor is executed before the writer and in another the Writer is executed before the SQLExecutor (the second one handles far more data).I tried to change the horizontal and vertical order of both but that doesn't change anything. Thanks for any help,Christian

Hi, I need to set color for Lod2Geometry features (vegetation) to create city GML. Please find the snapshot of the workspace. I am able to view the color in FME inspector but not in FZK viewer 

Following is an example I am suffering from now, just don't know how it could happen and the solution for us so far is just to manually move impacted columns back to the right position, which is stupid of course:1. Columns (Latitude and Longitude) are at the begining of the excel file:2. After imported into the FME, the order of these two columns (Latitude and Longitude) changed and moved to the last for no reason:

Hi,I have a 3D polygons file that I would like to convert to obj format. I tried several times but I always have one polygon in the output that is strange.any advice or idea?thanks!

Has anyone experience with moving data to/from ArchiCAD (https://www.graphisoft.com/archicad/) ? Seems to be easiest to work with IFC or SKP for buildings. But havent found the easiest way to work with terrain-data for import/export yet. It seems incapable of importing terrain-data without generating the terrain all over again - but that might be just because I dont know the software :)

Hi all,I'm the version FME 2018 build 18284 Windows and when I write the name of transformer ProjectWiseConnector, doens't show Help information.Whats is the reason?Thanks,Danilo

Our script log files say INFORM|ArcSDE release: '10.0'. Underlying database: 'Oracle' We are running SDE 10.6.1 and our SDE.VERSION table shows the database as 10.6.1. I am wondering if there is something in our geodatabase that hasn't been updated correctly.

Question: Is it possible to have FME write .ovr files with a GeoTIFF (Georeferenced Tagged Image File Format) writer? The Solution I am hoping for:An FME solution for writing .ovr pyramid files2nd best would be solutions to the Python/ArcPy errors I'm getting when running ArcGIS geoprocessing tools3rd best would be another plan for writing .ovr files.My Software:Safe: FME(R) 2018.1.0.3 (20180926 - Build 18552 - WIN64)Esri: ArcGIS desktop 10.6.1 version 10.6.1.9270 with Background Geoprocessing (64-Bit)Basic Background:I am developing a process for a couple thousand tiff images that will be used in ArcGIS (it's not relevant but I'm using a parent workspace with WorkspaceRunner to run this child workspace). Ideally my FME workspace would write GeoTIFF images with pyramids in a format read by ArcGIS (apparently its an .ovr file), that way the features written are a final product for use in ArcMap. The Issue I am having:My problem is that I am not able to get the GeoTIFF writer's "Generate

Hi folks,I have a workspace thatreads in an Excel filejoins it with a KML file to Georeference the entriesuses an AttributeManager to keep just the values from the Excel filewrites the output as a KML fileMost of the attributes end up as blank/missing.Does anyone know what is happening and how I fix this?Thanks in advance,Ian

Hi,Each time I tried to read an SQL database and include a where clause statement in the reader the FME was fails to do so, even when I tested the statement it was running successfully see below.Does any one know how could id solve this error? The error as the following:2018-11-22 16:31:29| 1.8| 0.0|INFORM|FME API version of module 'VertexCreatorFactory' matches current internal version (3.8 20180604)2018-11-22 16:31:30| 1.9| 0.1|ERROR |Microsoft SQL Server Non-Spatial Reader: Query failed, possibly due to a malformed statement. Query Text `SELECT [BBSId], [ID], [Entity/Observation], [Observation Date], [Observation Type], [Severity of Observation], [Performed By], [EmployeeID], [Person Observed], [CONT_SVC_PROVIDER], [Not Listed], [CONT_SVC_PROVIDER_Name], [Name_Third_P_Inv], [Group Type], [Safe], [At Risk], [Description], [Longitude], [Latitude], [Location], [OrgAxisId], [Reference], [Workplace Activity], [Offline_CONT_SVC_PROVIDER], [Behaviours], [Company], [Platform], [Crea

Dear Sirs, I would like to extract elevation from a KMT or KMZ file from Google Earth! to use them in Autodesk Civil 3D (to DWG file).Is that possible? I was looking and reading about the Google files inside the FME Knowledge center, but I couldn't find any topics which lead to the answer to my question!I am very new to FME and this is my first time to use FME. I hope someone can help me with it. Thank you so much for your attention and your help.Wishing you a wonderful day.Kindly regardsSalwan Abbosh

Hi everyone. I'm writing a dwg file from an excel sheet and i would like to know if it's possible to select/change the visibility state in a dynamic block. I can create the blocks but they all came out with the same visibility (the first in block visibility list).Thanks

How to cut a uniform distance of 1 km from the right coastline DEM below? please help

FME seems to disable linetype generation by default when creating dwgs. Is there any way to enable linetype generation?

Hello,I create the feature class il a gdb automatically every night. I need to fill up the item description in the same time. Thank youBest regards

I'm trying to write postgres data from to a new schema. The table I'm reading has a unique constraint on two columns like this: CREATE TABLE public.real_right(    share_numerator smallint,    share_denominator smallint,    upi character varying(50) COLLATE pg_catalog."default" NOT NULL,    party_id character varying(100) COLLATE pg_catalog."default" NOT NULL,    is_deleted boolean,    CONSTRAINT "PK_REAL_RIGHT" PRIMARY KEY (upi, party_id))WITH (    OIDS = FALSE)TABLESPACE pg_default;If I take a look at the reader it shows me only a primary key at upiWhen I use Table definition: Copy from Reader ...Then the bulk data load fails because of the primary key violation.So the question is: Does the postgres reader supports multiple key constraints?And is there a workaround?thanks in advance

Hello,Some strange thing is going on in fme server. Sometime Web Connection is working and some time getting failed.Product Used :-FME Server 2018.0.1.1 - Build 18312 - win64ArcGIS OnlineSteps I have used to setup communication between FME server and AGOL.1. I have created app in ArcGIS online and taken its Client id , Client Secret & registered my fme server redirect uri there.2. Created my own web service from ESRI ArcGIS online and updated Client id , Client Secret & Redirect Uri ( ).3. Created new Web Connection using above Web Service.Then test it and authorized it. 4. Created new workbench which uses AGOL feature reader and used above web connection to communicate(after checking in desktop upload to FME server with my authorized web connection).5. Re-authorize web connection in FME Server 6. Scheduled Workbench for every 30 minutes. So here is the problem my workbench sometimes work ok and sometimes it is getting failed (error - Python Exception <HTTPError>: 401 Cl

Hi,   I'm trying to write to an ArcGIS SDE database in PostgreSQL. I have:FME Workbench 2018.1 64 bitArcGIS Desktop 10.4.1ArcGIS Desktop 10.4.1 Background Geoprocessing 64 bitArcGIS Pro 2.2 First, I got this error:Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216028'. The error message from ArcObjects is: {No SDEHOME environment variable set} I solved this by setting the SDEHOME variable to C:\\Program Files\\ArcGIS\\Pro, so that the 64 bit SDE dll's can be found.But now I get:Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147155644'. The error message from ArcObjects is: {Cannot connect to database because the database client software failed to load. Be sure the database client software is installed and configured correctly.} The 64 bit PostgreSQL client dll's are in C:\\Program Files\\ArcGIS\\Pro\\bin, but I'm not sure how to instruct FME to use these.

Hi FME experts,I have a number of text files that looks like this (attached). I would like to extract the numbers and store them into different attributes to process them further.A 468832.92042276752B 7175381.1634021383C 2829D 388What is the best way to approach this? So far, I tried unsuccessfully using attributesplitter, substringextractorI tried wresting with regex For instance, the following expression returns \\((.*)\\,everything in between the first ( and the last , but how can I extract each string separately?Many thanks in advance. !table !version 300 !charset WindowsLatin1Definition Table File "a2.jpg" Type "RASTER" (468832.92042276752,7175381.1634021383) (2829,388) Label "Pt 1", (468991.81894034828,7175225.3923977558) (4127,1684) Label "Pt 2", (468917.96947360213,7175142.166946603) (3520,2370) Label "Pt 3", (468878.98707272188,7175056.807626294) (3195,3063) Label "Pt 4", (468691.66407155019,7175209.7422

From reading one Oracle table I'm inserting entries into two other tables, and they should be farther-son related based on the ID-primekey field.However, I can only insert the farther entry. When inserting the son entry containing the relational ID of the farther, FME says, it's missing (or maybe not committed yet).This must be a common known problem, so can anyone help?

Hello,I am trying to convert several CityGML models to FGDB. While I have been able to convert more than half, by using the same workflow and changing nothing, there are some particular models that the translation fails, without any real explanation from the log, as you can see in the attached figure. I do not create or use any OBJECTID attribute and the Writer's User attributes do not contain it by default. As I said, I am using the same workflow for all models and I have successfully written the rest of them. I realize this is not very enlighting information, but this is what the Log produces.  Any ideas appreciated :) Kind regards,George 

Hi there,I've started to play around with the CAT (column aligned text) reader. Is there a way to specify column definition using another text or csv file instead of hardcoding it in the reader?Any advice would be good.Thanks,W

I'm updating FME server to 2018 and I find no way to get access to all schedules in general. If another user creates a new schedule I need to get in to the security settings to get access. Is there no way to always see all schedules created?