Skip to main content
  • EN

FME Form

A space to discuss FME Form

10000 Posts
4
4dlink
asked in Transformers
Hi. I would like to know how to add off set value of location into the workspace. I have an workspace to convert file from .Rvt to .tileset (.b3dm) and .Geojson.

Coordinate system setter is in the workspace, so I can select local coordinate, but I want to add offset value in somewhere in the workspace. Please kindly let me know how to add off set value (Latitude shift, Longitude shift, and height shift). Thank you.

70
4
camwatson
Contributor
camwatsonContributor
asked in Data
Is there anyway I can force FME to utilize the ArcGIS Pro libraries rather than the ArcGIS Desktop libraries when both are installed?

I’m using FME 2020.2 (FME(R) 2020.2.0.0 (20201027 - Build 20787 - WIN64)) and I have ArcGIS Pro 2.6 and ArcGIS Desktop 10.4 (with 64 bit background geo-processing) installed. I have a File Geodatabase (FGDB) that FME is unable to read.  The error I'm getting is : “It could have failed to open because it contains ArcGIS Pro-only features, for example Arcade expressions. If this is the case, please install ArcGIS Pro-compatible ArcGIS Sever and 64-bit FME." This FGDB contains a relatively new ESRI field type called contingent values on a feature class.  ESRI notes this makes the FGDB incompatible with ArcMap and releases prior to ArcGIS Pro 2.3 and ArcGIS Enterprise 10.7.x. It appears that FME is defaulting to using the ArcGIS Desktop libraries rather than the newer ArcGIS Pro libraries when both application are installed. The only work around I have identified at this time is uninstalling ArcGIS Desktop.  Once I do this FME will read the File Geodatabase without any errors

55620
mgg_beca
Contributor
S
shawn.brandt
asked in Transformers
I'm trying to generate multiple Word and PDFs from a SQL Creator. I'm not sure the intermediary steps. I am struggling with the MS Word Styler/MSWordParagrapher/FeatureWriter working properly Any help is greatly appreciated. Thank you in advance

100
marcyeranos
Contributor
thijsknapen
Contributor
thijsknapenContributor
asked in Transformers
What is/are the default (X,Y) coordinate order conventions in FME (particularly in relation to the 'Lat/Long vs Long/Lat discussion')?

Like described in the header, In short I'm wondering what the default (X,Y) coordinate order conventions are in FME (particularly in relation to the 'Lat/Long vs Long/Lat discussion')? Reason/motivation of the questionThe reason I'm asking is that in quite some workspaces I prompt users to enter an extent for a particular area (mainly to filter out data for the user defined area). Recently a user asked me if it was possible to incorporate an option to also allow the input extent to be entered by means of explicit Bounding Box (BBOX) coordinates in the form of a specific envelope, i.e. to enter both the (Xmin, Ymin) AND the (Xmax, Ymax) coordinates.Of course these explicit coordinates are meaningless without knowing how to interpret them (i.e. without knowing the underlying coordinate system). In the Netherlands it turns out that the vast majority of spatial files make use of the 'RDNew coordinate system' (EPSG:28992). However, I also wanted to give users the opt

31514
thijsknapen
Contributor
N
nibon
asked in Transformers
How can I get the straight (and predominant) line from a polygon?

I would like to get the predominant line for each polygon. I have tried using the 'CenterlineReplacer' but that doesn't work well since a lot of these shapes aren't long and narrow areas.  I only need one line per polygon, but it needs to be straight. The length of the line doesn't matter. I'm interested in the direction. Does anyone have an idea about how I can approach this task? 

342
danilo_fme
Evangelist
tcronin
Contributor
tcroninContributor
asked in General
Dropping Esri Required Fields

Trying to remove the editor tracking fields. I can, run to, in Attribute manager and see the fields removed but in the File GDB preview, I still see them.

60
tcronin
Contributor
markcoopersdc
Contributor
markcoopersdcContributor
asked in General
Cannot Uninstall FME

Hi I am trying to uninstall FME (2020.002) using Windows Add/Remove Programs. However, it just hangs on 'Gathering Information'. This is the second time I have tried - first time I left it for 24hours and no progress. Anyone go any ideas how I can remove it completely?

460
carmijo
Supporter
ileung_cnw
Contributor
ileung_cnwContributor
asked in Data
Edit coded value domains for a feature layer in AGOL using PythonCaller?

