- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27540 Posts

Recently active

Most replies Most views Newest first

joySupporter

asked in Transformers

Error translation when reading in ecw file with search envelope for level 0-2

hi Everyone,This is a very specific error and I wondering whether it's a bug. Initially I tried using the FeatureReader with Spatial Filter, however then the whole ecw file needs to be read (14 gB) which takes a long time. I then tried using the normal ecw reader with the search envelope which doesn't need to read the whole ecw file before conducting a spatial operation. This works superfast for when I choose a number for Advanced > Pyramid level to Read from 3 to 10. I get the following output for level 3, however the picture is quite coarse as you can see. I would like to have the most sharp picture, thus ideally I would like to choose level 0, however when I choose a number from 0-2 then I get an error translation with no explaination about the cause of the error. I was wondering whether this a bug.

1 year ago

john_otoole

asked in Integration

FME Server 2022.2.4 - uploaded files not being overwritten if >10kb

We're getting some strange behaviour with FME Server 2022.2.4 running on Windows Server, wondering if anybody else has come across this or has any ideas of how to resolve. We have a workspace which accepts an input text file and then does some processing on it. When running the workspace through the REST API, or through the FME Server interface, the file is first uploaded and then the workspace processes it. We are finding that the uploaded file does not get overwritten. i.e. First we upload file A - all works fine the first time. Then we rerun the workspace, uploading file B. File A does not get overwritten and the workspaces processes file A instead of file B. In this log file: C:\ProgramData\Safe Software\FME Server\resources\logs\tomcat\<machinename>\catalina.2023-06-19.logWe see the error below:19-Jun-2023 11:28:21.685 WARNING [http-nio-0.0.0.0-80-exec-8] COM.safe.web.upload.StoreManager$FileDesc.<init> null org.apache.commons.io.FileExistsException: File element i

491

1 year ago

s.jagerEnthusiast

asked in General

SQLCreator 2022 Exposing attributes from query does not expose any attributes, without any error message

Hi, I have a bunch of fairly complicated SQL queries, which I frequently use in an SQL Creator. This saves me a tremendous amount of featuremergers and such, because the sql basically re-creates the business object from the normalized database tables. Up to version 2020 this worked just fine: insert an SQLCreator, select DB Connection (SQL Server 2016 SP3), copy-and-paste SQL from my code snippets, click on the ellipsis to Expose attributes, click on Populate from SQL Query, and I'd be done. Now that we've upgraded to 2022, that does not work anymore. The Attributes to Expose dialog stays empty, and no error messages or warnings appear in the log. It is rather annoying because I have to do this all the time, and now I have to copy the attribute names manually from my sql statement. It's causing me quite a bit of extra work. Am I missing something? I am currently using FME(R) 2022.2.6.0 (20230523 - Build 22800 - WIN64) , and up to now this method has always worked just fin

974

1 year ago

virtualcitymattEvangelist

asked in Transformers

FME 2022.2.5 - Data Inspector 2D window loading/freeze issue?

Has anyone experience the Data Inspector having issues when viewing 3D objects in 2D? Sometimes I get the Inspector into a state where the application partially freezes. It seems to happen when I switch from 3D to 2D. I'm unable to change what I see on the screen, however, I can see that the buttons at the top are responsive and the context menues. I switch back to 3D and it'S fine. It's only 2D which isn't working. Restarting the machine seemed to fix the issue but eventually it come back. Just looking to see if I have a faulty machine/config or if it's FME. Steps to reproduce: Open 3D Dataset (3D view opens by default) switch to 2D.

1 year ago

megannes

asked in Transformers

How to make sure ImageRasterizer runs even with no input data

Context:The overarching goal is to extract certain categories of areas from GeoPackage files and then write the output as images with the R, G and B channels containing specific grouped categories.I've gotten this all to work nicely as long as the geographical area that we collect the data from contains all of the categories that is written to each of the channels. The issue now being that when one of these categories doesn't exist in the selected area - then the connections for that color channel wont be ran and I end up with a broken output. So what would be the best way of making sure the ImageRasterizer leading into the RGB channel creation is ran regardless of input data or not?Or would I be better off doing something completely different? I am currently working with a RasterNumericCreator to try and generate blank data to be supplied when other data is missing but all I've gotten is a mess trying to get the coordinates accepted by the nodes down the line.Using this me

1 year ago

zdanskyParticipant

asked in Transformers

POSTGIS dynamic writer forces generic geometry columns instead of specific ones (point / line / polygon).

Hello, I am trying to generate dynamic POSGIS tables from spatialite data, however I cannot seem to force FME to create POSTGIS tables with Point / Line / Polygon geometric columns, they get forced to Geometry every time.As you can see, I have geometry set from schema definition, I have disabled creation of generic geometry columns. My features look like this:However when I look into the database, the table created looks like this:SRID is generated correctly, but geom geometry(Geometry,5514) should be geom geometry(Polygon,5514)...I have found similar question, from 7 years ago, is it possible that this has not been fixed? They are using feature writer, I am using normal writer. https://community.safe.com/s/question/0D54Q000080hcErSAI/featurewriter-postgis-writes-generic-geometry-column PostgreSQL 13.10 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bitFME: FME(R) 2022.0.0.2 (20220518 - Build 22343 - WIN64)

