Skip to main content

FME Form

A space to discuss FME Form

10000 Posts
sg2171
Contributor
sg2171Contributor
asked in Transformers
InlineQuerier not working on FME server 2022

For some reason when I run inlinequerier on FME server 2022 I get the following error. 64 2025-3-31 16:49:13 | InlineQuerier (InlineQueryFactory): The clause 'USE_FMEOBJECTS Yes' within 'FACTORY_DEF {*} InlineQueryFactory FACTORY_NAME { InlineQuerier } USE_FMEOBJECTS Yes TABLE_DEF Swap_Data Title<comma>text<comma>Hyperlink<comma>text<comma>Region<comma>text<comma>Status<comma>text<comma>Event_ID<comma>integer<comma>Usid<comma>text<comma>Market<comma>text<comma>SubMarket<comma>text<comma>ClosedOut<comma>text<comma>ErcNode<comma>text<comma>SSD<comma>text<comma>SSV_Ready_Date<comma>text<comma>Q_5640T_Date<comma>text<comma>FA<comma>integer<comma>County<comma>text<comma>SSV_Rejection_Note<comma>text<comma>sharepoint_item_id<comma>integer QUERY_DEF Swap_Data SQL_ENCODED Select<space><quote>County<quote><lf>From<space><quote>Swap_Data<quote> GEOMETRY_SELECTION FIRST INPUT Swap_Data FEATURE_TYPE Swap_Data_SHAREPOINT_1_1_wuz7majgeOo=' is not recognized by the factory 'InlineQueryFactory' My des

161
nielsgerrits
VIP
jerrylim735
Contributor
jerrylim735Contributor
asked in Transformers
Cluster sampling of line data

I would like to create clusters of line data (geometry) for sampling, the geometry would be connected within each cluster. So far I’ve thought of: Create a bounding polygon > split it into X polygons using Tiler or some other transformer > SpatialFilter. This would be the easiest I guess, but this would create dead ends at the geometry around the polygon boundary. Ideally, I would like a closed/self-contained ‘route’ but not really necessary. SpatialSorter > group every X rows. But I realize this doesn’t give a nice closed-off route either and you would have to manually see how many rows to pick to create a nicer cluster so probably better off with the first option. Any better ideas? Additionally, it would also be good to be able to define a criteria for sampling like having X km of main roads and Y km of small roads in each cluster but I suppose that can come afterwards by calculating the counts per cluster and choosing clusters to hit the quota.

992
jerrylim735
Contributor
vxn43
Supporter
vxn43Supporter
asked in Authoring
Generate additional unique IDs from existing Unique IDs

I am using FME Form 2021. I have a Point Feature Class with 100,000 points that includes 4 ID fields, all of which are populated with unique IDs. I want to simplify the process of creating new unique IDs from the existing ones, so I no longer have to manually enter each one when I add a new point. For simplicity, I will refer to the unique ID fields as Field1, Field2, Field3, and Field4. For Field1, the maximum value is 141386; for Field2, the maximum value is 592124. What would be the best way to do this in FME? I am looking for general information like what transformers and parameters I need to use; I think I need to use the Counter Transformer. My goal is to add a new point in ArcGIS Pro and then run the FME workspace to generate the unique IDs for that point.

242
vxn43
Supporter
blueinc
Contributor
blueincContributor
asked in Integration
FME2023 fmeobjects folder installation missing python folders?