I am receiving this error below when I try to retrieve the getJSON variable:Python Exception <Exception>: Unable to update feature service layer definition.Object reference not set to an instance of an object.(Error Code: 400)Error encountered while calling function `processFeature'PythonCaller_3 (PythonFactory): PythonFactory failed to process featurePythonCaller_3 (PythonFactory): A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for detailsJSONFormatter (JSONFormatterFactory):This is the code in PythonCaller (simplified for readability):import fmeimport fmeobjectsfrom arcgis.gis import GIS def processFeature(feature):   getJSON = feature.getAttribute('JSON')   gis = GIS(profile='username')    lyr = gis.content.get('item_id').layers   for lyr in gis.content.get('item_id').layers:      lyr.manager.update_definition(getJSON)I know getJSON is giving me issues because if I replace lyr.manager.update_definition(getJSON

1669
evieatsafe
Safer
ranga_tolapi
Contributor
ranga_tolapiContributor
asked in Transformers
Custom format of version 2017.x (32-bit) not working when saved with 2022.1 (64-bit) version

Custom format of version 2017.x (32-bit) not working when saved with 2022.1 (64-bit) version. Enclosed the custom format of version 2017.x for your reference. Above screenshot shows the v2017 custom format when consumed as Workspace Resource in FME Desktop v2022.1. Above screenshot shows the v2022.1 custom format (same old v2017 custom format opened and saved in FME Desktop v2022.1) when consumed as Workspace Resource in FME Desktop v2022.1.

50
natalieatsafe
Safer
mmestrov
Contributor
mmestrovContributor
asked in General
Looking for a workbench example that updates a SDE Feature Class with attachments with an AGO HFL. Basically we would like to truncate and fill the SDE Feature Class with attachment with what is in a HFL in AGO.

Looking for a workbench example that updates a SDE Feature Class with attachments with an AGO HFL. Basically we would like to truncate and fill the SDE Feature Class with attachment with what is in a HFL in AGO.

290
evieatsafe
Safer
I
imran
asked in Data
How to read texts from dwg file which is associated with SHX font

Hi,I am having a large set of DWG files in which all the texts are referenced to a native Autocad font file called XARB.SHX, when I try to read it through FME desktop the fme_text_string shows something which is unrecognizable as FME is referring windows fonts.I am unable to read the autocad (XARB) style applied to the text in dwg file.It will be very helpful If anyone can suggest me some workaround.Thanks in advance.IMRAN

1089
omerseyfettin
Contributor
jhu_20
Contributor
jhu_20Contributor
asked in General
I have state name and county name as input parameters. I need to use state name as first input and then filter county name list to provide based input selection for county name. I checked Parameter Manager and cannot find a way to do this

I have state name and county name as input parameters. I need to use state name as first input and then filter county name list to provide based input selection for county name. I checked Parameter Manager and cannot find a way to do this

100
jhu_20
Contributor
s.jager
Influencer
s.jagerInfluencer
asked in Transformers
Conditional database connection parameter

Hello,I have a number of Workspaces that are run by colleagues using FME Server. These typically connect to a database, do some stuff, and create file-based output. The can run on three different environments, and because of that the database but also the output directory should be different. Right now I allow for that by using a database connection parameter and an output path parameter. It is to easy though to set one and forget the other, so that Production output ends up in a Test directory (or the other way around). Is it somehow possible to have a single Choice-Parameter, that influences which database connection is selected in the database connection parameter? I know I can use the ${} notation, but that does not see to work for a database connection.

290
s.jager
Influencer
S
suzanna
asked in Integration
Issues retreiving data with microsoft SQL server Spatial reader

Hi,Microsoft SQL Server Spatial reader connects successfully to a SQL Server entreprise geodatabase however it fails to retreive spatial data,throwing this error : Microsoft SQL Server Spatial Reader: Failed to load mssql_spatial_wrapper.dll. Cannot read/write curves and full globe and may orient geography incorrectly. Ensure Microsoft System CLR Types for SQL Server 2012 and Microsoft .NET Framework 4.5.2 (or higher) and are installedMicrosoft SQL Server Spatial Reader: Microsoft System CLR Types for SQL Server 2012 is available at http://www.microsoft.com/en-ca/download/details.aspx?id=29065. Please expand 'Install Instructions' and download 'SQLSysClrTypes.msi'Microsoft SQL Server Spatial Reader: If you have confirmed that Microsoft .NET Framework 4.5.2 (or higher) is not installed, it is available at http://www.microsoft.com/en-ca/download/details.aspx?id=42643Microsoft SQL Server Spatial Reader: Schema lookup query failed for table `domain\\TableName'. Provider

3180
S
I
ingemar_2020
asked in Transformers
Pivot SQL table for large amounts of data, lists, attribute pivoter, feature joiner or SQL executor

Hi, I have a problem that is bugging the *** out of me. By know it's a question of FME pride since I assured my colleague that FME was the way for this :) I have a rather sizeable SQL table containing measurement data from gauges. It is listed in a fairly common way (described by the attached picture). For analytical pictures I would like it to turn the attribute "name" inte columns that have their value displayed for each time step. This is for data analytical reasons.  I have tried with attribute pivoter without success, working with lists, creating a structured table than make a join. The problem is that the amount of names is so large that I can't make any manual type-ins for name etc. It has to be dynamically otherwise it won't work Please, any suggestions or will I have to admit defeat and hand it over to a sql colleague. It will give him alot of work (and also he will laugh in an evil way). Thanks in advance

374
I
A
atdelwp
asked in General
How to control appearance of cesium 3D tiles. Specifically, edging and shading.

