Skip to main content

FME Form

A space to discuss FME Form

10000 Posts
benvk
Contributor
benvkContributor
asked in Transformers
Trigger a ESRI Survey123 Report generation via webhook, then email pdf report to user

Hi All, I have been getting my head around FME Server and Webhooks with Survey123 data collection, and I am loving it! I can competently capture data via a Survey123 form, then trigger some FME automation to manipulate the data and email a specific user results dependant on what was captured in the Survey123 form. This is working well. I would now love to take this to the next level by using the formal Survey123 Report rest API. So ideally I want to get a copy of the Survey123 report PDF that is generated each time the webhook is triggered, and email this PDF to particular people. I have been searching this forum and I do not see any tutorials or any mention of working with the Survey123 Report API itself. Has anyone had any experience with setting up an automation that works with the ESRI Survey123 Report creation API, that they would be willing to share with me? note: I know with FME I can do pretty much everything the Survey123 report generator can do, in the long run with the dozen

5453
bromp
Contributor
dsign-world
Contributor
dsign-worldContributor
asked in Data
What are valid values for a custom schema's data types in a dynamic wokspace?

The website Dynamic Workflows: Destination Schema is Derived from a Lookup Table > Creating a Table-Based Schema > Geometry Type tells me that valid values for the `geometry_type` column are the values from the `fme_type` format attribute. It provides the full list of values under this link. The link is incorrect. This is the list of FME internal data types. These are NOT valid values from the `fme_type` format attribute and these are NOT values from the `geometry_type` column in the screenshot above in the tutorial. Where is the correct list of values for the `geometry_type` column or the `fme_type` attribute?

351
AliAtSafe
Safer
3d_ff
Contributor
3d_ffContributor
asked in Transformers
Automate the creation of 3D planar surface

Is there a way through FME to automate the creation of plates (3D planar surface), from the following data: XYZ position (centroid) Shape: Always has 4 sides but not necessarily always a rectangle Dimensions info: Width and Length Orientation info: Azimut (DipDIR) and DIP

10014
3d_ff
Contributor
aashnaparikh
Contributor
aashnaparikhContributor
asked in Transformers
Remove duplicates

In the reader file I have multiple full names “John Doe”. I want to ensure my Writer 1 / Output 1 should only have the first entry of John Doe and the rest of the John Doe entry should be mapped to Writer 2 / Output 2. Ex. Name Address John Doe 31 xxx st John Doe 41 yyy st John Doe 51 zzz st John Doe on 31 xxx st should go to output 1, and other two John Doe should go to output 2

252
DanAtSafe
Safer
nic_ran
Contributor
nic_ranContributor
asked in Integration
FME Form freezes when adding a new database connection

I’m trying to add a new database connection (FME Form 2024.2). I haven’t had any problems with this in the past but today the Add Database Connection dialog just freezes when I click Save. I’m able to click the Test… button to test the connection and that works. I’ve tried various connections to various databases and get the same behaviour - I’m able to test the connection successfully but not able to save it, so it does not appear to be a DB connection issue. I suspect it’s a file lock / permission issue on the connections file/DB that is being used but I have rebooted the computer and that did not help. I’m trying to save the connection for my own user (not a shared connection). Has anyone else experienced this and know how to resolve it?

343
AliAtSafe
Safer
aashnaparikh
Contributor
aashnaparikhContributor
asked in Transformers
Remove space and Space* from the name ensuring John Doe*/ John Doe * converts to John Doe. What transformer and parameters should be implemented

Remove space and Space* from the name ensuring John Doe*/ John Doe * converts to John Doe. What transformer and parameters should be implemented? Tried to use the Attribute Trimmer but it only removes either of it.

232
aashnaparikh
Contributor
joku041199
Contributor
joku041199Contributor
asked in Data
Reading an Excel file exposing all available columns automatically (To create Web App)

Hey Everybody, In my work, I generally get the question from clients to build a FME Server Web Application. Often, the question involves a MS Excel file, which needs to be analyses and converted to points/lines/polygons (GIS). Mostly, I use a Creator to kick-off the Workspace and a FeatureReader to load in the Excel. Also, I force the FeatureReader to have one single output port (Generic) and load in the Excel file using a User Parameter when kicking off the Workspace. This means that I need to Expose all attributes individually in the Workspace. However, this limits the flexibility. When I want to create a Web App from the Workspace, the input Excel always needs to have the same columns (so a Template Excel as input). An potential extra column is therefore not exposed an not in the result of the Workspace. However, in some cases, it is for my clients not possible to always use an Excel Template. Or they want to add additional information. My question therefore is, is it possible to dy

395
crutledge
Enthusiast
simeon.simic
Contributor
simeon.simicContributor
asked in Data
dwg coordinate system

I am reading dwg file, but i cant set him the right coordinate systemThe file i am reading is from autocad 2012In autoCad coordinate system is set to EPSG : 31277, i dont have that system in my fme workbench Thank you in advanced

80
simeon.simic
Contributor
crazypix
Participant
crazypixParticipant
asked in Transformers
Can't subtract solid geometry with csg-builder

