• EN

FME Form

A space to discuss FME Form

26580 Posts

dor1411993
Contributor
dor1411993Contributor
asked in Integration

FME Flow Apps- redirecting to a loading GIF while running the job

I have a Flow App, which performs a relatively long process, which at the end directs the user to a certain url following the success or failure of the process.The url reference is made by a single HTML writer at the end of the process.My problem is that this process can take some time,And in terms of the user experience, the customers are not aware that the process is running behind the scenes.I want to make a reference to some kind of loading GIF that will at least show them that something is really moving behind the scenes..And this is where I need your help.Because if I write to two HTML writers, it simply downloads the two HTML files for me,It does not direct me HTML line after HTML, but simply disrupts the process.Does anyone have a solution?It doesn't even have to be a reference to the HTML of the loading GIF, just an indication in terms of the user experience that will tell the customer: "Don't worry, a few seconds and you move to the next screen"Thank you!Dor

5
kidega
Contributor
1 day ago
virtualcitymatt
Influencer
virtualcitymattInfluencer
asked in Authoring

Get a list of filenames based on the user selection?

I’m working on an upload process via REST call and I want to use FME to do the upload.For the API I need to provide a list of file names in advance. I want this to just work and I want to be able to use FME’s multiple file picker to allow the user to pick folders, multipler files or just a single file. etc.Does anyone have a good/robust method for getting a full list of the files (and filenames) that this input could be.My initial plan is to split up the input parameter into a list and then figure out what are folders and what are files and for folders I would use a PATH reader to get the files.I guess I need a “MultiFilePathResolver” kind of thing. 

2
virtualcitymatt
Influencer
1 day ago
drejkzet
drejkzet
asked in Data

PostGIS dynamic writer forces lowercase attribute (column) names

As is stated in the title. However I need column names to be created exactly as they are, for example I have incoming attribute "OGC_ANGLE.uom" and even though I have Lower Case Attribute Names unchecked,tables in database have column names are created lowercase ("OGC_ANGLE.uom" becomes ogc_angle_uom) - this is a problem, if I read those tables and try to use xsd to create gml again, as these attributes are unknown to the xsd, therefore failing creation of the gml. I could manually rename those columns, however I would need to rename those columns every time xsd file changes, which is why I need to do this dynamically in the first place, as those xsd files are going to be updated quite often... And it seems that the dynamic PostGIS writer ignores Table Qualifier, it always creates tables in default schema, unless I specify schema in Table Name (schema.@Value(fme_feature_type))

16
mats_anderberg
Participant
1 day ago
kathyjbryce
Contributor
kathyjbryceContributor
asked in Authoring

Dynamo DB - configure AWS endpoint for VPC

We have FME Flow (Windows 2024.0.1) installed in an EC2 instance in a VPC. The DynamoDB reader uses the public endpoint: dynamodb.<region>.amazonaws.com.Can this be modified to use a VPC endpoint?For example: vpce-0a06cf963f9d04a28-3wilx6xm.dynamodb.us-west-2.vpce.amazonaws.com We need to do this for all AWS endpoints, S3 and SQS.Thank you,Kathy

0
kathyjbryce
Contributor
1 day ago
E
ebrightc
asked in Data

FME Server change database to SQL Server

I am trying to change the FME Server database from the default Postgres to SQL Server. I have followed the instructions in this link: http://docs.safe.com/fme/2018.1/html/FME_Server_Documentation/Content/AdminGuide/Changing_Database_Provider.htmbut after everything is done, I cannot login as admin anymore. I get the login page to come up, and I can confirm that connectivity is there to SQL Server, but it won't accept my password for admin anymore.

3
crstnaiw
Participant
1 day ago
liamfez
Supporter
liamfezSupporter
asked in Authoring

Excel Column Formatting

When using Manual Attribute Definition in the XLSX Writer or FeatureWriter, is there a way to copy the Column Formatting between attributes? I have noticed that if I manually add a new attribute beneath one already formatted it copies the Formatting of the one above. But I was hoping there would be an easy way to set one, and then have it applied to all attributes.

0
liamfez
Supporter
1 day ago
dannymatranga
Contributor
dannymatrangaContributor
asked in Authoring

FME 2024.1 Beta Bug: Choice Parameters

My workspace is not keeping my user parameters settings. It creates extra blank parameters when I close the User Parameter Editor window, and then my choices become useless at runtime. I’m also not able to delete these extra blank parameters. Downgrading to the stable version of FME Form but wanted to note the bug here.

0
dannymatranga
Contributor
1 day ago
S
serg42932
asked in General

Hi, I am trying to use FME to create an Inspection in the Cityworks. How can I configure Answers for the Questions in FME? I believe I need to do that in the Additional Parameters Section but I cant figure out how to set it up. Can someone help pl

Hi, I am trying to use FME to create an Inspection in the Cityworks. How can I configure Answers for the Questions in FME? I believe I need to do that in the Additional Parameters Section but I cant figure out how to set it up. Can someone help please?

