Authoring

I need to connect to SQL Server database hosted on Azure cloud. It is currently blocked within LAN network and we are looking at option to connect to database over SSH or HTTPS. Is it possible to connect to SQL Server database over SSH using FME?

I'm using a schema mapper to update a number of attributes that have string values to a corresponding code. I'd like to catch features where one or more of the attributes to be mapped have a value that isn't in the schema mapping table. There doesn't appear to be an easy way to do this, since some of the attributes on the feature are mapped, the feature exits the mapped port. Has anyone come up with a good solution for this?

I was following to do a tutorial on "Extracting Data within a Clipping Polygon using FeatureReader" but I do not know how to create published parameters from the Navigator. I am knwe to FME. Can you please help. Regards

I have been tasked with sorting out 100s of workbenches. In the majority of them the names of the transformers have been customised and should be in annotations rather than the actual transformer name, for easier readability. E.g. SQLExecutor is actually named Table_xxx or FeatureWriter is Named xxx_Output. I'd like to know if there is an easy way to just revert the names back to the original transformers names. I can't find a way myself, other than manually going through each one and changing it myself. EDIT: This is on FME Desktop 2022.1 Thanks!

Hi there, Slightly off the wall here, but has anyone created a workspace that can create Bingo cards? Ideally a 5x3 grid of random numbers between 1-90, but no repeating numbers...? Obviously, RandomNumberGenerator can give us a way to actually play the game...but I'm thinking whether FME can create the cards for users to play with..? Thanks!

Hallo! I have a general question about the dll's on fmeserver. There seem to be a lot of people having problem with this, but I cannot really find a good solution for it. In my company we have many scripts running on the server (2017.1.2.1 build 1775.) In my case I have made sure to use the same version when I develop in fme workbench. Often we have .dll's that can be found but not loaded, and the script doesn't do its job. This causes frustration for our customers. (An interesting perspective is that we didn't have any problems in our test-server, but they started right away on the production-server). We have tried to analyse if there is any systematics in this (specific scripts running just before, changes in python-version, engine-specific etc., but with no good results). Is there a way to get by with this problem? /Anne

