FME Form

create line between two points from two different shapefiles.i have common field (line Numbers) with some of same values, need to draw lines between if the values match with other shape file. like above figure need to draw like Yellow color lines.

I have very little python knowledge so I have real trouble understanding the documentation FME provides:http://docs.safe.com/fme/html/fmepython/api/fmeobjects/_rastertools/fmeobjects.FMERasterTools.calculateSlope.html?highlight=rastertools#fmeobjects.FMERasterTools.calculateSlope I have a PythonCaller that calculates the slope of a Raster. At the end I want to itterate over the cells to calculate the desired height, but for now I want to understand how to use Python to manipulate a raster. class FeatureProcessor(object):    def input(self,feature):            raster = feature.getGeometry()            rst = fmeobjects.FMERasterTools()            settings = {'kFME_CalculateSlope_interpolateNodata' : 'No'}            raster_new = rst.calculateSlope(1,raster,settings)            feature.setGeometry(raster_new)This works, except that it still interpolates Nodata. So how should I write down the settings dict to tell the function not to interpolate and use the Horn method?     

Trying to run the following SQL/DDL combination:SELECT setval('@Value(table_name)_$(Column_Name)_seq', (SELECT (coalesce(max("$(Column_Name)"),0) + 1) FROM "@Value(table_schema)"."@Value(table_name)"));ALTER TABLE "@Value(table_schema)"."@Value(table_name)"  ALTER COLUMN "$(Column_Name)" SET DEFAULT nextval('@Value(table_name)_$(Column_Name)_seq'::regclass);But the workspace freezes with a deadlock on ALTER TABLE.  Tried explicitly BEGINning a transaction before the first statement and COMMITting after the second, but that fails with "transaction already in progress" followed by "no transaction in progress".  Not even separating the two statements into different SQLExecutors helps. Thinking I'm going to need to split this into separate workspaces, or worst case scenario, doing some of it in standalone Python.  But wondering if anyone else has run into this and has better suggestions.

I am trying to do a translation of multiple pdf files (11 in this case), and I want them as jpg files, as simple pictures. My attemp was to import all the folder that contains the pdfs, and to pass them through a dynamic jpg writer, but I am getting an error from the jpg writer that says that "This format cannot support more than 3 bands". I dont know if I am configuring something wrong in the writer, please give me an advice. Thank you

I am trying to access an AGOL feature service from one of my clients. I thought the issue had to do with special characters in the group and feature service names, but I get the same error with that corrected. Creating reader for format: Esri ArcGIS Online (AGOL) Feature ServiceTrying to find a PYTHON plugin for reader named `ARCGISONLINEFEATURES'Loaded Python module `arcgisonlinefeatures' from file `C:\\Program Files\\FME\\python\\python37\\arcgisonlinefeatures\\__init__.pyc'Creating reader for format: Esri ArcGIS Online (AGOL) Feature ServiceTrying to find a PYTHON plugin for reader named `ARCGISONLINEFEATURES'Loaded Python module `arcgisonlinefeatures' from file `C:\\Program Files\\FME\\python\\python37\\arcgisonlinefeatures\\__init__.pyc'ArcGIS Online Feature Service Reader: Requesting portal informationArcGIS Online Feature Service Reader: Getting list of user content items in 'UNCC_Locate'ArcGIS Online Feature Service Reader: Searching for all gro

I'm experiencing a strange behaviour with the File Geodatabase writer (GEODATABASE_FILE). Everything works when I write to the database from the cache but I get and error when I try to run the complete workspace from the start (with or without caching).I tried so many scenarios, but I always get an error while running everything from the scratch.Here are the few screenshots showing successful scenario and a writing error.Does somebody have similar experience and what might be a solution to this?I'm using FME 2020.2.3.0 (build 20820) and have localy installed ArcGIS Pro 2.8.1Screenshots:1) run to this (from the cache to the database; last step of the workflow)2) success; features are written to the database3) rerun entire workflow4) error running transaction 

