- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27683 Posts

ohumeniukParticipant

SQS Message content to workspace job.

Hello everyone! I'm a novice in FME Form/Flow. Maybe somebody can help me.I have a workspace that has multiple PostgresSQL readers, and these readers have a reference to the User Parameter in the WHERE clause.This workspace is published to FME Flow and triggered by an Amazon SQS trigger. The SQS message content is a JSON with parameters that are required for the readers in the workspace.My question is, how do I pass/parse incoming content to separate parameters in the workspace?

861

9 months ago

joe.fmeContributor

asked in Data

Batch processing metadata from SQL export to XML for use in ArcPro

Hi FME community,I’ve been tasked with trying to get the metadata we hold (in a SQL server database) into an INSPIRE-compliant format.I was hoping that we could use the metadata we currently hold (Title, Abstract, Temporal Extents etc) and run it through an INSPIRE XSD template. However, it’s pretty overwhelming when I look at the XSD templates (which I got from here - application-schemas/schemas at main · INSPIRE-MIF/application-schemas · GitHub) as there are so many nested parts (see screenshot). Is there a relatively straightforward method I could use for each topic of data (be they addresses, parcels of land etc - which have their own topic under the INSPIRE framework) which could be joined in FME and output an XML file which can be imported to the data in ArcPro? It seems a bit convoluted but I’m just trying to get an idea of where to go from here with a large shift in metadata storage and how we will be using it at my organisation going forward. Thanks

1004

9 months ago

bbeaumontObserver

asked in Transformers

FME equivalent of ArcGIS Tabulate Areas?

Dear all, I’m fairly new to FME but currently I’m quite impressed by the software :). My question is rather simple: is there an equivalent in FME of the Tabulate Areas function of ArcGIS Pro: Tabulate Area (Spatial Analyst)—ArcGIS Pro | DocumentationI have two datasets:The cadastral parcels of Wallonia in polygon format ; A land cover classification (TIFF raster) with 20+ classes.I would like to calculate for each polygonal entity the proportion of land cover classes.The result should look like this:ID | LC1 | LC2 | LC3 | … | LC201 | 10% | 0 | 0 |25 | … | 02 | …3 | … Many thanks in advance for your feedback :)

631

9 months ago

r7Contributor

asked in Transformers

Transform normal PDF to TIFF

When I simply add the PDF reader and convert to the TIFF writer, alle Images are exported separately into rows, meaning that for each individual PDF-File I get 100+ TIFFs. How can convert PDF to TIFF without this happening?

1028

9 months ago

alsherrenContributor

asked in Integration

Formatting json using JSON Fragmenter

Hello, I am new to handling JSON but am really struggling to understand it. I have formatted json stored in a csv as an attribute. I cannot seem to flatten or fragment it. Latest attempt was to write to a json then read in and fragment. The workspace screenshot attached ran successfully but hasn’t exposed the strings I have requested.

861

9 months ago

spill002Contributor

asked in Data

Request for input s- Unable to update the date field record using arcpy updatecursor in FME

