General

Recently we installed FME server… And I’ve been banging around in it like a bull a China closet… Nothing is broken… just throwing up workbenches and trying to get things to process in the same way they are on FME Desktop. I’m having some success… but I feel its more like luck than “repeatable success”. I’ve looked on the Safe.com website and read through questions and articles… That helps some… but still needing a little more guidance…   What suggestions do you have? What guidelines/articles/manuals/reference material could you suggest? Here are some of the areas/errors where I’m struggling with…  Error connecting to Oracle database: message was `ORA-01017: invalid username/password; logon denied'. (serverType=`ORACLE8i', serverName=`odeq1', userName=`msaccess', password=`***', dbname=`')  Microsoft Word Writer: Aborting translation: Not authorized to access destination file. Please ensure that destination file is closed and check destination filepath  CSV write

I try to run diffrent workspaces with a WorkspaceRunner. It works with a fullpath but not if I use a AttributeValue or a UserParameter fed by a pathReader. The ErrorMessage contains "An error occurred while evaluating a test parameter: @Tcl2 -- failed to evaluate expression `WorkspaceRunner ..." I run it on Windows 10 with FME 2022.1. I already added FME_Home to PATH environment. With FME 2019.2.x it worked fine. An Example Workspace is provided.   

What software do I need in order to use PhotoCoordinateExtractor on a computer. ?

Hello, I am pretty new to all of this, so I am not even sure in which category to post my question. I have created a small FME Workspace containing a Reprojector. Now I want to include this tool into a Python Script already containing different other functions, and it should be possible to select which data to transform as well as the coordinate systems used. I tried to use the FMEWorkspaceRunner(), but it is only possible to state the Source and Destination Dataset, not to use the FMEReprojector.setCoordinateSystems() funktion. The same goes for calling the workspace over the command prompt with fme.exe it only accepts parameters for source and destination. As the workspace contains some other elements as well I also want to use the existing workspace and not to create reader, writer and all fmeobjects in the python skript every time the function is called.

I am using AttributeManager to write a Conditional Statement. I was wondering what other Transformers can I use that allow for Conditional Statements? I can achieve what I want using AttributeManager, as shown here. But, I am looking for alternatives other than AttributeManager to help me hone my FME skills.

I was watching the  OpenAI GPT-3 seminar the other day and the presenters had some magic turned on that allowed them to inspect transformers without attaching the usual inspectors. See image for a better explanation of what I am after. How do I turn on this feature/s? 

Hello FME Community,I want to control which records have no date format.Does anyone know how I can check whether data records have been saved correctly as dates.

Fme serverdesktop version: 2022.1 But if no features reach the writer then I get no summary output. In what way can I solve this dilemma?  The image I provided is not of the workspace itself, but it shows the problem.

I have an address field with an address value of 1244 Deep Creek RoadI want to use the AttributeSplitter to separate this value in a List so it comes out like this List{0} = 1244List{1} = Deep CreekList{2} = Road My question:What delimiter do I need to use that would split the 1244 into a separate list, but keep the "Deep Creek" together in List{1}? (Note that there are other streets with two names, I use "Deep Creek" as an example)

I can't seem to find this mentioned in the documentation or on the community posts

Hello everyone. We are experiencing some difficulties while running the workbench on the FME server. It had been working fine for a few years, but we are now experiencing these issues on a regular basis... Is it due to a memory problem? When I checked the server memory, I found that a maximum of 40% was occupied by RAM and 4% by CPU. What constitutes a problem and how to resolve it? Sometimes resubmitting the job in FME Server or restarting the FME server and running the job will produce positive results, but not always...

I've made great use of the HTTPCaller to connect to an external FTP, drag down the data, transform and utilise internally. What about the other way around? Could I use FME Desktop to write to an external FTP? This assumes I have all the right permissions, firewall exceptions etc. in place Thanks

Hi ! What I have is two colums and sometimes, I have to modify column1, but not each row. For examples : Column1 : PR1 Column2 : 0 ==> PR1+0 exists and PR1 stays as it is.Column1 : PR1 Column2 : 120Column1 : PR1 Column2 : 500Column1 : PR12 Column2 : 120 ==> there is no column2 = 0 ==> this means that PR12 doesn't exist, ==> so I need to get this another value in column1 : 'PR12+120'But I don't know how...I hope it's clear enough.Thanks for your help. Nati  

Hi there, I'm having an issue with an Active Directory connection after completing an upgrade to FME 2022. In the newly upgraded version of FME, when creating a Web Connection from FME Desktop to FME Server the correct permissions are not being assigned.  Choosing 'Windows Credentials' I can make a connection successfully, however I can only see the Samples repository. I can not publish if I click through the wizard. Digging deeper, it appears as though when choosing Windows Credentials, rather than passing through my logged-in user, I am authenticating as 'guest' - the built-in user. I have tested this by disabling that user from the FME Server UI, and the connection can no longer be made. There are no issues using the Windows Credentials via the browser, and interestingly no issues when making a Web Connection from an older version of FME Desktop, so I am confident that the AD setup with FME Server is ok. Is there anything new in the latest builds of FME Desktop t

