General

Hello there,​I would like to check a dataset attributes. So I would like to write a workspace that can check the incoming dataset. ​For example, I expect to receive a dataset that has attribute name. My expectation dataset attribute name: A, B & CThe incoming dataset attribute name: B, C & D. In this case, I would like to call out attribute A and D. As attribute A is what I expected but missing and D is not the attribute name that I want. May I ask what transformer I should use in this case? Thank you very much. Zachary

Hi, im using neighbor finder in identifying duplicates based on XY. However, my data is stating that +/- of the value is considered as 'duplicate'. For example, stores selling 5 cars is the same with 6 or 9, but will be different if 10. So in this, I have 3 stores considered as duplicate based on their location. So I want to know the nearby data known as duplicate based on these parameters. Hope I make it clear. Is this possible in FME? Thanks in advance!

I have been trying to move Point data into the adjacent parcel which is connected to its line via ESRI's Geometric network is not working out. can someone help me get through this?

Hello Experts,I have 3 files A: Point FileB : Line file (Street)C : Line file (Street2)I have extracted Street names from the A point file and transferred them to the closest street B. But unfortunately, the street names have been populated to streets within provided distance. This has caused superfluous names to the streets. I need to populate the street name to the streets where the names are missing, but it also should not be available in the polyline file C. Basically i want to identify the superfluous names.Any help would be highly appreciated

Hello,I have a shapefile representing a neighborhood of a city. It contains 455 shapes with one shape per building. Each shape contains multipolygons corresponding to the building walls or little facade elements. Some buildings have common walls but their 3D points are not equal (typically 10 cm distance between them).I would like to group the neighboring buildings and extract their hulls. In other terms, I would like to only keep the multipolygons that constitute the contours of the building blocks.I am a beginner with FME and I have tried many transformes (geometry extractor, bufferer, dissolver, deaggregator, aggregator, hullreplacer) but I could not get what I want.If you have any advice, that would be great!Thank you!

hello i would like to RUN my workbench with a batch file, so i copied the first line of the log but when i try it, it just launch FME with the workbench but he doesn't run it. how could i do that ? thanks charles.

Hello,  I'm currently testing all the workspace I have after upgrading from 2020.2 to 2021.1.3. There is an issue I can't fix. I have a workspace that export data from postgresql base to an excel file. The file can be modified so I have a dynamic feature reader to get the model and a dynamic writer to write the data.In 2020.2 it works (I still have the version on my laptop, until all projects have the same version). With the same data and the same workspace, but using 2021.1.3 version of FME, my file is writen empty ....FME isn't failing but I have 95 warnings :  Feature Caching is ONThe workspace may run slower because features are being recorded on all output ports.Logs_systeme_StatisticsCalculator (StatisticsCalculatorFactory): Attribute 'resultat' has no statistics requested. If statistics are expected for this attribute please ensure that they are selected in the Statistics to Calculate tableExcel Reader: Found named range '_xlnm__FilterDatabase' on she

This is definitely a "New to FME" question. I'm using FME Desktop, FME(R) 2021.2.3.0 (20220131 - Build 21812 - WIN64). When I select "Check for Updates..." an alert says that I new version of 2021 is available with a link. When I go to that web page, I see that 2022.0 is available. Is there is any reason I would not want to upgrade to 2022.0? When I upgrade to 2022.0, will some of my workspaces and transformers need to change? Thanks.

I have a series of user parameters that will display when I use preview but when I run the workspace the last one won't display. I can't see any options where a parameter wouldn't be visible when running the workspace. Is there a limit to the number of user parameters that can be set?

Hello, FME'ers,Welcome to What's Up Wednesday, your weekly look at FME news. Today is May 4th, so it's Star Wars Day - and don't forget you earn a special badge for posting on the community today - or Cinco de Cuatro if you're a fan of Arrested Development (who isn't?) Either way, we're celebrating the release of FME 2022, which became available for download yesterday. FME 2022So FME 2022 is now officially released:  As always, you can find it on our website's downloads page, along with the full list of updates and changes in the ChangeLog file.  I'm sure there are lots of obvious changes, and you know about many of them already. But something I only noticed for the first time today is that the AttributeFilter now allows imports from Feature Caches:   It was something that helped me a great deal, and I hope you find it useful too. Something else new that I'm quite fond of...  The new Start Page with workspace preview image and the ability to &quo

I am updating a table in a database where I must insert, update or change value of one attribute of a record when it is deleted from source (ex: field ISDELETED is changed from N to Y when record is deleted). So in ChangeDetector I am connecting the destination table to "original" port, and new incoming data to revised port.The issue is that the attributes coming to "revised" don't have the same name like the ones from destination table, and I am using in my script a SchemaMapper tomap Source Fields to Destination fields (as the names can change and customer has access to the table used in SchemaMapper only).So because the attributes have different names, I don't think that the ChangeDetector will do it's job correctly. I attached a dummy script and dummy data to this issue.Can you give me some help here? Thanks.

I want to calculate the volume of ditches. It is do-able to determine the shore heights of these ditches, but it is not very precise. A better way would be to do a fill sink analysis. As far as I know FME has no way of doing this?

Is it possible to draw a 'centerline' for a polygon but on e.g. one third from the outer edge instead of half ways?

hi i have some features contain arabican numbers (۰۱۲۳۴۵۶۷۸۹), how to convert any arabic digit to english (0123456789)? for example all of ۱ converts to 1, or all of ۲ converts to 2 and so on thanks guys

