Best Answers

The attached data has 164028 rows but only 134483 row are actually read. I can import using Excel and this has the correct amount of data but if I use FME I get less, anyway I can resolve this? I have also attached the parameters I used. Cheers

Hello,  I use one featureReader to load Oracle spatial data on my workspace. How can i choose my geometry like the oracle spatial reader ? By defaut fme read the first geometry field.  Thank you

As an example, in Excel you would use the filter function and select specific values from the drop down menu across multiple columns. How in FME do you filter rows of data based on attributes held in multiple columns? I've looked at the two SQL translators; SQLCreator and SQLExcuter but both need connecting directly to a database. In my case I need to use the transformer within my workflow. Thanks.

Hi FME Community,I have a column with number. I want to add a dot to the last three numbers.the pictures show what I expect as a result:what I have:Thanks in advance :)

Hi all, InlineQuerier doesn't give the last two outputs ? 

Jag vill flytta min licens från en dator till en annan. Måste jag ta med hela programvaran eller kan flytta licensen mellan datorerna ändå?

I am not able to get the result that i want :i would like to have the same value of difference column for the same id but it depends on larger lengths for id_counter column .when we compare the row no.3 and row now.4 for id = 6so the output should be for first row id_counter = 1 /lengths = 2 /ID = 6/ difference = goodand the other row for the same id will be still the sameand the same idea with all rows . if the value in difference column is the same for the same_id so the program should do nothing and keep it .i was thinking to do it with matcher but i could not get the correct result .thanks for help fme 2018

I have a workspace where I have lines that are clearly duplicated but the matcher does not identify them because the coordinates are flipped on one versus the other. Is there a way to identify duplicate geometries for lines regardless of whether the coordinates are flipped. For example: Line 1Coordinate 0 = 1973175.975504196, 1785187.3988771015Coordinate 1 = 1973164.445329631, 1784950.337012621 Line 2Coordinate 0 = 1973164.445329631, 1784950.337012621Coordinate 1 = 1973175.975504196, 1785187.3988771015 Both lines are identical, however the direction of one is different from the other. So how can I eliminate one of these based solely on geometry.

I have 8 bookmarks each are doing separate tasks. However, the 1st bookmark must be done before the others. And the 8th bookmark must be done last. How do I enforce this?

A tool in FME to remove duplicates,  I couldn’t figure out which tool can remove duplicates. For example, in case we have two lines that are identical (one on top of another), then which tools can remove this duplicate?  For example, in the screenshot below we have 4 lines that are identical, then how to remove three of them and to leave one?    Thank you  Best  Jamal

HelloI am having trouble extracting attributes from a kml for the features that have photos.I am using XQuery similar to this example https://community.safe.com/s/question/0D54Q0000848CTkSAM/extracting-information-from-different-folders-in-kml-to-convert-to-the-shapefile That method works for the features that don't have photos but the features that have photos seem to have a extra section in the HTML that is causing my XQuery to fail. The Xquery I am using is : declare default element namespace "http://www.w3.org/1999/xhtml";for $x in /html/body/table/tr/td/table/trreturn fme:set-attribute($x/td[1]/text(),$x/td[2]/text()) I am pretty sure I just need to modify the Xquery 

Hi,The problem I'm trying to solve is as follows:I have about 2,000 aerial imagery ECW files, averaging in size around 30MB (so around 60GB in total).Each of the files cover 1km x 1km on the ground at a resolution of 10cm, so are 10,000px x 10,000px.I have been asked to downsample each file to 2,048px x 2,048px and output the results as a series of 4km x 4km tiles (each tile being 8,192px x 8,192px).I have an index feature class that lists each 'FileName' and its corresponding 'Tile' attribute.I've attached an image that shows this spatially, below.Large black squares and number labels represent the tiles that I want to output. The coloured squares with red outlines represent the original files.Previously, when working with a much smaller amount of data, I've been able to use my index feature class, in conjunction with a StringConcatenater, to provide the full path of each file to an 'ER Mapper ECW' FeatureReader.From there, I used RasterResampler an