Any thoughts on the below error, trying to load data into a Hive table that has columns defined as decimal 11,2 Value is 6500, I have also tried stringformatter to 11.2f, and hard coding value to 6500.00, and a few other things like setting the value to double(@Value(my_amount), etc. Database Error Message: [Cloudera][ImpalaODBC] (370) Query analysis error occurred during query execution: [HY000] : AnalysisException: Possible loss of precision for target table 'xxx.xxxx'. Expression 'CAST(65000 AS DOUBLE)' (type: DOUBLE) would need to be cast to DECIMAL(11,2) for column 'my_amount'

I am writing a WS which is reading an Excel sheet for two Writers which are supposed to write in two different environments (DEV and TEST) As you can see since the source data is same I am using only one stream workflow instead of duplicating the transformers for each writer (DEV and TEST) I have created a User Parameter like this Now, can someone please let me know where and how should I assign this into the workflow to select the endpoint (Which Writer to be used)? Thanks

How does one pass a user parameter to a pythonCaller that's inside a customTransformer import fmeimport fmeobjects def processFeature(feature): p = FME_MacroValues['SomeUserParameter'] print p I read here "If you put your pythonCaller inside a custom transformer, the parameter name changes to {customTransformerName}_SomeUserParameter. " I tried then doing this below but still does not work. import fme import fmeobjects def processFeature(feature): p = FME_MacroValues['{customTransformerName}_SomeUserParameter'] print p What am I doing wrong?

All I am having trouble automating some workspaces as the data and folders that I receive are containing dates in the format MMMYYYY as shown below... \\\\server\\FMEData\\DataDownloads\\Supplier\\Data\\Data\\Name_Mar2020 The files are supplied as shapefiles and they are also named Name_Mar2020.shp etc How can I automate the running of these workspaces for when the folder or file name changes to the next month?? I have tried using the * in various places, but to no avail and don't want to have to run these manually I know this is something obvious, but just cant figure it out... Regards

I've created a custom transformer which I think can be of use to other FME enthousiasts. I want to upload it to FME Hub as described here Publishing an Item to the FME Hub (safe.com). It states that it is best practice to upload an test workspace as well, but the information provided on how to do that is minimal. Is there somewhere a template available?

Nel livello in cui devo selezionare i dati, devo applicare l'espressione Area >1

Hi when I run the exercise-workspace-prototyping.fmw I received this error can you help ? thx Francesco

Hello, I'm working with FME Desktop 2015 with a WorkspaceRunner transformer calling several workspaces where i have to use an environment variable in the path of some private variables. For example: %ENVIRONVAR%\\dat\\myfile.txt The problem is that the called workspaces don't recognize the value of the environment variable defined by the Windows System. I have tried to assign the value to the environment variable inside the workspace but it is not a good solution in this case because every PC could have a different value. Is there some example about to do solve this problem? Many thanks in advance! A.

Does the FeatureMerger actually work as a blocking transformer when no features reach the Requestor port? I mean, for example in the workblow below, I assume the Creator transformer will go first but after that, will it read the json file, wait to see if any feature enters the Requestor port and then go on through the rest of the flow? I'm reading and writing the same json file so it's critical to know. It works as expected so far but if anyone knowing for sure could confirm I would appreciate.

I'm trying to do a spatial join between two AGOL layers, one is a strip map and the other is parcel data with owner info. I want to merge the two and create a table with the owner information and its respective page number. I have been using the SpatialRelator tool; the parcel data are Requestors, the strip map pages are Suppliers, Spatial Predicates are intersects/touches/within, and merge attributes are checked with Merge Supplier as the Accumulation Mode and Supplier as Conflict Resolution. The SpatialRelator will create a table with all attributes merged but all of the supplier data is shown as "<missing>" (and it's definitely not missing in the AGOL layer). I have tried a few different combinations of this but I just can't seem to populate the entire table. Has anyone ever encountered this problem?/Does anyone have any ideas on a fix?

Hi, after following the OpenAI GPT-3 webinar I would like to ask if is it possible to create a process to detetc/extract the traffic sign from images using OpenAI GPT-3 in FME thx Francesco

Hi All I have a URL in the format http://blah.com/images/{index] where the maximum index value will be the total number of records minus 1. So for three images the indexes would be 0, 1, 2 What is the best way to take the attribute imagecount and loop to the URL for the correct number of times starting at zero??? Just getting a bit confused now.... Regards

Hi, Is there any way to read an image from a excel sheet or expose the hidden attribute/row that contains it? Thanks

How can I pass a published parameter in a workspace into a custom transformer within the same workspace? I think you can pass a publishedParameter into an attribute and then make this attribute available in the custom transformer, just wondered if there was a simple cleaner way?

Hi, I'm trying to extract XML from the attached file. I'm using an XMLFormatter before hand which extracts the loggerId I need to match to a database table. I can extract the XML using the fragmenter, but unless I use the 'Merge Attributes from Input Feature' the loggerID is not carried through. If I do this. FME managed to burn through 700GB of my hard drive and then fails due to lack of memory. Any idea how I can carry through my original XML attributes through to the fragments without having to do this?

Greetings, Is there a setting to set the date value out of the DateTimeStamper to say ISO? Thank you, Tyler FME 2022.1

Greetings, Do you have a best practice for adding a 'status' attribute populated with the value of the join status such as 'joined', 'unjoined_left', 'unjoined_right'? I can imagine using a 'create attribute' transformer outside of each join transformer port, but that seems heavy on transformers (four total). Let me know if you have a more efficient solution. Thank you, Tyler Workbench 2022.1

Hi, I have a large point dataset and line dataset in ArcGIS. For each point A, I need to 1) create point B on the line which is nearest to the point A. Ensure point is snapped to line 2) Generate a line between points A and B I have tried using NeighborFinder, with the line set as the base. However this doesn't create an additional point dataset on the line. Any suggestions