Skip to main content

- - Community Resources
Ideas
Product Updates
Events
Groups
Support
Knowledge

Start a post
Log In

Home
Forums
FME Form

FME Form

A space to discuss FME Form

Authoring
Data
Integration
Transformers
General

10000+ Posts

gogopotter90Contributor

asked in General

How I use aggregator and keep color of text

I have some texts that I have read from DGN format ,texts are colored.I would like to aggregate the texts and be as one together .i have found that the colors converted to black and white .so my question , how could I aggregate the texts and still has the original color . Thanks in advance FME 2018

asked in General

FME Desktop Build 22304: The fme workbench has “parsing error”,

FME Desktop Build 22304: The fme workbench has “parsing error”, I couldn’t figure out why the fme workbench has “parsing error”. As I open it, all the transformers are deleted. fortunately, I could restore it from the backup What could be the issue here?

asked in Transformers

How can I use HTTPCaller and HTMLExtractor to get past header tag and script?

I am trying to extract text from a data catalog website to use for metadata updating. I think I have all the pieces to get a line of text with the correct CSS selector. The problem is that the HTTPCaller doesn't even seem to register anything after the <header> tag so I can't extract anything in the main body. My output always comes out null.Here are a few screenshots of trying to just extract the title of the dataset page:The _response_body returned from the HTTPCaller doesn't even have the main <body> section.

knutosContributor

asked in Transformers

Hi, I have encountered a strange FME Engine error. Any suggestions?

The error occurs once in a while in a Workspace that is reading a PostGIS/PostgreSQL 12.9 database and writing a GEODATABASE_FILE using 64-bit ArcObjects from underlying an ArcGIS Desktop 10.8 installation. The error is triggered in a DatabaseJoiner, when attributes are joined in from a PostgreSQL table and written to the File Geodatabase simultaneously. The error happens once in a while (every second run or so), but it does strangely not occur on a PC with 64-bit ArcObjects from underlying an ArcGIS Desktop 10.4 installation or in any other variants of the workspace writing to other formats. The error occurs both on Desktop and Server. FME version is 2020.2.3. The error message does not say anything about the GEODATABASE_FILE writer, only the PostGIS reader, but the writer is obviously a part of the problem. If I disable the writer, nothing happens. If I bypass the DatabaseJoiner nothing happens. The message POSTGIS reader: stk::ex::bad_expected_access is discussed el

asked in General

How could I execute a SQL "select distinct" command on an ESRI FGDB Table?

I have tried using the unique value transformer but it only accepts a single column. The SQL Executor doesn´t read FDGB. So how could I do an SQL distinct on two columns?

chrisgrandinContributor

Hi, I'm trying to write mesh files incl textures from obj to Esri SLPK format. The problem I face it is takes a really long time. I'm a newbie on the slpk format and don't know if there is a smarter way to do the translation. Any help highly apprecia

Hi, I'm trying to write mesh files incl textures from obj to Esri SLPK format. The problem I face it is takes a really long time. I'm a newbie on the slpk format and don't know if there is a smarter way to do the translation. Any help highly appreciated.

asked in General

Sort data scattered over excel spreadsheet.

Hi everyone,we have hundreds of excel-files that we would like to read in and format with fme. But the data is scattered over one spreadsheet each. like this:We would now like to sort this data so that it is in order in a row.Is this possible with FME? If so how. Thanks for your help

asked in General

How to convert esri SLPK file format to PLY file format?

How to convert esri SLPK file format to PLY file format?

eridoParticipant

ECW Format v3 Writer error with coordinate system EPSG:2056 / EPSG:21780

With ECW v3 Writer I get the following error message: ECW writer: An invalid parameter was used : date and projection setting are invalid. The coordinate system used is EPSG:2056/EPSG:21780. With the coordinate systems UTM / LL-WGS84 the ECW v3 Writer works correctly!Tested with FME 2019.2.1.0 (Build 19813) WIN64 and FME 2020 Beta (Build 20153) WIN64.

asked in Transformers

Clip or Snip aggregate routes by measures

I have been trying to clip/snip a set of multipart linear features with measures based on from and to measure attributes. I've tried running the linear features through the Snipper transformer but all that seems to do is deaggregate the lines. Is there a way that I can replicate this functionality in FME?

swachContributor

