Automation

Good morning everyone, Imput1: a group of polylines in SHP or KMZ format and a LAS file. Imput2: Several LAS files How to output a Las file containing the closest points (from the imput2) to the line every 50 meters? Thank you. Alex

Unable to run FME workbench with Python setup on Task scheduler. It runs fine when I run manually. It gives 0x1 error.

The whole workspace runs daily by means of a schedule, all the readers point to their respective CSV files URL, but the last created reads from another CSV source, and inserts in Google BigQuery the same amount of records obtained from such wrong CSV, but with null values. Is it recommended to change from schedule to automation?

Hi all,  I've publish my workspace with SQL Server connection to FME Server and build an automation from that. However, the error message "MSSQL_SPATIAL writer: Failed to open writer" is returned when I run the automation.   I've check all three workaround given in this article, " https://community.safe.com/s/article/fme-and-sql-server-troubleshooting-guide " but none of them works. Anyone have any idea or suggestions on how can I resolve this issue?

General info: There is a survey123 with a webhook to run a workspace in fme server. Webhook is only for new entries, not edited.  Test:From any Windows OS, once the survey is filled out, the webhook is triggered: a json file is sent to FME server and the workspace runs (i can see a completed job).  Test 2:From an iOS (tablet), survey is filled out. Not sure if the webhook is triggered, but there is no json file on FME Server and no jobs, running or queue or completed.  Question: Is there something on survey123 I can look at to know that the webhook was triggered? Is there an issue from an iOS device?  I don't have an android device to test on so not sure if the problem is mobile device specific or just iOS. Would appreciate any insight.

Hi all,  I would like store the historical data in FME Server to MS SQL Server database. I have successfully store the data from FME Desktop to the SQL Server. Then I have publish the workspace to FME server to do the automation which will update the data daily at 9.00 AM.    However, I couldn't store and view the past data in the database once the data is update after the automation. Any suggestions?

We've upgraded to fme server 2021, and when we build a new automation, it's impossible to use a value from upstream and pass it to a workspace parameter when the parameter type is not plain text. Before with fme 2020, its was possible to set a choice parameter with a uptream value.   Is this a bug, or a new behavior for fme server 2021 ?

I have a set of data which contains an attribute name (header/title) which I have to use an an attribute value for a new attribute. At the moment, I am using attribute creator to create a new attribute and then attribute manager to add this to existing data. However I am unable to set the new attribute value as one of the attribute name of existing data (which I read in using reader transformer). Any help will be highly appreciated.