I have a dirty stormwater network for a large region, which contains many network loops/cycles and non-directional features. The network is made up of Stormwater PipesStomrwater ConnectionsStormwater Channels/WatercoursesRivers/Large StreamsI would like to estimate the primary flow through the network with the following assumptionsFlow direction will be down hillAt network junctions, flow direction will be prioritized by edge typeRiversWatercourses/ChannelsPipesLarger PipesSmaller PipesI have made some progress using the Network Flow Orientor and Stream Priority Calculator (Im setting flow direction by finding the sink/source with the lowest elevation per network group). Prior to the Stream Priority Tool, I am assigning weights to edge features based on edge type, and using this as the forward and reverse weight.  This method seems to prioritize streams and channels over pipes, however I'm not sure how I can prioritize larger pipes over smaller pipes. I have tried sorting pipes o

Hello everybody, I have a layer of points and I wanted to calculate the azimuth of each point, suddenly I thought to make a pythoncaller to call the API of QGis in order to use the Azimuth function, I'm a little stuck on this integration if you have any proposal, I will be recognizable.

Hi Everyone I have been trying to read pdfs and save to jpeg. The issue seems that I can only write 3 Bands to the Jpeg Writer(R,G,B). Once I remove the Alpha8 Channel, the background turns black. I have tried multiple ways of fixing it, but to no avail, I am stuck right now. I found this excellent Article on the forum, but I still seem to have the issue with the Colour Values, can someone please help out? Is there an elegant way of fixing this? I can succesfully export png, but can't crack this Jpeg Writer! Any help or advice will greatly appreciated. Fred  

I have a custom transformer that I have been periodically updating for a couple of years and I had it working so that whenever I opened a workspace that used the transformer it would ask me if I wanted to update to the latest version (yes). However, I tried editing the transformer in 2021.0 and the versioning seems to get lost. When I saved it, it is saved as version 1 (instead of v23) and when I opened a workspace that used it, it did not ask if I want to update to the latest version - unless I am missing something this is a massive pain because it means manually replacing the transformer, reconnecting all the inputs/outputs, and reassigning published parameters. I was able to recover my previous versioning info (which involved reverting back to 2019) but workspaces still do not ask if I want to update to the latest version of my custom transformer - is there a way to get this working again?

Hi. I'm trying to read a pdf of a 2D CAD drawing. The file opens ok in Microsoft Edge browser but when I use the Adobe Geospatial PDF reader it is only reading a fraction of the elements in the file - a few text elements.  I've tried playing around with the reader parameters but cant figure out why its not reading the whole file. Any idea what i'm doing wrong?  

Hi, I have an angular application which create files(eg:auto cad files). I need to view these files inside the application after generating . Is it possible to integrate FME inside an angular project? If Could you please provide documentation link of it.

