Authoring

I have an OracleDB table with the following varchar type column.This looks like json but is recognized by fme as string type by default.  I want to enter this column in mongodb in nested json format.I want it to be entered in the format below.Can the fme workbench do this?

I would like to search a string for the text (example HIGHWAY1 & HIGHWAY6 or HIGHWAY11 and replace it with 1 HWY & 6 HWY or 11 HWY)

So in the hopes of better managing the scheduling of FME jobs and while dreaming of creating a dataflow diagram for all my FME pipes, I've started mapping out all data sources and data targets across all my workspaces. I had high hopes for the Workspace Reader because it offers a ton of meta data. But even after trimming down and flattening some of the data to get only Source, Target, Workbench Name, Dataset etc., I realize this only documents proper readers and writers and NOT any SQL Creators/Executors... or am I missing something?On another note, has anyone, has Safe, built something usable that does this? A workbench I can point at a collection of workbenches to parse out ALL source/target databases ? Any suggestions or redirects appreciated.

I'm running into issues with ageing workbenches that are running as workspaces on FME Server. Most of these I did not build, many I've never published, some I've had to republish to make minor configuration changes. But I've not made any effort of somehow bringing them all up to the same "standard". Currently, I'm also still on server/Desktop 2018.I'm familiar with the ability to upgrade readers/writers in place when upgrades are available. But is there any guidance for keeping a clean house with regard to your portfolio of workspaces? I'd like to avoid having various workspaces of different vintage, i.e. created in different versions of FME. But I'm reluctant to just update every reader/writer and republish out of fear I will break too many things.Any guidance, or list of caveats for said approach would be helpful. - THANKS.

Hi Guys,any easy one for you i thinkI have an ACAD template dwg file, but i don't Need Always all layers in the Output (only those which come from the Reader)is there a possibility to handle that ?this template file has also Layouts included….can i also decide if the Output should Keep them or not? Thank you and greetz and stay safe!! (isnt that a cool statement anyway)Franco 

I have added a user parameter type "Choice with Alias (Multiple)" to my workspace that I ultimately want to be used for exporting selected GIS layer within an area, out to a CAD file. I was able to create the parameter and when I trigger the workspace, it asks me what layers I want to export, which is all great; however, any time I select more than one layer, and try to run the workspace, I get an error as follows:An error occurred while attempting to open the table, feature class or relationship class 'GIS_SDE.RoadArt GIS_SDE.RoadCol GIS_SDE.RoadHwy GIS_SDE.RoadOthr'. The error number from ArcObjects is: '-2147216057'. The error message from ArcObjects is: {Invalid parameter value passed to function}It appears that it's attempting to push all selected layers in as one value/layer. Do I need to somehow add commas somewhere so that I treats each item selected as separate? This seemed to have worked fine in desktop 2019, but I noticed that it broke last week

I think we're pretty much 97% through an installation of FME Server in production, but we can't seem to login. When we checked the log files, it seemed to point to the Job Queue not starting up properly. There's also a redis process that seems to be running that shouldn't be? Any help on this would be greatly appreciated, Thanks,Van

Hi there! I have an FME Workspace with two dynamic readers for two data sources with different schema names (or no schema name at all). As the content of both data sources use a very similar data model, with only the schema name different, it would be user friendly to select the feature types only once using one Published Parameter called "FEATURE_TYPES" and not to have (as I have now) two Published Parameters called "FEATURE_TYPES_1" and "FEATURE_TYPES_2" For example: in the File Geodatabase the fme_feature_type has the value "pGreen". In PostGIS the fme_feature_type has the value "Name_schema"."pGreen". Now I select twice the same objects using two separate Published Parameters . Is it somehow possible, within one FME Workspace, to use a single Published Parameter "FEATURE_TYPES" to read both "pGreen" and "Name_schema"."pGreen"? Is there a trick?

