FME Form

Hello everyone! First time using and writting something in community. I apologize if this is not appropriate place to put this question and also if I'm not going to write it based on some rules. Anyhow: Long story short, I have FME workflow which is working how it should on Workbench. But when I publish it on FME server, for some reason it doesn't want to use all readers or writers are not working properly.  Readers:3 excel1 csv1 mdbWriters:1 excel Result from FME workbench: Result from FME server: As you can see, worksheets in results are different. I believe I did everything correct with setups in readers and writers (if needed, I can provide screenshots on how it looks like). Tried also to make new Readers/Writers. Tried to make different repository and put it there. Also weird warnings that appear after the workflow has been runned:  Again, I apologize if I missed the place to post this, or also if I didn't write this question correctly. Anyhow, looking forward on some

I have added the following items as a list on a user parametersRiceSoft wheatSunflowerCorn after the user selects the first three options, the output value is displayed on this formatRice "Soft wheat" Sunflower where as I would want to convert the above output onto the following format["Rice", "Soft wheat", "Sunflower"] Kindly suggest on how I could achieve the above output. Thank you. 

Hello,- What are the best settings to read a large XML-file (650Mb) on FME server?- Is there a better way to read this XML file? o XML flattener will hold with Optimizing Memory Usage o Shorter XML files (300Mb) run without any problems.thanks  I have the details placed in a document. thanks for your help

Hi,I need to transform the value of this column and a new column...the values are always the same.  Thank´s

Hi, i would like to ask, i need to type that "not equal" to Where clause, and the attribute value is stringI tried to type != and <> or not in and others and non of them worked. Maybe you know the answerThanks in advance

I have some photomesh files that I would like to turn into 2d top down raster images. Is there a way I can accomplish that in FME while preserving the georeferencing. Most of my viewing software allows me to export a snapshot, but the geocoordinates are not preserved.Original data (obj)Desired output (geotiff) I can't just use the texture files because they are spaghetti.

How do I set up my writer to only update after column 3? Or is there a transformer that locks the columns to prevent them from clearing every time there is an update? 

i would like to access for some data in Microsoft azure storage explorer .could i read the data directly from azure storage explorer by FME Desktop? Thanks in advance .FME Desktop 2021

I'm clipping a Raster with a number of polygons.As I'm using another software to then visualise the raster-file in 3d, I would like the oultine of the raster to be "smooth" and not "pixelated", is there a way to accomplish this?

I was told the data  "44821.76657" is the elapsed days and time since "1 Jan 1900"

Hi,I have a service account that I use for connecting to our company's AWS, this works successfully for S3 and SQS and DynamoDB on a windows server. However using the same workspace, same AWS account on my laptop I get the certificate error:PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target- I've upgraded to 2021.2.6 as suggested in other posts.- I've confirmed it is not a certificate issue on my laptop because SQS and S3 are working (this didn't work before I installed the certificates).- I've confirmed it is not an issue with my AWS account permissions because I can run the workspace on the windows servers. Any ideas what the issue could be? How does the DynamoDB reader work, is it looking somewhere different for the certificates? What is the HTTP request it makes behind the scenes so I can test with other applications? Thank-you!Kathy

I'm attempting to use relative dates, however I want to exclude data that was modified "Last Friday" where today is "Monday", however I can't see any documentation at what acceptable relative dates there are and what they actually mean (i.e. if today is Monday, does "Last Monday" return as today or the week before? Or does "next Monday" return as today?)?

I would like to start an FME workspace that has 2 CSV readers with a batch script that specifies the path for the CSV files that each CSV reader (in red). The workspace also has a CSV and Shapefile writer (in green) that I need to specify the output paths for.Is this possible?  tC/.

Hi,i read a postgis table with the feature reader. As a WHERE clause i want to filter on a certain criteria, say: name_community IN ('Comm1','Comm2','Comm3') I would like to allow multiple selection. Therfore I have choosen the type of parameter "choice" and a list with multiple selection. The name of the parameter is "_community". Now , I thought: name_community IN (%(_community)) However, this does not work. Any support would be appreciated.

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 Transformer - Generic Port - Attributes to Expose?

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 know, this is challenging to find the desired value if the JSON structure changes from one to another. I am trying to find out an easy way to use the test condition. Not sure which expression can show a range of the values within cur

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 ESRI documentation you can do Identity with a point or a polygon, but I’m getting a bit stuck on the polygon.For the points data I tested in service identify window, and then copied and pasted the query from the URL into my HTTPCaller and then amended it to take XY attributes etc in FME.I tried to test for a polygon by inputting a list of coordinates in here and swapped the type to polygon, but I g

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"?