FME by Safe Software Community

Recent activity
Unanswered
Categories

arunkjContributor

AttributeManager with limited sets of attributes

I need something like the AttributeManager but it needs to work only on a limited set of attributes. What I need is a transformer that sets values (conditionally) to a handful of attributes. I need the ability to copy paste this box to various places in a workspace or to other workspaces. I’ve been using AttributeManager but the problem is it gets overwhelmed with other attributes and the transformer changes based on the input stream. I need something that’s sort of shielded from what’s in the pipe. These limited set of attributes are common to various workspaces or workflows (eg, datemodified, lastuser, datecreated etc) and are always guaranteed to exist. So naturally I need them handled in a simple, separate transformer that can be reused. Is there any way to achieve this? Thanks

15 hours ago

freegnome

Data

Unable to convert value taken from Z_ORIGIN keyword to a float data type

Hello,I am writing to ESRI geodatabase that uses MS SQL. Every time I get "Unable to convert value taken from Z_ORIGIN keyword to a float data type". So far i have:Used a 2dforcer,changed the "z scale and z origin" to 0 or 0.00000under table creation parameters set "Contains Z Values" to No (also set to yes, and blank on other trys)Recreated the writersSet the writer geometry to table, not a point file.Nothing has worked. I am under the assumption that the writer is passing a "Null" value to the writer which in turn says that "null" cant be a float value.Finally I have looked at the other posts on this and nothing has helped. Any suggestions? Just to update, I used a vertex creator to make new geometry, and still didn't work, but i can insert all of this into a file geodatabase and then import that to my enterprise database. If anyone has any help please post it, this issue doesn't have a good answer on the forms yet.

16 hours ago

asadamjad

General

I am getting errors while JobHistoryReader

Feature Type: `JobHistoryReader_LoopHere'Attribute(32 bit integer): `Loop to JobHistoryReader_LoopHere1664443291 Input Splitter.BranchingFactory.Count' has value `1'Attribute(string: UTF-8) : `_min_job_age' has value `20220928000000'Attribute(64 bit integer): `_offset' has value `0'Attribute(string: UTF-8) : `fme_feature_type' has value `Creator'Attribute(string: UTF-8) : `fme_geometry' has value `fme_undefined'Attribute(string: UTF-8) : `fme_type' has value `fme_no_geom'Coordinate System: `'Geometry Type: IFMENullCoordinate Dimension: 2===========================================================================Loop to JobHistoryReader_LoopHere1664443291 Input Splitter (BranchingFactory): Transformer/Factory JobHistoryReader_HTTPCaller is blocking and cannot be used in a loop, but was found between 'Loop to JobHistoryReader_LoopHere1664443291 Input Splitter' and 'JobHistoryReader_LoopHere1664443291 Input Splitter'An

18 hours ago

lambertusEnthusiast

Data

PostGIS Reader - warning about 3D feactures

I created a 2D spatial point dataset in a PostGIS database.Today I tried to load them into FME, that works perfect. I get the right locations including the according attributes.I only get this warning:Dimension metadata is ambiguous for spatial column 'geom'. Reporting 3D when 2D+measures might be presentDid I forget to set some specific settings while creating this dataset? There should be no 3D data present, I only saved 2D data :)

20 hours ago

mhabContributor

DI: step through selected features with automatic zoom to each featureOpen

Sometimes it would be very helpful in Data Inspector if it were possible to step through the selected features with an automatic zoom to each selected feature in the view window.At the moment it requires 2 clicks. One click for the next feature in the Feature Info window and a second click for each new feature on the "zoom to selected feature" button.

20 hours ago

chelseawuContributor

Automation

How to conditionally send out email based on output of a workspace in FME automation?

Hello,I have a flow automation set up to send out email with attachment(s) from a workspace. The output from the workspace include files: f1.xlsx, f2.kmz, and some parameter (e.g. ‘kmzneeded’ with value Yes/No).The email will always send f1.xlsx, but depends on whether or not user draw on the map, then f2.kmz need to be attached. Right now, I configured to include the two file path in server in the email attachment ("$(FME_SHAREDRESOURCE_TEMP)/F1.xlsx" "$(FME_SHAREDRESOURCE_TEMP)/F2.kmz"), so it always emails two files (with incorrect kmz from previously run). Can anyone please help point me a direction how to handle this? Any information is appreciated. 🙏

21 hours ago

danielleatsafeSafer

Question of the Week

Question of the Week: This or That

Hi FME Community, We’re switching things up for this Question of Week and playing a game of this or that! Tell us in the comments below: Cake or pie Spiderman or batman Tester or TestFilterThanks for playing along! New to the Question of the Week? Every week, we’ll post a simple but thought-provoking question that could be about your FME journey, the power of spatial data, FME innovation, or the future of FME.Each weekly question you answer earns you an entry in our monthly draw for exclusive Safe swag and points toward badges! Answer our October Questions of the Week by Thursday, October 31 at 5:00 pm PDT to be entered in this month’s draw.Answer your first question and you’ll get the Socializer (Ice Breaker) badge. Answer five questions and you’ll get the Socializer (Talker) badge.

1 day ago

stuart_misoParticipant

Authoring

Use existing Oracle table schema for writing into csv

I have a whopping great big table in my workbench with 2100 attribute fields in it! 😯The data originates from JSON files, and I need to write it into several csv files.The csv files need to pick up the schemas of tables in an Oracle db. These tables have a couple of hundred attribute fields / columns in, so many of my attribute fields will be dropped from the massive table in the workbench when creating the csv. This is good!The Oracle tables do not feature in the workbench at all, so I just need to grab the schema of the existing tables, bring them into the workbench, and use them in the csv writers.I’ve tried to use Schema Scanner, and Schema Mapper but with no luck. I am sure the answer must be really simple and I am doing something wrong.Any help will be much appreciated.Stuart

