Authoring

I know the issue of dynamically exposing attributes in a feature reader from the Generic port comes up often, but I thought I would ask anyway. I have two issues with the FeatureReader regarding scripted parameters. Firstly, I have a text file which contains a list of feature classes to read. As feature classes are added to the database, the name will be added to the text file. I have a Python Scripted Parameter which is called "FeatureTypes" with the following code:f = open(r"D:\Scripts\DEV\List of Feature Classes.txt", 'r')featureTypes = ''for line in f.read().split('\n'):    featureTypes += (line + " ")f.closereturn featureTypesThis returns a nice list of all feature classes to read. In my FeatureReader, I set the Feature Types to Read paramter, to this $(FeatureTypes) parameter. However, when the database tries to read it, it's reading the literal string "$(FeatureTypes)" instead of the list. I got around this by using a ParameterFetcher and storing the list of feature classes into

I'm working on a script that I downloaded from the server and want to run this on the desktop version.It requires a couple parameter changes to make that working, but it's quite a hassle to do that properly whenever switching between desktop and server.For instances changing the featureReader file path from $(FME_SHAREDRESOURCE_TEMP)/$(FME_MF_NAME)/foo.json to ~/documents/FME/foo.jsonI noticed that I can set FME server parameters on the desktop, which are currently all empty.Can I for example set $(FME_SHAREDRESOURCE_TEMP) = ~/documents and $(FME_MF_NAME) = FME so it works on the desktop and server without the need to change these parameters whenever I switch between server and desktop?

