- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,681 Posts
50,727 Replies

When you subscribe we will email you when there is a new topic in this category

12681 Posts

Recently active

Most replies Most views Newest first

patoche_78

asked in Transformers

Error message : searchEnvelopeNative.fmi could not be opened

Hi folks,I have the following error when I run my Workbench project : 2020-04-17 08:05:41| 785.3| 0.0|ERROR |SpatialRelator_15_Output Feature Recorder -1 2147615062(RecorderFactory): File C:\\Apps\\fme\\FME18578_32b\\metafile\\searchEnvelopeNative.fmi could not be opened 2020-04-17 08:05:41| 785.3| 0.0|ERROR |File C:\\Apps\\fme\\FME18578_32b\\metafile\\searchEnvelopeNative.fmi could not be opened 2020-04-17 08:05:41| 785.3| 0.0|ERROR | I've read some other articles about similar posts here, but I did what was suggested (FME Options > Translation > Log Message Filter and unchecked "log Debug") I'm using an FME Professional Suite (FME 2018.1.1.1, build 18578 - 32 bits). Even in a 64 bits version, the error message is still there. You can see that it begins to write datas, but then stop.The log file is attached and the error messages are line 9611 and after thank you for any help ! Patrick

464

5 months ago

tkow_trappersParticipant

asked in Transformers

How do I copy AGOL reocrds with file attachments to a separate AGOL feature service?

I am trying to to transfer records with jpg file attachments between two seperate AGOL hosted feature services. The source has also has point geometry which is stripped out prior to passing into the target table. I've been able to create the target table by using the AGOL feature writer, but I'm unable to access the attachments - even though I've exposed the attachment attributes and ticked the "include attachments" parameter in the feature reader.Does anyone have a working example of this transformation?Thanks in advance,Brett

29617

5 months ago

davekazemiContributor

asked in Transformers

Error : unique Attribute Names strings in the translation

Error:I have a workflow using a generic reader and it give me below warning:2022-03-10 22:07:41| 135.3| 0.3|WARN |Detected 2600000 unique Attribute Names strings in the translation. Several unique names may result from operations like list attribute creation or feature type fanout. Reducing the number of unique names may improve translation performance and reduce memory usageany idea what the reason is?

1585

5 months ago

sunsilk11Contributor

asked in Transformers

Process one feature at a time

Hi,I have multiple features, for each I need use an Oracle sequence to get the ID of the feature.Then I need to write the feature to the database. The ID must be unique.I have used a SQLExecutor to obtain the sequence next value. I am struggling when there are multiple features to write. FME is executing the SQLExecutor multiple times before getting single value for the ID. I need to process each feature at a time i.e. run through SQLExecutor, get the feature ID and write feature to database, then proceed to next feature. Any suggestions ?

922

5 months ago

ajhemelsContributor

asked in Transformers

HTMLReportGenerator creating a table from excel sheet

I want all columns from the excel sheet in the table, not selecting them one by one in the column settings, is that possible?

251

6 months ago

fred.haanContributor

asked in Transformers

Emailer Transformer : Fail with [Errno 11001] getaddrinfo failed

Hello, I use FME Forms 2024 and I have a very basic workbench just to test the emailer transformer and the configuration of our email system.The Emailer is the following version When I run I have this error and it fails: <class 'socket.gaierror'>: [Errno 11001] getaddrinfo failed Any Idea ?Is it a probleme of mail smtp mail server accessibility. What is the configuration to adapt ?RegardsFred

4251

6 months ago

rzickuhrParticipant

asked in Transformers

HTTPCaller Enverus API v3 custom header parameter ignored in Form but works in Postman

Enverus’s Developer API has a custom header option to change the location of next link from the header to the body. When I put X-Omit-Header-Next-Links in the header of Postman I get the expected response: Results from Postmanputting X-Omit-Header-Next-Links in the header of HTTPCaller seems to be ignored as no next link is in the response body and the link remains in the response headers.HTTP Caller with X-Omit-Header-Next-LinksBottom of response body in FormReturned API header attributes in FormAm I doing something wrong or has anyone experienced this behavior?Thanks in advance,Randy

493

6 months ago

noggerContributor

asked in Transformers

Spikes in 3D view

Another one from my daily work:Is there any chance to find “spikes” in elevation to avoid situations like this in 3d view? I already found that there is spike remover but my job is to only find them.Red lines are bridges and they should look like a little bit smoother :)Attribute which they are based on is “F_ELEV” and “T_ELEV” Please help me with identifying such situation using FME.Shapefile with this situation:

492

6 months ago

joySupporter

asked in Transformers

Could I create maps with Classify and FeatureColorSetter