11
tbsm223
Participant
1 day ago
joy
Supporter
joySupporter
asked in Integration

Will there be Git integration with FME Workbench?

Hello everyone, I have colleagues who were wondering whether there would be git integration available with fme workbench.I understand now at the moment there is no integration directly in fme workbench with git. However it's possible to manually check in .fmw scripts in git I heard, but I think it would be an useful functionality if you dan do that directly from fme workbench. I was wondering whether something like that would be available in the future.

7
joy
Supporter
2 days ago
L
ling55
asked in General

Connection issue to MS SQL

Hey guys, I'm not sure if this is the right forum to ask, but I'm at a loss as to what to do here. I'm still quite new to FME and have tried looking for solutions to this problem that I am having.I have read this https://knowledge.safe.com/articles/281/failed-to-connect-using-sql-server-2012-native-cli.html and installed SQL Server Native Client 2012 on my machine, https://www.microsoft.com/en-us/download/details.aspx?id=50402, which wasn't installed before, but I am still running into the same issue.Details from the translation log:2021-06-05 13:14:39|   0.2|  0.2|INFORM|FME 2020.2.2.0 (20210111 - Build 20817 - WIN64)2021-06-05 13:14:40|   1.2|  0.0|INFORM|Operating System: Microsoft Windows 10 64-bit  (Build 19041)2021-06-05 13:14:40|   1.2|  0.0|INFORM|FME Platform: WIN64  2021-06-04 08:28:55|  45.6|  0.0|INFORM|Creating reader for format: Microsoft SQL Server Non-Spatial2021-06-04 08:28:55|  45.7|  0.0|INFORM|Trying to find a DYNAMIC plugin for reader named `MSSQL_ADO'2021-06-04 08

9
kailinatsafe
Safer
2 days ago
anteboy65
Contributor
anteboy65Contributor
asked in Transformers

PointOnPointOverlayer stores duplicates in list, how to read from Pythoncaller?

Problem in short:I have a lot of points which some has identical coordinates. PointOnPointOverlayer does this for me and store the “twins” in a list name. Now I want to use a Pythoncaller to loop through the list of each feature and figure out if some or none of the twin attributes has a value that should update the the major feature. The problem is that I cant seem to reach the list variable created in PointOnPointOverlayer from the Pythoncaller. It seems to be exposed when running with feature cache and checking output from PointOnPointOverlayer. What’s the magic for reading the list, looping throug it and check the attribute values? Tried this example code from the PythonCaller just to see if I could reach the list but can’t see anything:  

4
anteboy65
Contributor
2 days ago
fbastian73
Contributor
fbastian73Contributor
asked in Transformers

adding/appending from csv value to excel value

hello experts,I am trying something that to some of you may be quite simple so I hope one of you is able to help me out.All i am trying to do is to append/add the value cnt from the inlinequerier to the existing excel file.I am trying to write the cnt value into the count_of_errors value where the incoming feeder name is the same as the destination one (in excel file).thank you,fb

1
jkr_wrk
Enthusiast
2 days ago
cavarly
Contributor
cavarlyContributor
asked in Authoring

Writing null geometry features to ESRI file geodatabase

Is it possible to create features with a null polygon geometry and write to an ESRI file geodatabase?I have some features with known geometry which I write successfully.I would also like to write features with no geometry to the same table and update their geometry by manual editing later.I have tried modifying fme_geometry{0} and fme_geometry but nothing seems to work.I usually get an error like  “can’t write features to and area feature type” I have read through similar questions but don’t seem to have a complete response. It appears it is possible to create a valid null geometry. Thanks go any help.

2
frro
Contributor
2 days ago
fmegrinder
Contributor
fmegrinderContributor
asked in Transformers

Extract map extent from MXD

Hey! I have an 50 diffrent  MXD and I need to retive the map extent from start  in every mxd. There is an option to igonore map extents.But is there an an way to extract the start extent? 

0
fmegrinder
Contributor
2 days ago
fred.haan
Participant
fred.haanParticipant
asked in Data

Utility Network (UN) (Esri) - Update Attributes

Good morning,I would like to use FME processing to "periodically" update the values ​​of certain Utility Network attributes.This concerns the updating of data which potentially can be versioned, but I am only considering here the updating of "descriptive" (simple) attributes which are not involved in asset group assettype distribution rules and which have no impact on connectivity rulesDo you have experience of the best methodology to use and perhaps illustrate this with an example Workbench?THANKS 

0
fred.haan
Participant
2 days ago
redgeographics
Influencer
redgeographicsInfluencer
asked in Authoring

Importing database connections in FME on Linux, no gui

One of my clients is using FME on Linux with only the command line interface and is having some trouble importing database connections. Specifically: they don’t know how to do it on the command line.I can’t find much in the way of documentation for this. I suspect that if it is at all possible it may be through the APPLY_SETTINGS command, but other than that I can see that that exists, I can’t find any indication anywhere on what those settings may be and how to set them.Any clues? Anybody with an old manual somewhere? I do have old installation cd’s and dvd’s going back to FME 2005, but I don’t think I have a computer with a cd or dvd drive anymore 😅 Hoping one of the other long-time users has something stashed away...

9
virtualcitymatt
Influencer
2 days ago
jugoslaviaa
Contributor
jugoslaviaaContributor
asked in Integration

Tolopoly Builder wont break polygon

I have two polygon datastets and i send them to the Topology Builder so that they will get break at the intersection. However it does not give the result I expected. My expectation would be a similar result to thearea on area overlay  my output looks. The overlapping area are not broken. Any idea what i may have been doing wrong 

4
joepk
Influencer
2 days ago
cyoung
Contributor
cyoungContributor
asked in Transformers

Naviswroks to FBX to multipatch gdb?

Hello,I have a Navisworks 3D file of our facility that needs to be viewed in ArcGIS Pro and published as a 3D Scene. We exported it out to a fbx for City Engine which is then exported to a scene layer package to be viewed in ArcPro and this “works”, but we have a only layer with zero attribution. Is there a way I can either use the original Navisworks file or the fbx to break out the all the features withing the facility and create an output as a multipatch gdb?  sorry for my noobnessthanks in advance.-C

2
cyoung
Contributor
3 days ago
mlupien
Contributor
mlupienContributor
asked in Transformers

CSV content from SQL field to Features

Hi Community,I need to extract a CSV Style content from a SQL field of an SQL table.It is stored into a single field.The content looks like this:Classification,Fonction03-1,30003-2,301AA-10,C-1000AA-12,C-1000AA-15,C-1000AA-17,C-1000AA-20,C-1000AA-22,C-1000AA-25,C-1000AA-27,C-1000AA-30,C-1000As you can see, the first line gives me the Attributes names and the following lines gives me the valuesWhat would be the best way to turn this into multiple features using the first line as the Attributes names ?Thank you

6
mlupien
Contributor
3 days ago
scarter
Contributor
scarterContributor
asked in Authoring

HTTPCaller and 'bearer token' authentication method

Hello forum, I am working on a new API integration. I’ll be using HTTPCaller. The provider has said that their authentication method is ‘bearer token’ However the options in HTTPCaller are Basic, Digest, NTLM, Web Connection, Single Sign-On. Is one of the those options equivalent to bearer token? Thanks,Stuart

8
virtualcitymatt
Influencer
3 days ago
syahrastania
Observer
syahrastaniaObserver
asked in Data

Error while trying to open IFC file. Error ISO10303-21: The input data contains a syntax error

Hello.I’m trying to convert and IFC file into CityGML 3 file using the ifc-to-citygml3 FME Workspace, but when I tried to Run it, it shows this error.ISO10303-21: The input data contains a syntax error at the beginning of the file. The file should start with 'ISO-10303-21'. Ensure the file is in an ASCII character system, with no byte order marker.Unexpected character: #ISO10303-21: Invalid file format, unable to continue reading Can anyone help me fix this issue?

1
virtualcitymatt
Influencer
3 days ago
P
pqtkha
asked in General

How can split polygon (rivers/roads) into branch?

How can split polygon into branch like this image?Each branch showed by a number. And the split positions are yellow lines like this Everyone has any ideas to solve this my issue, please show with me! Thank you so much!

11
jennychu
Participant
4 days ago
lennertpronk
Contributor
lennertpronkContributor
asked in Transformers

maximum amount of non-neighbouring polygons

Trying to find a  way to find the maximum amount (highest density) of polygons with the rulethe polygons must be non-neighbouring. Essentially selecting a polygon and jump to the next polygon which is not neighbouring and so fort and so on until you encounter a neighbouring one.See attached picture which I hand-picked.

2
lennertpronk
Contributor
4 days ago
fme_dr22_forum
Contributor
fme_dr22_forumContributor
asked in Transformers

looking for a transformer tool in FME to compare two GIS datasets

Hello fellow FME-ers. I'm looking for a transformer to compare two GIS datasets and what has changed compared to each other. Actually, the Symmetrical Difference tool that is present in ArcGISPro. This transformer must be there in FME. Can anyone help me with this? Thanks in advance.

8
liamfez
Supporter
4 days ago
gisbradokla
Contributor
gisbradoklaContributor
asked in Transformers

tester with wildcard for "only" any folder following

I have a test looking for many possible cases. one of the cases I want to find is Any folder inside of any folder that has some specific names. (BTW I am using directory and File Pathname reader to create a list) and then a tester to get all of the special cases.)I have a test line like path_directory_windows CONTAINS *\project_data\working\**\*I don’t get any errors with this syntax but it does not find the folders. Basically i am only wanting to find folders within any project_data\working folder that contain any files.If it doesn’t contain a file I am not concerned with it.Any help with a correct regex statement that would work, or the proper syntax for the contains statement are what i am needing.I have tried this regex unssuccessfullyproject_data\/working\/[^\/]+\/[^\/]+TIA 

8
gisbradokla
Contributor
4 days ago

Badge winners

Show all badges
28,807
Posts
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.