FME Form

I have an MSSQL database, where new rows will be added on and off. I have setup a workspace that will be run nightly, that checks the database for rows with null in the field "email_sent_with_data" and sends it in a beautifully formatted email and it works wonderfully. However, I would like to send along a map, either a pdf or a shapefile or similar containing the three geometry columns in the row. Any ideas for solutions to this problem?

Dear Sir / Madam, I have an indoor data set. As shown in the figure below. Red line represents network path. Blue circle is the POI (Point). Black dot is just the vertex. As I have an indoor data for the entire building. I would like to find network that is unnecessary (not linked with any POI), as shown as Yellow Circle. I am just wondering what transformers I can use to find these path? I cannot just simply break the lines as some vertex are necessary for turning. I would really need some hand. Thank you very much!

I am creating PDF reports from ArcGIS Portal Features w/ attachments. The workbench is set up to write to a word doc to use the template doc functionality (custom header/footer) and then converting to PDFs with a PythonCaller. It seems that when writing more than 2 images (from the feature attachments) to the MS Word document, it corrupts the file. Two images or less works correctly and the documents are able to convert. I am writing out images from attachments to a local drive using the BinaryDecoder and AttributeFileWriter. Then specifying them for the word doc using the MSWordStyler --> Image Source = From File. I've tried using a PythonCaller after the the AttributeFileWriter to compress the images (jpeg and png) and resize them before being written to the word doc, but that doesn't seem to help. Any help/ideas would be appreciated.

Basically, I want to match meter IDs from two different datasets: shapefile and excel file. Meter IDs in both datasets might have typos such as dashes, dots, letters, slashes, which I need to remove first. Then I want to match MTR_NO from Excel against Mother_1 , Child_3, & Child_4. My idea is to export an excel table that will include only matching meter IDs.

Hi, Is there a way to modify execution order of a sub part of a workflow to obtain a full execution of an arbitrary long chain of transformer on a given feature. alike: transformer1 execute row1 - transfomrer2 execute row1 and output 10 row - transformer3 execute row1 to 10 - then - transformer1 execute row2 - transformer2 execute row2 and output 5 row - transfomer3 execute row11 to 15 - then - transformer1 execute row3 - transformer2 execute row3 and output 7 row - transfomer3 execute row16 to 22 this even if there is merge or agregate transformer. The issue is: I have is that I have to sequence operation on an external web service that some time "loose itself" when for exemple I create all invoices then further in the workflow I create all invoices_lines for all invoices, I need inside of a more complex workflow to create the invoice then create all line for this invoice then create next invoice and so on... I allready know that I can use a workflow runner to achieve this but it is n

I have this problem: In the workbench there are many writers. Two of them should be in the same zip folder. This happens when I run the workbench in FME Desktop, but when I run it from FME server I only get 1 of the two files in the zipped folder. I use fanouts: @Value(field1)_ExportacioGIS.zip\\SortidaDXF.dxf @Value(field1)_ExportacioGIS.zip\\SortidaDWG.dwg Where "field1" is the same value for each file. In the desktop I get the expected output: But when it runs from the server I get only the DXF file. I try it using a Job Submitter and a Data Download services. Any idea why it does not work from the server?

is there any reader where i read the Google analysis data ?

How to extract start and end name of road from road network ?

Hello , i am using Esri feature service reader to read map service but it does not work with me . when I click on layer to show them ,it is written that token error ,499 error i have admin user and keyword but it does not work to access . could someone advice me ,how could I read map service from ArcGis server ?

Within ArcGIS Pro 3.1 I am creating annotations with the help of Arcade (a lightweigth expression language). The outcome is as shown below, basically a fraction When I read the annotation layer from the file geodatabase, FME does not interpret the HTML tags in the text string, but counts them as part of the text. I there a way to make FME interpret these tags correctly? My final product should be a dgn file with a level holding these 'labels' and I was wondering if that is possible, and if I can achieve this with FME. The 'fracture' consists basically of three parts as I see it: nominator that is underlined line break denominator without underline

Hi I am reading various tables from Oracle each of which contain many date attributes. Is there a transformer that will allow me to filter out all the attributes that are have a type of date as I want to check the dates make sense (I know there are some with some very dodgy data in and wont write out to a sql table) Thanks

Hi, Im struggling a bit with finding nearby points to another point layer. I want the Neighborhoodfinder to find the two closest points within a distance. The output file only includes the nearest point even though I have set the neighbors to find parameter = 2. I want the output file to include the two closest points and their distance. Any suggestions? Thanks in advance!

I have a shapefile with numerous columns that I need to calculate a mean for on a row by row basis. Within the data there are a lot of values equal to 0 that are skewing the mean - how can I set up a calculation in the ExpressionEvaluator to remove the 0's from my calculation?

Hello , i have around 800 tables at my oracle database and I would like to ask if there is a method that I can find which tables has the same object id . i think ,if I read each table then use feature merger between one table and others and so on .it will take time is there a quick method that compare between all tables and eachother to find which tables has common id and show me the name of tables that has common id. my target to find the name of tables that has common id. FME 2021

I have set the timeout to 1800 seconds but i fails after about 10 minutes. I have asked the guy who administers the webservice and he says that on the API side it seems to go well and it sends the response after about 12 minutes. I have attached the log file of me trying to run the httpcaller. Edit: I can see that i some months ago made a similar thread, so if you (administrators) prefer I can delete this and respond in the old one. In short I was asked in that thread wether I was sure that there should be a response, and I am sure of that. Sorry about the double post! Kind Regards Rasmus Raun

