Skip to main content
  • EN

FME Form

A space to discuss FME Form

10000 Posts
aashnaparikh
Contributor
aashnaparikhContributor
asked in Transformers
Feature Writer - Feature Count Limit

Hi,  How can we set the set the limit for max features to write in the feature writer? I have set the limit of 10,000 in max features to read in the feature reader; will that automatically imply to write 10,000 to the feature writer

352
alexbiz
Influencer
lmengualpelay
Contributor
lmengualpelayContributor
asked in Integration
How to use a floating license?

Hello,Sorry for the inconvenience. We've never installed a floating license. Is there a process, or do I just need to specify where it's located?Thank you for your help.Regards.

412
lmengualpelay
Contributor
evoteck
Enthusiast
evoteckEnthusiast
asked in Authoring
Creating choice User Parameter to show column list details when I want to run the workflow.

I want to Create a choice User Parameter that will show column list details from database, This will enable me to select my choice column field that when I run the workflow, I will be able to get the output result for only the column in a fanout dataset.

332
crutledge
Influencer
muhammadsambe0
Contributor
muhammadsambe0Contributor
asked in Transformers
Calcul de statistique zonale sur raster à partir d’une couche polygone

Bonjour,Je souhaite calculer une statistique zonale afin d’obtenir la moyenne des valeurs de pixels d’un raster, sur une couche polygone (vecteur), comme on a l’habitude de le faire dans un logiciel SIG (voir capture ci-dessous).Merci pour votre aide. 

596
muhammadsambe0
Contributor
goldstein
Contributor
goldsteinContributor
asked in Data
Splitting multi header CSV into chunks.

Hello Folks,I have been presented with an interesting issue.I have a CSV which consist of data with multiple headers and related data for those headers.  #header 1 and valuesobservationId,broid,_response_body_new,_http_status_codeid_01682157639,GLD000000036023,"""BRO-ID"",""bronhouder"",,""kwaliteitsregime"",""datum eerste meting"",""datum recentste meting""GLD000000036023"",""50200097"",,""IMBRO"",""(2005-11-27, JJJJ-MM-DD)"",""(2025-04-10, JJJJ-MM-DD)"",,,,,#header 2 and values""put BRO-ID"",""put buisnummer"",,""monitoringnet BRO-ID"",,GMW000000074173"",""2"",,,,,,,,,#header 3 and valuesobservatie ID"",""start observatieperiode"",""eind observatieperiode"",""observatietype"",""mate beoordeling"",""observatieproces ID""id_OMO_95135"",""(2024-07-18, JJJJ-MM-DD)"",""(2025-04-10, JJJJ-MM-DD)"",""reguliereMeting"",""volledigBeoordeeld"",""id_OP_95135"",,,,,#header 4 and values""tijdstip meting"",""waterstand"",""status kwaliteitscontrole"",""censuurreden"",""censuurlimietwaarde"",""inter

747
takashi
Celebrity
salvaleonrp
Enthusiast
salvaleonrpEnthusiast
asked in Authoring
Using an AGOL Web Connection as a user parameter, would I be abe to get the AGOL Org account URL from this web connection during run time?

I wonder if there’s a way for me to hack the web connection during run time to expose the AGOL Organization URL and token so I can use this URL downstream.The ArcGISOnline Connector returns these as format attributes but I have the extra overhead of running the right action item to expose them. Submitted an Idea related to this:  

344
j.botterill
Influencer
lifalin2016
Supporter
lifalin2016Supporter
asked in Transformers
2024.2 yields an error in SharepointOnlineConnector ?

Hi.I built a workspace in 2024.1, that fetches a number of files from a customer Sharepoint site. It works (in 2024.1) without problems.I just installed 2024.2, and ran the workspace (with no changes).Now it issues an error with a SyntaxWarning from the package “safe.microsoft-sharepoint”:C:\Users\xxx\AppData\Roaming\Safe Software\FME\Packages\24783-win64\python\safe.microsoft-sharepoint\stringcase.py:247: SyntaxWarning: invalid escape sequence '\W' return re.sub("\W+", "", string)Is this something that I should worry about ?SharepointOnlineConnector is not listed as an upgradable transformer in 2024.2Cheers.

