- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Authoring

Authoring

Creating and organizing workspaces. How to use Workbench.

3,045 Posts
12,618 Replies

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

3045 Posts

OneDriveConnector to Emailer - how to bring through _sharable_link attribute

Hi,I'm doing a bit of testing with OneDriveConnector and Emailer. My workspace writes an Excel file out using FeatureWriter and then uploads that file to OneDrive. I want to insert the '_sharable_link' attribute, created in the OneDriveConnector, into the body text of the Emailer. However, the Emailer appears to get rid of the value in the '_sharable_link' attribute, therefore the hyperlink <a href="@Value(_sharable_link)">Output</a> doesn't work in the resulting email.Has anyone come across this before? Or in the more likely scenario, am I missing something obvious?Thanks!

6 years ago

anthony1

asked in Authoring

Getting FME to fire an onclick event

I have what seems like a simple thing I need to do. I have a webpage with a java button on it. The result of pressing that button downloads an xls file that is the data I need. I'd like FME to be able to go to that URL and press that button, but I can't figure out how to get the HTTPCaller to hand the java code and then capture any response. Maybe it's not the HTTPCaller I need?I'm pretty new to FME. The URL is inside a fire wall, but it's a basic https URL. Inspecting the button shows this code.<button title="Excel" onclick="cfExportData('xls', 146014343, 'WorkItemEvents:146014343', 'WorkItem,EventName,EventStartDate,Notes', '')">XLS</button>What do I need to do to hand FME a static URL and get it to run this cfExportData command from above and then capture the resulting file download?Any tips/help would be great. Thanks

Poll REST Service until value changes

Good afternoon,How would I poll a REST Service, check the value of a attribute (e.g. status), sleep if the attribute is not yet "completed" and then retry? (Ideally I'd implement a short-circuit if the time is exceeded, e.g. expose a attribute in Python and add a Tester). In this diagram, it seems FME explicitly prevents the possibility of a looping structure? Do I need to either:Place the last REST API call into Python and do the looping within there ... ORInvestigate this article: "Looping with a Blocking Transformer" ?http://docs.safe.com/fme/2017.1/html/FME_Desktop_Documentation/FME_Workbench/Workbench/looping_with_blocking_transformer.htm Cheers.

How to extract the coordinates (x,y,z) of all vertices of a polygon and add it as attribut

Hi,I am new in using FME and it seems that there are something that I am missing, I found the "CoordinateConcatenator" transformer that I think can do what I need. I open my shape file as a reader ,I choose the CoordinateConcatenator transformer and then I choose a new shapefile file as writer (output).It runs with no error but no new attributes containng the coordinated of the vertices in the output file.I tried to add attribuet creator, attribute writer ,nothing works ,what am I missing?Thanks for your help!

4220

6 years ago

oliver.morrisContributor

asked in Authoring

Connect to Oracle

Hi, I have an oracle db I would like to connect to from FME Cloud. I can reach it on desktop but I have the client installed locally. Can anyone point me to a link on how to connect, I have had a look but couldnt find anything.Thank you

270

6 years ago

jdhContributor

asked in Authoring

Dynamic FeatureWriter and feature counts

I have a scenario where I need to dynamically read in some data (FeatureReader), do a bit of filtering and write it out dynamically with the FeatureWriter and then continue processing. Since there's no reader to point to in the Dynamic Schema Definition Schema Sources, I'm using "Schema From Schema Feature". This creates the correct output file with the correct number of features. However, the Summary port feature is including the schema feature in the _total_features_written attribute, so is one more than the number of features recorded in the log, and also outputs it through the Feature Output Port. Is this the desired behaviour?

Multiple parameter in PythonCaller script

Hi,I'm trying to make a script that will replace/erase some of words from table of strings.I want to create list of key words in a Published Parameter (multiple choice) that will be piked by user. When I pick one KeyWord script works fine but with more doesn't work at all. How can I make it to loop through all picked words?str1 is with Published Parameter andstr2 is with list of words, but there should be more of them so it will look horrible ;)EDIT: words are single. Additional problem I have now is how to make them be whole words only eg. Landhotel shouldn't be erased HOTEL, only Land Hotel -> Land.And additional question is there a way to replace RegEx matching with sth shorter? I'm new in scripting so my code is vary basic :)I have such a script in PythonCaller:import fmeimport fmeobjectsimport redef KeyWord_replacer (feature): str1 = feature.getAttribute('Name') str2 = feature.getAttribute('Name2') keyW = FME_MacroValues['KEY_WORDS'] str1 = str1.lower() str2 = st

