FME Form

Hi Team, I have a large map which has a route on it, I have buffered the section to widen the path and would like to know how to snip the map section out. Also how to adjust wider or smaller on the buffered route.

Which i then replace with regexp.How can i have it just yield following result? "amount" : 10000 I'd like to have it solved inthe Templater rather then resorting to regexp clean-up.  Tx in advance to all.

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.

Hello and welcome to What's Up WednesdayWe didn't get a post last week (sorry) so you can imagine that this one has a lot of items to mention! A Community Guide to FME Best PracticesLast week I tweeted a screenshot of a workspace I was working on and talked about how it was time to do some best practice on it:  Of course, Best Practice is more than just the style of a workspace; it's also about how you go about creating a workspace and testing/debugging what you have. Anyway, I suggested perhaps we should create an e-book or similar entitled "A Community Guide to FME Best Practices" and it seemed to be a popular idea with everyone. So I'm now determined to make this a reality and will reach out soon to those folks on Twitter and anyone else who would like to contribute.  I'm really excited to get this going and think it will be a great community project. FME 2022 NewsWe've all been waiting anxiously for news of when FME 2022 will be released, and now w

I am setting up a WB dynamically to migrate data from one DB to another. Each feature types has a several hundred thousands of objects. Whilst developing the WB i dont want to read the entire content of the source tables and has therefore set the reader option "Features to Read" -> "MaxFeatures to Read Per Feature Type: 10. In that way I can Create the destination tables before I run the entire process which will take a while.But even if I have set it to read 10/feature type it only read the 10 first features of the first table. I was expecting it to read 10 features from each of my 30 tables?I can also see that it is readying the entire feature class but only processing the first 10. I am confused of this feature?

I'm doing a change detection on a date field from 2 sources. One source always includes time even if they are "000000". The other source appears to be strip those 0's. How can I add the hours minutes seconds to the records that are missing them? Do I need to filter for the records missing time values before adding the 0's. I will attach an image with the "J_NotifyDate" column missing time if they are 0's

Hello, please, I have met issue that I read DWG Layout in FME. But unfortunately FME is not able to load raster which should be in Layout. I use parameters "Read Paper space" as You can see in attachment. Is it bug? Or is there any workaround, how to read raster in DWG Layout? Its very uncomfortable, because I need to transform DWG Layourt to PDF. Thanks a lot!Lubo

Hi, I thought this would be easy but it's starting to look like it's not even possible. For each feature, I want to copy the contents of a list attribute from the previous adjacent feature (-1). It is possible to create a new attribute and copy an adjacent attribute this way, but since you cannot just create a "list" attribute in the AttributeManager, this doesn't seem possible. Is there a way to achieve this? I have also looked at the ListCopier, but it cannot access adjacent features since that functionality is only available in the AttributeManager. Is it possible to access adjacent features via Python? If that were possible, maybe Python could provide a solution to this problem. Thanks.

I am getting some records from replicate view in smallworld and fme unable to read these value bcoz fme is working on the current view in smallworld.IS there any possibility to change the current view to replicate view of smallworld in fme

Hello,When I put a gdb file in my process with the reader, its works, the file is read. But when I put another gdb file with the same reader (thanks to a parameter) it isn't read if this file hasn't the same name field. Why ? Thanks you

Hello,I am using Dissolver to remove common boundaries and create larger areas based by an attribute.Next step was to calculate the areas of areas from which I created the large ones - DONE (Accumulation -> Attributes to sum).Now I would like to create a list of some attributes from small areas and put them in another attribute separated by comma ( ex: name, id of old small area).Can we do this in Dissolver? Thanks!Nicu

Hi! I'm trying to connect points to each other using lines. The points are in two seperate postGIS datasets, but have an ID-value in common. So I would need help to join points based on a common field / attribute. Does anyone know how to do this? I have successfully done this in QGIS using the Hublines tool. https://docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/vectoranalysis.html#qgishublines

Hello! I've been working on a project for a few weeks now and finally got a good enought network. Now I want to calculate the distance from every school to every adress point. This is to later create polygons from set distances.  Is it possiable to do this in the same shortest path finder? I've been looking at list but can't figure out how to do it. Can anyone help me? I have attached my workbench and the data.  Best regards Jesper

Hi there, I'm converting IFC to CityGML following the tutorial FME shared here: https://community.safe.com/s/article/bim-to-gis-intermediate-ifc-lod-300-to-lod-4-cityg.  It is noticed that the representation of WallSurface is quite strange (red lines on the surface). May I know the reason and if there are any solution to make the wall surface shown as smooth surface like others? Thanks in advance!

I know that in PythonCaller processing is feature wise and each attribute can be access by feature.getAttribute().But for my task I need all values of attribute (e.q. to check min, max, uniqueness etc).I know that I can check those e.q. in AttributeValidator but for current task I need them in PythonCaller.Is there some way to accomplish this using fmeobjects?Something like getAllAttributeNames() but for let say column not line?Thanks,Submi

I have an Edge line (like a polyline) and would look to trim some length in feet off the beginning of the line, with the rest of the line remaining intact as is. Is there a transformer that can do this?

I've created a workspace that updates (and truncates) an ArcGIS feature service. It works great! I'd like to run it once a day in the middle of the night like 3:00 AM. I have a floating FME Desktop license and don't have access to an FME Server. I use the floating license on my desktop and laptop computers, both run Windows 10. I think that this may be more of a Windows 10 question rather than an FME question. Can anyone recommend a way for me to run an FME workspace once a day at a specific time on my desktop machine? Because I have a floating license, I think that I'll need to make sure to FME Desktop on my laptop at the end of the day. Thanks.

I need to update a text file which contains the settings for an executable tool. It would be really useful if I could automate this in FME. The text file is saved in UTF-8 format and for example, lines two and three contain the variables for START_TIME and END_TIME: START_TIME=2005/01/01 00:00END_TIME=2007/12/31 23:59 How can FME be used to change the two dates, 2005/01/01 and 2007/12/31? Thank you, Rob