Authoring

I am using a Condition Statement in the AttributeManager to check if the attribute ends with a letter. Using [a-z] does not seem to work and I am assuming it is because the test sees it as text not a Regular Expression. Is there a way to get this to work or do I need to have a Test Clause for each letter of the alphabet? Regards

Hi all,   I am using FME Workbench 2018.0 Build 18284. I would like to run an update to sharepoint list on Sharepoint Online.  Readers:Sharepoint list using (http link to the sharepoint rather than https; using https would run into an "Error message 403- error authenticating via SAML" (log-in details are correct)Excel spreadheet with new lat/lon values I am using a feature Merger to update lat/lon column in sharepoint list Writer the same Sharepoint List - when specifying the url to http://XXXX.sharepoint.com/Projects/XXXX the translation runs into a Client-side error: '405 Client Error: Method Not Allowed for url: https://XXXX.sharepoint.com/Projects/XXXX/_api/contextinfoI have not specified the above https url ending in _api/contextinfo- when specifying the WRITER url to https the translation runs into the above 403 SAML error  Do you now of any ways to work around these errors or are they possibly solely due to my sharepoint security settings?  Thanks a lot for

For all transformers it is possible to change the 'Transformer Name'. Why is not it possible for the FMEServerTransformers (at least in the version FME2016)? Is there a specific reason here? I'm using the FMEServerJobSubmitter in my workspace very often, so i would like to be able to customize the name accordingly.

I have a workspace with a dynamic writer writing to postGIS. The source for the writer is a csv spreadsheet which is loaded from a workspace resource using schema (from table). The reader reads a table named "test", and the writer outputs to a table named "Mapped". It is essentially based on this tutorial:https://knowledge.safe.com/articles/1046/dynamic-workflow-tutorial-destination-schema-is-de-1.html except that I don't use fme_feature_type as the writer table name.This is my csv source file:The columns all appear to be mapped correctly.This is the writer:This was working in FME 2017, but since I upgraded to 2018 it no longer works. I get an error message saying:Cannot find a matching schema named 'Mapped' in the known set of schemas: ''. Known schema sources are: 'Schema from Schema Feature, SCHEMA_FROM_TABLE_1'. Please verify writer feature type configuration.Then there's a message saying:POSTGIS Writer: Fanout for feature type &#

I try to run example from this article: https://knowledge.safe.com/articles/1112/live-spatial-dashboard.html on default installation of FME server 2017. I get the following error:WebSocketSender: Attempting to connect to host '192.168.99.100' on port '7078'WebSocketSender: Successfully connected to host '192.168.99.100' on port '7078'WebSocketSender: Performing handshake with remote hostWebSocketSender: Failed to perform handshake with remote hostWebSocketSender(JavaFactory): A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for details2018-03-12 13:00:56| 0.9| 0.0|ERROR |192.168.99.100 is the ip address of FME server. Does anyone know how to connect to websockets on FME server?Thanks for any help.

I'm writing a code to run workspaces in python but I think that I found a bug with the FMEWorkspaceRunner.getPublishedParamNames function. This function is returning the private parameters from a workspace and it shouldn't.import syssys.path.append('C:\\Program Files\\FME\\fmeobjects\\python27')import fmeobjectsrunner = fmeobjects.FMEWorkspaceRunner()print runner.getPublishedParamNames('test.fmw')The output: ['a', 'b', 'privateparam']"privateparam" is private and it is not checked as published in the workspace

I am currently using FME Desktop 2017.1. My question is: is there a way to set up a workbench so that whenever I add a new reader, it will automatically check off the FME_FEATURE_TYPE within the Feature Type Format Attributes?Thank you for your time.

Hi guys,We have a routine job that reads 5 million records from a Oracle non-spatial table (runs on fmeserver, 2017). During a recent run it completed successfully but only processed 2 million records. The log looks normal, it is as if the source db only had 2 million records - which is not the case when checked. Normally we would get a oracle/connection error if there was a network failure - the job does take a while to run. Has anyone seen behaviour like this before? Thanks!Grace

List one contains the attribute namesIndexAttribute_namejoin0Incidenttype11keyword12region13regionrefinment14location15reporting16verified17closed18advisory19interest110notification111security112status1 List two contains the attribute valuesIndexAttributejoin0enviromental11storm 12north america13canada14eastern ontario15jtfc16false 17false 18xxxxxxxx19high110stratadvisory111unclass112initial1 The goal is to append the two lists to the feature below.joinmodtimetaskoriginlonglatnametypestatusstarttimeentid118:06jttr44.245707-77.50707stormeffectex0.010x0008e I have tried various transformers to create a new feature using the two lists and then merging the features without success.

When using the E57 writer, I've been unable to assign specific names to the scans in the point cloud file. In my case I only have three names, and those are in attributes waiting for a place to use them. It seems the writer uses the file's basename for the first scan, and then appends _001, _002, etc. to any others. I'm hoping there's more flexibility and that some smart person will tell me where to find it. TIA

Attempting to edit a workbench file this morning but the file in question won't open.  Choosing file->open and selecting the file does nothing - no error, workbench remains blank, wording in title bar still displays Untitled - NONE, file name isn't in the list of recently open files.  The script itself works fine and runs daily via a .bat file  We have upgraded to the latest service pack since I last looked at this file but it only seems to be this file that is affected.  Is there anything I can try to get this file to open up in workbench?   

Reading a WMS using Feature Reader WMS, search envelope based on an bounding box "Envelope Intersect", however the resulting Image is just the overview image, how can I make sure i get the image clipped to the best resolution per the bounding box?what I have tried alreadyensured coordinate systems are the sameattempted to use ImageFetcher, no luck with querying based on coordinatesverified the WMS is ok, by viewing in OpenLayersAny help would be great, Thank you ;)