6 years ago

li_fme

asked in Authoring

How to customize Fanout file names

Hi,I have an workbench where I used a fanout in a geojson writer. The geojson writer has 23 features and each feature is fanout based on the fme_feature_type where my Fanout Expression is "@Value(fme_feature_type)". The result is great, it created the files I need in geojson format in the folder specified in the "Destination" property of the writer. But each fanout dataset is named with the feature name. So if my fme_feature_type name is gis.auto_recloser, the fanout file is named gis.auto_recloser. But I would like it to be named auto_recloser_delete.geojson instead. Is there a way to customize the fanout dataset file name?

FME Desktop not recognizing installed StatTransfer license

Why isn't FME able to find and recognize the installed StatTransfer license I have? I need to use the RDATA reader and cannot get FME to see the installed StatTransfer software I have.

SketchUp : how to write groups

Hello,I would like to know if it is possible to handle groups for SketchUp output (.skp files), like layers handling with the aggregator ? I tried ola solution (here), without success ... Thanks in advance,

6 years ago

frankvandoorne

asked in Authoring

Why is an empty date parameter of different type when running it from FME Server or Workbench?

Hello,I have a workbench with an optional DATE-parameter. When I use a tester to handle that empty date, I get different 'outcomes' when running from within FME Workbench compared to running it from FME Server. FME Server says an empty date parameter 'HAS A VALUE', but directly in Workbench an empty date parameter is an 'EMPTY STRING'. I use the exact same versions for Server and Desktop (version 2018 build 18301 Win64).Is this a bug? How can I properly handle empty dates passed via parameters?Regards,Frank van Doorne

Hello.I am needing to lookup attribute values from my source table and lookup the attribute name and value in an excel file to return a the new mapped value. If the source attribute name and value matches the lookup list, return the new value.I have tried different combinations of mergers, exploders, joiners. Its a massive dataset with dozens of attributes to lookup per record. Any guidance would be appreciated. The challenge mostly that source attributes to align are values in the lookupFor example:Source Data ExampleSTATUSMANUFACTURERMATERIALCREATEDBY0ABC_COJohn0ZYX_INC1John0ZYX_INCJohnLookup XLS IDDOMAIN1ORIGVALUENEWVALUE1MANUFACTURERABC_COABCCO2MANUFACTURERZYX_INCXYZINC3MATERIAL UNKNOWN4MATERIAL1PLASTIC5STATUS0ACTIVEDesired Target STATUSMANUFACTURERMATERIALCREATEDBYACTIVEABCCOUNKNOWNJohnACTIVEZYXINCPLASTICJohnACTIVEZYXINCUNKNOWNJohn

Help with counting, comparing, as a condition for execution?

I have a SQLCreator that returns x number of features, and FeatureMerger that returns y number of features. I then want to compare the two counts (Does x = y?) and if that is false, then I want to do certain things, including generating a string (for logging or notification) that is something like "Table1 has x features and Table2 has y features."I can get the respective counts (StatisticsCalculator), and I can compare the counts (Tester) and I can (incorrectly) generate the string (StringConcatenator). My problem is more about storing/saving values, and regulating their population and use.For example, two counts comes in as two features, so I get two comparisons, and two strings:Table1 has x features and Table2 has <null> features.Table1 has <null> features and Table2 has y features.FeatureHolder seems only to delay the inevitable. What am I not fundamentally understanding about feature processing that is making this harder than it should be?Thank you very muc

Reopening or testing connection to Oracle

Hello,I've encountered to a problem with my connection to Oracle DB. I have a workbench that needs a fair amount of time to process. I don't know how but connecting to Oracle DB is executed at the start of translation an by the time all features are ready to be written to DB FME gives me message: Error committing transaction on Oracle connection: message was `ORA-03114: not connected to ORACLE'. (serverType=`ORACLE8I', serverName=`//ORACLE_DB:1521/orcl', userName=`SYSTEM', password=`***', dbname=`') After this message translation is still active but nothing is happening. My DB is located on separate server connected over LAN network.Is there a possibility to:a) Set that connection to Oracle DB is executed when features are ready to commit?b) When connection is lost that FME reconnects to DB an continue with translation?I am using FeatureWriter to write to my DB with FeatureHolder in front of it.

Feature writer outputs wrong geometry