Hello everyone,Based on the following video I was delving a bit into the Classifier transformer in combination with the FeatureColorSetter and I was quite pleased with the possibility of coloring polygons based on a class.I assume making maps such as traditionally done in arcgis pro, is currently not possible in FME.However, since it's now possible to create chloropeth maps or give classes random colors now based on classes generated by the Classifier Transformer, I was thinking it might be a nice step in the direction of being able to create maps in FME. My wish would be as follows:You could for example use the classes id (generated by the Classifier transformer) and a label for the classes id to create the legend for the map.A title can then be filled in by the user and maybe a scale bar can automatically be generated based on the extent/coordinates of the data. Moreover the user can move where the following objects should be placed on a landscape/portrait on some kind of preview sc

412

6 months ago

rishi1804Contributor

asked in Transformers

FME not recognizing geometry

I have a dgn Model and it’s meshed there are some mesh elements in the model but FME is not recognizing them. AppearanceRemover is rejecting them, Geometry FIlter is returning them as null geometry. These elements are visible in microstation and looking absolutely fine. MISSING_GEOMETRY_APPEARANCE This the rejection code from APpearnce Remover and if I skip Appearnce Remover and pass it to geometry filter it returns the featurs as Null.

1072

6 months ago

hswebParticipant

asked in Transformers

FME GIS transformers

Hello everyone.. i am trying to use the GIS functionality of Union 3d in the FME. can you please advise which transformer can support this , since the normal union and joins for features and data will join data level. below is the Union 3D functionality of GIS ESRI.https://pro.arcgis.com/en/pro-app/latest/tool-reference/3d-analyst/union-3d.htmthank you in advance.

612

6 months ago

noggerContributor

asked in Transformers

Finding partially connected polygons within one layer

Hello guys,Has anyone ever encountered the following problem: I need to find such situations in my data. It’s not a typical gap between polygons and that is a problem for me. Let’s call it “partial gap”. Maybe someone already had similar problem and found a solution?Thanks in advance!Shapefile with this case:

532

6 months ago

barryParticipant

asked in Transformers

CRM api authentication issues

Trying to extract data via a CRM API. Stuck (401 errors for authentication in the FME logs) on our internal CRM api with FME. I can query the API using a web browser after authentication. I've also tried without success to authenticate with FME's ODATA reader with a similar authentication issue.the URL example is:https://MYSITE/api/data/v8.1/TABLE?When login works in a web browser there is a redirect (an active directory account is used) i believe this is using OAuth2 authentication.Any advice or hints would be appreciated. I have reviewed other posts on this form but have not been able to find a solution. thanks for the help!

449

6 months ago

thiruppathirajsContributor

asked in Transformers

Geocoder

Hey,Is there is no transformer for Geocode in Transformer gallery rather than take it from hub

604

6 months ago

p_c_20Contributor

asked in Transformers

Computer vision - recognise feature type in photo and calculate area coverage?

I’m looking at a workflow wherein the start point is this: Underwater photo manually copied into Powerpoint Measurement grid overlaid Percentage cover of different plant species estimated by eye Results copied to ExcelI haven’t dabbled in CV at all within FME, just read this blog - and this may be jumping in the deep end - but am wondering if this scenario might be a candidate?

701

6 months ago

claire.medici

asked in Transformers

Reading PDF Table

Hello, I am struggling to read a very simple table from a PDF, I just want to have something in the output. I have turn on only the "Read Tagged Tables" in the Reader's parameters, but nothing is coming out from it. The reader is not being created in my window. I have created a special table from excel in PDF to be sure that the table was fine. It looks simple in the FME presentation... https://www.safe.com/convert/geospatial-pdf/excel/ Could someone git me a hint about what am I doing wrong? Thanks! My simple PDF with its readable table: My Reading parameters:

28016

6 months ago

cosminciotinaContributor

asked in Transformers

Attache images to points data

I have a collection of photos and a point layer in SHP (Shapefile) format. I aim to replicate the functionality of 'Enable Attachments' from ArcGIS Pro. Specifically, I want to associate each photo with its corresponding point on the map based on matching the photo file names with a column in the point layer. Is that possible? What transformers should I use?

631

6 months ago

vimva679Supporter

asked in Transformers

Extraction of EXACT points (XYZ Excel File) that intersect / are completely within 3D Cube (IFC File)

Am sure am missing out some step or obtain right setting. I am trying to extract points that fall inside or intersect 3D Cube . I am also getting points as an output that are not within 3D Cube . Please note: 3D is cube is multi-surface with different shapes and its IFC file. I shall be highly obliged with FME Community expert to help me with their know-how and expertise to bridge that missing part / thank you for support and time.

382

6 months ago

stuarmitagehomeContributor

asked in Transformers

JSON - moving unexposed attributes into FME table