There appears to be a change in message recorded in _reader_error that gets added to data coming out of the rejected port of either the SQLExecutor or SQLCreator when connecting to an Oracle DB. Previously (in 2019.2) a failed connection to the database resulted in a single error in the translation log and the following sort of text in the _reader_error attributeError connecting to Oracle database: message was `ORA-12514: TNS:listener does not currently know of service requested in connect descriptor'....orError connecting to Oracle database: message was `ORA-01017: invalid username/password; logon denied'.  orAn error occurred while accessing a table result for feature type `'; message was `Execution of statement In 2021.2, I now get two errors in the log. One which contains the useful information above and a second that seems to always readError connecting to Oracle database: message was `%5'. (serverType=`%0', serverName=`%1', userName=`%2', password=`***', dbname=`%4')It's this sec

Hi all,I need to connect to a linked server in my SQL Server. Is there a method of connecting to a Server Object using FME?Alternatively I have a query that collects my data but running it through the SQLCreator doesn't produce any attribution (presumably because FME doesn't natively connect to the data).ThanksNeil

Is there a simple way to rename a attribute name so a user defined field name set in a customer transformer parameter?

I use FME 2022.1.0 - if i use a Shape-File with x Points + Attribute: Radius then add an Bufferer Transformer + the right settings for Circles. I get an INVALID_PARAMETER_BUFFER_AMOUNT Error In 2021.2 FME 32bit it is working flawless. Is this fixed in FME 2022.1.1 ? Greez Michael

Hello We just updated FME from 2020.0 to 2022.1. I wanted to use a workspace with a file copy writer in it. It still works and copies files. I wanted to change something, but in the file copy writer- dialog there's one tab missing and I cannot fill in anything.That's how it looked in FME 2020.0That's how it looks now in FME 2022.1Is this a bug or how can I change the parameters? Thanks in advanceVera

"Feature Tables" - the buzz word heard around the 2017 FME UC, is now referred to by a more intuitive term "Bulk Mode"... The CSV format has been updated for amazing performance increases, but for what transformers and formats can I expect to see benefits from Bulk Mode? 

FME Desktop Version: 2022.1OS: Windows 10 Pro TempPathnameCreator is not creating the full path in file system, omitting the last part of the _pathname attribute value. Note: Basename and Extension property input values were left empty.  At run-time, _pathname returned a path C:/Users/<username>/AppData/Local/Temp/wbrun_1663507413323_13720/fmetmp_0/1663508664728_25800_d\\tor690. However, only C:/Users/<username>/AppData/Local/Temp/wbrun_1663507413323_13720/fmetmp_0/1663508664728_25800_d\\ directory was found created, not found the sub-folder tor690 inside. One more observation is, although it's Windows OS, _pathname attribute value was following the unix path pattern (forward-slash), except the last part (it was backward-slash).

FME 2022.1 64-bit Personal Geodb Reader - Reading feature type as case-sensitive. Where as 32-bit Personal Geodb Reader in earlier versions used to read feature type name as case-insensitive. Is there a way to make FME 2022.1 64-bit Personal Geodb Reader to read feature type as case-insensitive? 

How to split a delimited string with a carriage return to create a stacked list. Example:Input = A:1-100+B:1-300+C:1-600Output = A:1-100 B:1-300 C:1-600 The output will be stored in a multiline attribute in AutoCAD 2017.

Is FME 2022.1.x still supporting custom formats? Can someone share the documentation to create and consuming a custom format in FME 2022.1.x. Custom format that I have created in FME 2022.1, published user parameters not getting exposed. Means, published user parameters of the custom format are not available to set in the consuming (as Workspace Resources) workspace.

I am using Data Interoperability (Build 21302) from Pro 2.8.4 to frequently refresh tables in an ArcGIS Enterprise Geodatabase. The tables are registered and published to Portal. The client is using the data in web maps, apps and dashboards in ArcGIS Enterprise Portal and require specific web layers to have little or preferably no time where it's empty of data.  Instead of using the Truncate and Append to Existing table in the ArcSDE Writer I am using the ChangeDetector to set all new features coming in as both "Inserted" (containing the latest data / timestamp) and "Deleted" (data from 5mins ago) then in the writer match by Unique ID. From testing this enables a "seemless" refresh with minimal time of the table appearing empty in Portal.  Is this method at all stupid or precarious? If so, what is a better solution. Additionally is it risky to read in and write to the same table in the same workspace? Background Notes:One frequently refreshed table can

Hi All, I have script written in Py3 in ArcGIS Pro 2.8, it uses pyodbc lib to connect to Non GIS SQL Server database. ArcGIS pro needs to be a cloned env.  I want to schedule this script as FME workspace (Ver 2021.2) using Python caller to run the script. The issue that I am having is that it’s not able to find the Cloned environment and not able to reach pyodbc library. I have implemented all the suggestions from this Safe Community Article.   https://community.safe.com/s/article/choosing-a-different-python-interpreter-installati#SettingACustomInterpreterForDesktop I am looking for some feedback on hoe to have FME Desktop point to the clone env. It points to the following path:  C:\\Users\\testUser\\AppData\\Local\\ESRI\\conda\\envs\\arcgispro-py3 I need to update so that it points to the following path: C:\\Users\\testUser\\AppData\\Local\\ESRI\\conda\\envs\\arcgispro-py3-clone The error that I am getting is: Python Exception <ModuleNotFoundError>: No module named 'pyodbc&#

I'm working on a workflow to convert a DWG file to KML file. I noticed that DWG files may contain Autodesk (ACAD) and/or Civil3D type features, so I added both Readers to my workspace to handle both. Features coming from the Civil3D Reader do not convert to KML well. See attached screenshots. I want to replicate how the Civil3D 2 KML looks. This was performed using the Civil3D Export To KML tool. The FME conversion looks very different. I tried toggling the Explode Blocks To Entities in the Civil3D Entities setting, but it didn't seem to make a difference.  Overall, I want my FME conversion tool to produce a KML that looks just like the drawing does in Civil3D. I'm looking into ways to Explode or Drop the drawing so that it breaks down to simple linework if that makes sense. Does anyone have any suggestions?

Has safe adopted the standard for related tables in geopackage (writing/reading)?If so, how do I go about it?

Environment - Ubuntu 16.04 LTS Docker Host, running FME Server 2018.1.1-20190122 images I am receiving an error - There was an error submitting the job - when trying to run a workspace within FME Sever. Digging through the FME Server logs I find the following error within the Resources > Logs > tomcat > fmeserverweb > localhost current log.07-Mar-2019 09:05:10.300 SEVERE [http-nio-8080-exec-1] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [JobRunnerForm] in context with path [/fmeserver] threw exception java.net.ConnectException: Connection refused (Connection refused)    at java.net.PlainSocketImpl.socketConnect(Native Method)    at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)    at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)    at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:3

I really try to keep things nice and organized, but apparently all it takes is opening one bookmark and all heck breaks loose!!! This happens all the time and it's really straining my relationship with FME. I was working on another part of the workspace before noticing the chaos. I can't just hit undo. If anybody has any tips, it would be much appreciated. With Dynamo, I don't have this problem. Devs, are you listening?

When writing to a csv file with the following settingsIf writing a value such as 18" pipe the field is written to the csv file as18" pipeThis is different behaviour to the 2015 writer where this would be represented as"18"" pipe"It looks like the 2019 writer doesn't consider the presence of a single quote character to warrant the field value to be quoted (although i would consider it to be an unsafe character)Is this expected? 

Following some helpful advice from Shannon in the FME Customer Success team, in place of a jobs board on the FME site I was advised to post a current position we are recruiting for here. We are looking for a seasoned FME Professional with Desktop and Cloud skills to support a team of geoscientists and help mentor 5 or so other FME users within the office. The role within Landmark Halliburton is to continue to develop our suite of geoscience products which include a range of 2D and 3D continental and global scale geological representations of the Earth - see Exploration Insights for more information.Within the role you will be working on further innovations to the product range and helping to shape the direction of product delivery. If you have OL3 and GeoServer experience as well that would be a fantastic bonus.If you are interested please apply through:this linkThe role is permanent and based in the Oxford office in the UK, the salary range will be between £50 - 70k depending on exper

Error message with filename wb-xlate-...

Hi Community, does anybody know a way to force FeatureWriter to wait for completion of a writing task of a feature type before the next writing is triggered? I'm trying to delete features on a database (Oracle Non Spatial) with constraints on the affected tables. So I must enforce a specific delete order. Currently I use a rather complex mechanism with mutiple FeatureWriter transformers in chain and would like to tie them down into one FetureWriter.  If a FeatureWriter could be configured in that way it would also be great to do the action within a single transaction. Is this possible too?

We have an automation that runs and outputs a report result as a HMTL page using the data streaming service. Our testing did not have any issues, but in our production system, it appears if the job is queued, the web client times out, although eventually the job completes on server. If there are not jobs in the queue, or the job is a quick job it completes without error. Does anyone have any ideas on why this is occurring?FME server 2019 with 3 engines.

I want to simply add a folder with 3 subfolders to an S3 bucket. I'm using the S3Connector transformer and it seems you need a file to Upload to an S3 folder to create a folder, whereas, it seems to me that you can't only add a folder w/o having a file to upload it. I tried adding a csv file to each subfolder to setup my folder structure in S3 and that works to get the main folder w/ 3 subfolders each containing an empty csv file. I then added 3 more S3Connector transformers w/ the Delete option to remove the csv files from each subfolder thinking then I would have the desired folder setup without any files in them. This doesn't work because when you delete the only csv file from the subfolder, it also removes subfolder leaving nothing left in S3. Is there a way to create the desired s3 folder structure without adding a file? Or is it possible to delete the file from the subfolder without removing the subfolder?

What is the FME syntax required to assign a <null> value? Inputting <null> seems to return the string '<null>' and not a bonefide <null> (greyed out FME version). Some fields offer <null> in the drop down, but some do not and require the user to input, such as...Thank you.TylerFME WorkBench 2021.0