Authoring

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 7bdBut 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 sheet1700 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){  "propertie

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 pa

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).

Hello, I am wondering if its possible to implement Imageprocessing tools in FME? For instance: Lets say you have a LIDAR file and want to make presentable contours. You then take ur filltered LIDAR file, do some processing to it first, then you make contours, write the contourvector to a raster, and on the raster I would like to have to oportunity to do Image processing, with a convolution/kernel filter.  Can this be implemented i FME?   

I have tried and failed and tried and failed. Any help is extremely appreciated in advance! I have column1 containing reference numbers (with duplicates) and I have column2 containing dates (and blanks). I want to create column3 and return yes/no values for all the reference numbers, depending if all ooccurrences of each reference number contains a populated date field. e.g:input:RefDate101/01/2019101/01/2019 201/01/2019 201/01/2019 2 301/01/2019 3 401/01/2019 401/01/2019  Output:RefDateNewField101/01/2019 Yes101/01/2019 Yes201/01/2019 No201/01/2019 No2 No301/01/2019 No3 No401/01/2019 Yes401/01/2019 Yes Thanks,Sideshow 

Hello,i would like to aks you, if you could help me with downloading data from website. i would like to download from this website: http://www.meteo.si/uploads/meteo/app/inca/?par=si0zm. if you open the link, you can see the red frame, in case of rain or snow in this frame shows precipitation with different colors. i would like to download frame and precipitation. i do not now how to download this. i hope you can help me.  

I'm trying to get a webhook up and running so that Microsoft Graph can write straight to a topic on one of my FME Cloud instances. I'm using the following: Go to https://developer.microsoft.com/graph/graph-explorer/, do a POST-request to https://graph.microsoft.com/v1.0/subscriptions using the following body:{   "changeType": "created,updated",   "notificationUrl": "the-topic-url from Message as Subscriber Content",   "resource": "me/mailFolders('Inbox')/messages",   "expirationDateTime":"2019-02-15T18:23:45.9356913Z",   "fmetoken":"token-goes-here"} However, I get the following response: {    "error": {        "code": "InvalidRequest",        "message": "Subscription validation request failed. Must respond with 200 OK to this request.",        "innerError": {            "request-id": "5b842b2b-6325-444e-890e-f9ff6eb61510",            "date": "2019-02-14T13:09:40"        }    }} Using Postman, I've verified that I get a 202-response if I make a POST-request to the topic URL. Is there a

Hello, When setting the Feature Class or Table Name field in an ArcSDE Feature Type writer as a parameter, e.g. $(str_table_prefix)_ALLI get the following error:Geodatabase Writer: Feature Class or Table 'OLDNAME_ALL' must exist when Table Handling is set to 'Truncate Existing'Looking at the FMW file in Notepad, I notice that when I put a formula in the Feature Class or Table Name field, there are still a ton of references to the old value. If I put just a parameter (i.e. remove the _ALL suffix), the same thing happens. If I put just a plain string in this field, all of the old references are updated to the new string value. If Table Handling is set to Create if Needed, the workflow runs, the expected table is created, and the data flows into it. But setting it to Truncate Existing will cause an error when running, if the table OLDNAME_ALL does not exist. If it does exist, then FME will truncate OLDNAME_ALL and then flow the data into NEWNAME_ALL. What? FME ESRI Edition (v2018.0.0.3)

Hello, Today I wanted to experiment a bit. I used WorkspaceRunner with "wait for end" option set to no.  It worked quite well for some time, I had few hundreds of featured to be processed using this, but after some time it all slowed down and then stopped. Then I stopped job in fme workbench and tried to run it again. There was information that I dont have enough licenses.I saw that problem before so I thought that it would be enough only to open task manager end kill some fme.exe processes but there were none. Then I opened powershell and entered get-process command Here there are.  When I try to kill any of those processes it doesnt work, still list is the same Do you know that problem? I hope that there are better ways for solving that then computer reboot :) 

Hi,I use a FeatureReader with the Format "Esri Geodatabse (ArcSDE Geodb).I linked the "WHERE Clause" constraint to an attribute.Then when I checked the parameters of the FeatureReader transformer in the Navigator window, I saw a parameter named "GEODATABASE_SDE WHERE Clause".I would like to know the difference between the "WHERE Clause" parameter and the "GEODATABASE_SDE WHERE Clause" parameter.ThanksValerie

I struggle to find the link for the FMEAR including the Airplane from previous World Tour? Anyone have it or know where to look? Thx