I’m trying to discover why my stand-alone python script cannot now ‘import fmeobjects’ after an upgrade of FME Desktop 2022.2 to FME Forms 2023.2.2. The sys.append path that worked previously had a python version subfolder inside the installation’s fmeobjects folder, like this: if os.path.isdir(rf"{FME_HOME}\fmeobjects\{python_subfolder}"): os.add_dll_directory(FME_HOME) sys.path.append(rf'{FME_HOME}\fmeobjects\{python_subfolder}") sys.path.append(FME_HOME) os.chdir(FME_HOME) import fmeobjects but those python subfolders are no longer there inside the fmeobjects folder in the Form current installation, but rather are outside in their own ‘python’ folder now. Is this correct? It seems that most of the searching I’ve done has the path to the python version as a subfolder of fmeobjects folder. No amount of appending sys.path versions of the python_subfolder will allow python to correctly ‘import fmeobjects’ and not stop producing: ImportError: DLL load failed while importing fmeobjects: T

37514
blueinc
Contributor
emerson_styles
Contributor
emerson_stylesContributor
asked in Data
Output excel file hiding column names (row 1)

I am writing data to an excel file but when I open the written file, the first row of the file (that includes the column headings) is hidden and I have to manually expand it to show the headings. Is there a way to fix this in the writer at all?

7819
phoeffler
Contributor
smjie
Participant
smjieParticipant
asked in Integration
What is the Host URL in FME AR app? Any other optional app for AR?

Hello! I want to use my phone to visualize the FME model I created in laptop. I am using FME AR app now. I don’t know how to log in. What is the Host URL? What’s more, since the FME AR app is no longer available in app store now (I download it long time ago but cannot use this app through other device), which software should I use to create the AR project?

201
AliAtSafe
Safer
harmen
Contributor
harmenContributor
asked in Authoring
In Form the FME Flow connection is overwritten when creating a new database connection

In Form (2024.1) the FME Flow connection is overwritten when creating a new database connection. This behavior is in our Citrix environment. Why is this happening and what can I do about it? Doesn't have a clue at the moment.

332
harmen
Contributor
clowncutie
Contributor
clowncutieContributor
asked in Integration
Write geometry to PostSQL Database

Hi, I have this workspace and databse connection, worked nicely to write to a table. This is geometry column for another table in PGAdmin My workspace using the PostGreSQL writer: But for some reason, even if I add column geom manually in pg admin after, it refuses to write. What could I be doing wrong? The column jsut never appears, maybe it is a pgadmin question not FME question how I store the geodata, not as X,Y points but as readable geometry like this:

415
nielsgerrits
VIP
bec
Contributor
becContributor
asked in Transformers
Using Spatial Filter within a FeatureReader

I’m using FME Workbench 2023.1. I have a workspace where I am trying to use a FeatureReader with a Spatial Filter for a constraint to limit the number of Parcels I bring in from the Parcels layer by running them spatially against the Corporate Boundary layer. I’m new to FeatureReaders and I’m not sure what I am missing to get this to work as intended. I have my Corporate Boundary layer connected to the Initiator Port on the FeatureReader. The settings for the FeatureReader point to the ESRI REST Service URL of the Parcels layer. And no matter what Spatial Filter selection I use: Initiator OGC - Contains Result, Initiator OGC - Intersects Result, Initiator OGC - Within Result...I only get 1 output to the Schema and 1 output to the Initiator port. See the image below. Can someone please explain what I might be doing wrong or missing when trying to use the FeatureReader? FeatureReader_Parcels Parameters view with FME Workspace in the background.

563
nielsgerrits
VIP
cbrien
Contributor
cbrienContributor
asked in Transformers
Python Libraries not available?

Hi all,I’m attempting to create a python script to encrypt a file for transfer to a bank.We need to be using PGP encryption, and as I understand the only way to encrypt using FME is by way of python. Having only recently joined the organisation, I was not here when the installation of the latest Form and Flow was undertaken, (otherwise I would have advised that the Flow installation 2022.1.1, should at least match the Form version 2023.2). But that’s only part of the problem I believe.First, I would like to attempt to figure out if the libraries are available from a Form workspace running on my desktop. When I check the INTERPRETER settings in the Options menu, it appears I cannot change or make reference to any alternative path. So far I have had very little luck, and would like to know if anyone has a simple python script that can run in a workspace PythonCaller/PythonCreator that will provide a test (so far the script produces an error any way I attempt to write to the log). I must

213
cbrien
Contributor
amber369
Contributor
amber369Contributor
asked in Transformers
HTTPCaller response different to browser response

Hi All, I've replicated a print call to a public mapping application using HTTPCaller. I've done this to try to capture some metrics on intermittent print errors we are seeing. However, complicating this, the response body results URL (from which the pdf would be retrievable) is formatted slightly differently between the HTTPCaller and the browser Dev Tools response. For example: In the browser I see: "url": "https://utility.arcgisonline.com/arcgis/rest/directories/arcgisoutput/Utilities/PrintingTools_GPServer/x_____xW6zDASkYrE9-8aNcJmscBA..x_____x_ags_e458af6a-0932-11f0-acf5-0e5ef779a06f.pdf" However in the HTTPCaller response I get: "url": "https://utility.arcgisonline.com/arcgis/rest/directories/arcgisoutput/Utilities/PrintingTools_GPServer/_ags_10f9db8b-0934-11f0-84d5-0afff93c372b.pdf" What would be the explanation for this difference? Thank you!

435
amber369
Contributor
brendanneal
Contributor
brendannealContributor
asked in Data
Snowflake database connection with keypair not recognising schema

Hi, I have and issue trying to connect to snowflake DB using keypair authentication, it is not recognising my schema. I'm using FME(R) 2024.1.2.1 (20240906 - Build 24624 - WIN64). I can connect fine in DBeaver using the keypairs. I'm using the advance JDBC settings to add the parameters in a new snowflake database connection. The error I get is ' C OM.safe.fme.jdbc.TranslationFailureException: java.lang.IllegalStateException: Connection established with no current schema. Make sure that schema 'dbo' specified in connection settings exists and is accessible by the user ‘. I know you need to have the case correct in the parameter I have checked with the DBA and have been told that the schema is definitely lowercase. I can’t show all the jdbc connection string, but this is the schema bit ‘ schema=dbo ’ so it is passing the lowercase parameter. Again, I am using the lowercase in DBeaver and connecting fine. I’ve also tried the scheme DBO, “dbo”, “DBO”. There is another schema in the databa

334
brendanneal
Contributor
mark2atsafe
Safer
mark2atsafeSafer
asked in General
FME Weekly Quiz: Round 2 Answers and Results

Hi FME'ers, Here are the answers and results to yesterday's quiz:Answers1) Which of these transformers has a Stiffness parameter? Displacer HullAccumulator SpikeRemover RubberSheeter EggBeater The answer is the Displacer transformer. This transformer is useful for moving features apart that are too close to each other (usually for cartographic purposes). The stiffness parameter controls how much a feature can be deformed in moving it. Give yourself 3 imaginary bonus points (ibp) if you knew the answer already, 2 ibp if you figured it out from what the transformers do, and 1 ibp if you typed stiffness into Quick Add and pressed tab (great tactic).You get no ibp if you went through each transformer to check! 2) The FME Mobile App that connects to FME Server is called... FME Server Express FME Data Express FME Mobile Express FME Workbench Express FME Vande Bharat Express It's the FME Data Express. It's intended to allow mobile access to Server, with some data collection capabilities too.