I am new to JSON, I’ve read the guides on here and have tried several ways to sort this without success.I’m using a JSON Reader to read from a file.The table has just three columns: OBJ; TIMESTAMP; and PK1.However, there are 114 attributes I can see in the Feature Information window which I need to bring into the table. (I am hoping ultimately that I won’t need 114 attributes!) As you can see I have tried the 4 transformers listed but without success. The answer might be to configure one of them correctly or link one to the next… but over to you clever folks to see if anyone can come up with the answer.Thanks in advance for any words of wisdom. :-)

462

6 months ago

hanymashadyContributor

asked in Transformers

Hello every one i have excel file saved in microsoft sharepoint, i need to read this file and update some attrbute without dowloading this file to my pc and update and upload again, i need to read and update directly in the file Thanks

272

6 months ago

rogbakContributor

asked in Transformers

AzureBlobStorageConnector FME Form 2024.0 python bug?

HiWhile converting an existing chain of workspaces from 2022.1 to 2024.0 version i ran into this issue:The current FME process locale has been changed from 'Norwegian Bokmål_Norway.utf8' to 'C' and FME has restored it back to 'Norwegian Bokmål_Norway.utf8'. It is undefined behavior to call 'setlocale()' in plugin code and doing so may cause unexpected errors..Python version 3.12 loaded successfullyPython: There is a known Windows bug that may cause instability when using Python in the current locale. Please update to Windows 10 version 2004 and greater, or to Windows Server 2022. See http://fme.ly/nw5 for more detailsC:\Users\%username%\AppData\Roaming\Safe Software\FME\Packages\24187-win64\python\safe.azurestorage\azure\storage\blob\_deserialization.py:657: SyntaxWarning: "is" with 'int' literal. Did you mean "=="? elif num_empty_lines is 2:Message Type: fme::internal::_v0::py::ExceptionPython Exception <Error>: unsupported locale settingPythonFactory failed to load python symb

740

6 months ago

stevekjParticipant

asked in Transformers

Terminator alternative

Good morning all - hoping that you can help me; I’ve got a fairly lengthy workbench which we run daily updating our internal data warehouse from a variety of sources. due to the complexisty, there are several no features testers included in the workbench which continue the translation when no data feeds in at certain points. However, there are certain instances where we would want the translation to stop (no new source file available, source system not ready for update etc.). We currently use terminators in order to stop the subsequent no features testers from triggering - however it would make it easier for us to keep on top of our monitoring if this didn’t then appear as a failed job in our server log - is there any alternative way of stopping the translation without it appearing as a fail?

805

6 months ago

no_idContributor

asked in Transformers

Conditional Values for Rule Configuration in AttributeValidator

I'm building a data validation tool and utilising the AttributeValidator heavily as part of the process. There are a couple of attributes that are "optional" but have an associated list of valid values (field validation/domain). This means they are allowed to be null, but if they have a value, it must be one of the pre-defined valid values. I'm hoping to use the Conditional Value option for Rule Configuration as below: However, upon running the workbench, FME terminates and the translation fails immediately due to "unbalanced quotation marks on line XXXX of file <workbench directory>\\wb-xlate-1700200438336_13788". Is this a bug or is my conditional value rule configuration just incorrect?

421

6 months ago

dbannon22Contributor

asked in Transformers

Logging in to new FME AR App

The new FME AR app update has introduced a login page with a URL or Barcode (see attached). Are these logins for a server app or a FME Flow instance? I cannot find any documentation on the process here. I have not been successful in logging into my FME Flow Instance or server apps so I am not sure what else the login url could be. Any help is appreciated.

715

6 months ago

leroyContributor

asked in Transformers

Handling Data Validation Errors in FME Script: Capturing Invalid Records for Review

In my scenario, I have an FME script that performs data validation. If the data is valid, it updates the database. However, if any records contain errors, I want to capture those records in an Excel file for users to review before uploading the data. In this error case, no data will be updated to database. So, the logic I'm aiming for is as follows:Validate the data. After validating all data, capture all invalid records to an Excel file. Then, terminate the FME script without uploading the data to the database. If all data is valid, proceed to upload it to the database.I've attempted to create a flow with a terminator, but the Excel writer doesn't have a connector. Connecting the terminator to the output port of the TestFilter after validation would terminate the writing of the error Excel file as well.Can anyone provide suggestions to solve this issue?

401

6 months ago

Page 19 / 508

Badge winners

mglancloshas earned the badge FME Flow Authoring Training
halinakozak29has earned the badge English Speaker
halinakozak29has earned the badge Polish Speaker
jregulovahas earned the badge FME Flow Authoring Training
reyhas earned the badge FME Flow Authoring Training

Show all badges

30,157: 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.