Authoring

Dear FMe community. I'm trying to build a list with a SpatialFilter transformer but it doesn't works. I need to build an exhaustive transcription between lines whose intersects polygons like that : For the moment with SpatialFilter I don't find... Thanks for your help.

I am trying to leverage a Choice with Alias (multiple) User Parameter in a custom transformer. When I add the custom transformer to a new/blank workbench and connect it to an data input (CSV), all the attributes also show up for the user to choose from. Am I missing a setting/toggle somewhere? Parameter Setup: What's showing up when custom transformer is added to an empty/new workbench and connected to a CSV input: Why are these attributes from the input showing up in Choice parameter? If I select Choice with Alias without multiple choice, it works properly. FME 2018.1.1.2 (Build 18586) Thanks.

Hi all, I have a shapefile with roads and another shapefile with points that contain a field with the mileage of that roads, and I use the latter to calibrate the routes I create with the former in ArcMap. Both shapefiles are related with IDs, so there is no risk of asigning a mileage point to the wrong road if it's not snapped to it. My problem is that the mileage data of some points is out of place, for example you can find: ...42 - 43 - 44 - 0 - 45 - 46 - 47... And that zero causes the calibrating tool to fail. I've tried to spot it so I can generate a new shapefile without the incorrect mileage points but it always returns me another points and I can't find a way to get it right. Here is an example: Gaps in the enumeration are not a problem, but some times there are not only one but a group of points out of place. For example : ...42 - 43 - 44 - 178 - 177 - 176 - 175 - 51 - 52 - 53... In this case there would be no problem with the gap between 44 and 51. The numbers in between are

I have an older script that will no longer execute importing pyfme. Any suggestions as to why? Log translation details below: FME_END_PYTHON: evaluating python script from string... Python Exception <ModuleNotFoundError>: No module named 'pyfme' Error executing string `import pyfme Shutdown Python Script details:

Hello again. I was planning on setting up a sequence of translations to run where each successive translation is run by a WorkspaceRunner transformer in the previous. The problem with this is that placing a WorkspaceRunner at the end of a translation makes it dependent on the translation succeeding, and my chain of many translations could be jeopardized by something out of my control, such as a "403 Forbidden" error in an HTTPCaller. My questions are: A) Can I run a .bat file as a Shutdown Python Script without the translation where that script resides remaining running? In other words, is there a Python version of "Wait for Job to Complete: No" ? B) If not, is there a way to place the WorkspaceRunner so that it both Doesn't start the next translation in the sequence until most or all of the operations are complete, and Isn't dependent on any other transformers succeeding The reason these requirements are in place is so that more than one translation isn't running at a time, and so tha

Hello All, We have built a new server on a Windows 2008 R2 (64bit) system and and I have: 1. FME 32bit installed 2. Oracle Client 32 bit installed 3. Oracle client BIN folder in PATH 4. TNS_ADMIN environmental variable set to point to folder containing tnsnames.ora 5. ORACLE_HOME environment variable set The issue is very similar to this I can connect to our DB via third party and SQL*Plus. I've modified security setting to give required access. I'm running out of ideas. Any input please? 2013-11-18 11:23:15| 0.6| 0.0|INFORM|ORACLE Reader: Using Oracle 8 SC Reader Version 1.2 (Jul. 04, 2000) to read tables from database `', server type `ORACLE8i', server name `pri1', user name `fme_ro', password `***' 2013-11-18 11:23:15| 0.6| 0.0|INFORM|ORACLE Reader: Using Classic geometry. 2013-11-18 11:23:15| 0.6| 0.0|INFORM|Loaded module 'OCI' from file 'OCI.dll' 2013-11-18 11:23:15| 0.6| 0.0|ERROR |Unable to connect to Oracle database, because the database environment could not be initialized. 20

Hi, is it possible to change the filename in a dynamic writer? I'm trying to add a suffix to the original file name but as soon as I do any changes to the value stored in fme_feature_type the workbench fails. Is it even possible to change the filename in a schema?

My batch print is not working properly. The workspace runs, but when I try to run batch manually it fails. Saying error determining writer (Translore). Again regular workspace runs properly. Help?

I use a SQL creator on a Oracle Spatial database extracting around 40 columns. I would want to score the fid of this extraction in order to use it in the where clause of a post-gis reader. This to avoid the post-gis reader to read all 1 000 000 records when I only need 300 of those. How can I do this ? I did some research but seems I am using the wrong key words as I can't find it.Thank you