383
danilo_fme
Evangelist
scarter
Contributor
scarterContributor
asked in Authoring
PointOnAreaOverlayer not producing expected results

Hello Forum, I am experiencing an unexpected problem with what should be a simple point in polygon search process in FME Form. I have a Creator connecting to… FeatureReader - reading in a point dataset of 16255 records FeatureReader - reading in a polygon dataset, which covers a smaller area of what the points do The two FeatureReaders feed into a PointOnAreaOverlayer. But when I run the workspace 16255 point records are found. The number should be far smaller. Thanks.

332
scarter
Contributor
chandu
Participant
chanduParticipant
asked in Transformers
How to Perform a Utility Network Model Subnetwork Trace Using Python Caller or Python Creator in FME?

Hello FME Community, I am working with a Utility Network Model (UNM) in ArcGIS Pro and need to perform a subnetwork trace using FME. Since FME does not have a dedicated transformer for UNM traces, I am exploring options using the Python Caller or Python Creator to execute this operation. What I Need Help With: Python Script Guidance: How can I use the arcpy module (or another approach) within FME's Python Caller/Creator to perform a subnetwork trace. Are there any specific UNM functions or ArcPy methods that work best for this? Input/Output Handling in FME: i need to pass subnetwork name from FME to Python? How can I return the traced features back into the FME workflow? Environment: FME 2021.x ArcGIS Pro 3.x Python 3.x

