General

Hi all, I have a huge dwg file I am clipping them by some grid. However my output get more textes than original dwg as you see in the images. I am not familiar with cad datasets. I believe it causes some sort of visibility? How can I make sure that my output is as same as the output? Thx in advance.

Is there a process in FME allowing for the creation of a seamless .tab file. In this case I have around 300 aerial imagery .tab files that need bringing togethere in a seamless .tab (note: not merging, but a seamless .tab). Thank you

Hi,thank you for your help in advanced.In ArcMap it is possible to export out a raster based on its currentl styling: https://pro.arcgis.com/en/pro-app/help/data/imagery/export-or-convert-raster-datasets.htmForce RGBCheck the Force RGB check box to export the output raster as a three-band RGB raster dataset with the current renderer.Additionally, while exporting to formats such as TIFF, JP2, PNG, and MRF that support alpha bands, you can use this option to export the data as a four-band raster dataset with an alpha band to preserve the transparency settings of the original data. Is this possible in FME? Thank you Oliver

Hello, I have some 3D Polyline (Polyline ZM) of which I am interested in the lowest/maximum height in order to be able to make a further query with this information. All polylines have a different height at each of their vertices. Is there an elegant solution in FME for extracting the min/max height of a line and then attaching it as an attribute?  Thank you very much for your support.

I have some excel files i am creating with coordinates in several columns. each time i create the files they will have different number of rows. i would like to put a label at the bottom of a group of columns for instance all the xy columns (merged columns) stating that they are NAD83 stateplane like...

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 SchoolJunior SchoolCatholic InfantsCatholic PrimaryAcademy 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 obvious

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 a

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 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.  P

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.