Best Answers

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

Hello thereI work with polylines in an ESRI Personal Geodatabase and want to shorten every polyline by distance using the Snipper. But for certain features there are more than one remnant. I guess, the reason is because features consist of Paths. Do I have to split Paths first and then use the Snipper for Lines and Arcs separately? Thank you for every hint.

It is possible to upgrade the fme esri edition version to the database edition version? What are the costs?

The Dashboard data is great for seeing patterns over a period of 30 days but if the period were extended it could provide other information too. For example, "how long has it been since a certain workspace has been used?" That would identify FME scripts that are no longer being used.It would be easy to build something that would store the daily data better than the current CSV files, for example, a SQLite database, and then build reports off of it. However, I'm wonder if Safe has something like this in the works already?

What is the earliest version of FME that is compatible with Windows 10? When did support for Windows 10 become official?

I can't figure out how to use a mongodb writer to update existing documents (specifically, I want to insert new elements in a list within the existing json structure)  I don't even see any parameter to set the writer to update or upsert.

Found no transformer or question on the Knowledge center so here is my simple question: Is there a possibility to realize something like a SolidOnSolidOverlayer that does an intersection of incoming solids and just outputs the intersecting parts of the solids? Just tried to do that with the CSGBuilder but I think this transformer just outputs the solid features which are completely within another solid.Also visualized my expected result in 2D (the red solid is the intersected solid I wanto to get):

I scheduled a job to run, but say when the job is scheduled to run FMEServer is off (someone turned off AWS instance). Will the missed scheduled job run when that AWS instance with FMEServer is turned back on? Is it possible to set up FMEServer try to run all missed scheduled jobs on start-up? Or can FMEServer alert us to which scheduled jobs were missed?

Hi,I was trying to submit job in FME server and it just throwing it in to queue. while I am troubleshooting the issue I have noticed there is no engine listed at Engine Management page I am wondering why??Ihave tried to fix the issue by restarting all FME related service manually and didnt work.Any suggestion? this is production environment ?thank you

I have database and web service connections set up in FME Options - where are these connections stored on a Debian or Ubuntu system?

Hi all,I am doing my first steps with FME.I am trying to parametrize a CSV reader as follow:But parameter is replaced by its value:How to do this? Many thanks for your help!

I am trying to create xml files for metadata with the filename of a gdb forming part of the xml output filename. The fanout expressions are: @Value(gdb_name)_gdb_metadata.xml@Value(gdb_name)_lidar_metadata.xml@Value(gdb_name)_imagery_metadata.xmlHowever, this creates two xml files per output, one empty but with the correct filename, and one without the @Value(gdb_name) but with the correct content. I have tried to feed in the @Value(gdb_name) earlier on in the process but this does not work.

Attempting to edit a workbench file this morning but the file in question won't open.  Choosing file->open and selecting the file does nothing - no error, workbench remains blank, wording in title bar still displays Untitled - NONE, file name isn't in the list of recently open files.  The script itself works fine and runs daily via a .bat file  We have upgraded to the latest service pack since I last looked at this file but it only seems to be this file that is affected.  Is there anything I can try to get this file to open up in workbench?   

Reading a WMS using Feature Reader WMS, search envelope based on an bounding box "Envelope Intersect", however the resulting Image is just the overview image, how can I make sure i get the image clipped to the best resolution per the bounding box?what I have tried alreadyensured coordinate systems are the sameattempted to use ImageFetcher, no luck with querying based on coordinatesverified the WMS is ok, by viewing in OpenLayersAny help would be great, Thank you ;)

