Best Answers

I am using FME to convert ESRI Raster Dataset orthophotos to an .ecw file and there are some very ugly black pixels added to the border.

Im simply trying to get fme to use FileCopy (so that I can copy csv files inside a large zip file (about 4 gigs)) to a network folder. I only used a reader with format set to CSV, dataset set to the path of the zip file, and workflow options set to Individual (connected to filecopy writer). Are there any issues with fme and large zip files? Is there a better method to extracting a specific file type from the zip than what I used? Thanks for any help--latest error states: "failed to open file. failed to get any schema from reader". i am able to manually use filezila or 7 zip and perform this

I want to aggregate or dissolve a set of input polygons based on 3 fields - Authority, Category, Site_Name. So where these values are the same, there should be one output feature. If the polygons are not adjacent, a muti-part feature should be output (File Geodatabase). If they are adjacent, then I expect them to be merged. However this is not happening. I've tried both Aggregator and Dissolver, individually and together. The boundaries may not be shared, but I believe the polygons overlap, so why aren't they being merged?In the attached image, the blue fill is the input, and the hatching is the aggregated/dissolved polygons.Also, there are 2 blue polygons on top of each other in the middle, but in the output there's no polygon visible.

https://www.safe.com/transformers/kml-view-setter/I've been looking at the KMLViewSetter transformer, but when I set lat/long values in there it continues to open to the default location in Google Earth. I've tried using the values in the doc example, but it still opens to the default location.  I might be missing something - but has anyone got this to work and could help me out?FME(R) 2018.1.0.0 (20180321 - Build 18442 - WIN32

Hi,I have a workspace that makes an initial SQL database call to write to a table that generates an id key that subsequent database writers require. The problem is that the initial call doesn't seem to close/finish writing before the subsequent calls look for the id key. I have placed a feature holder before the subsequent calls but if the records fall below a certain number the process fails (and the initial table is not populated). Over a certain number or records the process is fine. Any ideas?Thanks!Sam

Is it possible to do a substring(0,10) with the BulkAttributeRenamer? I want to simulate truncating the columns as writing to shape does. I know I can do this with a SchemaMapper, this is my current workaround.

I am trying to add file reference to a job submitter from an email that come is through the notification service. The email comes in here:Resources /System /temp/emailattachments/20180323010138-tgsdata@production-tgs.fmecloud.com-test/autocad.dwgI had use the email attachments before when they came into ${FME_SHAREDRESOURCE_TEMP}/${FME_JOD_ID}