Hello! I am working at the moment on several FME Workspaces that can process data with as little manual manipulation as possible. In general just a file is selected, and from the data and its schema, automatically whole schema's in databases are created, filled, and further processed for further use. Obviously dynamic readers and writers are used. Now I have a Challenge to recognize existing objects based on spatial relations, new data and existing data from a central database. There are several approaches here: 1. to compare geometries on basis of coordinates. A SpatialFilter could give for example possibilities there;2. to do a fuzzy selection under the asssumptions that (point) objects in the field survey have been recognized but may not have exactly the same position. A NeighborFinder could here for example give solutions there. In an inital approach I tried to use the SpatialFilter and NeighborFinder and to use the "Group by"-functionality using the attribute fme_fea

I was attempting to read a input data list, which along with the dataset path, has some formatted instructions for translation. One of these instructions is the reprojection of attribute values in two columns. I am reading the instructions for the attribute reprojections for the dataset from a value such as this:  I was then reading values into fields, so that I could use them in the csmapattributereprojector as follows:  At this point, FieldNameX has the value of 'Easting', and FieldNameY has the value of 'Northing'. (Just at present, I have hardcoded the source and destination coordiante systems, not attempting to read them from the input, but just choosing them in the input dialog of the csmapattributereprojector).I am using a dynamic schema, so at this point the attribute{1}.name has value of 'Easting' and attribute{2}.name has value of 'Northing'.  My problem is that the csmapattributereprojector does not seem to be reprojecting the values. I have

Hi there, is there any way how to automatic connect all features from AttributeFilter with (each) StatisticCalculator?or maybe any other Idea? I do not want to do it manualy, because the AttributeFilter has about 400 features. Thanks

I have a workspace that I'd like to dynamically write different output formats to: shp, sqlite, fgdb, and AGOL. I have no problems doing it for shp and sqlite but when it comes to fgdb I’m having an issue.One of my data sources - features - has multiple destination feature classes by featureClasssName attribute. The attribute schema for all features are the same but their fme_geometry are different.That is where my problem lies with the file geodatabase api writer.If I make it dynamic, the feature type name parameter changes to default fme_feature_type. If I uncheck the box for dynamic, I can use the featureClassName attribute as feature types parameter but there is no dynamic geometry parameter.Most of the samples of using feature type schema mapper samples I’ve found show single geometry. I’ve attached my workspace template here in case someone wants to take a stab at it. Screenshot of wokspace is below.Any suggestions or links to community page are appreciated. Thanks! 

Hi,I want to clip a large ECW file which is about 2 GB in size. It consist of aerial imagery around a river in my country.Secondly I have a shapefile which is the river body. Now I want to clip my ECW with this shapefile. See the attached figure as illustration.I foresee that just clipping the ECW with this shapefile will take a long time. Do you have any advice to speed up this process?I was thinking about the following:- Use RasterTiler and create an attribute which will function as a Group By attribute in the clipper. I hope this will make it possible to perform parallel processing within the clipper?-Use 'Clippers first' and drop my shapefile reader at the top of my readers. I saw this suggestion elsewhere at this forum.-Not all features in my shapefile overlap with my aerial imagery. Maybe I could filter them before entering the Clipper.Thanks for you help in advance!

Hello,can someone tell me please, or indicate where is described the meaning and differences of the attributes of the .owns and the .xsi_nil? i know that are boolean, but what do they mean and what is the difference that distinguishes them from each other? thank youBest regards.

During creating fme list I get python error:Attempts from my side:and:and even this:maybe the issue with data in my python list (data) ? but it is just array which contain text data. 

Actually i have to prepare a touristique card so i need to prepare a legend and put some figurative symbols on the map so it will be more descriptif and give the user more information . if someone have any ideas of how to do it please. i'm using a shapefile of a country as a reader and i want to get a shapefile as a writer . thanks

I am having some issues with the 2020 install and i have had to move over to a different PC. I migrated everything fine, but when i open the workspaces, the first thing that occurs is the feature readers try and find the old database and then drop all the feature types that were previously being read. Some of these have 10 or more specific features, all with multiple links so it will take a long time to try and re-link them in, is there any way i can change the parameter without opening it, then open it up?

Hellocan someone tell me or where the meaning and differences of the attributes are described, as well as the values they receive?for example .owns and .xsi_nil are boolean, ok, but what do they mean and what is the difference that distinguishes them from each other?and the others?.about (xml_buffer).nilReason (xml_buffer).gml_remoteSchema (xml_buffer).xlink_href (xml_buffer).xlink_tittle (xml_buffer).owns (xml_boolean).xsi_nil (xml_boolean).DateTime (xml_datetime)  thank youBest regards.

