- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Authoring

Authoring

Creating and organizing workspaces. How to use Workbench.

3,048 Posts
12,635 Replies

When you subscribe we will email you when there is a new topic in this category

3048 Posts

Calculate distance of a point to the nearest vertex or edge of a polygon feature

Trying to calculate distance (Have been using nearestneighbour) but now require were we have a set of points in table 1 and a set of area features in table 2.We need to calculate the distance from each point to the nearest area feature but not its centroid, the requirement is to find the distance from table1 point to the nearest edge or vertex of an area feature from table 2 happy to hear ideas on how to do this thanks

1900

3 years ago

simon_bellContributor

asked in Authoring

How to update ESRI Feature Class Metadata down at the Resource/Fields/Entity and Attribute Information level?

We are trying to automate updating the metadata on feature classess, in particular at the level of the Entity and Attribute Information level for the fields in our feature classes.I have tried both methods of updating from an XML file or directly from the file geodatabase as metadata, but I can't seem to expose the information down to the field level of XML detail.We are basically trying to update the Definition & Definition Source of all attribute fields in the feature class from an table. see highlighted area below to show help explain.Is there something simply I am missingThanks

Is there a way to publish an FME Server application to a public website that is in cPanel?

I would like to know if there is any way that I can host an Fme Server application on my organization's website (for example) that is published using cPanel. What I would like to do is that through a public website, some of our clients can access a server application. I know that I can connect some other web application to the fme server using rest API or url webhooks if the server has a public IP address, which can be accessed from an external network. Can anyone enlighten me on this issue? I am just getting started in web development and these questions come to mind. Thanks

I'm looking for this article: https://www.safe.com/blog/2020/10/build-virtual-conference-booth/ Does anybody know why it is taken down?

I'm looking for this article: https://www.safe.com/blog/2020/10/build-virtual-conference-booth/Does anybody know why it is taken down?

3 years ago

nilsmeinhardContributor

asked in Authoring

DWG-file name from Publiced Parameter don't work when using the Data Download Service....

Hi I'm creating a DWG-file witch gets it name from the published parameter outfile. This works fine when I call the workbench directly from the desktop. But if I upload the workbench to the FME-server and then using the Data Download Service I get the default name instead of the supplied parameter.Here is an example of a http-request to the fme-server:http://localhost/fmedatadownload/SPIV/spiv2dwg.fmw?export_spiv_data_id=99&outfile=newname.dwg I first thought I somehow failed to supply a value for the outfile-parameter, but since the other parameter is working fine, I don't think that could be the problem... Regards Nils P.S I'm using FME Workbench and server 19.1 resp 19.0

140

3 years ago

nedwatermanContributor

asked in Authoring

Using HTTPCaller with Body

HI, I've not used the HTTPCaller using a POST request and body attribution.The API call constructed by the developer has been provided like this:var client = new RestClient("https://sww.smartchartapi.co.uk/api/Authentication/request");client.Timeout = -1;var request = new RestRequest(Method.POST);request.AddHeader("Content-Type", "application/json");request.AddHeader("Cookie", "ASP.NET_SessionId=xcqkvogm2bp2yxshsgx1ncbg; AspxAutoDetectCookieSupport=1; __AntiXsrfToken=e680dfae824a472088c01d6672ba8471");var body = @"{" + "\\n" +@" ""username"": ""SWWAPI""," + "\\n" +@" ""password"": ""***""" + "\\n" +@"}";request.AddParameter("application/json", body, ParameterType.RequestBody);IRestResponse response = client.Execute(request);Console.WriteLine(response.Content); I've set

Correct transformer for joinig to database tables

I have to tables from ms sql server.table A: Task_postingtable B: Task_analysis They are joined by the transaction_id field. Now I need to get all Fields from A and add line_cost, Line_qty and Line_unit from B. What transformer is the best for this? I tried to use databasejoiner, but in the section "fileds to add" I cannot find the fields from table B

3 years ago

sashalContributor

asked in Authoring

Why FME has stopped working when Parallel Processing is enabled on Custom Transformer?

My workbench run successfully but when I enable parallel processing on a custom transformer, and 'FME has stopped working' error/APPCRASH occurs. I have tried:using only one group to process to rule out having too many parallel processes, I have tried setting to minimum, moderate processing. I have tried publishing to FME server and running. All fail as long as parallel processing is enabled on the custom transformer. Does anyone know the solution for this?

Updating 'reader as resource' for dynamic writing

Hi all,I am using an excel file containing several tabs. Each tab corresponds with a feature type in my data. And each feature type/tab has its own specific set of attributes I would like to write to several formats. Whenever changes are made to this excel file (changing names of attributes, adding attributes, adding tabs, etc.), it does not update automatically. Even if I set the parameter 'Scan Schema in Dynamic Workflow' to 'Yes'. Every time changes are made, I have to delete the workspace resource and add it as a new. Anyone having similar problems? Or solutions to this problem?Thanks!

FME - workbench - destination-folder?

