Skip to main content
  • EN

General

A read-only category for lost FME Form topics. We hope to move them shortly.

  • 4,042 Posts
  • 13,932 Replies
4042 Posts
A
asadamjad
asked in General
Seeking Assistance with FMe Test Filter Challenges

I am new to FMe, and I am struggling with the Test filter. Here is what I'm trying to achieve:If 'No_Feature' has both 'Insert' and 'Un' values, then it should pass.If it only has 'Insert,' then it should pass.If it only has 'Unchanged,' then it should fail.I have tried everything, but I haven't been successful. Is there anyone here who can help me out?I am attaching the workspace for your reference.

120
A
bhagyashrisingh
bhagyashrisingh
asked in General
How can we handle Symbology (or preserve Symbology) in FME while reading data from ArcGIS online feature layer?

How can we handle Symbology (or preserve Symbology) in FME while reading data from ArcGIS online feature layer?

690
bhagyashrisingh
galigis
Enthusiast
galigisEnthusiast
asked in General
Better use of ExpresionEvaluator

Hi Community, I have created an FME workflow to complete a RAG analysis (Red, Amber, Green) and need help to automate the very last step of the workbench which uses a ExpressionEvaluator transformer. For now I have included 14 different ExpressionEvaluator transformer to calculate the average value of the 14 RAG guidelines, here is an screenshot of the 14 transformers: ...but what I want to improve is the way of each of these 14 guidelines are being calculated as the ExpressionEvaluator transofrmer uses an expression that manually needs to be updated each time a new dataset is added into the analysis, here is an example of the expression:  If an additional dataset needs to be included then I manually need to change the expression from 5 to 6 as divider...and trying to avoid this. Is there any way I can tell FME to update the divider if new dataset is added? Ultimately I want to make the average calculation as a Custom transformer.   

140
redgeographics
Celebrity
F
fmesafejde
asked in General
How to add to existing value

Currently I have few AttributeCreator to do the following: Insert numbers into table if no matches found (Attribute Value=INSERT) Replace number into table if matches found (Attribute Value=UPSERT)However there's a need to add numbers to existing values. Do not see any APPEND or ADD attribute value from the dropdown.  Any help would be appreciated!

1220
redgeographics
Celebrity
jared_bloch
jared_bloch
asked in General
How can I upload a test workspace that tests an Authorization Code flow Web Connection?

I am trying to publish a new Web Connection to FME Hub that uses OAuth 2.0 Authorization Code Flow. My test workspace fails when FME Hub tries to run the test workspace. I suspect it is because the Authorization Code flow requires user interaction. Is there any way to successfully test this workspace that calls the Web Connection I am trying to test?

60
jared_bloch
nielsgerrits
VIP
nielsgerrits
asked in General
PythonCaller list to feature

To get the number of features from a FeatureClass in a File Geodatabase you can use arcpy's GetCount.arcpy.management.GetCount(<featureclasspath>)So I tried and got this working.import fmeimport fmeobjectsimport arcpy class FeatureProcessor(object):     def __init__(self):        pass     def input(self, feature):        arcpy.env.workspace = feature.getAttribute('path_windows')         feature_classes = arcpy.ListFeatureClasses()                fc_list = []         for fc in feature_classes:            count = arcpy.GetCount_management(fc)            fc_list.append((fc, int(count[0])))            print(fc_list)         self.pyoutput(feature)    def close(self):        pass     def process_group(self):        passBut no matter what I tried, I could not get the list to the feature. I expected it to be something like:feature.setAttribute("fc_list",fc_list)The log keeps reporting the error:Python Exception <TypeError>: Could not convert attribute value to a supported attribute

962
nielsgerrits
VIP
angwan
Contributor
angwanContributor
asked in General
Sorting 'date' using sorter with option Alpha/Num does not work Sorting 'dates': Regular sorter on dates( e.g 26/05/2023....) as alpha/num options do not work.Could there be another way to do this date sorting?

2170
angwan
Contributor
O
olivertishmael
asked in General
How can i preserve aliases when writing data to a geodatabase?

I have a File geodatabase with field aliases that are in the correct case that I wish to preserve, however, I need the field names to be in uppercase.  I have tried to do this using the AttributeExposer, followed by a Tester:with the values that end with _alias being passed directly to the writer while the values that fail i pass to a BulkAttributeRenamer to convert them to uppercase before passing them to the writer.  - but i don't think the aliases are being passed to the writer properly because everything ends up in uppercase. How can i correct this, preferably while still using the Tester transformer?

690
topf
D
dvanderwel
asked in General
SharepointOnlineConnector - filtering by file extension

