Creating and organizing workspaces. How to use Workbench.
Recently active
How can I pass a published parameter in a workspace into a custom transformer within the same workspace? I think you can pass a publishedParameter into an attribute and then make this attribute available in the custom transformer, just wondered if there was a simple cleaner way?
Hi,I'm trying to extract XML from the attached file. I'm using an XMLFormatter before hand which extracts the loggerId I need to match to a database table.I can extract the XML using the fragmenter, but unless I use the 'Merge Attributes from Input Feature' the loggerID is not carried through. If I do this. FME managed to burn through 700GB of my hard drive and then fails due to lack of memory.Any idea how I can carry through my original XML attributes through to the fragments without having to do this?
Greetings,Is there a setting to set the date value out of the DateTimeStamper to say ISO?Thank you,TylerFME 2022.1
Greetings, Do you have a best practice for adding a 'status' attribute populated with the value of the join status such as 'joined', 'unjoined_left', 'unjoined_right'? I can imagine using a 'create attribute' transformer outside of each join transformer port, but that seems heavy on transformers (four total). Let me know if you have a more efficient solution. Thank you, TylerWorkbench 2022.1
Hi, I have a large point dataset and line dataset in ArcGIS. For each point A, I need to 1) create point B on the line which is nearest to the point A. Ensure point is snapped to line2) Generate a line between points A and B I have tried using NeighborFinder, with the line set as the base. However this doesn't create an additional point dataset on the line. Any suggestions
Hello, I have the following date string(s):...which I need to convert to datetime objects. They appear to be 'iso datetime with offset', however I continually get invalid format with auto detect or manual choosing format. I have tinkered with several other input formats to no avial. Any ideas? Thank you, TylerFME Workbench 2022.1
Hi Folks, I'm setting up a HTML web connection to an API using OAuth2, and one of the parameters that I must specify is grant_type=client_credentials. However, in the 'Retrieve Token Parameters' dialog in the preview window, I see that grant_type=authorization_code. Is there any way to change this? If I enter it in the URL section, will it overwrite (even if it doesn't show the change in the preview)? Thanks!Tyson
I recently upgraded my FME Server (to 2020.2.4) and the unwanted file hierarchy for FileCopy output datasets in Data Download Zip files have returned! I now have an additional folder (called FILECOPY_1) in the output zip from a Data Download Service on Server. I've updated the Writers in Desktop (2020.2.4), but the edit functionality (Publish --> Edit Register Services --> More) seems to do nothing for the structure of the zip file for FileCopy outputs anymore after publishing (the old way is outlined here: https://community.safe.com/s/question/0D54Q000080hM9QSAU/how-can-i-change-the-folder-structure-returned-in-the-zip-file-from-fme-servers-data-download-service). I this a known bug, and is there a fix please? Many thanks!
I have put all of my parameters into the Private panel in the Parameters Manager, but they still display in FME Server 2021.1 unless I uncheck Published. What is the value of having to do both?
I currently have multiple processes set up where predefined FGDBs can be loaded into Oracle using FME (server). I need to extend this so I can load ANY FGDB and I am struggling to find a way to do this dynamically. Ideally I would split out a uniqueID and Geom to load direct into Oracle and split out the tabular data into a CSV as I have a dynamic process set up for non-spatial data already. This way I can easily join the spatial and non-spatial programmatically in Oracle. Thanks
Have a process that takes a csv, adds a few attributes, and writes to Socrata. I just updated the package to use the newest Socrata Writer, thinking the old writer was the problem. When I run it I get the error "Socrata Writer: HTTP 400 (None): Revision is of type 'update', but applying it would result in schema changes." If I make the process output a csv, I can manually upload it to socrata without any issues/errors/warnings. Same exact data. I downloaded the full existing dataset, made a new workspace that just takes the downloaded data and uses the socrata writer to replace the cloud asset. Runs no problem. I thought that would fix any schema issues since it was a replace. But I get the same problem from the main process. I have made sure all headers match, etc but am stumped on the error. The asset has historical data that I don't want to lose every time the process runs. This is really an upsert/append operation. Thanks
Hi All, I have been asked to create a digital sign in/out form for when contractors visit our workplace to carry out contracted works. Currently when a contractor arrives we ask them to fill in a paper based book, just capturing name, phone number, time in and internal contact person. Then when the job is complete (or at the end of each day) they must sign out with a simple signature and time out. This allows us to keep track of who might still be in the building before we lock up at the end of each day. I can create a simple workspace that caters for capturing this information, but I am more asking for advice around best practice for setting it up in workspace and then in the FME Server. For example, should I create one form, with a question for 'Sign in/out', or should I create two forms, for the two tasks? I might be over complicating it, but basically this is the request I have received:
how to generate a value off a partial level name
I have a child workspace accepting a where clause parameter:loggingUnit = 'LK107I' This works just fine standalone. But when I call the same workspace with a parent workspacerunnerusing an identical where clause my SQL Creator fails with rejected features. I can see in the logfile the parameter passed in is identical also?
Using an old version - 2019.1.3.1 with ArcGIS 2.7 compatability. In my script I have where: import fmeimport fmeobjects if __name__ == "__main__": # Script parameters inputLayer = feature.get.Attribute('inputLayer') outputLocation = feature.getAttribute('outputLocation') outputName = feature.getAttribute('outputName')
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?