Best Answers

Hello, here is what I am trying to do in a workbench that is attached here:1) Input data are .xyz file with a list of 3D point coordinates, jpg + jgw files with DEM photo2) I need to create surface TIN + set an appearance to it3) I need to export it into a format that Trimble Connect is able to process.(https://community.trimble.com/viewdocument/supported-files) - There is a list of 3D supported formats The problems that I run into:1) Data need to have a defined coordinate system.1) I need to create a FME Cloud app, where customer is able to run this transformation themselves. 2) The formats that Trimble Connects do not support textured surfaces / solids3) FME Cloud does not support many writers that Trimble Connect would be able to process DGN - FME is unable to write 3D solids (only extrusions, which is not what I need) or meshes, all dgn files that I try to create are after loading simple lines.https://community.safe.com/s/question/0D54Q000080hfr8/dgn-writer-outputs-lines-instead-of

Hello, I am trying to convert text strings like Jan-2019 to date . The text strings don't have the day values. I have tried using DateTimeConverter transformer and the date time functions in AttributeManager but it doesn't work when I specify %b-%Y. However, with the DateTimeConverter, when I convert text values like Jan-05-2019 using %b-%e-%Y , it is correctly converted to 20190105 .  How can I achieve the same to convert the dates like Jan-2019 without the day value to 201901 ? Thanks

The documentation for the counter transformer references parameters that are no longer available in the latest counter version. How should the new counter be configured to pickup the count start from another counter in the same workspace?

-Because while the new data coming from httpCaller should be written to AttributeFileWriter, first the file starts the parse process. In this case, it causes old data to be processed instead of new data. -If I delete this file from desktop then run the workflow from fme server;-Fme server run workflow and see engine logs;Why do it works first parsing file then httpCaller ? True way that is it gets httpCaller new data firsly and write to file.

Error: An error occurred while installing package 'C:\\Users\\<accountname>\\AppData\\Roaming\\Safe Software\\FME\\Packages\\21789-win64\\PackageFiles\\safe.emailer': An error occurred while installing Python package with 'pip install --force-reinstall --no-deps --no-index --find-links C:\\Users\\<accountname>\\AppData\\Roaming\\Safe Software\\FME\\Packages\\21789-win64\\PackageFiles\\safe.emailer\\python --target C:\\Users\\<accountname>\\AppData\\Roaming\\Safe Software\\FME\\Packages\\21789-win64\\python\\safe.emailer --upgrade --no-compile fme-emailer' : Process crashed. Done both as a std user or an admin. Same issue. Any assistance greatly appreciated.  

I have a very old file while contain contour lines. And then I obtained a new DEM from which I generated new contour lines. Visually I can see that between 2 files, the contour lines of the same elevation differ in distance and they differ from one elevation to another. Is there any way I can get a statistical result about max, min, mean between these files? And is it possible to visualize this?

I had an engine queue pileup where job where just getting added to the queue and never ran. Since there were no failures none of my automated notifications were going out. So I completely missed this. Is there a way I can set up hourly polling to check the number of jobs in the queue? Did a quick search for doing this with Rest API but nothing jumped out at me. Thanks for any suggestions you may have.

On our machine running FME Server, we have both ArcGIS desktop 10.6.1 and ArcGIS Pro 2.7 installed.  When we run workspaces that require an ESRI license, FME Server can get a license, but pulls a license from the ArcGIS desktop 10.6.1 license pool (As shown below). The same thing happens when the same workspace is run in FME Desktop. 2021-12-14 01:10:07 | The ArcObjects license 'Advanced' is being selected from the Windows registry2021-12-14 01:10:18 | FME has checked out an Esri license. The product checked out is 'Advanced'2021-12-14 01:10:18 | Installed ArcGIS version is '10.6.1' How can I configure FME server to check out a license from the ArcGIS Pro pool? Preferably the advanced concurrent use license. We followed the step by step instructions for using ArcGIS Pro with FME server in this article without succes: Using ArcGIS Pro with FME Server (safe.com)

Hi FME communityI have successfully added a web connection to my Sharepoint site following this tutorial https://community.safe.com/s/article/How-to-create-a-Sharepoint-Web-Connection using the Client ID multitenant method.Then when I browse the Site: parameter (image below) only a subset of all sites in my organisation are showing. My goal is to read files hosted in Sharepoint just as if they are sitting on my hard drive. Anyone have any suggestions on my issue above or know of an alternative way to connect to Sharepoint?Thanks

MapInfoStyler parametersFor a Region, how do I set the Fill Background Color to be transparent?For example, Fill Pattern 30 is diagonal lines. I want the spaces between the diagonal lines to be transparent, so I can see the layer underneath.

Hi Everyone I have come across an ifc file where the Feature Reader does not find all IfcSpaces when reading a file.  Both ifc Viewers DeSite and Solibri manages to read the files, but the Feature reader loads maybe only a third of the objects. My suspicion is that there has been some post editing of the Ifc file by some third party software or created with a plugin EDM? EDM Software:https://jotneit.no/express-data-manager-edm Example of Ifc FileStructurehttps://essxnce.wordpress.com/2019/07/31/190731-searching-how-to-make-ifc-file-from-non-ifc-file/ If someone know how to read there files with success, please give me a shout out! If not, I imagine this needs to become a feature request to be able to read EDM IfcFiles? RegardsFred 

I'm reading a number of json files each with their own set of records. I can see I need to expose many attributes but without adding hundreds of lines (the index goes to 142). Is there any easy way to go from screengrab below to web site structure at http://reg.bom.gov.au/products/IDT60801/IDT60801.94850.shtml:

Hey all, seems a new vulnerability is currently being exploited across the wider network. From what @Todd Davis​ and myself have determined, it seems it will effect FME Server. https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2021-44228https://arstechnica.com/information-technology/2021/12/minecraft-and-other-apps-face-serious-threat-from-new-code-execution-bug/ Further investigation seems to show that FME Server 2021.1 and on wards contain 2.13. Versions post 2.10 can include the following parameter to mitigate the exploit:‐Dlog4j2.formatMsgNoLookups=True https://www.zdnet.com/article/security-warning-new-zero-day-in-the-log4j-java-library-is-already-being-exploited/

Hi I would like to use a new line as a separator in the list concatenator but I do not know what I need to actually type into the separator box. The help suggests a sequence of Ctrl+Shift+j (^J) but if I CTrl+Shift+j, nothing happens. I have no idea about the ^J. I have tried pasting this in as text too but no combination works. Please could someone explain what the help file is suggesting I do? Thanks

I've been given some data - 10 KMZ files which seem to comprise multiple named layers (so over 70 in total) with only occasional data in the Name field, which I want to convert to TAB format. I'm struggling with it - below are 3 views of the data - in Google Maps, in QGIS and in FME Data Inspector. I also attach one of the KMZ files here. I'd like to generate a workspace to produce 10 MapInfo tables of points, lines and polygons, to correspond with the KMZ files and named as the KMZ files, but with an attribute column populated with the layer names, for example, "J Garden Terrains" (in QGIS appears to be the Layer names) and a Name field for the occasional data that has. The only way I can see of converting the data at the moment is to click on each layer in QGIS and Save As a MapInfo table. I'm sure I must be able to do this in FME - I hope so! If anyone can help I'd be very grateful. Thanks, Jane

I'm running JSON Fragmenter to break out an array, and, in the process, it indexes each row of that ID. Is there a way to retroactively put the last JSON Index value of each ID's array into every row associated with that ID? I'm trying to calculate a percentage of where each row is compared to its total. (JSON index [8] of ID XXXX is in the first 2.34% of ID XXXX's total JSON Index.) Thanks, in advance!

