General

Hi folks, I have a question from a customer, how can I locate or find certain "NaN" (Not a number) records inside a Numeric field?I have tried with : AttributeValidator/option : Attribute is a Numeric,But I would like to know it there is another better way to do it.Regards

I am trying to install 2020.2 over 2020.1.3. Each time the installer fails with "FME Desktop 2020.2 Setup Wizard ended prematurely because of an error"I have tried restarting the computer, tried on another day, downloading the installer again, for some reason it does not want to install on my machine.Maybe I should wait for a new build.

Hello everyone, I am extremely new to FME and I am trying to do a basic task and take a column in excel and turn it into an inline csv document. Any help would be appreciated, even links to know forum answers I can't find yet.

Hi I have a database which has about 80 attributes that I need to add together. Short of manually creating an attribute in Attribute Manager's arithmetic editor, is there another way that can sum there? I thought about creating a list, but that creates a numbered element per feature, not per field like I need. Many thanksMark

The data has three points crossing a main segment. The center point will generally hold the correct elevation value needed for the adjacent features.

I would like to run more than 16 threads using the custom transformer in parallel on one machine. If I read the documentation, that is not possible because there is a limit to the number of processes available for FME licenses – in my case it is 16.Do we have in the FME licensing some trick which will allow us to connect two licenses to the FME client machine and by that use 32 threads with the custom transformer?

Welcome to your weekly FME news update!  FME 2020.2 is now live!Last week we launched FME 2020.2. This release is a smaller release in terms of new functionality, but we spent a lot of time building the framework for some epic things for 2021! Watch the highlight reel to see some of our favorite things in this release or read all about them in the blog post or on the new features page. Download the latest version from our website.  Personally, my new favorite feature is failed ports on Automation triggers in FME Server. Now you can send an email or execute other tasks to let you know your trigger failed.  FME Server Dashboards - Feedback wanted!Do you use FME Server Dashboards or another reporting tool to monitor activity on your FME Server? If yes, we’d love to hear from you. Please fill out this Google Form - it should take no longer than 5 minutes. Survey closes November 27th.  Coordinate Systems blog postHave you ever wondered about the difference between a projection and a coordin

Does someone recognize that Regex Lookbehind does not work in the string function FindRegEx, but does work in the StringSearcher transformer? Pattern: (?<=[_-])\\d+\\.\\d*$String: Foobar_1.023 RegardsDaniel Update: I did some testing, this is my result:Conclusion: StringSearcher and ReplaceRegEx behaves as expected with lookaround. StringReplacer doesn't handle lookaround at all.FindRegEx handles lookahead, but not lookbehind. Test workspace is attatched.

Today we had a great question on the community about counting the number of line vertices in a given section of line: "Lets say I have locations of point/polygon features along a line and I would like to count the number of points along the line using a moving window. For instance I'd like to slide along the line using a window of 100 feet. As I move along the line, I want a count the number of points within the 100 feet window until I reach the end." At first glance, this looks like it ought to be a problem of spatial analysis: you create a buffer perhaps, 100 feet long, and do an overlay to count the points inside it. Then you move it along by a set offset and repeat.  But consider: if you could just take the line feature, create a list of its points, and calculate how far along the line they existed... well then you could analyze the numbers not the geometry. That would be easier and quicker. And the distance along the line that a point exists has a name: a Measure. Me

The directory starts fresh every time, files copied are and produced by other FME Workbenches, testing condition whether a directory contains a 1-1000 files. I'm found and filter for the required files via FeatureReader Path but having a hard time testing for specific condition, Tester before a ListBuilder or a ListBuilder then a ListSearcher ??? PASSED condition if the directoryMust find = const.dwg, exist.dwg, passed.kmzMUST BE NOT FOUND = failed.kmz FAILDED in all other conditionsFound = const.dwgFound = const.dwg, existing.dwgFound = const.dwg, existing.dwg, failed.kmzFound = const.dwg, existing.dwg, failed.kmz, passed.kmz...... 

It's not up there with previous oddball ideas (sundials, QR codes) but randomly scheduled jobs certainly isn't something everyone will need. On the other hand, perhaps you might want to do data QA at random intervals, or sample a live feed at unscheduled times (what is the weather/traffic load at this particular point?) I thought about how I might achieve this, and here are the methods I used and the results I got. FME Server SchedulingHere's what the scheduling dialog looks like in FME Server:  As you can see there are no options to randomize time, which is sensible really. If FME had to pick random times then the user would have to enter the probability of an event (say, 1:10,000) and FME would have to continuously test for that, taking up valuable resources while doing so. Similarly the CRON command doesn't have the option, and the solutions I saw online involved more of a command-line CRON process. So, I considered two viable FME processes: Have one workspace run an

Our company was told AutoCAD will go from a computer-based to user-based license structure. We're wondering how this will affect using FME.

