- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Search

Unanswered questions

20229 Posts

Recently active

Most views Most replies

_camille_

asked in Transformers

Adding text to a GeoTIFF

Hello, I'd like to add a geo-referenced and framed text (see attached) to a GeoTIFF.I've used the transformers on the attached screenshot.Everything runs without error but the framed text does not appear on my output GeoTIFF.Could you help me? I'm new to FME. Thank you in advance,Camille

When processing 1000's of files, how can I create output in stages so that I don't loose everything if something goes wrong?

I use FME to extract geometry from 1000's of cad files and save the results in a single SHP file. The source files are listed in a CSV file, and they exist on servers in three different citiies which are all connected with a VPN. It takes a bit of time for FME to read each cad file, filter out the layers and geometry required, and then save them to a SHP file with attributes that point to the original source cad file. Last time I did this, it took about 6 hours to complete, and we have added a lot of data since then. I am worried about what would happen if the VPN connection to a server goes down. Will FME time-out and loose all the data that may have been written to the SHP file? I am thinking that perhaps I should add a counter and create a new SHP file for every 200 or so source files. That way if something goes wrong, I can figure out where to re-start the process.

112

1 year ago

borsky.lukas

asked in Transformers

Modifying a table through FME - Excel

Hi all one more time,I didtutorial example: Transpose a Table Using FME. Is it possible to further modifythe table according to the images below, please? Values could be"x" or any other. Thankyou all :)

1 year ago

jorgeherediasni

asked in General

Why are the log files just disappear when a workspace is being processed in the FME Server?

After it begins running, I have this message: Error: The log file for job ID "19099" does not exist.However, I can see it (only the job id and the workspace number) in the running jobs section.

662

1 year ago

nicole.mcstayContributor

asked in General

Is there a way a writer can create a new file with a new name to reflect any updates instead of just overwriting the current one?

I have workspaces looking a data quality which are automated on fme server. I am looking to record the monthly number updates from the workspaces and was wondering is there a way a writer can create a new file with a new name (e.g jan 2023 or Feb 2023) instead of just overwriting the current one?

285

1 year ago

mzuer

asked in Transformers

Iterate over a list of attribute names to compare in 2 datasets

Dear All, I am facing the following issue. I have 2 datasets (which are quite large) that contain a series of common attributes. I have a 3d table that stores the attribute names that I would like to compare (no geometry comparison). What I would like to do sounds very simple (sorry, I am newbie to FME...) :loading the 2 data, add prefix, merging them based on a key attribute (they will then have attributes like source1_col1, source2_col1, source1_col2, source2_col2, etc.)load the data that contain the column names I want to compare (e.g. col1, col2, etc.)iterate over col1, col2, etc. and for each of this value use TestFilter testing sth like "@Value(source1_$(column)) = @Value(source2_$(column))", write the unfiltered in an excel file on "$column" sheet) I have tried thousand things (custom transformer, ChangeDetector, workspace runner), but could not achieve exactly what I would like to do. One solution works rather well : I have a parent workspace that loads the

1551

1 year ago

dpkonofa

asked in Transformers

Splitting single input into multiple outputs for processing (Not fanout)

Is there a way to take a table as input and split it out into multiple outputs based on the value of an attribute (that I may not know)?I have a table of data that refreshes daily and one of the columns is for an object value. Most of the features (non-spatial) will have the same value for this field but people do have the option to set it to a different value that would be specific to them. Depending on the person adding data, the value could be different from one day to the next. Is there a transformer that will split a table out based on the value of a single field and then let me do different processing for each output? I've looked around and saw a few mentions of a "Fanout" but that looks to be something that happens on the writer and that's usually geospatial. I'm looking for something more like this:I see that there is an "AttributeFilter" transformer but it seems like I need to know what the values are that I would need to split by in advance. In

1796

1 year ago

barrett_hContributor

asked in General

Preserve attribute order from FeatureReader Generic port

Hi all, I'm wondering if it is possible to preserve the order of (unexposed) attributes when they come out of the Generic port of a FeatureReader. The attributes are coming out ordered alphabetically, I want them to remain in the order they appear in the schema. My process involves a dynamic FeatureReader to grab data records, a SchemaMapper to map (some) attributes to new names, a SchemaScanner to determine the new schema and a dynamic writer to write features out in the new schema. The problem I have is that the new schema is coming out with attributes in alphabetical order, rather than in the original order (with the old attributes mapped to their new names). Is it possible to preserve the attribute order from the Generic port of a FeatureReader? Thanks!

353

1 year ago

mp3robbo

asked in Transformers

Is it possible to apply group processing to only one of the input layers?

