FME Form

I have files in a folder. I want to select the files with a path_modified_date from the year prior. Example, if the path_modified_date contains "prior year" then zip these files. I know how to do the zip files part.  It is the If the path_modified_date contains "prior year" part that I am having trouble with. The files in question accumulate every year and I would like to set up an automation in FME Flow that runs every March and zips the files from the previous year. I know how to set up an automation. Here is what I have done so far in FME Form. The Tester passed if @Value(path_modified_date) Contains 2022; If I use this workbench as is, every year I want to run the workspace I would need to go in and manually change the Right Value in the Tester to the prior year. I want to know if there is a way where I can automate this portion?

The FeatureReader has the option to read "Schema and Data Features", "Data Featues" and "Schema Features". In an attempt to optimize a process which converts a bunch of AutoDesk dwg's I tried to first read only the schema (the layers), determine which of the layers need to be read and feed that list in a second FeatureReader as Feature Types to Read. I found out I was getting slower performance, due to the FeatureReader being really slow to read the Schema Features.Reading SchemaFeatures from the dwg took 120 seconds.Reading Data Features from the dwg took 2 seconds.Reading from an empty file did not result in a different performance. Why is this so slow? Does it have anything to do with the parameters?I think the FeatureReaders FME Defaults should be "Data Features" as a lot of users would benefit from the increased performance.

Hi,  I would like to create a table showing all the attributes available per feature type and the count for each one.  For example, I have these datasets: Trails, Activities, Landscape which contain similar attributes, but also different attributes. (similar = objectid, name...) (different= trail size, type activity).  I want to generate an overview with all the attributes and to which feature type they belong to.  Any idea how I can do that without using too many transformers?  I have already tried many options:1) attribute exploder, unique values (but then I can trace back to whcih feature type it belongs to)2) attribute manager, change values to feature type, then statistic calculator (but then I have to use one attribute mananger per feature type which is redundent).  Any ideas how I can make this script dynamic? Thanks

Dear people, When using the Spatial Relator I get a list of "Spatial Predicates to Test" to choose from. This list is rather limited, it seems to me.  However, the documentation for this transformer describes a "Dimensionally Extended 9 Intersection Matrix (DE-9IM)" at the bottom. This offers more options. But, as far as I can see, the string representation of a DE-9IM is only output as a list attribute with the result. I haven't tried that yet, but I assume that the DE-9IM that comes out corresponds with what is chosen from the list for "Spatial Predicates to Test". Or does it give the exact spatial relationship according tot DE-9IM? Anyway, I would like to compose a string representation of a DE-9IM to use as a spatial test parameter in the Spatial Relator. Is that possible? Kind regards,Ferdinand.

Mongodb supports EPSG 4326 by default you can specify a custom crs : https://www.mongodb.com/docs/manual/reference/operator/query/geometry/ My workflow is simple : geopackage to mongodb.  I tried : Specify source and destination projection : no effect (data are in 4326 in mongo)Extract geometry (projected in 2154) and store in attribute geometry2 but there is no json type (or even geometry type). Extract geometry and write it in a geometry attribute : fme returns an error.  

Starting out with feature reader, and I am definitely missing something. The input dataset has about 1,600 records. Why is the output at 366,458 (and counting) about 10% of the way through? Thank you,

I would like to convert ecw files into other raster formats, and since I do not know what output format other users prefer, I would like to provide a public user parameter with a list of available raster formats in FME, and use the parameter to specify the format used in the FeatureWriter. Looking at the FeatureWriter I cannot see the possibility of dynamic, or even a selection of output formats. It also seems rather cumbersome to get a list of all raster formats FME is able to write. Is there a possibility to tweak the FeatureWriter to take the format from a user parameter list?

Some jobs are queued before it is allocated an engine for processing due to shortage of available engines or based on priority of job queues. I would like to know how many jobs stayed in queue for more than 30 second before it was processed? This will help us to allocated additional engines... Is there a way to do this analytics in FME server? Thanks

Hello ,i would like to connect FME professional with Azure AD to write the output from Fme to azure .i would like to ask , after creating web connection in Fme professional. How could I publish the web connection in FME server ? to read the data from azure ad ,which transformer should I use storage blob connectors or https caller my second question : how let the workspace to write the output directly the file into Azure AD ?could someone explain idea or provide screenshot of workspace ? FME 2021 thanks in advance

I'm using a HTTP caller to download a ZIP file from a API. After that I'm using the ZipExtractor transformer to extract a number of csv files from the ZIP file to a folder and then a FeatureReader reads the files and so on. Only problem I'm having is that the CSV files change from time to time. They all start with the time of the export followed by the filename. So every time that happends I have to go back to the FeatureReader, select the files again and reconnect the files to their appropriatie transformers.  Is there a way to rename the files after the ZipExtractor ? I have found some topics using the Directory and File Pathnames Reader with the File Copy writer but I cannot get that to work. Any help would be greatly appreciated.

