Skip to main content

FME Form

A space to discuss FME Form

10000+ Posts
G
gnash
asked in Data
jamal
jamal
asked in General
danilo_fme
Celebrity
danilo_fmeCelebrity
asked in Transformers
M
mger1974
asked in Transformers
How to retieve data from text file that resides on multiple lines

Hi, I have a problem extracting data from my text file.The file looks like this:******************************************#Textlimiter=;#Decimalsign=.#ProvadmColumn1, Column2...ColumnX;"Value1";"Value2"...""ValueX";"Value3";""Value4"..."ValueY";#ProvdatColumnA, ColumnB...ColumnZ;"ValueXX","ValueYY"..."Value11";"ValueQQ","ValueRR"..."Value22";#End******************************The ProvAdm-section can contain one or more rowsThe ProvDat section can also conrtain one or more rows I want to read ProvAdm section into one table (SQL Server) and ProvDat into one table (SQL Server) but I dont reaaly understand how to find out where ProvAdm section ends (how many rows should be read) or where ProvData starts (where should I st

3615
geomancer
Evangelist
S
sam.27
asked in Transformers
fme_can_do_it
Enthusiast
fme_can_do_itEnthusiast
asked in General
gogopotter90
Contributor
gogopotter90Contributor
asked in General
jamal
jamal
asked in General
J
joelavigueur
asked in Transformers
knutos
Contributor
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

3310
mark2atsafe
Safer
R
robertdbuckley
asked in General
chrisgrandin
Contributor
chrisgrandinContributor
asked in Data
ebiku
ebiku
asked in General
I
inf800
asked in General
erido
Participant
eridoParticipant
asked in Data
S
spalka
asked in Transformers
swach
Contributor
swachContributor
asked in Transformers
V
vbe
asked in Data
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

1050
V
ienesaglam60
Contributor
ienesaglam60Contributor
asked in Transformers
surbhi
Contributor
surbhiContributor
asked in Authoring
J
jdaswani05
posted in Transformers
quangu
Contributor
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

230
quangu
Contributor
S
stevens
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

1212
S
mark2atsafe
Safer
mark2atsafeSafer
asked in General
actualabhijeet
Contributor
actualabhijeetContributor
asked in Data

Badge Winners

Show all badges

Community Stats

32,569
Posts
123,647
Replies
40,863
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.