I'm having trouble getting a dwg writer to write multiple files. What is syntax in FME desktop v. 2019.0 If I write .... *. Dwg - then there are errors - probably because it writes all dgn files to the same dwg file - If I do not write anything there are also errors.

3 years ago

larueContributor

asked in Authoring

How can I filter out aggregates that contain the same geometry as another, but keep the ones with more parts?

I have a bunch of line pairs where each individual line has been assigned a UUID and is stored in a list: UUID_PARTS{} with indices 0 and 1. Also have some aggregates of three which contain the same lines as the pairs, plus an additional line. They also have the same list attribute, where the indices are 0, 1, 2. The pairs and trios of lines are currently separated, but could be combined if needed. Have tried both list-based feature merger and regular feature merger on UUID_PARTS{0} or UUID_PARTS{1} with various settings, but no luck. My goal is for this to be flexible enough so it does not matter what index the matching UUIDs are and also handle aggregates with more than three parts, if possible. Any ideas? Thanks, @larue

3 years ago

btlContributor

asked in Authoring

Custom Transformer versioning in 2021

I have a custom transformer that I have been periodically updating for a couple of years and I had it working so that whenever I opened a workspace that used the transformer it would ask me if I wanted to update to the latest version (yes). However, I tried editing the transformer in 2021.0 and the versioning seems to get lost. When I saved it, it is saved as version 1 (instead of v23) and when I opened a workspace that used it, it did not ask if I want to update to the latest version - unless I am missing something this is a massive pain because it means manually replacing the transformer, reconnecting all the inputs/outputs, and reassigning published parameters. I was able to recover my previous versioning info (which involved reverting back to 2019) but workspaces still do not ask if I want to update to the latest version of my custom transformer - is there a way to get this working again?

3 years ago

bhavyagandhiContributor

asked in Authoring

I want to create a sequence of numbers starting from 1 but ending at a certain point which it will decide from attribute value coming from the SQL executor, suppose the value came out as 100, then I would want to create sequence of numbers upto 100.

How to identify Line Orientation? Clockwise/Anticlockwise

Hi All, I am trying to identify the orientation of a line (clockwise/anticlockwise or left/right) so that I can use Orientator transformer if a line has been drawn anti-clockwise. In older post this seems to be achieved by using Azimuth Calculator on FME Hub; however, this does not seem to be currently available. Is there any transformer I can use or workaround to achieve this? Thanks,Ana

460

3 years ago

lifalin2016Contributor

asked in Authoring

Reading feature attributes from varying Excel with FeatureReader

Hi list.This issue has been touched on several times, but I don't see a solution for me in any of the answers.I have to read a number of Excel spreadsheets, and being spreadsheets, they vary very much in both content and structure.I can read the spreadsheets with FeatureReader just fine, and I get both schema features with an attributes{} list of attributes, and generic data features with attributes in an unexposed state.How do I utilize the schema features to dynamically expose whatever attributes are present in the data ?Exposing attributes seems to be a design time issue only, and I haven't found any way to expose attributes dynamically.Alternatively, can a (MS/SQL) writer accept a list of name/value items, and output these to the database as fields with values ?I also need to merge several fme_feature_type's (i.e. multiple Excel sheets/tabs), so Dynamic Schema Definition won't work for me, I think.Cheers.

Attribute pivoter not working anymore while upgrade to arcgis 1.8 was done.

After a upgrade to 1.8. arcgis FME data interoperability model does not work anymore.Type of an error i am getting : Python Exception <TypeError>: '<' not supported between instances of 'str' and 'float'Traceback (most recent call last): File "__init__.py", line 163, in close File "__init__.py", line 261, in generate File "__init__.py", line 298, in summaryData File "__init__.py", line 417, in summarizeTypeError: '<' not supported between instances of 'str' and 'float'AttributePivoter_2 (PythonFactory): PythonFactory failed to close properlyAttributePivoter_2 (PythonFactory): A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for details

130

3 years ago

lorindaContributor

asked in Authoring

Change name of Shapefile and copy or move to another directory

Hi,I've got scripts set up to download 51 zipped up shapefiles to a directory, then extract them to another directory. There is a script to delete the old files as well so that it doesn't get out of hand. However, my source is now appending the date to the shapefile. My script expects the name to not have dates attached to it. I've used the FilenamePartExtractor and AttributeCreator to change the filename to the desired name that will work with the conversion script of shapefile to EGDB. My problem is that I can't get filecopy writer to copy or move these files to a new directory so that they can be used by the conversion script. I'm not sure what I'm missing. I've used the filecopy before for a single json file, never for many files that are related (shapefile has 8 components in this case), but this time it is being very picky. I'm thinking it has to do with the 8 files rather than 1. In the StringConcatenator, I see the name that I want and

570

3 years ago

matthieuvContributor

asked in Authoring

Get row and column from a raster for points on top

