- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Search

Unanswered questions

20229 Posts

Recently active

Most views Most replies

fbastian73Contributor

asked in Transformers

Hello FME experts!, help on FGDB spatial analysis.

I am looking for some suggestions on how I could create a workspace that would detect no intermediate junction between linear objects that share connectivity between them and are of a different asset group and/or asset type. an example would be a HV conductor connected to a LV conductor without a point feature in between.All suggestions welcome.thank you :)

1 year ago

asadamjad

asked in Transformers

GeoCoder Transfer

GeoCode transformation working very slow its take whole day to get the result just only 28K records is there any way to run faster

313

1 year ago

gogopotter90Contributor

asked in General

Is there a method to open DGS or PFD format from DIGSilent power factory ?

Hello ,How to open file has extension pfd or DGS format from power Factory DIGSilent ? The only exporting format from power factory is PFD or DGS ,There is no license or other option in power factory to export other formats .is there a method to open PFD or DGS file in FME and export the data from it ?FME 2021

5222

1 year ago

sameerContributor

asked in General

Embedding a Worksapce App as an iFrame using SSO loops back to the login page

Hello I'm creating a bespoke solution whereby the bottom of the page shows the Workspace App. The FME App will basically allow staff to submit comments. I've used an existing App for testing purposes which required the use of SSO (Azure). The Workspace App URL is simply enclosed within an iframe tag. <div class="embed-responsive embed-responsive-16by9"> <iframe class="embed-responsive-item" src="https://fme.mole-valley.gov.uk/fmeserver/apps/SubmitComments" allowfullscreen></iframe></div> The page shows both contents so all good.When I login as usual, it loops back to the log in page within the iframe.The Workspace App works as usual on its own. So I decided to create another Workspace App which does not require authentication. Used that instead for my iframe and everything works as expected. Any ideas / pointers?FME Server v2023.0.0.3 ThanksSameer

740

1 year ago

garbadekContributor

asked in Transformers

Can I generate an input file that will populate AttributeManager?

We update hundreds of shapefiles quarterly. The data we use comes from many sources, but we transform all the data of a single type into a standardized "Master" schema for that type (for example we get Parcel data from 70 counties, each having their own schema, and we translate and transfer that data into a standardized "MasterParcel" file). Using the above example we currently use 70 different workspaces containing 70 different instances of AttributeManager. To hopefully make this process much more efficient, we have developed is a database table containing rows like "ProviderSourceTable", "SourceAttribName", "SourceAttribType", "SourceAttribLength",...."TargetLayer", "TargetAttribName","TargetAttribType".... basically all the data AttributeManager needs to do the job for each data provider/data type combination. The only problem is we cannot figure out how to use this data to dynamically populat

1 year ago

fme_hansContributor

asked in Transformers

Is it possible to pause a workbench with an error message and resume it after a certain time?

Hi, With an http caller I execute get requests. This is done in a loop to enable pagination. Sometimes the server that receives and handles the request has trouble handling it and returns an error message. Is it possible to put a decelerator after the rejected port of the httpcaller and then redirect it to the inport of the loop so that the last get request is executed again and the workspace continues?

122

1 year ago

corsa

asked in Transformers

Process large number of input files in groups

I have 10000 GML files that I have read in as a single merged feature type. The task is to convert them into FBX files, maximum of 300 MB per FBX files. How do I accomplish this? I have tried modulocounter but doesnt seem to work.Also, I have tried fanout, and am trying to see if I should run a script to separate those files into folders first, prior to FME. Any ideas?

274

1 year ago

datamanContributor

asked in Automation

How to run one Workbench X times (Loop)

Hey there,I have written a workbench where I get some data from some weather-stations and generate the average temperature for that station as a line in a new Excel file. It works great but we have 100 Weather stations and I want to make it with all of the stations and get the excel file with 100 lines... I imagine it like:for i in 0..99 loop getDataFromStation(i) processData() writeDatain Excel(i)end loop But I have no way to do those loop in FME Desktop or Server. Or at leat I do not find it...Has anyone any idea?thanks a lot

185

1 year ago

virtualcitymattEvangelist

asked in General

GeometryReplacer Not working on utf-16LE strings (from SQLExcecutor)

I'm querying a table with geometries (PostGIS) and the resulting geometry column when run through a GeomtryReplacer just ends up with an empty geometry. The encoding is Hex Encoded OGC Well Known Binary. If I copy the string (with copy paste) into an attribute creator then the geometry gets replaced. The only differnce that I can see is that the string attribute from the SQLExcecutor is encoded as utf-16LE and the attributeCreator string is in UTF-8. It's kind of strange because another geometry column in the same database comes in as a utf-8 string. It's an envelope. This is the string/geometry in question:01060000A0E86400000100000001030000800100000005000000333333335C021C41000000C052BF54410000000000A05C403333333354021C41000000C052BF54410000000000A05C403333333354021C41000000C052BF5441CDCCCCCCCCEC5C40333333335C021C41000000C052BF5441CDCCCCCCCCEC5C40333333335C021C41000000C052BF54410000000000A05C40I was previously casting the Geometry using AS_STBinary() and then replacing using using OC