Has anyone configured an FME trigger webhook as an outgoing webhook in Teams? It'd be very nice to just @ an automation without leaving Teams. I've got an automation triggered by a webhook that can be triggered no problem using curl, but trying to use that webhook in Teams gets an immediate failure ("Sorry, there was a problem encountered with your request"). It looks like Teams may be expecting a particular response (https://stackoverflow.com/questions/45743782/custom-bot-always-replies-with-an-error) and I'm not sure whether FME provides that / how to troubleshoot from here.

I want to remove the FILECOPY_1 path from the data download zip file from FME Server when using the filecopy writer, and can't figure out why it isn't being removed. When I enable the Data Download service on FME Server when publishing, I make sure to set the Path in the Zip File to empty, but I still receive the data download file in the structure listed below. Current Download File FormatFME_3637254D_1587574658508_152.zip\\FILECOPY_1\\examplefile.txtFormat I Want to ReceiveFME_3637254D_1587574658508_152.zip\\examplefile.txtAny ideas as to what I can do to remove the "FILECOPY_1" from the download zip from FME Server?  Below is an image showing how I have it setup for FME Server.  FME Server 2020.0.0.1

FME server documentation states:Note: Each IMAP Publisher created on FME Server must reference a unique email account. You cannot create multiple IMAP Publishers that reference the same address.However, I have done some testing with this and I have created more than one publisher with the same IMAP email. Bother publishers work. Am I missing something? Is there going to be a future error or fault? Where is the conflict with this? Thanks.

Hello, I've made a workbench that downloads data to Shape automatically once per month from https://geodata.nationaalgeoregister.nl/hwh/eenheden/wms/v1_0?request=getcapabilities&service=wms (WMS).  This time I would like to make a workbench that compares the geometry and administrative data from the Shape files with each other (January-February, February-March and so on). I am thinking about doing this with the ChangeDetector transformer, but that's where my idea stops. Could anyone give me advice on this?  Many thanks,Claire

Hi, I've build an automation in the FME Server with Trigger type: Schedule initiated and Schedule type: Repeat on interval for 1 minutes (for testing purpose) and it works perfectly . However when I stop the automation and set the interval for 1 day at 7.00am, the automation is not working after I checked again the service the other day.   Any idea on how can I resolve the issue?

Current stepsRevit IFC readerGeometry Coercer -> FME_composite_surfaceSurface Footprint Replacer -> Overhead ShadowGeometry RefinerScalerDissolverGDB Writer Extra info: The process has been created as a result of mostly trial and error with varying IFC files, although mostly similar. For this exercise attribution can be ignored other than FME_feature_type to remove the redundant IFC components (site, project, building etc) It feels like there is a lot of 'junk' in the IFC format that is not required for geometry work. What steps are possible to clean / optimize / dissolve IFC files or their derivatives to increase workbench processing speed. I cannot supply an example IFC file due to data security.  

I am tasked to asses FME and determine if it will be a good fit for our organization as main integration platform. I have done some research on FME and have few questions (where i could not find much documentation):Does FME have any self-documentation feature or 3rd party add-on which can be used to achieve this? How does most organization maintain design documentation for workspaces?Can FME Server expose REST APIs that are created by developers or we absolutely need to get a 3rd party API Gateway (AWS, etc.) for hosting APIs, security, etc?What capabilities FME provides for monitoring (performance, errors, etc.) or all of this has to be designed by developers?What additional tools are required in the Integration Stack to support basic patterns like APIs and Messaging ? What does your implementation have.Any pointers to documentation that

HeyI recently learned through this webinar: "Creating No Code Web Apps with FME Server" how to create an app with the help of the server, and thus optimize our work.It is explicitly stated that the application can be embedded in any external site. Just copy and paste.When I tried to create the app, it would not let me access the app from an external computer. (The server is currently installed on only one computer.)What do you need to do to have outside access to these apps? Thanks  Dor

I am looking for the possibility to process the status message of a FME script (Translation SUCESSFULL / Translation FAILED) within a Python script, or to stop the script as soon as the processing was not successful.Currently I call my workbench inside a Python loop and process a (first) part of the data. Then I call the Workbench with the next part of my data and so on. Unfortunately, with my current workflow, I have no way to see when my Workbench generates an error in between and actually terminates. Within my loop, it continues and moves on to the next part.Currently I generate my argument using a function:def get_arguments(GDB, CSV, Start_Object_ID, Last_Object_ID):    arguments = []    if GDB:        arguments.append('--DestDataset_GEODATABASE_FILE "{}"'.format(GDB))    if CSV:        arguments.append('--DestDataset_CSV2 "{}"'.format(CSV))            if Start_Object_ID:        arguments.append('--Start_Obje

Hi,I want use automations to concatenate workbenchs published in FME Server. But I want use the result of the first workbench to use in second workbech as a reader data. In first workbench I use a FME Server Automation Writter, but I can't configure the Automation to get my finality. Is possible this scenario?Thanks! 

I have two tables, they have the unique ID to compare with each other. There is another column called year in both tables. I am hoping to find records in table2 with the same ID in table1 and then compare the 'year' attribute, only keep the latest one. Which transformer should I use? The feature joiner can find all records in table 2, but it can't dynamically decide which one to keep.  

I am using system caller in child workbench which trigger 3rd party service using command line and start the process e.g. abc.exe in windows. Sometimes process get stuck at their server and I am not able to get the status of the same, hence child workbench continue until any response gets from System caller. Is there any solution to kill the 3rd party process using windows process name or ID if its taking more than a particular time e.g. 1 hr?Note: I am using FME Desktop with concurrent process of 3 jobs, so it should kill only the process which are not getting finished within 1 hr.Can anyone help me on this?

Have two automations happening where one downloads files off an Azure Blob storage. The other is actively listening to the folder where the first automation downloads files too to trigger a workspace. My problem is that for some reason AzureBlobStorageConnector sometimes downloads files as 0kb. Is that cause it's trying to download files that haven't fully uploaded to that Azure Blob Storage? I.e the same thing that happens when you download something off the internet and it goes to the download folder as a temp file - until it downloads fully. CheersDan

I want to terminate child workbench automatically if its taking more than the expected time (e.g. 30 min). Also it should be treated as successful translation in the workspace runner so that next job in queue can start concurrently. Is there any solution?

I was using Httpcaller for an automation but I could not get it to work. The URL to the service I wanted to use worked fine in the browser but when my automation ran, it resulted in an error from the service saying "invalid URL". It turned out that my URL contained spaces that was encoded as %20 wich the Httpcaller encoded in turn to %2520. Replacing %20 with a space in the Httpcaller solved the problem. Is this desired behaviour? I'd excpect the Httpcaller to understand not to encode an URL that is already encoded.

Do I need to refresh the "Run Workspace" action in an Automation on FME Server when I make an expression change in an Attribute Manager in the workspace? I've published the updated workspace to FME Server already. Will the Automation run the newest version of the workspace? Or do I need to make it "see" the change somehow?

I have built a simple Automation that is set up to read in email attachments, process them in workspace 1, and then move the attachment files to another folder location in workspace 2. The trigger is an IMAP trigger, which polls every 10 min. This means that sometimes, there are two or more emails waiting to be processed when the email is polled. When this happens I would like email 1 files to be processed through both workspace 1 and 2, before moving on to email 2, but I am having trouble setting this up. Currently, my job logs show:Workspace 1Workspace 1Workspace 2Workspace 2But I would like them to process in a different order so the job logs would look like this:Workspace 1Workspace 2Workspace 1Workspace 2I had a similar Automation set up and working this