FME Form

Hello Forum, I have an externally supplied dataset which includes a street name. Some of the street name entries are all in lower case (e.g.: royal road) where it should be Royal Road. However some entries are fine.This is part of a larger regular data process, so I’d like to build in a process that fixes street names to proper upper/lower case (e.g.: royal road would become Royal Road). Is this possible in FME Form?  Thanks,Stuart 

Hi, I‘m stuck at a simple point. I want to make the AttributeKeeper filter from @Value or a User Parameter which is created by the AttributeCreator. Is it possible? I don't find a solution.The goal is to get more attributes late in a row: test_2,test_4,_test_x in the AttributeKeeper from the AttributeCreator/User Parameter.  

I would like to visualise data on the inspector data or in the graphic view after I reprojected it. That would be in the middle of a workspace before using other transformers and just to locate some features. I know it’s possible to write the data in a shape and check the features on another software like QGIS or ArcGIS but I would prefer to do that in FME directly if that’s possible, when I’m building my workspace. Can I do that?

I want to convert JPEG file (4 band) to COG with below parameter:I have problem with “Interleaving Type”:When i chooses “BIP”, i received a message log:“COG writer: JPEG compression supports at most 3 bands with BIP interleaving. Please change the interleaving to BSQ, choose another compression method, or reduce the number of bands”When i chooses “BSQ”, i received a message log:“COG writer: The file layout 'Cloud Optimized Tiles' may only be used with BIP interleaving. Please change the interleaving to BIP or select a different file layout”I need to convert JPEG file to COG with compression method “JPEG” and keep alpha band.Can i do that? Am I mistaken about something?

Hello, I have these dataArea Category Date A  Medium  202301 A High 202305 B Medium High 202306 B Medium High 202305 B Medium High 202304 B Medium High 202303 B Medium High 202302 B Medium High 202301 C Low 202306 C Low 202305 C Medium 202304 C Low 202303 D High 202306 D Low 202305 D Low 202304 D Low 202303 E High 202306 E High 202305 E High 202304 E Medium High 202303 E Medium High 202302 E Medium High 202301 I want to count the categories that occurred 3 or more times consecutively per area. So something like these Area Category Count Same category consecutively >3 A    0 B Medium High 6 C   0 D Low 3 E High 3 E Medium High 3  I am not sure how to do it in FME. Thank you!

Hi Community, I am facing a similar issues as outlined in the following link : However, I am unable to extract the data from the database. I guess am missing something in the JSON query parameter of the JSON Fragmenter transformer. Attached are the screenshots  Am very new to FME so it’s possible that I might be missing something basic. Any suggestions on how to overcome this would be helpful.

I’m trying to convert DWG’s to SVG’s. It works, but it’s using the AutoCAD colors. I would like to just make the lines all one color, and NOT use the autocad colors. Ideally, I’d like to fill certain layers with another color.

I want to allow selection of multiple records from database in user parameters.For example, I have records a,b,c etc  in a list and I want to select records a and b to be used in FME  workflow. How can I allow user to choose records a and b? 

I need to extract TAB or Shape file from S3 and read data from it including schema.I have discovered in this articlehttps://community.safe.com/data-7/how-to-extract-the-actual-shapefile-from-featurereader-geometry-and-attributes-14548?tid=14548&fid=7that FeatureReader apparently can’t read all attributes that are in the file, until I expose them. But what is I don’t know the list of all attributes? I don’t know what exactly will be uploaded by other people to S3 bucket, I just need to read the file.  Could you help, please, to identify the correct settings of FeatureReader or another way to extract data?

Hello, I have an issue with trying to use the Microsoft Word Writer. As far as I understand, I can build my Word document using multiple MSWordStyler transformers, and depending on the order of these, the document will be built differently. For example, if the “heading” goes in first, it will be at the start of the document, but if it goes in last, it will be last in the document. I have 2 MSWordStyler transformers, one table and one paragraph. I want the table to be first and the paragraph last. I got my desired result, but when I later saved my workspace my paragraph now ends up first and the table last. The order of which FME is reading the transformers has also changed. If I understand correctly FME runs the transformers in the order they appear in the Navigator, and you’re supposed to be able to change the order. I can’t do this though? I don’t get the option to move transformers up or down. I’m also supposed to be able to get the option to “Set connection runtime order” when I ri

Hello, I am using a "Directory and File Pathnames" reader to pull shapefiles from a folder. I then walk them through a tester to filter out the files that I do not need. All good and working up to this point. The goal is to work on those shapefiles and have a processed shapefile as an output, in the end.  After the tester, I send the "passed" ones to a "FileReader" that outputs the desired features under the <Generic> port.  My question is: how can I write those out and keep the geometry + attributes of the shapefiles for future processing?   I can see them in the Inspector but I cannot figure out how to move on to the next step as the only attributes I see imported to any transformer I add, are the ones from the "Directory and File Pathnames" reader, not the shapefiles themselves.Long story-short, I want to use the shapefiles that passed the "Tester" as readers. 

I need to make a mapbook export (png/pdf) for different thematic maps with a large legend. For the boudingbox of the map I would like to insert a dynamic legend (filtered) based on the content in the bounding box.  

