Best Answers

I have a workbench intended to run daily on FME Server. It does the usual data transformation stuff and then it email reports to a member of staff once per week. The report contains information relating to contractor performance over a 30 day period. I only want to send out a report if there's in new activity in the past 30 days. Currently, I have 9 x reports (one for each contractor). The reports are updated daily. I want the Emailer transformer to email only those reports containing new activity. I have gotten as far as calculating which reports are valid (i.e. within 30days) and using an Attribute Creator to fanout a new attribute, being the path & filename of the report. The Emailer then reads the fanout parameter as the Source File, picks it up and sends it. The problem is, the Emailer is sending each attachment in individual emails. I want the transformer to recognise which reports are valid and then send them together in a single email. The image I have attached shows 5

I'm having some issues with our FME Server which I don't understand. Every now and then, when running a nightly scheduled job, a FeatureReader fails to read a CSV file. The log returns:Trying to find a DYNAMIC plugin for reader named `CSV2'Library 'D:\Program Files\FMEServer\Server\fme\plugins/CSV2.dll' was found but could not be loaded. Ensure that all the dependent modules exist for this libraryModule 'CSV2' is unavailable for use with this FME editionWhen I resubmit the job, everything works fine... which is great for the data being processed, but harder to debug. The issue feels somewhat familiar and I did find similar questions but not related to CSV2.dll.I'm quite sure this is not related to desktop/server versions. Version is 2019.1.2.As far as I am aware nothing has changed in the installation, I do know the certificates were replaced recently but I doubt this has anything to do with it. Not sure where I should start looking, can anyone point me in the right direction? Update: 

 I get a very vague error when running it: " Error running translation." and no other details. I have over 60 GB of space on the drive so it can't be a matter of space. Also 16 GB RAM and closed all other applications.

We would like to inventory our FME Server on all input and output data from our database. We have setup a workspace that calls the FME REST API and reads all input/output, but there is no way to read other transformers as it seems. Is there a way to read FeatureReaders/Writers from all the workspaces in FME Server somehow? Also we would like to get a list of pythoncallers and systemcallers etc.

Hello,I need to create a bounding box with 5-8 vertex for my polygones. The BoundingBoxReplacer has 4 vertex only. I tried the HullReplacer, but it creates too many vertex - 10-20. But need only 5-8 vertes around my polygone.Do you have an idea?Thank you anyway.Regards

Trying to figure out how to do that with FME Server 2022.2.3Have the user fill a form ( my guess: Server App with User Parameters)Validate the data entered by the user (lookup into a database for existing value)If the data is good, process the data and confirm the user that the processing succeeded.If there are any errors in the user input, the user should be prompted to correct the input and submit for validation again.When data is submitted correctly, an email is sent to the supervisor with a link that will allow him to validate and complete extra data fields (such as authorization number)I thought that I would be able to do this with Server Apps, Automations or Webhooks, but I can't figure out how to direct the user to a "second step" input .Any Idea is welcome :) Thank you.

Hi! I’ve recently installed and licensed FME Desktop Esri Edition (on 32Bit) on a VM within an isolated network. I need to use the ArcSDE Geodb Reader of FME, to have access to Network and Relationship information, and as a pre-requisite I’ve also installed the ArcGIS Desktop (by default on 32Bit). I have not yet licensed the ArcGIS Desktop that I’ve installed along with the FME. Still, I can call and start to configure the ArcSDE Geodb Reader.My goal is to connect to several ArcGIS VMs within the same isolated network. I’ve received a bunch of .sde database connection files that I’ve used in the configuration of the ArcSDE Geodb Reader. I do not know exactly if these VMs that I’m trying to connect to are running just a database or have ArcGIS software installed and licensed as well (like ArcGIS Desktop, ArcGIS Server). I have little knowledge about the ArcGIS architecture. I know that there are several ArcGIS models dispersed on a bunch of VMs.My problem occurs in the set-up of the Ar

Hello, I am trying to read an excel file with FeatureReader but my excel file has an extra row before the true header row.  Row 1: Report TitleRow 2: Header RowRow 3-N: Data Is there a way to skip over the first row when reading in the file with FeatureReader? Thank you

I am having issues with using the payload that is being sent to the webhook in FME server. I have setup a webhook, I watched this video: https://www.safe.com/webinars/hook-line-and-sinker-reeling-in-arcgis-webhooks/ But I cannot set the same values in my ParameterFetcher and my Workspace on FME server is not allowing me to set anything with webhook.  I have the webhook created and I am able to log the webhook message to the logs and see the expected output. I am having issues sending it into an fme workspace.

I have this block of XML. <?xml version="1.0" encoding="UTF-16"?><place place_id="11703">  <gas_price type="regular">22.19</gas_price>  <gas_price type="premium">24.19</gas_price> </place> I used an XMLfragmenter to break up the big block of XML from the data source into the above snippets for different stations. But I can't figure out how to extract these using the XML transformers.  I am trying to get a result like this: ID | Price Premium | Price Regular11703 | 24.19 | 22.19 I know I'll probably have to transpose the data, but even before then I can't get the XML extractor or flattener to do anything to this little JSON snippet. Is there an obvious query to extract this using one of the transformers? Thanks

Hi all, I'm looking for the optimal way to create a 'mesh' of potential flow paths to use with the ShortestPathFinder. Currently I feed my workspace a polygon of interest, then to a point cloud of required spacing. Turn that into individual points and then connect them up in the 8 points of the compass using a NeighbourFinder/ListExploder/VertexCreator. My query with this is at the end I have to use the Matcher to remove lots of geometric duplicates where point A has connected to point B, and point B has connected to point A. Line direction is irrelevant to this task so I was wondering if anyone has any ideas as to how I could optimise this process?

I need to develop a .NET app to execute somo FME workspaces with FME Desktop.Before doing that, I would like to check if there is a license available (there are only two floating license). Is there a way of achieving that? I could assume that if the process doesn't start is due to license problems, but I was wondering if there is a better way. Thanks for any help provided.

Hello. Does anyone have knowledge of how to determine the sequential order of segments based on already created geometry? Or any other option? For example, I have L616 tracks where I need to combine the points in the list of fixes into one value. If I use the aggregator, I have values in one column, but the values are not consecutive, see the aggregator attachment - the aggregator writes segments - DENKO BINPO VELAB MISKA ETNEL PEKOT DESEN continues KEROP NIVIS VAL REDVA ?KOGAT ?BITLA and ends NIT TABIN ALAMU. It should be correctly DENKO BINPO VELAB MISHKA ETNEL PEKOT DESEN continues NIT TABIN ALAMU and ends KEROP NIVIS VAL REDVA ?KOGAT ?BITLAIndividual segments that have an expected trajectory from top to bottom are in the attachment. Thank you very much

I have 2 datasets of points created from the vertex extractor transformer. The 2 points have the same X, Y coordinate but differ in Z. I want to create vertical lines between these 2 points. I think this should be possible using the vertex creator transformer with 2 transformers after each other but can’t get it to work.

Does the constant interpolation method in the surfaceDraper transformer takes into account X, Y and Z coordinates (2.5D) or is it only looking at the closest 2D value in X and Y coordinates?

Hi I have a feature service that is apart of a Survey123 survey. The survey will indicate if something has failed in a variety of ways.  I currently have a workspace that has a testfilter transformer looking through 50 different attribute columns looking for the word Fail. Then from each output port there is an action that is taken. Is there a transformer that I could use to search the whole attribute table for the word fail instead? Thanks!

The caller just hangs.Works fine on desktop but not the server.I had to add a feature holder between the HTTP Caller and the XML templater. Any other suggestions?? That seems to be only part of the solution.

Hi Community. I am putting together a workbench to upload specific (Plan) files to a SFTP and while I was there I thought I'd add in to download a list of existing files, match them against the options to upload and add/remove only what is necessary. So in summary:Get list of plans on network drive (file and path directory reader). Success!Filter plan name against spatial file (determines if plan is needed or not). Success!Download list of plans currently on the SFTP (FTP caller with SSH-Authentication). Success!Filter needed plan names against plan names already existing on SFTP. Success!Delete plan files from SFTP no longer needed (FTP caller with SSH-Authentication). Success!Upload plan files to SFTP that are needed (FTP caller with SSH-Authentication). No success yet. I'm happy to upload the template file I'm just not sure that will assist without the keys needed to access the SFTP (can't give these out). The creator/attribute manager are there for testing some of t

I want to translate a shp file into gpkg format, but there is a id(32 bit int in shp) field in shp file. I can't do it via FME serverIt throw errors of3792023-3-7 11:28:17 | OGCGEOPACKAGE writer: OGCGEOPACKAGE writer: For feature type 'd_y_n40', primary key attribute 'id' has unsupported type 'mediumint'. Primary key must have type 'int,PrimaryKey'I try to use AttributeRenamer, But it is not working.How can I use AttributeRenamer in this caseThe attached is testing dataset

I need these translation log info to be part of my translation canvass so I can include them into the header of my report. I used to have this solution in place but I'm hoping to find a more efficient way to include the info in my canvass and not the shutdown. https://community.safe.com/s/question/0D54Q000080hedASAQ/using-the-processid-and-timestamp-as-my-log-name-failing-on-rename-with-py3x-but-not-27  

Hello, i have a list of files from an FTP server that I have read into a List. The last field in the list is the file name. The file name generally follows this format: "ProjectInfo_YYYYMMDD". YYYY is the four digit year, MM is the 2 digit month, and DD is the 2 digit day. I want to choose the one that matches today's date. I'm guessing this can be accomplished with the use of a user param or regular expression but I can't seem to find a reference on it. Any assistance would be appreciated.

Hi, I am writing to a Non spacial SQL Database, using a FeatureWriter.When INSERTing new rows in the table, a UniqueID is created by SQL database.Is there a way to retrieve that UniqueID after INSERT completed sucessfully ?I would need the UniqueID for the next step of my Workbench.I do a SQL Executor to select the last inserted row, it will work, but, if multiple rows are inserted simultaneously, there is a chance that I won't get the right UniqueID. Any Idea ?Thank you.

Is there a way to automatically set the datetime within a parameter and use it to fanout a dataset so that does not then create a folder for every minute the workspace was running.  I just want the initial date time the workspace was run. The default date time parameter is not really ideal for this as it defaults to midnight and requires user input. I'm hoping to not have to use a workspace runner. Using DateTimeNow seems to create multiple folders as the outputs are written.

Hi all, I'm using the AmazonAthenaConnector to query an Athena database.In the Translation Log I'm seeing:  "2023-03-10 09:04:27| 6.1| 0.0|INFORM|AmazonAthenaConnector: Query ran successfully. Run time: 5.225 seconds. Data scanned: 27694.09 kB" I'd like to use the info on the file size / Data scanned to do some cost calculation. 1: Is there a way to incorporate the output of the Translation Log as attributes in the workbench? Alternatively I guess I could load the .log file in a workbench and use that for the calculations... 2: I am wondering , can I run the main translation AND the .log file in the same workbench? (wait for the main translation to have finished so it can read in the log file and perform operations on that.)   

Morning all,I have points (A) at the intersections of streets/lines. Also I have points (B) scattered everywhere. I need to keep location points A at intersections but would like to bring attribute information from points B. Point A can get all other points around it and stacked at this location.