Skip to main content
  • EN

Best Answers

10389 Posts
tris_w
Contributor
tris_wContributor
asked in Transformers
FME server engine crashes using ESRI ArcGIS Desktop python interpreter

We've just upgraded an FME server from 2018.1 to 2019. When running any of the workbenches that have the python interpreter set to "ESRI ArcGIS Desktop (Python 2.7)" the FME engine mysteriously crashes and restarts the job when it hits the python code. I cannot find any reason for this. If I switch it to the Python 3.7 interpreter the workspace fails with a python error, which I'd expect because its the wrong python version, but at least the server engine doesn't restart itself. Has anyone seen this behaviour and any idea what could be causing it? Using 64-bit FME, 64-bit python and 64-bit ArcGIS.

281
H
C
c_net4s
asked in Transformers
Coordinate reference system is read wrongly for WFS

Hi there, We have a a problem reading a WFS with FME Workbench 2019.0. (ArcGIS Pro). We're using two datasets, If we check the data in ArcGIS Pro both datasets have overlap and the same coordinate system: When we read the same data in FME using the default coordinate reference system, we see the following: According to the translation log the following happened:FME Configuration: Using ESRI Reprojection Engine CS-MAP Reprojector: Transformation will be automatically selected for 'LL84' -> 'EPSG:23031', and is not guaranteed to remain the same in future releases of FME Reprojector: Using transformation `ERP50-W_to_WGS84,Inverse(Multiple Regression)' when reprojecting from LL84 to EPSG:23031 We tried to use the Reprojector and the EsriReprojector to change the coordinate reference system without success. Also changing the coordinate reference system in the reader itself was not successful. Help or advice would be highly appreciated. 

972
C
E
ev2019
asked in Transformers
Add until a certain value is reached

Hi there! I am working on a specific analysis. This analysis needs to calculate 13 000 ha of parcels (area) randomly and then assign a new attribute value to this. Right now I have the following workflow:I thought I could make this work by calculating the percentage and then use the Sampler to randomly select parcels, but this doesn't work because the sum of ha does not add up. What I am looking for is a tool that allows me to use the following formula:"Random amount of parcels added up" = 13 000 haSo I guess it is a randomized sampler using a certain value based on attribute values. Does anyone have any idea how to do this? Thank you so much in advance!

352
ebygomm
Influencer
lambertus
Enthusiast
lambertusEnthusiast
asked in Transformers
Regular expression in combination with else/if construction

Hi guys,I have a table with an attribute 'Ingebruikname'.This field contains a year, month and day and info in hours. For example: 2019-01-11T13:05:00.000. I created a regular expression to select only the part with information about year, month and day. Like:2019-01-11T13:05:00.000I would like to get my attribute 'Ingebruikname' updated to records with only date infromation as shown in bolt. Records with no data for 'Ingebruikname' should be included as well and left empty.Do you have any ideas how to solve?  

713
takashi
Celebrity
S
sandry
asked in Data
Missing attribute AIXM5.1 to gkpg

Hi there, I've a problem with AIXM data. I try to translate AIXM data to gkpg (he problem is the same with another writer format : shp, postgis...). It only works when I translate AIXM to gml ............Some attributes are missing like the information regarding the volume information for the Airspaces (upper/lower limit....).What is the setting to get all the attributesCan someone help me please ?

71
deanatsafe
Safer
michaelbreen
Contributor
michaelbreenContributor
asked in Transformers
Dynamic Multi string replace

