FME Form

I recently posted a question on the r/fme subreddit but am reposting here to see if I have better luck. I’m including the reddit post for context in the Original Post Contents section below.Since creating the post, I ended up joining the attributes I needed from the JSON to my transformation table but at the cost of decreased performance, see the Update to Original Post section below. Original Post ContentsDoes anyone know if there's a way to easily load attributes from a simple JSON file to be used as Parameters in an FME workspace (Workbench 2022.2)?I want to be able to alter the values in the JSON file and have the changes reflected in the FME Parameters, instead of having to manually set each parameter in FME by hand when I want to make a change.Here's a portion of the JSON file I'm using. I've tried using the JSONFeature Reader in combination with VariableSetter/VariableReader and MultiVariableSetter/MultiVariableReader to some degree of success. However, it's far from perfect, be

i have a problem to find the driver for FME data Inspector 2023.1i have install the ODBC drivers 

Hi, when I create a new feature class in an ArcSDE Geodatabase (Oracle) the field “SE_ANNO_CAD_DATA” gets created automatically. Is it possible to disable this field in the writer? I did not find anything in the documentation about this. 

Hi - I’m wondering if anyone has tried to read a filegeodb straight from s3 with a featurereader.  The S3 connector documentation implies this might be possible - but I could not get it to work.  I had to have the gdb directory local on my machine for it to work.  Has anyone else run into this?  It would be cool if it did work, since I don’t like having these file geodbs local.  I can work around it if not.  

When using the SQLITE3 Reader, unchecked attributes from the User Attributes tab are not exposed downstream to any transformer like AttributeManager, -Remover, -Keeper. This behavior is as expected.However when using the FeatureType downstream on the Requestor side of a FetureMerger and the conflict resolution is set to ‘Use Requestor’ , the unchecked attribute is still active behind the scene and take precedence over the attribute of the same name coming from the Supplier.It turned out that I need to keep the unwanted attribute ‘checked’ and remove it actively with an AttributeRemover to avoid the unexpected usage in the FeatureMerger.I also tried to force it by changing the workspace option Reader/Writer Options > Allow Reader Feature Type Editing, but it made no difference.Question: is this a bug or dangerously intended? Setup: FME Forms 2023.2 for win 64

HI, I have a gdb with a lot of feature classes and I need FME to search thoroug the content of each layer and give me the list of all attributes from each layer that meets certain tester requirements. I was thinking of usint Attribute Validator but the content of the gdb will be changing hence adding attributes manually to each tester is going to be very time consuming. I need FME to search thorouhg the content of each layer saved in the gdb and give me the attributes 

Hello, I have received a GEOJSON file from a data supplier, which I would like to convert into a shapefile. Unfortunately, I am not able to extract the geometries with their corresponding attributes from this file. If I use the standard reader for JSON files, I can look at all attributes in the Inspector, but I have no geometries, only an object (?). If I integrate a ListExploder after the reader, I at least have all the objects that are integrated in the file, but I only ever see the first point of the object.My question now is how I can extract both the geometries and the corresponding attributes from the file and save them in a ShapeFile or similar?I attached a small sample. Thanks a lot

I have a workspace that uploads zipped folder to a Dropbox folder. I have established the Dropbox web connection, token is also retrieved and authenticated. When I run - I get translation is successful with no errors. But I dont see the folder on my Dropbox account. What am I missing ? Any suggestion is highly appreciated. Thank you so much

Hi,I am converting a Civil 3D DWG file to GDB. However, once I read the DWG file, the colors appear to be changed to black and white. I attempted to use DWGStyler, but the colors are still not reverting to their original state. I've checked the Reader Parameters to ensure that "Resolve Entity Color" is selected. Could someone please assist me?1 more thing that I found is that, once I use autocad_color or fme_color in DWGStyler the values disappear.  Thanks in advance

Hi,  I am attempting to ingest Microsoft Project Online data into our on-prem MMSQL Warehouse. I have found that the only (?) way to get the api is via SharePoint: https://<xyz>.sharepoint.com/sites/ProjectWebAppTestSite/_api/ProjectData The URL Above lists endpoints for all the sub-components ie: https://<xyz>.sharepoint.com/sites/ProjectWebAppTestSite/_api/ProjectData/[en-US]/Projects I am after recommendations for "simple" one-to-one replication of this data structure in SQL via FME.  The SharpointOnline component allows access to the document as an HTML file which I would have to manually parse and furthermore the site (via FME) only lists 5 Items in a document library wheras the main api endpoint via the web browser lists > 20 endpoints for data objects.The OData connector doesnt seem to work as I believe the feeds are ATOM.The HTML connector fails to authenticate as we use MFA and even if it did, this would most likely be a nightmare to parse.The PowerBI

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 Python" true >> %filename%:: Use custom Python Interpreter. Directory: "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro

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.Any thouhts? Thanks a lot!

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,Steffen P.

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?