Authoring

Hi All, Is there a way to allow the jobsubmitter workspace to be partial populated by some means from user clicking a prebuilt URL? (Or other method) I have a ESRI webmap that contains a feature service with Asset locations. These assets contain a unique identifier attribute I wish to pass into the workspace so the user doesn't have to type it, or select it from a drop down.The workspaceI have a workspace that requires the unique identifier to maintain a relationship with other data, however the user needs to load in a CSV and add other parameter details before executing the workspace. Currently I have set it up so the user types this ID, but this is fraught with danger of the relationship being lost due to typos. My research so far....I have found that I can either build a URL from the attributes in my ESRI web map as a popup to either 1. Open the job submitter with blank

In FME 2019, I can pass feature class names to a workspace without error.  Now, using FME2020, I'm getting warnings from the workspace that didn't run properly reporting the following:The table name '@Value(fme_feature_type_poly)' could not be found in the Geodatabase as either a feature class or a tableAll other parameters pass fine (postgis where clauses, etc.)  The only hiccup is with file geodatabase feature class specification, which is correct within the workspacerunner fmw.There is no error reported by the workspacerunner fmw, just in the target workspace.I've checked over and over and the problem keeps manifesting. However, when using FME2019, everything is smooth-sailing. Anybody else run into this phenomenon or have a known fix?  Is there another way that the user parameter needs to be formatted/Thanks,Pete

