FME Form

I use the AIXM 5.1 Reader with the default settings to read all AirspaceTimeSlice. Some of them are missing geometry. For example, I have a feature which uses xlink:href  to reference the geometry of a CTR. The CTR in itself has an UNION and consists of two CTR's which are also referenced with xlink:href. How can I get FME to get this geometry. It somehow doesn't seem to follow up on the xlink:href. I use FME Desktop 2019.2.3.1

I have 4/5 layers of rasters representing the geological horizons. I want to visualize the layers in 3D voxel. what the result look something  like this. Is there a way to get this with fme? 

I have a layer that contains 2 point line features i.e. start and end only, and I want to convert the start and end to points but have a count that keeps the parts in order. For example the start of the first line has count of 1 and the end of that line a count of 2, then the next line, start point would be 3 and end point would be 4. Each line has an ID so was thinking to try and group the points by line ID and then apply the count but can’t get the grouping to work as expected.   

Hi, Im trying to write approx 17.000 rows into an existing feature service in AGOL. I get the error "entity too large for url", so I assume its too many rows. I have tested with a few rows, and that works fine.  I have tried now to use the ModuloCounter and a TestFilter to split into smaller groups, and then add multiple AGOL-writers, so they only write one group at the time. Im not sure this is the best way to go, as I would the need a lot of writers. Another is to use the FeatureWriter to do the same, but I would still need to do the setup for all the groups, so not sure if thats ideal.  Does anyone have any better suggestion? Best,Anne Kathrine

With a permanent licence fme desktop hit much engines do we have available ? 

Using FME Form 2024.1.2 and QGIS 3.34.4 with Python 3.9 the following script:import fmeimport fmeobjectsimport sysfrom qgis.core import QgsApplication, QgsVectorLayer, QgsProcessingFeedbackclass FeatureProcessor(object): """Template Class Interface: When using this class, make sure its name is set as the value of the 'Class to Process Features' transformer parameter. """ def __init__(self): """Base constructor for class members.""" # Initialize QGIS Application QgsApplication.setPrefixPath("F:/QGIS 3.34.4/apps/qgis-ltr", True) self.qgs = QgsApplication([], False) self.qgs.initQgis() # Append the path where processing plugin can be found sys.path.append('F:/QGIS 3.34.4/apps/qgis-ltr/python/plugins/processing') from processing.core.Processing impo

I am writing a PyQGIS script (Python version 3.9) within FME Workbench 2024.1.2 Python caller transformer which has to run some processing tasks from the QGIS (LTR 3.34.4) processing framework:import fmeimport fmeobjectsimport sysfrom qgis.core import QgsApplication, QgsVectorLayer, QgsProcessingFeedbackclass FeatureProcessor(object): """Template Class Interface: When using this class, make sure its name is set as the value of the 'Class to Process Features' transformer parameter. """ def __init__(self): """Base constructor for class members.""" # Initialize QGIS Application QgsApplication.setPrefixPath("F:/QGIS 3.34.4/apps/qgis-ltr", True) self.qgs = QgsApplication([], False) self.qgs.initQgis() # Append the path where processing plugin can be found sys.path.appe

Hello all ! I need to create CSV where value will end  with a semicolon. I can do it using AttributeManager > @SetValue(SUP); but in that case it would add “ “ between attribute because it is converted to varchar. I need it without those “ “ but can’t manage to do it.Example below : 1st is my output and second is what i want. Only difference is those “ “.PS : Title is correctly formattedCODE_AL;NUM_AL;LIBELLELOL;LIBELLEC;SECTSTAT;ANCIENNE_C;NOUVELLE_C;CODE_POSTAL;PRO;REGION;PAYS;POP;SUP10;10;GEROMPONT Avenue des Déportés 74;GEROMPONT ;25122C11-;Gérompont;Ramillies;1367;Brabant Wallon;Région Wallonne;BELGIQUE;82;"0,099368;"CODE_AL;NUM_AL;LIBELLELOL;LIBELLEC;SECTSTAT;ANCIENNE_C;NOUVELLE_C;CODE_POSTAL;PRO;REGION;PAYS;POP;SUP10;10;GEROMPONT Avenue des Déportés 74;GEROMPONT ;25122C11-;Gérompont;Ramillies;1367;Brabant Wallon;Région Wallonne;BELGIQUE;82;0,099368;

I would like to find for each green point the closest orange building limited by the parcel border the green points are situated in. See the attached image below. The neighbourfinder should do the the trick but should not search in adjacent parcels for closeby buildings. Any suggestions? Ps. This is a snapshot of my data. I have about 700 green points and their parcels and buildings. 

Hello, In the case of having a permanent FME Desktop license, can it be reused on new machines ( i want to use it only in one engine so i would like to know is it possible to use it in anothe engine), or do we need to purchase new ones?

I have a dataset with spikes, and I want to flag records with spikes for manual inspection.I am aware of the SpikeRemover transformer. Is there a method of just detecting spikes? Not removing them but just flagging them? I would prefer to do a manual fix.

Wondering if FME can read QR-codes from images. Input is folder with images with QR-codes and some other content. FME should determine where to save those files based on the QR-code so just be able to read the code within workspace. Has anyone tried doing something like this? 

Hello,I’m having a hard time figuring out why a json file created with a Text Writer is not accepted by the GoogleBigQueryConnector.I have an original JSON Key File downloaded from Google Cloud for the Service Account we are using to authenticate to BigQuery. This JSON file works fine and I am able to authenticate and select the Dataset I want to upload data as well as the table in that Dataset.The problem is that since I have to use a system environment variable and specify the service account key file location in that variable in order for the GoogleBigQueryConnector to be able to use Service Account instead of Web Connection, it seems the GBQC takes the project_id specified inside that json file and uses it as default project to log you in, which means that even if you have access to different projects in BigQuery you can only access 1 project per Service Account Key File.Here is an image of the error I get for when the GBQC tries to use the JSON file