261
trentatsafe
Safer
g_tz
Contributor
g_tzContributor
asked in Transformers
Read AEC Objects (Geometries and Attributes) in FME

I am working on feature and attribute extraction from an AutoCAD Architectural file, namely the extraction of room polygons and their attributes from AEC blocks that represent rooms. I have tried the Civil 3D reader and the reader actually sees the layer with the room AEC blocks and it shows me the available attributes correctly, alas the reader does not return any features. There are no errors, only a lot of warnings about attribute renaming because of scpecial characters. Has anyone ever succeeded in reading AEC block features and attributes? If so, how did you do it?

776
g_tz
Contributor
mr_fme
Enthusiast
mr_fmeEnthusiast
asked in Authoring
Problems with points in Bufferer

Hi, I have points created by vertex creator but my points don’t have coordinate system. I need create by points square buffers with 25 kilometers. I’m using coordinate system setter to define WGS84, after use bufferer but the error below is showed. Bufferer can’t understand my coordinate system but without the coordinate system isn´t possible to generate the buffer. Thank´s

8612
mr_fme
Enthusiast
matthieuv
Contributor
matthieuvContributor
asked in General
Table Qualifier for FeatureReader

The FeatureWriter has an option to set the Table Qualifier. This makes it possible to use one writer for multiple database schemas. Unfortunately the FeatureReader is missing something similar which leeds to a lot of spaghetti. It would be a nice improvement if you can set in the FeatureReader the Table Qualifier (based on an attribute value).

443
nielsgerrits
VIP
darren
Contributor
darrenContributor
asked in Transformers
Creating a dynamic reader template

