Skip to main content
  • EN

FME Form

A space to discuss FME Form

10000 Posts
D
dchow
asked in Transformers
Extracting attributes from a KML in odd format

Hello,  I am having issues extracting info from a kml. Here is how the information is stored in the kml_description. What kind of transformer would I use to extract the info. <style type="text/css">td {white-space:nowrap} th {align:left} td.padr {padding-right:0.5cm}</style><table><tr><th></th><th></th></tr><tr><td class="padr">GPS Date:</td><td>03/29/17</td></tr><tr><td class="padr">GPS Time:</td><td>02:26:15pm</td></tr><tr><td class="padr">Datafile:</td><td>R032913A.cor</td></tr><tr><td class="padr">Avg Horz Prec:</td><td>0.9</td></tr><tr><td class="padr">Worst Horz Prec:</td><td>1.2</td></tr></table> 

798
D
D
dbeaton
asked in Data
Setting Log File location when using ArcGIS Data Interoperability Extension

Hi When working with full Desktop FME it is possible to set where the log file is written to disk through the GUI (or set it to be a parameter), however when working with the ArcGIS Data Interoperability Extension version setting the log file location is not available in the GUI (none of the workspace parameters are). Is it still possible to set where the log file should be written to on disk through a variable or is this functionality removed for a reason? Ideally, I would like to write the log file to sit alongside the data being processed. ArcGIS Desktop 10.5 which uses FME 2016 Many thanks Duncan

994
salvaleonrp
Enthusiast
K
kcech
asked in General
Feature Inspector does not show cached features

Hello, according to the docs, "to view recorded features, click an inspection icon on an output port". I would say that's what I'm doing, yet no features are shown in the Inspector. According to the number on the junction, there should be 4:What am I doing wrong?

1153
pmcpherson
Contributor
melanied
Contributor
melaniedContributor
asked in Transformers
Transformer Bufferer : ellipse ?

Hello, I use the transformer Bufferer in a workbench.I don't understand the result pour some features for which I have an ellipse in result (fme_geometry = fme_point, fme_type = fme_ellipse). I join a very simple fmw (2022.2) with 2 polygons. What parameters should I take to always have features with fme_type=fme_area et fme_geometry=fme_polygon ?  Mélanie

350
ctredinnick
Supporter
parashari
parashari
asked in General
Create Line from Points in One Column and Using 'From' and 'To' Values

I have a dataset that includes 'from' and 'to' values in separate columns. The 'from' column contains latitude and longitude coordinates. Both 'from' and 'to' values are unique.My question is: How can I create a line that connects the 'from' and 'to' values in FME? I would like to visualize the connection between these points using a line geometry.Any guidance or suggestions on the workflow or transformers to use would be greatly appreciated.Thank you in advance for your help!

582
parashari
O
olivertishmael
asked in Transformers
How to convert all the attribute names of all the feature classes within a File Geodatabase, to uppercase?

How to convert all the attribute names of all the feature classes within a File Geodatabase, to uppercase?

4040
chriswilson
Enthusiast
cory
Contributor
coryContributor
asked in Transformers
Sophos blocks Custom Transformers from the Hub

Hi team,I've seen this at multiple locations, where Sophos will prevent FME from installing custom transformers from the Hub (i.e. Emailer) and display a Lockdown alert, Sophos believes it to be malicious behavior. Has anyone else experienced this? Is it possible for Safe to reach out to Sophos to see if this can be looked at, as the only way to get around this, is to allow exceptions per Transformer on the Sophos side and we have to re-do this each time we upgrade FME Desktop.

470
siennaatsafe
Safer
C
clayb
asked in General
Trouble connecting to MongoDB

Attemping to connect to a hosted mongodb I get this error message:MONGODB3 reader: Server at xxxx:yy reports wire version 5, but this version of libmongoc requires at least 6 (MongoDB 3.6): generic server error I can see FME's reader doesn't like some app version on my db server. Is this something I can resolve in FME, or does the server require updating to allow FME to connect to it? Thanks,Clay

1300
C
E
eliton
asked in Authoring
"Persistence" of published parameters as password for embedded Postgres connexions

Hello everyone, I am trying to use a SQLExecutor with embedded connection parameters provided by some published user parameters. Here's an exemple:After saving the SQLExecutor parameters and reopening it, it seems that the last parameter (password param, i.e DB_PASSWORD) is not being persisted:At first i thought that it would not affect the connection parameters (i.e. maybe an small UI bug), but that's not the case since the SQLExecutor did not use the provided $(DB_PASSWORD): This is a local test, but i have similar results when targeting prod servers.Interestingly, this happens on FME2022.2 (Build 22765) but not on FME2018.0 (Build 18312) Do you notice the same behavior on your workbenchs ? Is there's an workaround for that? (I tried using an ParameterFetcher, same results)Thanks in advance!  