I'm wanting to see how many of a list of 34 overlays intersect each of 25,000 cadastral parcels, and get attributes from any that intersect. I'm currently using the SpatialRelator transformer, to see if each of parcels intersect the 34 overlays. However the output only appears to contain the attribute information of the first of the 34 overlays found, and I'm wanting all attribute information of all intersecting overlays. I would be able to achieve what I'm after if I used 34 different SpatialRelators, so each parcel could check if it touches any of the 34 overlays, however I'm hoping for a more concise solution. I wished that the SpatialRelator could do group processing that applies to only one layer, so that it effectively runs 34 times. AreaOnAreaOverlayer isn't doing what I'm wanting, as some of the parcels overlap and entirely contained by one another, which appears to be blocking the overlayer from reading them.

1 year ago

mzuer

asked in Transformers

WorkspaceRunner and UNDEFINED MACRO failure (user parameters)

Dear All, I am facing a very weird issue : I want to run another workspace using a workspacerunner with a set of user parameters. Sometimes it works, or sometimes I get a UNDEFINED MACRO error. What is really strange, it is that in some FME workspaces it works very well and the workspacerunner does the job - but in another workspace a workspacerunner (that calls exactly the same script with exactly the same set of input parameters) fails with the UNDEFINED MACRO failure. Even stranger : when I copy-paste the workspacerunner that does not work in the same workspace of the workspacerunners that works, it also does not work -> so in the same workspace I have 2 workspacerunners exactly identical, one working and the other raising a UNDEFINED macro error ???!!! I've spent days trying to understand what was wrong in my script and/or parameter settings, but I end up thinking something else might be wrong... Do you have any ideas what could cause the issue ?Particular cache files to del

231

1 year ago

dor1411993Contributor

asked in Integration

fme flow 2023.02 does not run jobs with a link to gdb or sde

HiAfter our server was upgraded to fme flow, the jobs that run together with ESRI services (gdb, sde) do not run, and this error is given: Unable to perform any licensing related tasks. Please check your Esri ArcGIS Compatibility workspace parameter, found in Navigator -> Workspace Parameters -> Translation. This 64-bit version of FME requires ArcGIS Desktop along with 64-bit Background Geoprocessing; ArcGIS Pro; or ArcGIS Enterprise. Refer to this this article http://fme.ly/qua for more details Of course, in the previous version of the server, everything worked smoothly,And also when I run the same jobs on the server's machine, along with fme form, everything works fine.There is ArcGIS Pro with a license, and full access for all users.I would appreciate your urgent help!Thank you!

Problems reading an XML file in FME Workbench

I am right now struggling to understand this issue. I have read XML several time with FME several times and never encountered this problem. I have an XML file that just lists a couple of airports with some basic information. The xml file looks like this: I read it like this: But when I read it in, this is what I get out of it: What is going wrong here?

421

1 year ago

asmithContributor

asked in General

ArcSDE Querier Deprecated - what to use in its place

Hi, we have several workbenches deployed to FME Server that use the ArcSDE Queirier, which is deprecated. It was reading data from an .sde and deleting the data based on a WHERE clause, and the translation was continued on the output ports of the transformer. What is a transformer that I can use in its place that meets the above requirements?

1 year ago

miguel

asked in Integration

I want to replicate oracle tables with SDO_GEOM data types to a Snowflake data warehouse without any transformations before. Just a straight up replication of the complete table, including the SDO_GEOM data field. Can Safe FME do that?

403

1 year ago

gpt_geoinfoContributor

asked in Flow Hosted

Is there an option to prevent a Job to be automatically restarted after an Instance is restarted?

I would like to prevent a Job to be automatically restarted after an Instance is restarted. In the FME Flow documentation I saw a "Job Recovery" configuration, does this configuration option exist in FME Flow Hosted (Cloud)? Can I set the max number of retries to 0 somewhere in FME Flow Hosted?

FME SQL Server Reader failing to connect . how do I check if this is a client issue? The DB is 2019 SQLServer.

