Authoring

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

I have a simple FME workbench that loads two shape files into an ArcSDE feature class called LEXCO_LEASE_2. The feature class was versioned and the process ran very slow. To speed up the loading,  I unregistered the versioning in ArcCatalog for this feature class without keeping any edits and change the workbench SDE Transaction Type to TRANSACTIONS. But the workbench failes to run with this error:  An error occurred while attempting to open an insert cursor on the table 'LEXCO_LEASE_2'. The error number from ArcObjects is: '-2147216556'. The error message from ArcObjects is: {Objects in this class cannot be updated outside an edit session [SDE_GOM.LEXCO_LEASE_2]}    I then re-register the versioning, then the workbench runs fine (but very slow).    Anybody know how to fix the error without re-registering versioning for this feature class?    Software Versions:  ArcGIS Desktop 10.0 SP3  FME Desktop 2012 ESRI Edition SP2      Allen 

Hi,I am trying to take advantage of the Direct URL feature. In my use case, I am including links in messages such as emails, where if the user clicks it, it runs a workspace on FME server with the correct parameters that calls a REST API to create a new project on a particular server. The user gets a summary screen in a web browser that simply reports whether the workspace ran successfully or not, but does not relay any other information. It also asks the user to read the logfile for more info., but there are no logfile links on this page. Here's an example in FME Server 2017.1: In the above case I added a Terminator so that if the feature comes out of the <Rejected> port of the HTTP caller, the workspace stops and results in an error. In this case I tried to create a project that already existed. Now the workspace does have this exact information in the response body from the server that it interacted with, but we have no way to route this information to the resulting summar

I want to dynamically write out new files based on a set of input shapefiles. I want this output to be an exact copy of the input data except in a different format. I know that dynamic mode should work well for this type of workflow but I am getting lots of extra attributes in my output. It also seems like the schema being created contains all the attributes from all of the input shapefiles combined! What am I doing wrong?

I have a copper cable table which has attributes of startjoint and endjoint. I would like to build a cable path from the lead-in cable to the copper pillar. The logic to build the path is based on the startjoint and endjoint. The cable whose endjoint = startjoint of another cable is the upstream cable. By joining them, a complete path can be built. Due to the uncertainty of the numbers of cables between the lead-in to the pillar, I would like to use Loop to achieve this. I have used inlinequerier to join the cables and any result returned will go back to the loop. The loop will stop when there is no feature returned where endjoint = startjoint. However, the iteration only occurs 1 and no feature is returned for iteration even there are 11 features output from the result. Any suggestion what is the best approach to achieve this? Thanks.

Hi,I'm starting to getting know FME, and I have such problem:I need to sum occurrence of values from one table within ranges from another one. Ranges needs to be taken from another table because they're changing sometimes and there is a lot of them. I've created min and max column but I don't know how to deal with searching and counting. I want to know how many records is in every range.EDIT:I've added example of my data and fmw.

Hi all,I have an attribute table in the following format:localitycountmonthbright123janbright456febbright789marmyrtleford987janmyrtleford654febmyrtleford321marI would like to change it to the following format:localityjanfebmarbright123456789myrtleford987654321I have a convoluted process using an attribute filter and a bunch of statistics calculators but it's not very scaleable. I was wondering if anyone can point me in the right direction for an improved solution!Cheers,Barrett