1 year ago

jnknnnContributor

asked in Transformers

How to update (or delete and insert) geopackage with another id than primary key?

I'm trying to update (or rather replace) rows with new features and write them to geopackage. The problem is geopackage primary key is "id" that is generated when writing geopackages and I'm reading features from postgres where that same id doesn't exists and another id (let's call it ChangeID) is used as a primary key. ChangeID does exist in the geopackages and postgres table but geopackages primary key must be "id". Unfortunately I have no control over why the id's is implemented like this. Also I know i could read those geopackages in to fme to get the "id"s but the problem is the dataset is hundreds of geopackages resulting in 100 millions of rows so the whole workflow is designed no to do that because that would result to weeks of runtime. I have a workflow to get rows that need to be replaced but fail to write them into geopackages because i can't use ChangeID to replace the rows because of different primary key. I know there

2137

1 year ago

kcarlsonham

asked in Transformers

AGOL Writer producing only 1 out of 26 features

I have a fairly straightforward workspace writing out one AGOL feature class with a large schema (American Community Survey data). After running the writer the translation log shows 26 features successfully written, however, the resulting AGOL feature class only has one feature. I am stumped as to why this might be happening as I've worked with AGOL writers pretty frequently and never encountered anything like this. Any advice?

1 year ago

woltersContributor

asked in Data

Int8 Gdal VRT Raster not supported by FME?

When attempting to load in a VRT Raster, created with GDALBUILDVRT that is in Int8 Format, FME says it is invalid. I am licensed to use the VRT format. I am using FME 2021. I am using the correct VRT Raster format when loading it into my workspace. It seems rather strange that FME would not support VRTs in Int8 formats. I am using GDAL 3.7.1-1 to create my Raster VRT's. Either using the commandline tool directly or manually creating VRT's in QGIS results in the same error. GEOTIFF writer: Setting feature type level option 'geotiff_compression_method' to value 'deflate' for feature type 'changedetect'GEOTIFF writer: Setting feature type level option 'geotiff_jpeg_compression_level' to value '25' for feature type 'changedetect'GEOTIFF writer: Setting feature type level option 'geotiff_deflate_compression_level' to value '6' for feature type 'changedetect'GEOTIFF writer: Setting feature type level option &#39

391

1 year ago

paul.brignall

asked in Transformers

How to terminate AzureEventHubsConnector in receive stream mode?

When using the AzureEventHubsCOnnector to receive in stream mode, the documentation states "Stream: The connector continues to receive messages indefinitely. The translation needs to be terminated in order to stop reception." Am i missing something here? how do you send a termination to it? In python this is straightforward...

1 year ago

kattContributor

asked in General

Bug: Transformer dropdown list not working when using other apps (e.g. zooming on a pdf in Adobe Acrobat)

I have a FME workbench open. Then I open a pdf in Adobe Acrobat Reader, and zoom in. Then I return to my FME script, I can not add any transformer to my script anymore. There is only a tiny box instead of the usual dropdown list. It is a bug. I tested it several times to make sure it is an issue. I am using FME 2022.1.

FeatureWriter to postgres does not apply what he shows to you (Automatic vs Manual)

Here's a simple table creation process with FeatureReader and FeatureWriterFor a value list table.The structure is the same and provided from the source tableAutomatic Attribute definition-> The primary key is not set CREATE TABLE IF NOT EXISTS eau_potable.vl_polygones( id integer, name character varying(200) COLLATE pg_catalog."default", color character varying(20) COLLATE pg_catalog."default", active boolean, CONSTRAINT vl_polygones_pkey PRIMARY KEY (id))Manual Attribute definition (only manipulation is uncheck the automatic to manual) -> The primary key is set successfulyCREATE TABLE IF NOT EXISTS eau_potable.vl_polygones( id integer NOT NULL DEFAULT nextval('eau_potable.vl_polygones_id_seq'::regclass), name character varying(200) COLLATE pg_catalog."default", color character varying(20) COLLATE pg_catalog."default", active boolean, CONSTRAINT vl_polygones_pkey PRIMARY KEY (id))This would be a nice thing to fix because I think everythink is known

1 year ago

herfried

asked in Authoring

Geopackage "attempt to write a readonly database"

Hi, After creating a simple Geopackage (one Table named '01004nnu') with the OGCGEOPACKAGE Writer with FME Desktop, I want to UPDATE Attributes in this Geopackage with a second workspace using the SQLExecutor. Error message:"OGCGEOPACKAGE reader: In ExecuteSQL(): sqlite3_step(UPDATE '01004nnu' SET col1 = '1' WHERE col1 = '8'): attempt to write a readonly database" The Geopackage ist not used by another process. SELECT Statements do work with the SQLExecutor.

1597