error ( Microsoft SQL Server Spatial Reader: Failed to connect using Microsoft OLE DB Driver for SQL Server. Provider error '(-2147467259)). FME server version FME Server 2022.2 Build 22765 - win64, works on desktop with same SQLServer credentials

ArcGIS Enterprise Portal Connection

I have followed the steps at https://community.safe.com/s/article/How-to-create-an-FME-Web-Connection-for-Esri-ArcGIS-Portal-Feature-Service-OAuth-2-0?t=1688516897087 for FME Form only. After I am presented with the authentication challenge and log in with our portal administrator account I receive: "unable to retrieve access token""Request to update access token failed. HTTP Error: HTTP/1.1. 500 Internal Server Error

2945

1 year ago

peter100Contributor

asked in Transformers

How do I concatenate several rows in one row?

I have a table with multiple rows. Each line has a number. The number is appended to the column name. After that, each line should be appended to the other. The picture shows the starting table and the target. I've researched a lot but found nothing. Does anyone know how it works?

2079

1 year ago

joshuajames1979Contributor

asked in Transformers

Unable to Reproject ESRI ArcGIS Server Feature Service while pushing into SQL Spatial Database

Hi there, I am connecting to Vicmap as a Service (VAAS), which is an ESRI ArcGIS Service Feature Service, which will allow me to bring in the state property data and push it straight into our SQL Database. This will replace a weekly download of MapInfo files which are pushed into SQL via automated procedures. The ESRI data is in Vicgrid GDA2020 (EPSG:7899) and I am trying to push it out to SQL as UTM55S GDA2020 (EPSG:7855). It doesn't matter which projection tool or coordinate system tool I use the data still outputs as Lat Long with an SRID of 7844. Is there a way I can do this? I thought perhaps I need to output to a different file format and then reproject that file and push into SQL, but I'd rather avoid an extra step if possible. Regards, Josh

294

1 year ago

viviancfhungContributor

asked in Transformers

Keep attribute field order after schema scanner

In FME version 2023.1. We can keep the attribute field order after schema scanner for most of dataset. But for the attached dataset, we can't keep the attribute field order after schema scanner.Is any problem in my dataset?The fmw is attached alsoThanks

472

1 year ago

fmelizardContributor

asked in Authoring

401 or 404 when connecting to FME Server?

Why might I be getting a 401 or 404 when creating a web connection to FME Server from FME Workbench?

1145

1 year ago

robinso1Contributor

asked in Transformers

I wish to publish an tester output port which in turn is generated from a field containing OS Tile refs

I have 1,000's of 1km asc files which are simply named 1.. 10,000 which I wish to merge in to 5km asc files, and appropriately name with the correct OS Tile Ref. I have managed to perform a spatial filter and added the OS tile ref. I now wish to filter so all 1km tiles within an identified 5km tile go forward for merging. Is there a way to automatically filter based upon the present OS tiles without creating the individual condition filters manually?

1 year ago

stkolContributor

asked in Flow Hosted

"Unauthorized request by user due to lack of proper permissions" But only on one engine

I am getting the "Unauthorized request by user due to lack of proper permissions", none of the provided examples seems to be applicable as it should be engine agnostic, and I can run it on one of the two availible engines.. It is a simple "Read table from oracle database" -> "Write table to different oracle database" Running on a schedule it chooses Engine1 where I get the following error"FME Server error: `FME Server error: `Unauthorized request by user due to lack of proper permissions for connection: ODB . Please see: http://fme.ly/zn8'" It connects to said ODB and then connects to ODB2 and then does nothing. Manual run, it chooses Engine2: Connects and reads from ODB, then writes to ODB2

604

1 year ago

swarnaParticipant

asked in Transformers

We are trying to create geopdfs for different defined area having multiple devices , features in them. Adding labels to symbols using LabelPointReplacer Parameters and set the label scale that most of the area fits to it. But few areas are having labels that are overlapping with the symbols as shown below Is there a way to adjust the scale based on different areas.

100

1 year ago

thijsknapenContributor

asked in Transformers

StatisticsCalculator always expects Summary statistics, how about only Cumulative statistics?

In some cases I like to create cumulative statistics using the StatisticsCalculator. I'm glad it's kept as a Advanced option in the StatisticsCalculator. However, it feels a bit odd that the StatisticsCalculator seems to require/expect attributes for 'Summary statistics'. I.e. if I only want to create cumulative statistics, the StatisticsCalculator shows an error (Red Cogwheel) indicating; 'Parameter 'Statistics to Calculate: ' must have a value'; Although it's possible to ignore the error and run the translation, or provide a dummy attribute to calculate regular 'summary statistics', it doesn't feel fully correct. It would be nice to also have the option to only create Cumulative Statistics. I guess that may be possible by (also) embedding the regular 'summary statistics' in a Checked ParameterGroup (and be default checked).

104

1 year ago

Page 101 / 810

Badge winners

poonam21has earned the badge Integrate Data with the FME Platform Training
User15941217152509577149has earned the badge Welcome Back
gowthamvinohas earned the badge Teacher (Grey)
michaelhas earned the badge Welcome Back
gavhas earned the badge FME Certified Trainer

Show all badges

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