I'm trying to create GCP points for a raster. I have some points for which I know the original and transformed coordinates. So now I need to know for each point the column and row from the underlying raster. I tried the PointOnRasterValueExtractor, but it gives only information from the bands. I tried the RasterCellCoercer which gives me row and column. With a spatialfilter I get results, but is already slow for my test file and when I try to do that for my actual raster I run out of disk space. Does anybody know another way to get the row and column from a raster for a certain point? I use 2020.2

330

3 years ago

lifalin2016Contributor

asked in Authoring

FeatureWriter, ESRI Shape, and a single feature = problems

Hi list.I'm using FeatureWriter to write some data into a temporary ZIP file, that is being attached to an email.When I have the situation, where a single feature needs to be output in ESRI Shape format (inside the ZIP), it seems that the file isn't being written at all !?!?I've tried different file locations, different file names etc., nothing works.But if I add a Cloner with a value of 2, the file gets written as expected.What gives ?

3 years ago

lifalin2016Contributor

asked in Authoring

Understanding schema features ?

Hi.I'm trying to utilize the "schema features" for dynamic schema definition output, but have a hard times grasping exactly how FME uses and don't use these schema features.FeatureReader has a special "<Schema>" output, but readers don't seem to have a similar mechanism, even though one can designate them in the dynamic output as "Schema Source". Does this mean that there is an underlying hidden connection between the readers and the writers ?Specifying "Schema From Schema Feature" does _not_ seem to enable the writer to read schema features, but requires the schema feature content to be superimposed upon all data features. Is this correct?I have several needs to be able to manipulate the schema before output, so understanding the functionality is important to me.One need is to "clean up" a schema defintion before output, especially if the input if WFS (FME adds all sorts of nonsense into the schema, e.g. "*.xsi_n

How to change List to attribute (with ListIndexer transformer loop or another way)?

Hi,I know that there are a lot of questions in the forum about that but I’m not able to find how I can use it correctly. So, for extract my attributes from a list I’m using ListIndexer after the aggregator (10 listIndexer if I have 10 lines aggregated) to add a prefix to my attribute (index 0 with prefix for example x0_ and so on). That works but I think that is not a good way to do that (especially if the data change and I need to add more ListIndexer).Is-there a way to do that with loop or another method (a dynamic way to extract the attributes)P.s: I have many attributes, so expose elements will be more complicated.Thanks

6940

3 years ago

chickeyContributor

asked in Authoring

Any plans/solutions for Smallworld database connections?

I currently have about 175 ETL workbenches for extracting Smallworld data for ESRI/Oracle which are being run from scheduled job on FME Server, and rarely are also manually run individually via FME Desktop if the scheduled job fails. We are moving to a new environment (new network, new hostnames etc.), so each workbench now has to be visited individually to change the Smallworld connection config. Are there any plans to allow a Smallworld database connection (i.e. under Tools/FME Options/Database Connections) to be created? If not, would anyone have any suitable method (considering I will be visiting all of these anyway) to provide a centralised parameter(s) type solution to allow one location to have the connection config information? I am even starting to look at 'config.ini' type functionality in each workbench, but obviously that is a kludge. Any ideas/possible solutions would be very welcome - thanks.

180

3 years ago

redgeographicsCelebrity

asked in Authoring

Import format and coordsys names in choice with alias paramter

Working with FME 2021 here, trying to set up a Choice with Alias parameter and it seems the option to import format and coordinate system names has disappeared in this version. Does anybody know how we can get that back (other than setting up the workspace in 2020)

3 years ago

lifalin2016Contributor

asked in Authoring

FeatureWriter and dynamic schema definition fails !?

Hi list.I'm attempting to use a FeatureWriter to write som ESRI Shape files, wanting to utilize the schema features from the (WFS) input (read with FeatureReader) to enable dynamic schema based output.I have selected "Schema from schema features" for source and "fme_feature_type_name" for definition name. And both schema and data features arrive at the same port in FeatureWriter.However, the workspace fails immidiately when FeatureWriter receives the first schema feature, and long before any data features arrive.Why does FeatureWriter fail when receiving a single schema feature? I would have expected it to just keep it (them) until any data features arrive ?Is dynamic schema definition driven output at all possible with FeatureWriter ?Any help is appreciated.

Hi i have a database with 500+ tables, and i want to create a sample of each table. The sample should be the top 10 rows in each table, and i'll write them to a flat file format like CSV.

I can create a list of schemas and tables, using a SQLCreatorselect schema_name(t.schema_id) as schema_name, t.name as table_namefrom sys.tables tand then i can use that in an SQLExecutorselect top 10 *from [@Value(schema_name)].[@Value(table_name)]and this is where i get stuck, as each table will have different attributes to expose. I have also tried using a dynamic reader & writer combination, but couldn't workout how to stop it reading all the records in each table (which would take way too long to run). i'd appreciate any help you can offer.

220

3 years ago

Page 23 / 122

Badge winners

james.zazulahas earned the badge Welcome Back
hyperxhas earned the badge Teacher (Grey)
judithhas earned the badge FME Certified Trainer
lundg1has earned the badge Integrate Data with the FME Platform Training
bezearvhas earned the badge English Speaker

Show all badges

30,412: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.