Hello AllI am currently modifying a workbench to chop pavement polygons based on the street id and then dissolve them back together, again based on the street id.I have used a neighbour finder to get the nearest street and merged those attribute together with the chopped pavement line.  This all looks good as can be seen below, where each road (from a feature color setter) for visualisation is correct.Output from Neighbour FinderHowever, when i try and put these lines through the line on area overlayer to chop the pavement polygons up, different street id’s are being added to each polygon, hence i can not then disolve them back again.Output from Line on Area OverlayerPArt of the workbench below - not tidied up yet ..sorryWorkbenchParameter setting for line on area overlayer belowLine on Area Overlayer ParametersAny help on what is wrong would be appreciated.Thanks in advance.

Hello,I recently updated from FME 21 to FME 23. In the old version the relative link worked fine. In the newer version it creates now an extra folde.Example:C:/temp would be replaced with the macroIn 21: c:/temp/thefileiwanttocreateIn 23: c:/temp/temp/thefileiwanttocreateHow can I prevent FME from creating this extra folder?Thx

When i use the python caller i get a translation successful, but it gives no output.I'm not very good at python, so do any of you have an idea what i did wrong? 

I am creating a geodatabase where I have buildings and all the corresponding rooms; however, when I import it into arcGIS pro, I am unable to select based on floor level. I checked the written data in fme, and all the rooms and floor levels are in the attribute table, but are merged onto one “layer”. Is there a transformer I could use that can make each floor level seperate from one another in the geodatabase? I tried using attributesplitter, attributefilter, etc. Thank you in advance!

Hello! I currently have a stored procedure in MSSQL that takes in some parameters and inserts into or updates a SQL view. I’m using a SQLExecutor transformer to run that stored procedure, passing in the feature attributes from FME as parameters for the procedure. The code in the transformer looks something like this:EXECUTE [schema_name].[procedure_name]   @id = '@Value(id)'  , @name = '@Value(name)'  , @description = '@Value(description)'And the stored procedure looks like this:ALTER PROCEDURE [schema_name].[procedure_name] @id nvarchar(100), @name nvarchar(250), @description nvarchar(250)ASBEGIN IF ((select count(*) from [schema_name].[view_name] where id=@id) =1) BEGIN UPDATE [schema_name].[view_name] SET name = @name, description = @description WHERE id = @id END ELSE BEGIN INSERT INTO [schema_name].[view_name] VALUES (@id, @name, @description) END Generally this works, but some of my attribute values (eg name and description) are long blocks of text with various s

Can i get the Publish parameter as Parameter input of the transformer?I want to customize this parameter in order to display or hide ports of Customer Transfomer.   

Hi All,I’m working on a workbench to help my team with some geoprocessing. The plan is to upload the workbench to FME Flow therefore my team can run it on demand. I have included a FeatureReader at the start of the workflow to select a GDB containing Polygon data then I was able customise the tool to with a User parameter read the GDB and give the user the option to select the feature layer. That works fine.The challenge now is that I would need to provide the user with the option to select the relevant fields based on the Generic port, How can I set up the User Parameters to allow the user to select the relevant fields to include in the analysis? Here are some screenshots of the feature reader as well as the Parameter Preview:  

Hello,Why attribute types in AttributeManager transformer and in FeatureWriter are different?For instance, integer in AttributeManager has int16,int32, int63, while in FeatureManager int2, int4 and int8?In general, those lists are different. Could you please explain? Thanks! 

Hello,My FME FORM 2023.2 recently has been updated to FME 2024 without my notice. And the new version installed was incomplete, so I can not use FME entirely.I did not see any option for auto updating in the FME software itself, did I miss anything? How to disable the auto updating?My IT team said they did not push out the upgrade. Can any one help please? or direct me to where I might get help?Thanks. 

Hi,I would like to populate the "public.pdl_steg" table in PostgreSQL/PostGis with features from a "pdls" shapefile layer. public.pdl_steg includes triggers in some fields.The id_pdls field is of the serial type.The code_pdls field is unique.   The triggers work well in PostGis et QGIS. Shapefile “pdls” table:However, after several attempts, I was unable to add the features from the "pdls" layer to "public.pdl_steg". The execution does not emit any errors and nothing happens.Any help is welcome.

Hello , i would like to find duplicate of specific column As exampleColumn A contain 256789 - 45674567 - 256789256789 - 4567i would like to find all duplicate values at column A ,consider  the values as duplicated in case  a-b or b-a i mean , 3 above values consider are matched .the target to ignore order of each cell How could I achieve it ?thanks in advance FME 2021  

hello ,i would like to save geometric data into excel file then I read the excel file in arcmap ,It shows me the attribute tables and location of lines .How to achieve it ?fme 2021thanks in advance 

I am attaching a sample db3 file that I am using for a project. This db3 file contains many fields of blob type. The table, field of my interest are as belowTable Name: CURRENT_TAGField Name: _TAGOBJ_SUBSTATIONGIDselect _TAGOBJ_SUBSTATIONGID from CURRENT_TAG where _TAGOBJ_GID = '145242397947723855';This particular record in my application shows this value “151433541765593417”But in db3 file it is actually stored as blob. How do I decode the blob as text? I tried to use online tools to convert this binary to text - it doesn’t work. Also, how do I know the data format that is stored as blob - is it either image, xml, json etc.?