FME Form

Hi community, I've many postgres table in source, with differents structures. I would like to send them in Big Query, with, for each table, the same structure, so I thank to regroup source and regroup target to do that. But, I would like, transform the date format for each postgres field. In fact I know to do that with DateTimeConverter but I've to declare all field one by one. It is possible to do that with "all date fields" ? Thank you for your help.

HiI drew a simple shape with google my map and export it to kml in my browser then i convert it to dwg/dxf with FME quick translator to modify the shape with Autocad, but the original map stretches out and shows a wrong map, it also happens when i convert dwg/dxf files to kml or gpx.how can i fix it?

HI, I get error above when i write to Feature Class in SDE. i have no issue if I write into GDB.( i also attached the log file here).would you let me know what the issue is and how to solve it. Appreciated for your help.

Hi. I'm trying to decode a .zip file sent over mqtt connector. I recieve the message payload attribute with the zipped string and want to decode that string to plain text. I'ts not the mqtt message that is the problem but how to decode this zipped attribute into plain text on the fly inside a workspace?Thanks, Stefan

How do I automatically delete both the parenthesis and the content in them from my reader file? Is String Replacer the transformer to use? If so, can you help me with the code needed to find and replace any () and the numbers inside them with a blank. in other words, I want to delete them. This will probably be easy to a lot of you so I really appreciate your help.

I have a workspace set up to write into an Excel spreadsheet in Sharepoint. I am able to control the cell width in the writer parameters to a designated number.  I also want to set the cell height to auto fit because I have the text set to wrap, but some entries have a lot more text than others. When there's longer text entries some of the text gets hidden until you double click the cell. Is this possible in the FME Excel Writer? If I were to manually do it in Excel this is the step I would take.

View Data > Exercise: Customize Your Viewhttps://safe.my.trailhead.com/content/safe/modules/view-data/exercise-customize-your-viewUsed the geojson as input instead, worked out fine. 

I am very new to FME and have recently learned the basics of the software. I'm starting to apply some of this knowledge to building workflows and was curious the best way to go about reading in 200+ shapefiles to write to single feature class in a file geodatabase. They all have identical schemas so my thought was to read them in by adding the folder they're stored in, using *.shp as the dataset indicator, and using the Single Merged Feature Type option for the Workflow options. Is this the best way to do this?

I have this table of data (as an example)I will be receiving data for each object, and I want to cross check that every attribute (column) that has Yes is provided in the dataset. Please could someone advise me how to go about doing this and which transformers I should be focussing on?I was trying to maybe create a list for each object (but failing at the moment) so am a little stuck. Thank you in advance!

So when I place a reader und just look at the untransformed model it already has the wrong geometry. Changing the settings for stroking doesnt help. It seems like FME just doesnt like curved volumes, but that seems like a big lack in capability, which seems unlikely, because I havent found anything about this topic here. Is there a way my file can be read correctly or at least closer to the truth? The way it is now, I cant really use it. Here is an example:The color and height difference are intentional. What isnt, is that the lower object lost a few vertices compared to the higher one.

Hi everybody, I created a Workspace. This Workspace should be started by an external http-request. If the workspace ended, i wanted to send back a response. I published the Workspace with fmedatastreaming + included the writer to the stream.The response was send as a file. I wanted to send the response as content in response. Any Ideas?   

I am creating a workspace converting from shapefile to cesium 3Dtiles. The workspace is completed, but it can not set the color by values of specific attribute. I am trying to use "AppearanceSetter" or "FeatureColorSetter" but it won't allow to set various values of one attribute by colors like value 0-1:Green, value 1-2:yellow, value 2-3:Red. I'm new to FME, so if you don't mind, please kindly help me out how to set up. Thank you.

How do you multiply each row of Attribute A with Attribute of B? Similar to excel operation? I need to convert imperial units to metric.  I can multiply the attribute with a User_Parameter and I can also multiply two attibutes together and I can also use the Expression Evaluator. But, for each operation I get about 200 lines of WARNING. What is going on? What is the correct way to multiply two attributes or an attribute with a user_parameter?

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?