22120
lifalin2016
Supporter
esmgron
Observer
esmgron
asked in Transformers
Locating a duplicate column

SOLVED - I found the error Hello!I've been working on a script that has 56 columns (client needs all the fields of information), and now I need to write it using an Esri File Geodatabase writer. I have double- and triplechecked whether there is an invalid character (since gdbs are quite strict with field names) or a duplicate of one of the fields, but I cannot find it. Is there a tool in FME that let's you identify a duplicate of a whole column in the attribute table? Or a duplicate field name? Or does anyone know if there is another common solution to this error?This is the error code:ERROR |An error occurred while attempting to create the feature class 'Test'. The error number from ArcObjects is: '-2147220649'. The error message from ArcObjects is: {Cannot create a table with a duplicate column. [Test]} I am using FME form 2024.1.Thank you in advance!

562
esmgron
Observer
max_h
Supporter
max_hSupporter
asked in Transformers
Datetime DD-MM-YYYY in userparameter

Hello!Is there a way to change the displayed date in a datetime userparameter as DD-MM-YYYY?The chooser interface is helpful to check if it is the right date, but it can still be quite confusing, especially in Flow, when not every user knows about the picker and just enters the date. Is there an option I am missing or is a text-field instead my only alternative? Many thanks in advance!

642
max_h
Supporter
lorenrouth
Contributor
lorenrouthContributor
asked in General
PDF Reader: Can it read bookmarks?

I have a large PDF that has bookmarks set up. So far I have not figured out how to access. Thanks

303
pat_mecee
Participant
jurgenmack
Contributor
jurgenmackContributor
asked in General
I want to download a PDF with the HTTP_Caller and then write it to a directory on the local computer.

I want to download a PDF with the HTTP_Caller and then write it to a directory on the local computer.

2255
ebygomm
Influencer
djmcdermott
Contributor
djmcdermottContributor
asked in Transformers
Does FME use round-to-even or half-round-up?

Hello FME’ers,I am currently comparing FME and PostgreSQL/PostGIS when transforming some line geometry. In each scenario I need to round the coordinates to 3 decimal places. This has thrown up a anomaly when rounding coordinates ending .4999. For example, the coordinate 104269.57149999999 will be rounded to 104269.571 by ST_ReducePrecision but 104269.572 by the FME CoordinateRounder. I believe this is due to different rounding techniques like round-to-even or half-round-up. Can anyone explain this behaviour? Is there any “right” answer?Thank you,David  

455
djmcdermott
Contributor
earlw
Contributor
earlwContributor
asked in Authoring
Ultra basic workspace/web app to take published parameters and generate/open a url/uri.

We currently have an .asp script that builds a url/uri based on a selected prefix and document ID.When the OK button is clicked, the url/uri is opened in a new browser tab.The server where the asp script is located is being retired so we need to come up with an alternative.The parameters are Plan Type and Plan Number.The parameters are used to generate a path to the document to open. Eg. \\sample.file.path\resources\SCIMsPlans\pm12345.pdfI have converted the ASP to Python and made a self contained executable that works well but staff are used to accessing the plan search via a web link. I thought a FME web app may be suitable for this.Can anyone point me to the correct transformers to use for this or even better, a sample workspace.In case it helps, below is a snippet from the python script that builds the file path and opens the document.        # The Plan document ID number        name = self.plan_input.text().strip()                # If 'dp' is selected, use 'DP_DepositedPlans' to b

302
earlw
Contributor
suresh007
Contributor
suresh007Contributor
asked in Integration
Multiple Google Credentials

We just started integrating data to GCP BigQuery by adding a system environment variable called ‘GOOGLE_APPLICATION_CREDENTIALS’ and pointing that to the service account key file. I am anticipating a need to integrate with a different BigQuery and would like to know how to run parallel integrations to two different GCP accounts. Any thoughts? Thanks.

