Authoring

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

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?

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.

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,

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 

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

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.

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

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.

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!

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

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.

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

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?

It is similar to https://knowledge.safe.com/questions/30005/how-to-run-same-workspace-multiple-times-with-diff.html, but not exactly.I would like to run the same workspace a number of times using different GDB as input and producing different outputs. For example, GDB1 as input produces 1.dwg as output. GDB2 - 2.dwg.Thank a lot in advance! @ blueinc

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.

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.

I would like to use HTTPCaller to grab the contents of a file from a webserver and store it in an attribute as a binary and then use a FeatureReader type of transformer to parse the binary attribute. I thought I was able to do this before, but I can't figure out how I may have done it.

I am using a FeatureReader to read a data source (e.g. SHP file) and then immediately writing it to postGIS using a FeatureWriter. Because the input is supposed to be agnostic as to the exact data being uploaded, I am using the "single output port" option and outputting the results via the Generic port, which is being directly fed into the FeatureReader.In FME 2017 this worked. In 2018 I am having a problem - the writer only works correctly if the destination table already exists (i.e. with the "Use Existing" option).If I use the "Drop and Create" option in the writer, all I get is the geometry column in the destination table. The other columns don't come across.I saw a forum post where a user was advised to use a dynamic writer and to pass the schema in like this:https://knowledge.safe.com/questions/46483/generic-attribute-from-featurereader.htmlThis works, but has one major annoyance - I lose control of the name of the output table - I have to use th

I'm working on a workflows that will run on my FME Cloud and is started by a REST command. The idea is to develop a database driven pdf creator that generates x amount of pdf pages and bundles them a zip. The setup of my workflow is as follow(or should at least work like this):Step 1: Rest command is send to the cloud with a TaskID and starts the workflow 1.Step 2: Workflow 1 will get the information in our database that is connected to the TaskID. The table that is fetched contains an x amount of PageID's (depending on how many pages is needed) and each PageID contains the information that is needed to set the paper size, geom layers, WMS stuff, graphs and tables, name of the PDF and other information that is needed.Step 3: For each PageID athere is one line submitted to the FMEServerjobsubmitter (in sequence and waits for job to complete) with the information that is needed to start workflow 2 that builds the pdf out of the table that is generated in step 2. For each PagaID a

Hi,I'm fairly new to using the dynamic output, but needed it for converting a set of shape files to SQL Server.The writer has a "Table Qualifier" field, which in static writing designates the target database schema.However, when used in dynamic writing mode, the value entered here is completely ignored, and the tables are all created in the "dbo" schema.Is this WAD og a bug ? And if WAD, is it possible to set the database schema anyway ?CheersLars I.

Hello, I have a list called ''list'' of variable length depending on features. I wanna assign as an attribute to each feature ''list(0) ; list(1) .... list(lenght(list))'' I tried writing a loop on the attribute manager but I didn't know how to use it well Thanks for any possible help :)

I would like to use each polygon of a shapefile sequentially to clip a big raster then coerce that raster clippee to points and do a PointOnAreaOverlayer to get _overlaps for each polygon (in a new field in the polygons shapefile). How would I go about doing that ?