FME Form

Dear All, I would like to read an excel ''configuration input file'' which contains the values that will be used to set the ''User parameters'' (2 columns table : first column giving the variable name, second column the value that the variable should take). Is it possible to that ? Can the ExcelReader parameter ''Read Form Control as Cell Value'' be used for this purpose ? What does this parameter ? I found no information about it in the help and tried a lot of things without success... Any help would be welcome !

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

I have points in WGS84, collected with a gps on one single point (static). I would like to determine the median of these points. Or the one point with the less deviation.Thank you for your comment.

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)

We have recently implemented a new version of the ESRI ArcGIS platform and are running the old geodatabase with the new one as well. Is there any functionality in FME to sync the old geodatabase with the new one. As of right now the two are out sync.

Hello all, I was planning to do a small workshop on FME Data Express... While preparing this, I found shockingly little information on the specific parameters I could use to interact with some specific phone-app functionality. This ... was the most informative post, noting 'We are still working on our documentation.' two years ago. How do I make the app ask for a QR-code?Can I somehow consume a picture?I seem to be able to get the location of the device with a specially named text-parameter. Are there more of those? Please, give this app some tender love and care in the documentation. Give it a technical blog-post and some example workspaces one can upload to ones own server as a startingpoint.. Martin

I have a CAD layer of control points which have two labels around it. I'm trying to extract the neighboring labels and add them as attributes in the final geodatabase. I have tried using NeighborFinder but it captures the nearest label only. I have tried to use a Tester to differentiate between the two labels and then run NeighborFinder but it leads to multiple records. The red circled is the control point and orange circled are the labels.  How can I capture the attributes and have 5 points in the output rather than duplicating them? 

Hello every one,I have a cad file with lines and block on to on them.The block have some attributes, and one of the is Length.for some reason, there are a lot of blocks that instead of having the length properly, it have #### marks.I tried to fixit of course with FME, I managed to recover the length from the line which the block is belonging to, but- when i'm writing it to dwg, it is get mess again!I tried to use Attribute Output in the writer definition, 'Inserts' or 'Limited' got the right length number, but they destroy a lot of other definitions in the cad file.can someone please help me?I'm attaching here small sample..Thanks!

Hi, I am trying to asses assets that are in CAD and not in GIS. Using the Spatial filter or the SpatialRelator i am getting results of one to many. I.e. the results are relating one candidate to many filters. What transformer can i use that only spatial joins one candidate to only one filter? Please help!

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 See log file attached.I alswo tried with pythonCaller but I didn't yet figure it out. Any tips to solve my case ?Thank you,

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, and I swear I haven't changed anything. (OK, yes, apparently I did, but I can't for the life of me think what.) Am I missing something simple here? (Feels like a "facepalm" situation, for sure.) Thanks, All.

 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?