FME Form

We have a client that has a unique need and I'm wondering if it's even possible in FME. There goal is to have a csv or table that contains a dataset name, itemID, and layerID. They also have a GDB file containing the datasets. The would like to have a function to cycle through their csv table, and overwrite an individual layer in an AGOL hosted feature class. The caveat is this hosted feature class may contain many layers and as far as I know you can't update just one layer. We have been racking our brain and FME seems like it may be our last hope. Here's the short version of the workflow Read update table -> Read GDB -> Update Hosted Feature Service Layer Any advice would be appreciated, Chad

PostgreSQL database login details Host: postgis.train.safe.com Port: 5432 Dbname: fmedata User:fmedata password: fmedata (not sure if it is that password) (getting ***)

In an Esri SDE database, fields (attributes) have a property setting of isNullable (Allow NULL). This property determines if the field allows null values or not. I want to be able to set this property in FME when I create a new feature class. Is there a way to set this property with the Esri Geodatabase SDE writer? See screenshot below to see how to set the setting in ArcGIS Pro.

I have a question, i am trying to join in a pythoncaller Only i am getting this error: BADNEWS: Cannot convert null string into an integer (C:\code\fme\foundation\framework\util\stf\stfutil.cpp:347) class StatusInfo *__cdecl STF_stringToUInt(const class ObsoleteString &,unsigned int &) Python Exception <AttributeError>: 'fmeobjects.FMEFeature' object has no attribute 'getAllAttributes' Traceback (most recent call last): File "<string>", line 14, in input AttributeError: 'fmeobjects.FMEFeature' object has no attribute 'getAllAttributes' Error encountered while calling method `input' PythonCaller_FeatureMergerReplacement (PythonFactory): PythonFactory failed to process feature The script i am using is: import fmeimport fmeobjectsimport pandas as pd class FeatureMergerReplacement(object): def __init__(self): # Initialiseer de DataFrames self.primary_df = pd.DataFrame() self.secondary_df = pd.DataFrame() def input(self, feature): # Voeg rij toe aan primary_df new_row = pd.DataFrame([featur

G'day, My workspace generates several rows of data, then goes through a statistics calculator so I can count the total rows of data. This total row is calculated so that I can email the user a summary of what has been done during the run process. What I am finding is that I am unable to use this fmt_acc.total_count figure unless I connect the Summary output through to the HTMLReportGenerator. When I connect this to the generator it ends up creating an additional row in my report with all NULL values, which is not ideal, so I disconnected it. I then use an emailer to send a copy of this HTMLReport, and in my email subject I would like to say "XX Number of Features Found, full list attached", where XX is the fmt_acc.total_count. Unless I connect this summary, the emailer has no access to this data. Can anyone think of a way I can include this fmt_acc.total_count in my emailer, without adding a dummy row in my HTML report?

Hi all, I have building footprints, DEM and DOM data, I have finished 3D modelling for DEM with overlaying DOM, and 3D buildings, while the bottom part of some buildings, especially those located along the foot of the mountains, are under the terrain. I have tried many ways like 3Dforce with values minZ, or chopper buildings to points and acquire the points cooridinate Z value, and also clamp function, while all failed. Anyone can help? thanks a lot.

I have an FME workflow that extracts planning overlays against the cadastre/properties. Some properties could have 5 or more planning overlays. I am currently using AreaOnAreaOverlay transformer and then a ListExploder to get all planning overlays against each property, otherwise not all overlays appear for some reason. ListExploder seems to show all overlays against each property but it duplicates certain overlays. It doesn't matter which transformer I use to remove the duplicates, the result still has duplicates. Also, when joining the result to the rest of my workflow I have a feeling it chews up too much memory due to the listexploder as I get a non-descript translation error, which online forums suggest it is due to memory usage. What's the best way to show all distinct overlays without duplicates?

I want to convert a ESRI Multipatch Feature class to IFC and wonder what the best practice is to write the feature into IFC writer. I am using FME Form 2023. Appreciate your help! Thanks

Hi, I'm prepared my fme as the picture attach. I use the transformer Offsetter to change the Z value. My sequence of the Z value is 0.01, 0.02, 0.03 etc. Can i know how to define Z offset based on requirement that I have been mention.

I am reading a large xml dataset - about 80GB .gz file - and send each feature in a PythonCaller that simply dispatch the content in different .gz files according to the feature type (since multi-writer will keep all the content in memory/temporary files). Seems to work since I can see the size of the different files increasing. however, Since it is being running for 8 days now (yes, 8 days), I wonder if I could eventually improve the speed of the workbench - parallel reading, processing, ... whatever could help! Daniel

Hi all, I have a dataset that contains a _dirpath attribute that I would like to use as the Destination Fanout Directory. My workflow injests CSVs from multiple different folders, and I would like to output the Writer data to the same folder that the data originally came from. Does anyone know if that is possible? I can't seem to set an attribute as an input for the Destination Fanout Directory. Any suggestions?

Version - FME 2020 How to import values in the user parameter dynamically(EX. Read the data from Text file(values in the text file keeps changing)

Bonjour j'ai un "nuage de points" et je cherche a les trier par distance : le resultat attendu est le suivant: le point 2 est proche du point 1, le point 5 est proche du point 2, le point 3 est proche du point 5 etc... j'utilise un neighborfinder en candidates only mais le probleme est que dans ce cas j'ai comme resultat le point 2 est proche du point 1 et le point 1 est proche du 2 et je ne les trie pas il faudrait que lorsque le point 1 est traité il "disparaisse" je ne suis pas sur d’être très clair merci a la communauté de votre aide

To previously set up our license server we followed the majority of info in this link: https://community.safe.com/s/article/create-fme-license-server The documentation show that the redhat-lsb-core package is required for the license server. The problem is the new Linux 2023 is based on Fedora and CentOS, whereas the previous Linux 2 box was based off the REHL 7, so it's now unavailable. Curious what others who may be required to upgrade their machines to Linux 2023 may have done or are planning on doing?

Hi, We recently upgraded from FME Server to FME flow and I've noticed that a few workbenches that contain only one python caller and a creator, are taking up to 10 times longer. Both environments hosting Flow and FME Server are identical in specs. Here are the workspace statistics from each environment FME Server: Average Elapsed: 12 minutes 44 seconds Average % CPU: 96% Average CPU time: 12minutes 20 seconds Average Peak Memory Usage 256mb FME flow statistics: Average Elapsed: 53 minutes 42 seconds Average % CPU: 19.4 Average CPU time: 10 minutes 42 seconds Average Peak Memory Usage 264mb Does FME flow utilize CPU differently when using python, or is there some setting I can change in the form workbench? I can see from the logs that simple arcpy commands are taking 10x longer and the CPU is being under utilized in FME flow. I've looked into the transformer and can't find any processing settings - Is there a setting in FME flow that I need to configure? I can't figure out why it's so m

i have two geodatabases. geodatabase 1 containing all lookup tables. One lookup table is source_table in which there is a column named "source_table_name" is added. Based on the values in "source_table_name " I want to select the feature class from geodatabase 2. I am getting output but its routing through generic port of the FeatureReader so no schema is being added. Can anyone help me solve this issue.

I'm new, so any help is appreciated. I have a SQL table that has lat/longs. Want to copy table into SQL Server SDE feature dataset with geom column. Tried the feature writer, but don't see where I can select the feature dataset.

I have a lookup table in which some feature class name is mentioned. I have to select in the feature reader only those features from geodatabase which in there in the lookup table. How to do that. One more problem here all my feature classes is in the feature dataset in input geodatabase. In output I want this outside feature dataset

Hi! I have a gml file that i have downloaded from the statistical bureau of sweden. This is the data source: https://share.scb.se/OV0105/Xml/PD/pd_befolkningsfordelning_totalbefolkning_nt.xml It is in GML format and the data is structured in 10km squares. However, I can't seem to be able to convert it to any other format. The geometry im getting is just a bounding box for the entire dataset, not the specific 10km squares. I have found very limited resources to help with this problem online. The final destination should be in an enterprise geodatabase. Has anyone else had trouble with this? Thankful for any help. /Alex

I am trying to run a Shell Script from the System Caller but am running into issues when accessing the various gdal programs that are called from within the script. These are stored away in usr/bin/ and "globally" accessible through the PATH file. The folder where the command is run is generated by FME in earlier steps, so its not as straight forward as copying the gdal files to the folder. Is there some workaround to get this functioning?

I have two datasets, one with 'old' parcels and one with 'new' parcels. I need to find out which old parcels turned into new ones and come up with a was - is list. Desired output: feature OLD parcel XX712 with a list with new parcel attribute(s): 557, 516 feature OLD parcel XX713 with a list with new parcel attribute(s): 584 feature OLD parcel XX713 with a list with new parcel attribute(s): 584 feature OLD parcel XX621 with a list with new parcel attribute(s): 189 What I have tried so far using the SpatialRelator with spatial predicates: Contains, Within, Equals Only works for parcels that stayed the same geometry wise. It is possible that geometry changed, see the example in the screenshots. Intersects This works but its giving me too much suppliers. When a parcel geometry has stayed the same its giving me a supplier from the parcel next to it because the outer lines are touching. Touches Giving me only the touching parcel to the side Am I doing something wrong with the settings in th

Is it possible to use FME to monitor servers and services that include the following: Request Failure Alarms (example includes when an internal or external website gets a 502 error) Response Time Alarms (example includes if a website takes longer to respond than usual) Available Storage on a server (example if storage gets to 20 percent then send an email notification) Server Unavailable (example is if a VM goes down) I know I can do these things using VertiGIS Analytics for the GIS side; but am curious to know what FME Form along with FME Flow can do, if it is even possible to do at least one or any of the things I list above? what transformers would be useful? maybe creating a few workspaces and publishing them to FME Flow.

We have some Annotation points all in one feature class. We are looking to find duplicated annotation text that are close to each other. We used the NeighbourFinder and attached the attributes from the neighbouring annotation to the base annotation. This allows us to see that, for example, record OD=1 is close to OD=2. Then a Test Filter is used to check if the TextString is the same on the base annotation when compared to the neighbour. From the results of the TestFilter we have a list of annotations that can be reviewed as it looks like they are close to each other and have the same text string (which may not be needed). So, for an example, say there are 100 annotation points that come out of the TestFilter. For each of these points, one of the other points in that selection of 100 points is the point it is related to/neighbouring. So, we don't actually need a list of all 100 points, just 1 of the points from each relationship, resulting in 50 points. Currently we are missing a relat

In the Desktop User Parameters dialog there is the option to "Save As User Parameter Default Values". I have server app and I would really like to use this feature so that the parameter information the user entered is retained for when they run the app again. I haven't been able to find a way to do this - is this possible? Many thanks 😁

Hello, I am writing features to a block that was created in a template. The attribute definitions in the block definition have their positions locked, but when I write a new file using the tempalte and block definition all the attribute definitions labels are moveable. I have been playing with settings and trying to figure out why it changes in the new file, but have not succeeded. Original Block New Feature (See all the insertion points on the text, text is also moveable)