Skip to main content
  • EN

FME Form

A space to discuss FME Form

10000 Posts
soly
Contributor
solyContributor
asked in Transformers
how to reorder values in some cells ?

i have some cells contains Aaaa||ccc||ddd||bb||fffi would like to reverse them in case condition happens to get fff|||bb||||ddd||ccc||AaaaFME 2021Thanks in advance 

631
geomancer
Evangelist
galigis
Enthusiast
galigisEnthusiast
asked in Transformers
FeatureJoiner or FeatureMerger

Hi All,I’m working on a workflow that requires filtering some values based on a Lookup table. I’ve initially thought using FeatureJoiner to join and filter the values but doesn’t give me the desired results as the 1:M relationship doesn’t work. I have thought about the FeatureMerger to apply the 1:M relationship but can’t get it to work.Below a few screenshots of the tables:Table A- Example of the table to join (by TexString)Table B - LookUp table (by TextString - Column B)Only the highlighted cells will be used to join  Below is the part of the workflow to filter the value in the Table A but the join doesn’t do 1:M. There’s 193 records highlighted in yellow in the LookUp but the FeatureJoiner only joins 189 from the 1,363 records from Table A….and I’m expecting more values after the join as for example N = North Lines and S = South Lines values appears multiple times in the Table A and need to keep all of them. That’s why I think the 1:M is the one to apply here? Any trick to make the

5635
geomancer
Evangelist
dxirgu
Contributor
dxirguContributor
asked in Integration
Assign SLD to KML

Hi everyone!I’ll try to explain what we need...Nowadays, we have a download system based on Geoserver. When someone wants to download some data in KML format from the viewer, the data contain the same style you are displaying. So, you can open this KML in Google Earht and you can display it with the same symbology. Now, we want to change this download system and we want to do it using FME. But, when we download a KML, we have lost the symbology, beacuse we get data from database, not from Geoserver. Nevertheless, Geoserver contains SLD files from each layer. KMLStyler transformer can assign an static symbology, but this isn't what we want.The question is, is there any way to assign dynamicly, the SLD to KML, in order to display with the right symbology? That is, can we read he content of SLD and assign the colours to KML?

1372
dxirgu
Contributor
pgammie
Contributor
pgammieContributor
asked in Integration
Difference between Esri ArcGIS Server Feature Service Reader/Writer.and Esri ArcGIS Portal Feature Service Reader/Writer

I am making my first workspace that uses a reader for a hosted feature layer from Portal. I notice that I am able to use the Esri ArcGIS Server Feature Service Reader/Writer as well as the Esri ArcGIS Portal Feature Service Reader/Writer to achieve this. My question is what is the difference? As the end result was the same for both.The Esri ArcGIS Server Feature Service Reader/Writer seemed far simpler to use as all I needed was the user and password plus the feature layer URL while for the Esri ArcGIS Portal Feature Service Reader/Writer I had to enter the host, user, password and feature service which was the folder location of the feature layer plus the feature service ID on the end in brackets in order to get it to work. I am using FME 2018.0 as well if that makes a difference. 

1091
j.botterill
Influencer
outlook
Contributor
outlookContributor
asked in Data
st_geometry to (esri shape column) p

Hi All, I want to update geometry  column (esri SDE) from postgresql writer. What I need to do ? esri keeps the point value  like. 2D000000010000000100040001000000110000000101000090D1D3C2A00380A6E4AFBA0880A8D6B90700000000 I can reading from the postgresql as  sde.asText / asBinary    but I can not write 

946
hkingsbury
Celebrity
larue
Contributor
larueContributor
asked in Authoring
PDF Writer: Creation of Annotation objects?

This may end up as an Idea, but wanted to ask the community first: I have been trying to find some way to generate pdfs of floor plans that will contain annotation objects at specific coordinates, labeling things in the floor plan where the annotation can then be edited/appended.  Also, I want to ‘embed’ a GUID in each annotation that can be used to link back to other systems.    Use Case:Taking a pdf of floor plans onto a construction site, making comments on the provided annotations that can later be loaded into a Revit model by leveraging the GUIDs that came from Revit objects.  The pdf could be generated directly from a Revit model, or coordinate and GUID data could be extracted separately and added as a layer. You can imagine most buildings contain hundreds if not thousands of components that need to be maintained and tracked.   This is a universal problem for building owners and maintenance personnel.    As far as I can tell, there is no way to create these objects, only tooltips

440
larue
Contributor
soly
Contributor
solyContributor
asked in Transformers
how ro trace all paths and get ordering point and lines in eavh path ?

Hello , I need to trace all paths that I have ,start and end point of each path is available I would like to find the points and lines between start of path and end of path in different paths ?First point is start find the next point on the same path and the second point find the third point till end of path ,ordering points and also ordering lines between them .i would like to have excel file that include First row Start point (a) - next point (b)- lines (line id 1)Second row From b point - next point C - lines (line id 2 )and so on till end point (blue point )fllow direction from start point to end point as picture  

430
soly
Contributor
geouser97
Contributor
geouser97Contributor
asked in Data
using the result of anchoredsnap as the new input for every iteration.