asked in Transformers

Smallworld to file geodatabase writing changed in 2021

I have a process that reads a dataset from Smallworld to a point feature class in an esri file geodatabase. I works fine in 2019. In 2021 it now fails because apparently there are a few fme_aggregates in this dataset. How can I get these features to write again? GeometryCoercer and DeAggregator aren't working. I need this to work in 2021 but can't figure out how

DWG (topographic plan + underground network) to IFC model

(English translation below) Bonjour, Dans le cadre d'un projet, j'ai pour objectif de créer une routine permettant de convertir des plans topographiques et de réseaux enterrés en modèle 3D au format IFC. J'ai commencer à chercher, mais il semble y avoir à la fois beaucoup de possibilités et à la fois aucune que j'arrive à faire fonctionner. Je vous explique un peu mes données d'entrées. J'ai : Plan topographique, dessiné en 2D, contenant des points topographique avec attribut (altitude).Plan de réseaux enterrés avec des étiquettes (bloc ou texte) contenant des attributs divers (nature du réseaux, profondeur du réseau, type d'élément (fourreaux, câbles, canalisation...), altitude de la génératrice supérieur, ect.). Nuage de point j'ai donc plusieurs besoin : 1/ Il faut que j'arrive à faire que mes polylignes représentant me

ienesaglam60Contributor

asked in Transformers

SystemCaller error

I have one line command. This command works manually in cmd command windows. When I try with fme systemcaller it does not work. What could be the problem? Fme version 2021.1.1.0 build 21619example:xcopy "@Value(png_source)" "@Value(png_dest)*"xcopy "C:\\gml\\F-12696263-A.png" "C:\\gml\\gml\\F-23-A.png*"

surbhiContributor

asked in Authoring

How do I use a parameter to call a feature class in a Feature Reader when I run a workbench from a python script?

I am trying to read metadata in FGDC format from a feature class using a python script and workspace runner to call in a workbench. I want to know how I can set a parameter to call a feature class from a geodatabase.

posted in Transformers

@Takashi Iijima

@Takashi Iijima I need to separate text values for 'Texas_WellsTexas_WellsTOOOBIN_BOUNDTOOOBIN_TXTexas_Wells' as Texas_Wells Texas_Wells TOOOBIN_BOUND TOOOBIN_TX Texas_Wellscan you please help in building text to replace query?

quanguContributor

asked in General

Create underground terrain surface

Hi, community! I have not found any solutions to this problem in FME. The problem is to create underground terrain surface for each polygon class (such as clay, sand or gravel in this case <MRR, MRR, KM and MKM). Polygon classes have different z coordinate (from 1.8 to -8.7) and the colors represent their classes. I want to find a way to merge/dissolve the nearest polygons in the z coordinate (begin from the top) of each class to create terrain surface, see image below. For example, the gray color (see image below) should find the nearest gray color within a z range of 0.5 m or auto, and the next gray color should find the next closest gray color downwards and so on. If a green color is between two grays, the upper gray will stop merging/dissolving on the lower gray. The same pr

asked in Transformers

JSONTemplater, double counter in for loop

Hi All,Helped by info in this forum I constructed a loop in the JSONTemplater, to loop through a list and make a json array based on info if a certain condition is true. This works, I use a $i to reference to the index in the list. In a different counter $c I would like to keep up with how many values are entered i the array and use this value in the array as wel, but I can't get the $c counter to count up.This is what I have so far:[{let $top5s := fme:get-list-attribute("_prio{}.top5")let $themas := fme:get-list-attribute("_prio{}.thema")let $deelthemas := fme:get-list-attribute("_prio{}.deelthema")let $c := 0for $top5 at $i in $top5swhere xs:string($top5s[$i]) eq "Ja"let $c := $c + 1return {"titels": "Projectambitie " || $c ||": " || $deelthemas[$i] , "teksten": "Op basis van de locatie vraagt " || $deelthemas[$i] || " aandacht in je project." }}]It works, only

mark2atsafeSafer

asked in General

What's Up Wednesday (23-Mar-2022): World Tour News, a Photo Contest, Importing Google Location Data, a Community Badge Leaderboard, French GeoPackage data, the Consortech Awards, and more...

Hello FME'ers and welcome to What's Up Wednesday... Safe World Tour NewsLet's start with news about Safe's event on the FME World Tour. We call it a virtual brunch-and-learn, and it takes place on April 5th and 6th. Day 1 is a set of higher-level talks about the value of FME and how it helps to fuel business decisions. Day 2 is a more technical series of talks with specific demonstrations and examples. Meanwhile, before the event starts, you can also take part in our Data-Driven Photo Contest: Not only do you get to dress

actualabhijeetContributor

How to Migrate Oracle Geodatabase (sde) to MySQL Database - ( MySQL FGDB Schema extracted from Oracle database in ArcGIS Pro) in FME Desktop. Which all possible Transformers can be used to migrate this data.

Firstly, we have extracted the Schema of this Oracle database (sde) in MySQL FGDB format in ArcGIS Pro exporting this schema.Now, in FME Desktop I need to connect to Oracle database server and get this data as per feature classes present in datasets with all the attribution and its values with geometry in this MySQL FGDB Schema imported.Need help on this and which transformers can be used to get this Oracle data migrated in MySQL database Schema FGDB.

asked in Authoring

How to reference CSV from Writer for S3Connector?

How can I reference the CSV created from a Writer to upload to AWS S3 using S3Connector? I can successfully use a Reader to reference a file on my computer and upload to AWS S3 using my Web Connection and S3Connector, but I don't know how to reference a newly created file within my worflow. See attached.

izabretonContributor

asked in Transformers

Snap point to nearest point based on attributes

Hi, I have 2 layers with points features in shp. I want to create a tool that finds the nearest point from another layer of points only if the layer as the matching attributes and then snap to the nearest point, regardless of the distance, only the one that is closer to it and has the matching attributes. Example: 2 points with a oak attribute as sort. Thanks ahead! Isabelle

asked in Transformers

Is there a difference between AttributeRemover and Feature.removeAttribute('attr') in the PythonCaller

I was wondering, if there is a difference, how the two things work?I create Lists in a Spatialrelator, and I need to sum over some of their values. As I have a lot of data, I want to remove the lists after summation, and i think feature.removeAttribute('_relationship{}') does the trick. However if I add an AttributeRemover afterwards, under Lists it shows me the _relationship{} List, so it wasn't removed by feature.removeAttribute() ?

asked in Transformers

Excel template file cannot be located

Hi. I write data to an excel file using an excel template. I also make use of a Python script to upload the newly created excel file to SmartSheet making use of the API. The program runs perfectly from FME Workbench, but when I run it on FME Server, I get the following error message in the log: "Python Exception <FileNotFoundError>: [Errno 2] No such file or directory:" I have similar files running and working on FME server, but they do not make use of a template file. The error message pertains to the path of the template file, which is in the same directory where the dataset is written to.

asked in Transformers

JSON Array to table

hi,I have the following json time series and would like to convert it to a table structure.so per time and value an own row with all station information.Unfortunately I can't find a corresponding example in the FME help. [ { "ts_id": "19690010", "station_name": "Badinghagen W", "station_latitude": "51.084693593981505", "station_longitude": "7.650786142144193", "parametertype_name": "Niederschlagshöhe (N)", "ts_name": "Tag.Summe", "ts_unitname": "Millimeter", "ts_unitsymbol": "mm", "station_no": "13100039", "station_id": "12918", "rows": "4", "columns": "Timestamp,Value", "data": [ [ "2022-03-18", 0.03 ], [ "2022-03-19", 0.00

asked in General

Creating HTML report - output problem

Hello sir/ madam, I want to output my result as a HTML format. I want to output my source data (let say I have 3 source data) on new line.Like this: abccdefgh May I ask how to do it?I am not sure why mine is still on the same line. ( i have uploaded my capture screen below). Thank you. Zach

1
...
343
344
345
346
347
348
349
...
400

Page 346 / 400

Badge Winners

anryanhas earned the badge Teacher (Bronze)
petebarneyhas earned the badge FME Form Basic Training
cole1980has earned the badge Online Training
areederhas earned the badge Online Training
kneffhas earned the badge Online Training

Show all badges

Community Stats

32,513: Posts
123,487: Replies
40,730: Members

Powered by Gainsight

Terms & ConditionsAccessibility statement

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

A product of

Company Products Giving Back Careers Contact Trust Center Privacy

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.