I'm trying to create a re-usable template that uses a dynamic reader to allow it to read a table from a database, the 'connection', 'feature types to read' and 'where clause' attributes would be defined before the reader but this approach seems to be causing me problems. The process so far looks like this... The FeatureReader looks like this... If I define the connection, table and where parameters within the feature reader everything works fine, the reader recognises the schema and creates an appropriate output port. Using the above approach and defining the same parameters as attributes doesn't create a output port (which I understand as how can it create a port for a feature type it hasn't read yet), next stop was the generic port but I can't seem to get anything useable out of this. I've read numerous articles on here about using a feature merger to merge the schema and the generic ports but this doesn't seem to give me anything useable either. I've also tried an attribute exploder

1432
j.m-visma
Contributor
galigis
Enthusiast
galigisEnthusiast
asked in Transformers
Esri Indexed 3D Scene Layer (I3S) - Point Cloud Help

Hi All, I’m working on a workbench to help my team to convert E57 point cloud data into SLPK and publish these into a 3D Scene in Portal for GIS. Initially I was converting the E57 into LAS files and then use ArcPro to convert the LAS files into SLPK and upload them into Portal. Before doing any publishing on Portal I wanted to do a simple test on my machine to makesure the E57 point cloud export fine to my machine, I have read the slpk can be created in FME by using ‘Esri Indexed 3D Scene Layer (I3S)’ but, for some reason, I can’t get it to work. Below a screenshot of basic workflow that read the E57 and tries to export to slpk….but it doesn’t export anything? there’s no slpk at all, see below: Any ideas if I’m missing something? Cheers

596
nielsgerrits
VIP
philipwhitten
Contributor
philipwhittenContributor
asked in Transformers
ERROR : INCLUDE -- failed to evaluate TCL expression

I am getting the following error in a FME Form Workspace: Starting translation...ERROR : INCLUDE -- failed to evaluate TCL expression ` if { {-1} == {0} && {ORIGINAL} == {ORIGINAL} } { puts "MACRO REAL_MODE LAST"; puts "MACRO REAL_RATE <Unused>"; } else { puts "MACRO REAL_MODE ORIGINAL"; puts "MACRO REAL_RATE [expr <Unused> * ( -1 ? -1 : -1 ) ]"; } ' -- missing operand at _@_in expression "_@_<Unused> * ( -1 ? -1 :..." (parsing expression "<Unused> * ( -1 ? -1 :...") invoked from withinexpr <Unused> * ( -1 ? -1 : -1 ) invoked from withinif { {-1} == {0} && {ORIGINAL} == {ORIGINAL} } { puts "MACRO REAL_MODE LAST"; puts "MACRO REAL_RATE <Unused>"; } else { ...Program TerminatingTranslation FAILED. In a general context , what does this error mean? What are examples of issues that can trigger it and what FME form workspace design approaches eliminate it? In the specific workspace, if I progress through the workspace from beginning to end using the “Run To This” option on each transformer t

274
philipwhitten
Contributor
sussexpete
Contributor
sussexpeteContributor
asked in Authoring
FME Workbench and other FME Form software broken by VMWare Tools

Since updating our FME Form host computer with the latest version of VMWare Tools, FME Desktop, FME Data Inspector, and all other FME Form GUI software does not run. We briefly get a spinner and then nothing. The problem was noted on FME version 2021 but is a problem with all version of FME Form up to the latest version FME(R) 2024.1.3.0 (20240927 - Build 24627 - WIN64). It is still possible to run Workspaces in batch mode. The issue seems to be with OpenGL as indicted in the log, below. I would be interested if others have the same issue and, if so, how the issue can be resolved. Here is a snip from the log file: VMWare Tools v12.5.0.24276846 Faulting Module = vm3dgl64.dllWorking Version = 3.5.3.2 Faulting Version = 3.6.0.0 Event Log: Faulting application name: fmeworkbench.exe, version: 2021.7.41.21614, time stamp: 0x60f7b7a5 Faulting module name: vm3dgl64.dll, version: 3.6.0.0, time stamp: 0x66a16726 Exception code: 0xc0000005 Fault offset: 0x0000000000e3696d Faulting process id: 0x

536321
nia.colebrooke
Safer
p_c_20
Contributor
p_c_20Contributor
asked in Transformers
Feature reader - dynamically expose attributes using schema read in by another FeatureReader (or Schema Scanner)

I have a collection of geopackage files, several of which have different feature attribute schemas (attribute names, numbers of attributes). I have read the schemas using a FeatureReader, and created a list for each FME_Feature_Type_Name. (I’ve built a concatenated text string here just for visibility): Where I am getting stuck is in using this in a subsequent FeatureReader to define the attributes to expose for each file. I’m using fme_feature_type_name in the read location to grab one file at a time. But am struggling to use the Schema list or concatenated attribute to drive the attribute exposure. I can get all attributes exposed via AttributeExposer, but then I have to use a TestFilter and an AttributeManager to remove the attributes that don’t apply to particular files (because ‘expose all’ picks up all attributes from all files). Is there any way this will work?

1211
j.m-visma
Contributor
tb09114
Supporter
tb09114Supporter
asked in Transformers
How to get Bing tiles into MapnikRasterizer?

I need to get data from my Bing subscription into the MapnikRasterizer. At least that how I think it should be done. It works of course in the preview because I made the Bing maps available through the options. But as I see it for the MapnikRasterizer I will have to provide the background as an image and I am struggeling to get the Bing data into my workflow. background settings in MapnikRasterizer How can I get the Bing data into the MapnikRasterizer?

501
tb09114
Supporter
jon
Contributor
jonContributor
asked in Transformers
How to update Feature Types using a FeatureReader

For normal Reader feature types, to update for schema or attribute changes you simply go to Readers > Update Feature Types. I can't find the same functionality using a FeatureReader. Is there a way to do that? The only workaround I've found is to drop the FeatureReader and re-add it.

4167
kalbert
Supporter

Helpful Members This Week

Badge Winners

Show all badges

Popular Tags

Community Stats

31,153
Posts
118,107
Replies
38,772
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.