Hello people, I am new to FME (about 3 months) and this is my first post on this community. So, please be patient, if this question sounds ridiculous to you ;-)The background of my question is as follows: I have a big major workspace and want to split this into a few smaller, less complex, workspaces. In addition, I would like to re-use some of these new small workspaces in another context. Therefore, my idea was to build a few FME-workspaces as modules and use these modules to build bigger major workspaces.I understand that I can use custom-transformers and/or workspace-runner for this, but both do have some disadvantages on its own.Workspace-runner on the one hand, can just run another workspace (as the name says) and it can transfer data from the parent-workspace to the child-workspace via published parameter. However, the workspace-runner cannot give you an output from the child-workspace back to the parent-workspace (if I am right here?

I have an FME script which takes specific headers of a source spreadsheet and copies the them and the field values to two new fields (Substrate Size Distribution & Substrate Size Distribution Value). There are transformers which replace alphanumeric characters from the original header string, sorts the numbers that are left, and concatenates the alphanumeric characters back to the sorted values. This works great. But, the script is coping a header from a field called "Visit_Year" to Substrate Size Distribution field and its value, "1989", to Substrate Size Distribution Value, where values are null in the specific headers I am trying to reformat. This is not what I want. See attachment. I want Substrate Size Distribution and Substrate Size Distribution Value fields to contain only the headers and their values, not the header text Visit_Year. Thoughts as to what is going on?

i want to know how u are converting 3d files format to json

I have spreadsheets with Date and Time fields. I assign them to a Reader in FME 2018 and funnel them through AttributeManager. When I check the output that comes out of the Writer, I see that the Date and Time fields have been modified. I have tried to find a setting in the Reader and transformer which would prevent these fields from changing so I don't have to use the DateTimeConverter. Does anyone have suggestions? The only solution I have found is to change the field in Excel to concatenate Date and Time. Then this field stays the same after the AttributeManager transformer. However, some of my spreadsheets don't have a time metric, just date. Thoughts?

Hi list.I have next to no knowledge of what OAuth2 entails, other than it being a security protocol.A customer wants to use OAuth2 when exposing a WFS and/or an Esri Feature Service to us, and we want to use FME (Server) to fetch the data.Both desktop and server have a facility for custom "web connections", and here you can create both "Esri ArcGIS Portal" (w/OAuth2) and a straight up "OAuth2 Service" connections, but how do I utilize them when reading data ?Are there any in-depth resources available that covers this area ?CheersLars I

I have got an environment with a set of Named Connections however I would like to test them without pushing up a workbench. Is this possible?

In MS/SQL I have a table with multiple geometry fields. When using a FeatureReader, how can I designate which geometry column to read ?

I have a dataset with values of D15 (mm), D35 (mm), D50 (mm), D84 (mm), D95 (mm), & D100 (mm). I want to use stringreplacer to remove the letter "D" and "(mm)". Syntax to remove?

Hi @GerhardAtSafe , Thanks for developing the new SharePoint Package, I am very excited about its functionality, but have unfortunately already run into an issue when trying to install it. Please see the log below. It may have to do with my version of python.I am using FME 2020.1.0.1 Build 20596. Apologies if this is something I would rather need to pick up with my IT department. Log when trying to install the package:An error occurred while installing package 'C:\Users\Srautenberg\AppData\Roaming\Safe Software\FME\Packages\20596-win64\PackageFiles\safe.microsoft-sharepoint': An error occurred while installing Python package with 'pip install --force-reinstall --no-deps --no-index --find-links C:\Users\Srautenberg\AppData\Roaming\Safe Software\FME\Packages\20596-win64\PackageFiles\safe.microsoft-sharepoint\python --target C:\Users\Srautenberg\AppData\Roaming\Safe Software\FME\Packages\20596-win64\python\safe.microsoft-sh

The circled number is exactly 2x the number of records in that input - an sde point file. This happens no matter which file is "on top." In the translation log, the Total Features Read is exactly the right number.Total Features Written is too high by exactly the number of records in the first input. All other inputs are appended correctly. Does anyone know why this is happening?Thank you,Randy McGregor

Forgive me if this is a stupid question, but I haven't found this process to be very intuitive and I haven't found a solution in the documentation. Let's say I have a database with 10 different tables. There are some common columns in each of these tables, but they also all have unique columns. I want to create a dynamic workspace so that a user can open it, run it, and specify the name of the table they're interested in to send only the features from that one table on to the writer. So I create a reader, I select "single merged feature type", I specify the names of all the tables in the Table Names box in the reader parameters, create it and add it to the workspace. I create a writer (let's say it's an ESRI shapefile), I set the User Attributes to Dynamic, and I connect the two. I run the workspace and in the "Feature Types to Read" parameter I provide the name of just one of the tables. I look at

I have a list attribute that I'd like to use in a JSONTemplator. I am able to get the list into an array no issues, however, I want the result to be an array of integers/numbers rather than a string. If it was not a list I can use the xs:integer to try to force it to be an integer, however, I'm not quite sure how I should do this for values in a list. Any ideas on this?

Hello FME-specialists, I use FME(R) 2020.0.2.1 (20200511 - Build 20238 - WIN64)I made a succesfull webconnection with SharePoint.I tried to read the database of MSPROJECTS. According the manager of MSPROJECTS my credentials has all the rights needed to access the msproject database (user and password are correct and user has sufficient rights). The HTTPCALLER unfortunately gives errors: 'HTTP/1.1 403 Forbidden' from ...' (see attatchment)QUESTIONSWhat goes wrong and how can I connect properly to MSPROJECTS with FME?(I also tried to fill the clientID and the client-secret in my web connection but it resulted in no connection with sharepoint)2 . Does FME V2020 HTTPCaller support SAML (SharePoint Online) authentication?3. Do you have a working example HTTPCALLER with SharePoint? ===============================================

After creating an FME Server Resource Connection, how can I work with this to author my workspaces? When I view the Folder properties in FME Server I can see the System path references an FME Server macro $(), however when I specify this path within my workspace it shows red because FME Desktop does not recognise this as an existing parameter.

Hello there! I have a problem with the definition of Published Parameters. Using Customized Transformers when I define a Published Parameter to the type "Attribute name", creating a new attribute and having that as output, I have the Attribute name as output and not the Attribute Value. I would like the Attribute Value as output.  When I change the definition of the Published Parameter to the type "Text" and fill in the textstring "@Value(name_of_the_attribute)" I do receive the Attribute Value as output. In the attachment you find two files. In one you can see the results of the settings from the configuration menu. Please take into account only "Foutmelding" and "Fouttype". "Foutmelding" makes use of the above described textstring while "Fouttype" makes use of the type attribute name-setting.In the other you can see the output

I've got a big workspace (running on desktop 2019.1.1.0) that uses a few embedded custom transformers to perform some fairly complex calcs. I actually call one custom transformer a lot of times. This worked OK when I had about 75 of the transformers in the workspace, but now that I have about 90 it is returning the error "Too many recursive macro substitutions..."I think there is probably a way I can use looping to physically reduce the number of transformers in the workspace, but this will be a very big effort and I'm not sure there is any guarantee it will actually fix the problem.Has anyone seen this before and know what the issue is?I have found a couple of unanswered questions about this when searching in the previous questions. thanksKeith

Let's say I have 10000 features going thorugh my workflow and 7000 do not pass a test. I want to send a single message (to whatever) and not a message for each feature.I know there's many ways of doing this but I'm looking for the most efficient one. Maybe my approach is wrong, but I've considered any transformer that lets me get a single feature and then I build the message with an AttributeManger or an AttributeCreator:Sampler: 9999 features would go through the NotSampled portStatisticsCalculator: I actually have no statistics to calculateAggregator: may be the best optionAny other?  

Hi, I could probably work this out over days (weeks!) but I figured asking the question here may be a quicker method to the end goal!As a first line, I am working in FME(R) 2018.1.0.0 (20180717 - Build 18520 - WIN32) which is unchangeable due to it being what is installed/available at my place of work. Just in case this affects a solution.Also, this is my first time posting here, so apologies if this is vague/long winded/wrong format etc.I have a spreadsheet with each row being a project and multiple columns showing the names and addresses of people involved in the project. I have successfully run this through FME to amend the various raw details into the format required to distribute as I require.However, I now need to generate a duplicate free list of all the 'contact name'/'company name'/'postcode' which I will then be able to reference back to the original format of the spreadsheet (i.e. a row per project with multiple 'con

Hi Everyone, im new in FME and still learning a lot. I want to Sort some Files by their Filename.For Example:in Directory are few Files: E006N52_ed2.zipE025S23_ed4.zipW312N34_ed1.zipetc....Now i want to Sort them by:All E..... in one Way (Output on html as: All East Files)All W.... in one Way (Output on html as: All West Files)Hope u understand what i mean ;) Greetings

Hello there!I was creating a report from a database and I had the idea to pimp my report with the ExcelStyler, to impress some colleagues. I realized very fast that when I put a conditional value on Background Color or Font, I can't write without an error into an Excel file when I have too much features. I can click yes, but I don't get any color/font, the ExcelStyler hasn't worked.To explain the problem I created a workspace I attached . I put a conditional value on an attribute and I write it into Excel. I added a Sampler because as you'll see, when I write exactly 21809 features it's working, but higher than that, it's not, I get the error.  Am I doing something wrong?I'm using FME 2018.1.

Hello guys,i have a feature class with the county of new york, some one say to me that if want to iterate through the county i need to :"Create a published parameter for the county (name or id) to limit the workspace to one county.Create a second workspace with a reader for the counties."I dont really know how to create a published parameter on a attribute value like the name of my county feature class. who could help me ?

Hi,Usually when accessing API data I can pass my user credentials using a HTTP caller and then the name of the API service.However, for the service I'm using now its asking me to log in first, then access the API using a url. I can use a HTTP caller to pass my login credentials to the server, which results in a successful response: how then do I use the results of this to access the API service, which looks like this: https://sww.watercore.net/API2.ashx/GetAvailableChannelListForExport Thanks,N

Hi all,  Has anyone had any luck trying to calculate a radius of on object from a point cloud?I have point data for several structures (e.g., wind turbine, water towers etc) and I have a fairly detailed Surface Model. Seems to be quite a tricky task for FME. I would probably try and clip the point cloud by some buffer which I assume will be bigger and then try and get all points which are some percentage of the max height withing the buffer.Once I have the points then it would be about creating a convex hull and calculate radius based on area (assuming a circle). Pretty crude... Any other ideas would be welcome. Thanks in Advance