FME Form

I have a workspace where I gather the data from the web and upload on data base whenever data available my script run and load the data on the database with truncate.  now the issue is on the source table remove the data until new data is not availableso when I run the script the feature reader shows me nothing. so how can I truncate as well until new data is not available?   as you can see Advisory Wind don't have records from source so if there is record i need to truncate my table  

I'm struggling with a date that I want to extrapolate based on a frequency. The maximum latest date is the end of the year.My columns are:routefrequency_daysdate_startHow can i realize this in the right way?

I am able to use a python scripted parameter to get the list of field names/attributes and they do populate with the scripted parameter as expected, however, when the scripted parameter is plugged into a FeatureReader to expose attributes, it fails. Example:Scripted Parameter Name: $(scriptedParameter)Returns the value of:OBJECTID COMPONENT SITE_NAME JOINT_BASE STATE_TERR COUNTRY OPER_STAT IS_FIRRMA SE_ANNO_CAD_DATA SHAPE_LENG Shape_Length Shape_Area However, when using the same scripted parameter in the FeatureReader Transformer - Generic Port - Attributes to Expose, the result is missing values in an attribute called $(scriptedParamter) (the same name as the parameter). If I hardcode the value of the parameter to my list of attributes, things work fine. Is this a bug with the FeatureReader transformer, or do scripted parameters not work in the FeatureReader

We are in change our FME-Desktops to a new machine. Same WindowsUser, same Version -> our SQL Server Database Connection is not working on the new Server.By defining a database connection (Windows authentication) the Error below appears. Microsoft SQL Server Non-Spatial Reader: Trying to connect using Microsoft OLE DB Driver for SQL Server...Microsoft SQL Server Non-Spatial Reader: Failed to connect using Microsoft OLE DB Driver for SQL Server. Provider error '(-2147467259) TCP Provider: The wait operation timed out.'. Connection string 'Provider=MSOLEDBSQL;DataTypeCompatibility=80;Data Source=XXXX\\sql1;Initial Catalog=XXXX;Integrated Security=SSPI'Failed to open readerUniversalReader -- readSchema resulted in 0 schema features being returned 

I've got several workspaces open at one time, and have a hard time switching between them using the Windows Taskbar because their names are "MULTI - MULTI", "SHAPEFILE - MULTI" etc.  I know Alt-Tab will cycle through, but I usually want to click on the taskbar to bring it to the foreground. Is there a way to display the file name instead on the Taskbar? Not the directory as these get pretty long. So it shows "land-use.fmw", "birds-of-prey.fmw", "routing.fmw" or whatever. Here's what I've got open right now:

I have thousands of JSON files, containing metadata. Although these all metadata are not relevant, hence tried to filter out only relevant data using test conditions. The problem is that the JSON file structure is a bit inconsistent.For example- I want to extract "Roll" data from JSONs and when exposing the attribute through the "Attribute Exploder" transformer, it shows data varies widely from one JSON to another (see the below example)metadata{20}.metadata.rollmetadata{43}.metadata.rollmetadata{45}.metadata.rollmetadata{52}.metadata.rollmetadata{106}.metadata.rollmetadata{844}.metadata.roll etc. etc. Now I am trying to find the "Roll" data using test condition within the "Tester" transformer (see below example) I k

Hi forum Looking for a bit of help with the using the HTTPCaller to query a polygon area on an Image Service. PointsI’ve got the DTM image service from the Environment agency, which I’ve been using to extract the DTM height value for certain points. I’ve been using the “identify” function through the HTTPCaller in FME, and then some JSON extraction to get out the height value. All great and working. PolygonsI’ve now got some polygons, and I want to find the lowest height within the polygon footprint (added bonus, maybe also the lowest point on the perimeter too. Not essential).Looking at the

I've got a server app that uses an HTMLReportGenerator to create a simple web page. It contains a few paragraphs, a table and a very simple SVG chart. However, when I run it from Edge, the SVG is missing, and line spacing and font sizes are different. In Chrome it's fine.However, if I do View Source, copy the html into a new doc and open that in Edge it looks as expected. Styling is within the html, except that which it references from bootstrap@4.5.3/dist/css/bootstrap.min.css

I need to remove duplicates from varying sized datasets. Would it be more efficient to use a sorter with a sampler or a statistical calculator with a tester?

I am getting an error when I write to ArcGis Layer I tried everything but still getting eroor ArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server was '' and the message was: 'Could not access any server machines. Please contact your system administrator.'. Details: ''

Looking at this article writing using the XSD XML Writer: https://community.safe.com/s/article/XSD-Driven-XML It seems that it is not possible to nest features together using xml_id and xml_parentid and having multiple features to write. For that example I want to be able to have two featurewriters as shown below, the cap:alert and the cap:info. The way they are grouped together is that the cap:info has an xml_id and xml_parent_id which links it to the correct cap:info. I thought that woudl work, but no.... Is there no way to write complex nested xml-features other than "merging them in the workspace"?

I would like to replace the content of one node in XML fragments (SLD/SE), which I import into FME. I merge these fragments to other features with the values for the replacement and want to do the replacement for each feature.With the XMLUpdater that seemed to be an easy task. Nevertheless, using the configuration as shown in the attached workspace, the contents of the node allways gets replaced by the value of the last incoming feature, not the value of the feature with the corresponding XML fragment. I read a lot of articles here in the FME community but could not find out what I am doing wrong. Do I missunderstand the function of the updater?

