Authoring

Hi, I have a attribute field that contains decimal values. Eg: 84.2, 86.0, 85.1, 95.3, 94.3, 106.6.I would like to create a new attribute field with an integer value that represents the different groups based on the proximity of values. ie: The records 84.2, 86.0 and 85.1 would have each have a 1 in the new attribute field; 95.3 and 94.3 would have a 2; and 106.6 would have a 3.I can't work out the best way to do this. I tried rounding the values but that doesn't guarantee that items which should be in the same group will round to the same value.Any advice?I am using FME Desktop 2016.Thanks

HiI have a simple spreadsheet that has a month column in text ie January, February.How do i convert this to a number? So for January it would be 01, February 02 etc etc.I've tried using AttributeValueMapper with the following source value;@Value(Month)='January'and a destination value of 01but no luck.Would be grateful if someone could suggest how i can do thisthanksSimon Hume

Hi,I would like to define a private parameter based on a publish parameter. My idea is to use a python script that should return the desired private parameter.import fmeobjectsif (FME_MacroValues['publih_parameter'] == 'val'): private_parameter='val_'elif (FME_MacroValues['publih_parameter'] == 'wal'): private_parameter='wal_'else: private_parameter='zal_'return private_parameterBut this is not working. Any ideas?Thanks

Hi,We have a workspace file with a size of 2140kb, when we tried to upload to FME server we are getting a publish failed error:Publish failed - FME Server encountered an error.Request to https://myserver/fmerest/v3/repositories/dev/items returned status code 413.HTTP Error 413 is Entity Too Large, where can I change this restriction on FME Server?Thanks.

Hi - I'm attempting to load the Ordnance Survey Addressbase csv files into an MSSQL database and get the above error message, with subsequent FME stops working error messages.It has successfully read and written over 43 million records, but then seems to fall at this hurdle whilst trying to Optimise Memory UsageAm I simply running out of local storage for Temporary files ?Or is it more complicated than that ?Has anyone successfully managed to use FME to load GB wide Addressbase Premium into a MSSQL database ?Thanks,Bruce

Hi ! I have a simple process to query a SQL Server database, create a json, then pass each feature to a python script.My issue is that the JSON Templater's ram usage grows and grows, storing features even when they have already been passed to python (up to 64Go for about 300000 lines).How can I split my features stream, in order to work with n-sized batches (e.g. take the first 20 000 features, run the json templater and python, free any ram usage, and then take the 20 000 next features to do the same thing.)

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"# Process: Rebuild Indexesarcpy.RebuildIndexes_management(TEST_sde, "NO_SYSTEM", "TEST.DBO.FC_TEST", "ALL")But everytime I run the the FME project I get this error:Python Exception <ExecuteError>: Failed to execute. Parameters are not valid.ERROR 000837: The workspace is not the c

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://*** --HazardZonesUrl http://**r 2>@1

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 same workbench. Somehow there seems to be

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 Description attribute values from second table so the first table looks like:Parcel number Use of land 1

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