- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
General

General

A read-only category for lost FME Form topics. We hope to move them shortly.

4,032 Posts
13,815 Replies

When you subscribe we will email you when there is a new topic in this category

4032 Posts

ingallaContributor

How to send through the value of zero if no features coming through...

I am trying to update a feature class containing statistics. Basically i am using the following fieldsfme_basenamefme_featuretypeand each value from the fme_db_operation (insert, upsert, update, delete etc) is the number of eachmy problem is, that if there are no deletes i get no features coming through as expected, but how can i still send through the fme_basename, fme_featuretype, and for example the value of zero for the delete attribute.I want to be able to add the total records, but obviously can not do that if there is no value, hence setting as zero.From what i have, if there are changes then they go through the workflow as expected.Regards Andy

100

1 year ago

joshuajames1979Contributor

asked in General

Rubbersheeting Issue where One Polygon disappears - different shape to original

Hi there. I'm preparing our GIS data to adjust to align with new cadastre boundaries when our state mapbase is updated as part of the Digital Cadastre Modernisation. So far with testing it all looks good, but I see one polygon on one the layers has disappeared in the shifted version. On investigating it looks like the adjusted parcel this features sits on looses a few vertices in one corner and the shift vectors being used possibly cause a self intersection. I've attached the example. On the left, the grey is the current parcel boundary and the purple is the shifted, with the shift vector joining.On the right is the particular layer that aligns with the boundary that is disappearing post shift. You can see the shape of the parcel changes and it looks like the shift vectors would cause a self intersection. Just wondering if there are any ways to avoid this? I can see a record in the output data but no geometry, or an invalid geometry. Thanks in advance. Josh

1 year ago

spidermanContributor

asked in General

Question relates to geodatabase

Hello , i have geodatabase data as input ,it includes different points ,lines ,annotations . I would like to read this data in FME workbench and filter specific data from them for city then write the output again into new geodatabase writer .my problem : when I use spatial filter and use the specific city as filter and the geodatabase data as candidate .so the passed port include all data together and for sure not each input has the same attribute names as other .How could I write the output for my data (passed port ) into geodatabase format and each writer includes only his own data without any problem .

1 year ago

arnaud.leidgensContributor

asked in General

Water deficit calculation

Hello everyone, I try to automate a monthly calculation of water deficit, based on monthly rainfall data. Each feature is characterized by a year (integer), a month (integer), and rainfalls (float). The calculation involves the water reserve at the end of each month ("final reserve"), based on rainfalls and number of rainy days. My challenge is that I need to carry this quantity to the next month ("former reserve" of current month = "final reserve" of previous month). Easy to do in Excel, but I'm not sure if this is possible and how I should proceed in FME. Is there a matter of "iterative calculation" here, since the data of each month depends on data of previous month ? Should I convert my "year " and "month" integer into date format ? Thank you in advance !Regards,Arnaud

110

1 year ago

lfergContributor

asked in General

I have a workbench which has the GoogleDrive Connector in it which downloaded files to a local folder for me however it has stopped working and I get an Authorisation Error 400. When I go to authenticate my web service I get the attached message

and error message below. Not sure where to from here. It was working but I am a total novice at web connection stuff. 2023-06-01 15:11:03| 0.9| 0.0|WARN |Request to update access token failed. HTTP Error: HTTP/1.1 400 Bad Request2023-06-01 15:11:03| 0.9| 0.0|ERROR |Python Exception <FMEWSException>: Type: 3, Number: 1, Message: Failed to get authorization header.2023-06-01 15:11:03| 0.9| 0.0|ERROR |Traceback (most recent call last): File "fmegeneral\\plugins.py", line 500, in input File "webserviceconnector\\fmewebfs.py", line 1096, in receive_feature File "googledrive\\gdrivefs.py", line 569, in handle_operation File "webserviceconnector\\fmewebfs.py", line 699, in handle_operation File "webserviceconnector\\fmewebfs.py", line 856, in handle_download File "googledrive\\gdrivefs.py", line 466, in get_item_info File "googledrive\\gdrivefs.py", line 241, in get_file_metadata File "C:\\Program Files (x86)\

730

1 year ago

spidermanContributor

asked in General

How to convert from Esri Arcsde into File geodatabase ?

Hello ,i need to convert from EsrI Database Arcsde Geodb to write into Geodatabase (File Geodb Open Api)Feature reader :to read all feature classes in Arcsde feature write :file geodatabase my target to write specific feature classes that belongs to one Feature dataset from Esri Arcsde into file geodatabase i need exactly sample of feature dataset to test in ArcGis pro . FME 2021 Thanks in advance

420

1 year ago

sameerContributor

asked in General

Since upgrading to FME 2022.0.01 (Desktop/Server) I'm experiencing few issues.

One of them is:WARN MessageCould not load module 'C:\\Program Files\\FME\\2022\\plugins/MAPINFO.dll' : 'The specified module could not be found'Could not load module 'C:\\Program Files\\FME\\2022\\MAPINFO.dll' : 'The specified module could not be found' Translation is successful (Desktop or Server)

separately missing, null and empty values

Hi, I want to separately identify missing, null and empty values in a data array.I tried with the TestFilter, the sorting does not seem to be done correctly.Because, my file contains null and missing values but here all data exits in one place. Do you have a solution ? Thanking you in advance

140

1 year ago

scootercat_nlContributor

asked in General

Using FeatureReader after FeatureWriter