Hey Everyone,I'm trying to do some javascript work with FME Server. I can't seem to connect to my server that runs FME Server. I have the FMEServer.init method set up window.onload but I get the attached error. The onload code is below too, the FMEServer.init portion is near the bottom.  window.onload = function(){debugger;require(["esri/map", "esri/toolbars/draw","esri/graphic", "esri/geometry/webMercatorUtils","esri/symbols/SimpleLineSymbol", "esri/symbols/SimpleFillSymbol","dojo/_base/Color", "dojo/dom", "dojo/on", "dojo/domReady!"], function(Map, Draw,Graphic, webMercatorUtils,SimpleLineSymbol, SimpleFillSymbol,Color, dom, on){map = new Map("mapDiv",{basemap: "hybrid", //Select the basemapcenter: [-155.114166, 70.27], //Enter the coordinates to center the mapzoom: 7, //Set the default zoomminZoom: 4,//Set the minimum zoom levelsmartNavigation: false});map.on("load", function(){toolbar = new Draw(map);dojo.connect(toolbar, "onDrawEnd", addToMap);on(dom.byId("draw"), "click", drawPol

Hi, I was using arcpy inside fme workbench. Till yesterday everything was good. Now today , FME python 27 has been deprecated and 'im not able to import arcpy module. Is there any workaround for this?

I just found the "Enable Cache" option on the FeatureReader, but it's not entirely clear from the documentation when this cache is renewed.Assume I have set the "Cache Timeout" parameter to a very long time, say a week or longer.Will the cache only remain during a session, or will it still exist when I close the workbench, and reopen it later that day?Will the cache still exist when I close the workbench, close down the machine, and reopen the workbench the next day?The reason for asking is that some remote datasets are pretty heavy and only change occasionally, so I wish I could minimise the number of times reading it.Note: I am not talking about workbench feature caching here!

Hey all, I'm struggling to get an Automation set up on FME server 2020. Whenever I add a workspace it states that there are no connections available, but I have a connection set up on the server to a MariaDB database. So far I have found this: https://knowledge.safe.com/articles/109765/known-issue-fme-server-resourcesautomations-could.html  So updated to the latest FME Server but it doesn't work Not sure I am missing something simpe or not! Thanks Joe  

I am trying to construct my first custom transformer and have some issue with the schema handling.To explain what I am doing in my transformer:The SQLCreator is pulling information from a PostgreSQL table. The information retrieved are used to extract polygons from a Oracle database in the subsequent FeatureReader (FR_Municipalities). here the requested feature type is static. Cleaning up some attributes and joining a timestamp from the initial PostgreSQL table, the polygons are used to extract data from another table in the Oracle database. The difference here is, that the user has to have the possibility to select the feature type in the last FeatureReader(FR_AnalysisData).Since the feature type is based on a published parameter, there is no specific output port, but all goes trough the generic port. Here I have the problem that basically all attributes should be pulled, but how to say that in the dialogue where I specify the attributes to expose?Is there some sort of wildcard to do

I am forget the password of my workbench . how to get it reset and get the data in to it.

I was looking to do a data transformation task by making use of the following high level workflow: Run a data audit to compile a database table of filepaths of MapInfo tab filesCompile data about the file discovered, included a field as to whether to transform this particular dataset (Field “TransformRequired” with Yes or No values).After our data audit is complete, use the Database table as an input list for the transformation, making use of the FeatureReader transformerUse a MapInfo Tab writer with a dynamic schema, using the “Schema from Schema feature” option as the Schema source. The problem I have is that the input table list will include MapInfo tables which have the same file name, but which are in different file system folders. The paths I am trying to read in include: \\Input\\GDA2020\\MapInfoV16\\PARCEL_VIEW.tab\\Input\\GDA2020\\MapInfoV17\\PARCEL_VIEW.tab\\Input\\GDA94\\PARCEL_VIEW_GDA94.TAB\\Input\\GDA94\\PLAN_ZONE.tab When reading the list into the FeatureReader transform