General

How to inspect CSV data file containing line data instead of point data information?

Hi, Where is the Parameter Presets saved? Is there a way to export and share presets with others?

Hi - I've set up a workbench to update a number of feature service layers in Esri ArcGIS Online. The feature services exist under my individual account within ArcGIS Online and the workbench therefore requires the appropriate web connection in order to run successfully. I've set the web connection as public and have ensured that the public key is in an accessible folder that is referred to in the workbench. However when a colleague opens the workbench it contains a reference to a different web-connection (one they have previously entered in another workbench). Is there any way to get the web connection that I have entered to persist in the workbench so that it is used when other colleagues open the workbench? Thanks very much for any advice.

I am creating a 'school catchment finder' so when a user types in their postcode, it brings up a list of schools catchments that their address resides within (i.e. essentially a point in polygon query). I want the result to bring up a table of 10 school types regardless of if that school type has a catchment at that address or not e.g. Primary School Junior School Catholic Infants Catholic Primary Academy School etc. The issue I have is when using ListBuilder, if one of the school types is not present at that address, the column headings still appear, but a different school type is listed under the school name. This sets the table information off kilter. E.g. If a Catholic Primary school is not present, they Academy School information appears under the Catholic Primary school headings which is obviously incorrect. From the images below, can anyone tell what I am not doing correctly?

Hi, In FME Workbench Build 20252, if I add a prefix using the BulkAttributeRenamer, it also renames fme_basename and fme_dataset. This have not been the case before. In the "visual preview > table" the fme_ attributes are NOT renamed, but in the Feature Information they are renamed. Have someone else come across this? I think this is actually a bug. Regards, Daniel

Below is the example file where I am getting all my data from. As you can see, each row has a unique ID and there are 4 sets of product information. What I am trying to do is create a single row for each set of product and ensure that the ID and User ID matches. Example below Any help will be greatly appreciated. Thank you

Hi! I would like to make a spatial join between two dataset. I usually use NeighborFinder but my problem is it duplicate each candidate each time a base is near. I would prefer for this time that each candidate can be used only once. So if a candidate match with a base then the candidate is not available for the others bases. In the example, the blue feature nearest the green, take the value "10" and the other blue feature, take empty value. Is it possible? Thanks!

I have a surface with a color/material, but the side of the color is different. How can I get the material/color on the same side of all objects? So all become grey in this example. thanks!

I will run a stored procedure (in a MySQL db) with the SQL executor but is doesn't generate output. I'm not so familiar with running stored procedures. See the attached picture, it seems the procedure is running correct. Is there a way to get output through the result port?

I have 5 original jpg orthophotos as follows and would like to have the same results but as one mosaicker file I have the following workbench to merge all of the 5 files into one mosaicker The output file on the writer I get the following final results with a black background which I don't want: If I set the RasterBadnNoDataSetter to a value of 255, I then get a white background, which I also don't need. Any ideas as to why I can't get the desired mosaicker without any black or white background? Thank you for your time and any insights would be greatly appreciated.

Hello! I need to randomly select 7 grids from the grid net including condition that selected grids cannot be self-intersecting and cannot overlap each other. See image below. How to approach it in the most efficient way?

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 thanks Mark

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 post Have 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 Regards Daniel 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. Measures A measur

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 directory Must find = const.dwg, exist.dwg, passed.kmz MUST BE NOT FOUND = failed.kmz FAILDED in all other conditions Found = const.dwg Found = const.dwg, existing.dwg Found = const.dwg, existing.dwg, failed.kmz Found = 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 Scheduling Here'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 and pick a random

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?