Skip to main content
  • EN

Unanswered questions

10000 Posts
tim_wood
Contributor
tim_woodContributor
asked in General
How to detect/report a non-existent layer being queried with a FeatureReader (layer name is passed to FeatureReader in an attribute)

I am building a Workspace which takes an integer as one of it's parameters. Depending on the value of the parameter it will query a different ArcSDE layer. I have an AttributeValueMapper to map the number to the layer name e.g.Number : LayerName1 : dbo.layerA2 : dbo.layerBetc After this I have a FeatureReader where the Feature Types to Read value is set to @LayerName as set above. This all works nicely - the data comes out of the Generic port. However, I also want to detect and report on any layers that don't exist. So if dbo.layerA is being set in the AttributeValueMapper but does not exist in ArcSDE, how do I detect this? I thought it would come out of the Rejected port of the FeatureReader, but it doesn't. I do get a WARNing line in the log saying the layer could not be found in the geodatabase, but there is seemingly nothing I can use in the Workspace. I already have a NoFeaturesTester attached to the Generic port to handle a successful query of the layer that retur

60
ebygomm
Contributor
2 years ago
jamal
jamal
asked in General
FME Desktop 2022.1: What is the equivalent tool of “Euclidean distance” of ArcGIS Pro in FME?

FME Desktop 2022.1: What is the equivalent tool of “Euclidean distance” of ArcGIS Pro in FME? I couldn’t figure of if all Raster tools that are available in ArcGIS Pro have equivalent tools\\transformers in FME For example, what is the equivalent tool of “Euclidean distance” of ArcGIS Pro in FME?   

790
olivier
Contributor
2 years ago
B
baznewman07
asked in General
Error when trying to read from Azure Blob Container

when trying to use the select file from web - azure blob storage option on a reader. I can get to the container and i can select files that are at the top level in that container but if i want to go into a folder to select a file in the folder i get an error. ( see screenshots )Any help appreciated

4040
J
2 years ago
N
nickbrownsurvey
asked in General
Adding new Font Name style

Hey Guys,  I'm extracting AutoCAD Parcel information (LotPlan Name) and converting it to MTEXT within the drawing.  The MTEXT needs to be a specific Font. However, the Font required isn't available within the DWGStyler transformer. Can I add a new AutoCAD Font style to FME?

320
danminneyatsaf
Safer
2 years ago
aaron
Contributor
aaronContributor
asked in Transformers
Emailer attachment fails with 'Message size exceeds limit' error

I have a workspace that writes a simple CSV file a little over 10 MB in size using a FeatureWriter. I then use an Emailer to send the file to myself but receive a 'Message size exceeds limit' error. (Error wording is - Emailer: SMTPSenderRefused: Could not complete request. Message: (552, b'5.3.4 Message size exceeds fixed limit', 'myemail@company.com')) Is this limit imposed by the Emailer transformer itself? I can email the file to myself as an attachment manually without issue so I don't think it's our company email server. Wondering how I can overcome this issue. Running FME Desktop 2020.1.2.1 (Build 20624). Thanks, Aaron

230
aaron
Contributor
2 years ago
D
daniel
asked in Transformers
How to resolve failed to write error for writing aggregates to line feature class in Esri Geodatabase (File Geodb Open API) writer

Hello, I've got an FME workspace which uses the LineBuilder then aggregates the lines using the Aggregator which grouping the line features into aggregates grouping by an attribute. However, I'm getting the following error message:FileGDB Writer: Failed to write Geometry to feature class 'BUS_ROUTE' with geometry type 'esriGeometryPolyline'. Dropping containing feature.I've tried using GeometryCoercer after the Aggregator but this doesn't work as the GeometryCoercer cannot coerce IFMEAggregate features into lines. Any help would be much appreciated, thank you.

860
M
2 years ago
A
arnaud974
asked in Transformers
Transform a coordinates array into a polygon

