General

HiI'm wondering if anyone can give some advice on the following;If i have 2 simple tables;One table with 2 records, captured as polygons against the same feature (a building outline); Each record has a unique referenceAnother table, also with 2 records, but each captured as a point to represent an address; As with the polygon table, each record has a unique reference.What i would like to do is allocate the unique reference from each point record to each of the polygon recordsIt doesn't matter which point reference gets allocated to which polygon record, I only need to be able to allocate.I should add that the points lie within the polygonsIs this possible in FME? I'm thinking the SpatialRelator may work, but how would FME allocate one reference to another table and then perform the next allocationthanksSimon Hume  

Hi Everyone, I have been looking in the forum but could not find loads of info on 3d Clash detection, a topic I thought would be quite common here. Nonetheless, I have made an example script trying to catch Objects in an .ifc Model which are Geometrically modelled over one another. This is quite easy to test and visualise in Navisworks Manage or DeSite - IfcViewer Softwares.  In FME Desktop I attempted using the Matcher, Geometry Validator and CRC Calculatoras with a 2d SurfaceFootPrintReplacer, but to no avail. The clashes are not shown in my workspace, where am I going wrong? Thanks for any help or suggestions. Fred

Hello! I have some Civil3D files that contain 2D and 3D points/lines/polygons, as well as surfaces. These files need to be converted into a format that can be opened in Rhino for a client. I am having a challenging time successfully extracting all of the different types of data, and it's probably because I'm not as familiar with these data formats. Does anyone have any suggestions on how to do so? A direct Civil 3D --> FBX results in a drop of 3D line/polygon data, but I'm sure there's something that can be done with something like a SurfaceModeller. Although, it's taking hours to process a relatively small file so I'm sure I have an incorrect setting somewhere. Any help is appreciated!

Hello,I have a web application that provides JSON results on a webpage. However, this results is created using javascript and web workers (mostly for efficiency purpose). Therefore, the javascript process takes some time to complete, and update the DOM content of the page.As I result, the HTTPCaller transformer provides the page content before the update (and the JSON result being integrated). I own the web service as well, do you think of a way (both in FME or on the web service side) to gather the JSON result in FME ? Thanks !