This image of my output display on a CesiumJS website demonstrates where I am up to. I am trying to convert GDB multipatch to C3DT.I can control colour through either geometrycoloursetter or appearancesetter but I cannot figure out how to prevent dark shading on top of models nor create defined edges to accentuate the geometry.I want the edges to look like this:

500
A
ramachandra
Participant
ramachandraParticipant
asked in Data
Dynamic Blocks and Object Data using AutoCAD RealDWG writer?

Is it possible to write object data to a dynamic block with AutoCAD RealDWG writer?

560
jovitaatsafe
Safer
S
sraapril
asked in Transformers
Line Combiner | FME(R) 2021.1.1.0 (20210730 - Build 21619 - WIN64)

The line combiner when used in 2018 and 2021 behave differently for the same input data. In 2021, the output does not correlate to the explanation on the FME help.  For the following dataset, the output expected is as shown in the 2018 output screenshot however, for 2021, despite the configurations being set as per the result which is expected does not yield the same results. It appears that for some reason the duplicate lines(?) are not merged as expected. In the example below, K1, K2 etc. are kring_id and the numbers are _overlap (As set in line combiner)  The help states that duplicate lines are accepted by the line combiner for 2018 and 2021. Here are the transformer settings from 2018 and 2021 that are used in the workspace.  2018 - Break Across Attribute ValuesIf this parameter is set to Yes, two lines with the same values for the attributes selected above will not be combined if the node at which they meet is also connected to another line with different values for these attribu

603
S
L
lufecol
asked in General
problem with ZipExtractor then PythonCaller

Hi,I use ZipExtractor to unziped a file, then put it in a folder, but when I go to use PythonCaller to read the files from the folder, it still hasn't finished unzipping all the files.How do I make it use the next task only when the previous task has finished?Thank you

140
L
geographix
Contributor
geographixContributor
asked in General
How do I lock the bounding box of the Graphics View?

My project covers the whole state of NSW, and the workspace has many many transformers. What I want to know is how to lock the bounding box of the map in the Graphics View. If I'm debugging one particular area of interest, the map jumps to some sort of saved view for each and every transformer. I spend the day zooming and panning the map to get back to my area of interest. I click another transformer to see what the data was doing at that point. then have to zoom and pan again to get back to my area of interest. What I want to do is lock the Graphics View to my area of interest. I can see the hover for "2D" button is "Lock the current view in 2D", but it doesn't lock anything consistently. Sometimes it even centres the map on another state where there is no data. Other times it drops me in the ocean and I have to zoom out until I see land, pan, and zoom in again. Is it possible to keep the bounding box of the map in the Graphics View fixed?

350
evieatsafe
Safer
emo10001
Contributor
emo10001Contributor
asked in Transformers
Populate User Parameter choice dropdown from sql server query dynamically.

I would like to be able to populate a user parameter dropdown choice list from the results of a sql query and/or stored proc every time the workbench is run. As in, the dropdown choices need to always be able to reflect the database results every time. This seems unusually difficult to do. I need the dropdown to always reflect whatever the latest values in the database are, every time the workbench is called. Using Workbench 2021.2.1.0 (20211203 - Build 21797 - WIN64) Any help is greatly appreciated.

710
carmijo
Supporter
T
tslack
asked in Transformers
Exporting to DWG w/ object data is writing empty layers

Hey there,So i've modified the Data Downloading script on FME Server and am having some issues exporting to a dwg with object data. The script lets them pick from a tree list what to download and then export to DWG and it completes fine but the issue is if I only download one layer, say contours, its including every single feature class as a layer in the DWG even tho its empty. I can see it creating object data during the FeatureWriter process.  Is there an option to not include layers if they're empty im not seeing? thanks for any help.

540
T
chris_acc
Contributor
chris_accContributor
asked in Transformers
Is there a better method to update my data into ArcGIS Online?

Hello,I wish to copy polygon data from SQL DB to ArcGIS Online. The only way I have found that seems to work is in attached image. Having to delete the data before I can insert the update seems incorrect albeit appears to work.I assume there is a better way?Thank you

530
M
R
rbakker
asked in General
How to move a file to a file share without needing a subfolder?

When using the FeatureWriter, it wants me to provide a subfolder. I cannot leave it blank. I need to be able to write the file to the root of the file share. I am doing a move and not a copy. any thoughts?

1300
R
asablomberg
Contributor
asablombergContributor
asked in Transformers
Sample raster data value from vector polyline.

I have a raster with downpour data (with water depth in different areas) and a vector layer with sewer pipes data. I want to know the maximum water depth of a sewer pipe. I have found an ArcGIS Analysis tool called Sample, is there anything like that in FME?https://pro.arcgis.com/en/pro-app/latest/tool-reference/spatial-analyst/sample.htm

471
ctredinnick
Supporter

Badge Winners

Show all badges

Community Stats

31,846
Posts
120,959
Replies
39,476
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.