I have a nine element, pipe-delimited attribute. These elements can be a text string or a blank space. I want to replace duplicate text elements with a blank space and leave blank elements alone. I.e. have it come out with eight delimiters and nine elements when I put it back together. ListDuplicateRemover gets rid of the unwanted text elements, but also the blank ones. Example: |||Carnegie Drive|Carnegie Drive||Dunfermline||Ky12 7bd when run through AttributeSplitter and ListDuplicateRemover becomes: |Carnegie Drive|Dunfermline|Ky12 7bd But I want it to be ' ||||Carnegie Drive||Dunfermline||Ky12 7bd' (with a leading space) I.e., just remove the duplicate instance of 'Carnegie Drive' and replace it with a blank space. Thoughts? Thanks

Hi everyone, I have a workflow in which I have to change the schema dynamically. I was able to write the result I want into a CSV file by using a FeatureWriter (or a CSV writer) and setting Dynamic Schema Definition with Schema sources as "Schema From Schema Feature". The features passed in have list attributes name and fme_data_type. The table in the output CSV file is correctly formatted into the new schema. However, the data from the output port of FeatureWriter is in the same schema format as the input to it, (not in schema format written in CSV). I want to change schema in FME so that I can process it further. Is there some setting in FeatureWriter that Im missing? or any Alternative workflow to change the schema ? Thanks in advance, Ashish

Hi there, I've been trying to find answers all over the internet, but no results. In short, I'm generating a CSV output where my input is an unknown amount of entries (workbench will be run several times and input varies each time), but I want to generate a separate CSV for a maximum of 500 entries found. So as some examples, based on hypothetical inputs, this is the output I want: 350 entries - 1 output sheet 1700 entries - 4 sheets (3 with 500 each and one with 200) 502 entries - 2 sheets (one with 500, another with 2) I'm not particularly concerned about the order of these features. I tried the ModuloCounter, but instead of splitting up my input per 500, it splits up my input into 500 equally sized groups, which won't do. Thanks in advance,

After doing a lot of search I still can't find a way of exposing attributes whose names are stored in another attribute. _count attribute values are the names of the attributes I want to expose. They exist and have values. I find the AttributeExposer transformer too simple. It won't let me set an attribute value as an attribute name to expose. So, what should I do? What's the way to go?

Hi, I want to make a simple list of two attributes. I will try to explain the context. I have a point shapefile who has all an attribute "Factor2019". First i have to determine which two points belong together, i use the "neighborfinder" and that works perfectly. I also give the two points who belongs together a same attribute (RWZI-NR), with the neighborfinder. I also merge the field "Factor 2019 but i firts give it an other name with the renamer "F2019" But then a want for each "RWZI_NR" the two values from "Factor2019 and F2019" in the same field named "FACT" in al list so after that i can use de ListConcatenator for determing the max value. But it doesnt work, i have tried to generate a list immediately in the neighborfinder, with list builder and with a feature merger but i never get the result i need. I'm doing something wrong but i don'n know what. Help :-) Nathalie