I am using FME 2018.0. The problem is that my FeatureWriter outputs some weird geometry. The first picture is my input geometry. The inspect result is generated right before entering FeatureWriter.Then, I created a FeatureReader connecting to the geodatabase created above and inspected following geometry.I looked into the two geometries. They have the same amount of vertex. What could cause this problem?Update 1. I change the output format to shapefile and it works with either arc geometry type or polyline. The latter one is what I use for geodatabase output. Hope it helps. Update 2. A simplified worksapce and relative data is attached.

How to find loop in Line Layer, attached is screen shot

490

6 years ago

johnglickContributor

asked in Authoring

Reference an s3 bucket as a FME server parameter?

Hi, is there a way to reference an s3 bucket using an fme server parameter so that we can read or write directly to/from the bucket? I know I can use the S3 uploader, but it would be really handy to be able to use the feature writer instead.

Get objectid of currently written features for further processing in shutdown script

I'm writting features with FME to an Oracle database with ArcSDE. For further processing (e.g. call of external python functions) I need to know the objectids of the written features within a python- or tcl-shutdown script. Is there any option to get these information?Thanks for your ideas!

200

6 years ago

nicholasContributor

asked in Authoring

Fanout MapInfo writer one folder, multiple tables

I have a dataset that is clipped to LGA boundariesI want my output to fanout to mulitple MapInfo tables, each named after an LGA, all within one folder.How do I do this?I am using FME 2018.1.0.0

Run custom transformer end to end in a loop

Hello,My simplified flow is that I would like to take some features from DB. Next for each one do some processing using custom transformer (downloading for each some additional data etc.) and then save it to the zip file. Is it possible to do it using custom transformer one by one I mean take one feature, then execute for it custom transformer, save results to zip and then take next one?Right now it waits for all features to be processed and at some point I have out of memory exception :/It would work if I would submit separate workspace from my main workspace to do that but it isn't the best solution for me.

6 years ago

koenvdwContributor

asked in Authoring

how to calculate point perpendicular to nearest line from polygon with fixed distance

HiDoes somebody know if this is possible (check picture)? I have a shapefile with polygons (BLACK), a shapefile with points (RED) and a pointcloud.I want to make a donut (GREEN) around the polygons and clip my pointcloud with them. So I have pointclouds around my polygons. That is what I have so far. The next bit is more difficult and why I need help.The points around the polygons should be moved perpendicular to the nearest line from the polygons and with a fixed distance from the polygons (PURPLE). Once I have those positions, I want a buffer around them and calculate the average height from the points from the pointcloud within the buffer. The average height should be written in the original shapefile with points (RED).Some thoughts:split the polygons into linessearch for nearest neighbourif the directional coefficient is m then the perpendicular directional coefficient is -1/mintersect perpendicular line with line from polygonoffset with fixed distance from intersect and along per

femoContributor

Hi i am processing data using 5 workspaces. One Workspace calls another by means of the Workspacerunner. The 5 workspaces create 5 logs i want to Analyse. Therefore the last of the 5 processes call a Workspace that read and processes the 5 logs. However, this last Workspace processes more than half a Million records. It seems than the 5 logs are processed before the last log is completely written. If i Limit the Features to read it works fine. Any ideas?

6 years ago

involver

asked in Authoring

How to run the same workspace many times with different parameters?

FME Server does not recognize linked custom transformer in custom transformer

I have a Custom Transformer that I am using in a number of scripts, that I use as a linked transformer in a number of scripts. This transformer contains another custom tranformer that is embedded.When I open the top-level Custom Transformer in FME Workbench the contained Custom Transformer is shown disconnected with no properties, and there are various errors because of this. The funny thing is that the scripts still work when run from the command line, and if I look in the FMX file for the transformer I see that there are still references to the internals of the embedded transformer. The issue seems to have started after a recent major edit. Unfortunately there were a lot of changes in this edit to both the top-level and embedded transformers so it is impossible to pinpoint anything specific from that.Any ideas how I might recover the embedded custom transformer?This is on FME Workbench 2018.0.0.0 Build 18284.

6 years ago

lianaolianov

asked in Authoring

Rounding the elements of a list

Hello, I have a list of numbers and I wanna round all its elements to a precision. How it can be done in FME ? Thank you very much in advance.

180

6 years ago

Page 65 / 122

Badge winners

anteboy65has earned the badge Welcome Back
tamadurhas earned the badge Welcome Back
buraskyhas earned the badge Integrate Spatial Data
langdonmshas earned the badge Student (Grey)
langdonmshas earned the badge Teacher (Grey)

Show all badges

30,364: 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.