FME 2020: How to filter dwg file based on hatches and Areas (polylines)? I couldn’t figure out how to filter dwg file based on hatches and Areas (polylines).   

FME 2020: How to filter dwg file based on lines and polylines? I couldn’t figure out how to filter dwg file based on lines and polylines 

table 1table 2 Expected result is : table 3:actgeneric_id------- fNotam_id1.2.1.1.3.1 ---------- 1.2.1.1.31.2.1.1.3.5.1----------1.2.1.1.31.2.1.1.3.5.2----------1.2.1.1.3 .... .... ..... .....1.2.1.1.4.1------------1.2.1.1.41.2.1.1.4.2------------1.2.1.1.4............ 

I am trying to use SpatialRelator with SDE and GDB layers that are the same data but the data is not matching up. I am using "Requestor OGC-Equals Supplier" to compare the layers. The point is when we get new data we can uploaded only the changed data into the SDE but I am unable to get the layers to match up. Both are WGS 84 and line up in FME Maps and in ArcGIS Pro they also intersect when running tools. There is no errors in the FME work flows that pop up after running it.

Table A:Table B:Result:How can i do it with Feature Merge transfomer in FME 2016 Build 16494 ? pls ..

Hi everyone, I am trying to download a set of files with the AutodeskBIM360DocsConnector and save them to a temporary location. The temp location is generated with the TempPathCreator. The BIM 360 connector does not have the option to pick an attribute for the "Download to Folder" parameter. Typing out @Value(DownloadLocation) seems to trigger FME to recognize that I want to use an attribute value, however during translation the attribute value is ignored and instead FME uses the string I typed in i.e. it creates a map named "@Value(DownloadFolder)".   

Hi FME Community,I have converted my Excel file into a CSV file. I would like the heading to be automatically deleted.In the picture I have shown with red marking which part has to be deletedI would be grateful if you could tell me whether there is a solution.Thanks in advance

I have a basic project as shown in the screenshot. In this example there are 54 items that need data cleansing (at the rejected port), I am wanting to send ONE email at the conclusion of this run, with a list of all the Property Numbers that were captured here.  If I add an emailer at this 'rejected' port I will get 54 emails. I am assuming there is a simple way to list then expand into the body of a single email? 

Hello everyone,​So I want to do something similar to "IMDF Validator".​My data format is "GeoJSON" in one single file. When I import the data, it will break into 4 feature types. ​I just not sure how to set up something similar to IMDF validator, with "Creator" at the front (just like the picture I uploaded? Also, the user parameter of IMDF validator is set default in ZIP file, yet I have to set it to geojson file.​Should I use Create Custom Transformer? But I am not sure how to set the parameter. It is because my data will be getting more and more complicated. I have to make it more tidy first.​Thank you in advanced. Zach

So I have multiple columns of data that return a yes or no value. I'm really only concerned with the yes value.  When the value in the Cut Grass attribute is 'Yes' - i want to replace the Yes with say "cut grass to 100mm"Then i have another Yes value in Remove Flammable materials column and I want to replace the Yes with "remove materials".  Is there a multiple string replacer transformer that I can use.  I need to do this for approx 13 different attributes. I have read about string replacer or attribute value mapper. But whilst string replacer can replace multiple attributes to the same replacement text it doesn't allow for differing replacement text individual to a column.

I've configured the SMTP Publisher to receive emails, but when I send them to FME Server I get undelivered responses.  I looked at the email.log for the FME Server Publishers and I see: "WARN Email received for unknown recipient [email address], so dropped  What does this mean?

Hi FME Community,I would like to reproject my file into another coordinate system. I am looking for correct coordinate system. ArcMap gives me a correct result. FME gives me wrong coordinate after the reprojector.the pictures show which coordinate systems I used in FME and ArcMap. In addition, my file belongs to Germany. Thanks a lot in advance   

I think it takes a lot of time to convert one by one.