- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27668 Posts

mariasContributor

How to replace FeatureReader?

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?

280

8 months ago

jonnasemailContributor

asked in Transformers

Microsoft Word Writer and changing run order of transformers?

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

472

8 months ago

robertrContributor

asked in Data

How to extract the actual shapefile from FeatureReader (geometry and attributes)

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.

1855

8 months ago

jaccowandersParticipant

asked in General

Dynamic Legend for map

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.

151

8 months ago

ingallaContributor

asked in Authoring

Merging Attributes with Line on Area Transformer

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.

larottiContributor

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

972

8 months ago

bertboonemanParticipant

asked in Transformers

Python caller gives no output

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?

2006

8 months ago

mariamrgn2

asked in Transformers

Splitting Data

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!

532

8 months ago

allisonlehnContributor

asked in Transformers

Forward slash breaks SQL insert with SQLExecutor in stored procedure

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

4732

8 months ago

jesselangdonContributor

asked in Data

Splitting bulk features into individual features when performing simple copy of annotation between File GDBs

I am trying to do a very basic read/write of an annotation feature class from one file geodatabase to another. In my case, I’m first running a PythonCaller transformer to remove any and all annotation feature classes in the target file geodatabase, then I use a FeatureReader to read the annotation feature class from the source file GDB, and then run a FeatureWriter to write the annotation FC to the target geodatabase with “Insert” and “Create if Needed” options selected for the table, which I assume is creating a new annotation feature class in the target FGDB.Regardless of minor tweaks I make to both the FeatureReader and FeatureWriter transformers, FME Flow keeps writing these as individual features instead of bulk features. There are ~450k annotation features in the feature class, so running this by writing individual features takes over an hour, which will not work for our scenario.Interestingly, the first time I ran this in an earlier workspace, FME Flow used the bulk feature sett

1583

8 months ago

davidleeSupporter

asked in Transformers

Can i customize the Publish parameter in Transformer input in Trasnformer Customer?

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.

1154

8 months ago

galigisEnthusiast

asked in Transformers

FeatureReader Expose Attributes - User Parameters

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:

652

8 months ago

mariasContributor

asked in Authoring

Why attribute types lists are different in 2 transformers?

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!

483

8 months ago

chelseawuContributor

asked in Integration

FME auto upgraded to version 2024 without my notice

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.

492

8 months ago

gennineContributor

asked in Integration

Problem to insert features into PostGis table

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.

654

8 months ago

solyContributor

asked in Data

how to find duplicate of specific column ?

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

983

8 months ago

solyContributor

asked in Data

how to show the graphic from excel file ?

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

658

8 months ago

manojse07Contributor

asked in Data

Help with reading blob from db3 file using FME

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

1394

8 months ago

helmoetzContributor

asked in Authoring

INSPIRE Theme Version Support

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?

1024

8 months ago

kiabeeContributor

asked in Transformers

Cesium 3DTiles generated has performance Issue

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

2635

8 months ago

mariasContributor

asked in Authoring

Which transformers to use to work with different geometry?

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.

650

8 months ago

schulte.aContributor

asked in Data

How to query all add/delete tables in SDE and have a count of each as a row in the output

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!

4310

8 months ago

pcarrerabalsellContributor

asked in Transformers

DuplicateFilter: Hot to choose which of the pair goes to unique depending on the featuretype?

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

425

8 months ago

townestContributor

asked in Transformers

Remove all line vertices that don't change line shape

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

752

8 months ago

alexandererlandContributor

asked in Transformers

Moving lines and keeping the line's geometry

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.

16012

8 months ago

1
...
58
59
60
61
62
63
64
...
1107

Page 61 / 1107

Badge winners

jacklonsdalehas earned the badge FME Certified Professional
kokilamhas earned the badge Integrate Spatial Data
ryanwillshearhas earned the badge FME Form Basic Training
barkushas earned the badge Welcome Back
anteboy65has earned the badge Welcome Back

Show all badges

30,366: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.