I am getting the following error,when trying to write all the NITF attributes to the PostGIS table.Bulk copy failed on table 'public.EGPL' using delimiter ':'. Error was 'ERROR: value too long for type character varying(4)CONTEXT: COPY EGPL, line 1, column nitf_fhdr: "NITF02.00"'A fatal error has occurred. Check the logfile above for details... Last line repeated 2 times ...FME Session Duration: 3.2 seconds. (CPU: 2.0s user, 0

I'm very new with FME and there's a few things I cannot get to work.I have a feature with an URL as an attribute and it's like this: http://serverName//document?searchText="section3"&start;=1&max;=1&f;=pjsonI want to read the JSON in it with it's attributes (which I don't know) separated to do something with them.I've been playing with some JSON transformers like JSONFlattener and so on, but I can't get the JSON.Any idea?

Hi guys,I have a problem loading arcgis layer to the workbench. After licence is checked out, I've got a pop up error 'FME has checked out an Esri license. The product checked out is 'ArcInfo'. Error occurred while attempting to open the dataset 'C:/Users/Downloads/Albian.lyr'. Did you come across this error before?Kind regards,Aleksei.

Hello,I want to create a workflow that will monitor updates to tabular SQL Servers tables, which would send email notifications when my workbench has updated "error" tables. My workspace is effectively processing data and writing these error tables. But I am unsure of the best way to create database "listeners" that would note when new data has been added to an error table and then send out an email notification via FME Server. We have FME Server up and running and it does send email notification for when the workspace fails to run. But we have never sent email notifications for when a SQL Server table has been updated. Can anyone provide some suggestions on how to best do this with some links and possibly an example work bench that "Listens" for database updates?   Thank you!

I am trying to add a custom transformation using a NTv2 grid shift file.I have defined this .fme file in \\Documents\\FME\\CoordinateSystems\\ :XFORM_DEF Stereo70_to_ETRS89_NTV2 \\  SRC_DTM PULKOVO42/58 \\  TRG_DTM WGS84 \\  DESC_NM "Stereo 70 to ETRS89 using grid shift file generated from TransDatRo grid" \\  GROUP Romania \\  INVERSE Yes \\  METHOD GRID_INTERP \\  GRID_FILE NTv2, fwd, .\\GridData\\Romania\\stereo70_etrs89A.gsbNow FME wont start. I get the error mesage: Xform 'Stereo70_to_ETRS89_NTV2' contains invalid GRID_FILE value of 'NTv2,'

I am trying to compare and update a field in a table. I have several tables from sde that require a date field to be updated. This worked in an earlier version of FME. In the workspace I brought the tables in and duplicated on writer. In the latest version of FME I get the following message:"Using ArcSDE Writer to write Spatial Database Engine 3.0 dataset `gis'ArcSDE Writer: Connected to version 'SDE.DEFAULT'Writer `SDE30_2' of type `SDE30' using group definition keyword `SDE30_2_DEF'Required columns 'GlobalID, ' not specified for predefined table 'SDE.SWGRAVITYMAIN'. Using Definition from DatabaseGrid size 0 (-6) for table 'SDE.SWGRAVITYMAIN' doesn't match that specified in mapping file (0)Existing SDE table 'SDE.SWGRAVITYMAIN' allows the following shapes: SDE_NIL SDE_LINE SDE_SIMPLE_LINE SDE_MULTIPART . Shapes specified in mapping file for table allows: SDE_NIL SDE_POINT SDE_LINE SDE_SIMPLE_LINE SDE_AREA SDE_MULTIP

Hi Team Fmeiers, I wanted to change the publish parameter value in fme server for each run. for example existing system we have is:fme desktop,in my fmw file the buffer value is published. and every time i run thru batch file, i can change the buffer values by editing batch file.fme.exe c:\\temp\\create_road.fmw --buffer 50fme.exe c:\\temp\\create_road.fmw --buffer 100fme.exe c:\\temp\\create_road.fmw --buffer 150here the bat file calls the same fme workspace three times with different buffer values.calling this batch file windows scheduler , three different time intervals.  upgraded to fme server 2017Now, this fmw file is published in fme server and this job is scheduled in server three times a weekhow can I achieve the same task using fme server.  your help will be appreciated.