I can't subtract solid geometry with the fme csg-builder. My goal ist to subtract the terrain (extruded by -10m) from buildings, to evaluate the volume that is above the terrain (subtract the basement under terrain). 3D-View: 2D-View: I tried several fme-transformer before plug them into the csg-builder. I used combinations of geometrycoercers and solid-builders with no success. My approach is to negative-extrude the terrain convert it to a solid and then substract it from the building-solids. The result ist always “nothing” (rejected): Or i just get one building dissolved (union) or cut (difference) when i dont use grouping:

546
crazypix
Participant
fionasin
Contributor
fionasinContributor
asked in Data
Method for forcing decimal points between numeric characters in a string?

I have various values in a 'code' field. A sample would be: A33, B111W, B12, C3V etc, etc. This issue is, there should be decimal points between all numbers, i.e, these should correctly read: A3.3, B1.1.1W, B1.2, C3V. There does not need to be points between the letters. I can string replace “33” with “3.3” and continue to do that for all values if I have to, but I’m hoping that there is a more efficient way of capturing these values and using regex or something to force decimal points between the numerical characters. I’m not well adept at using the stringformatter, but maybe there is something there?

282
fionasin
Contributor
frantsch
Contributor
frantschContributor
asked in Transformers
How to treat all appearing lists at once within a dynamic workspace?

I have a FME 2022.1 Desktop workspace with dynamic reader and dynamic writer. The reader generates several lists in some feature classes, in addition to attributes. How can I parameterize e.g. ListIndexer or ListExploder transformers to treat all appearing lists within various features of various feature classes streaming through my dynamic workspace at once, not explicitly knowing their list names (and hence not being able to indicate them as transformer parameter) ?

403
takashi
Influencer
keller
Contributor
kellerContributor
asked in Integration
OGC WMS Reader gives a coarse resolution output

I was just trying to load a wms into my fme workbench using the OGC WMS reader and i get the image with a resolution of 22m yet the image has a resolution of 8cm. I then loaded the same wms as a background map and it comes with the desired resolution of 8cm. Did i miss something or the calls made to the wms server using the background option is different from those made using the OGC WMS reader? i also realised that without setting the map width and height the resolution is very coarse then on setting the width and height, the resolution gets better, but i cant go beyond the maxheight and maxheight specified in the wms xml file. Below is the wms url. https://service.pdok.nl/hwh/luchtfotorgb/wms/v1_0?request=GetCapabilities&service=wms Kind regards, Keller.

212
keller
Contributor
sandrineyoubi
Contributor
sandrineyoubiContributor
asked in Transformers
PythonCreator Code Error

I have error messages when trying to run python script. I installed fme.exe python -m pip install pywin32 before import win32com.client but encountered a lot of error messages. Please see script attached. Please help. Thank you.

202
sandrineyoubi
Contributor
benji
Contributor
benjiContributor
asked in General
Geometry validator: 1 input but multiple outputs... why?

Can anyone please explain why with only 1 feature being read, more than 1 can fail? Any help would be highly appreciated! Many thanks!!

264
laddysmurf19
Contributor
eric_armitage
Contributor
eric_armitageContributor
asked in Transformers
Problem using FeatureReader with ArcGIS Portal Feature Service

I’m trying to use the FeatureReader to read 3 features from an ArcGIS portal feature service layer by reading in a spreadsheet and using a WHERE clause with an attribute in the spreadsheet. The FeatureReader will connect to the service and I can select the correct table in the “Feature Types to Read” parameter. But when I try to add the WHERE clause FME crashes before I can start creating the WHERE clause. The second image below indicated the point when it crashes. I can read the full table with no problem using the ArcGIS Portal Feature Service reader. How can I get the FeatureReader to run and read the required features?

675
fbruimte
Contributor
A
abhinav4972
asked in Transformers
Does FME support reading Geosoft Geodatabse with the extension .gdb?

Does FME support reading Geosoft Geodatabse with the extension .gdb? If yes, which reader can be used?

333
karthika
Participant
caracadrian
Contributor
caracadrianContributor
asked in Data
Autodesk AutoCAD DWG/DXF repairing polyline on read

I am trying to create a workspace that identifies consecutive duplicate point in DWG polylines. and outputs their coordinates for future review. As per my example, Autodesk AutoCAD DWG/DXF (normal reader or FeatureReader) does some autorepair on the features while reading. The DWG feature has 12 vertex in AutoCAD but only 7 in FME. Please see attached sample feature in dwg format. I want FME to read the same geometrie that AutoCAD gives. Using FME 2024.2.1.0 build 24801

413
caracadrian
Contributor
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.

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

222
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

37114
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?

7679
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

Helpful Members This Week

Badge Winners

  • Teacher (Bronze)
    arenscotthas earned the badge Teacher (Bronze)
  • Teacher (Grey)
    jmfeehas earned the badge Teacher (Grey)
  • Socializer (Ice Breaker)
    jmfeehas earned the badge Socializer (Ice Breaker)
  • Conversationalist
    jmfeehas earned the badge Conversationalist
  • Socializer (Ice Breaker)
    doniwanickahas earned the badge Socializer (Ice Breaker)
Show all badges

Popular Tags

Community Stats

31,082
Posts
117,845
Replies
38,837
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.