Skip to main content

- - Community Resources
Ideas
Product Updates
Events
Blog

EN

Home
Search

Unanswered questions

20008 Posts

Recently active

Most views Most replies

arunkjContributor

asked in Transformers

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

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.

asked in 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

lambertusEnthusiast

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 :)

alpheusParticipant

asked in 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?

robotixContributor

asked in 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!

lifalin2016Contributor

asked in 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.

asked in 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.

rzel24Contributor

asked in 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.-

asked in 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?

alicevdbContributor

WHERE Clause can read text with macronated o, but fails to read a User Parameter with same text macronated o.

Context: Feature Type with a WHERE clausePurpose: To only read records relating to a user defined Iwi (Maori Tribe).When the WHERE Clause is, for example: "IWI"='Whakatōhea', the transaction is successful and returns the expected records. However, when the WHERE Clause is set with a User Parameter "IWI"='$(IWI)'and the User Parameter is set with the value Whakatōhea, the transaction is successful but no records are found.This behavior is only affecting records with macronated vowels, which is common in Maori language. Users need to be able to input their Iwi of interest for this workbench.Can anyone suggest where the WHERE clause setup might fail?Many thanks

faresParticipant

asked in Community Q+A

ExcelToPDFWriter

Has anyone tried running the ExcelToPDFWriter in an FME flow? I’m encountering an issue where Excel cannot open the file when I run this transformer in the FME flow. However, I don’t face this issue when running it directly in FME Form. Any insights or solutions would be greatly appreciated!

asked in General

Health check failures after 24hrs when running FME Server in AWS using Aurora PostgreSQL Serverless for the FME Server Database

I'm running FME Server in AWS using Aurora PostgreSQL Serverless for the FME Server Database and I check the health of the server by calling the fmerest/v3/healthcheck?textResponse=true&ready=true REST API periodically. Everything runs ok for 24hrs but after that, the health checks start to fail and do not recover again. From the errors logged (below), I think it might be a connection pooling issue. I don't get the same issues on an Express install and there's a line on https://aws.amazon.com/blogs/database/best-practices-for-working-with-amazon-aurora-serverless/ that says "Aurora Serverless closes connections that are older than 24 hours. Make sure that your connection pool refreshes connections frequently.", so I think this might be the cause. I've copied some errors from the logs (can provide full logs if required), am I right in thinking this is caused by Aurora Serverless killing the connections or is this something else? Is there a setting anywhere that will force FME to ref

conchContributor

asked in Authoring

HTTP call syntax to retrieve OSM data

HiI’ve been constructing http calls to download OSM data to a .OSM file, then reading the downloaded .OSM file via a FeatureReader to generate specific outputs (yes, I know there are downloadable OSM transformers but they don’t do what’s required here).The specific problem I’m having is, not returning way or relation items into the downloaded file (if this is possible).Looking for assistance regarding the http call syntax. Below is what I’ve tried but still only returning point features (same results for both).https://overpass-api.de/api/interpreter?data=[bbox];node[building];out;way[building];out;relation[building];out;&bbox=@Value(_xmin),@Value(_ymin),@Value(_xmax),@Value(_ymax)https://overpass-api.de/api/interpreter?data=[bbox];nwr[building];out;&bbox=@Value(_xmin),@Value(_ymin),@Value(_xmax),@Value(_ymax)

timwarfeContributor

asked in Authoring

SharePoint Online Migration

Has someone please done a file transfer migration from one Sharepoint Online location (Site) to another Sharepoint Online location (site) and also keeping the original file Metadata, including created date, etc.. Using FME Form?

ldreyfussParticipant

asked in Transformers

Extract all line segments between many pairs of points

Hello,I have a set of pairs of points that each have a uniqueID_start and unique_end field. I am trying to extract all of the line segments between each pair of points. The tricky thing is that the pairs can be several line segments long, and have other pairs intersecting them:There could also be several points on a single spot, but corresponding to different pair sets.It’s a mess! Any help would be wonderful!

cstewartfortsasContributor

asked in Automation

FeatureReader works in Form but fails in Flow (by trying to read sidecar files)

I have a workspace that filters a folder for the newest .zip file contained within and then uses a FeatureReader to extract shapefiles out of it for further processing. This works perfectly in Form but in a Flow automation where it runs off of a folder watch, it fails with '<filename>.dbf' is not a valid Shapefile and cannot be read. So apparently when operating from Flow the FeatureReader is trying to read the sidecar files. Why? And how can I tell it to stick to .shps? Thank you

djmcdermottContributor

asked in Deployment

Unable to connect to FME Flow

