Authoring

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

I have simple workspace routine that imports data collated from ArcGIS Survey123 (AGOL) and updates to a SQL server table that needs to run on a daily basis. Can this be done with a batch file (.bat) and scheduled with windows task scheduler?

I have a Microstation v8 file that has 60 odd levels from which I have to filter out 20 and further filter those 20 levels to based on the color of the features. One level has features that go on two different output levels. I am using an Attributefilter to filter them out based on their color value, then use several FeatureCreators to write out the features with the destination color, weight to the destination levels. When I look at the log it shows that features were created for two destination levels, but when I open the dgn file I see no features on one of the destination levels. All output features will be written on a single level. Any idea why?

@david_r @DanAtSafe I've created a simple workspace to download a file from FTP every morning. When I run the workspace in FME -> everything works.When I run the FME workspace from the command line -> everything works.When I run the batch file that I created, which points to the FME workspace -> everything works.When I create a task in Windows Task Scheduler to run the batch file that I created, which points to the FME workspace -> Task Scheduler says it completes successfully, but no files are downloaded or saved.Additionally, I added a function (at the end of the batch file that launches the FME workspace), in order to create a simple log file called "batch_log.txt":C:\apps\FME_18440_x64\fme.exe "J:\workspace.fmw" echo "this works" > C:\apps\Scratch\batch_log.txtWhen I run the batch file from the CMD prompt successfully (not Task Scheduler), the log file contains this:FME 2018.1.0.0 Beta (20180319 - Build 18440 - WIN64)FME ESRI Edition (node locked-crc)Permanent Licens

Hi,Does anybody have any experience with FME and SQLBase?FME doenst support it, but can an ODBC connection can be made?Thanks,Itay

To simplify this issue, my short term goal is to build a simple module which checks each attribute from a transformer or reader and returns the percentage of nulls for each attribute (vs the total number of records).  for instance something like:  Input: Attribute1Attribute2Attribute3Attribute4...... Output: Attribute1Attribute1-null-countAttribute2Attribute2-null-countAttribute3Attribute3-null-count......or something like that...  Again, to clarify, we DO NOT KNOW the Attribute names nor how many attributes there will be. Ideally, I would build a Custom Transformer, which accepts an unknown number of attributes and performs this calculation / process. However, Custom Transformers require that the inputs attributes are static.  From all the research Ive done I cannot figure out any way to make this happen.  I thought about a transformer that takes all attributes and combines them into one then they could be broken apart after but nothing seems to exist. I am open to any suggestions eve

Hi,I have many tables in SQL Server under the 'dbo' schema that I would like to replicate to PostGIS under an 'sde' schema. I would like to do this using the dynamic schema functonality. How can I replace the dbo with sde in the fme_feature_type attribute while still bing able to associate the matching schema for the tables using the dynamic writer.Thank youOliver Please forgive the use of schema term - schema in sql server means something different to schema in FME.

I am 2 feature reader in My WS , to read a PostGIS DB , we update the data in post GIS but when we inspect the featured reader it still sees the old data.we did a test in a new workspace and its working fine.is there any setting we need to handle Thanks

Hi.I like to have most of the essential translation parameters as published. This typically includes the database server name and the database name when working with (MS/SQL) databases.But when I press the "..." next to the current value to choose another, I get an unexpected error, stating that I gave an "Invalid authorization specification", even though I've set it to "Windows Authentication" originally, which worked then.I cannot specify any other "authentification", so I'm left with having to write the database name manually. Not cool, and not very productive. And I cannot change the parameter into a choice list either.Is there another way to get this to work ?Cheers

Hi FME Experts, I have F.C and we received new data for the same F.C it contains 3 types of update:- update on the attribute level.- Update on the geometry level.- Add new data.I am trying the insert the new data into the main destination, I tried the update\\insert feature operation with truncate data but it does not work.there is a way to do this?