I have FBX files with various textured 3D objects.The FBX includes file names for these texture files, eg. "textures\\asphalt2.jpg" and when FME loads the FBX, those textures are created as local JPG files in a folder .fbm. Essentially I need the texture name (filename) within FME. I can pull the individual textures as rasters as per the attached, but they dont have a name, specifically the filename. The closest I can find is the ShareItemID for each texture. How can I link the SharedItemID to the texture filename? Example attached.

I have a file geodatabase and a feature class called "Boundaries".I am using the Esri Geodatabase (File Geodb Open API) reader and I would like to apply this WHERE Clause, but the WHERE Clause is disabled."COUNTY" = 'Will County, IL' Is this a way to use the "SQL To Run Before Read" to achieve this? It can be found when you click on 'Parameters' and in the 'Advanced' section of the Esri Geodatabase (File Geodb Open API) reader.

I get the data from two different databases, which contain a point layer, and a surface layer, I combine the two layers using a transformer called FeatureMerger, and it works fine. I write the result to a third database, where the layer is a surface layer. All the fields with data that I want are included, but when I send the data to an sde database in the writer, information is missing in two fields. In the writer, data type = char is set. The information that is missing is data type = text, the number of characters is correct when I look in the writer. What is it that is wrong? Why doesn't the information that is in the two fields come along?

The Python package <numpy> in FME is using version 1.15.1 and I want to switch to version 1.16.1. Already tried to force reinstall:fme.exe python -m pip install --upgrade --force-reinstall numpy==1.16.1 --target C:\Users\301650\Documents\FME\Plugins\Python\python37It does install numpy 1.16.1. However FME Desktop is still using numpy 1.15.1. Is it possible to uninstall Python package in fme.exe python? It would be nice if command below does work, but currently it does not: fme.exe python -m pip uninstall numpy --------------------------------------------------------------------------------------------------------------------fme.exe python -m pip uninstall numpy Python version 3.7 loaded successfully Usage:  C:\Program Files\FME\fmepython37\python.exe -m pip uninstall [options] <package> ...  C:\Program Files\FME\fmepython37\python.exe -m pip uninstall [options] -r <requirements file> ... no such option: --target Error in running the Python command 'python %0'Program T

I note that ArcStroker will stroke CircularStrings but my testing indicates it won't stroke CurvePolygons and CompoundCurves. What transformer will allow me to so stroke those geometries?Simon

Hi FME Users, I have a list of points with coordinates and a lot of attributes. Based on this dataset I need to create (different size) polygon clusters, which depend on the criteria - such as distance from competition points, cluster density, number of POI in this cluster, and others.  Firstly I filtered data based on some criteria (eg. types of points, etc). Then I used NeighborFinder to find and filter these points which are too close to competition points (distance is defined by users as a parameter). But I am not sure how to create the polygon clusters.  I thought about using HexagonSample (custom transformer), NeighborhoodAggregator, or H3HexagonalIndexer. But unfortunately without any successful results. Maybe, someone from you had a similar task and could suggest how to approach this problem? Any tips or ideas from all of you will be very helpful! I am working on FME 2022.0, so it seems to me that I cannot use PointClusterer from FME Hub (the wrong Python version). Thanks in ad

I'm beta testing the new FGDB 'preserve GlobalID' parameter in 2023 build 23215. It does not seem to be preserving the values. In the test dataset I've attached, the GlobalIDs are used for relating the attachments table to the feature. Is there something else that needs to be done to ensure the values are preserved, besides setting the parameter to Yes?

I am trying to read an arcgis dimensions file from an sde . While reading i am getting the error "Unable to convert row to 'DimensionFeature'". i need to read the dimesions and need to convert them as a line feature.can you please hep me to resolve this issue.

Looking to extract 12 different unique number values in a CSV file. What would be the ideal way to accomplish this task. TIA

Hi all.I'm trying to update single values in a table, which has 3-4 keys. The three keys are mandatory, while the 4th is optional.A writer will apparently only update records which has a value for the 4th parameter, erroring when this value is NULL.Why is that ?I tried to test for the NULL value, but that didn't work. Apparantly the value needed to be tested as being an empty string, not a <null> value, even though that was what it contained.Is that a bug ?And lastly you - again apparently - cannot simultaneously have a writer/update and a SQL Executor (to handle the NULLs), the writer blocks the SQL Executor. I had to ditch the writer and go with two SQL Executor's.Why does a writer block transformers ?All this a s a warning to y'all. Can anyone confirm these findings ?Cheers.2020.2 / MS SQL Server

I've created an excel sheet with a series of dataset names and different equations to run against them e.g. @Value(COV_LEVEL)-@Value(INV_LEVEL) Using fme_feature_type and FeatureMerger I am able to get my datasets and the required equations together. How do I tell FME that to use the content of my Feature Attribute as an equation and action it rather than as seeing it as a text string? thanks