Hello, I created a batch file and need to run it through a task schedular. The file gdb needs to change in this batch file on every run. I am not sure if is there a way to loop through a folder and select the current gdb from the folder.  "C:\\Program Files\\FME\\fme.exe" "D:\\Workspace_features\\Country_NEW_APM updates_FeaturesOnly.fmw" TRANSACTION_TYPE_GEODATABASE_SDE "VERSIONING" VERSION_GEODATABASE_SDE "DBO.SarahS_APM_edits_Country_006" geodb "G:\\APM_DOWNLOADS\\Country\\Country_Bulk_2022-05-01_22-43-59\\Country_Bulk_2022-05-01_22-43-59.gdb"PAUSE Any advice and suggestion would be greatly appreciated! Thanks, Sarah

Hallo FME Community, I am trying to convert ArcSDE to DWG file. A DWG template is available for this, which must be applied to the points (See picture 1).   in my file there is a column named autocad_block_name. this column defines which symbol in DWG template has to be applied to which point. one layer can contain two symbols. (See Picture 2)   Other column is autocad_layer sets the name of the layer in writer.   the DGW Template contains 250 layers and each layer contains a symbol. from these 250 symbols we only need 40 symbols. what problem is that my result contains all layers of DWG_Template and autocad_layer column. I want my result to only get the layers that are in my autocad_layer. 

I have a series of fillable PDFs that are used by stakeholders to apply for a permit. Another form in the series is used by stakeholders to report back on the activities of that licence. Can FME transfer the information in these forms into a used database

Hi everyone, I'm currently trying to decrease the size of different file consisting of line and polygon geojson. After reducing the number of attribute and the name to a minimum, I'm looking to reduce the coordinate lenght of the those file.  I used the generalizer to decrease the number of coordinate being ouput by the line and polygon features. The other thing that would really help is to reduce the number precision or lenght of the number. I've tried to use the coordinaterounder transformer, but it those not remove the number itself.  From what I've read, only a python caller could round element in a list. If I choose this way, would I have to use a jsontemplater to format my geojson.  First, would it be possible to round the coordinate output directly in the geojson writer? Second, what would be the script to add in python caller. I'm very new to python.   

I receive datasets from users where some rows may have empty values for compulsory attributes.The AttributeValidator is testing for empty attributes. If I find any empty rows I want to reject all features. Any ideas? Somehow using a FeatureHolder?

Short version here for time: FME2021.2 64-bitArcSDE Geodb writer, truncating the SQL Server table in 10.x geodatabaseVersioned Edit Session to feature class that is registered as versionedFME log claims success and that all writes were saved. No errors, warnings or anything indicating an issue in the log at all.ArcCatalog and Pro report a blank tableSSMS business table has old data, deletes table has all features, add table is blank, inserts table has one featureConnection used to write has db_datawriter and db_ddladmin permissions to the database in question Any ideas on why this didn't quite work are appreciated. If it's as simple as non-FME solutions like post/reconcile or compressing to get things moving that's ok. I'm not an advanced SDE user in terms of versioning, a little better on archiving though. A workaround is in place and there's time to learn about this, and I have contacted my vendor but thought I'd try here as well. We could probably get aw

Hello guys we have a GDB with multiple layers, we need to generate sample data for each layer but with different rates for each layer, the problem I have is the sampler transformer will take only user parameter value not an attribute value how could we set the rate based on the attribute value ??Thanks

I'm currently using reading geotiffs(mosaics) generated from pix4d. And writing them backout again by removing the black band that is generated around them.  When I started publishing these out to arcgis image server I started to notice the projection was not aligning with points of the projected that have been collected. But the original generated by pix4d didn't have this alignment problem. All our mosaics created since 2021 are projected out in EPSG:6549 and when the geotiff is read through the feature reader it looks it's being detected as the following: Coordinate System Parameters CS_NAME: NSRS11.OH-NFDESC_NM: NSRS 2011 Ohio State Planes, North Zone, US FootDT_NAME: NSRS11EPSG_QD: 1GROUP: SPNSRS11FMAP_SCL: 1MAX_LAT: 42.55MAX_LNG: -79.98333333333333MIN_LAT: 39.88333333333333MIN_LNG: -85.31666666666666ORG_LAT: 39.666666666666664ORG_LNG: -82.5PARM1: 41.7PARM2: 40.43333333333333PROJ: LMQUAD: 1SCL_RED: 1SOURCE: CRS HARN/OH.OH-NF with datum modified to NSRS11UNIT: FOOTX_OFF: 1968500ZER

Hi,I am trying to make a flow where among other tasks I have to move some areas from one table to another and remove duplicates ID's for areas, but keep in 2 attributes a list of blocks (names and ID's) - like in pic attached.I thought I had a solution by using a Dissolver and put those values of ID's in a list, then using a ListConcatenator I could put them in desired new attributes. First issue I discovered is that the Dissolver didn't removed the duplicates (or not all of them) and BLOCKID and BLOCKNAME doesn't contain all values. Can you give me an idea on how to fix this issue? Thanks.Nicu 

Hi, Currently having 'fun' with the OnlineSharePointConnector transformer, this was correctly functioning on FME desktop and FME Server (both version 2021.1 ) for a me a week ago. Now the transformer none of the SharePoint sites I have access to appear and I'm getting the following error messages when attempting to connect to a site. Any assistance greatly appreciated.