General

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?

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.

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?

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

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 

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

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

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 

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. 

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  

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  

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

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

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

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? 

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  

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.

I am working as a consultant for Consortech Solutions and I have a client who is trying to make his G3 Smallworld connection work in FME using the SBS Plugin for Smallworld. Unfortunately, the reader in FME doesn't work all the time. When it fails to show the table to choose from for reading data using the SBS plugin for Smallworld reader, the error message returned is "Bad or Invalid License for feature: spatialbiz_read [-12]". What's weird is that sometimes he is able to read his data in FME using that same reader but sometimes it fails to read the data.  Is that something people have experienced in the past and if so, is there a way to solve this issue?

I have 200+ shapefiles I would like to read in and merge into a single fgdb feature class. Some of the shapefiles have slightly varying schemas. Is there an efficient way to read them all in at once and validate if the schema is the correct format I would like? Rather than going through them one-by-one?

Hi all,I'm new to AIXM data but I'm facing the challenge of converting GIS data to AIXM 5.1. I am beginning to understand the structure and complexities of the model and I also went through the article and FME template that is online here. I can write out the desired structures but I can't write geometry. It seems it expects an attribute called part{} for the geometry. I have tried different variations of renaming and extracting the geometry.  Edit:Theres's an example of writing to FILEGDB to AIXM and back in this webinar, but the workspace itself isn't available anywhere. https://www.youtube.com/watch?v=3KW0Bj01Wj0&t=960s&ab_channel=FMEChannelWould it be possible to share this AustriaObstacles filegdb to aixm workspace? Any pointers would be greatly appreciated!Thanks!

Hello , How to solve self intersection ( p-case ) ?i would like identify which lines has p-Case and solve this problem ?as example I have a line with specific id starts at point and closed back at the same point .Will be possible to let the line to cross this point and no intersection at start point ,if it is possible .Thanks in advance .FME 2021

Greetings,I used FeatureJoiner to merge a Spatial and non-spatial records using a common value (grid_id).  I use a Tester to select a scenario ie date is 2000, 2030, 2040, etc.I then use a StringConcaternator to add a value to a cell (overwrite cell value), the cell for 2000 will be 0 -5. I also have a Tester for 2030 (2C), 2030 (4C), 2040 (2C), 2040 (4C), etc. The records in the FeatureHolder, should all be written to a single row.Instead I have a row per date/scenario?? For 2000 I have the following data. The output is written over n rows, not a single row??

I've built an AutoCAD based automation in FME Form and use blocks with text for some of the output features. The text aligns how it was designed in the block in the FME Form output.   However, when running in FME Flow the text shifts. If I move the block slightly or edit the text in AutoCAD then it snaps back to the correctly designed position.I'm using the same template dwg in FME Form and FME Flow. 

Hello,I have a main table called "Documents". I need to create a table called "List" based on data from the "Documents" table. Within the "Documents" table, I have a column called "ElaborationType," and within it, the number 1 represents the main document. Numbers 6, 14, 33 represent documents related to the main document, i.e., they are lists. My goal is to generate results in the "List" table where the "RecordID" in that row matches the "ElaborationType" equal to 1, but it also repeats or duplicates that number based on the numbers 6, 14, 33.(EXAMPLE: 2302(6), 2304(MAIN DOCUMENT NUMBER 1), 3177(14) belong to the same group because they are in the same cadastral municipality KO_ID).Within the "List" table, I need to have 2304, 2304 because they are lists for the main document 2304, and they must have their corresponding year from the "FromYear" attribute.I