Hello, I am trying to update the date field records of a feature class using arcpy update cursor, but I am getting the following error (text in bold), please let me know If I am missing anything : Field Name : e_result_datetimeField Values : 20230803081554 Field datatype : Date Also, want to mention that I am able to update the string, double data type fields using updatecursor in FME with no issues - it’s only with date data type I am facing the problem. Python Exception <RuntimeError>: The value type is incompatible with the field type. [e_result_datetime]Traceback (most recent call last): File "<string>", line 46, in inputRuntimeError: The value type is incompatible with the field type. [e_result_datetime]Error encountered while calling method `input'PythonCaller (PythonFactory): PythonFactory failed to process feature

505

9 months ago

yagami9Contributor

asked in Transformers

Extract an IFC object from one file and put it in a precise location of another IFC

Hi ,Is there any way to use an ifc file containing ifc objects, extract a specific object , then put it in precise locations in another ifc file that I am creating in the workflow?for exemple if I am interested in using this ifcDoor object that is inside a file1.ifc file : and the positions where i want to put this ifcDoor are where the 2d doors (the red lines) of my input file are located (my input is a dwg file containg 2D doors):All I can do now is just extrude those 2d doors , add ifc attributes to them , and them write them to ifcDoor writer . but they don't even look like doors :i want the doors to look like the ones in my file1.ifc file (their color , geometry , texture )I'm searching for a way to do it , but I am afraid that it is impossible .

814

9 months ago

ingallaContributor

asked in Data

ArcGIS database table watcher

Hi AllI am trying to set up a workspace to react when a change is made to an ESRI Enterprise Geodatabase table but cant figure out how to watch for changes on the table.I could set up a scheduled task to read all of the data and then a change detector to update a further table but that doesn't seem a wise use of resources, particular if there are no changes.SO any ideas how to watch this database table for changes efficiently??Regards

422

9 months ago

tb09114Supporter

asked in Transformers

Expose attributes in XMLFlattener based on list

I am getting features in through a WFS and pump the resulting XML structures through an XMLFlattener.The Elements to Match are ‘grouped’ by an attribute value and thereby dynamic.What I cannot make dynamic are the Attributes to Expose. I can either write them myself, or import them, but how can I get e.g. a list to work there, or the value of an attribute?Best thing would be the option of a conditional value… 😉

966

9 months ago

checcosisaniContributor

asked in Authoring

Connect point to line perpendicular

Hi how can create a perpendicular line that connect point to line, I mean I need to connect red points to blue line with a perpendicluar line thxFrancesco

492

9 months ago

sunita22Contributor

asked in Transformers

how to upload new csv file to database via fme

I need to upload new csv file each day with there is date on file each day

789

9 months ago

gjaguilarContributor

asked in Transformers

SystemCaller with xcopy /I /E /Y /T doesn´t create a directory

xcopy "$(TEMP_FOLDER)\$(FME_JOB_ID)\Temp" "$(TEMP_FOLDER)\$(FME_JOB_ID)\Results" /I /E /Y /TFrom the command line I use xcopy /I /E /Y /T and if the directory does not exist it creates it but within a SystemCaller it does not work and does not give an error message.I need Help

1286

9 months ago

gjaguilarContributor

asked in Transformers

Is there a way to check if a directory exists?

Is there a way to check if a directory exists?I create a directory B using the mkdir command within one SystemCaller and in another SystemCaller it copies file from directory A to B and it works.But the process must copy copy new files that are created in directory A and the mkdir gives an error because the directory already exists.

2002

9 months ago

mhabContributor

asked in Transformers

Preferred location of plugin DLLs

Since eternity and up to FME 2022 we placed our DLLs for self implemented transformers in FME_HOME directory.In FME 2024 it seems they need to be placed in FME_HOME\plugins directory ?!Since when is this requirement in effect ?Is there a way to influence where transformer DLLs are searched by FME ?

542

9 months ago

ciarabContributor

asked in Integration

Python Exception ImportError fme-form-2023.2.1

Some users in my organisation are getting the below error when using using fme-form-2023.2.1-b23774-win-x64. They have already looked at editing the path in environment variables and that didn't work. Any suggestions on a solution? Python Exception <ImportError>: This package should not be accessible on Python 3. Either you are trying to run from the python-future src folder or your installation of python-future is corrupted.Failed to import `fmesite'Python Exception <ImportError>: This package should not be accessible on Python 3. Either you are trying to run from the python-future src folder or your installation of python-future is corrupted.Failed to import `fme'(PythonFactory): The Python Framework could not be started. PythonFactory could not initializeThe Python Framework could not be started. PythonFactory could not initialize

1441

9 months ago

caracadrianContributor

posted in Integration

When will we be able to update FME Hub custom transformers to FME 2024?

Just update eterra3.ancpi.roGeometryFetcher. Updated all transformers to 2024, created a workaround for Tiler not completing a Conditional Value for $Parameter Contains/Begins with, created a test suite, uploaded .fmx and .fmw to the Hub.This is the Test Suite Failure Log:2024-03-12 20:33:35| 0.0| 0.0|INFORM|Current FME version: FME 2023.2.2.0 (20240205 - Build 23781 - linux-x64)2024-03-12 20:33:35| 0.0| 0.0|INFORM|System Time: 20240312203336 UTC2024-03-12 20:33:35| 0.0| 0.0|WARN |Workspace was last saved in FME version: FME 2024.0.0.0 (20240304 - Build 24187 - WIN64)Can’t run 2024.0 workspace on 2023.2.2.Please fix this!By the way, in case safers missed it: Something is wrong with the Conditional Value in transformers that only have Arithmetic Editor (for transformers that have both Text and Arithmetic Editor it appears to works)

INSPIRE validator problem