Hi,I have a workspace the reads json files: I need to publish this to Flow, and configure parameters to enable the user in Flow to read files from a certain folder. This will change several times, and I do not mind this part being a manual process.I am unsure of exactly how to configure this.I have set up a Folder and Pathnames user parameter:I have configured it to select Folders, and called this “SourceDataset_PATH”. I have then configured the parameter for the json reader to point at the SourceDataset_PATH parameter.

I have been unable to find a up to date compilation of the AI transformers and connections available in FME, is there such a thing?Specifically, I want to do some experiments with reverse image lookups.

I have a series of Feature Services in ArcGIS Online.  Unfortunately they contain attribute names of varied case. This is proving difficult for me when I try to create a dynamic workflow that updates the data in ArcGIS online.  When the Reader reads the source data (also of varied case), it converts them all to lower case.Therefore, when my workflow tries to write to ArcGIS online, it cannot find matching attributes to write to because the case is different.It is now too late for me to change all the layers on ArcGIS online to lower case because of downstream dependencies. Will I have to write a separate workflow for each individual layer and individually do the field mapping?Or is there a way around this ?

From a csv file, I determine the target layers that I wish to update on ArcGIS online.The following 2 transformers build the source layer name deriving it from the csv data.My source data name is an attribute titled “portalservice_andfolder”This is fed to a dynamic reader that reads my enterprise portal for each layer.There’s an issue with the Reader.  Refer blue summary for settings.I’m getting all the features come through but only the schema for the FIRST feature type only.Refer the below image which is the result <Generic> port from my reader.  The schema port has a count of 1 when there are actually 2 source layers.The image below shows that the fme attributes are missing for the second feature type.

I have a featurereader after a featurewriter which is writing 4 feature types. I have configured the dataset parameter as _dataset as per the output of the reader. What do i need as the feature types to read? I have tried _feature_types{0}.name _feature_types{1}.name _feature_types{2}.name _feature_types{3}.name and _feature_types{*}.name but neither work. _feature_types{0}.name by itself does work on the first of the 4 in that same parameter.

I have been having a consistent problem in FME for quite a while now, across both 2023 and current 2024 versions. I have a workspace set up which has a SQL Spatial reader, a few transformers, then a writer back to the database of origin.Any time I run this database, it goes through and successfully runs it within FME. However, as soon as I go to another source and read the database table(s) involved, such as SQL Server Management Studio or QGIS, I find that the data is still the exact same as it was originally, like FME had done absolutely nothing. Likewise, if I make a new table, it will simply make an empty table with only the columns/fields intact, with no attributes at all. I have no problems editing data from this database in QGIS or SQL Server Management Studio and have even had colleagues run the exact same FME Workspace with no such problems. I have also had two different FME installations on two different devices behave exactly like this.I'm pretty much out of

Hi I'm trying to update attributes in a copy of an MS Access database. The workbench fails at the writer due to a provider error '(-2147467261) invalid pointer. Any ideas as to what the issue may be?

Hi, Currently have a process that recieves a list of record id’s from Salesforce using HTTP callouts, the record ID include the ID of records from a custom object and the id of a number of users, we are trying to create an insert in the customobject_share to create records to give the list of userId access to the records from out custom object.  We currently are getting an error,Salesforce Writer: Record 1 was not processed successfully: 'FIELD_INTEGRITY_EXCEPTION:invalid parent id: Parent ID:ParentId --' The parent id is the record Id of the salesforce record we are creating a related share record against. the record exist in salesforce and in testing we have event tried hardcoding te ID of both records, and user Id with RowCause = “Manual” and Access Level = “Edit”. The form is running as using the Salesforce reader/writer with a System Admins login details? Thanks  

Hi,I have a scenario where I need to recode the pixels of raster, but the values are determined at run time.I have a list of from-to values, but what is the best way to implement that?The RasterCellValueReplacer will take attributes, but not a list.  Is there any way other than looping through the list and recoding the raster one value at a time?   There can be anything between 1 and 300 elements in the list.

Hello everyone,I am using the StringPairReplacer to find and replace short codes with their corresponding fulltext from a string that may contain multiple codes. It looks something like thisA1, A2(A3), A4 → Fulltext1, Fulltext2(Fulltext3), Fulltext4with the Replacement Pairs: A1 Fulltext1 A2 Fulltext2 A3 Fulltext4 A4 Fulltext4 This works fine, however the lookup table containing codes-fulltext translations may change in the future and I would like to implement a dynamic solution which doesnt rely on changing the workspace everytime something changes in the translation. I managed to create the correct text for the replacement pairs field using the SQL Creator from my translation database but am having trouble inserting this string into the appropriate field as it only accepts text and user parameter input. I am not too familiar with user parameters and cant seem to work out a solution to insert the dynamically created string into the StringPa

Hello,I would like to use FME to search for partial name matches (essentially a fuzzy string comparison) between two columns in different datasets.The challenge I'm facing is that it’s not a straightforward ID-based comparison. I want to pick a name from a row in one dataset and search for the closest match in a column of names in another dataset.Does anyone know a way to achieve this in FME, perhaps without relying on IDs?Thank you!

Hi there, I have a workbench published to FME Flow. In the workbench I have a SharepointOnlineConnector which reads in an Excel Sharepoint spreadsheet, and downloads it to my shared data source in Flow server.  The workbench runs successfully and the output (a table in ArcGIS Online) says it has updated, however the values are all old data.  When I run the workbench manually from Form, the SharepointOnlineConnector reads the current data in the Excel.  Any pointers on how to get Flow to read the current Excel Sharepoint?