Transformers

Hi,I have a SQLExecutor with a dynamic SQL Server query like:SELECT * FROM value(@table_name)Obviously, as it is a dynamic query I don't expose any attribute.Then, I connect the schema and generic outputs to a featureWriter (CSV).When I run the workspace, It finish suscessfully but It doesn't generate the CSV file.The same problem if I try to generate the CSV file with a dynamic writer instead of a featurWriter.However, if I replace the SQL Executor with a dynamic featureReader, the CSV is generate correctly.I need a SQL Executor because the query will be a bit more complex.I think It is something related with schema but I missing something.Could anyone help? Thank you un advance! Regards. 

Hi all, I have a GeoTIFF with 1 rasterband (UINT8) that has palettes with 3 values (RGB).Example: I will convert this tiff into a three channel (RGB) tiff.Is this possible with FME? thanks in advance!

Is it possible to run workspace runner with “wait for Job to compete” = YES and setting a number of the concurrent processes? It should work the same way as “wait for Job to compete” = NO with the only difference on the time of showing the success or failure of the process run.

Hello.Is there a possibility to read an ifc file, retrieve a list of all attributes (like it is present after running a workflow once and click on import from feature cache in the attributeKeeper), be able to select the ones to keep and keep only those in the writer? Or at least read a textfile with a list of attributes separated with , and use them as attributes to keep?I build a workflow to work with IFC data and at the moment I specifically create a “new” workflow for every file, manually adjust the attributeKeeper from the feature cache and run the workflow with the same file a second time. I do not know beforehand which attributes are included in the ifc file, and it can differ with each file.I already figured that the attribute keeper can’t work with user parameters. I tried using the Attribute Exposer with “Import from Dataset” or the Feature Reader Schema Output for a dynamic writer...but either I did not understand the answers given in other community questions or I did someth

Hello! I have recently started working with FME Flow. I’m just testing the possibilities of writing to the Fme flow temporary resource directory, which causes the translation to fail immediatly. My script is just a reader, which in this case is reading from a shapefile, as well as a feature writer. The featurewriter is set to write to [FME_SHAREDRESOURCE_TEMP] and the response i’m getting when running the workspace is this:  Has anyone encountered this before, and is there any hope for me and my workspaces in FME flow? Thanks!/Alex

Hi,I have a shape file and want to create some geometries and annotations and export them as IFC.The geometries are correctly exported. But the Annotations are really small in the exported IFC file. I used the Scaler before exporting the IFCAnnotation. But the problem is that the scaler doesn’t change the Size of the text, but also the location of it. Can anyone help me please to make the Annotations larger and also have them in their correct location?

Hello! I just got ortho images from Realworks, but I got images without coordinate system and some information in txt format. Is there any way to put this txt file as a coordinate system in FME?At last, I would like to get EPSG : 3857 geo referenced ortho images.   

Hi everyone, I have some DEMs. I combined them (PointCloudCombiner) and have created surfaces on them (PointCloudSurfaceBuilder) and exported them as LandXML. The problem is with the borders of the DEMs. They are not connected. How can I solve it?Thanks! 

 Hi, I am having an issue with feature readers and XML. I have a process which downloads an XML file from an ftp site, and the file name changes daily.  Upon download, I am trying to trigger a second process which reads the downloaded xml, so I can then split it into separate records (hence why reading in as text will not work, as I need the xml fragments). I use a path reader, to get the file name, but when I put ‘Path_Windows’ as the dataset, i get this error: error message  If I choose to ignore the message, and run to the featurereader, It reads in the correct amount of records (59), but the schema is blank. Blank Schema Log Error message   Now, i know for a fact that my xml does in fact, have a schema, because if I hard code the file name in the feature reader, it works perfectly fine. (see below)   FeatureReader with hard coded file nameSuccessfully read The parameters are identical on both.  FeatureReader Parameters  I am at a total loss as to why when I want to put in a dynamic

Hi All,I have created a workspace that reads all GDBs included in a folder (and subfolders) and export a few attributes to an excel file but now need to bring the GDB name (path_filename) into the final output. I tried to expose the attribute to bring it along the workflow but seems isn’t part of the unexposed attributes.I was expecting to see the GDB name as part of the Generic elements (within the unexposed attributes) but the GDB is only in the <Schema>,How can I bring the GDB name as column in the final output (excel file in this case)?<Generic> screenshot<Schema> Screenshot 