I'm using FME Desktop 2020 and have a workbench with several SQLExecutor transformers. These are performing 1000s of SQL queries against a PostGIS database and working fine. The only issue I have is that every SQL statement is being logged in the FME log, which is creating a bloated log file (100s of MBs in size).  I don't need to see the individual SQL statements in the FME log, but these are coming through as INFO level messages (I would actually class this type of logging as DEBUG not INFO level log messages - but that's another story). I know there are options to turn off INFO messages, but other INFO messages may be useful. So is there a way to turn off logging of SQL statements only? I would have thought this could be a global logging option or an option on the SQLExecutor (and SQLCreator) if this option doesn't exist already somewhere.  Any thoughts appreciated. John

This is the statement I am using in SQL Executor. It runs fine in SQL Server Management studio.  update a set ParcelID = NewParcelID, KOAUnitID from  (select a.ParcelID,b.ParcelID NewParcelID,a.KOA_UNIT_ID KOAUnitID from   [GISStaging].[dbo].[KAINGAORALETTABLEUNITSTAGINGNZTM] a left join  GISPublish.dbo.Parcel b on a.shape.STIntersects(b.shape) = 1) a  and this is the error message:Microsoft SQL Server Spatial Reader: Query failed, possibly due to a malformed statement. Query Text `update a set ParcelID = NewParcelID, KOAUnitID from (select a.ParcelID,b.ParcelID NewParcelID,a.KOA_UNIT_ID KOAUnitID from [GISStaging].[dbo].[KAINGAORALETTABLEUNITSTAGINGNZTM] a left join GISPublish.dbo.Parcel b on a.shape.STIntersects(b.shape) = 1) a'. Provider error `(-2147217900) Incorrect syntax near the keyword 'from'.'A fatal error has occurred. Check the logfile above for details

Our situation is as follows:We have a network that we have built with the help of several sources of information, and we want to verify their correctness, prior to the publication of the information.One of the tests we did, and have already fixed the problems, is a check of the flow directions. Each line exits an manhole, and exits to the next manhole, where vertex 0 is the beginning of a line, and vertex 1 is the end of a line. (You can see in the picture with the arrows, which symbolize Vertex 1)I did this test with the help of "VertexExtractor" , and it was pretty successful.Here I need their help:The relevant data for the lines are: "StartHeight" - the height which the line begins- the height of the exit from the manhole, and the invert which it is exit from the manhole."EndHeight" - the invert which it entered the manhole.The relevant data for the manholes is "IL out

Hi,I export a shapefile from FME. The shapefile contains lines and some entries without lines. After that I open it in QGIS. The shapefile looks good, but then I try to edit some specific lines I get an error: CRITICAL   Layer Info : OGR[3] Fehler 1: REPACK of layer 'Info' failed. I try to find a solution for the problem and find a workaround:Export the same shapefile again in QGIS to shpAll data inside are the same, only when I try to open it, the header is differentQGIS writes "ƒpè": FME writes ƒè: When I copy the three characters from QGIS manuell it works! Why? What do these characters mean? 

Products - FME 2020.1.1.1  & Smallworld 5.2.4Relationship 1:nWe are able to load the data in Smallworld parent and child objects and maintain the relationship (1:n) using FME. Relationship 0:nFor 0:n relationship we are able to load the data in Smallworld parent and child ( except Relationshipattribute) objectsThe intermediate internal relationship table between the parent and child is not accessible in FME Smallworld 5 Writer to update the 0:n relationship.1. Can you guide in identifying what could be wrong?2. Do FME 2020.1.1.1 support writing 0:n relationship in Smallworld 5?3. Do FME 2020.1.1.1 support writing Smallworld 5 internal tables?

Hello,I have a large set of points, that I need to connect. With a LineBuilder and a Chopper, I can obtain each segment, but the angles are sometimes a bit harsh.And so I would like to soften them, creating a curve instead of a set of lines. But I want the curve to go trough ALL the points of the input. Therefore I can not use a Bezier curve.Any idea on how is it possible ?Thanks  The first pic is how I would like it, and the second is what I do not want, a Takashi solution for a similar problem, but that does not work here. 

when i bring an autocad drawing into any fme wb it shows the text as a different size than what is in the drawing. If i use esri to display the drawing it shows exactly what is in the drawing. Why can't this be done in fme?another feature i would like is to be able to turn the autocad text into linework (with the string as an attribute). I have accomplished this in some software before (can't really remember which software). The first part of the request would be to quickly read a file make a change and write the file back out with only a small change. (virtually impossible to do with fme currently). The second part of the request would be to in effect use the drawing in fme to write out to many other software with the graphics of the drawing preserved.

Hello there,I need to create empty shape files, using an attribute as directories and files names.For now I always have an object( with "NULL" attributes values) in each tables.Any one have a solution ?

Hi all,  I have multiple dwg files. I created concave with help of HullAccumulator and I would like to identify which concave hull intersects which concave hull. It is possible that one concave hull intersects more than one. For example if polygon 1 overlaps with Polygon 2 and Polygon 2, I would like to add this in the attribute of Polygon 1.  I am trying to combination AttributeCreator & Intersector and Tester but I could not get expected results until now.  Thanks in advance.

Hi I'm trying to export all of my feature datasets in my ArcGIS Online account to independent shapefiles. I'm using the 'Dynamic Schema Definition' option in my Writer to output a separate shapefile for each of my feature datasets. In my ArcGISOnlineConnector transformer under 'User Content Folder', if I select my root folder, I get shapefile outputs with names that match my feature datasets, but they are all just empty shells, no attributes or geometry. However, in my ArcGISOnlineConnector transformer, if a specify a specific subfolder from my ArcGIS Online account for 'User Content Folder', then the shapefile outputs are all good, with correct attributes and geometry. But obviously I only get outputs from that one sub-folder. I need shapefile outputs from all subfolders. Can anyone point out what I'm doing wrong please? FME file attached. Cheers, Damian

Essentially I'm looking for a group by function where I can group my data based on a shared value and then export these subsets into seperate shapefiles where each subset shapefile shares the same attribute value. For example my shapefile has field that has either a value of 1,2,3,4 I'd like to create 4 shapefiles from the main shapefile where 1 shapefile has the value of 1, the other has the value of 2, etc..