1 year ago

kellerContributor

asked in Transformers

How to implement a range value expression as key in feature merger

This might be an easy one but i could not find a way around it, I have two files File A (lines with geometry) and File B CSV file(lines without geometry). Both files have ID,START,END columns as shown below. So i was wondering how can i merge them on ID as the first key and also specify the range of the start value as the second key, (any other approach is welcomed)so what i expect is the first two values of FileB be given geometry from the first value of file A, and the third value of FileB be given geometry from the second value from FileA.Thanks ,Keller.

1 year ago

thijsknapenContributor

asked in Transformers

Reverse search using string function FindString() (negative startIndex?)

Say I have data like the following;sequence_path (string: UTF-8): 1.2.3.4As a result I wanted to fetch the parent from this sequence_path (i.e. '1.2.3'). In order to do so I wanted to do the following;Use a reverse search to find the position of the last '.' in the string, Fetch the (Left) substring up to the position of this last '.' To perform the first step, I thought to use the FindString() string function (with a negative startIndex). So, at first I thought that @FindString(@Value(sequence_path),.,-1) could be used. However, that returned '-1' (not found). However, somewhat unexpectedly at first, I noticed that '@FindString(@Value(sequence_path),.,-2) ' did return the desired value. Upon second reading of the String Functions documentation: "If startIdx is a negative integer, FindString() returns the index in str starting at startIdx from the end of string , then matching strToFind going forward (from left to right)." I now notice that the search is still from left to right (forwa

1232

1 year ago

ecxContributor

asked in Transformers

How to write to a versioned database via arcgis portal feature service writer

Hello, I wish to write to a specific version in a versioned feature dataset, by default the arcgis portal feature service writer writes to the SDE version aka the main/base version. Where can I configure which version the writer will write to? Thanks.

Is there a way to customize the webhook url in FME flow hosted?

633

1 year ago

davideagleContributor

asked in General

Group adjacent grid squares until a max attribute value is reached

I've got a grid of polygons, each square is equal in size but has an attribute stored against it with a numeric value. I want to group grid squares together based on a sum of that attribute, but that sum needs to be as close to an upper limit as possible. So for example in the picture below all 'like' coloured grid squares are collected into groups where their attribute sum does not exceed 60,000. As close to 60,000 as possible would also be acceptable. I can't have disparate geographic groups, it has to be one block of squares, albeit that block doesn't have to be completely uniform.When I started looking into this I thought, this must have a "name", an existing algorithm and "I bet there's already a custom transformer"... Well, I haven't found anything yet. Can anyone help put me out of my misery? This feels like a loop might be required, but the issue is the proximity, the grid squares might need to be pre-sorted geographically first?

152

1 year ago

dbannon22Contributor

asked in Transformers

Two Microsoft Graph API Post calls in one workspace, works on one but I get a token failure on the second.

I have two POST API calls to the Microsoft Graph API in my workspace. The workspace functions as intended on desktop ,but when I upload it to FME Server the POST call on the second HTTPCaller will fail saying that there was no token provided (message below). "message":"Access token is empty.","innerError" How can it work on one POST call and not the other when its using the same Web Connection? Also why is it functioning fine on desktop and not FME Server? Thanks

140

1 year ago

petria

asked in Architecture

FMEflow 2023 installation not working

I'm trying to install HighAvailamility setting (2 windows server , Oracle DB) fmeflow2023 windows (fme-flow-2023.0.0.3-b23319-win-x64.exe) Environment:2 FMEflow servers, Windows server 2022 standard editionsystem fileshare , Windows server 2022 standard edition fileserverOracle, Oracle 19c EE with Data guard Installion done fmeflow servers and it doesn't work.Trying to open web page (from local fmeflow server) it just give empty page with Fme:flow image. C:\\Program Files\\FMEFlow\\resources\\logs\\installation , folder is empty. Where to get help ? what is safe.com support address ?Is there any support from safe.com ?

161

1 year ago

rohit

asked in Transformers

PDF to SHP with Text embodied in pdf

Query ArcGIS feature service by using bounding box in where clause

Hi,I am trying to put query where clause in feature reader. the reader data is from esri Portal Feature Serice. I would like to put bounding envelop into where clause. I am not sure what is the clause should be. I would not like to query them all then do intersect. i would only like to query everything in the box I defined. the clause i am using somehting like:geometryType=esriGeometryEnvelope&geometry=1.6407885025300004E7,-4272238.302200001,1.6703666006300002E7,-4088621.626699999. it didn't workI would like to know:where clause support extent clasueif so what is the correct the clause structure. Thank you very much.

381

1 year ago

Page 105 / 810

Badge winners

andrew_pattersohas earned the badge Welcome Back
ebygommhas earned the badge Hooked by Python
poonam21has earned the badge Integrate Data with the FME Platform Training
User15941217152509577149has earned the badge Welcome Back
gowthamvinohas earned the badge Teacher (Grey)

Show all badges

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