Hello FME’ers.We recently upgraded our FME Flow and FME Form instances from 2023.1 to 2024.1 (Build 24622). FME Flow is installed as an express installation on single Windows Server 2016 and is configured to use HTTPS and Azure AD. FME Form is also installed on the server and my laptop. When testing the connection from Form to Flow on my laptop everything was fine. I way able to connect and upload/download workbenches. However, I am unable to do the same on the server itself. When connecting as Admin, I get:Login failed (Connection Error) - Unable to connect to FME Flow.When trying to connect was my user I get:Connection Storage: Request to update access token failed. (HTTP Error 'HTTP/1.1 400')I then went to refresh the Azure AD connection and got the following error:Server's certificate does not match the URL.Client does not have access to any certificates from the following issuers:Go Daddy Secure Certificate Authority - G2Go Daddy Root Certificate Authority - G2I am able to get to

fmelizardContributor

asked in FME Hub Alerts

OvertureMapsDataDownloader

FME Hub user ardadurmus just uploaded a new transformer to the FME Hub.OvertureMaps Downloader custom transformer allows FME users to directly access and download geospatial data from the OvertureMaps Foundation using DuckDB a high-performance SQL-based analytical database system. Runs with Executable file or command line system variable duckdb or duckdb.exe using System Caller. This transformer retrieving and storing overture map data in a local environment or temp folder that can be accesible during your process enabling integration with FME workflows for further spatial analysis transformation or export into other formats. It's designed for users who need fast access to large-scale open-source geospatial datasets in a seamless and efficient way.Would you like to know more? Click here to find out more details!

markotObserver

asked in Transformers

How to buffer a line?

How to buffer a line with different distances on the left and right side?The question is about road centrelines, where buffer needs to have different distances from centre line on left and right side.

jbreslerObserver

asked in Community Q+A

Turn on logging of SQL statements in 2014 workbench

Is there a way to turn on logging of the SQL statements that FME is issuing to Oracle in Workbench 2014?

tbarker1986Contributor

DWG Writer: Preserve Template File Paper Space Issue

Hi All, i’m having an issue writing to an AutoCAD DWG file, with a template file. I want to preserve the Model Space, but not the Paper space as i’m editing some attributes within the drawing title block in FME which I want to write back out in the paper space.Even though I am setting preserve paper space in the writer to No, the original blocks from the template file, including the original attribute values, are being written as well as a copy of the block with the new attribute values I have updated in FME. As a result I have 2 overlapping blocks, 1 with the new values I want to keep and 1 with the original values I am trying to replace. I just want a single block with my new values.In the attached, you can see the output from the writer, with the same block duplicated with the new value I have updated and the old value in the template (highlighted in yellow).Any thoughts/ideas/assistance with this would be greatly appreciated, whether this is possible or not possible. I have done si

asked in Transformers

How to fix bugged user parameter ?

I had a workspace with 13 user parameters. When renaming them all, I accidentally erased one's identifier, and it duplicated it and the new one is bugged. When I try to save, the workspace crashes. After publishing it on the server, trying to run it shows not a single user parameter. I can not delete it, and it is linked to every single transformer of the workspace (copy pasting any transformer from the bugged workspace to a new one imports the bugged user parameter and therefore corrupts the workspace).

kidegaContributor

asked in Transformers

Manage custom paths, Included Data from Writers in Form 2024

Hello,I have previously in Form 2023 added custom paths in the “Edit Data Download Properties → Include Data from Writers” when preparing to upload to Flow.The issue I now have in Form 2024.1 is that after I have published the workspace to Flow or if I reopen the workspace my custom paths are not saved within the workspace, or if it’s saved to Flow as it was in Form 2023. This makes the Republish option button not useful as I can see as I have to rewrite the custom paths. Or have I might missed something? To be clear I belive this only counts for custom paths and the benifit with custom paths is that I can customize how files are organised within the .zipped file from the Data download service.

so_much_moreContributor

asked in Transformers

Date functions only available in featureWriter transformer not in a Writer, why?

I need to write datetime to a comment on a SQL table after my postgres SQL writer is complete.This can easily be done like when using a featureWriter like so:COMMENT ON SCHEMA "my schema" IS '@DateTimeFormat(@DateTimeNow(), %Y-%m-%d %H:%M)';This is not possible if i use a regular postgres writer. Only SQL functions are available. This alone is not enough to set a timestamp.Tiny but frustrating neuance between almost identical transformer/writers. What other ways can i inject a datetime into my comment on schema syntax?

1
2
3
4
...
801

Page 1 / 801

Badge winners

t.yang_rmwbhas earned the badge Integrate Spatial Data
crystalatsafehas earned the badge Kanelbullens dag
ahuertahas earned the badge Welcome Back
chelseawuhas earned the badge Kanelbullens dag
dbaldacchino1has earned the badge English Speaker

Show all badges

29,799: Posts

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login

Login to the community

An FME Account is required to contribute

Login

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.

OK

This file cannot be downloaded

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

OK