Authoring

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

Hello!I have 2 workspaces. The second workspace call the first with a workspace runner.The user of the workspace will launch only a .fme file. So for the moment, I use published parameters to fill the parameters on the workspace runner. But it's very long and if I update the first workspace I have to change the second one.So there is a way to show the parameters of the workspace runner directly on the form when the workbench run ?Thanks!

I am using looper to modelize the daily temperature. I want to input different values from different cells in Excel to do the calculation in each loop.(For example, input Value A1 to calculate Loop1, A2 to Loop2 ) Is it possible for me to do that in FME?

I want to read different csv files that includes coordinates and do some calculation with this coordinates. The attribute names differer from file to file: x, y or a, b or lon, lat ... The calculation is the same for all input files. I have created internal names for the coordinates like wgs84_lon and wgs84_lat. I want to create parameters to let the user assign which attributes in the source csv includes the values for wgs84_lon and wgs84_lat like x >>> wgs84_lony >>> wgs84_latI have used an dynamic csv reader and tried to use the AttributeCreator and publish some of its parameters but this did not work for me :-(I am looking for a solution that works with FME Desktop and FME Server.Can anybody help me?

I have a folder of pdf files. I would like to extract the names of the files and put them into a separate rows into a column. Attached is a screen shot that shows examples of the files.  

I have a line network and need to calculate the angle for each line vertex. I have tried using PolylineAnalyzer but unfortunately it doesn't calculate the angle for all vertices when I used it in the main workspace. Too many vertices miss the angle value. As for now, I use PolylineAnalyzer in a second workspace which I execute for each line in the line network and write the results to a csv. This does, however, take a looong time. It is the attribute AngleBetweenLines I am after.

I'm looking at starting to publish some of the custom transformers I've been putting together and it occurs to me that while I want to publish them on the FME Hub under an open source license (like MIT, requiring only attribution and nothing else to use), that perhaps I'm not able to as FME itself is proprietary. So I was wondering if I can get some guidance on what I can open source and what I cannot?For example, if I create my own Python code, that is mine, but if I'm importing fmeobjects, then technically I'm bound by the license for that as my code depends on it.Similarly, if my transformer just uses the .fmx format, then it heavily depends on the FME internal factories and functions. This would be especially true if my transformer was based on an existing transformer first.As I'm looking at open source, I'm not looking to get any money out of this. It's just nice to get recognition in the long run. Particularly if Safe one da

Hi, I am using the websocketSender transformer to stream some data; when I am using the template in the data to transmit as below:  {  "ws_op" : "send",  "ws_msg" : "FME Rocks" } I have no issues; however when replacing the "FME Rocks" with the attribute name, nothing happens. For example, if I have an attribute named "id", here is what I do:{  "ws_op" : "send",  "ws_msg" : fme_get_attribute("id") }I don't get any errorr, it is just that data is not transmitted compared to the first case.Any pointers would be much appreciated.Thanks.Lyes   

Hello, I am reading a number of input files that are then processed all-together and split into multiple subfiles based on an attribute, using fanout. The reason of running them together is that there are 30 inputs and each input generates 3 outputs, so that would be 90 writers in the workspace.Fanout works fine. However, because each input has slightly different Attribute Definition, in the end the final outputs have an accumulation of all the attributes, most of them being empty.I wanted to know if it is possible to take a different Attribute Definition for each input, if that makes sense? So each output after fanout would have exactly the attributes that it needs to have, and not lots of empty ones that come from the other files.