General

Hello everyone, I've recently been doing some work using HTTPCallers to connect and authenticate to an API. The basic flow is that the first HTTPCaller hits the login endpoint. The credentials (username & password) are passed as application/x-www-form-urlencoded values. An XML response is sent which contains a Session ID. This is then passed through to all subsequent HTTPCallers via the header as Cookie - ASessionID=<Our session ID>. This all works very well, but I've been asked if I could move the whole authentication part into a nice secure easy to use Web Connection. I've done similar before, so thought this would be a fairly easy task, but alas, I've hit a bit of a wall when it comes to the Access Token Response. Unfortunately, the login call to this particular API only returns XML and will not return a lovely JSON response for FME to parse and handle. I was under the impression that FME should be able to look at a JSON or an X

My goal is to read a directory of SDE connection files and then list out the database name and all the feature class names, tables, geometry types, etc. associated with each connection file. I've reviewed the articles below and can't figure out how to set the Feature Types to Read parameter since it only shows tables/feature classes from the one Reader as a Resource SDE connection. This isn't an issue if there is only one database but when there are multiple (like what I'm trying to do), it doesn't seem to work. Is this possible or is there another way to get this info? Here are the articles I've been using:https://community.safe.com/s/article/how-to-read-all-feature-classes-from-multiple-esri 

If i run this command in the command prompt (OS) it takes about 15 seconds.M:\\Survey\\'COGO DATA>DIR /S *.DWGIf I run the Directory and File Pathnames Reader with essentially the same parameters it takes 5 hrs! Why can't fme do this any faster?

Hello, I have a REVIT file which contains some cylindrical objects (e.g. pipes) and when I convert the model to cesium, it creates hexagonal shaped pipes instead of cylindrical ones. Is this intentional or can I bypass this behaviour somehow? NOTE: The Revit model is offset according to it's Reference Point. Also, the Data Inspector shows the cylinders correctly where it is an aggregate geometry with with many many IFMEFaces. 

Hi Team, I'm doing the training for FME Professional, using FME Desktop 2022.2 and am now at https://safe.my.trailhead.com/content/safe/modules/turn-coordinates-into-geometry/exercise-turn-coordinates-into-geometry-using-the-vertexcreator-transformer . The last question on this page is about VertexCreator making a line instead of a point geometry. The question gives the impression that creating a line using this transformer is "a feature" from that transformer (and values the answer given accordingly), while the page https://community.safe.com/s/article/Known-Issue-VertexCreator-creates-lines-instead-of-points clearly shows that this is a glitch th

I'm running a workbench on FME Server 2017 and after running through some transformers, the data should be writteninto a database. I'm getting an error ans this message: An error occurred while flushing the cursor for the table/feature class 'xxx.yyy.zzz'. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error [[Microsoft][SQL Server Native Client 11.0][SQL Server]Arithmetic overflow error converting float to data type numeric.] [xxx.yyy.zzz]} Am I right to assume that the error is possibly invoked by an incompatible value? How can I find out which value is causing the error? Is there a possibility to retrieve more information to start the search for the cause of this error?

I have several types of rasters in my folders (ecw, png, tiff..). Not all folders i want to process contain all of the types. In my workspace i created one reader for each type, but when one type is not available, i can not launch the workspace. How can i make a reader optional so it will accept no input data?

This week I looked at this question on the community. "I have a 100 ft line that curves and then turns back into a straight line. How can I use FME to only gather the straight line after the curve only. I basically want to cut out the curve and only grab the line after the curve." This isn't too difficult, but what's interesting is the contrast with last week's question. Last week (click the link to check it out) I too

AttributeManager_10 (AttrSetFactory): Bulk features are not supported because of the setting for 'If Input Attribute is Missing'. Changing this to 'Remove Output Attribute' may improve performanceI see no such setting in attributemanager_10. Where is this setting? Form or Flow I get the same message in both.I do have an sqlexxecutor directly in front of the attributemanager but do not see this exact setting in it. 

Basically here is the need: right now workbenches run (Using FME Desktop 2020.2 and Task Scheduler) and the email addresses are typed out within the Emailer Addressing "To" parameter.We would like things to be more easily updated. For example, if someone is no longer on the team, or if someone is new on the team, we would like to simply update a text file and ALL of our jobs will be updated. I tried reading the text file in, aggregating the addresses into one long string separated with a comma, but I wasn't sure how to assign the value to a User Parameter.(I tried a couple things and failed) Thanks in advance for your help.@danminneyatsaf​ 

Dear FME friends,Welcome to What's Up Wednesday. For reasons of space, this is an extract from the full version of this newsletter, which you can find here on LinkedIn. Streaming to a DatabaseThis week I saw a question about writing an incoming stream of data to a database: "I have a workspace that runs continually in streaming mode (receives from a connector). I want to write to a Spatialite DB while the workspace is still running. I've tried a FeatureWriter, but nothing is written out while the workspace is running. Is this normal behaviour for Workbench?" So there is a great article on the knowledge base about

Hi,FME Server 2022.2.1 Express install.Connecting out via proxy (not authenticated).https is not enabled on tomcat I've published an OAuth2 connection to the FME Server and am trying to Authorize it. Proxy is configured in the FME settings. Client ID and Secret is all set up correctly, including the redirect URI as I can get to the OAuth sign-in page for the app. However when supplying my credentials the token/code is being sent to http://<server><port>/fmeoauth but it just returns an error page "FME OAuth Service FAILED" "Failed to complete". I've also tried to use the ip address of the proxy to no avail. I'm guessing it is a tomcat redirecting issue but can't see any previous info related to modifying the server.xml or OAuth config file in the install folder.

