General

I need the operations to work in the following order:TerminatorDatabaseDeleterData Load (rest of workspace) I tried using a WorkspaceRunner transformer, having split out the three functions. It works fine if I'm in FME, but if I try to run it using a batch file, it errors out. Ultimately, I want to be able to schedule this through Windows Task Scheduler to run nightly. It will compare the last updated date between two datasets, and terminate if the destination dataset is already up-to-date. Otherwise, it will proceed to delete a subset of the destination dataset (a "partial truncate" for lack of a better term), and then re-load the new data.

I am new to FME Desktop and experimenting with downloading a feature from a Map Service hosted on an ESRI ArcGIS server. Is there a way to enable the "return_true_curves=True" when downloading the feature to a local FGDB. I have everything working using a Reader pointed to the map service; however, FME is converting the true curves to simple curves when reading or writing the data. I am able to download the feature using a query and the ArcGIS REST API in python to get a feature with two point curves to a FGDB. Would like to do this directly in FME.

Hi how to avoid to repeat 3 days of data read after a translation failed? Seems the temporary folder run out of space. Can I swap the temporary location and restart the process from certain point instead of starting again from the begin? Alex

This morning all of my FME workbenches failed to open and I get an exception breakpoint application error. It says (0x8000000003) occurred in the application at location 0x00007FFAB8D6293. The only option is to terminate the program. Any help would be appreciated. Thank You. 

Hi All, i have been banging my head against this for a while. Im trying to parse an api call response I get ( XML returned) . I have tried Flattening it. I have tried Fragmenting it, I have tried swearing at it. None of the things I have tried have worked. I don't really understand how this data is structured. Its nested I think, with something like tuples??? there is a Name, Number and Text for each attribute?? Any help or direction appreciated. Happy to learn. I'm trying to return the "number" value of NZTM 2000 Northing and NZTM 2000 Easting as attributes... Many Thanks for your suggestions.

I am trying to parse an SLD file (which is XML) and generate a CSV output based on the rules within it. The following is a sample of the SLD structure <?xml version="1.0" encoding="ISO-8859-1"?><StyledLayerDescriptor version="1.0.0" xmlns="http://www.opengis.net/sld" xmlns:ogc="http://www.opengis.net/ogc"xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://www.opengis.net/sld http

I have geotiff tiles and some need te be partially blurred, because of military terrains.  I mainly use the rasterresampler to resample the pixels in those area's to 3 meters and then resample them back to their original pixel dimensions.  The problem as you can see in the picture is on the edge.   The black edge is 1,12 meters, so the resampler doesn't have the space to make another 3x3 cell there, so he doesn't.  How can I solve this? I had the idea to make the geotiff tiles canvas bigger (see picture), let it resample and then clip it back with the bounding box of the original tile.But I don't know how to make the canvas bigger.    @Takash

I am trying to generate a JSON message to update editing templates on an AGOL Feature Service. I've got most of it complete. I am having trouble with the last piece though.  Each Editing Template has a list of fields and defaults like this: I am trying to generate 27 unique editing templates based on unique pairs of 2 attributes. The portion of the JSON text I am struggling with is the ["types"]["templates"]["prototype"]["attributes"] section. I have the correct number of "types" (27). I have the correct fields and corresponding default values.  As you can see, I am getting an extra pair of "},{" between each field as co

Hi, I'm new to MongoDB, and I'd like to use FME to import data into it. Can someone please provide me with an example that shows how to set up the connection, specifically the connection Name, Connection Type, Protocol, Host, Port, Database Name, Name and Value parameters? Harry

Hi team, While transforming the tables from Reader ArcSDE to Writer ArcSDE . At the Writer end, didnt write any features and getting following error."3.1| 0.0|ERROR |Could not unregister GlobalID column 'GlobalID' in table 'DBO.Publish_Test_Cables_2'. The error number from ArcObjects is: '-2147215875'. The error message from ArcObjects is: {Table is already locked [TCS_TEST_PUBLISH_SYNC.DBO.Publish_Test_Cables_2]}" At Writer end, follownig parameters are used.1.Preserving the Global IDs parameter with Unversioned ArcSDE table 2.Trasaction type is "Non-versioned edit session" Highly appreciate for the solution!! RegardsVIPLAW

hi,I want Conversion   osgb to obj .when Multiple osgb to one obj ,how Merge textures image to one

Hello, I'm doing the unit "Publish your Self-Serve Workspace to the Web" as part of the training "Integrate Your Data with the FME Platform". That unit tells me to change the parameter "Destination Generic (Any Format) Folder" of the writer, to a location on the FME Server. If I change that parameter to the FME Server, and run the workspace locally, it seems to store the output in the same folder as the workspace. I would like to store it in a different local folder when running locally. That way, I can use the same workspace both locally and on the server. Is it possible for the workspace to detect if it's running locally? If so, then I can configure it to save to a specific local folder. If not, I can configure it to save to a specific FME Server folder. So far I've tried:Log File. Potentially the workspace could see if "FME_HOME is 'C:\\Program Files\\FME\\'", which i

