General

Using AttributeManager to update 86,000 (existing) records using APN for key. Is this process optimized by FME? It takes a long time, and I assume it is N*N time. (Does the Reader iterate through each record, one at a time, then searching through all the records in the Writer to find the matching key?)

Hello again everyone, I have a question for anybody who's worked with passing JSON data in the body of a POST request for a webhook. I am working with a developer on a script to call FME server from an outside application and pass the needed JSON data in the body. She is using an AJAX script that looks somewhat like this: $.ajax({        url: <my server url with webhook token>,        method: 'POST',        data: {"A":"1",         "B":"2",        "C":"3",           },        dataType: "json",        success: function (response) {                             alert(JSON.stringify(response));                     },               error: function(data, errorThrown){                             alert('request failed :'+errorThrown);                             //document.getElementById("response").innerHTML="Failed"+errorThrown;             } }); Here's the thing: I have a

I have pdfs with multiple pagesi have to split them up by a certain textstring (e.g. SS 66,16)This textstring is always nearly on the same coordinate on the page, so i can isolate them and write the text in a new attribute but how can i fanout them that i have all content right from one page (e.g. pdf_page_number 2) and the pdf is named after that textstring (SS 66,16.pdf) Greetz and cheers Franco

We have an IFMEFeature from type FME_GEOM_AGGREGATE.The window "Feature Information" in FME Desktop displays the IFMEMultipoint property with 299 parts of IFMEPoint.How can we get these multipoints in the writer plugin? If we call feature->numCoordinates() we got 598 but if we call numParts () or numVertices() we got the correct number of 299.And if we call feature->getAllCoordinates() we got a list of 598 coordinates, but only 299 of these are correct and the other ones consists of a point with coordinates (1, 1, 0). Where does this point (1,1,0) come from?The list of coordinates starts with1,1,0valid point1,1,0valid Point1,1,0....

I need to be able to read an existing geodatabase annotation feature class (regardless of whether it is populated or not) and get a value for the "Annotation created with new features" annotation feature class attribute. Is there a corresponding FME geodatabase format attribute? If there is, would FME properly set the geodatabase attribute if I used that format attribute on a schema feauture used to build a geodatabase?

I did a spatial join of two AGOL layers, one is a strip map and the other is parcel data with owner info. I merged the two and created a table with the owner information and its respective page number. Some parcels are on more than one page, however, and I'm trying to make a table that includes these records and doesn't just omit them (there should be an individual record for each parcel and every page it shows up on). I've been trying to use the Spatial Relator with Generate List checked, followed by a List Exploder but it is not working. Does anyone know of a better way to do this? Edit: There is no common attribute between the two layers.

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