Authoring

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'T

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>                        &lt

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 wh

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 Co

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 2

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 i

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

Hi all,At the moment I have the following situation. I have a regular, 6*6 grid, from which the gridsize depends on the outcome of a formula which includes several variables: 1. The volume of the underlying pile of sand 2. The surface area (only in xy-direction) from the pile of sand. In this case, they can be assumed as constants, since the pile of sand stays the same.The model now calculates the maximum grid size based upon those constants, which is projected over the pile of sand, resulting in a 6*6 overlying grid as mentioned.Next step: the calculation of the thickness of the sand at the grid points. This is where drills should be taken, until the surface underneath the pile of sand is reached. This is called drill depth. The sum of the total drill depth should be 100m or above (by law), but as small as possible to reduce labour costs.Problem: when I run the model and the total drill depth is e.g. 96m (as in this example),

Hi everyone,I am trying to create a dynamic Workflow with a SDF3 Reader and Writer. The idea is to reproject sdf-files with different schemas. The problem in that workflow is that the SDF3-Writer expects an identity column, but the ID-column names from my sdf-files are not equal. Because of that I can't use a static attribute. In addition I don't want to create a new attribute as identifier in the output-file.Is there any way to get the name of the ID-column of the sdf-file dynamically?kind regards and best wishes, Marvin

I'm trying to Dynamic writer to a dataset within an arcgis gdb. I set my fme_feature_type to dataset/fuse but it will create a fc at the root directory named dataset_fuse. I then discovered there is a "feature Dataset" field to fill in ...and i did with datasetThen it does create a file named dataset_fuse within the dataset. But it doesn't use my schema. if i alter my fme_feature_type to just fuse then it says it can't find the schema and doesn't write.this is my gdb setup:arcgis.fgdbdatasetfusethank you

I am attempting to modify a workbench that a former co-worker created, and they password protected the workbench. Is there any way at all to decode the password for the workbench? Getting in touch with the co-worker is not an option

Why does the ESRI-JSON reader automatically expose all of the attributes in the fields list but the Feature Reader set to ESRI-JSON require me to interactively set the attributes that are to be exposed? Why can't the Feature Reader work the same way as the Reader?

Hi, I have dataset which consists of about 40 millions parcels. Some of them have the same identifier and I would like to join them into one area (with dissolve lines). I would like to use custom transformer which is very similar to https://knowledge.safe.com/articles/47216/using-arcpy-for-fme-feature-processing.html. I have FeatureWriter, PythonCaller and FeatureReader Transformer and I have a problem with keeping attributes after FeatureWriter transformer because in the PythonCaller Transformer I would like to use Attribute Accumulation (…”AREA SUM; CITY FIRST; POSTCODE FIRST; COUNTRY FIRST”…). I will need these information as a final score. Maybe is here someonebody who could help me?

Hi all,I'd like to know if there is a way to use conditional value mechanism with a group by parameter.Imagine following case:I have a published parameter with values 0 and 1. My features have the attributes A, B, C and D. When I select 0 for the published parameter I'd like to have A and B attributes as Group by attributes, and when 1 is given, C and D shall be set.I know that I could use a tester and route features accordingly to differently set transformers, but I'm using the Group by setting on various locations. To keep the workspace readable this approach would not be applicable.