Hello, I have a Geojson file. I would like to create a new key-value pair in properties. Current properties of an object looks like it. { "properties": { "name": "Seattle", "type": "CITY", "template": "Prohibited", "id": 1, "TRANDESCRI": "MAJOR TRANSIT ROUTE", "SLOPE_PCT": 1, "PVMTCATEGO": "ART", "PARKBOULEV": "N", "SHAPE_Leng": 666.1146823345148, "_related_candidates": "0" } And I would like to create new key in properties which is called 'description' and it should have the other key-value pairs in it. So it should look like this { "properties": { "name": "Seattle", "type": "CITY", "template": "Prohibited", "id": 1, "TRANDESCRI": "MAJOR TRANSIT ROUTE", "SLOPE_PCT": 1, "PVMTCATEGO": "ART", "PARKBOULEV": "N", "SHAPE_Leng": 666.1146823345148, "_related_candidates": "0", "description": { "name": "Seattle", "type": "CITY", "template": "Prohibited", "id": 1 } }} or (description is a list here) { "properties": { "name": "Seattle", "type": "CITY", "template": "Prohibited", "id": 1, "TRANDESC

http://www.sharkattackdata.com/place/australia how can i scrape this page and get the table as a CSV, Im a total noob and ive tried watching youtube but the tutorials are still above my level and i cant seem to apply them to my job. I know i need a HTTP Caller,

I'm trying to configure a python shutdown script to run if a user cancels a workflow prematurely. In testing I'm finding that the scrips does not run (or at least it appears not to run). Is this expected behavior? Has anyone been able to work around this? @DebbiAtSafe any ideas? The limitation here is when working with live streams - The process will never end until terminated/cancelled. Cheers

I have 4 workbench fmw files, each pulling data from an outside source, run it through various transformers, that then insert and update data into 6 related tables. The First FMW is updating traffic accidents. The Upper body code on the HTTPCaller transformer contains start and end dates that have to be manually updated each week.This is the code in the Upload Body parameter: <?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <TPWAccidentDataXML xmlns="http://www.lesa.net/"> <StartDate>02/01/2019</StartDate> <EndDate>02/16/2019</EndDate> </TPWAccidentDataXML> </soap:Body> </soap:Envelope> I want to replace the manual process by adding a scheduled task to run every Monday AM morning, and to calculate and pass in the Calculated Start and End dates. I have a creator transformer to start, followed by 2 DateTime Calculators

Hi, is there a way to restrict the "attribute name" parameter to specific attribute names. I use it for chosing the attributes of an Excel file that has lots of attributes so the drop down list gets very busy. I tried to use the choice parameter as an alternative but it seems you can only use it for attribute values not names. Thank you for your help.

We are facing the error SDE_ERROR_CODE(-92) Bad connection handle while running the FME workspace via workbench.Full error message: Error connecting to instance 'sde:sqlserver:Server' for database 'database' on server '!not_used!' for user ''.:SDE_ERROR_CODE(-493) Connection was attempted with an older version of SQL Server client communications software that is not supported.. Error connecting to instance 'sde:sqlserver:Server' for database 'database' on server '!not_used!' for user ''.:SDE_ERROR_CODE(-92) Bad connection handle.Note: SQL native Client is SQL server 2012 native client and Microsoft system CLR types for SQL Server 2012. We are facing this after we upgraded to FME 2016.1.2.1. The workspace can run successfully in 2014 FME version.Kindly suggest how to resolve this. Lee!

Our app, on server 1, calls on a FME fmw file translation, also on server 1, and sends the data back to the user via the app. This was working perfectly up until ? time, I can't be sure exactly when it started as I only got the helpdesk issue routed to me yesterday. I did upgrade our Weblogic server on the same machine (server 1) last weekend but no other changes were made to the Oracle client or Java or anything other than Weblogic specific, but I'm not ruling out that it's not realted. From server1, I can tnsping the database server, withing FME workbence the database connection test successful, running the fmw file from within the workbench connects successfully also, yet via the app I get the infamous ORA-12154: TNS: could not resolve the connect identifier specified. I've played with the tnsnames.ora file modifying various items, setting IP as opposed to machine name, setting service_name as opposed to sid, etc....to no avail. Any ideas?

Hi , I have images with RGB channels and images with IR channels .I would like to merge images that have the same name together to be 4 channels image ,would you please tell how can i do that with FME

I need a little help finding the correct format to enter a spatial envelope Input Geometry. Looking at the following link It looks like I need to put the following information into the Input Geometry Parameter (xmin, ymin, xmax, ymax). I tried this with no records being returned. Is there a trick to pre-filter spatial data from an ArcGIS Server service. http://docs.safe.com/fme/2018.1/html/FME_Desktop_Documentation/FME_ReadersWriters/arcgisfeatures/ft-parameters-r.htm

I am looking for a configuration that would let me use FME from web client. I imagine I can install FMEServer for example on AWS EC2 and control it via REST API. But the fact that I haven't seen any tutorials/documentation about it, makes me thinking my assumptions might be wrong. My questions are: 1. What platform would be best for installing FMEServer remotely (for testing purposes – would a free of charge platform be preferred)? 2. Do you know any tutorials that would guide me through this process? Thanks in advance

I have different workspaces with the same Private Parameter which I want to change. Is it possible to do that with an additional workspace where I can change all of the same private parameters togther? The Parameter itself is a string. I added an example Workspace with the including private parameter (Template File).