340
E
hlouie
Contributor
hlouieContributor
asked in Integration
I'm wondering if anyone has worked with MaintainX API?

I have an API Key from MaintainX but I'm trying to get pass the first stage of Authentication with Bearer Tokenhttps://api.getmaintainx.com/v1/docs

1743
hlouie
Contributor
antoine.prince
Contributor
antoine.princeContributor
asked in Transformers
Reverse string at certain caracter

I have a string column containing lake names in the format ''Blue, Lake'' and I would like to reverse the format to ''Lake Blue''. I somehow can't find a way to reverse a string at the comma.  Is there an easy way to accomplish this using string functions in FME ?

624
dustin
Influencer
H
hayleyl
asked in Transformers
StringReplacer to replace all text?

I am wanting my StringReplacer to search for values which start with a certain string, and replace the ENTIRE value with a new string (not just the start). I have table with a list of values starting with "Sh 1" and "Sh 77", and they all have following text after Sh 1 and Sh 77. I would like to replace the entire value, e.g. "Sh 1 Rs 401 Rakaia to Chertsey" should be replaced with "State Highway 1".  I have tried a few expressions, but currently I am only able to replace the "Sh 1" part of the string, not the following text.  How do I change my expression so the entire value is replaced?   

1503
ebygomm
Influencer
wrijs
Contributor
wrijsContributor
asked in Transformers
Best way to import an Esri Feature class, one at a time into workspacerunner?

I have a large set of featureclasses that need to be run into a workspace, one at a time because loading the dataset all at once will make my FME workspace terminate because the memory is full. I have used workspacerunner on a folder with multiple csv files, which solves the memory problem. But I can't figure out how to do a simular thing with multiple featureclasses. I wouldnt mind if the featureclasses need to merged into one and the input the first xx number of features into the workspacerunner. If that is even possible.

153
wrijs
Contributor
speknl
Contributor
speknlContributor
asked in Integration
How to get the SharePoint Online connector working (again)?

Hi there, Until a few days ago we had a working SharePointOnline Connector in FME which uploaded a .dwg file every day. After updating to FME Workbench 2022.2 that stopped working. A saw in the webservices options that the Tenant-ID was replaced with the string 'common' so I reverted this to our setttings. I used this YouTube-video for implementing the right settings inside FME. I can test the webconnection which is succesfull. But encounter a number of error messages. See below. I've also been troubleshooting together with IT to make sure that all proxy/FireWall settings are correct but nothing has changed there.Thusfar I've encountered the following error-messages:   As of now FME also stopped opening the webservices settings menu. It just shows the blue windows loading circle. Hopefully some of you recognize these errors and point me in the right direction for a solution. Thanks in advance! best regards, Jaap 

810
speknl
Contributor
data.djz
data.djz
asked in Transformers
Hi, The sharepoint list writer is not working for me once I add a geolocation field to the sharepoint list. Even when I don't write anything to the geolocation field, the writer still gives me: Python Exception <TypeError>: unhashable type: '

The writer stops working after I added a geolocation field to the sharepoint list. Even without writing anything to the geolocation field, the writer still gives me this error. Could anyone help me? Kind regards.  https://docs.safe.com/fme/2019.0/html/FME_Desktop_Documentation/FME_ReadersWriters/sharepoint/sharepoint-user-attr.htm

240
data.djz
quelozantonin
Contributor
quelozantoninContributor
asked in General
PythonCaller: Set and Get attributes from a class QMainWindow

Hello, I managed, with a PythonCaller, to create a dialog box with a dropdown list of choices, a button opening a url link depending on the selection. I would like now that:1) the choice list be taken from an FME list  (code line 38 below)2) once the coordinate is chosen, by clicking on "button2" ("OK..."), the FME attribute "Choix_adr" takes this coordinate and the FME script continues.  (code line 88 below) I have the following code that works at the list level (but without taking a FME list or defining the "Choix_adr" attribute once chosen) and the hyperlink button:from PyQt5.QtWidgets import *from PyQt5 import QtCore, QtGuifrom PyQt5.QtGui import *from PyQt5.QtCore import *import sysimport webbrowserimport fmeimport fmeobjects class Window(QMainWindow):     # Initialisation de la commande    def __init__(self):        super().__init__()         # définition du titre de la boite de dialogue        self.setWindowTitle("Choix de l'adresse")         # définition de la position et la ta

192
quelozantonin
Contributor
joshuajames1979
Contributor
joshuajames1979Contributor
asked in Transformers
GeometryExtractor WKT output splitting out multipolygons onto separate lines

