Authoring

Good morning!I want to execute a Python script that rebuilds the spatial index of a feature class. I have followed the steps described here: https://knowledge.safe.com/articles/1190/using-a-python-startupshutdown-script-to-perform-g.htmlThe script I use is the following:# -*- coding: utf-8 -*-# ---------------------------------------------------------------------------# test.py# Created on:#   (generated by ArcGIS/ModelBuilder)# Description: # ---------------------------------------------------------------------------# Set the necessary product codeimport arceditor# Import arcpy moduleimport arcpy# Local variables:TEST_sde = "C:\\Users\\TestUser\\AppData\\Roaming\\ESRI\\Desktop10.2\\ArcCatalog\\TEST.sde"

Hi,I have created a FME workbench v2017 (on my development machine where i got oracle client installed) in which i am reading and writing data into oracle database tables.Now I need to publish this workbench as a 'jobsubmitter' service into FME server and schedule it to run.This FME server doesn't have oracle client installed.Just wondering is there a way i can connect to the database without oracle client? I mean can i use JDBC to connect oracle database? If so how could i achive this?Any response would be helpful.Thanks,reachmj

I want to use the rastermosaicker with parallel processing. Because the process takes days. So I want a common ID where the Y-coordinate is the same. (see ). What is the best way to solve this problem?

Hi, I have this terrible simple workspace, of only a creator, a parameter fetcher and a logger. Next to it a floating number parameter. When I post it to one FME Server site, it runs (JobSubmitter) fine and when I run it again, it remembers the value I entered before. When I post it to another site, it still runs fine, however, it doesn't remember the last value I entered for the parameter. What is wrong with the second setup? I suspect it has something to do with the rights of a user in the folder for the jobsubmitter service. Or it has something to do with cookies, or a secure http and Active Directory setup. How to keep the nice behaviour remembering the last values supplied?

How to use FME Jobsubmitter with one token without username and password ? thx

