Data

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?

Hi,I have files of xyz format that would want to clipp off the scope of the polygon. The output format should be the same as the input xyz. The problem is that I need help in defining the output file.Formatting (the gap must be between the coordinates and should be one below the other, the precision one - which is also the input file.). Input file.xyz320000.0 5020000.0 1257.8320025.0 5020000.0 1257.1Output file.xyz320050.0 5020000.0 1254.0320075.0 5020000.0 1244.6

How can I create CityGML from shapefile included polygon with z value ? I have tested all suggested method here but not working

I have an input DWG file and I need to make some changes to some layers and write these layers to an empty output file, but with the name of the predefined layers. A good example would be to say that the data in my input file will fill an empty output DWG, this DWG file has only the layers and their names, there is no geometry. How can I do this? Thank´s

I am currently using a fme Cloud-instance without the PostGIS database. I never saved the credentials of the PostGIS database because i have my own dedicated database. This is why i never saved the credentials text file with this information (security risk). You can guess what happened... I changed my mind and would like to test the PostGIS database in my current project as a temp database so i can process intermediate results faster. I know that you cannot redownload the credentials file but is there a way to reset the whole PostGIS database and generate new login information for the database? (superuser for the server itself needs to stay intact) No data is in it so i do not mind that is completely reset.Because you cannot download it again:WARNING: Do not lose this file. Once you have downloaded this file you cannot download it again, and there is no way to retrieve it.https://docs.safe.com/fme_cloud/FME_Cloud/Content/About_Instances/Connect_to_Web_UI.htmhttps://docs.safe.com/fme_c

I am trying to write from a sql database on one server to another sql database on another server. The first feature writer works fine but I am getting an error message"Microsoft SQL Server Non-Spatial Writer: Failed to start database transaction. Provider error `(-2147168237) Cannot start more transactions on this session.'A fatal error has occurred. Check the logfile above for details" with the when the second feature writer tries to write.

I do have an huge point cloud which I have to divide into several tiles with an maximum number of 10000 coordinate per tiles. I try to find an solution by using the Tiler or the PointCloudsplitter Transformer, but there was no way to solve my problem - as fas as I understood the transformers.