Hello, I have a folder containing multiple shapefiles, for example,  (a, b, d, e, f...). My objective is to utilize the AnchoredSnapper transformer in the following manner: initially, snap shapefile 'a' with 'b', where 'a' serves as the anchor. Then, the resulting snapped shapefile will be used as the anchor and snapped with 'c', and so forth until all shapefiles are snapped. I tried to implement loops but the problem is that the output have to be the new output after every iteration, so i can't get a configuration of the loop. I appreciate any assistance or proposition you can provide. Thank you.This is my wokspace and the custom transformer , using a loop. 

441
nielsgerrits
VIP
L
leif
asked in General
Versioned geodatabase edit session writes 'successful', but not all are written

Hi,I am using:FME2021.1 32-bitArcSDE Geodb writer, truncating the SQL Server table in 10.x geodatabaseVersioned Edit Session to feature class that is registered as versionedFME log claims success and that all writes were saved. No errors, warnings or anything indicating an issue in the log at all. The problem:Only even 1000 are written. For example, 9454 features result in that FME log displays all written successfully, but only 9000 features exist in the geodatabase. If i use cloner and increase the feature count to even 10 000 all features are saved. Any suggestions? 

664
AliAtSafe
Safer
psprague
Contributor
pspragueContributor
asked in Authoring
command line with parameters only works with the cmd window running as administrator

I am running a workbench that uses dates as parameters. If I run the command in a windows cmd window without admin privilege's, the date parameters are not passed into the workbench. When I run the cmd window with admin privilege's it work as expected.  I am fairly new to FME and I am not sure what I am missing. Any insights are appreciated.  string passed to the cmd window:"C:\Program Files\ArcGIS\Data Interoperability for ArcGIS Pro\fme.exe" \\myserver\myworkbench.fmw --SourceDataset" --SourceDataset" --SourceDataset" --DestDataset_CSV2" \\myserver\myfolder\mycsv" --odbc2_where_clause "(reptd >= '2024-2-1 00:00:00' AND reptd < '2024-3-1 00:00:00 00:00:00')"  --FME_LAUNCH_VIEWER_APP" YES" 

2515
psprague
Contributor
J
jonathanhetheri
asked in Transformers
can FME support Nato Vector Graphics (NVG)

1094
geolassi
Contributor
gogopotter90
Contributor
gogopotter90Contributor
asked in Data
How to detect zigzag -spike -dangle lines and fix them ?

HelloHow could FME detect unwanted spike and unwanted zigzag and fix it without changing geometry of lines ?I have used spike remover and zigzag remover but sometimes it catches data that has no relevant with spikes ,what is best angle for transformers?How to keep the original geometry without changing it ,after fix the problem with zigzag or spike remover ?what is the best method to detect dangle lines and fix it ?thanks in advance fme 2021

1773
gogopotter90
Contributor
nicholas
Contributor
nicholasContributor
asked in Data
Difference between MapInfo Writers?

Hello all,I want to understand the difference between two MapInfo WritersI am running FME Desktop version FME(R) 2022.1.3.0 (20220928 - Build 22630 - WIN64)The Writers are;MapInfo TAB (MITAB)Precisely MapInfo TAB (MAPINFO) Is one Writer better than the other?

463
j.botterill
Influencer
katt
Supporter
kattSupporter
asked in Transformers
add an if condition to the json templater

Hello, I am creating a JSON file using several fme attributes. I want to include an if condition. If the typ =’HC’, I want to have an additional attribute (the name) added to the JSON. is it possible? The way the if condition is written here is not correct but it gives you an idea what I would like to do.{"Device": {"Type": fme:get-attribute("TYP"),"latitude": xs:decimal(fme:get-attribute("LAT")),"longitude": xs:decimal(fme:get-attribute("LON")),if fme:get-attribute("TYP") eq "HC"    then "Name": fme:get-attribute("NM")}}

4571
debbiatsafe
Safer
bskim
Participant
bskimParticipant
asked in General
Problem that material is not added to some obj when converting ifc

You are trying to parse the IFC file into Obj and metadata through your company's FME Desktop.​I don't know why, but there is a problem that materials are not added to some objs. Please help in this regard.​The attached file is the workbench file used at this time.​​Regards,Bongsup Kim​​

1657
kailinatsafe
Safer
jmcarthur
Contributor
jmcarthurContributor
asked in Authoring
Supress translation log

Is there a setting to disable the translation log window from automatically popping up when running a workspace? I’ve disabled all logging and hidden the window, but it pops up as soon as I run. I’m trying to record the execution of the workspace for a presentation, and the window keeps getting in the way.

1033
AliAtSafe
Safer
chris_acc
Contributor
chris_accContributor
asked in Transformers
Copy data from ESRI File Geodatabase to SQL

Hello, I am attempting to copy data from an ESRI FileGDB to a Feature Class in a SQL DB but no data appears to be copying.I have attached an example of a record from the log.  I have pasted “etc etc.” into it to shorten it as it is very long otherwise.I also get this error-Microsoft SQL Server Spatial Writer: Could not commit row locally. Provider error 'Description: Unspecified error'. Try turning off 'Bulk Insert'Hopefully this helps you troubleshoot my issueThankyou in advance