I am trying to write a fanout of a large pdf using bookmark data that was merged from a csv file. The fanout works, but the output files give me either blank pages or very blurry/unreadable images. The source file contains many jpegs and was created using BlueBeam. I am able to see raster images using RasterConsumer (filtering to single pages), but the end result is unusable. Here is my workspace with annotations:Surely this is possible?Thanks,@lorenrouth​    Update:After looking at the data from the GeoSpatial PDF Reader, the issue appears to be the file has multiple formats on the same page. How do I deal with a pdf that has text, image, raster, spatial and vector data all on one page?!?!? If I send spatial data only to the writer, it leaves out an important raster image. If I include the raster, it is output with an unreadable black background and blurry text. If I print the pdf as an image, it looks fine, but there is no text or metadata associated with it, making it impossibl

I am struggling to ouput rasters correctly when using the GeospatialPDF writer. My source file is a PDF that has text, image, vector and raster data. It's the raster that is giving me the trouble. When isolating the raster and sending to the GeospatialPDF Writer, some of it comes comes out ok, but the rest has a black background. Interestingly, the colors are switched when viewed from Google Drive! What is going on here??? Viewing the raster directly from the GeoSpatialPDF Reader, it looks more or less normal (should just be a straight white background for everything). My workspace is literally a Reader and a Writer, that's it. The goal is to be able to render the output pages exactly as the original, using the data from the other objects for a fanout. Any ideas? Thanks,@lorenrouth​ 

