FME Form

I am joining 3 tables together. There will always be a record in the first table and there may or may not be a related record in the second. If there is a related record, there may or may not be a record in the third. I always want to have the record from the first table.The relationships are as follows:Left: Table 1 primary key - Right: Table 2 foreign keyLeft: Table 2 primary key - Right: Table 3 foregin keyWhen I try and set this up using FeatureJoiner transformers, it works ok on the first, but if there is no record in the second table, it cannot join to the third as there is no left key. Is there any way to pass records with a null left key in FeatureJoiner? If I did a similar workflow in a Microsoft Access query I would still have the record from the first table. I presume I could use a FeatureMerger and pass Merged and UnmergedRequestor into the input of the next transformer. This could work ok but I do much prefer the FeatureJoinerM

Hello Community, I have a points dataset containing 17 records. Some at stacked at shared locations. Some are isolated in one location…  I need to separate this into two different streams. Stream one: all records that are at shared locations (i.e: sharing an XY co-ordinate pair)… Stream two: all records that are the only records at that location…   How is this achievable? Thanks,

Hi, I have simple workbench where outcome is saved as dynamic schema. Somehow, additional columns are added to attribute table of the feature classes in gdb. Any clue what is going on?

Hi,I was wondering if there is a way to format text that is used in the "Message" User Parameter in FME Form. There is no Text Editor available for the "Message Configuration" option and when I use the Parameter in a FME Flow App, line breaks are removed, although they show up when prompted in FME Form. Is there a way to keep line breaks?

Hello! I could make a 3D buildings with simple roof form, I got SurfaceNormal Z, so I could separate flat form roof. But I have a building with complex roof. So I want to separate the building from certain Z height, above it, it is roof and under it, it is body of the building. Do you have any Idea to get it?

Hi, I am working on translating data from numbers to phrases. I know using the String Replacer and Attribute Value Mapper is the best for this, but I am having issues when trying to map more than one value to one field.  An example would be the reason_of_given_set has multiple values, I need these values to populate with given phrases, each number represents a phrase. I provided the parameters of the transformer I am using below. I also tried creating 14 different string replacers to represent each number and each time the output shows blank at the attributes with multiple values. I am probably using the Attribute Val

I have a "Directory and File Pathnames" reader that gives me a list of text files in a Windows folder. I want to pass those folder and filenames to a FeatureReader transformer and be able to read the text lines from them as output for further processing, but I can't seem to get anything out of the FeatureReader other than the results of the Directory and File Pathnames that go into it. How do I get the contents of the text files out?

Hi,I am facing an issue where wall was not rendered properly by the FME inspector as it has direction issue. I tried "SurfaceNormalExtractor" but I didn't get any information out of the transformer. Please find the screenshot. Could you please help me in this regard. Same issue was posted 6 years back https://community.safe.com/s/question/0D54Q000080hfTrSAI/citygml-generation Wall not render properly in FME inspector   

I am utilizing the EsriReprojector and am getting limited results for datum transformation options from GCS_WGS_1984 to EPSG:6574. Is there a certain setting that needs to be applied to gain the other transformation options?

Is it possible to write into 'autocad_layer_desc'? A key piece of info/metadata that seems to be unavailable on DWG writers.

When setting the connections to Azure Database in FME Desktop, it does not have an option to use Active Directory Integrated authentication. It has only Windows and SQL Server Authentication. Is there possible to connect Azure Database by using Active Directory Integrate? Any help is very much appreciated.

The documentation for autocad_dimension features says that you can use an attribute "autocad_text_rotation" to rotate the text of a dimension.See autocad_dimensionHowever, I haven't succeeded in rotating the dimension text yet.I use "autocad_dimension_type" = autocad_aligned Any ideas?  

Hi, I'm trying to write an XLS file based on a template (according to this help), with complete rewriting of the data (Overwrite Existing File = Yes) and I can't find a way to keep the order of the columns according to the template in the output XLS and not in the order in which FME processes the attributes. For example, I would like that if I invert 2 columns in the template, it also inverts it in the output xls, without setting this with an attribute manager. Did I miss a parameter in the xls output that would allow this or is there another method.Thanks a lot in advance for your answers and best regards. Antonin

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 workflowRead update table -> Read GDB -> Update Hosted Feature Service Layer Any advice would be appreciated,Chad

PostgreSQL database login detailsHost: postgis.train.safe.comPort: 5432Dbname: fmedataUser:fmedatapassword: fmedata (not sure if it is that password) (getting ***) 

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 inputAttributeError: '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

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 acce

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 resultatle point 2 est proche du point 1et le point 1 est proche du 2et 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 clairmerci a la communauté de votre aide