I'm new to FME.I have a text file listing about 90 features from an ESRI enterprise geodatabase. I want to convert each listed feature from the geodatabase to its own geojson file. What's the most efficient way to do this? The only way I've found is to make a separate reader and writer one at a time in workbench, which isn't ideal. Is it possible to have FME read the text file to get the parameter names then make readers and writers from that, perhaps using python?

Hi I have made a second shared resource folder in the fmeServerConfig.txt file.SHAREDRESOURCE_TYPE_8=FILE SHAREDRESOURCE_NAME_8=FME_SHAREDRESOURCE_DATAADA SHAREDRESOURCE_DISPLAYNAME_8=DataADA SHAREDRESOURCE_DESCRIPTION_8=This shared resource is the Server data directory SHAREDRESOURCE_ISMIGRATABLE_8=true SHAREDRESOURCE_DIR_8=G:/apps/ada SHAREDRESOURCE_SECURITY_DEFAULT_ROLES_8=fmeadmin|fmeauthor|adaauthor SHAREDRESOURCE_SECURITY_DEFAULT_OWNER_8=adminI can see the resource in the GUI and give authorusers access etc. But I cannot figure out how to access the resource as an FME Server Parameter. I cannot add a new FME Server Parameter in FME Desktop. And if I just use the parameter FME_SHAREDRESOURCE_DATAADA I get an error when I run the workspace on FME Server:Undefined macro `FME_SHAREDRESOURCE_DATAADA' dereferenced in file `BI\\ADADataSharetestd\\ADADataSharetestd.fmw'Thanks,Annette

Hi all Im trying to super optimize a workbench I have that reads a bunch of data from a mssql database, the workbench has 2 published parameters that i use to set years in the "Where" clauses of readers. both parameters have years as values, the parameters are$(year)$(year_minus_1)Is there any way to base the parameter $(year_minus_1) on $(year) and then minus one year. if the value of $(year) is 2017 the value of $(year_minus_1) should be 2016.Is it possible to do this so you only have to input 1 parameter?I know its not a big thing but it would make the running of the workspace every year easier for other people running it.

Hi guys,I have a problem loading arcgis layer to the workbench. After licence is checked out, I've got a pop up error 'FME has checked out an Esri license. The product checked out is 'ArcInfo'. Error occurred while attempting to open the dataset 'C:/Users/Downloads/Albian.lyr'. Did you come across this error before?Kind regards,Aleksei.

HelloI have a workbench which is launched from FME server by an end user, let's call it Workbench_A.This workbench has an FMEServerJobSubmitter to call another workbench, Workbench_B.Is it possible to somehow have the FMEServerJobSubmitter in Workbench_A inherit the credentials that were used to call Workbench_A, for using when calling the subjob Workbench_B?I know of the FME Server parameter FME_SECURITY_USER, but I do not know of any password parameter. My alternatives are 1) hardcode a username and password on the FMEServerJobSubmitter, and2) add Published Parameters to Workbench_A to have the end user provide their fme server credentials for use in the FMEServerJobSubmitterBoth of these are undesirable as option 1 has the usual issues surrounding hardcoding credentials anywhere, and option 2 could be confusing to the end user.

