FME Form

I have one line command. This command works manually in cmd command windows. When I try with fme systemcaller it does not work. What could be the problem? Fme version 2021.1.1.0 build 21619example:xcopy "@Value(png_source)" "@Value(png_dest)*"xcopy "C:\\gml\\F-12696263-A.png" "C:\\gml\\gml\\F-23-A.png*"

I am trying to read metadata in FGDC format from a feature class using a python script and workspace runner to call in a workbench. I want to know how I can set a parameter to call a feature class from a geodatabase.

@Takashi Iijima​ I need to separate text values for 'Texas_WellsTexas_WellsTOOOBIN_BOUNDTOOOBIN_TXTexas_Wells' as Texas_Wells Texas_Wells TOOOBIN_BOUND TOOOBIN_TX Texas_Wellscan you please help in building text to replace query?

Hi, community! I have not found any solutions to this problem in FME. The problem is to create underground terrain surface for each polygon class (such as clay, sand or gravel in this case <MRR, MRR, KM and MKM).  Polygon classes have different z coordinate (from 1.8 to -8.7) and the colors represent their classes. I want to find a way to merge/dissolve the nearest polygons in the z coordinate (begin from the top) of each class to create terrain surface, see image below.  For example, the gray color (see image below) should find the nearest gray color within a z range of 0.5 m or auto, and the next gray color should find the next closest gray color downwards and so on. If a green color is between two grays, the upper gray will stop merging/dissolving on the lower gray. The same pr

Hi All,Helped by info in this forum I constructed a loop in the JSONTemplater, to loop through a list and make a json array based on info if a certain condition is true. This works, I use a $i to reference to the index in the list. In a different counter $c I would like to keep up with how many values are entered i the array and use this value in the array as wel, but I can't get the $c counter to count up.This is what I have so far:[{let $top5s := fme:get-list-attribute("_prio{}.top5")let $themas := fme:get-list-attribute("_prio{}.thema")let $deelthemas := fme:get-list-attribute("_prio{}.deelthema")let $c := 0for $top5 at $i in $top5swhere xs:string($top5s[$i]) eq "Ja"let $c := $c + 1return {"titels": "Projectambitie " || $c ||": " || $deelthemas[$i]  ,        "teksten": "Op basis van de locatie vraagt " || $deelthemas[$i] || " aandacht in je project."    }}]It works, only

Hello FME'ers and welcome to What's Up Wednesday... Safe World Tour NewsLet's start with news about Safe's event on the FME World Tour. We call it a virtual brunch-and-learn, and it takes place on April 5th and 6th.  Day 1 is a set of higher-level talks about the value of FME and how it helps to fuel business decisions. Day 2 is a more technical series of talks with specific demonstrations and examples. Meanwhile, before the event starts, you can also take part in our Data-Driven Photo Contest:  Not only do you get to dress

Firstly, we have extracted the Schema of this Oracle database (sde) in MySQL FGDB format in ArcGIS Pro exporting this schema.Now, in FME Desktop I need to connect to Oracle database server and get this data as per feature classes present in datasets with all the attribution and its values with geometry in this MySQL FGDB Schema imported.Need help on this and which transformers can be used to get this Oracle data migrated in MySQL database Schema FGDB.  

How can I reference the CSV created from a Writer to upload to AWS S3 using S3Connector? I can successfully use a Reader to reference a file on my computer and upload to AWS S3 using my Web Connection and S3Connector, but I don't know how to reference a newly created file within my worflow. See attached.

Hi, I have 2 layers with points features in shp. I want to create a tool that finds the nearest point from another layer of points only if the layer as the matching attributes and then snap to the nearest point, regardless of the distance, only the one that is closer to it and has the matching attributes. Example: 2 points with a oak attribute as sort. ​Thanks ahead! Isabelle

I was wondering, if there is a difference, how the two things work?I create Lists in a Spatialrelator, and I need to sum over some of their values. As I have a lot of data, I want to remove the lists after summation, and i think feature.removeAttribute('_relationship{}') does the trick. However if I add an AttributeRemover afterwards, under Lists it shows me the _relationship{} List, so it wasn't removed by feature.removeAttribute() ?

Hi. I write data to an excel file using an excel template. I also make use of a Python script to upload the newly created excel file to SmartSheet making use of the API. The program runs perfectly from FME Workbench, but when I run it on FME Server, I get the following error message in the log: "Python Exception <FileNotFoundError>: [Errno 2] No such file or directory:"  I have similar files running and working on FME server, but they do not make use of a template file. The error message pertains to the path of the template file, which is in the same directory where the dataset is written to.

hi,I have the following json time series and would like to convert it to a table structure.so per time and value an own row with all station information.Unfortunately I can't find a corresponding example in the FME help. [    {        "ts_id": "19690010",        "station_name": "Badinghagen W",        "station_latitude": "51.084693593981505",        "station_longitude": "7.650786142144193",        "parametertype_name": "Niederschlagshöhe (N)",        "ts_name": "Tag.Summe",        "ts_unitname": "Millimeter",        "ts_unitsymbol": "mm",        "station_no": "13100039",        "station_id": "12918",        "rows": "4",        "columns": "Timestamp,Value",        "data": [            [                "2022-03-18",                0.03            ],            [                "2022-03-19",                0.00

Hello sir/ madam, I want to output my result as a HTML format. I want to output my source data (let say I have 3 source data) on new line.Like this: abccdefgh May I ask how to do it?I am not sure why mine is still on the same line. ( i have uploaded my capture screen below). Thank you. Zach 

