Best Answers

I would like my automation to watch a directory. If there's a update, then the rest of the automation runs, but only during the night.I could use a directory watch trigger to run the automation immediately after a change, or use the schedule-trigger to run the automation during the night, but how can I combine those triggers?Thanks, Vera

I'll be the first to admit this may be a dumb newbie question, but I'm struggling! I have an input field that contains a file path like the following:q:\\staging\\incoming\\1930s\\WI\\Sauk\\1937\\Sauk_WI_WU_11_908_19370707.tifI need to construct a URL to the file as referenced in a URL, and dump it into another field:https://server.com/1930s/WI/Sauk/1937/Sauk_WI_WU_11_908_19370707.tif My conceptual approach has been to use string processing to replace q:\\staging\\incoming with https://server.com, and then replace backslashes with forward slashes. Well, you can see where this is going... the slashes and backslashes are wreaking havoc. For example, I've tried various combinations to escape the \\, like:@ReplaceString(@Value(inputpath),"/\\","/")... but I either get no results, or a syntax notice. Am I even in the ballpark?? I'd love some suggestions on how to approach this issue.  

@nielsgerrits​  I have a road shape file with numerous segments (links), all of which share the same road id. Now the user has provided me with csv data, claiming that this is the bad route from chainage 0.75 to chainage 5.1. In order to highlight the road, I must add another line geometry (a long line) on top of road features. The created line must overlay eactly on top of road. the created line begins at link 1 (0.75 chainage far)and extends to link 9 at a 5.1 chainage. How do I accomplish this with fme? I tried a lot of different things, but none worked. Actual line length and chainage length are two different metrics. We can take the proportionately dividing road length since chainage length is accurateWhat I mean is that if the real length of the line is 1.5 km and the start chainage and end chainage (attributes) difference is 1 km, then it becomes 100 m = 150 m in geom length. sample source shape file attachedand source shape ,desired output line, how it looks like( jpg files) 

Hello,I use FME to transform data in S-57 format (the native format of our databases) into more traditional formats, in particular shapefiles. The database export is therefore in S-57 format (extension .000), with the classes and attributes present for the ENCs, but this model is enriched with additional attributes and classes. This can be done by modifying the files s57attributes.csv, s57objectclasses.csv and s57expectedinput.csv in the directory $FME_HOME/s57 (Custom Object Classes File and Custom Attributes File). These files are also useful for correctly displaying additional attributes and classes in QGis (in the directory C:\\Program Files<QGIS>\\share\\gdal). While in QGis an S-57 file with additional classes and attributes is displayed correctly, this is not the case in FME.For additional classes: some are handled correctly, others generate an error when read and you can't go further in the processing (there are also cases where the class seems to be ignored, without

I want to extract data within the masked polygon by using FME. Can you please guide me how it should be done. Which transformer to use?

I have the 2023 beta and authored a workspace that I would like to use in your latest official version (2022.2.5) which came out after. It looks like a number of updates that were in the beta are also in the official one. Before I try to open my beta workspace in 2022.2.5, I had a few questions: If the updated transformer versions match, should the prod version accept them?What is the best way to back up or document a workspace to use in an earlier version? Any insight is appreciated, and yes, I learned my lesson.

Hi, I published a workspace to the FME Server (2018) of my client that allows to import a specific sheet of an Excel file in Postgres.But when the input file has zero feature or when the specific sheet doesn't exists, the Workspace doesn't log any error and says that translation was successfull.Of course, we could open the Excel file to check the data but this workspace is running with automatic processes.Is there a way to log an error when there are no features in the input file or when the awaited feature type (Excel sheet) not exists ?Thanks for any help.

I am taking a feature reader (ESRI geodatabase) and putting a feature class through an attribute manager. The feature reader shows the guid fields correctly as guid.However, the attribute manager shows them guid fields as buffer.This is happening for all guid field. I've tried "reset table" and import from dataset in the attribute manager. I've also tried recreating the attribute manager. How can I fix the attribute types to be accuate?