Hello, I have a problem with INSPIRE validator. I created a ETL schema in my FME Desktop environment according to INSPIRE theme of Protected Sites. So I've done it by applying all the technical guides from INSPIRE, and solved all my previous validation errors except this one: The dataset has 1 file(s) with errors for this assertion.XML document 'ProtectedSites ETRS89_jasmin.gml': The file has 1 schema validation error(s).XML document 'ProtectedSites ETRS89_jasmin.gml': 1:729: cvc-elt.1.a: Cannot find the declaration of element 'gml:FeatureCollection'.When I use the Hale studio for transformation and get my GML, validation process goes smoothly, but with FME I have a problem. During my analysis I saw that in Hale Studio GML I have a longer <gml: FeatureCollection > tag in the xxsi:schemaLocation part. Here is the Hale xsi: schemaLocation: xsi:schemaLocation="http://inspire.ec.europa.eu/schemas/ps/4.0 https://inspire.ec.europa.eu/schemas/ps/4.0/Prot

mr_fmeEnthusiast

Hi,I have a shapefile with lines, some of which show the degree of curvature...I would like to delete some lines based on the angle of curvature.How can I do that?

653

9 months ago

becContributor

asked in Transformers

Get output for all values in an Excel attribute field whether there is data for that value or not

I’m using FME Workbench 2023.1. I have an excel file with a Payment Type attribute field. There are 4 types:Cash Check Credit Card Money OrderNot all payment types will be present in the excel file each time this is run, but I need it to still have an output for that payment type. I’m fairly new to FME and used an Attribute Filter transformer to filter for each Payment Type, but when there are no rows in my excel file with a particular Payment Type, I will not get any kind of output. See below image for example of one of the areas in my script where I use this filter. I think I need to create a domain of values for the the Payment Type field, before this is run and maybe get a count? In the end what I need is if there are no payments of that type in the Payment Type field, then when I sum the payment amounts for each Payment Type, that particular Payment Type would need to be given an output sum of, 0. If you look in my below image, the only Payment Type that has an output is Cre

922

9 months ago

kushtrimContributor

asked in Authoring

run on quick translator just by double click?

Hello FME community, I have a workspace which I always run with quick translator. Since my user parameters are never going to be changed, is there a way that I can simply double-click on this file and it runs with quick translator without the need to click OK or press Enter to confirm the user parameters?

551

9 months ago

desubaranParticipant

asked in Transformers

Duplicate geometry in WFS

Hi,I have data from the WFS address, for parcels of land. I need to perform an additional check in which it will be checked if some of parcels are not duplicated. That is, I need to detect if there are two polygons, one on top of the other, in my layer in WFS in one place. Please give me some suggestions.

443

9 months ago

vxn43Supporter

asked in Transformers

Need to compare two values in two separate tables

I have two Excel Files. You can see from the screenshot, in the Visual Preview, I need to compare 95137 and 95138 in a Tester. Before I can do this, I need to “move” 95137 to row 1 (highlighted in yellow in the screenshot below) and have only one row in the table not two, what is the best way to make this happen?

GML Write for INSPIRE ExistingLandUseGrid Element

Hiich would like to write an gml Class "ExistingLandUseGrid" Object from the INSPIRE Specs http://inspire.ec.europa.eu/schemas/gelu/4.0Wenn adding a INSPIRE GML writer by pointing to the cooresponding GriddedExistingLandUse.xsd, the writer does not offer a featuretype "ExistingLandUseGrid" which is what i would expect. The only featuretype in the GML writer is "SpatialDataSet".Are there any options for the writer to enable writing a featuretype "ExistingLandUseGrid"? Or an example of a working script? RegardsPeter

121

9 months ago

bozboswellContributor

asked in Transformers

Use FME to connect to SQL Server Analysis Services data cube

Hi there.I am needing to pull data directly from a SQL Server Analysis Services data cube. Can FME connect to the cube?

874

9 months ago

harishContributor

asked in Integration

SQL executor working principle

I am using Oracle DB. My sql commands are update commands. I believe it is directly sending to the oracle to execute rather than regular transformer which execute in batches. Please clarify.

421

9 months ago

1
...
71
72
73
74
75
76
77
...
1108

Page 74 / 1108

Badge winners

courtney_mhas earned the badge Welcome Back
courtney_mhas earned the badge FME Form Basic Training
arhayeshas earned the badge Welcome Back
mariakahas earned the badge FME Form Advanced Training
johnzhas earned the badge Welcome Back

Show all badges

30,395: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.