Is it possible to split 1 polygon equally into 5 sub polygons based on point density and not area? For Example there is 100,000 points inside a polygon and I would like to split the polygon into 5 parts each part containing ~20,000 points (it doesn't need to be exactly 20,000 but the points need to be spatially in the same area).  

Here's a great workbench snippet that uploads a file geodatabase to AGOL, publishes it, updates the view to switch it to your new service, then deletes the old service.

I want to create a sequence of numbers starting from 1 but ending at a certain point which it will decide from attribute value coming from the SQL executor, suppose the value came out as 100, then I would want to create sequence of numbers upto 100. How ?

I'm reading archived tables with the GEODATABASE_SDE format, i.e. with connection file. I'm trying to access the special archive views for this occassion. The ones that SDE creates automatically which has the "_EVW" postfix. Though I cant see them in the list of available geometry tables. I'm connecting as the schema owner with a FeatureReader. How does this work? Does FME figure that out automatically? For example if I read features from table "SAMPLES", the question actually directs to SAMPLES_EVW view? Or does it work any other way. I did some tests and created a logger which helped me out with the number of features read.  For one of the tables I got the logger saying that it "Cloned 841467 input feature(s)" When counting the records in the database I got the numbers:Table: 840 225EVW-view: 840 227 Three different numbers is what made me write this question. So how does this actually work?    

Hi. I am using GeometryValidator for some buildings as multisolids. All of them has been created together, but after the GeometryValidator, some of them come out from Failed part. I need all the 3D buildings. Can I repair them before the GeometryValidator?I set the set of issues to Detect to Surfaces and Solids. Thanks 

I have saved MVT tiles locally like this, c:/3006/0(zoom level)/0(Tilecol)/0(Tilerow).mvtInformation about the tileset below.<TileMatrixSetLink><TileMatrixSet>3006</TileMatrixSet></TileMatrixSetLink> <TileMatrix><ows:Identifier>10</ows:Identifier><ScaleDenominator>14285.71428571428623399697</ScaleDenominator><TopLeftCorner>8500000.000000 -1200000.000000</TopLeftCorner><TileWidth>256</TileWidth><TileHeight>256</TileHeight><MatrixWidth>4096</MatrixWidth><MatrixHeight>4096</MatrixHeight> When I RUN the Workspace I get this translation log (see link) and no GeoJSON file is to be seen. What do I do wrong? https://docs.google.com/document/d/1u-BgtK6lU4SUKFFPjG-lv4Gs2VYHLc7AIOXo-Is_QB8/edit?usp=sharing 

I am encountering the following error. Can anyone tell me how to fix it? 2020-10-22 10:24:56| 0.9| 0.4|ERROR |Python Exception <ImportError>: this version of pandas is incompatible with numpy < 1.15.4your numpy version is 1.15.1.Please upgrade numpy to >= 1.15.4 to use this pandas version

Hello,I am trying to POST an XML using the HTTP Caller, but get a 415 error.I have an API tool for the application that I am trying interact with, and manage to POST the XML with success.I have seen other posts that suggest it is the header of the XML / Content Type option which is incorrect, but I have tried all the options I can think of. Any help would be appreciated. I have pasted the XML I am using below, and attached the test  workbench I'm using. Note that I have deleted credentials / sensitive information.Cheers<?xml version="1.0" encoding="utf-8" standalone="yes"?><Mail> <TotalAttachmentCount>0</TotalAttachmentCount> <Confidential>false</Confidential> <RichMailText>false</RichMailText> <MailSubject>TEST2</MailSubject> <ToUserId>1476934057</ToUserId> <MailTypeId>2154</MailTypeId> <MailFormFields> <MailFormField identifier="DesignPackage_singleSelect">N/A - Not Applicable</MailFor

Where (what path) to place the *.fme-file file on FME Server for to use a custom coordinate system in workspaces?Thanks.

Hi Folks,we are trying to save json request/response data into oracle database using SQLExecutor and getting following error java.sql.SQLSyntaxErrorException: ORA-01704: string literal too long Request that we are trying to save is more than 6000 characters. Appreciate your suggestions ?

I have a shapefile with a few thousand points. I would like to be able to remove points that are too close or overlapping on each other. Usually, the points should be at a minimum of 1 meter of each other. If I have points that are exactly at the same coordinates or within let's say 0.8 meter, I would like to keep only the point with the lowest value into the OBJECTID attribute. Any idea of which transformer I should use ? Thank you. Mathieu.

We've had a strange behaviour importing data using FME Quick Translator. One user (Admin) had the following entry in the log file when he experienced wrong string encoding in the target database:2021-06-29 22:11:16|  3.5| 0.0|INFORM|Shapefile reader: Reading dataset with encoding 'windows-1252' as determined by 'System Encoding as Fallback' Another user got the right encoding in the target database and the same line number of the log output instead showed:2021-06-30 00:32:56|  3.0| 0.0|INFORM|Shapefile reader: Reading dataset with encoding 'UTF-8' as determined by 'Codepage File'  Both users could read the .CPG Codepage File without a problem, but it turned out that the first user did not have "full control" access to the .CPG file which lies next to the .SHP shapefile.As soon as we gave him "full control" access to that file the log output regarding the encoding was the same. Seems to me as if FME (Quick Translator) tries to excl

Hi,i have installed the FME Server Version 2021.0.3 with Docker. I´ve imported my Workspace successfully , but it runs into lot of warnings and it failed. These warnings are consisting of a lot of files, which could not be found. Why these files are missing and how could i fix these warnings. best regardstim