Hello,I'm relatively new to using FME and have been tasked with synchronizing a local folder and it's subfolders with Sharepoint. I have installed and configured the FME SharepointOnlineConnector and it is successfully synchronizing the contents of the folder and it's subfolders to Sharepoint in its default configuration. The only issue I'm having is there are some .xml files that are present in these folders that I do not want to synchronize. Does the connector provide any means of white or blacklisting specific file types from being uploaded? If not, does anyone have any suggestions on how this would be best accomplished? The section titled "Clean up your SharePoint Documents" in the following link would allow me to delete the unneeded files after the load, however this is not ideal as it would mean the files are unnecessarily created and deleted on every load.https://community.safe.com/s/article/Reading-and-Writing-SharePoint-Libraries-with-FME Ideally I wo

160
nielsgerrits
VIP
couch
Contributor
couchContributor
asked in General
In FME flow if I had a process which downloaded physical files to resources folder but as part of the data workflow, these files will need be deleted once files are utilised, what is the best way to go?

In FME flow if I had a process which downloaded physical files to resources folder but as part of the data workflow, these files will need be deleted once files are utilised, what is the best way to go?

200
couch
Contributor
magda_cz
Contributor
magda_czContributor
asked in General
Update creation date to the writer

Hi, I have las files to process and update the SDE as contours. One of the attributes which I need to include is a creation date. Unfortunately, when I try to use Attribute Manager to create the new column 'DATE' the value based on 'las_file_creation_date' is added as a new row and doesn't update the whole column as the attached print screen. Does anyone come across similar problem? Thanks

120
tomfriedl
Contributor
mr_fme
Enthusiast
mr_fmeEnthusiast
asked in General
Merge Lines

Hi, I would like to merge the two lines below into a single line, since they have the same ID field number, and the other information is the same, except VARIED, which can be any value, either BBC2 or BBC4. How can I do that? Thank´s 

190
mr_fme
Enthusiast
B
bhocker
asked in General
How to change scanner_channel for only specific source_id in multiple las files?

Hello,I have numerous las v1.4 pdrf 7 tiles from a dual channel airborne lidar sensor - there are multiple source ids (flightlines) in each tile, and most have the scanner channels coded correctly as 1 and 2.  One line however has the scanner channels coded as 0 and 1. Is there a way in FME to go through all of the tiles and only change the scanner_channel for a particular source_id?  I would envision a script running through all of the files, then at any instance where the source_id matches a user defined value (the flightline with the problem), then it would change then scanner channel from 1->2 or from 0->1 while retaining all the other non-matching points, and all other parameters such as classifications. Thank you for any tips or suggestions,Ben

100
danminneyatsaf
Safer
lifalin2016
Supporter
lifalin2016Supporter
asked in General
Wallpapers for 2021 ??

When, oh when, will the wallpapers for 2021 become available ??I have a wall to decorate ......

700
lifalin2016
Supporter
W
wheels496
asked in General
How to execute a PowerShell script or even a simple batch file?

I have a power shell script, which retrieves data and saves it to a Jason file. I can run this with a Windows schedule task. I have successfully created a FME project which retrieves that data and populates a database table. Now we want to look at the possibility of executing the power shell script, within the FME project. I have tried this with a SystemCaller but it does not work. Therefore I tried to simplify it. I have created a batch file that appends the current date time to a text file. I have tried using this instead, but when I run the workspace, the text file is now updated scratch that is not updated.Note, I have tried it with the full path as well as just the name of the batch file. Can anyone advise? Thanks 

202711
paalpedersen
Contributor
billmcbride
Contributor
billmcbrideContributor
asked in General
GeoPDF to CADRG: How to in FME?

Background: We have an almost complete library of Vietnam-war era topographic maps in CADRG format. There are some "holes" in the coverage that I am trying to fill. We use these maps as a background for creating tactical overlays of battlefield information, unit locations, prominent terrain features, etc. I am a Vietnam Vet (USMC), and these maps/overlays/annotation are provided to other vets and researchers at no cost. Up until now, I've use an assortment of other programs to covert both geo and non-geo map imagery into CADRG files (gdal, QGIS, GeoRect, CadrgConvertor, Open Map, Gimp, etc), and as "viewers" and overlay editors of the CADRG use primarily FalconView and Open Map. I'd like to learn how to use FME to do this end-to-end if possible. I've tried a few basic conversions in Workbench with varying degrees of success...mostly trying learn by and adapt work by other users. I'm a very basic user. Much of the source material for the map i

740
billmcbride
Contributor
thijsknapen
Contributor
thijsknapenContributor
asked in General
How to use/access the parameter of an FME Flow Network Based Resource in FME Form?