Hi, I've downloaded a json file that contains geometries defined as an array of coordinates. A portion of this json file is described below. One json feature can have one or more geometries. I can't find the proper way to parse this json file and transform this array of coordinates to a polygon. Do you have any solution ?  Thanks for your help.{ "identifier" : "2", "country" : "REU", "name" : "[FM][D 2] La grande montée/Plaine des cafres", "type" : "COMMON", "restriction" : "PROHIBITED", "restrictionConditions" : "", "region" : 931, "reason" : [ "OTHER" ], "otherReasonInfo" : "Zone dangereuse", "regulationExemption" : "", "uSpaceClass" : "", "message" : "Vols interdits sauf lorsque la publication d'information aéronautique l'autorise explicitement ou avec l'accord du gestionnaire de la zone lorsqu'il est désigné par l'information aéronautique", "applicability" : [], "zoneAuthority" : [ { "name" : "Autorité mentionnée en ENR 5.1 de l’AIP", "service

1862
A
2 years ago
O
oskarwallin90
asked in Transformers
How to properly UVmap a TINsurface, without getting large offsets in the UVmap?

Hello!  I am generating a few TIN surfaces which i want to use in Unreal Engine. This means that i will need to generate a UVmap to be able to texture it in engine.  My current setup looks like this: (Ignore my Apperance setting and image rasterizer, i was trying to see if generating a georeferenced texture would work in the appearance setter.). My TIN surface is far away from Origin, so what i am doing is removing the xmin and ymin extracted in the bounds extrator for the offset in the texture coordinate setter. I have tried to do the same thing for the appearance setter aswell.  It seems to generate a UVmap, but the UV is VERY offset in regards to where i need it to be. the scale is correct though.  This is how my UV looks in 3Ds max, its the correct size, but WAY offset.  As you can see below, the size is correct if i manually move the UV down to the 1:1 UV.   Moving this manually for every tinsurface i generate is both nonexact aswell as timewise impossible. Do you have any tips?

150
O
2 years ago
rudy_v
Contributor
rudy_vContributor
asked in Data
Database Connection - Config for Secondary - Readonly Database - SQL SERVER

We are using SQL Server 2014 deployed as 3 node cluster with 1 primary and 2 secondary. We need to connect to the READONLY secondary. To do that you the set the Application Intent=readonlyBut i cannot find the parameter setting in the database connection for SQL Server.

440
rudy_v
Contributor
2 years ago
K
kop
asked in General
IfcSite to GmlLandUse

my question:i have an Ifc file structured like IfcProject -> IfcSite -> IfcBuilding -> IfcBuilding Storey -> IfcSpacetrying to convert to gml i fail to convert IfcSite to GmlLandUse. the export structure is:CityModel -> LandUse -> Building -> BuildingPart -> Roomwhen i remove the writer for LandUse, the structure exports as expected like:CityModel -> Building -> BuildingPart ->Roomids and parent ids are inherited from CityModel to LandUse to Building.... suppose ids and parentids are correct LandUse has no geometryany help appreciated

110
kailinatsafe
Safer
2 years ago
N
natashya
asked in Transformers
HI EVERYONE, I have a problem where I need to update ENERGY ADE using FME workbench but there is nothing appeared, I would like to ask, is it any of you have been work with it? I really need the helps since this is my final project.

HI EVERYONE, I have a problem where I need to update ENERGY ADE using FME workbench but there is nothing appeared, I would like to ask, is it any of you have been work with it? I really need the helps since this is my final project.

60
M
2 years ago
L
lachichi_farah
asked in Transformers
How to know if a field contains string or integer (numbre or letters) ?

I have a field with a code (number) and I would like to know if a feature haven't a number code in her line (maybe a message like "error" or other but with letters). Thanks for helping

1390
M
2 years ago
B
bi
asked in Transformers
Excel FeatureWriter ignoring Row Number Attribute

Hi all, I've published a workspace to FME Server which updates some rows in Excel. When run on FME Workbench, the rows are correctly updating (using fme_db_operation = UPDATE) at the correct row number, which starts at row 10. I've set the row number by using a counter for xlsx_row_id with a Count Start set to 10. Weirdly, when published to FME Server, the workspace ignores the xlsx_row_id attribute and starts writing at row number 1 (even though it gets the correct column positions). Is this a bug in FME Server? Does anyone have a workaround? I've tried different options in the Start Position parameters of the FeatureWriter (both "Named Range Start Row" and "Start Row") but no success... Any advice gladly received, BI

450
B
2 years ago
A
aneta
asked in Data
Hi, I have an ifc file and there are attributes like volume, width, height etc . I can't see them in fme. I even tried to expand the format attributes. Does this mean that reading IFC files is limited to a certain number of attributes?

Hi,I have an ifc file and there are attributes like volume, width, height etc . I can't see them in fme. I even tried to expand the format attributes. Does this mean that reading IFC files is limited to a certain number of attributes? How can I turn on the visibility of these attributes? Is it possible? I've attached a screenshot. The attributes I want to process are in a red box. Regards,Aneta

350
magi
2 years ago
arash_hokm
Contributor
arash_hokmContributor
asked in General
Fanout oder Dynamic write anhand clipper

I have 16 polygons (zone) and a feature of points. I would like to clip points by zone and write to points in each zone in a separate shapefile. that means as a result I have to get 16 shapefile from points. Attached you can see the workbench I tried dynamic and fanout. anyway i only get one feature from punkt.

50
geogaard
Contributor
2 years ago
mohamdwassouf
mohamdwassouf
asked in Data
How do you design a simple architecture on Revit and import the IFC file to FME and then convert it to citygml format. Thank you so much.

How do you design a simple architecture on Revit and import the IFC file to FME and then convert it to citygml format. Thank you so much.

120
mohamdwassouf
2 years ago
charry
Contributor
charryContributor
asked in Transformers
Vertex normals removed due to application of non-invertible matrix

Vertex normals removed due to application of non-invertible matrix,Error running translation. when I try translate the 3d .obj model to 3dtiles,the error Appear，of course not all obj appear the error

80
charry
Contributor
2 years ago
P
ppp19
asked in Transformers
How to update PostgreSQL existing schema with any new data with additional columns ?

Hi, I am new for using FME to create PostgreSQL database and having trouble updating schema or adding columns to the existing table. so to explain in detail: 1) I have different councils 3 waters pipe data which I want to add to my database2) I have already done extracting, and transforming of data but now I want to load data coming from different councils into a single PostgreSQL database3) So I am using FME writer format "PostgreSQL" and table (say Table1) definition as "Automatic" and ok till I have added the data from one council having 52 columns4) Now when I am trying to add data into same postgresql database table (Table1) from other council having 79 columns in it ... my database is not accepting data from those new columns came from new council 79-52= 27 columns into my existing database table Any comment or recommendation on this will be great!

