FME Form

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'm using HTTP Caller for geocoding adresses, but somehow I'm getting randomly lot of 400 responses - e.g. 2 of 12 calls are succesfull. If I copy paste the URL from error log to browser I'll get the result correctly.I'll share the worspace template temporarily including the API key of Geoapify. I don't know why I'm getting 400 (bad request).

I am trying to select a polygon located in between other polygons. All polygons are saved in the same layer. Either NeighborFinder or AreaOnAreaOverlayer do not provide the result I am after.

Hi, I'm encountering issues to connect to an sFTP server through a proxy.With my ftp client I'm able to connect with the following configuration.But I don't know how to configure my FME Desktop environnment and FTPCaller transformer to access to it.Here is how I tested it.Configure proxy settings on Windows Configure FME Desktop environnementConfigure FTP CallerI have the following error

Please appreciate if you could let me know in details  

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 have a set of features, all with IFMELine geometry, where some are closed and others are not. The closed ones vary between 2D and 3D closure. I can inspect these features and see the Closed propery right there in the Feature Information:(The straight line to the lower left of highlighted box has Closed = No, as one would expect.) So, for every line in the set, Closed is visible in the Feature Information window and has a value of Closed In 2D, Closed In 3D, or No; however, when I then run this set of features through a GeometryPropertyExtractor, all features are Rejected with the MISSING_GEOMETRY_PROPERTY error. The setup for this transformer in my workspace looks as follows:The transformer was working yesterday. Today, it isn't

 Please refer snapshot, creating texture Atlas using CITYGML data FME 2022.1.2 version

I am trying to connect to my Smallworld 5 database with FME 2022. I can connect successfully with 2021. I have FME Smallworld edition and have copied the needed connection files to the installation folder. What have changed between the two versions? It says 'This FME edition does not recognize the 'SWORLDSWAF' reader.

So I have data from several 100s of pumping stations. In a specific point in time there is a radical decline in what the sum of all pumping stations is delivering (it declines). I need an analysis that can verify if the decline comes from one, or several, of the pumps or if it is due to a "general" decline on all or most of the pumps? Could this be solved in FME? I have 20+ years of data so there should be sufficient amounts for statistical analysis. However, it is more important to be able to dispaly the results (in for instance in a graph) visually than for instance R technical value. Even if both could be of interest. Would appriciate all the input and since I am doing all the data prep in FME it would be great if this issue also could be solved in FME :) Regards

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 have two input table I set to LL-WGS84. I need to determine the length of the lines after the SpatialFilter in meters. I re-projected to XY-M then used LengthCalculator but the resulting values are not in meters. How do I reveal the line length in meters? 

Dear all,  I am facing the following issue - sounds very simple : I have a 2-column table that gives a mapping oldname->newname that I store in a dictionnary inside a PythonCaller ; in another PythonCaller, I need to use this dictionary.So far, I am doing the following : 1) in Python Start-up script, I define a global variableglobal mydictmydict = {}2) in the 1st PythonCaller : I populate a dictionary in the `input`function and then in the `close`function , I update the value of the global`all_progs` class FeatureProcessor(object):    def __init__(self):        tmpdict={}        pass    def input(self,feature):        # do something like :        tmpdict['oldname'] = 'newname'     def close(self):        mydict = tmpdict        pass3) in the 2nd PythonCaller I would like to use this dictionary ; but when I try iterating over t

In Attribute Manager I have created 3 fields (Borough Code, Block_Leading, Lot_Leading), 2 of which have leading zeros in them. I need to concatenate the three fields into a 10 digit string while retaining the leading zeros in the order listed above. My formula for for Block_Leading is @PadLeft(@Value(Block),5,0) and the formula for Lot_Leading is @PadLeft(@Value(Lot),4,0). Can I concatenate all three fields in a single formula in a new field in Attribute Manager and if so how? 

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 

Hello , I am working on migrate the data from arcmap to utility network and I have read some articles that FME can help in data migration .could someone explain me ,which ideas and steps should I consider to success in converting data from arcmap to Esri electric utility network Thanks in advance FME 2021  

I would like a PRJ file written alongside the DWG when using a dynamic format workflow. The bespoke AutoCAD writer has a setting, just looking for how to do with with a dynamic workflow.

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 C

I'm having some trouble when trying to upload Python libraries to FME Cloud and I couldn't find any documentation over it. I have tested that the workspace successfully imports the PyPDF2 python library on my desktop (windows 10). I then followed the directions on the post that is linked below and I am still unable to have the workspace on FME cloud import PyPDF2. I'm still fairly new to Python and haven't had any experience with Linux, so I'm not sure what I might be doing wrong.My stepsCreated a virtual machine with ubuntu (32 bit. No option for 64)Downloaded the source code for PyPDF2 from: https://github.com/mstamy2/PyPDF2Compiled the library on the virtual machine and copied the folder created in the dest-packages folder to FME Cloud folder located at Resources>Engine>Plugins>Python>Python27. (no files in site-packages)R