Hi community. I am looking to improve some workbenches and have them slightly more automated.The one I am currently working on revolves around some height of building data and is extracting the class from a string (example below). Currently I am using the AttributeValueMapper to convert this out manually but would be fantastic if there was a way to do this without setting it manually (if new data/classes are added we don't need to come back in and edit the Values to map.This is a screenshot of what is coming out of the AttributeValueMapper. The Condition attribute is the Source Value and the lay_class attribute is the destination value.The class I am extracting is the capital letters (one with number, but there will be more in the future) towards the end of the string. I know there is a regex expression to extract uppercase letters which is the closest to an automated solution that I have found (the condition includes more than one uppercase character) so it may be a combo of that

605
bwn
Evangelist
f.kemminje
Contributor
f.kemminjeContributor
asked in Integration
How can I extract total transfer time from "http caller" transformer

I want to write "total transfer time" to the destination as an attribute. When i process feature through "http caller" for each feature fme log writes "Total transfer time" in Log window. But this data I cannot extract, but somehow fme is getting this duration time, i need this time to write to destination. How can I extract this info. please help me. i pasted below my fme log window texts. please look for "total transfer time: '3.058 seconds' in below log. HTTPCaller_2(HTTPFactory): HTTP/FTP Transfer: Downloading resource 'https://gisnet.cable.comcast.com/eGisCoeServices/api/CC_MULTI_HFC_PRX_ANLYS_CORE_ERT?distance=2000&solvetype;=fiber&jobcost;=n&hfctype;=fspl&routecount;=1&xycoords;=-119.393773%2C36.545843' to internal memory bufferHTTPCaller_2(HTTPFactory): HTTP transfer summary - status code: 200, download size: '12889 bytes', DNS lookup time: '0 seconds', total transfer time: '3.058 seconds

6316
jovitaatsafe
Safer
jhu_20
Contributor
jhu_20Contributor
asked in Data
Space in the path for File Geodatabase for reader will fail and cause ArcObject error when published to FME Server 2019.1

I have the following FGDB as reader. It works in FME Desktop 2019.1 but will fail and get Arcobject error when published in FME server 2019.1. It looks like that FMEserver 2019 cannot handle space inside the file path. \\\\enervest\\shared\\ArcGIS\\GIS\\Geoscience Technology\\Raw Vendor Data\\Rextag\\Temp\\Rextag_Crude_Oil\\Rextag_Crude_Oil.gdb Received arcobject error when running the job on FME server: Unable to connect to the File Geodatabase at '\\\\enervest.net\\shared\\ArcGIS\\GIS\\Geoscience'. Make sure the correct filename was specified, and that the geodatabase wasn't saved with a newer version of ArcGIS than the one installed locally. The error number from ArcObjects is: '-2147024893'. The error message from ArcObjects is: {} This is not good since I have not seen this problem in FME 2018.

204
jhu_20
Contributor
A
adamka
asked in Data
FME, read features AutoCAD object enabler

Hi, I am currently facing an issues in which I cannot access objects within a AutoCAD file. The AutoCAD file contains 3D objects from Civil 3D that can be seen in AutoCAD with the object enabler plug-in from Autodesk. However, I cannot seem to be able to find the geometry or the features while reading the .dwg file using FME. My hypothesis is that FME does not recognize the content since it basically is unknown for a standard set up of AutoCAD. However, once the object enabler plug-in is installed, the content can be read in AutoCAD. Anyone else had similar issues and could point me in the right direction? Thanks,Adam

323
daveatsafe
Safer
bjudes
Enthusiast
bjudesEnthusiast
asked in General
Path windows not working from WorkspaceRunner

I'm sure this is an easy fix, but I have a workspace that is being run by WorkspaceRunner. A different shapefile is reading in from the runner each time using the Path Reader. When I run the WorkspaceRunner the child workspace is not running. I have used this setup before and it's worked perfectly. I can't figure out why it's not on this occasion. I've attached both workspaces. Thanks for any help. B

558
dataninja
pflegpet
Contributor
pflegpetContributor
asked in Transformers
Insert Image into Excel

Hi, I know there are already threads about inserting images into Excel spreadsheets but I could not find a solution for my problem yet. In my workspace I create an image with MapnikRasterizer and a table, both of which I would like to write to Excel. For that purpose I created a template that is used in the writer. I define the cell location for the image in an AttributeManager but in the output it overlaps the table instead of being inserted into the defined cell. I'm sure there is some writer setting I'm setting up incorrectly but I just can not figure out which one. Example workbench and template are attached. Thanks for any help!

1183
pflegpet
Contributor
pdorio
Contributor
pdorioContributor
asked in Transformers
Mistakes by configuring a new Custom Coordinate System [RDN2008 (ETRF2000) Italy zone (N-E) EPSG:6875]

Good evening at everyone.SINFI (National Information System for Italian Infrastructures) requires that the data be delivered to the reference system EPSG:6875 [1]The SRS EPSG:6875 is called "RDN2008 / Italy zone (N-E)", based on the "RDN 2008" Datum.The "Rete Dinamica Nazionale 2008", is the evolution of "European Terrestrial Reference Frame 2000" (ETRF 2000) . The RDN2008-ETRF2000 system is the new official Italian reference system since 2011 (D.M. del 10/11/2011) [2][1] http://epsg.io/6875 [2] http://geomappando.com/wp-content/uploads/2016/07/DM-ETRF2000-RDN.pdf  I have configured as follows a custom "DATUM_DEF" and a custom "COORDINATE_SYSTEM_DEF" in my "MyCoordSysDefs.fme" file:ELLIPSOID_DEF GRS_1980 \   DESC_NM "GRS_1980" \   E_RAD 6378137 \   P_RAD 6356752.314140DATUM_DEF RDN2008                                             \   DESC_NM    "Rete_Dinamica_Nazionale_2008"  \   SOURCE     "PROJ4"                                         \   ELLIPSOID  GRS_1980 \   USE 7PARAMETER    DEL

1905
cdalessandro
Contributor
terezia86
terezia86
asked in Transformers
replace letters

Hi,is there any way to replace ALL big letters for small ones?Thanks

123
terezia86
M
manu_uhlmann
asked in Data
Problem with CSG Evaluation while reading an IFC-File

Hi all, I have some troubles reading an ifc-File with FME 2018.1. I’m able to read all of the ifc-types except of IfcWindows and IfcWallStandardCase. When I read these feature types, I get memory issues and the workspace process fails with the message “Failed to free sufficient memory to reach the process usage limit”. The file is not that big (182MB) and I run it on a machine with 32GB RAM. I guess the problem is associated with the CSG Evaluation of the features. If I set this parameter to yes in the ifc-reader, then I get the memory issues right away when I start the workspace. If I set the parameter to no and run the workspace with certain transformers (like a GeometryValidator, VertexCounter,…) or the CSGEvaluator, I get the problems after a certain amount of features. As described in the reader documentation, the csg evaluation is performed, when it is required (“If the CSG evaluation is not performed in the IFC reader, FME will automatically perform the evaluation when it is re

188
virtualcitymatt
Celebrity
T
tomrosmann
asked in Authoring
Set Python interpreter for a workspace

Hello, I have the following question: I would like to automate a process that involves running an ArcGIS Python script and then 5 FME workspaces. I thought about doing this with 6 workspaces, which I call using the WorkspaceRunner. For this to work, I would have to use the ArcGIS Python interpreter for the first workspace and after that the FME Python interpreter. Is it possible to set this as an option in each Workspace? I know it is possible to change the standard Python interpreter in the FME Options, but is it also possible to define it separately in different FMW files?Thanks a lot for your help in advance!

302
T
R
roland_kielema
asked in Authoring
Insert a loop?

The attached workspace contains of two parts. In part 1 I transform an excel document which contains many records of clients and products. Some clients have had only one product, others might have had 10. The result is also an excel document in which each client has only one row. In the row the order of al te products is displayed in time starting with the first product and ending with the last product (in time).In part 2 some checks are done on the data. For example some products of the same categorie may not be handed out within a short time period. The workspace does the trick, but is quite slow. I think things could be made more efficient using loops. I've done some research on the internet but can't find the solution yet. Any help would be appreciated.

378
R
virtualcitymatt
Celebrity
virtualcitymattCelebrity
asked in Authoring
Handling hanging processes on FME Server - ABORT

I'm looking for ideas to help me get around a problem with hanging FME Process. I've found (at least one case) where FME is hanging with a difficult geometry - I've tried a few things to fix the geometry, however, I haven't had much luck (I'm going to pass it on to support for them to look at).The process is being called web API and it's expecting a response back when completed, either failed or successful - I am just using Fail topic to send back a response.  I decided to add in a 'tm_ttc' directive to make the job timeout instead of running forever. It works great, however, now the Failure topic isn't getting triggered and I can't let the tool know to wait for a response. It's the same when the job is canceled manually from the FME Server web ui.  Any ideas on this one? Cheers

181
virtualcitymatt
Celebrity
softwrite1
softwrite1
asked in Authoring
Column Aligned Text (CAT) in a Feature Reader missing dataset and basename attributes - 2019.2

I thought I would check here first to see if anyone has seen this issue - before I log it with support.The Column Aligned Text (CAT) reader embedded in a Feature Reader is missing the fme_dataset and fme_basename attributes - even though they are specifically exposed. I am using FME Desktop version 2019.2 (build 19801 – WIN32).This was working fine in the last version of 2018.Thanks in advance.Mike B.

92
fmelizard
Safer
salvaleonrp
Enthusiast
salvaleonrpEnthusiast
asked in Transformers
Capture specific log messages to process in my workspace

During runtime, I wanted to read the log file for messages that contain 'START - ProcessID, 'FME Session Duration', END - ProcessID' and a few other messages (in the red boxes) into my workspace so I can include each message as a feature in my translation.I can get most of this information from a shutdown script like below. However, I need the information back into my translation so I can write it to a database table that records translation metadata.# Import modulesimport fme, datetimefrom os import path# Get current date and timedateToday = datetime.date.today().strftime('%Y/%m/%d')timeNow = datetime.datetime.now().time().strftime('%H.%M.%S')print(dateToday)print(timeNow)print(fme.processID)print(fme.status)print(fme.elapsedRunTime)print(fme.totalFeaturesRead)print(fme.totalFeaturesWritten) 

174
salvaleonrp
Enthusiast
frankers
frankers
asked in Transformers
Group Dates by 24 hr blocks

IM trying to read a lmgrd9.log file, i can see most of what i need, but need to group the time stamps into 24 hour blocks and the assign the correct date to that to give a date/timestamp - Then i wish to join the OUT and IN with the user name to give a duration - this will end up in a powerbi report so can do some there.

103
frankers
E
edhere
asked in Transformers
How to replace part of string based on keyword? (a bulk StringReplacer?)

Hi all,I have a list of POI names that I'd like to abbreviate using an a Excel file that contains the keywords. I only like to abbreviate the words found in the string that match with the keywords - not the whole string.Basically what a StringReplacer does, but in bulk.Thanks, Eduard  

10511
jovitaatsafe
Safer
H
hektopascal
asked in Architecture
FME server docker with custom port number

Anyone who has an idiotproof guide to how I change the default port numbers for FME server docker install into else than 80 or 443? I plan to run this on a linux server with loads of other stuff, including a web server on port 80. Lots of other stuff that breaks if I put FME server on port 80. I'm fairly certain I'm not the only one with this use case... I am quite baffled that port number this isn't a parameter in the installation script.

424
H
M
muhammad_yasir
asked in Transformers
Running total

Hi there, I have two attributes (i.e. date and a field called wastage). Wastage is numeric field. I want to calculate the Running total of field wastage. I am using statisticsCalculator. I have attached the configuration of the statisticcalculator. Date is organised w.r.t. date. The problem is that calculated running total is the same for all dates (i.e. sum of all values of wastage). I mean it just calculate sum, its not the cumulative sum. Could anyone guide me where am I making the mistake? 

1266
bwn
Evangelist
A
aquamarine
asked in Transformers
What is the difference between Reprojector and CsmapReprojector

Hi,I want to reproject a raster but I'm not sure which reprojector transformer to use: Reprojector or CsmapReprojector??Can someone please tell me the difference and which is better for rasters?Thank you

1403
J
bobo
Contributor
boboContributor
asked in Data
How to keep field properties in FGDB class?

I have several FGDBs with same feature class and fields and I want to merge them into one FGDB, so I set Single Merged Feature Type at reader and Dynamic at writer. By setting Feature Read Mode as Metadata I can keep field alias, but I can't keep allow null values as NO, is there way to make it work?Figs below show that field properties before and after running workspaces.Before:After:

146
bwn
Evangelist

Badge Winners

Show all badges

Community Stats

31,821
Posts
120,862
Replies
39,453
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.