1570
geomancer
Evangelist
2 years ago
B
bradosav
asked in Transformers
User parameter for reader path

My workflow regularly compares files stored at path X with prefix Y with files stored at path Z with prefix Y. I'd like to set up the workbench in such a way that I'd copy the workbench for a project and only have to edit the Y parameter for it to read in the required files, i.e. Read: $(Path_to_X)/($Prefix_Y)*.csvRead: $(Path_to_Z)/($Prefix_Y)*.csv Can this be done, and if so, how?Thanks!

900
B
2 years ago
fmesafe.podpora
Contributor
fmesafe.podporaContributor
asked in General
Group data

Hello, would anyone know how to group data under one airport? I have 32 airports, each airport has x UUID_departure and each departure UUID has x departureLegs and each departureLeg has two points. DepartureLeg has a unique ID and each departureLeg point also has a unique ID (it can be a variant of startpoint and endpoint). I have finished the connections, now I just need to somehow pair all departure legs under one UUID_departure and not connect individual points to these departure legs. Connect this whole thing to the airport. Is there any such transformer outside of featureMerger? I am attaching the WS on the download link, it is too big with data. Thank you!!!download link: https://www.uschovna.cz/zasilka/AQ2HU24BLI9F2R6D-XCY/

40
geogaard
Contributor
2 years ago
A
asadamjad
asked in General
Clipper

basically what i. want is that the outer polygon should be a doughnut-like shape, currently, its area is also covering the higher value qpf polygon inside (darker colours) it should have multiple polygons, just none that overlap the shp file needs to be clipped by itself

210
A
2 years ago
N
nrussell
asked in General
What is the standard pattern to develop web services in FME Server?

Hi I am interested in understanding the standard pattern to develop web services in FME. The standard use case is an external application post data to an FME server endpoint (e.g. polyline GeoJSON), have FME transform it (e.g. add a buffer around line), and return data back (e.g. GeoJSON again). I am trying to get my head around repositories, workspaces etc. Looking at it now it seems like the above needs to be accomplished with mulitple steps? Potentially posting data to FME server first, then submitting a job, then getting the results, then getting the final data? Thanks in advance,Nick

40
hkingsbury
Celebrity
2 years ago
B
bruno_de_lat
asked in Transformers
Tools for version control of .fmw en .fmx files

Hi all,  I was wondering if somebody could advice me a good tool that can be used for good version control of FME Workbenches and FME Custom Transformers. Any suggestions? Preferable an open source tool.  There are some  tools available for this, but most of them offer also automated "merge" and "compare" functonalities and in my opionion  this doesn't work well on .fmw en .fmx files, therefore I prefer not to have this functionality.  In case there is a difference, the user should be the responsible to choose the local version or the version of the server to decide which one to keep. Also multi-user-editing of the same workspace is not something that works in an FME environment (yet). But I do have interest in the back up functionalities, the compare functionalities, have a single repository of the main workbenches, being capable of taken the models locally and run them locally,...  I experimented with GIT version control, and It helps, but it is not exactly wh

290
B
2 years ago
joy
Supporter
joySupporter
asked in General
To which extent are performances of FME scripts determined by network disks or internal memory of the computer?

Our data is in the cloud and there is possibility for increasing the performance of our network disks on the cloud. However doing so, will lead to much higher costs. So if the performances of the fme scripts are mostly determined by internal memory of the computer, then maybe we wouldn't need to increase the performance of the cloud services.

40
hkingsbury
Celebrity
2 years ago
smfks911
smfks911
asked in Transformers
Why attribute is missing after area on area overlay?

Hi altruist, I am having an issue in after using AreaOnArea overlay operation. I have overlaid two polygon datasets and ideally the output should have attributes from layer when there is _overlap field have 2 and more. This is what happened for other overlay operations. However, in the following cases I do not see the attribute from one of the polygons after the overlay operations: This is the attributes before overlay:The overlay operations:After the overlay:Does anyone have idea why that may happen?

390
smfks911
2 years ago

Badge winners

Show all badges
30,194
Posts
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.