FME Form

HiI have some rows that need to be appended to a database table and some rows which need to be deleted then replacedI am using a feature writer and  can delete rows by setting the feature operation to Delete and the in Row Selection, the Columns (Im sure it used to be called math columns) is just set to the primary key of the table. That way it appears to delete all the rows. I presume this is correct.I then want to append the revised values to the table. How do I add another feature writer to do this?I presume the alternative (better method?) is to use update. If I wanted to update every field, would I just set Columns in Row Selection just to the primary key and the all other columns would update? Would this still work if some of attributes are null?Many thanks    

How should we use existing database connections inside of an FME Package?Will the python api have functions which will enable the use of these connections? I was working on something where I wanted to connect to a database and I realised that it’s not possible to use the existing database connection - this is probably a good thing but kind of killed my project. Then it got me wondering if this will/should ever be a possibility? seems like exposing that kind of access to third parties poses a pretty big security risk. You could pretty well hide some malicious code which just scrapes all the host, username and password data and post it to some server. I guess direct database access via a package might never be allowed - at least not until there is the same kind of security which Oauth offers for authentication. 

Hello, Is the result of the function @uuid() the same as the transformer UniqueIdentifierGenerator ?I would like to create directly an UUID in an attribute creator instead of using 2 transformers (UniqueIdentifierGenerator and AttributeCreator). Thanks.  

I am trying to pass custom Python Interpreter and Python Home to a batch script. The batch script then triggers a FME workbench script. Here’s the commands I am using in the batch script: set NEW_TIME=%TIME: =0%set LOG_DATE=%DATE:~4,2%_%DATE:~7,2%_%DATE:~10,4%_%NEW_TIME:~0,2%_%NEW_TIME:~3,2%SET path=<path to log directory>SET filename=%path%batch_log%LOG_DATE%.txtecho ************* Started FME Update ********** > %filename%echo.>> %filename%echo.>> %filename%echo Time Stamp: %DATE% %TIME% >> %filename%:: activating clone python env which contains all the dependencies for the PythonCaller referenced in the Workbench scriptcall "C:\Program Files\ArcGIS\Pro\bin\Python\Scripts\activate.bat" arcgispro-py3-clone >> %filename%:: Use custom Python set to true"C:\Program Files\FME\fme.exe" APPLY_SETTINGS SYSTEM "Python/Use Custom Pyth

Hi all, I have a layer with multiple polygons sharing a specific attribute (Area_ID), and they are spread with no geometry among them. Multipart polygons sharing same attribute value.Then, I would like to know the way to identify the area that could be filled considering the vertex points that can make up a border.Area between multipart polygons that need to be filled.Finally, the need is to merge all of the multipart polygons into one, without moving those multipart from the coordinates they are now, just filling the space between the polygons with the same attribute in common.

I have a feature class in a file geodatabase that I need to write to a hosted feature service that has different schema. Is there a way extract the values, modify them to match the other schema values, and update the feature service?

I would like to create an Excel list from our GetCapabilities document, where all our wms services are listed.Some of our services are grouped together and I don't want to list these group layers, just the lowest level of layers.The list should include name, title, abstract and metadata link (xlink:href).I have searched the community for examples, and although there are many questions about XML, I have not been able to apply these solutions to my problem and thus create a list.I probably have to use the XQueryExtractor to find the desired layer elements, but I am not able to insert the XQuery expression (Layer[child::CRS]).URL: https://map.geo.sz.ch/mapserv_proxy?SERVICE=WMS&REQUEST=GetCapabilities&lang=deAny help will be appreciated!Thanks in advanceVera

I am using FME in ArcGIS Pro and would like to know if there is a way to set QUOTED_IDENTIFIERS_IGNORE_CASE to TRUE in the Snowflake session before copying/creating a table. Otherwise, the table is created with quotation marks around the table and column names, then ArcGIS Pro cannot recognize the table.Thanks

Hi,we connected from FME Desktop 2022.2.5 successfully to a Azure Synapse SQL Pool using the "Microsoft Azure SQL Database (JDBC)" connection. I can use the Reader without any problems and query data from the tables. However I need to use SQLExecutor Transformer as the queries need to be dynamically created. But this gives me the following error:com.microsoft.sqlserver.jdbc.SQLServerException:  '@@TRANCOUNT' is not supported.Seems like the SQLExecutor performs additional statements in the background which are not supported by Synapse. Are there any workarounds to avoid this issue or to force SQLExecutor not to use additional statements?Thx for your help! 

Cache problem?At writing a dbf-file happens errror "DBASE writer: 'unknown' is not recognized as a valid encoding name". FME(R) 2023.2.0.0 (20231201 - Build 23764 - WIN64) Error happens since today Feature Caching set off Result files: .cpg, .dbf, ‘.dbt’ Each process creates 51 files of altogether 283 --> maybe a caching problem? Same error happens also with DBASE writer -> character encoding 'utf-8'Reader file:xlsx-file (MS Office 2016)Writer dBase (DBF) with character encoding Latin-1 Western European (iso8859-1)Parameter tab --> Name-table "JPB_NR" (format: number(3,0) all together 283 lines of dataDBASE writer:Writing files using character encoding 'iso-8859-1' OS Locale Encoding : windows-1252 Process Encoding   : UTF-8Test files are in attachments.Can anybody help?Regards,

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.