Hi there. I am outputting SQL data into a CSV into well known text. Some of these features are polygons and others are multipolygons. I am finding in the output some multipolygon WKT strings are spilling over into other fields which throws everything out. I'm not sure the field length is exceeding the maximum length for a CSV but is there anything I can do to keep it all on one line or is this a problem with multipolygons? I'm using a GeometryExtractor to convert to WTK, then a couple of StringReplacers to remove Z and change the SRID from 0 to 3857 so the csv can be brought into Power BI. Most are appearing fine. Regards, Josh

1410
joshuajames1979
Contributor
dos_gis
Contributor
dos_gisContributor
asked in General
How to generate random 6 character alpha code?

Hi, I'm looking for a way to generate a random 6 character alpha code. SequenceGenerator looks like it would work but it only uses numeric values.

1350
dos_gis
Contributor
R
revillauni
asked in General
Problem translation

I don't understand why I'm getting a failure to transform the projection system and save it in another format.jpeg - ecwundefined - 25830 

30
JennaKAtSafe
Safer
esalmagul
esalmagul
asked in General
Is there a way to copy to excel user attributes table of any writer?

Is there a way to copy to excel user attributes table? I need to reproduce the table of writer attribute names, data type, width, value, precision. Figured there must be a way to extract those fast? 

130
fpaquet
Participant
G
ghattas111
asked in Transformers
FME-Desktop crashes while loading main Window or inside the application.

Hi I'm using FME 2022.2.5 it crashes at the start and before loading the main window, sometimes it happens when I enable/disable cache. the issue with Qt6Sql_fme.dll ! appcrash event in the the log file.. anyone with helpful tips it does start after 5-6 tries. this log is from the start up crash------------------------------------------------------------------Felet uppstod i programmet med namn: fmeworkbench.exe, version 2022.7.45.22795, tidsstämpel 0x6424fcdc, felet uppstod i modulen med namn: Qt6Sql_fme.dll, version 6.2.4.0, tidsstämpel 0x6254adbaUndantagskod: 0xc0000005Felförskjutning: 0x000000000000edbfProcess-ID: 0x7968Programmets starttid: 0x01d98ca438014579Sökväg till program: C:\\Program Files\\FME\\fmeworkbench.exeSökväg till modul: C:\\Program Files\\FME\\Qt6Sql_fme.dllRapport-ID: 4320bc12-2030-4046-b3b8-63e036810fb4Fullständigt namn på felaktigt paket: Program-ID relativt till felaktigt paket: ----------------------------------------------------------------------------

1390
JennaKAtSafe
Safer
F
fdh12316
asked in Transformers
Why is the position being moved after transforming the point cloud into the Mesh

Hi, i am using this structure to generate solid meshes from a LAS, extruding the point from x,y and z and then building the mesh of each small cube. But I found that the solid mesh was moved in the space (there is an offset) when I use cloud compare to viz it, and I don't know why it is occurred.Very grateful for the answer!! thanks:) ! 

70
JennaKAtSafe
Safer
mferwerda3
Contributor
mferwerda3Contributor
asked in General
MS Excel almost doubling in size when written by FME

Have and excel spreadsheet, roughly 90 mb, if II make a workspace that simply reads that excel file and writes it, the size of the written excel file by FME is about 179 mb. I am just using the defaults on both the reader and writer. If I open the file in excel and clear all cell formatting, and save, it drops the file size down to about 109 mb. Any Ideas why FME is writing a file that is almost double the size of the source file? and is there any way to clear out any formatting, assuming that is where the bloat is coming from ?

200
mferwerda3
Contributor
spatialcase
Contributor
spatialcaseContributor
asked in General
Where can I find non-spatial introductory tutorials for someone who wants to learn how to use FME (but doesn't care about the spatial stuff right now)?

FME training and tutorials appear to be a 'spatial first' - ie they assume that any new user wants to work with spatial data. But FME is fabulous for non-spatial data as well and this spatial-first approach is overly complex and off-putting for new non-spatial users. Does anyone know of any introductory tutorials, videos, etc that teach new users how to use FME without dragging them through complex (and irrelevant to them) topics such as spatial formats, coordinate system, geometry processing algorithms, etc?Thanks

120
samatsafe
Safer
C
candimk
asked in Integration
Has anyone tried using FME to connect CityWorks to Kronos time keeping? We'd like to have the time codes sent directly to Kronos instead of having someone manually enter them in.

Has anyone tried using FME to connect CityWorks to Kronos time keeping? We'd like to have the time codes sent directly to Kronos instead of having someone manually enter them in.

190
keziaatsafe
Safer

Badge Winners

Show all badges

Community Stats

31,852
Posts
120,988
Replies
39,485
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.