Hello everyone! I struggle with understanding how ArcByCentrepoint (and Circle) are implemented in AIXM 5.1/GML. I ingest exactly the same dataset in FME and QGIS. However, in FME everything looks correct whereas QGIS butchers the geometry. I tried this with class C airspaces around Munich and other airspaces. The system behavior is the same regardless of the airspace. These discrepancies are not just ugly, but they also lead to partially invalid geometries. I have attached example screenshots. In FME In QGIS I believe that these discrepancies may occur due to each application utilizing a slightly different projection, e.g. UTM, AZMED, AZMEA, and other local coordinate reference systems are probably just part of a longer list. With each projection, the displayed geometries are slightly differently skewed in terms of distances and angles. So far, I have selected Lambert Azimuthal Equidistant Projection for my calculations/constructions, which originate at the circle’s midpoint. In my un

In Ideas @bilal​ said "One of the benefits of having a creator attached to such a transformer is the ability to define the order that the creators run in a workbench." https://community.safe.com/s/bridea/a0r4Q00000HbroNQAR/dont-require-creator-for-transformers-that-read-data How?

We are running desktop and server at version 2022.1.2.0 (20220831 - Build 22627 - WIN64). One particular workbench that we published runs to completion in desktop, but fails in server. I've checked some other cases and articles (such as this one), but none of the causes (including available memory) or workarounds seem applicable. When reviewing the job's log it seems to consistently fail at this step: 156 2023-5-4 15:09:41 | AttributeFilter_NBI <MISSING> Transformer Output Nuker (TeeFactory): Cloned 0 input feature(s) into 0 output feature(s)157 2023-5-4 15:09:41 | AttributeFilter_NBI <NULL> Transformer Output Nuker (TeeFactory): Cloned 0 input feature(s) into 0 output feature(s)158 2023-5-4 15:09:41 | StringFormatter_NBI_Leading_Zeros_2 (TestFactory): Tested 7132 input feature(s) -- 7132 feature(s) passed and 0 feature(s) failed159 2023-5-4 15:09:41 | GeometryRemover (TeeFactory): Cloned 1238 input feature(s) into 1238 output feature(s)160 2023-5-4 15:09:41 | StringFormatter_NBI_Leadi

Hello, I have a workbench that uses a tester to copy files into a folder and zip them based on the create date. This works fine however after I have the files in the new zip file I can't seem to figure out a good way to then use a FTP caller to upload the files since you can't do anything after you have used the filewriter. Looking for ideas of how to upload this zip file to an FTP in the same workbench?

Hello FME Community, Although I was very happy to have successfully used HTTPCaller for the first time by writing the data to a CSV file, I seem to be stuck in using HTTPCaller to read the data from the "_response_body" to continue the processing. I can see the data loaded in the "_response_body" but I couldn't manage to pull it out to continue the processing (tried FeatureReader, TempPathnameCreator, AttributeFileWriter). I always fail to pull the data. Can anyone help me out with an example of usage? I read the documentation, forum posts and other internet posts but I still fail to use it as exemplified below. Basically, I would like to replace the CSVReader (below) with the HTTPCaller data, as to load the data automatically and not have to download manually the CSV file every time. Below, the successful usage of HTTPCaller, but with a resulting file. Many thanks for your time, Robert

I have tried using the combination of this transformers to discard or filter out compoundCurve geometry but the issue still persist I would like to find a way to discard these geometry ("CompoundCurve".) to avoid the WB stops when I am inserting data to postgis table. GeometryFilter GeometryValidator ArcStrokcer GeometryRefiner

Hello, Recently we attempted to adopt single sign-on through our Windows AD. However, we are having difficulties getting it to work. I have followed the steps outlined by: https://docs.safe.com/fme/html/FME_Server_Documentation/AdminGuide/IWA.htm It worth noting that we have also switched our server to using HTTPs Whenever a user clicks "Use windows credentials" they get an error "Login failed, please try again". Its worth noting if a user manually inputs their AD credentials, the login is successful. When checking the fmeserver.log file I do see the message "Unauthorized request by user <User> due to lack of proper permissions or the object does not exist." I have also noticed that when using the generate token URL: https://<fme server name>/fmetoken/sso/generate I get an error 403 "forbidden" (this is the URL set in the propertiesFile.properties) Just to reiterate manually entering the AD credentials works without any issues, only when using the "Use Windows Credentials" SSO option d

I was experimenting with the OSM PBF reader, and I noticed that I get different results when I filtered on the Map Features vs the Feature types. In my sample data, if I selected building in the OSM Map Features, it read in 47691 features. If on the other hand I left the Map Features blank and selected building in the Feature Types to Read, only 45050 features were read in. Thoughts on why the mapping is different? I assume it has something to do with Multiple Map Feature Resolution, and I would expect extra features if it was set to Duplicate Features, but since it was Use First, I'm at a loss.

The List Date in the bottom photo contains a field called ListDate which is stored in a SQL database. We're using their WFS to download the data however due to the validation in Pro we can't see any date fields so we're using FME. I'm trying to use the transformer 'date time converter' but I get the prompts asking which fields I want & as you can see the software is splitting out 1 field into several which are all 'missing'. Which list elements should I select? Also in the select list elements box what number should be entered there? I just need the date so can strip out the time element.

I am trying to write a bunch of shape files to a geopackage but am getting a strange error. 'OGCGEOPACKAGE writer: sqlite3_exec(CREATE TABLE "table_name" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL' There seems to be a problem when the writer constructs the primary keys for the database, but I have no idea how to address this. There is no id attribute in the source data, I actually tried adding one and the writer handled this by changing the name of the primary key to id_0. Still got the same error though. I am using fme_feature_type to set the table names and schemas.