251

1 year ago

chrisnovak

asked in Transformers

How to query out certain fields (columns) from a feature class using a query

I have a feature class within a FGDB that contains 2631 fields that are named F1 to F2631 and looking to query certain fields from this main feature class to write out to a new feature class. For example the first i'm trying to write out as a new feature class I want to write out fields F1 to F40. Attribute Manager appears to struggle to remove fields F41 to F2631 when i try to use this transformer and crashes FME on me. I've been trying to figure out a way to query the fields i plan to remove within Bulk Attribute Remover but cant figure out how to complete the query? Any suggestions ?

1044

1 year ago

miledihamdi

asked in Transformers

How to use python caller and use neighborhood finder in python caller

I have 100 neighborhood finder, in each neighborhood finder the two input are matched and umatched from the first transformation and the two output are used as inputs in the next transformation, i want to used python caller for solve this problem

193

1 year ago

davidleeSupporter

asked in Transformers

AutoCAD Block Attributes to Point in FME

I have 2 DWG files are working with FME. How to FME transform automatically Block attributes to point (Block attributes in DWG file and tags in Microstation)File 1: FME transform automatically block to point with attributesorginal file 1: File 2: its not, FME is not transform block to point automaticallyOriginal file 2:How do i get the point with the attributes of block attributes like file 1 ?By the way with these 2 files i don't use "Preserve insert points" in FME

Safe Emailer works great with Generic and Gmail, how does one get the Microsoft Email Service to show up in the Service dropdown?

I've gone into Manage Web Services and managed to configure the Microsoft Mail (safe.emailer) web service and it tests and authenticates without issues. However, when I add the Emailer transformer from Hub and go to select the Email Service from the Service section I only see Generic SMTP and Gmail. Is there something special I need to enable or refresh for the transformer to see my new web service? edit - have tried this in both versions of 'Form' I have installed (2022.0, 2022.1) thanks

241

1 year ago

chadprop

asked in Transformers

I'm struggling getting filters to work in a simple automation. I'm using a webhook as a trigger, logging the message response from it then trying to pass a filter based on containing a certain value.

The webhook is coming from a hosted FS on AGOL set to respond to updates and creates. There are 10 'pieces' (layerids) to the feature service and I'm only interested in triggering a workbench when the layerID=0. I've imported the JSON keys and made them available to the filter action.I've tried many different formatting methods in the 'Contains' setting but no matter what I put in there the filter always fails and logs another message that it has failed. I've got a fairly simple workbench I'm trying to trigger with the automation but since the filter fails the workbench does not run.

1 year ago

franco69Contributor

asked in Transformers

Create kml file with jpgs

Hi guysi want to create a kml file with jpgs inside (they are inside a local folder) and when i click on the location jpeg pops up......i have set up my workbench like thisEmbedImages-in-KML.fmwtbut the locations and the information about the jpgs FME is writing the right way ...but what i have to do when i want the jpg to pop up?write the path in a hyperlink or a special kml writer format attribute? Greetz and thxFranco

601

1 year ago

aesi_geoContributor

asked in Transformers

Has anyone successfully passed null values to the chartgenerator or converted the htmlreportgenerator chart output to an image?

I have a workbench that uses the chartgenerator to create a simple chart graphic that goes into an automated daily email. image below:Blue line is the recent readings and the orange line is a limit (it looks static but it fluctuates throughout the year). I'd like to add a ten-day outlook to the orange line but the chartgenerator can't handle null values on the blue line, it throws the error:ChartGenerator: Non-numeric input provided. Please validate that the values of the "X Attribute","Y Attribute" and "Error Attribute" (if supplied) are numericthe htmlreportgenerator can handle the null values but when it's embedded in the email as html content the chart is not in the email, I am assuming it's being scrubbed out by outlook and am left wondering if there is a way to covert the html output to an image which can be embedded in the email. Desired output:

184

1 year ago

gisgeekproContributor

asked in Transformers

Calculate how much a polygon has been moved after rotating it from an arbitrary point, in order to place its tip midpoint, back in the center of axes

This is part of larger script, where the goal is to generate multiple rotation alternatives for a series of polygons. In this case, I have a 5-vertex closed polygon, where the midpoint of its "tip" is located in the center of the axes (0,0). What I am trying to achieve is, after generating a series of rotations from an arbitrary point -located in the feature's upper segment (see blue point in pictures below)- to calculate the shift in coordinates the rotation caused, in order to move the whole polygon accordingly afterwards, so the "tip" midpoint of the rotated polygon is again place at the center of the axes. Please see pictures below for better understanding : In picture one, the original position of the polygon is shown, where the midpoint of the tip is located in the center of axes. In the second picture, a clockwise rotation of 45 degrees has been applied, where the blue point has been used as an "anchor" (0,31).In the third picture, the shift

5314

1 year ago

lgrieContributor

asked in Transformers

HTML Layouter swallows data

