FME Form

The connection works fine; but when I try to read data i get: Error running query: Failed to acquire a SAS token for list on /__unitystorage/schemas/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/tables/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/_delta_log Exception: 403: Your token is missing the required scopes for this endpoint. What is wrong? --- I am quite new to databricks. Thank you.

I have created a geojson file from nine features drawn from a postgis database. I have tried all the examples from the community pages with no success. Can anybody point me in the right direction?

Need to filter out the large list of Attribute values(Around random 10000 values) to be processed. Currently it is tedious using 'AttributeFilter' transformer as it needs all 10000 output ports to be connected to next transformer for further processing.There should be other transformers for sure which I don't remember any. Please help.-Thanks

Is it possible to access GEE API from FME (and for example run a script using Sentinel data to extract vector data for edge of recently burnt area)Does anyone have experience in doing this?Thanks.

Is Azure Communication Services (ACS) supported in FME?

Hello everyone,Is it possible to connect to a cloud (PIX4Dcloud) where point clouds are stored, so we can download for exemple files automaticly with FME ? Thank you

Hi everyone,I need to convert multiple 3D .dwg files to feature class gdb. that can be readable and presentable in ArcGIS Pro, or Enterprise.The manual process in ArcGIS pro include these 3 steps Step 1. Bring in MultiPatch feature to ArcProStep 2. Select the original MultiPatch feature class and export data to geodatabaseStep 3. Use the new exported data feature class and input it into the colour model builderbut it is time consuming and I am receiving 25 file each day.Do you know which transformers can be used?here are a few important notes:the color for the component in GIS must be same as original dwg file  The workspace need to be dynamic, which means every day the files need to be read from online datasets, from different locations. (I think I need to start with “Creator” ) The files are 3D in dwg and I need to have them 3D as well the dwg files are in NAD 1983 CSRS MTM 10 and