What is the best way to write and read to/from sharepoint subfolders without downloading or uploading first the files or folder using Sharepoint online connector?

I'm trying to write texts to Microstation and having trouble getting certain characters across, specifically ü and ç but there may be others. They are present in the source data and inside FME right up to the point where they enter the writer. I'm pretty sure it's an encoding issue, but can't seem to set UTF-8 on the Microstation writer. Any ideas on what I can do to get those characters into DGN?

Hello , How to split the content of one column to two columns ?my output of aggregator looks like string12-string56 at same cell in one column and all rows similar . i would like to have two attributes one called base include string12 and other attribute called next include string56 and implement the method for all rows  Which transformer should i use ?how to use it ?fme 2021 thanks in advance  

Hello ,i have used topology builder Parameter :end node and intersection , tolerance automatic .I need it to to let the lines properly noded .but my problem that it create intersection point for cross lines ,as even „X“ or „T“ .how could I use topology builder end node and intersection and avoid effect on cross lines ?my target : to let the line properly noded then count the no. of overlaps point on line . I have used topology builder end node only ,it does not create intersection point but my network need to clean so I have to clean the data first .what should I do ?FME 2021 thanks in advance .

Hello. I have been tasked with pulling a large amount of XML from BLOB fields in a table to find relationships between the data. The problem I'm having is every approach I've tried has stalled FME Because of the large number of attributes I'm pulling out of the XML after XMLFlattener and AttributeExposer. I have attached one blob field, and each of them are basically the same, just larger or smaller. The results I'm picturing in my head are grouped by the Equipment GUID and Cable GUID. 

Reading/writing files(e.g .xlsx) from /into local drive not working in FME Flow 2023.0 (b23332) but FME Form does read/write the same files from local drive.

I have a point feature class in a geodatabase. It doesn't contain metadata yet. I want to write one for it. I think I need to use XML Templater. But I can't read directly from GDB by adding a Esri GDB reader. what should my source be?  

The files are ziped .shp files broken up by state. I need to merge them into one nation wide dataset and safe to a geodatabase. A general workflow would be very helful. Or a list of Readers, Transformers and Writers and things to pay attention to.

I have an excel file that does not have any merged cells. Any cell that is left blank is supposed to take the value from the previous row. How do you do that in FME without looping through a list? This is what I haveAnd, this is what I want (with grey-color being the items I want to automate with FME): 

I have data going through feature writer that creates my csv, that then is uploaded to azure file storage using its connector in fme, once I successfully upload the csv, I want to delete that file from FME_DATASOURCE where I wrote it in the earlier step. How can I do that ?

I am trying to access each row of the excel data I read with pythoncaller. How can I do that         coulumnData = feature.getAttribute('Column1')        data = str(coulumnData).split()        for row in data:            print(row)and how do I read FLOAT values as well? I do not understand what kind of object is returned by feature.getAttribute. If I print coulumnData, it is printed nicely row by row. But, how do I access those row of data? I want to do something like         coulumnData = feature.getAttribute('Column1')        data = str(coulumnData).split()        print(data[10]) 

I'm able to setup and use "OpenAICompletionsConnector" succesfully with text-davinci-003, but since the completions API models will be deprecated at the begging of the year 2024 I wanted to try Chat completions with gpt-3.5-turbo as described here.I understood that is hould use another transformer called "OpenAIChatGPTConnector". I use role "user " and as "content" I use the same prompt as for Completion to resolve not well-structured addresses. With this setup the Connector somehow aggregates all the features from input port an

When I read data from a PostgreSQL/PostGIS database and I inspect the features using the Inspector, all attributes seems to be of data type "string: (UTF-8)" when looking at the "Feature information" panel. But when I look at the "Table view" panel, the id column (defined as serial4 in the database) is formatted as a number (the value is aligned to the right). Boolean values are read as either "t" or "f" (still "string: (UTF-8)") while when reading boolean values from a GeoPackage they appear as "Yes" or "No" (and the data type says boolean). If I look at the debug logging I see that a boolean postgres attribute has an entry like:Attribute(string: UTF-8): `my-field' has value `bool,BTREE' While a GeoPackage attribute has an entry like:Attribute(string: UTF-8): `my-field' has value `boolean' Is this really the expected o

Hi.. I have an FMW workflow that reads a shapefile with H3 polygons. Each polygon has a HEX color attribute (eg #000000). I need to do 2 operations: Style the shapefile filling each polygon with color using the HEX attributeRender and write the layer as a raster image (Geotiff or JPG) Can this be done, and how? Thanks, tC/.