The tolerance in TINGenerator does not seem to do anything? I have a workspace where a geotiff gets converted to a pointcloud for some processing before running through a TINGenerator. I have tried values between 1 and 1000 but it always outputs the same amount of VertexPoints. Only thing that makes any difference is if I set the value to 0, then the amount of vertexpoints get multiplied by a million. In the same workspace I also use a PointCloudCombiner. Where the value of the point interval does not seem to make any difference. Does the workspace need to be set up in a specific way in order for the above to work? Or have I just missunderstood what the values are supposed to do?

I have a pretty complicated model which has many input data sets, transformers and lots of intermediatary data. I need to write a summary of the statistics at the end of the procedure including total area of results, proportions and ratios taken from the data. Which Transformers could I use to select or create statistical summaries and write them to text?

Hello,I would like to present for you new approach for testing data in FME :). The prototype is on FME Hub or just ping me for more details via michpil@gmail.com. Thanks,Michal Pilarski

I am creating a process that is going to move 3.5 million records from a SQL server db to a destination. The target can only be interacted with over SOAP. I am using a python caller to make the SOAP call because the HTTPCaller could not handle the challenge authentication method the target enforces. I am batching the rows into groups of 20,000, creating the XML and passing that to the python caller as a single feature per batch. The calls become progressively slower throughout the run of the job. They start out around 4 seconds between batches and after 130 calls the time to process is around 130 seconds.  

I am trying to use a HTTPCaller to call a website.The problem is that the website first is showing a loading-page while it's loading some data and after up to 8 seconds the new page is showing.The problem is that the HTTPCaller just gets the loading-page. Is there a way to let the HTTPCaller to wait until the new page is retrieved?

I have stumbled across a raster size problem in RasterExpressionEvaluator whereas two input rasters are clipped using Clipper to the exact same shape, however some of them upon arriving for raster calculation differ by one pixel.The problem is that although all input rasters are of different sizes only some in several hundred will result in this error quite randomly despite use of clipping that should cut them precisely to same size.|ERROR |RasterExpressionEvaluator_2(RasterEvaluationFactory): Raster A has '2119' rows and '2042' columns, whereas raster B has '2120' rows and '2042' columns. Paired rasters must have the same dimensions

I have an AGOL reader that I read many attributes from. This works great but, I also need to read the latitude and longitude for each record. I've done searches and read documentation but can't find the answer. Can someone help me? I've attached the Parameters tab from my AGOL Reader if that's relevant. Thanks.

i have different data and i would like to have all data in one view at FME inspector to show all of them together .How could i achieve that ? Thanks in advanced .FME 2021  

Currently we hardcoded the ‘URL’ & ‘Target File’ attributes in our FTPCaller parameters:Is there a way to specific them in a more dynamic way? For example, ‘Operating Account Structure - Export Budget 2022-09-22_13_27_55_PDT.csv’, the '‘Operating Account Structure - Export Budget ' part is static and '2022-09-22_13_27_55_PDT' part is dynamic date/time. How can we specific the dynamic part with wildcard something like ‘Operating Account Structure - Export Budget%.csv'? Thanks. 

i am trying to get the data in api but its only showing me the file name not shoing thw data http://40.76.139.235/fmerest/v3/resources/connections/FME_SHAREDRESOURCE_DATA/filesys/resttraining/Test.json?token=93c5c6c2-2025-411a-955a-cb481cf01c40 Output should be like this  https://www.nhc.noaa.gov/CurrentStorms.json

Hello, I have a line file that I need to divide into 5 mile sections. At each 5 mile point, I need to create a perpendicular line off to the left side of the line. I need this line to be certain lengths or be able to divide the line into sections afterwards. I need to then export the coordinates of each vertex along the perpendicular line. Please see my drawing what I'm looking to create. I need the coordinates of each location where there is a home placed on the drawing. Thanks!  

I have a large FME desktop workspace that works great. It reads an ArcGIS Online feature service (2 tables), joins the 2 tables, makes many, many changes (new attributes, etc.), then writes to a different ArcGIS Online feature service (1 table). I plan to run this daily with a batch file using the Task Scheduler. The destination table is published to a group of people. My issue/question is that I need 1 to 3 attributes to be reviewed. Usually a few records (out of several hundred) need to be modified. I'm sorry my question is vague. I'm thinking that there may be way to write (publish) a few attributes to a software solution to facilitate approval records after reviewing a few attributes. The few records that aren't approved would be flagged then I would manually make the change in the ArcGIS source. An example would be removing PII such as a person's name.

I have a street centerline Feature Class in a File GDB. I did a topology check in ArcGIS Desktop and it identified two streets that are overlapping one on top of the other (each street is identical in length). In FME, I set up a workbench with the SpatialFilter Transformer and two Inspectors to do a topology check. In the SpatialFilter I have tried using all the Spatial Predicates to test one at a time. FME does not call out these two overlapping street segments as does ArcGIS Desktop and ArcGIS Pro.  Maybe if I set a Parameter Condition Definition based on Shape_Length attribute field it might work?  Fyi, I am using this data as a test to help me improve my FME skills. Any ideas on how to get FME to call out these two streets?  Here is a screen capture of the two streets highlighted in red as seen in ArcGIS Desktop.