General

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 

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)\

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

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)

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   

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 ! 

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.

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

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? 

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

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

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.

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?

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

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

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

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?

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!

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

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

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 

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? 

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 ?

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