Hello people. I am having an issue that i cannot resolve. I am using the FME for 2 months now. Basically i have a workspace that performs pointOnRaster value extraction, does some calculations based on the result and writes to table/excel file/csv or whatever. Because i want to run this process over 10 000 files i created a workspace runner that loops trough a folder of *.nc files and compares them to one single shapefile containing the points. Regardless of the output format or the different approaches i've tried i am not getting the whole batch of results written in the output. For example i ran the workflow over the first 326 files and the WorkspaceRunner gives me 326 successfully processed entries. But the output file contains only 87 entries. If i run that workspace again it gives me between 67 to 90 entries but nothing close to 326. The log file doesn't indicate any kind of a problem. I've tried to do that with vector files as well, but still i am having the same i

I have a workspace which takes point features and assigns them models essentially this workflow: https://community.safe.com/s/article/creating-and-using-geometry-instances But I'm finding that the performance is quite bad. Is there anything I need to be aware of when using this kind of workflow? The idea of using a geometry definition was supposed to speed things up - heh.  I know with raster datasets there is some little tricks that FME does in the background to speed things up by not reading bits until it needs to. Perhaps there are some transformers I should avoid?

Happy new year, FMEers.Our question-of-the-week was posted just a few hours before I started to review the week. It's about parallel processing and the ShortestPathFinder transformer. Question of the WeekQ) I was hoping to speed up my ShortestPathFinder calculations with "Parallel Processing", but I don't notice any speed improvements. The 2018.1 documentation says "If it is enabled, a process will be launched for each group specified by the Group By parameter." However, the most recent documentation does not mention parallel processing at all. Am I missing something? Asked here by @magnus A) Yes, there are a number of points. The first is what happened to parallel processing in 2019, the second is how to ensure parallel processing works... Parallel Processing in 2019So here's a quick

Keeping getting the following error message - Overdue_Emailer: The file 'C:\\ProgramData\\Safe Software\\FME Server\\repositories\\GIS\\Test send Email/Overdue.xlsx' could not be found. It is required to form the content of the attachment Overdue.xlsx Works space created in workbench and published to server. Works fine if a run from workbench and I can see the .xlsx files that are the attachment in fme server repository but still getting an error

Hi Team,I am using the following xml snippet (thru postman) to get the response and i get the response from postman. it is working good. Now the same thing i need to achieve thru FME. Please help me on what transformer to be used? and how can i pass the parameters?can httpcaller do this? i tried with http caller using GET methos but Response is NULL.  <soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:test="http://www.synchronoss.com/spatialSUITE/test"> <soap:Header xmlns:wsa="http://www.w3.org/2005/08/addressing"> <wsa:Action>HubTraceB7</wsa:Action> <wsa:To>

Hi All, I'm new to fme, I have a LAS/LAZ point cloud data and I want to convert it to cesium 3d tiles. how can i do that using FME 2022.1.3. Please Help. -Thanks Aseem

I have multiple .dwg files I am trying to convert to feature classes. However I would like to nest the resulting feature classes inside a feature dataset that has the same name as the input .dwg file. I have tried to change the Feature Dataset name to @Value(fme_basename) under Table Creation Parameters after previously exposing fme_basename:But running the workspace with the above displays this error in the logs:"Esri Geodatabase Writer: Creating feature dataset '@Value_fme_basename_'An error occurred while attempting to create a feature dataset. The error number from ArcObjects is: '-2147220654'. The error message from ArcObjects is: {The table name is invalid.}GEODATABASE_FILE writer: A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the

Hi I am trying to set up connection to an external SQL database (the supplier describes it as an ODBC connection). I am using the SQL non spatial reader. However, we have been told it needs to use SSL to connect. Is there an option in FME to use SSL for the connection please?

Greetings, I used a setting that limits record input to 1,000 records before.I cannot find the setting to limit FME to read the first 1,000 records?? This is useful when testing a FME workbench that has large number of records. If anyone can point out the setting, it would be appreciated. ThanksClive

I have a workspace published to FME Server 2022.1.1 (build 22623) in which I want to give the user the option to Truncate Existing or Use Existing via a user parameter. When you create the parameter in the ArcSDE writer feature type, the name of the parameter defaults to fme_table_handling. This works fine when running from FME Desktop 2022.1.1 (build 22623). When running from FME Server, the parameter choice is not honored. It simply uses the choice of the parameter that was made in Desktop before the upload. However, when you change the name of the parameter to something else like 'table_action', it works as intended on FME Server.  Here is a screenshot from FME Server log file, where the parameter name is left as the default value (fme_table_handling). As you can see, the parameter is preceded by only one dash, where it should be two dashes. And also, 'fme-' has been dropped off. I think this is where the issue is occurrin

Feature Type: `JobHistoryReader_LoopHere'Attribute(32 bit integer): `Loop to JobHistoryReader_LoopHere1664443291 Input Splitter.BranchingFactory.Count' has value `1'Attribute(string: UTF-8) : `_min_job_age' has value `20220928000000'Attribute(64 bit integer): `_offset' has value `0'Attribute(string: UTF-8) : `fme_feature_type' has value `Creator'Attribute(string: UTF-8) : `fme_geometry' has value `fme_undefined'Attribute(string: UTF-8) : `fme_type' has value `fme_no_geom'Coordinate System: `'Geometry Type: IFMENullCoordinate Dimension: 2===========================================================================Loop to JobHistoryReader_LoopHere1664443291 Input Splitter (BranchingFactory): Transformer/Factory JobHistoryReader_HTTPCaller is blocking and cannot be used in a loop, but was found between 'Loop to JobHistoryReader_LoopHere1664443291 Input

Hello there we have Millions of JPG Photo we want to geotag all the metadata is located in an excel file is there a way to do this via FMEThanks 

Why i am Getiing this warning and error when i try to run workspace on desktop and on server