1 day ago

alpheusParticipant

Transformers

Transformers not installed message - AttributExposer and Clipper

Why do I get the message: The following potential problems were detected in this workspace:Transformers are used that are not installed: 'AttributeExposer (version 2)', 'Clipper (version 16)' The install/machine that created this workbench, and the install/machine I’m trying to run it on are different, is it a version mismatch? How can I fix it?

1 day ago

robotixContributor

Transformers

Install Package Manually

I have seen some partial answers to this while searching but nothing definitive.Can someone explain the best way to install a transformer [package] manually on Windows? More specifically, the emailer package from FME Hub. We don’t have internet connection to FME Hub so would need to download the package and install it. Does it have to be installed for each profile or can the users share a location for the package?Thanks!

1 day ago

arunkjContributor

Transformers

AttributeManager with limited sets of attributes

15 hours ago

freegnome

Data

Unable to convert value taken from Z_ORIGIN keyword to a float data type

16 hours ago

asadamjad

General

I am getting errors while JobHistoryReader

18 hours ago

lambertusEnthusiast

Data

PostGIS Reader - warning about 3D feactures

20 hours ago

alpheusParticipant

Transformers

Transformers not installed message - AttributExposer and Clipper

1 day ago

robotixContributor

Transformers

Install Package Manually

1 day ago

lifalin2016Contributor

Authoring

Python executable and site-package folder in various versions (e.g. 2022.2.6) ?

Hi.Is there an authoritative list somewhere of which versions of FME uses which versions of Python ?So far I have: 2020=3.7, 2021=3.8, 2022=3.9+3.10, 2023=3.11, 2024=3.12I’m assuming that the Python executable is located in [FME_ROOT]\fmepython###\python3.exe (or the dll’s). Is this correct ?And where is this executable’s site-packages folder located ?Is it at [FME_ROOT]\python ? Or [FME_ROOT]\python\python312 ? Or somewhere entirely different ?And is this location the same in an FME Engine for Server/Flow ?I’m contemplating adding a special Python package for use in both desktop and server.Cheers.

1 day ago

bwhitney

Transformers

Is there a way of working with GraphQL APIs using the HTTPCaller transformation?

I am in the process of working on an integration between Cityworks and ArcGIS Urban. While I am well-versed in using the HTTPCaller transformer for REST APIs in FME Desktop, after s few hours of working with an HTTPCaller, the only way I was able to make a GraphQL API call was using a PythonCaller with some custom code using the requests library. For now, the PythonCaller route will work well enough, but I would rather lean on the HTTPCaller for when others have to take over this integration who are not Pythonistas.

1 day ago

rzel24Contributor

Automation

How Can I Monitor New Files in Google Drive?

Hello,So we have been using FileExistanceChecker to monitor the addition of new files into our network folders, now we want to do the same for Google Drive Folders.We were hopping someone in the community has had any previous experience on how to do this regardless of the method used.Does anyone has any suggestions on how to do this from FME Form and FME Flow?.Thanks in advance.RZ.-

1 day ago

mkov

Transformers

Extract line segments between two points

HiI have a spreadsheet (see table below) with a start and end point coordinates for different road sections and I'm trying to extract the road segments between the start and end points from another dataset containing my road geometry. Unfortunately the start and end points do not always lie on the road so I would need to snap it to the closest road. The road directions (road ways) are stored as separate features in the dataset with a common road id.Section IdStart LatStart LongEnd LatEnd LongA-33.938..., 151.151.-33.935...151.131...B-33.949...151.138..-33.931...151.154...C------------E.g. For Section B, I want to extract the two segments in green from the underlying blue road. The eastbound (EB) and westbound (WB) road features have a common road id of 1.I tried using two vertex creators, a point on line over layer, a topology builder and feature merger, but I haven't had too much success. Any ideas on how this could be achieved?

1 day ago

Welcome

A space for news, notes and introductions

Announcements

20 Posts
59 Replies

Community Q+A

40 Posts
115 Replies

Question of the Week

17 Posts
307 Replies

User Spotlights

1 Post
4 Replies

FME Form

A space to discuss FME Form

Authoring

2994 Posts
12379 Replies

Data

6713 Posts
24736 Replies

Integration

1021 Posts
3593 Replies

Transformers

12569 Posts
50349 Replies

General

4034 Posts
13764 Replies

FME Flow

A space to discuss FME Flow

Automation

787 Posts
2676 Replies

Architecture

613 Posts
1989 Replies

Security

132 Posts
394 Replies

Deployment

74 Posts
159 Replies

Flow Hosted

83 Posts
247 Replies

General

606 Posts
1878 Replies

Community Alerts

Alerts about activities taking place in different parts of the FME Community and Safe customer ecosystem.

FME Hub Alerts

66 Posts
0 Replies

GIS-StackExchange Alerts

26 Posts
0 Replies

Blog Alerts

7 Posts
0 Replies

Leaderboard

Show full leaderboard

Redeem Reward Code

Enter a reward code and click submit to redeem the code for community reputation and badges.

List My Webinars

Click the button to retrieve your own personal webinar transcript.

List your webinars >

List My Badges

Click the button to find out which badges you have, and which you are yet to earn.

List your badges >

Welcome to the FME Community!

Community News and Announcements

Leaderboard

Redeem Reward Code

List My Webinars

List My Badges

Last Badge Awarded

More Useful Links

Need more help?

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Scanning file for viruses.

This file cannot be downloaded