I just installed FME server 2020.1 in the hope to use the Server App functionality. One example comes up quickly. I have a XML file that I want to use FME server app to edit a few elements. The flatten elements are shown in the attached image. I want to present this in the server app as some kind of table. The label column is static and each cell of the other two columns either as a free text entry or a drop down choice. The free text entry and dropdown can be published FME parameters. The initial free text entry and the drop down choice is populated from the XML file, but the users can enter or select their own choice. The have a Save button to save the results back into the XML file. Is this possible to do this in the Server App?

When I try to use 3D-breaklines, the contours are created without regard to the breaklines. See my method below. It's a simple process where I create a terrain mesh and coerce the geometry type to line. Any suggestions?

I have a problem with a Pointcloud source file. It is a CSV file without headers and separator character is |, but there are also double quotes present (see yellow marked in the attached picture). When I use a pointcloud xyz reader it generate only 4 columns but I need 6 columns (with | as separator character), it seems that the quotes cause the problem to split the string between the quotes. It will work when I replace the double quotes for noting. That’s usable in a small file but most of the CSV’s contains more than 20 million records (up to 100 million records) so replacing double quotes is not so easy! Has anyone an idea to handle these csv pointcloud files? Is there a way to negate these double quotes, maybe a rewrite action will solve this problem? A subset of the point cloud is attached.

I use the SQL executor to join a lot of PostGreSQL and PostGis tabels. One of these tables contain a "geom" column with points and line objects. At the end of the SQL statement i want to select only the lines. Can anyone specify which statement to use to select only linestrings? 

Hi there, I am running below script succesfully in the PYTHON Creator but i can't get it to expose a created value into and attrribute. the script creates a 3 digit number in ICP_GEN_ICP based on a parameter I provide for CheckICP, but it won't get exposed. i need to know how I can assign this value to an attribute and use it in an XML templater. thanks! ps i am new to coding ( both FME and Python)   script: D = int('0x180f', 0)H100 = int('0x100', 0)H1000 = int('0x1000', 0)HFFFF = int('0xffff', 0) def Asc(bytes_obj):  '''Get the int value of a char'''  if type(bytes_obj) == bytes:    return bytes_obj[0]  else:    return ord(bytes_obj[0]) def Mid(string, integer, integer2):  '''Select a substring from a string'''  integer = integer - 1  return string[integer : integer+integer2] def gen_crc(icp_number):  """ Generate a checksum for an ICP"""  R = int('0', 0)    

I prepare WMS according to https://community.safe.com/s/article/how-to-create-a-wms-service-using-fme-server I use the same data and when I run the process in FME server I get http://FOTOFME01/fmedatastreaming/AB_TEST_WMS/GetCapabilities.fmw?&token=3263a54ac33d220770be9136328640104b698f19When I want to open WMS in FME I get log like in attachment: "HTTP/FTP transfer error: 'Couldn't resolve host name'Please ensure that your network connection is properly set upNo proxy settings have been entered. " What can be wrong? 

Reprojector: Reprojection failedAn error occurred. FME will attempt to provide more information on the error, but this may cause the translation to be terminatedAttempted a typeid of nullptr pointer! I get the above error. I don't know how to solve this

Is there a way within in AttributeValidator Parameters -> Validation Rule -> Rule Configuration -> NOT EQUAL a value? 

We have gps data , want to convert in to Polyiline format ​

Hello all, I've made an .fmw that allow me to extract a lot of information contain in an kml to store them into an excel file. It work well but I want to improve my .fmw by extracting more new information. So, in my kml I have some entity that have an HTML structure. Generaly I put an HTMLtoXHTMLConverter followed by an XMLXQueryExtractor to store info into new attribute but here I'm stuck, I don't know how to do.My request is maybe impossible to do, I want some of your advice.Here my XHTML : <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"><head>  <title></title></head> <body>  <br />  <br />  <b>System:</b><br />  type: mysystemetype<br />  SEN: 2569852<br />  day: 2022-09-04<br />  fw: P6589-69-05-25<br />  <br />  <hr />  <br />  <b>software compu

Lets say I have locations of point/polygon features along a line and I would like to count the number of points along the line using a moving window. For instance I'd like to slide along the line using a window of 100 feet. As I move along the line, I want a count the number of points within the 100 feet window until I reach the end.Once the counts is done, I'd like to segment the line as well, based on the total counts within the 100 feet window. Any ideas and help on this will be greatly appreciated.

Similar question, but for different reasons. The FME2020.0 installation MSI file when run in Repair Mode fails, so it looks like I'm going to have to manually remove this too. This one is because of the whole FME-using-the-Documents-Folder-for-Application-Files issue again. The installer placed things like \\CoordinateSystemExceptions into the C: Documents Folder. But the same installer when run in Repair mode goes looking instead to the Windows Redirected Documents Folder which is a Network Shared Folder. It fails to resolve the location since the original installation actually put them on the local C:\\ and then cancels out of the repair task. Cue: *Grumble about applications using Documents Folder for App Data* 👿

I saw these fields in the output in the examples provided by Safe. When I looked at the example workbench files I don't see where and why those fields are created.