503
desiree_at_safe
Safer
lloechler
Contributor
lloechlerContributor
asked in Data
SchemaMapper - mapping attribute values

Hi everyone,I’m pretty new to FME and I’m using FME Workbench 2024.2 to move data from my sde gdb schema to an Esri Parks and Grounds solution fgdb schema. I’m having trouble with the SchemaMapper and moving my domains(attribute values) to the fgdb’s schema. Currently they are not mapping.  Previous SchemaMapper parameter settings moved the source attribute value over to the target attribute, but kept the same source attribute value (MULTI-FEATURE STRUCTURE should’ve changed to Jungle Gym but instead it stayed as MULTI-FEATURE STRUCTURE). Can anyone help provide more instruction on how to get the source attribute values to move to the target attribute name and change to the target attribute value?Here’s the .xlsx I’m referencing Here’s my SchemaMapper Parameters 

511
crystalatsafe
Safer
aaron
Contributor
aaronContributor
asked in Transformers
How to expand Query String Parameters dialog in HTTPCaller?

I’m stringing together a bunch of HTTPCallers, each of which has several query string parameters. From what I can see, you are only able to see two parameters at a time in an HTTPCaller transformer (see screenshot). Is there a way to enlarge/expand the dialog box so I can see all or most of them at once? Should be easy; I feel like I’m missing something. It would be so much easier, helpful, and efficient so see all query string parameters at a glance. (FME Desktop 2023.2.0.0, Build 20231201).

514
salvaleonrp
Enthusiast
joy
Enthusiast
joyEnthusiast
asked in Integration
SharepointOnlineConnector doesn't return all files

Hello everyone,We are encountering an issue when using the SharePointOnlineConnector. My colleague, who is a member of a SharePoint site, was able to retrieve all files from the site using the HTTPCaller. However, when attempting to retrieve the same files using the SharePointOnlineConnector, not all files are returned. We are unsure why the SharePointOnlineConnector does not return the complete list of files from the site. For further clarification pictures are added:My colleague can access a specific list in Sharepoint itself (Codes)In the SharePointOnlineConnector, after connecting to the same Site, the list Codes is not available to him. Codes is a List and not a Document. Maybe that might be the reason why Codes is not available? ----------------------------------------------------------------------------------------------------------------------------On the Azure App Registration side, the settings are configured as follows:Permission Type: DelegatedPermission app registrationSit

1255
desiree_at_safe
Safer
gboquin
Contributor
gboquinContributor
asked in Data
Project wise connector not downloading files with dependencies