2415
chris_acc
Contributor
sylvainl
Contributor
sylvainlContributor
asked in Transformers
Alignement LandXML, Put a Attribut of Station/Offset on XYZ Point.

Hello, I have many points in txt file in PtNum,Y,X,Z,Description etc.And i have Alignements Geometry in a (Civil3D DWG OR LandXML) I want to put Stationning / Offset value on each point.Thx alot!!Running FME 2023.1.1 

2026
sylvainl
Contributor
takanaka
Contributor
takanakaContributor
asked in Data
Efficiency of CityGML

Hi,  I have some questions about how to make a CityGML more efficient. Context: I have about 1.8m pipelines and cables. I want to visualise these as 3D cylinder/pipes (not actual ‘FMEPipeGeometry’), regardless of the ‘is it necesary to do this’. All features also have attributes like diameter and such. I want to write this to CityDB and CityGML. This results in huge filesize (somwhere like 15gb or 20gb). What I did: My thought process was it would be more efficient to use relative geoetries (a circle) that I extrude/scale/offset/etc to the proper location using the transformation matrix. Of course I cut the original geometry into pairs of 2 vertices. I wanted to reaggregate this to 1 feature once I had the relative geometry up and working. This all worked just fine until I discovered that in CityGML schema the cardinality is 0-1 on features with relative geometry. This means I cannot gather all separate bits of the cables again, giving me an even more absurd amount of features. I also

1828
takanaka
Contributor
jd.fernandez
Participant
jd.fernandezParticipant
asked in Integration
Civil3d Multipatch - fixing attributes

Good day,Is there anyone here tried converting Civil3d Pipes and Structure into ESRI Geodatabase Multipatch in ArcGIS Pro?My issue is the original attribute from Civil3d doesn’t copy in the converted Multipatch - when I convert using ‘CAD To Geodatabase’Can FME translate Civil3d Pipe/Structure Property to change the incorrect Multipatch attributes?Please see image below: 

150
jd.fernandez
Participant
geographix
Contributor
geographixContributor
asked in Transformers
DateTimeConverter version 4 produces INVALID_INPUT

I have a datetime in the format YYYYmmddHHMMSS.SSS and want to convert it to any other format e.g. YYYYmmdd or DD-MM-YY or whatever. My super simple workspace is below. My FME version is Windows 2022.1.3.0 The DateTimeConverter version is 4 The result I get with every combination is INVALID_INPUT The Preview suggests everything is OK and what I expect: Any suggestions?

34912
jovitaatsafe
Safer
fme_can_do_it
Enthusiast
fme_can_do_itEnthusiast
asked in Integration
FME and API

Hi, I am trying to make API requests to connect to an application. It requires OAuth1 authentication. It seems like FME does not have built-in support for OAuth1. Is there a way to set the HTTP caller in this case? I would be extremely grateful if you could provide me with your assistance!

633
hkingsbury
Celebrity
jimmybowden29
Contributor
jimmybowden29Contributor
asked in Data
Esri Utility network reader subtype layer

The Esri ArcGIS Portal Feature Service Reader has most of the capabilities needed to read from a Utility Network including being able to set branch versioning. However there doesn't seem to be a way to resolve domains that are defined at the subtype. The Utility Network uses the subtype layer concept where domains can be applied differently on each field by subtype. Is accessing the subtype domains something the FME can/will support?

26718
jakethepainter
Contributor
fme_can_do_it
Enthusiast
fme_can_do_itEnthusiast
asked in Authoring
ArcSDE geodatabase writer

When using the Transaction Type: Versioned Edit session in an ArcSDE geodatabase writer, all edits will be rolled back in the event of a translation failure. The geodatabase writer is set to Insert records in my workspace and I noticed numerous duplicate records after the translation failed due to conflicts identified during reconciliation. Do we need to modify anything in the writer? Thank you!

794
fme_can_do_it
Enthusiast
marianny
Participant
mariannyParticipant
asked in Authoring
Entering the same Attribute Value for multiple Input Attribute within AttributeManager

I’m a newbie using FME although I have also experience with SQL and GIS. I recently started working on a transformer using the AttributeManager. This contains ~ 40 attributes and the goal is to convert part of those attributes based on different conditions, and others attributes based on a same expression: @double(@CurrentAttribute())I was wondering if there was a method to apply the same attribute expression on several input attributes at once while keeping everything in one transformer.Thank you in advance!

1771
becchr
Influencer

Badge Winners

  • FME Form Basic Training
    johnrochehas earned the badge FME Form Basic Training
  • FME Form Advanced Training
    sahan969has earned the badge FME Form Advanced Training
  • Student (Bronze)
    marionmahothas earned the badge Student (Bronze)
  • FME Form Basic Training
    dezuviriamhas earned the badge FME Form Basic Training
  • Welcome Back
    dwade10has earned the badge Welcome Back
Show all badges

Community Stats

31,799
Posts
120,800
Replies
39,417
Members

Latest FME

Terms & ConditionsCookie settings
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.