Hello,I have have two different html files coming into HTMLayouter :A costum html file bearing specifications for a drop-down menuA file with charts AND a table.Before those two html files are joined into one with the layouter the table exists. After it the table seems to be erased and only the charts appear. Three charts of this: Normally there should be a table like the table attched.

1 year ago

marrysharif

asked in Transformers

How to concatenate a date field (format: mm/dd/yyyy) and a time field (format: hh:mm:ss) to a single field (format: mm/dd/yyyyhh:mm:ss)? They are already transformed by two separate AttributeManager.

423

1 year ago

gcarmichParticipant

asked in Transformers

Divide buffered line into equal lengths

I'm trying to buffer a line then divide it into equal distance sections. I've tried chopper but the resulting segments are not equal length and some are split awkwardly. How can I accomplish this in FME?

211

1 year ago

spidermanContributor

asked in General

How to create a line between two attributes at same table

Hello , i would like to create a line between two attributes that has coordinates at same tableThis table has many points .Id_1 | x1 |y1|id_2|x2|y2 x1 ,y1 relates to id_1x2,y2 relates to id_2Both of them are points. How could I create a line between id_1,id_2 and add text that include the value of id_1 and add text of value of id_2FME 2021

1 year ago

vimva679Supporter

asked in Transformers

How to COUNT total number of NULL values for EACH records ?

As an eg. there are 4 records i wanted to check how many null values are present for each records .

421

1 year ago

arthyContributor

asked in Transformers

No error but nothing was written in AZURE SQL table using sde connection file

I'm trying to write to a table in Azure SQL using a sde connection file.There is no error when running the workspace but nothing change in the table.What could be the issue?

102

1 year ago

jeaton

asked in Transformers

How do I get a schema to carry from a Feature Reader to a Dynamic Writer? I keep getting errors saying that 'Feature Type Definition {feature here} was requested, but not defined. I'm stumped. Thank you in advance!

P.S. When I have managed to get this to work, the attributes from the various features read by the FeatureReader aren't being written.

5615

1 year ago

galigisEnthusiast

asked in General

ArcObject Error with FME 2020 / Migrated from FME 2018 version

Hi Community, I'm trying to run an existing FME 2018.0 workbench on FME 2020.2. and just received ArcObjects is: '-2147219879' error. Tried to search online but couldn't find the workaround/solution. The FME workbench reads a GDB and applies metadata based on XML file as well as an excel file. Attached the log file for reference. Any help more than welcome 🙂

881

1 year ago

hlove2023

asked in Transformers

Sophos Virus protection is preventing install of Transformers which are supplied with FME which are not installed by default. Being detected as suspicious behaviour .

Within Sophos can exclude event id but as file locations for each transformer is different would have to keep adding them. Command used to install like below. Have excluded paths with no success. Is it possible to install transformers from command line rather than within FME application. Tried to use below command but file not found. Manual install may get round Sophos blocking . Thanks in advance for any advice supplied. pip install --force-reinstall --no-deps --no-index --find-links C:\\Users\\test\\AppData\\Roaming\\Safe Software\\FME\\Packages\\22800-win64\\PackageFiles\\safe.s3connector\\python --target C:\\Users\\test\\AppData\\Roaming\\Safe Software\\FME\\Packages\\22800-win64\\python\\safe.s3connector --upgrade --no-compile fme-amazons3'

262

1 year ago

dustinInfluencer

asked in Transformers

Deleting duplicate geometries in Oracle via SQLCreator

I'm working in an Oracle database, where there are multiple duplications of features with matching geometry that shouldn't be in a table named "TDS71"."METADATASRF". There are millions of records, and I haven't found a native FME transformer that can handle this in a timely manner (Matcher, AreaOnAreaOverlayer, etc). So I'm experimenting with deleting the duplicates in SQLCreator. For now, I'm simply just trying to return all but 1 of the duplicated geometries, and will worry about deleting after I can identify them. The code below is returning many more features than expected. I'm not really sure why to be honest. For example, a feature is duplicated 6 times in the database. From the query I have currently, 15 records are returned. Does anyone have experience doing this in SQLCreator/Executor?select a.OBJECTID, a.SHAPEfrom "TDS71"."METADATASRF" a join "TDS71"."METADATASRF" bon sdo_relate(a.SHAPE, b.SHAPE, 'mask=equal') = 'TRUE'and a.OBJECTID < b.OBJECTID

Since upgrading to FME Flow, the webmap for Geometry Picker is no longer working in my published workspaces.

I have workspaces that allow a users to define an area of interest when looking for data. Instead of the openstreetmap coming up, now it is just a grey box. Coordinates still get passed, but the user cannot see where they are drawing their polygon.

371

1 year ago

1
...
134
135
136
137
138
139
140
...
1102

Page 137 / 1102

Badge winners

dejan11has earned the badge Welcome Back
geoinspirationhas earned the badge Welcome Back
fbastian73has earned the badge Welcome Back
nick_ahas earned the badge Welcome Back
nick_ahas earned the badge FME Form Basic Training

Show all badges

30,114: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.