Authoring

Hi,I'm investigating the impact that the move to remove https support for TLS1.1 and below may have on my processes running in fme desktop and server.Does anyone know what http clients the httpcaller uses?I assumed it was the client installed on the OS, but i'm running fmeserver/desktop on a windows2008R2 server with IE8 installed. If i look at a TLS1.2 only site using IE8 on this server it complains like mad because i'm trying to use TLS1.0, but if i use the httpcaller from inside fmedesktop and server it connects just fine using TLS1.2. Leading me to deduce FME installs and uses it's own client. I would like to know what it is. (libcurl_fme.dll probably has something to do with it? i also noticed an ssl certificate in the install dir.)It must pick up internet proxy details from the default browser though right?regards,Nick(specifically i'm currently running FME 2015.0, but i'm looking to upgrade to 2018.1)

Hello There we are looking to update a table with the new attribute called layer the value will be populated by searching a keyword into the attribute ( Type ) that should contain the keyword in the lookup table there is w way to do it by using the conditional value on the attribute value and writing all the key word there, but this will be a long task and not simple to maintain. since data is so bigwe are looking to use the existing excel to maintain the lockup and then search only the keyword into the value of the attribute Any suggestions?Table Dig_lcn Type Status 125 Electric network open 126 New Phone line open 127 sewer conduite intalation closed 128 Mv electric ntework closed 129 sewer renwell conduct openif the attribute value containe the keyword in the lockup table Lockup ID layer 1 Electric 2 Phone 3 sewerthen we get this Final result Dig_lcn Type Status ID L

i am having trouble "reading" the grb2 files from the workspace runner. i can run the FME script that reads and processes the grb2 files with no issue, but when i try to call that FME script from the workspace runner FME script, nothing happens. any assistance would be helpful!i can zip up and provide the workspaces and underlying data if needed.thank you

Hey guys,I have a dynamic feature reader that reads and SDE database, one of the fields is a date time field called UFI_CREATEDWhen i use a standard SDE reader this works fine on the dynamic writer. But when I use the feature reader, it appears that its sending the full attribute into UFI_CREATED.full and date attribute called UFI_CREATED. When I try and write this I get an error saying thatA feature, of feature type 'PROPERTY', had an invalid time component for its time/datetime attribute 'UFI_CREATED'.This is because its expecting the .full attribute but dynamically its getting the shortened one.I could change all the attributes that I think might be affected manually back to non full, but this defeats the purpose.Why is it mapping it like this? And is there any way I can prevent this from happening.Regards,James

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!

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

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.

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!

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

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?  

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