I'm new to FME. I have an attribute that contains an alphanumeric code. I need to use this code to look up a name in an Excel sheet. I'd like create a new attribute with this name. I think that DatabaseJoiner may be the correct transformer but I haven't been able to get it to work. If possible, if the looked-up name equals "No Data" I'd like to get the name from a different column. Thanks.

I am attempting to add a new web connection/web service that I have created from the Esri ArcGIS Online service with my own app ID/secret.  I have tried to upload the web connection both during workspace publication and also through the Manage Services dialog. In both cases, I am getting the following error: Web service upload failed - FME Server encountered an error and reported the following message.929018:FME Error: Unable to create derived service from a non system web service..  Please contact Safe Support for more informationThis is happening both on our on premise FME Server (version 2021.2.3), as well as an FME Cloud instance (2021.2.2). I tested from another computer and was able to successfully upload the connection from Workbench there, running 2021.2.3 on both machines. I have already tried uninstalling FME, deleting the FME folder from my Program Files, restarting, and deleting the registry entries under H

I have a spatial filter that isn't giving me the correct result. I am trying to determine if a feature falls within a polygon. If it does it should pass. If it doesn't it should fail. I know the feature is within the polygon and therefore should be 'passing' but instead it keeps failing. I'm assuming I have something set incorrectly. These are my parameters: Filter type: Multiple FiltersPass Criteria: Pass against one filterSupport Mode: Support aggregatesSpatial Predicates to test: Contains candidate, touches candidate, intersects candidateUse bounding box: noCurve boundary rule: Default rule Merge attributes is selectedAccumulation mode: Merge FilterConflict resolution: Use candidate Preserves Feature Order: Per output port

Hello, I am looking at trying to build a transversal gain function for numeric rasters. I have several elongated rasters which form corridors. These rasters have a decreasing mean value from one side to the other. Since these rasters have varying orientation it is not simple to establish the row column relationship from side to side.Do anyone have a tip for me how to be able to handle the distance relationship from side to side together with a custom built rasterexpressionevaluator to either scale up or down depending the spatial location in the raster.

Hello, I am looking for a solution for extracting appearance from geometry to get raster's and then adding georeference to it. Full problem:I have geometries that are divided into multiple files that have ortho photo appearance on them, I want to get all the appearances and combine them into one raster. Then Ill read another geometry and append the raster to that one using geometry coordinates.But when I use the AppearanceExtractor no georeference is added so I cant combine them into one or append them to the new geometry. Input geometry Any help would be appreciated, thanks.

PROBLEM 1 if in column TYP the value is PL than do nothing (keep the cell G1, H1, I1 empty) ******************************************** PROBLEM 2 if in column TYP the value is PEthan calculate value in "x1 in (m)" check condition "F is W" or "F is E" or F is S" here the condition is "F is W" so fill in default value from "Y in (m)" to "y1 in (mm)" and from "Z in (m)" to "z1 in (m)"   FORMULA to calculate/obtain value in "x1 in (m)" i.e. 1960.85 from the DIM in (mm) always select the first value before "x" for i.e. 600 and convert it from millimeter (mm) into meter (m) i.e. 600/1000 = 0.6 now add the result i.e. "X in (m)" + "0.6" ******************************************** PROBLEM 3 if

The attributes should be visible in the AutoCAD properties dialog.I have been able to write "extended attributes" that you can list with the XDLIST command in Autocad but I want to write attributes that are visible in the properties dialog in Autocad.   Can anyone provide some advice on this or a sample. I think it must be simple but I am missing something???!

Hi,When downloading a geojson file through S3, I get a _content attribute containing my file's content. How can i convert it to geojson and write a geojson file (I do not want to use the S3Connector download to file as it does not let me name the file the way I want).

I currently have 2 datasets - one is a set of records with a date attribute. The other is a schedule dataset with 2 attributes indicating the start and finish dates. I am trying to identify how I can query whether a record in dataset one is within the range of the start and end dates of dataset two, and then subsequently count the number of times each record appears in the range of dates The end result ideally is something similar to the statistics calculator where I would see each record with an extra attribute with a numerical value indicative of how many times that date has occurred in the range of the schedule dataset.

Hi there, I have merged two tables by using FeatureMerger and kept some attributes by using AttributeKeeper. when I am writing this merged table to Excel by using Writer, I am asked to choose a feature type from two. If I select one, the writes takes all attribute from one type. In that instance, some attributes from the merged table are left out. Can anyone kindly tell me how to overcome this issue? A screenshot is attached here. Thanks in advance.

I would like to be notified if there is any wrong attribute value in a non-spatial table which is read from SQL database by comparing with an spatial attribute table. In other way, I want to detect change if the attribute of a particular entry/row is different from each other. I have intentionally changed attribute values for two entries so that these two are picked. Both tables have few common fields but the schemas of the tables are not same. I have tried with changeDetector, Matcher and DuplicateFilter but not getting the actual outcome. Any help will be very appreciated.  In the attached image, 1 is the non-spatial table and 2 is the spatial attribute table. I have used attribute manager so that the attribute names in interest in both tables are same.  

hellowe migrated to new sql server (names changed from SERVER1 to SERVER2) and now jobs is failing.i open failing fmw file in FMW Workbench, changed sql server names in parameters (where found), saved file, but jobs keep failing.any suggestions?thanks.