FME Form

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.?

From the FME Documentation about the INSPIRE GML Reader/Writer I read that "FME supports themes up to and including v4.0.". I tried to validate my FME INSPIRE GML output (for theme PS) with the INPIRE Reference Validator, but the test fails. On the support platform it is noted that the test that fails, "Validation against INSPIRE official schema", tests against the new version 5 of the schema. They recommend generating the GML according to the new version 5 of the GML. Can FME already do that, or do I have to wait for a new version of the INSPIRE GML writer?

Hi,I am trying to use FME 2023 version to convert OBJ into Cesium 3DTiles.While the conversion is successful, I notice that it causes our application to becomes sluggish, and it also consumes alot more resources. The application I am using is Luciad (https://dev.luciad.com/) and the software vendor has given the following feedback after investigating the Cesium 3D Tiles data:1. The number of .b3dm tiles generated are too few, resulting in each .b3dm being to "heavy" for loading & rendering.2. No sufficient number of "level of details" To demostrate that, I created a small sample and uploaded to https://drive.google.com/file/d/1FYMHx977zB_NAJa74nqMfmLvlMqWKPog/view?usp=sharing.1. Large .b3dm files    a. The .obj that I convert to Cesium 3D Tiles has 330K triangles.    b. Only 2 .b3dm files were created. But it should have at least 33 .b3dm files (330K/10000) since I am using 10000 for Maximum Number of Triangle Faces Per Tile (see 3dtiles_setting.png)    c. It seems like the FME 3DT

Hello,Could you advice, please, what transformers to use for my task? This might be easy task, but I am stuck. :( What I have: generic reader with the dataset in any of these formats SHP, TAB, KML or CSV.I need to define: if there is no geometry, WKT or SRID then set corresponding attributes to NULL If there is binary geometry then put the geometry to the attribute YY If there is WKT then add WKT value to the attribute UU if there is also a SRID in the file put that in ...How to check if my data has "no geometry", binary geometry, WKT and SRID and set conditions?Appreciate your help. Thank you in advance. 

Hello, I am trying to create a workbench that will read in all our add/delete tables from our SDE, do a count on the running total of records for each, and export a spreadsheet with the table name, and the counts in each,I’m using a SQL Creator and my SQL statement is something like SELECT COUNT(*) FROM <tablename>,and right now that's not returning me any value even though it was successful? Also, how would I go about coding out to add the next table in?would it be:SELECT COUNT(*) FROM <tablename>unionSELECT COUNT(*) FROM <tablename2>unionand so forth?also for background:We use Microsoft SQL Studio, and I chose the connection as a spatial server.Thanks for any help!

Hello, the problem is the following. I have a duplicateFilter attached to 2 different featuresTypes, which have an attribute in common. I would like, however, that when there are duplicates, the features of a certain type remain in the unique port. In other words: when there are duplicates, I always want the pair of the copy that goes to unique to be of a certain feature type, always the same, and to be able to control it. Any ideas? Thanks, Pol

Hello,I’ve researched this a bit now, and most folks point to the Generalizer, maybe Thin No Point.  However, I’m not concerned about distance away from other vertices (parameters of Thin No Point), rather I’m only concerned with removing vertices that fall in a straight line under the original line.  In other words, remove vertices that don’t change the shape.  These vertices could be 1 foot away from an adjacent vertex or 1000’ feet, doesn’t matter. I’m more or less looking for a algorithm that checks whether each vertex is on-line between it’s neighbor to the left and neighbor to the right.  If it is on-line, then remove, if not, keep.  I realize that there would need to be some tolerance parameter (angle or distance offline) due to rounding, but can accept that fact. Any ideas what transformer or Generalizer parameters to choose to best achieve this?Thank you,Tyler

I need some help with this problem below. As seen below the lines have diffrent attribute ID’s 1,2 and 3. The lines 1 and 3 are moving correctely as a offet 10 meter from their first location, as seen in the picture to the left. But line number 2 are not moving as an offset, as it is an exit ramp with different attributes than line 1 and 3. I want line number 2 to move with line 1 and 3, so they are connected in the same way as the right picture, meaning same direction and shape. I already have a dataset as the right version and my first thought is to create a point layer with start- and endpoints of each line and make them always connected as line 1 and 3 are moving. How should I solve this problem as easy as possible. I have a large roadmap of these lines and problems, so this is just an example.  

I created a few polygons  with topologybuilder and now i need to explode them in order to test some line on line with another feature.ive tried chopper which works greate except the fact that converts the arc in polygons to line and ruins everything. so how do i split these close polygons back to lines and arcs?ivre tried GeometryPartExtractor to filder out arc but the results are arcs and rest of the polygon insted of being a polyline without that part it convert it in cloed polygon 

I received a service bus connection string in the following format:Endpoint=sb://sb-sb-s-sbb-mastersupa.servicebus.windows.net/;SharedAccessKeyName=Andblablablab;SharedAccessKey=blablablablablablalbablablablabla+blablabla=;EntityPath=moreblablablablablatestBut it gives me an error in FME 2019,2020,2021Is says: Error: claim is empty or token is invalid.Should I enter the string in another format? Also: In 2022 and 2023 I get an error: No module named ‘uamqp’. Looks like this module is not available in this Python library set?

Hello,I want to generate an incrementation from the max value of a column in order to not have duplicate values. The _max value column is not recovered in the counter for the 50 duplicate features :  Any idea ? Thank you 

I have encountered a strange issue with FME web connections via OAuth2 which does not seem to be resolved yet.On one of our company’s networks physical Windows 10 PC, there are three versions of FME Desktop / FME Flow installed in parallel (we need these to cater to our different customer’s needs). When I routinely tried to check and update an FME workspace, I ran into the problem that authentication with an OAuth 2 Web connection (via Microsoft 365 account) did not work anymore. At first, the web connection window took more than 40 (!) seconds to appear with the logos sometimes not even fully appearing. When I entered my credentials, it takes another 20 seconds and then gives me an error not to have found it. The credentials are tested and correct. There are no proxy connections.Resetting FME Options has not worked, and neither has setting up the web connection completely from anew.Tests on a different machine within the same network (but on my Windows user) could not replicate the pr

Attached are simple FME-Workspaces from version 2017 and FME-Form with GeometryPropertySetters and Aggregators and the xml outputs. The 2 workspaces are exactly the same.FME 2017 writes the aixm Marking Element Geometry as expected, but FME-Form does not - the MarkingElement Geometry Feature is missing (Workaround is to use XML-Templater).Any idea, is this a bug?

Hi All,I’m getting the following error in the FeatureWriter transformer:A field type of 'number(20,version;1;cell_border_formatting;NO;text_alignment;NO;cell_protection;NO)' was specified, which is not valid. Please check the documentation on the Reader/Writer for information on valid field types...the normal GDB writer works perfectly fine with the same data...I had a look into the field types but couldn’t find the error,Any ideas?

I wish to extract a sample from a table where each attribute from some field should be represented x times. For example see below where x is 1, and the fields I want to sample from are House, Priority and Injury. Input:ID      Name    House       Priority    Injury 1        Draco   Slytherin    Medium  Head  2        Harry    Gryffindor  Low        Hand3        Ron      Gryffindor  Low        Head4        Cedric  Hufflepuff  High       Chest Output:ID      Name    House       Priority    Injury 1        Draco   Slytherin    Medium  Head  2        Harry    Gryffindor  Low        Hand4        Cedric  Hufflepuff  High       Chest

I want to style vector by “Mapbosxtyler” and write to .mvt (Mapbox vector tile).I try to make style for line, point no problem. But with the polygon file, Mapboxstyler , I use checked fill style and stroke style to make it, But they can’t. Could you tell me why? Thank you