Hi guys.Everything was working great with the 2018. But since I moved to the 2019, no matter what type of file I bring in the Data Inspector, it just crashes after trying to load it. The Workbench works fine though.I tried all the builds (of the 2019) that have been released so far, no success. I tried to re-install, uninstall, still nothing. But as soon as I get back to the 2018, Data Inspector works again.The problem is that I need the 2019 for latest import and visualization of IndoorGML. I suspect the bug is related to Qt5 because when I try to debug the application with mvsc2017 I have the following exception thrown:Unhandled exception at 0x00007FFE39931BFC (Qt5Gui_fme.dll) in fmedatainspector.exe: 0xC00000FD: Stack overflow (parameters: 0x0000000000000001, 0x000000CEEFE03F18).I did not update anything related to Qt5 lately. Anyone has an idea?Thanks in advance.

I am getting a rejection of one line in my wb that seems to be valid.as per safe documentation i have place a geometry validator and geometrycoercer into the workflow. yet it is still rejectedWhy would this be getting rejected for invalid geometry type?with these parameters on the validator.Feature Type MValue_OUTPUTCoordinate System NM83-EFDimension 3DNumber of Vertices 2Min Extents 7764.78954863, 4086.494, 3384.991Max Extents 7764.868, 4086.956395047, 3385.0004943987096Attributes (61)  _elevation 3384.991  Alignment_Sheet_Status COMPLETE  autocad_color 12  autocad_entity autocad_line  autocad_entity_visibility visib

Hi ! I hope someone can help. I'm trying to create more attributes within existing list without exploding and rebuilding it. Like this: _list{0}.aaa : A_123_list{1}.aaa : A_234_list{2}.aaa : B_245 to _list{0}.aaa : A_list{0}.bbb :123_list{1}.aaa : A_list{1}.bbb: 234_list{2}.aaa : B_list{2}.bbb: 245 Is there a way? I'm specially looking for help on the list creating part. I can manage renaming the list values;) I was looking for a way to first do this:_list{0}.aaa : A_123_list{0}.bbb : A_123 and than do this:_list{0}.aaa : A_list{0}.bbb : 123 cheers,ronald 

Trying to compare two columns that have strings concatenated by ' | ' and look like this: COL Aabc | def | ghi COL Babc | xyz Desired result:COL C that contains the matching part of both strings. In this case result should be: abc COL D containing the count of matched parts of the string. In this case, result should be: 1 Would appreciate your response. 

I used NTLM authentication in FME Desktop back in 2018/2019 with no problem. Now with FME 2020, it no longer works.  I am able to set up the reader fine: and select my List(s) with no authorization issues: However, at run time, or when trying to inspect the data, it fails!  Microsoft SharePoint List Reader: Client-side error: '404 Client Error: Not Found for url:

Dear All, I have a dgn file (version 7).I want to convert a dgn file into shapefile while still keeping the Fill values of the objects. How can I do that by using FME Desktop?I have tried using Feature to Feature in ArcGIS but all the values of Fill are -1.Thank you very much!Yours sincerely,ND Liem

Keep up-to-date with this week’s installment of What’s Up Wednesday. Gartner Peer Review SurveyIf you haven’t already done so, there is still time to earn that shiny exclusive badge on the community for filling out the Gartner Peer Review Survey. Get started by visiting http://fme.ly/CommunityInsights and entering your community username.  WebinarsIf you missed it, you can watch the Ask Me Anything FME Server Edition webinar. Thank you to everyone who submitted questions, this webinar was a huge success and we are planning on doing more like this in the future.  We also have lots of upcoming webinars hosted by Safe, such as integrating with

Hi all, I would like to know if it is possible to restart a counter when an attribute in a set of features changes. I've only succeeded in sorter the entire feature set from 1 -> x. thxPieter

Hi, I have a dataset with a class called drains, I no longer want drains to appear in the dataset and would like to merge/dissolve these on their nearest neighbour. When I do this at the moment, many dissolve and the neighbours attributions wins out, but in some cases (it appears to be when the drain is the bigger feature) the drains attribution remains. Is it possible to dissolve all drains into their neighbour and always have the neighbours attribution remaining?Thanks for any help. B

Given a workspace that uses FeatureReader, with a Geodatabase feature class as the "initiator", does anyone have a suggestion for how to process one Geodatabase feature (from the initiator) at a time? I have a large geographic area currently as the initiator and the model goes on to process millions and millions of features from dozens of feature classes (via FeatureReader), and is a slug! I am hoping that by clipping the data that represents my initiator in the above description, and finding a way to make workbench process only one feature at a time from a single geodatabase feature class, it can process the data in more timely manner. I have looked in to Workspace Runner but I can find any material on how to use it to process features from within the same feature class.  Thank you