Hi, I have created some JSON in FME but would like to remove the first couple of levels.At the moment I have:[    {        "output" : {            "status" : "200",            "body" : [                {                    "well_id" : 25325,                    "well_name" : "MYALL_CREEK_3",                    "latitude" : -27.046011,                    "longitude" : 149.236806                },                {etcideally I would like to remove the "output" level[    {            "status" : "200",            "body" : [                {                    "well_id" : 25325,                    "well_name" : "MYALL_CREEK_3",                    "latitude" : -27.046011,                    "longitude" : 149.236806                },                {Could you please tell me how to achieve this.For reference my workbench looks like: Many Thanks,Oliver 

I have a Condition Statement within AttributeManager that checks if an attribute has a letter at the end of the value. If this is true then I use Substring to drop the last character.However, when I use the above it always returns the original value (ex. 999a returns 999a instead of 999).It does not seem to work with any negative number at the end but if I change -2 to a positive number like 3 it works and returns 999. Any thoughts on what I am doing wrong here?Regards

I am using a Condition Statement in the AttributeManager to check if the attribute ends with a letter. Using [a-z] does not seem to work and I am assuming it is because the test sees it as text not a Regular Expression. Is there a way to get this to work or do I need to have a Test Clause for each letter of the alphabet? Regards

Hi all,   I am using FME Workbench 2018.0 Build 18284. I would like to run an update to sharepoint list on Sharepoint Online.  Readers:Sharepoint list using (http link to the sharepoint rather than https; using https would run into an "Error message 403- error authenticating via SAML" (log-in details are correct)Excel spreadheet with new lat/lon values I am using a feature Merger to update lat/lon column in sharepoint list Writer the same Sharepoint List - when specifying the url to http://XXXX.sharepoint.com/Projects/XXXX the translation runs into a Client-side error: '405 Client Error: Method Not Allowed for url: https://XXXX.sharepoint.com/Projects/XXXX/_api/contextinfoI have not specified the above https url ending in _api/contextinfo- when specifying the WRITER url to https the translation runs into the above 403 SAML error  Do you now of any ways to work around these errors or are they possibly solely due to my sharepoint security settings?  Thanks a lot for

I’m using FME Server 2017.1.1.1 and REST API to create a repository and publish workspace into it. This is fairly straightforward. Once done, I’d like to share that repository with other users already existing on the server. Is there a way to do it via REST API? I wasn’t able to find it in API documentation.

Hi,I have a FME Server and I would like to use jobs function. But the my workbanch is not working in the fme server. Normally it is able to work from fme dekstop. Server says that there is no defined Coordinate but I have. ITRF96 was added as custom. My question is how han I fix the problem.***********************************************************FME API version of module 'NULL' matches current internal version (3.8 20170315)MULTI_READER(SWORLDSWAF_5): Done reading 0 features from 2 readersCreating reader for format: Smallworld 4/5Trying to find a BUILTIN plugin for reader named `SWORLDSWAF'Trying to find a DYNAMIC plugin for reader named `SWORLDSWAF'FME Configuration: Source coordinate system for reader SWORLDSWAF_6[SWORLDSWAF] set to `ITRF96'Coordinate system named ITRF96 does not exist.Failed to get parameters for coordinate system `ITRF96' -- No definition was found for coordinate system `ITRF96'This FME edition does not recognize the `SWORLDSWAF'

I need to Dynamically change the Port Number in Workbench from Command Line before starting the FME workbench based on the Smallworld session

I have a MIF file with no matching MID file (attributes) which is intended to store purely geometry. I am able to drag it into my FME work space but when I run, it complains that the "...*.mid is missing"  I can get around this my importing the MIF into a TAB in MapInfo but is there a way FME can read in a MIF on its own?

I'm using FME Workbench 2017.1.I have a reader connection with multiple features (tables) being read from it. One of the features (let's call it Users for example) uses a SELECT STATEMENT option to get additional information (I can run and test the select, it's valid and it works). Right before FME uses that select statement to "obtain features for feature type", I'll get a bunch of warning messages in the log output like this:WARN | Oracle Reader: Column 'ID' specified on Feature Type but does not exist in table 'SCHEMA_NAME.USERS' and will be ignoredThis will happen for all columns of Users. I can verify that the columns exist in my source table.Even with these warnings, the records of Users will be read and written to their new destination. However, every other feature type that needs to be read/written after Users (say Logins, Favourites, Friends, whatever) will give me the same warning message for each of their columns and will not write a

This is error message on the FME server.Microsoft SQL Server Spatial Reader: Connection failed. Connection string `Provider=SQLNCLI11;DataTypeCompatibility=80;Data Source=gis02;Initial Catalog=nlpglive;Integrated Security=SSPI'. Provider error `(-2147467259) Cannot open database "nlpglive" requested by the login. The login failed.However, on the desktop I almost the same error when I try to list the tables in the above databaseServer 2012 Native Client...Microsoft SQL Server Non-Spatial Reader: Connection failed. Connection string `Provider=SQLNCLI11;DataTypeCompatibility=80;Data Source=gis02\\sqlexpress;User ID=;Password=********'. Provider error `(-2147217843) Invalid authorization specification'However, when I test the connection it is OK and successfulIf I use a reader or writer I can see all the tables !Any ideas? I have tried SQL Authentication for various local and domain accounts still the same issue.

Hi all,I have used Matcher to find duplicates. It works very well. I create "_match_id" attribute to create "small groups".The problem is there, I need now to sort into these "small groups" using an other attribute called "Hierarchy" (numeric attribute). The feature with bigger Hierarchy's attribute value into this small group (based on _match_id value) will have a red color, the other will have a blue color.So, I have to compare each value into this small group, keep the highest value and assign to this feature red color.I have to do this for every small groups.Any ideas ?Thanks

Hi Team,In my case, there are multiple geometries coordinates in one json file. I need to create multiple geometries and write to shp file. Sample json file attached.in this file there are multiple geometry blocks, I should iterate thru json and create geometris.help will be appreciated

Hi,Since we upgraded FME Server a few months ago from 2016 to 2017 I've been unable to chain jobs together successfully when using the FMEServerJobSubmitter Transformer. I have two workbench's on server which need to run in sequence, the workbenches are run in sequence by creating a third workbench utilising the FMEServerJobSubmitter transformer. Since upgrading to 2017 the 3rd workbench used to chain the jobs together just hangs on server when run until i eventually cancel this?   All jobs are set to run on the same engine, it's as if the the chain jobs workbench is waiting for the 1st workbench to run, however because the chain jobs workbench is running it needs to clear before the first workbench can run!? Never has this issue with Server 2016?It's worth noting that since we upgraded from 2016 to 2017 we increased our server engine capacity from 1 to 2. I can of course set the chain jobs workbench to run on a different engine, however for operational purposes this is

I have a workspace with a dynamic writer writing to postGIS. The source for the writer is a csv spreadsheet which is loaded from a workspace resource using schema (from table). The reader reads a table named "test", and the writer outputs to a table named "Mapped". It is essentially based on this tutorial:https://knowledge.safe.com/articles/1046/dynamic-workflow-tutorial-destination-schema-is-de-1.html except that I don't use fme_feature_type as the writer table name.This is my csv source file:The columns all appear to be mapped correctly.This is the writer:This was working in FME 2017, but since I upgraded to 2018 it no longer works. I get an error message saying:Cannot find a matching schema named 'Mapped' in the known set of schemas: ''. Known schema sources are: 'Schema from Schema Feature, SCHEMA_FROM_TABLE_1'. Please verify writer feature type configuration.Then there's a message saying:POSTGIS Writer: Fanout for feature type &#

Hey AllI have been googling this and trying to sort it out for a couple days now and cant seem to get it to work.I have a table with attributes for starting and ending Chainage (10+050 / 10+100). I want to map these as linear features on an alignment. The alignment is in as a measure and I'm trying to use the Snipper:Every feature is rejected by the Snipper. If I manually input the same attributes in the Snipper Starting and Ending Locations, it works fine for that one location.Also - it appears as though the Snipper keeps the attributes for the Measure, but not the ones from the input table, which would be needed.Any help would be great - is there a better way to map chainage/station for linear and point features along an alignment?Mike

I'm writing a code to run workspaces in python but I think that I found a bug with the FMEWorkspaceRunner.getPublishedParamNames function. This function is returning the private parameters from a workspace and it shouldn't.import syssys.path.append('C:\\Program Files\\FME\\fmeobjects\\python27')import fmeobjectsrunner = fmeobjects.FMEWorkspaceRunner()print runner.getPublishedParamNames('test.fmw')The output: ['a', 'b', 'privateparam']"privateparam" is private and it is not checked as published in the workspace

Hello,please, I try to compress more conditions into XML Templater in Root template, but unfortunately desktop refuses to run up translation repeatedly, because he misses comma between conditions. But, as You can see below, comma is there?Log is below:Does anybody know please, how to correct the statement?Thank You so much!Lubo

The MongoDB Writer for fme currently does not support writing to the MongoDB array data type. I am trying to develop a workflow in fme that can write to a JSON array data type in MongoDB when the number of objects in a json array are not fixed, for example (see "alternateNames array"):{    "geonameId" : 3,    "name" : Toronto,    "alternateNames" : [         {        "alternateName" : "Toronto",            "isoLanguage" : "af"        },         {            "alternateName" : "Toronto",            "isoLanguage" : "fa"        }    ]} in another record from the source, this "alternateNames" array might be contain more objects:{    "geonameId" : 1859924,    "name" : Kashiwa,    "alternateNames" : [         {        "alternateName" : "Kashiwa",            "isoLanguage" : "eng"        },    {        "alternateName" : "Ka?iva",            "isoLanguage" : "eng"        },         {            "alternateName" : ??????,            "isoLanguage" : "ar"        }    ]} If there is only one object in