Dear FME community, apologies up front for being a novice python userI am trying to use the python caller transformer to execute an external .py file. However my external .py file does not have any classes therefore I don’t know what to do with the ‘Class to process features’ parameter in the transformer. If I run the python caller regardless, it executes my .py script fine, but crashes at the end with this error message “PythonFactory failed to load python symbol `FeatureProcessor'”. This is because I’m using the default ‘FeatureProcessor’ as my parameter for the “class to process features”, which I know is wrong.My python script simply generates a JPG file and saves it to a directory.I hope someone can assist and I haven’t totally missed the point.Regards, Damian

I need to transfer a file to an external agency, who has set up a ftp filedrop locationI am required to use TLS/SSL Explicit encryptionI have been given an ftp URL ftp://a usernamea passwordAlso, my organisation has a proxy server, which I think I have to specify in some wayIs FTPCaller suitable for this task? 

Hi everyone! I am new to using FME software and I am trying to use FME Form to extract information from a PDF using the Adobe Geospatial PDF reader.  I was wondering if it was possible to somehow extract the color of the text in the document. For example, if I had a PDF document with yellow highlighting and blue highlighting, being able to extract the bits that are only yellow and only blue.  Thanks!

Hi, I have been working on CESIUM 3DTiles generation, but I am facing challenges because the results are not aligned with my intended goals. Specifically, I am unable to achieve the desired mesh quality. The input files consist of a GeoTIFF with a resolution of 6 centimeters per pixel, and the point cloud data is stored in a LAZ file containing over 250 million points. Despite these inputs, the resulting mesh quality remains disappointingly low. I am seeking guidance on how to improve my workspace and achieve a high-quality mesh. 

When I run: .\fme.exe python -m spacy download en_core_web_sm I get the following error: Expected an even number of command line arguments, instead got 3 for command line: >>  `pip'  `install'  `https://github.com/explosion/spacy-models/releases/download/en_core_web_sm-3.7.1/en_core_web_sm-3.7.1-py3-none-any.whl' <<Program Terminating I was able to install “spacy” to my Python environment, however I need to install the models for spacy as described here: https://spacy.io/usage/models Is there anything I can do about this error?

Hi all,Is it possible to tile a raster based on the defined polygons (coming from a shape file) and not based on the dimensions or number of tiles?

 Hi everyone ,Is there any way to create an area using the limits of area geometries in input ?For exemple , if my geometries look like this  : and if I use the BoundingBoxAccumulator transformer ,it only creates a box based on the limits of the input . But I want the output to be like this :  Any Insight is much appreciated !

I have a very long list of attributes that I have typed into an AttributeValueMapper transformer. I now want to share this mapping with someone (not an FME user), so I would like to export the source and destination values to excel. I see that there is a button to import to this transformer, but not one to export. Is there a way around this, or doing I have a lot of typing to do?

Hi,I am extracting GIS layers into a DWG file using FME 2017.0.1.1I would like to define the color of Autocad block attributes using Red Green Blue (RGB) codes (autocad true color) instead of autocad color values.The RGB values are defined in an Excel settings file that I call up in the transformer “AttributeCreator” :However in the output DWG file, the color is defined by an autocad_color value (very close to the RGB value but not quiet the same), but it doesn’t write the RGB values in an autocad_true_color attributes.I also tried to create an autocad_true_color attributes defined by the RGB codes of my Excel file but it doesn’t work neither (same output).Is there a known limitation in FME working with autocad block attributes with autocad_true_color? And is there a known workaround?Thanks in advance for your support.Aude 

Hi there, I am trying to create a 3D photo mesh using LiDAR and aerial imagery, but find using the TIN Surface produces a more jagged output, even with a higher tolerance. I was wondering if it’s possible to do this using a DEM and if this would produce a neater result. I am using Surface Modeller to convert the LIDAR to TIN Surface. I then remove existing appearance and hook up the result along with the aerial image to the appearance setter transformer.What should I be using to get a neater output or is TIN the only way to go?Regards, Josh

Hello everyoneI am currently working on a project where i have to create an ifc file from a CAD floor plan.in fact in order to do that i have some issues to solve, one of them is that i have to create gaps in walls for doors and windows, for that i thought of extruding the walls and doors twice using two extruders  to create solids and use CSGbuilder to create the gaps but it rejects them , so i thought of extruding the walls and doors only once to create surfaces and use the clipper , however the doors surfaces happen to fall next to the walls , and not precisely on them which lets the clipper fail at calculating the intersection , so i am wondering if there is a way to somehow project the surfaces (for example the doors on the walls) before using the clipper or maybe you have an entirely different idea for handling this problemThank you in advance.​​​

Hi All,What the best way of reading multiple ArcPro GDBs saved within multiple subfolders? I have looked into the Creator + FeatureReader transformers but can’t get it to work, folder structure as follows:  I would like to read the multiple GDBs form the DATA level and force FME to go through the subfolders. 

Hi, I am trying to simplify .stl file that is a fme_surface.I am trying to get from this to this I have tried MeshSimpifier and Triangulator+MeshSimplifier but it failed 

I have used the 'filecopy' writer. The workbench works fine within FME desktop but when I run as a 'data stream' within FME server I get a message saying 'There was an Error'. See attached screenshot. I guess the question is, is it possible to 'data stream' a PDF. And if it is, should I be using a PDF writer?

Hi FME Community,I’ve been testing out an old script with FME Form 2023.0.0.1 and noticed one workspace with NeighbourFinder transformer has come to a halt with no clear message of warning or error. The same workspace works well with older FME Desktop Workbench 2022.1. Data size is around 50K rows, however it’s unclear at what progress/rows the halt would happened.I was suggested to upgrade to newer version, anyone encounter similar experience?Cheers,Noe