General

My FME Workbench has a python startup and shutdown script (Esri ArcGIS 3.6 python interpreter) that works fine when running in the software or in command line with arguments.  When I put the workbench on a windows task scheduler, the workbench does not run and I get a 0x1 error in task scheduler. If I remove the python startup/shutdown the job runs fine on scheduled task.  Any ideas on how to resolve this? Thanks in advance! More detail:FME Desktop Version: FME 2020.1.0.1 (20200710 - Build 20596 - WIN64)FME_HOME is 'C:\\Program Files\\FME_64\\' Command line to run workspace: "C:\\Program Files\\FME_64\\fme.exe" "D:\\SOE\\FME Workbenches\\GRI\\GRI_Guardrail_AssetID_Creator.fmw" Python Interpreter: Using Python interpreter from `C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3\\python36.dll' with PYTHONHOME `C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3'  

I have a field with data like this: 10-234-RI want it to be like 10-234R.  So in other words, I want to remove the 7th character which is a dash '-' from the string: 10-234-R String Replacer doesn't work because it removes both dashes and not the specific 7th character dash I want to remove. AttributeTrimmer i can't get it to work. I chose Trim Type Both but how is it supposed to know to remove the 7th character only. Any help would be appreciated.  Thank you.

HelloAs shown in the drawing, I would like to have another curve parallel (2) that goes through 2 points at the same distance each from the original. The whole problem is that everything is in 3D.The distance between the new points and the curve is unknown. I have the shape of the curve and the point location but transformers like LengthToPointCalculator are not working as I lack informations.So i would like to know how to calculate the distance bewteen a point and a curve in 3D. Note that the curve can have any shape.And also, the OffsetCurveGenerator is only 2D, and does not work with a 3D length in my case I thought about getting the distance in 2D which I don't know once again how to obtain, use an OffsetCurveGenerator and then force it in 3D, but the elevation changes between the beginning and the end of the curve, so a 3DForcer does not work, I think. Has anyone an idea on how to solve it ?Thanks in advance 

Hello, I would like to total the number of times each record appears in the dataset. Here is an example of what I would like to count:I've tried using the FieldCalculator but I just keep getting 0's for the sum function. See photo below:I'm not sure how to set the parameters in the FieldCalculator to perform this function. Here is what I have currently set:Thank you!                 

Welcome to What’s Up Wednesday Gartner Peer Review SurveyJust over a week left to fill out the Gartner Peer Review Survey to earn a community badge. Get started by visiting http://fme.ly/CommunityInsights and entering your community username.  BlogHave you seen our virtual 3D booth at a conference lately? Want to create one for your company? Dmitri explains the motivation and how he created it in a new blog post.  Community GroupsAre you interested in user research regarding FME and what we do with that research? Check out the FME User Research and Feedback Group in the Groups section on the Community.  Community Groups are new for this version of our online community, what kind of group would you like to join? Let us know in the comments below!  CloudFME Server is available on the Azure Marketplace. If you are interested in cloud deployments, check out this article to learn more.  We also have a new FAQ on FME Server and Kubernetes that you should check out.  Transformer HighlightLast

Hello all ! I'm trying to build a pdf report.In the end it should contain map content as well as a table out of the spatial data attribute table.By now i'am failing at the simple point to write an attribute to pdf. Create a Text Attribute --> fill this attribute with text --> Style it with pdf Styler --> route to PDF pageFormatter and place the Object on the pge --> route to pdf Writer The pdf is always empty, no matter what i try.Any idea, i guess the Adobe Geospatial pdf writer needs a kick in any way.Version: 2020 RegardsAl

Dear all,  i need help to find solution to filter polygons with area below 1000 and dissolve it with neighbour with longest common boundary. In qgis is tool Eliminate selected polygons. I tried neighbour finder, spatial filter, but i can't find good solution.  Thanks in advance

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"= invert level out.Because the drain flows in gravity, the "StartHei

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? What can I do to get the same output like QGIS? Sry I can´t share the workflow and the data-> workstuff. Thanks for your help. 😃

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 visible  autocad_layer_desc  autocad_layer_frozen no  autocad_layer_hidden no  autocad_layer_locked no  autocad_layer_on yes  autocad_layer_plottable yes  autocad_linetype ByLayer  autocad_linetype_scale 1  autocad_lineweight -1  autocad_original_color ByLayer  autocad_original_entity_type autocad_3dPolyline  autocad_resolved_linetype CONTINUOUS  autocad_source_filename S:\\SUR

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