I have made a script that writes data to Oracle database, using FeatureWriter.Before I write data, I use FeatureReader to read number of records. At the end of the script I want to know how many records there are now.I also use FeatureReader for this. The results are always the same as before and after the transactions. It seems that the 2nd FeatureReader has already started before the transactions have been processed. I have tried with Oracle Reader, 2nd connection parameter, SQLExecutor.The results are always the same as before and after the transactions.Also using Triggerer and Decelarator. Something has to happen that the 2nd FeatureReader will 're-read' the table. Anyone has a suggestion ? Thank you in advance !

Creating a Network Using 'From' and 'To' Columns with Specific Conditions

Dear Safers,I am trying to create this network using the 'From' and 'To' columns.So, the number in 'From' is connected to 'To', and then find this 'To' number in 'From' and find it's corresponding 'To', and again find the second 'To' in next 'From' and get it's corresponding value in 'To'.The catch is, the value in 'To' has to be greater than 'From'.I can think of a go to solution in SQL, but can't think of something using transformers.Thank you for the support.

1 year ago

jkh

asked in General

How to assign values of a row to attribute name

Hi everyone, I am new to FME, please help me with the following issue. I am reading an excel file using FME. The name of the attributes (columns) is not right, and its in row 5 of the file. I was wondering how I can assign values in that row (5) as attribute names. I know that I can use a tool like AttributeManager to rename the attributes, but its too many attributes/columns (>100). I need a way that could assign the values from row to attribute name.Thanks

990

1 year ago

arsiContributor

asked in General

PDF2D (PDFWriter): Unable to successfully read the font

Using FME Desktop 2022: When attempting to write to pdf the following error occurs 'PDFWriter: Unable to successfully read the font from 'C:\\Windows\\Fonts/._TravelingTypewriter.ttf'. This font will not be available. Internal error code was '2'' FME has reading rights to this directory and the file exists. I haven't selected this particular font in the preceding PDFStyler-transformer. Any ideas why this occurs?

380

1 year ago

abdullah83Contributor

asked in General

CityJson cant read in Qgis

Hi i convert IFC to cityjson using FME. in FME everythink is ok like below: But when i open this cityjson file using Qgis, iit cant work like below: anybody can help me?tqvm

330

1 year ago

solene01Contributor

asked in General

can we retrieve data from a cloud with fme?

I would like to update my database with an excel file the problem is that it is on a cloud. This is a doc itself updated by several partners. Is it possible with fme to recover this data?Thank you in advance for your help

1 year ago

redamrini

asked in General

Visualizing elevation of flood in Cesium

I want to visualize 2 raster (DEM) the first is for terrain elevation and the second is a dem of a flood. I want to modilise the elevation of the flood compared with the terrain elecation and I want to visulise them in cesium just like I did in Arcscene. Is there a way to that like converting them in 3d tiles or something.

1570

1 year ago

mkastelijnsContributor

asked in General

How is it possible that 6 of 8 engines in FME server fail during the night running jobs? The error related to this faillure is attached in the text below. How can we prevent it to happen again?

There is a FME server setup with 8 engines, each on their own server. Error: Authentication failed: java.sql.SQLException: COM.safe.fmeserver.database.FMEServerDBException: org.postgresql.util.PSQLException: FATAL: remaining connection slots are reserved for non-replication superuser connections Anonymized event before the engine faillure: INFORM xxxxxxx 418049 : Received HTTP Basic credentials for user: xxxxxxxxx Temporary solution is restarting the FME-services on the servers. Possible cause: recursive connection error during authentication check which eventually shuts down the engine?

My free shape file from Ohio shows X and Y with this format? What transformer will change it to decimal?

Their format: X = 2067764.503 Y = 543479.582 -> I don't know this formatDesired format I need is: X = -82.1483 Y = 39.4917

1 year ago

richemcdContributor

asked in General

Using RasterToPolygon Coercer results in Hole Outside of Shell Geometry Error. The Geometry Validator is set to OGC. Attempt to repair results in no repaired geometries.

I’m currently receiving polygon geometry from various consultants, using various methods for deriving the polygons from Raster’s (GeoTiff). As part of our Data Validation process I validate all geometries to OGC Standards. Which, depending on software used, results in different issues, or not.While working through methodologies, to provide consultants with Software Specific guidance, I noticed that when using FME to generate the polygons it results in a Hole Outside of Shell geometry Issue's see Image below. We have only come accross this issue in FME, we have used ArcMap, ArcGIS Pro, QGIS and GDAL/OGR. The ESRI products result in 'Self Intersections', but the ArcGIS Pro 'Repair Geometry' Tool set ot OGR, fixes the issue. Both QGIS and GDAL/OGR are the only tools tested which by default result in OGC Compliant Geometries as outputs.I would like to be in a position to generate OGC compliant outputs from FME, considering we are using FME for our Validation process.I

Hi I am trying to write spatial features (which are results of a spatial join) in to a feature class using Feature Writer. For some reason it doesn't work and translation log shows "Error running translation".

I have removed ObjectID from the attributes and everything looks fine. My destination format is File GeoDB Open API

1 year ago

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?

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!

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

550

1 year ago

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

142

1 year ago

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.

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

1 year ago

Page 27 / 162

Badge winners

dmccullagh.npcahas earned the badge FME Form Basic Training
sdcp73has earned the badge Welcome Back
andybarnes1978has earned the badge Welcome Back
ibrucehas earned the badge FME Form Basic Training
ibrucehas earned the badge FME Form Advanced Training

Show all badges

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