Is this a bug? I am trying to list and download several files (some have dependencies-- references-- and some don't) and noticed that I cant download files that have an associated reference file.Any thoughts or suggestions?Thanks

20012
crystalatsafe
Safer
G
gis3780
asked in Data
Reading ArcGIS Online feature attachments

I have an ArcGIS Online hosted feature layer containing point features that have attachments enabled. Could someone help me with some advice for how to use the ArcGIS Online feature reader that will allow me to access the features and their associated attachments (if there are any-not all features have an attachment)? It is easy enough to get the features, but I can't see a way to access the attachments. Thank you!

71725
reedwhit
Contributor
stezi
Contributor
steziContributor
asked in Transformers
Adding attachments with ArcGISAttachmentConnector 3.9.5 not working with ArcGIS Enterprise

Hello,I want to report a bug related to adding attachments to a feature in an ArcGIS Enterprise Feature Service using the ArcGISAttachmentConnector in the latest version.I receive the following error:(C:\Users\x\AppData\Roaming\Safe Software\FME\Packages\25606-win64\python\safe.esri-agol\fmepy_esri_agol\attachments\handler.py:104) add_attachment    return AttachmentResult.from_dict(response.get("addAttachmentResult", {}))                                      ^^^^^^^^^^^^910523  Python Exception <AttributeError>: 'generator' object has no attribute 'get'The problem is that the ArcGIS REST API addAttachment endpoint returns text/html instead of json. This appears to happen specifically for Enterprise Feature Services, as described here. As a result, the result cannot be decoded. However, the attachment is actually uploaded successfully.Bug fix:Change the line 43 fromfiles = {"attachment": (filename, file_obj, mime_type))}tofiles = {"attachment": (filename, file_obj, mime_type), "f"

261
crystalatsafe
Safer
A
anandak
asked in Data
Bad geometry detected in the following feature; Geometry could not be encoded for Oracle

Hi,  I am using a bufferer and a dissolver transformer to generate a buffer polygon from an aggregated set of 500+ geometries. The Inspector is showing the generated geometry but the Oracle Spatial writer is unable write the geom into the spatial table. I am getting the error "Bad geometry detected in the following feature; Geometry could not be encoded for Oracle".  I have added a GeometryValidator after the Dissolver transformer. The generated geom comes through the PASSED output but still the error remains.  FME Desktop 2013 is used.  Regards, Ananda

1876
whkarto
Contributor
sapplezyw
Contributor
sapplezywContributor
asked in Authoring
User is not authorized - publishing workspace to FME Flow from FME Form

Hi,I get the following error when attempting to publish a workbench from FME form to FME Flow:User is not authorized.The specified user credentials were not authorized to perform this action. Ensure with your server administrator that your user credentials are authorized to perform this action.Publish Failed (Not Authorized) - Ensure that credentials are correct, and that user has sufficient privileges. I’m publishing using an account with superuser access. I’ve also managed to upload the workbench directly to a the folder using the FME Flow interfaceFME Form: 2025.0.1.0 (20250327 - Build 25220 - WIN64)FME Flow: FME Flow 2025.0.1

665
sapplezyw
Contributor
p_c_20
Supporter
p_c_20Supporter
asked in Authoring
Is it possible to extract text from a PDF of an MS whiteboard?

I have an export of an MS Whiteboard in pdf form. (I also have the JSON and HTML. The JSON doesn’t store the note contents).  PDF reader is spotting text, but I’m struggling to pull it out ‘per note’. Any ideas? 

463
p_c_20
Supporter
mmeyers
Contributor
mmeyersContributor
asked in Data
Excel reader not getting all content of cell

I’ve got a weird problem where an Excel reader is reading an entire file correctly, except for one column where it is only getting part of the data. When I decode the XML of the Excel file (change extension to .zip and expand), I can look at sheet1.xml and I see the following data:<c s="12" t="inlineStr" r="AK10"> <is> <r> <rPr> <b val="0"></b> <i val="0"></i> <strike val="0"></strike> <u val="none"></u> <sz val="10"></sz> <color theme="1"></color> <rFont val="Courier New"></rFont> </rPr> <t xml:space="preserve"> </t> </r> <r> <rPr> <b val="0"></b> <i val="0"></i> <strike val="0"></strike>

836
mmeyers
Contributor
benoitda
Participant
benoitdaParticipant
asked in Data
Enabling WAL (Write-Ahead Logging) in FeatureWriter for Geopackage

I’m using FME 2021.WAL is possible pour SQLite since 2010, Geopackage is based on SQLite. I didn’t find any way to activate WAL on a Geopackage FeatureWriter in order to avoid lock problems.How can I use WAL on Geopackage ? Is it available in later release ? 

101
hkingsbury
Celebrity

Badge Winners

  • FME Flow Authoring Training
    janethas earned the badge FME Flow Authoring Training
  • Webinar Watcher (Grey)
    ks1345has earned the badge Webinar Watcher (Grey)
  • Expert (Grey)
    hawaiialexhas earned the badge Expert (Grey)
  • Canada Day
    mark2atsafehas earned the badge Canada Day
  • Webinar Watcher (Grey)
    kaylavoxhas earned the badge Webinar Watcher (Grey)
Show all badges

Community Stats

31,835
Posts
120,911
Replies
39,470
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.