So, I have a set of flight tracks, all uniquely identified, and I'm trying to separate the flights into phases. I've had great success for the takeoff and landing portions, as well as the cruising portion, but the ascent and descent is giving me a hard time. When a plane is ascending or descending, it gets a "C" or "D" in the altitude change column. I thought that I'd be able to characterize the ascent to cruising or descent to landing phase merely by the presence of C or D (when it levels off, it gets a "-".) Sometimes during an ascent to cruising or descent to landing, however, the plane will briefly get a "-" or worse an opposite letter, which kills the consistency in characterizing the phases of the flight. But, if a "-" or the opposite letter is present, it will always be preceded or followed by the correct flight status. So, is there a way to change an attribute's value according to that flight_id (a separate value

Using FME 2021.1.0.1 When trying to use an FME Server Parameter in a Scripted Parameter, I get this error: ----------------------------------------------------------------------- Starting translation...INFORM: Using Python interpreter from `C:\\Program Files\\FME2021\\fmepython38\\python38.dll' with PYTHONHOME `C:\\Program Files\\FME2021\\fmepython38'INFORM: Python version 3.8 loaded successfullyERROR : Python Exception <KeyError>: 'FME_DATA_REPOSITORY'INCLUDE -- failed to evaluate Python script `def ParamFunc(): import fme repo = fme.macroValues['BOB'] repo = fme.macroValues['FME_DATA_REPOSITORY'] if repo == "Example Name - DEV": env = "DEV" return envvalue = ParamFunc()macroName = 'ENV'if value == None: return { macroName : u'' }else: import six try: value = six.text_type(value) except UnicodeDecodeError: value = six.text_type(value, 'utf-8') return { macroName : value }'Program TerminatingTranslati

Hi, all.I'm trying to pull a couple of dozen JSON files into FME with an API through flightaware.com, so that I can build flight tracks, based on the unique flight_id of each flight.I built a python script today that accomplishes the objective and saves all of the separate JSONs into one JSON, locally. With some help, I figured out how to pull that JSON into a couple of fragmenters and have been going from there. So, ultimately, I have the option of continuing to run the script separately from the FME session, but I was curious if anyone knows how to integrate an independent Python script into the workflow. Python caller hasn't worked for me, I assume because it's designed to process features not save files locally. Also, I didn't use the http caller because the URL request was done per flight id, so I decided I'd need 20 callers running simultaneously. Is that a correct assumption, or is there way of iterating through a list to fill in the URL request multiple time

 I have a workbench that has two ESRI Geodatabase (ArcSDE GeoDB) readers. The first (TableA) is a table containing updates that have been made, there could be up to 500 rows found. The other (TableB) is the table that needs to be manipulated based on the updates found in TableA, this table has 500,000 rows.  For efficiency sake, I am hoping to only read the TableB if there are rows returned from TableA. Can we tell the workbench to run the TableA reader first, IF rows found in TableA, then read TableB and continue through workbench processes, ELSE end workbench. Any thoughts on if this is a possibility?

Is there a way to bring the user name who requested a job run into the workspace as an attribute?  My current attempt uses a PythonCaller with the following code: import fme, osimport fmeobjects def processFeature(feature):    feature.setAttribute('Username', os.getenv('USERNAME'))    pass...and passes Username on as an exposed attribute. This works fine in Desktop, but in Server it always results in the Service Account username populating the attribute.  So if I run this in Desktop, Username is populated with jpickles... if I run this in Server, Username is populated with serviceaccount even though I am logged into FME Server as jpickles.  Is there an easier way to accomplish this task that I am currently unaware of? 

Hi, I have two shape files. One containing roads and one containing the grade of the condition of the road based of an inspection. The shape files share two attributes, starting point of the road and ending point of the road. I would like to add an attribute in the road shape file, which is the grade from the other shape file. Not every road has been graded, but I would like to add the grade as a new attribute for those that have a grade. So, if there is a matching starting and ending point in both shape files, which means that it is the same road, the grade should be printed as a new attribute in the road shape file. I hope this makes sense. Thanks a lot in advance! :)  

Here are the BADNEWS errors, these I haven't seen before. Could someone help me out in the right direction where they are coming from or does someone know a solution? 2021-12-09 14:46:38|  4.0| 0.0|ERROR |BADNEWS: An error occurred while fetching from query `SELECT OWNER, TABLE_NAME FROM ALL_OBJECT_TABLES WHERE OWNER IN ('GBIBASIS','PUBLIC') AND TABLE_NAME = 'GB_MECH_LEIDING'' : OCI_NO_DATA2021-12-09 14:46:38|  4.0| 0.0|WARN |(C:\\code\\fme\\foundation\\framework\\util\\dbwrap\\ocistmt.cpp:663) class StatusInfo *__cdecl STFDB_OCIStatement::fetch(unsigned long,unsigned long &)2021-12-09 14:46:38|  4.0| 0.0|WARN |Exception Name: stk::ex::Throwable -------------------------- 2021-12-09 14:46:40|  6.0| 0.0|ERROR |BADNEWS: Cannot convert null string into an integer2021-12-09 14:46:40|  6.0| 0.0|WARN |(C:\\code\\fme\\foundation\\framework\\util\\stf\\stfutil.cpp:348) class StatusInfo *__cdecl STF_stringToUInt(const class ObsoleteString &,unsigned long