I have a workspace that reads a database table (no geometry) from a file geodatabase from an on-premise subnet server location. When running the workspace from a Desktop VDI, I get read speeds of ~10K every minute or so. When running the same workspace on Server, I am getting speeds of ~10K records every 6 minutes. I tested to see if the location of the FGDB was the issue by uploading the FGDB as a server resource which resulted in the same slow reading speed. In my experience, Server has always been much faster than Desktop. Has anyone come across this issue?      

Hi! This is a general question re: what's possible with FME's SDE capabilities. We have some automated processes whose SDE readers take in large amounts of data, and they take a hit whenever they encounter corrupted or missing indexes. We are considering setting up some 'helper' processes to examine the indexes separately before the data is read in the main workflow. I know, for example, that there's ArcPy methods such as ListIndexes that can be used to check some of their properties for any given feature.  I'm wondering if FME can natively do something similar and without, say, calling ArcPy through a PythonCaller? Are there any exposable parameters or validation tools (or does anyone have an approach) that could be used to examine the SDE's spatial and attribute indexes and flag problematic ones? Thanks!

Hi all,When I try to replace "back slash" in a directory path to "forward slash" it works in all but the last occurence. Tried with Regex as well. Since I'm passing the path to a PythonCaller where I have to use double forward slash I get output similar to this: "C://Folder//AnotherFolder//3rdFolder/lastfolder".  I tried using AttributeSplitter and ListConcatenator and use // as delimiter. The output is the same and the last occurence doesn't have double forward slash: "C://Folder//AnotherFolder//3rdFolder/lastfolder". Is there some fundamental logic to this I'm not familiar with or is it a bug?Also I run the 2021.2 Beta, don't know if it could have anything to do with that.  Thanks!

using FME Desktop, i have a workspace that looks at two databases and generates a csv with information from one database that is not found within the other database. i need to then send that csv file to someone via an email, however, the csv file contains 11k rows and the emailer is trying to send 11k emails. how do i send one email with the csv as an attachment?

i want to create a tool that digest real time traffic layer from Google map. So is there anyway legally that FME can export this layer into raster or shp file to be used in my tool? Thank you

It's quite possible I'm missing something rather obvious here. But I can't figure it out. Funny how when searching the web what I stumble upon is my own post from a year ago. What I have put together since is a workspace that reads CSV and spits out JSON. I've published this to FME Server (2020.2) and selected "Data Streaming" and "Job Submitter" as services. Now, I'm sending a CSV file from a web page to FME Server using some of the examples here, and effectively calling the workspace with a Javascript line like this:FMEServer.runWorkspaceWithData( repository, workspace, params, callbackFunction);This works gr

ArcGIS Pro has this geoprocessing tool "Multipatch to Raster" to convert multipatch (3D) vector data (shape file or geodatabase) to rasters. Does FME have this functionality? Seems to me the few rasterizers in FME only handle 2D data. I am at FME 2021.1.1

I am using Bufferer to create a 4 foot buffer around right-of-way polygons. The tool works for 99 percent of the areas but I am getting a few random missing polygons as shown in the screen-shots below. I did find if I change the Buffer Distance one area will generate correctly; however, the issue occurs somewhere else. Areas: Buffer with missing polygons:Any Ideas how to fix this. Buffer works fine in ArcGIS for the same features.

Hi Community, I am trying Attribute reprojection transformer in FME to convert New Zealand Transverse Mercator Projection (NZTM) coordinates into WorldGeodetgic System 1984 (G1762) as per the attachment. However it is not showing my location of interest in my GIS software. Any suggestion on this. Regards, 

I have a workspace which uses input user credentials to do stuff. I also want the workspace to work during testing by using System environment variables. This is working great for things like DBNAME, HOST, PORT etc where the user inputs are strings (text user parameters). I can simply just enter in ${PORT} for example and FME will look for a set environment variable. Where I'm having trouble is with the password. I can't do the same thing for the password so I've created a simple scripted parameter which first checks if there is a user password set and if not try and see if there is an environment variable. In most cases it works well, however, I've discovered that some special cahrachters are getting encoded by FME - So something like @ becomes '<at>'. Does anyone know a way to 'decode' these encoded strings. Ideally it'd be done in the scripted parameter, however, if it has to be done in the workspace so be it.Short from using

Hi I have a lot of small geotif tiles. I need to mosaic them together as geotif in specific zones.  I tried the standard compression which is jpeg. The problem is that some zones are to large for the compression method. I get this error: "GEOTIFF writer: Failed to write the output file using JPEG compression. The raster is being written with a tile size of '29005' rows by '82874' columns, whereas the maximum number of rows or columns that JPEG compression can handle is 65500. Please reduce the tile size if writing a tiled file, or reduce the size of the raster" So I'm thinking I only need to change the compression method. I tried all the other compression methods and I always get the same warning: "GEOTIFF writer: Existing value for creation option 'INTERLEAVE' was 'BAND'. Overwriting with the new value 'PIXEL'GEOTIFF

Basically I need to create new edit version from sde.default and need to compare one arcsde geodatabase layer(copy layer) to another layer (source layer). Any changes in the source layer will be written to the copy layer. Copy layer is a versioned layer and the source layer is not versioned.

I remember a demo/webinar about FME Server showing workspaces exploding in VR/AR - but can`t seem to find it. Anyone?