@ReplaceRegularExpression(@Value(DETAILS),<.+?>,,caseSensitive=FALSE), @ReplaceString(@Value(DETAILS),&qout;,",caseSensitive=TRUE) The first expression replaces any text in details attribute that is bracketed with <> to be deleted.the second expression replaces any instance where &qout; appears with “.These work fine as separate transformations, however when trying to lump them into a single statement in attribute manager’s text editor the transform fails.I’ve tried comma separating, spacing, and barring the functions, but have had no luck. Any suggestions on how to get this to run? Thanks!

Hi. I run the workspace runner with the file path in user parameter. If there is a space (“ “) in the path, the parameter is loaded in a weird way: --DestDataset_ACAD {${=I:<backslash>Data<backslash>CAH<backslash>GAK<backslash>Data<backslash>GAK<backslash>FME-WorkSpace<backslash>09-Export<space>ZML<solidus>_final…But it works fine if I run original workspace. Is there some bug with Workspace runner?

I posted this Thursday, but apparently it hasn’t been ported to the new system, so here goes again: I have a job that harvest a number of data layers via WFS. As of late, the job has been throwing an error, when reading a particularly large dataset.I've tried to retrieve the same dataset as an XML (GML) file using HttpCaller, and the resulting file is 452 Mb.The error says something about "message: comment or processing instruction expected", but it points to the end of the very last line of the data file, and the data file syntax seems ok.So I'm wondering whether I've hit a limitation in the WFS reader ? E.g. a limitation in downloaded file size ?For now, I've split the original FeatureReader fetching 5 layers at once, into 5 FeatureReaders each fetching a single layer. I'll see if that solves anything tomorrow.Using Desktop 2022.2.6 and Server 2022.2.6Cheers.Ps!It would have been nice to have had a checkbox "Rea

Hello,I am using the String Concatenator to join two fields and separate them with a comma.However some fields are blank so I end up with some records that contain a comma only and others that contain a comma and then the value of one of the fields.My current setup looks like belowgenerally works well, except for some results like theseIs it possible to modify existing Transformer or is a different one more suitable?My only other thought is to perform some sort of trim on an other transformer after this one to remove first character?Thank you

Hi, I would like to have attribute values in one of the attribute tables in Shape file.Attribute value should be as shown below. How do I get the 

I have the following scenario.We use FME Form to gather public data. The data gathered should be written into a MSSQL database. Since we mainly work with ArcGIS Pro, and other ESRI products our MSSQL  server has an SDE extension on it.As long as I work in Form I can easily use sde connection files to access the databases. However, publishing a workspace utilizing an sde connection will result in errors since we do not have an ArcGIS Pro running on the same machine as our FME Server.Until now I was using the reader and writer ‘ESRI ArcGIS Portal Feature Service’ but this isslow, and requires published feature services in the ArcGIS Enterprise portal.I got our IT to open the firewall for direct access of FME Server to the MSSQL server and installed the latest msoledb drivers after getting the following error:Microsoft SQL Server Spatial Reader: Failed to connect using Microsoft OLE DB Driver for SQL Server. Provide

I have a dozen files in a folder. I was able to use the Path Names Reader to write the File Name, Upload Date, Upload Time, and File Size to the CSV Writer.  Does anyone know how, or if it is even possible, to get the name of the user who copied/uploaded a file into a folder? I see in the Pathname Reader the path_ownername attribute, but all this has in it is the value “Administrators”, no user name. 

Hi there, I wonder anyone can help me to resolve the issue I am having with FME 2023.2.1 installation on Windows 2012 R 2 Server. I have the following error opening FME.

I have a workspace that writes to a simple Excel sheet. The sheet has 3 columns: Report Name, Upload Date, and Upload Time.In Excel you can set a Filter for each column allowing a user to filter the data in that column. In Excel, I added a Filter to each column, but when I write to the sheet in FME Form, the Filters disappear. Is there a way to “keep” or “add” a Filter to each column in the sheet by tweaking a Writer parameter or is there another Transformer I need to add before the Writer? The screen capture below shows what I would like the sheet to look like:  

I have a list of lab test results and only want to include the rows that match a list of analytes. I am trying to use the IN operator in the tester transformer.I have followed the advice from this post:Help with syntax when using Tester transformer | Community (safe.com)This is what I have:Sheet1 contains the test results, text_line_data contains the list of analytes as one feature. I have merged them to get this: The “text_line_data” column looks like this:

Hi All,  I have a table with a 'route_ID' and a measure value (like a event table). On the other hand I have a polyline feature classe.  The attribute 'Name' correspond to route_ID from the table. The measure values are points on the lines. Now the measure values changed by a predetermined value (e.g. the point was 10 m and now the point is 10.5m). My Problem, the Polyline feature class is not defined as route form a linear referencing system. And so the table and the Polylines have no relations. I don't no where (which coordinate) my old and new points are.  Can I build a route feature class with FME? The Basisc should be my polyline Feature Class. I would have assumed a route feature class, how can I creat points (with coordinates) form the table?  Thanks for your help.  Debby

My work colleague is trying and failing to connect to Oracle Spatial.I suspect that her installation of FME is slightly broken and she lacks the access rights to the folder where FME connections are stored.When she goes to Tools | FME Options | Database Connections FME pops up an error message "Unable to retrieve database connections"And she is also unable to create a new database connection.If I knew the folder location, we could check if she has the proper access rights assigned by IT.Thanks,Nick

 I have a workbench build in version 2022 using active choice to enable and disable parameters based on other parameter values. This option stopped working in the new 2023 version.Does anyone know if the active choice is discontinued?Thanks

Clustering Points With K-Means in FMEThis article has been generated using FME 2017.1For a project to assess the quality of suppliers, five suppliers were approached to perform comparisons on aerial imagery. They were asked to select areas from aerial photographs where potentially dangerous situations might arise as a result of human activity. After the first delivery of reports from the suppliers within a test area, one of the obstacles for the project appeared to be the identification of clusters of reports. A cluster of such reports represent an area where a potentially dangerous situation has come about. A criterion for selecting the best supplier to detect the situations from the imagery, could be as follows: the best supplier is the one that “touches” the maximum number of clusters with the reports generated, with as few notifications as possible. Because FME played an important role in this project, but no transformer seemed available within FME, a stud

Hi, I have a gdb with pleanty feature classes with unique schema and I use SchemaScanner and Dynamic gdb to save the layers. Feature layers saved in the gdb have correct schema but the order of the columns is wrong, it looks like the new feature layers have the columns ordered alfabeticaly  

I am having issues with glacial speeds of using a delete from statement within a SQLExecutor pointed to Oracle Database. The SQL query is something like:DELETE FROM ABCWHERE ID = @value(id)AND TO_CHAR(DATETIME,’YYYYMMDDHH24’) > @value(timefrom)AND TO_CHAR(DATETIME,’YYYYMMDDHH24’) <= @value(timeto) (note: The query above is paraphrased and might contain syntax-errors, I have checked and confirmed the syntax in the actual version) The Oracle Table contains about 40 million rows, so I expect this to take some time (1-5 minutes per query) but not the >30 minutes for the first query (at which point I gave up, I have not confirmed if the query will ever finish) Currently I am using a workaround of Loading the primary keys of all features that fit the selection criteria and using a writer to DELETE all corresponding records, but this seems unnecessarily inefficient and wast

I have XML file with features I'm trying to read.. that works. Next step is to create a polygon for each feature, I have a string with points that make the polygon. String looks like this:  173363.252 587903.412 173363.369 587902.665 173362.055 587900.798 173363.867 587888.745 173364.007 587887.815 173371.744 587888.843 173368.618 587904.7 173363.252 587903.412 That's a list of x and y coordinates, now I can't figure out a idea to make polygons from it. Any ideas? Do I have to seperate them, create lines and make a polygon from it? Any help is appreciated.   

This is how the initial output from my ftpcaller looks like ( calling a csv to attribute)and this is how it looks like when i sort it by file contents.Any transformer that i use after calling the data uses the first screenshot, thereby inhibiting me from automating any process.I have to download to file, open and save it and then re add it to a second script to manipulate it and push it to AGOL ( which is my end goal)