On FME Flow we added a Network Based Resource. In FME Flow, I can see that the system path of this Network Based Resource is characterized with a parameter, e.g. '$(My_Network_Based_Resource)'. I had some trouble on using that parameter in a workspace with FME Form Workbench. FME Form is not aware that this parameter exists, and upon using it in e.g. a path reader.Is there any way that you can expose additional FME Flow parameters to FME Form Workbench? As a workaround I was able to use a ParameterFetcher, and then feeding in the attribute value of the Network Based Resource into the FeatureReader, but that seems not ideal. Also, the ParameterFetcher does show a Red Cogwheel, because it is not aware of the parameter. Another alternative is probably to create an additional 'FileURL' type of parameter, and set the (default) value for that parameter to '$(My_Network_Based_Resource)'. However, also here it seems that you are then forced to make the FileURL parameter

2050
laurawatsafe
Safer
scarter
Contributor
scarterContributor
asked in General
Authentication methods in HTTPCaller

Hello Forum, I looking into using FME Desktop to connet to an API using the HTTPCaller.  HTTPCaller requires a selected authentication method. The options are: Basic, Digest, NTLM, Web Connection, Single Sign-On. However the API owner has said that their authentication method is "Bearer Token (with an API key provided)". Is this compatible with any other the existing authentication methods available in HTTPcaller? Thanks,Stuart  

4260
scarter
Contributor
spiderman
Contributor
spidermanContributor
asked in General
How to convert multi line strings in cell into one line at the same cell ?

Hello ,How to convert multi line strings in cell into one line at the same cell ?I have many cells that include the strings in two lines at specific cell includes building CR LFone side i want to change the two lines into one line to be building one side in one line at the same cell CR LF : created from Fme ,I am not sure what does it mean ?fme 2021  

3031
nielsgerrits
VIP
spiderman
Contributor
spidermanContributor
asked in General
How to find which number closet to other number ?

Hello how to find which value closet to another value ? i have 4 id id -value 1 - 152 - 403 - 704 10how could I find which value of id closet to another value of another id more than others .As example , my target to know that id 1 and id 4 are close to each other and id 2 and id 3 ,close to each other fme 2021

420
nielsgerrits
VIP
alfons
Contributor
alfonsContributor
asked in General
Matching two datasets and keeping the highest point?

Hello I have several point data sets (different Excel files) that I would like to clean up. I would like to delete points with the same position (X,Y) and only keep the point with the highest height (Z).I am currently deleting points with the same position with the Matcher Transformer. This works wonderfully. Now I have not yet found a way to say that the highest point at the location cannot be deleted. Is there a way in FME to influence the selection of the points to be deleted when cleaning different data sets? The height of the objects is available both as attributes and as 3D coordinates.Thanks a lot

260
nielsgerrits
VIP
M
melvinvox
asked in General
What happens when you score a 78 in the proofessional certification exam

What happens when you score a 78 in the proofessional certification exam

831
danminneyatsaf
Safer
naveen
Contributor
naveenContributor
asked in General
Python script to invoke FME workbench and ArcGIS Pro dependency

Getting this error message : "Unable to perform any licensing related tasks. Please check your Esri ArcGIS Compatibility setting. This 64-bit version of FME requires ArcGIS Desktop along with 64-bit Background Geoprocessing; ArcGIS Pro; or ArcGIS Enterprise. Refer to this this article http://fme.ly/qua for more details FME version installed : 2021.2.6ArcGIS Pro installed 2.9.0 Triggering using the command as shown in the screenshot, but it fails with above error message. Any ideas pls? 

2680
naveen
Contributor
chau
Contributor
chauContributor
asked in General
Milliseconds are lost when reading from Geopackage?

I have used FME 2022.2.5 to write datetimes with millisecond accuracy to a Geopackage. But when I try to use the same FME and a FeatureReader to read the datetimes from the Geopackage I get truncated datetimes with second accuracy.  When I use the SQLite format in the FeatureReader when reading the features, the datetimes include millisecond accuracy.  I have inspected the Geopackage using DBeaver and there I can see the datetimes with milliseconds and the type is DATETIME. I would expect FME to be able to read DATETIME's from a Geopackage file with millisecond accuracy, but that might not be the case? Regards, Casper  

150
daveatsafe
Safer
M
mbatinic
asked in General
Deleting duplicate records and relocating entries in FME

So, in the "List" table, I have, as far as I've seen, some duplicate entries. For example, in this image, rows with ID 2404 and 2405 are duplicates of IDs 1 and 2. I believe I have duplicate entries for all lists like that. Could someone help with how to solve this, or rather, how to delete duplicate entries?In the "RecordBoundaries" table, I must not have records with the same ID. I should do the following only for duplicate IDs because they belong to the same document: for example, let ID_Record 357 be one record, and the "creation date" is always an older date (January 1, 1861), while for the "confirmation date," the attribute from the duplicate record should be used (January 1, 1863). So, the process should be done only for duplicate IDs because there must be one record each for themselves.P.S. I have attached both files, "Popis" and "ZapisnikOmedjivanja," so you can immediately try with them and send back the edited f

1250
M

Badge Winners

Show all badges

Community Stats

31,773
Posts
120,715
Replies
39,396
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.