In my workflow I have a main process which executes other workspace runners and passes published parameters of the main process to the workspace runners. One of these parameters is a text separated by comma (student_list) and when it is passed to the workspace runner is not getting interpreted as a text, but as multiple parameters.This is the main workflow: When Student_List is passed to the workspace:StudentElegibilityProcess: {C:/Program Files/FME/fme} G:/Git/compass-fme/student-eligibility/student-eligibility.fmw --ScenarioGuid *** --OrgGuid *** --DbServer *** --DbName *** --DbUserName ** --DbPassword *** --AuditFile {G:\Git\compass-fme\student-eligibility//audit_eligibility.json} --ALLOWS_OUT_OF_BOUNDARY_TRANSPORTATION true --SOLVE_CLOSEST_FACILITY_BATCH_SIZE 100 --STUDENT_LIST 000157141 --000170660 000171155 --ZonesUrl http://*** --HazardZonesUr

Hello, I have this record: "50379(T)-50383(T)". What I would like to do, is to transform it into 5 records:- 50379(T)- 50380(T)- 50381(T)- 50382(T)- 50383(T)What is the easiest way to create this list? Thanks!

Tried to cancel jobs, getting: Error: java.sql.SQLException: COM.safe.fmeserver.database.FMEServerDBException: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.What to do?

Looking for inspiration for processing example below. Clearly can be achieved with a few conditional values, but what if there were more combinations (additional attribute pairs) - is it then time to resort to Python?A feature has three attributes (WDA, WDB, WDC) with either Y/N value Three matching attributes (MY_A, MY_B, MY_C ) containing numeric value 1 to 5If any combination of two or more WD attributes = Y then the equivalent MY values must have the same numeric value  PASS (always because only one WD is Y so nothing to compare) WDA = Y WDB = N WDC = N  PASS (MY_C is ignored because is WDC = N)WDA = Y WDB = Y WDC = NMY_A = 2 MY_B = 2 MY_C =5   FAIL (MY_C is ignored because WDC = N) WDA = Y WDB = Y WDC = N MY_A = 2 MY_B = 5 MY_C =2 FAIL (all three MY values should be the same) WDA = Y WDB = Y WDC = Y MY_A = 2 MY_B = 2 MY_C =5

How can we trigger workspaces one after another in FME server? Suppose we have three workspaces and these three need to be run one after another in sequence, published the three workspaces to fme server with success and failure topics for each script. while configuring with Notification or Subscriptions, unable to find any trigger to run next workspace. am i missing anything?

Hi all, I need to pass the named database connection to a custom transformer. The name depends on the input in an Excel file. In this Excel file, I have for example 'NE' and 'NW', which needs to be mapped to a Named DB connection. Neither in the AttributeValueMapper, nor in the AttributeManager it is possible to set a value of the Named DB Connection. Anyone an idea on how to approach this?best regards,Jelle

I’m finding a strange behavior on usage of custom Transformers I create. So, I created a CustomTransformerA with all the necessary default settings/parameters. I tested it, all good, results as expected, done …. Export as Custom Transformer (tried all insert modes. Embedded always and default)Starting a new workbench I can call and insert my CustomTransformerA from gallery and make it available on my new workspace.Then if I duplicate or insert again from gallery the CustomTransformerA it will be automatically renamed to CustomTransformerA_2, CustomTransformerA_3 and so on. All fine … multiple Customs, all different names.There is my problem now – Every time I do a change in any of the customs that were duplicated or inserted from gallery, the changes are replicated across all the copies. So, my goal to use CustomTransformerA is to remove duplicate work working in isolation to any other copy of it making it reusable in diferent scenarios inside sam

Hello everybody,i know it is possible to run a FME workspace by using a a batch file. But what is the command in the batch to run this workspace with prompt?With kindest regards,Felix

Hi guys,I'm stuck with one problem and looking for advice. I have two CSV tables. I'm trying to replace attribute values from first table with ones from second table. Let me try to summarize...Table no. 1Parcel number Use of land 1 101 2 101 3 201 3 210Table no. 2Use of land Description 101 House 201 Business building 210 ChurchSo, first table is organized by parcel number and there can be multiple uses of land. There is a more than thousand features in this table. The second table just adds description to the use of land identifier (house for 101 etc.) and has 103 different features.I need to replace Use of land attribute values in first table with Descriptio

How can I control the flow of features when I have multiple flows of data in one workspace?

@takashiI am merging a number of feature classes into one. I would like to test the featurecount written with featurecount read.I am using a FeatureWriter and a VariableSetter/VariableRetriever to get feature count written and read respectively. However in my tester, the variable set in VariableRetriever is not available in the Tester to compare against _total_features_written. Input -> VariableSetter ->VariableRetriever -> FeatureWriter ->TesterAny suggestions ?

I want to update Windows with the latest Security Patches but I want to make sure this won't change the behaviour of FME Desktop or FME Server. Is there anything that I should be aware of before applying the latest patches?

I have a spreadsheet with three sets of seven fields that need to be merged into three and make sure that the values from the other fields match up. For example, I have 7 ID Fields that have 7 Quantity fields and 7 Price Fields. These need to all merged into one ID field and one price field and one quantity field. I am not sure how to go about it other than copying and psting all the values into one field in excel. Any suggestion would be great. Thanks

Does anyone know what the 'rules' are for best practice sharing of named database connections? I'm seeing some very odd behavior that I can't explain.It seems that for example there was a name change for the named connections database between FME 2016 and 2017 from namedConnections.data to fme_connections.data, meaning that an old connection database presumably must be exported as XML and reimported to a newer FME before the connections can be used. So, its not possible to share connections between different versions of FME in an organisation where there are different FME versions installed.Also, I'm seeing connections that are created on one machine, that work fine when 'tested', when they are tried to be used on another machine in the same organisation and they are 'tested' a whole raft of errors come back and authentication fails. Interestingly the authentication errors mention FME Server and web APIs... Its super odd. At the mome

In my workflow I need to check whether multiple lines (paths) crosses within some areas (hazard zones). I'm doing this with LineOnAreaOverlayer, but it is too slow only with 17K lines and 8 areas. It has taken more than two hours and the process didn't finish (On the bottom of the workbench I get this message performing low-level intersection phase X%)I've read that I could enable paralellism with grouping. However, when I did this the process doesn't find any overlaping line with the area, when it certainly are lines that do it. How could I improve the performance of this process?

So I have a point shapefile of orthophoto locations with approx. 250 features in it with attributes. I also have a .txt file to use as a template. What I basically need to do is for each feature in the shapefile, I need to extract the attributes, do a find/replace in the template, and write out to a text file. Essentially it's just creating text files with metadata of each orthophoto in it, so I should end up with approximately 250 text files when finished. I'm not sure how to get FME to go through one feature at a time and write out to a .txt. Does anybody have any idea how to do this?

Hello everybody,in my workbench the scale of an output raster type feature should depend on an attribute RADIUS, which is defined as a numeric published parameter the user can manipulate. I realized that with a private parameter which is defined through a python script as you see below. I set the default value of the RADIUS attribute to '500' so the scale should be '4000'... But the script returns the value '15000'. I also tried to return just the value of the RADIUS itself in this script to test if the RADIUS value is still setted to 500 when the python script is running and it is! And the RADIUS attribute is definitely numeric. It has the type 'Number'. What could be the problem? I don't really know what to do.Best regards,Felixscale=0if (FME_MacroValues['RADIUS'] <= 500):    scale=4000elif (500 < FME_MacroValues['RADIUS'] <= 1000):    scale=8000else:    scale=15000return scale

I have configured a "master" workspace that runs 4 Workspace Runners sequentially. I run the master workspace from a BAT file via the fme.exe command line. When one child workspace fails, the parent workspace stops, but does not fail. The workspaces are linked together by the Succeeded port. The Failed port is not linked to anything. I imagine I should link it to something? If so what? Thanks.

Hi,We have installed FME 2017 and i have adjusted my model to the new transformers (not all) but when i try to run my model for a large set of data (worked fine in 2016) FME failes and in the temp folder he makes al lot of files like "FME_OBJC_STF_RPTree_1497357414998_4532_186" (52.0000 in the first 10 minutes) and he has done only 10 percent of the model.It happens while using the snapper...If i run my model whith less data he workes fine.We have already tried to enlarge the memory and added extra processors.Has somebody also had this problem?GrtjsNath.