Hi,I need advice. I would like to dynamicaly read XML fiel using XFMAP to create feature types and extract values. Here is my source XML:<?xml version="1.0" encoding="UTF-8"?><b:DataTableList xmlns:b="http:\\wwww.b.com">    <b:DavkaTable>        <b:Name>dtCisTriedZnakKolaje</b:Name>        <b:RowList>            <b:Row>                <b:ColumnList>                    <b:Column>                        <b:DataType>System.Int32</b:DataType>                        <b:Name>C_TRIED_ZNAK_KOLAJE_NI_ID</b:Name>                        <b:PrimaryKey>true</b:PrimaryKey>                        <b:Value>1</b:Value>                    </b:Column>                    <b:Column>                        <b:DataType>System.String</b:DataType>                        <b:Name>KOD</b:Name>                        <b:PrimaryKey>false</b:PrimaryKey>                

Hello all We are using FME Desktop SP14 and have a project where we use quite a lot of input tables (aprox. 20-30) from different sources (GE Smallworld, MS Access and Oracle through ODBC) to one MS Access file. The full process uses 3 different frameworks that must be executed on the correct order and with several user parameters (ie. initial and end date). We looked for some method, easy for an end user, for running those frameworks. At first it seemed promising to use the transformer Workspacerunner. But with several tries detected that the reader from SmallWorld seems to become very slow when interacting with this transformer. Tried to implement the process on a batch file and, after solving some issues from the use of dates, it worked like a charm. So, the big question is, the Workspacerunner transformer was never intended to be used this way? perharps it is something that processes the features on a one-by-one basis (it seemed to us that this was what crushed the Smallworld reade

I am trying to set up the drag and drop example found at https://playground.fmeserver.com/javascript/server-uploads/upload-file-drag-drop/I have added the missing header to the list of allowed headers and rebooted the server but I still get the error.

Hi,I'm looking for a tool or approach on how to document an FME workbench. I got a workspace from colleague which perfoms multiple calculations. I need to document these calculations externally. I would need to go through all transformers and write down what happens there. Is there any tool which could help with that? Could this be done using Python - iterate over all transformers and get the details of each transformer in a readable form?Thanks, Rob

HelloI have a workbench that reads a dataset from a smallworld database and writes it to a ESRI File Geodatabse using the api writer. Everything works properly but it runs very slowly. I have noticed that FME is reading in all the features( > 1 million) and then writing them. Is there a way to get the features to write as they get to the writer? I have played around with the "Features to write per transaction" setting but this doesn't seem to help.

I'm using the BoxConnector transformer to download several hundred XML files which are spread across a large folder structure.(Using this https://knowledge.safe.com/questions/45772/how-can-i-download-a-file-from-boxcom-google-drive.html as a starting point) Many of these files have the exact same file name, so when downloading locally they are overwriting each other. Is there a way to add a counter or change the file attributes at the point of download to generate a unique file name or put them into individual folders?

How do I generate unique ids from existing and future object ids within a 50000 range and 30 diffattributeerent s within a 50000 range.There are 30 different attributes and each should be within a set block; i.e pt=10000; rt=20000;st=30000, etc. These are within an ESRI File GDB.Please help.@useytkaziev

Hi,I have a master workspace which calls inside another FME Workspace with the WorkspaceRunner Transformer. This transformers are set it up with relative paths. I'm trying to call this master workspace with Python, but this is changing the FME_MF_DIR making it point to another disk in my machine E:\\TEMP. This is making all my process fails because it cannot find the other workspaces.2018-03-09 15:00:56| 0.2| 0.2|INFORM|FME 2017.1.1.1 (20171014 - Build 17652 - WIN64) 2018-03-09 15:00:56| 0.2| 0.0|INFORM|FME_HOME is 'C:\\Program Files\\FME\\' 2018-03-09 15:00:57| 0.2| 0.0|INFORM|FME Desktop Professional Edition (floating) 2018-03-09 15:00:57| 0.2| 0.0|INFORM|Permanent License. 2018-03-09 15:00:57| 0.2| 0.0|INFORM|Machine host name is: rdelaparral 2018-03-09 15:00:57| 0.2| 0.0|INFORM|START - ProcessID: 13804, peak process memory usage: 32536 kB, current process memory usage: 32536 kB 2018-03-09 15:00:57| 0.2| 0.0|INFORM|FME Configuration: Command line ar