Data

I have two separate Oracle clients on my machine. When I create an Oracle reader or an Oracle writer, it defaults to whichever Oracle client is first in my PATH variable. Is there any way to tell FME to use the other Oracle client?

Dear Community, Last year I created a very large FME Workspace that became even larger in time as new feature requests came in while there was no time to restructure the FME Workspace. At the end the FME Workspace had more than 1300 Transformers and FME Workbench had trouble to open it. (The file was 25 Mb large.) Moreover development work became slow as I had to wait about 10 seconds every time I clicked within FME Workbench. Fortunately I convinced my client to restructure the FME Workspace and now there is time to do just that. With an upgrade of the FME Server from 2016 to 2018 it becomes possible to make use of Parent-Child-relationships. Hence no additional engines had to be bought and that made it possible to reshape one FME Workspace in two FME Workspaces. Unfortunately I was surprised that if I ran the Child FME Workspace alone (which is in that case by definition no Child) a File Geodatabase could be read. (See job 274 in the screenshot below.) If I used however a Parent FME

Hi, Im trying to Convert a DFX file to a GDB. The CAD file is a repesntation of a Piping System. The conversion runs successfully but pipes that run vertically (along x axis) loose their shape length. For the Reader in the format attribute tab: autocad_color, autocad_entity, autocad_layer, fme_attrib_info{}.field_value are checked. I'm using FME Desktop 2014, AutoCAD 2013, ArcGIS/ArcScene 10.1 The DFX is 2007 Format

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 files 2nd best would be solutions to the Python/ArcPy errors I'm getting when running ArcGIS geoprocessing tools 3rd 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

Hi folks, I have a workspace that reads in an Excel file joins it with a KML file to Georeference the entries uses an AttributeManager to keep just the values from the Excel file writes the output as a KML file Most 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], [Created

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 regards Salwan 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 you Best 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 upi When 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 - win64 ArcGIS Online Steps 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 Client E

Hi, I'm trying to write to an ArcGIS SDE database in PostgreSQL. I have: FME Workbench 2018.1 64 bit ArcGIS Desktop 10.4.1 ArcGIS Desktop 10.4.1 Background Geoprocessing 64 bit ArcGIS 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.92042276752 B 7175381.1634021383 C 2829 D 388 What is the best way to approach this? So far, I tried unsuccessfully using attributesplitter, substringextractor I 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.742227288) (1660,1784) Label "Pt 5", (468758.97137093107,7175297.6046

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?