I have a Data collected using Survey123 but sending data has issue and it was stored in android device only , so the format will be in sqlite database.. I want to extract the data from SQLite database and im able to read and see the data but not able take it into XML Fragmentor ..May be im doing some wrong.. I have attached screenshot and workspace ..Need Guidance and advice to fix this Thank YouNeed expert advice 

I'd like to divide my 3D polylines by 3.28084 (feet to meters) - I think I'm close with 3D Forcer, using Arithmetic Editor but it's not quite working... @ZValue()/3.28084

Hi all, I have a very simple requirement, find the closest location on a polygon to some points then move the points to that location, this has been achieved using the NeighborFinder and VertexCreator transformers. Further on in the workspace I need to use a PointOnAreaOverlayer to transfer the polygon attributes to the point layer (I realise that this can be done in the NeighborFinder step but for the sake of this post, lets assume this is not possible). The issue I am coming up against is that even though the new location of the point is determined by the NeighborFinder, in some cases the point and area are not considered to be overlapping by the PointOnAreaOverlayer. This is my very simple demonstration workspace:The initial features do not overlap:Once run through the workspace they appear to overlap:However, according to the PointOnAreaOverlayer, one of the points does not overlap:The point that does not overlap (according to the PointOnAreaOverlayer) is the southern most point (

Hello,I am creating a josn using the json Templater. In my setting i have a subtemplate that must to be an "object" and contain a lot off nested attributes that are "list".In the situation where only 1 attribute is populated, the final result is good (Topology1record.jpg screenshot) but when I have more attributes populated the result is an array and not an object (Topology2records.jpg screenshot). I also attached the templater to show what I did.My final result should be: {  "type" : "FeatureCollection",  "features" : [     {         "id" : "rfs:7BBE13D625241D58",        "properties" : {            "topologyCharacteristics" : {                  "isPaved" : [                    {                       "range" : {                          "endOffset" : 1,                          "startOffset" : 0                       },                       "value&

Hi,When I try to run a workspace on the FME server, I receive this error. On my machine, I have ArcMap and Pro installed with 64-bit background geoprocessing. I am also reading data from File Geodb using the Esri Geodatabase (File Geodb) readerArcGIS Enterprise 10.9.1 has been upgraded to ArcGIS Enterprise 11.0, and I am running FME Desktop 2022.0.1.0 and FME Server 2022.0.0.2. It is unclear why I am getting this error. Is it because we have upgraded ArcGIS Enterprise and are using FME Desktop 2022.0.1.0?  Thank you,

I am looking extract data from a csv file, (1) all open orders and (2) all closed orders within the last 90 days. Any recommendations. Thanks

I have the following XML:<?xml version="1.0" encoding="UTF-8"?><MyProblem> <Maat Name="MyName1" Description="LetsDoIt"> <Status_Maat Value="Open"/> </Maat> <Maat Name="MyName2"> <Status_Maat Value="Open"/> </Maat> <Procon Description="FinalCheck"/> <Precon Description="StopAndCheck"/> <Maat Name="MyName3" Description="LetsDoNothing"> <Status_Maat Value="Open"/> </Maat></MyProblem>I can extract the Maat with XMLXQueryExtrator by the following expression:/MyProblem/Maat Notepad++ XMLTools says the path to the Description is /MyProblem/Maat/@Description but this gives an error. And no results. What am I doing wrong?

i use transformer Testfilter to filter type of mutation. Ultimately, I want to know how many mutations there are per type. For that I use StatisticsCalculator.This works fine, except when no value comes from TestFilter. How do I get the process to continue and StatisticsCalculator returns a value of 0?

I have have a set of polygons (actually they are buffers of a point) and I want to buffer these again to leave a ring - just keeping the buffer outside the original polygon. I can do this easily in arc/arcpy by using the buffer type "OUTSIDE_ONLY". How can I get the same effect using FME? I have created the buffers but when I use the clipper to clip one out of the other it clips all the overlapping buffers (which is what I expected) but I can't seem to figure out how to get the result I would like. I feel like I need to split each of the the buffer datasets so that it does the clip on each pair of polygons separately but - I'm new-ish to FME so.... Can't seem to find anything to help online either. This is what I have - the attribute managers are just to fill in an attribute so I can put the two buffers back together in one layer and be able to identify which polygon is which type.This is what I would like to end up with:Not this:

Hi I have installed GoogleCloudPubSubConnector from the hub but I am unable to use it since it keeps failing the test for web service authentication.https://hub.safe.com/publishers/safe/packages/google-cloud-pubsub I can't proceed further, I always receive this error message:Error 401: disabled_clientSign in with Google temporarily disabled for this app. This app has not been verified yet by Google in order to use Google Sign In.  Does anybody encounter this before? Thank you 

Hi there, I'm running into an issue where an attribute that was initially numeric ('counts') is being converted to a character type after I sum 'counts' for each 'tree_type' per 'area_unit' using AttributePivoter (example left to right in image below). Note: These attributes/data are just an example. This is a problem as I'm trying to write the results as a shapefile, which won't work properly for analysis in ArcGIS Pro as it recognises these fields as text rather than integer. Here are more details about my process for summing counts of tree types by area unit.  Input = CSV and 'counts' is read in as UInt32. 1.) I used an AttributeExploder with exploding type set to List, Keep Attributes = Yes, and Keep Geometry = No (Geometry is added later).2.) AttributePivoter, Group Rows By: = 'area_unit', Group Columns By: = 'tree_type', Attributes To Analyze: = 'counts', Pivot Summary Statistic Types: = Sum, Row Group Su

I can't find a way to do what I want.I got a certain number of features. I want to find the max(date) on attribute date for those features, but I want the max(date) to be in relation to a condition on a value from an another attribute status.  So I want the max(date) to be calculated and returned first from feature where status = completedif no features have a status=completed then returned max(date) from the other features 1 20230330 completed2 20230329 completed3 20230331 running4 20230329 waitingwould returned max(date) from feature 1 : 20230330 1 20230330 waiting2 20230329 running3 20230331 running4 20230331 waitingwould returned max(date) from feature 3 or 4 since no value set to completed :20230331  

Hi Everyone I am slightly bamboozled and wanted to know if someone knows where I am going wrong or if this is a potential bug.I have had used the FME Cloud and FME Server for loads of FME Server Apps, and havent come across this issue so far. I get the following warning after running a fme server app I am converting a .dwg file to an excel file.  If I use a feature_reader set for readings dwg:Autodesk AutoCAD DWG/DXFI get the warning, that the no output can be generated. But if I read an ifc and convert it to excel, all is well.  Is there maybe a problem reading dwgs? Why is there no output generated? The FME Server Jobs show that the job is completed without any errors. I have uploaded a .dwg and .ifc and the workspace regardsFred 

Is there a transformer that will convert a multilinestring to a linestring object? I'm trying to load road centrelines in an oracle spatial database, but the road centreline table in oracle uses GTYPE 2002 (line). Multilinestring is 2006, so I can't apply a spatial index. Any suggestions please?

Hi there,Slightly off the wall here, but has anyone created a workspace that can create Bingo cards? Ideally a 5x3 grid of random numbers between 1-90, but no repeating numbers...?Obviously, RandomNumberGenerator can give us a way to actually play the game...but I'm thinking whether FME can create the cards for users to play with..?Thanks!

How to dissolve polygons based on an attribute where a dissolved record will include non touching polygons with the same attribute? Using Multi Polygon geometry

Hello, I am writing to an excel sheet with an existing template. Before the writer, I am using a counter (starting at 0) and attribute creator to then use "Use attribute names as column positions" and "Row number attribute". My attributes are B, C and D which are various strings and B_row_number (@Evaluate(16*@Value(_count)+10)) and CD_row_number (@Evaluate(16*@Value(_count)+16)). I would like the output sheet to look like the image below:Unfortunately, I can't assign different "Row Number Attributes" to arrange it this way (B using B_row_number, and C,D usin CD_row_number). I get the feeling there is a simple workaround I'm not seeing. Any help is appreciated! Thank you.