Best Answers

Hi FME community.I have a simple task to change Japanese field names in a shapefile to English field names. So I was using SchemaMapper to do this task. I created a simple csv file which has two columns, old_name and new_name. Then, I used this csv file in the ShemaMapper. I save the resulted layer as a shapefile. But the shapefile I crated had the exactly same field names as original one. All Japanese field names...I realized that when I inspect the output with the Inspector, I can see that SchemaMapper actually changed attribute names. Please see an image below.However, it did't reflect these changes when I save this result as a shapefile. Can someone tell me what I am doing wrong??Thank you in advance.Hiroo

I want to add an image to a Word file. The image has to show a map with road names, house numbers and reserved areas.The map I get from a WMS service. The road names, house numbers and reserved areas I read from our PostGIS database as vector features.I use the "TextAdder" transformer to change the road names and house numbers from vector features to text and use the "VectorOnRasterOverlayer" transformer to create the raster image to use in the MSWordStyler. And I use the "FeatureColorSetter" to set the color of the reserved areas.It works well with the map and the reserved areas - but the road names and the house numbers isn't shown in the map.How do I change the text to raster ?

Hi everyone. I'm researching on how to convert an autocad file drawing to geotiff and found this software but I do not know how does it work. Could anyone help me the basic on how to convert autocad to geotiff?

Dear FME community.I've to generate a complex line with a points listing. Complew why ? Because the line is a composite of lines and curves. The information of the geometric type is in point's attributes like that :I only tried with the LineBuilder but I don't know how to do with the curves objects.Thank you for your help.

I want to redefine raster band values, based on another raster band value.More specific: If raster band 3 has a value "0", raster bands 0, 1 and 2 should have a value "nodata".How can this be done most efficiently?

Hi, I am currently trying to convert a WFS into an ESRI shapefile and other ESRI formats using FME. I am adding the WFS as a reader and the output as the ESRI shapefile. The process runs with 0 Errors however 4 warnings: "Coordinate (approx) 9E:49N outside grid file coverage; no transformation applied.Coordinate (approx) 3E:49N outside grid file coverage; no transformation applied.Coordinate (approx) 3E:61N outside grid file coverage; no transformation applied.Coordinate (approx) 9E:61N outside grid file coverage; no transformation applied."The transaction is successful however 0 features are read and 0 features are written. Any help on how to fix this would be great!Thanks

When migrating from 2016 to 2018 I noticed that the folder Templates no longer exists when using a Shared FME Folder (FME Options, Default Path). There is a new folder Workspaces but it isn’t used for templates. Where do I store our company templates on a shared location so they will be visible when creating a new workspace?

Hi,I'm setting up an attribute containing a list of files, and then I want to use it as input Dataset in a FeatureReader.e.g. the attribute contains the string: "C:\\a.jpg","C:\\b.jpg"The featureReade will reject the attribute as input DatasetIf I hardcode the same string in the FeatureReader Dataset field it works fine.I also tried to use a workspace runner to convert the attribute to a Published Parameter as input for a reader, but the same problem appears. Can anyone help me out?

I'm using the following flow and getting two different results:The flow uses a cutting line and gives back the original (un)cut results. The polygon for this example is:POLYGON((145055.748 479705.959,145059.802 479704.301,145060.003 479704.791,145061.669 479704.11,145061.468 479703.619,145079.166 479696.383,145084.101 479708.452,145066.422 479715.682,145066.222 479715.191,145064.556 479715.872,145064.756 479716.363,145047.05 479723.604,145046.285 479721.734,145043.203 479722.994,145042.471 479721.338,145039.139 479722.701,145038.458 479721.035,145035.116 479722.401,145034.481 479720.846,145014.358 479729.074,145012.216 479723.836,145013.891 479723.15,145012.653 479720.124,145008.46 479721.838,145002.488 479719.333,144994.651 479700.17,144989.025 479702.474,144968.486 479652.247,144971.54 479650.998,145020.56 479630.952,145021.696 479633.729,145039.976 479626.254,145038.841 479623.477,145046.477 479620.354,145072.687 479684.501,145050.657 479693.509,145052.257 479697.422,145055.748 4797

The new DatetimeConverter works well for the gtfs stop times which are stored as only a time string field. But it rejects (naturally) any times greater or equal to 24:00:00. The gtfs convention is to roll over midnight for bus routes that do not finish before midnight. How might that be handled?I am trying to calculate the total time of a route using Arrival_Time - Departure_Time. I cannot just replace the 24 with 00 because I have to add up two intervals. I can see a clumsy three part conversion. There are 1.4M records so elegance and speed would be welcome.

I've got thousands of thin polygon and their centreline. And I can calculate average width of each by using polygon area divide centreline length. I want to generate some random width number based on the average width and the numbers are between max and min width of the polygon.My first thought is to create points along the centreline with small interval like 1 meter, and create station lines based on the points. Then use polygon to clip these station lines, the shortest and longest length of station lines will be the max and min range. So I can generate random width numbers in excel.I've already got the interval points by using @takashi 's LineDivider, and some articles about calculate line angle and create bearing line. I just want to know if there's an easier way to do so, and only in FME. To get my thought work, I have to switch between FME and ArcGIS, and also some third party add-on in ArcGIS. It is too complicated for others to use it.

I have data that was imported into PostGis and now I am exporting back to the DWG but I am not able to resubmit the texts. If you use the TextAdder it only exports the text, even though the parameters are KEEP for geometries. Can you help me?

When running the FME Server Installer on a CentOS system that is offline, the installer aborts with errors similar to the following:No matching distribution found for numpy No matching distribution found for matplotlib scriptlet failed, exit status 1

How to write data in Postgis with the same color as DWG, after recording in postgis the recorded data comes out with the same color.

I have a set of grouped features and want to identify the feature with the highest value in one of the columns, lets call it "MAX_attribute", for each group. I can find the highest value in each group by using the StatisticCalculator. But that only gives me the "MAX_attribute" for the group as an whole, I also need to identify and "tag" the actual feature that had the "MAX_attribute".To give you an example: I have depth readings for a number of lakes, and now I want to find the deapest reading for each lake.I also tried the Aggregator with the ListRangeExtractor but could not make it work as I wished.

Hi there,I'm completely baffled about how the "Apply to: Cell" function works in the ExcelStyler transformer.The explanation of how this works (at least to my untrained eye) seems pretty confusing:"Specifies which cells will be styled. This option allows selection of attributes, which correspond to columns in Excel, to style for each incoming feature, which each correspond to a row in Excel. The result is that the intersection of the columns and the rows are the cells that will be styled. Note that this can only be set when applying formatting to cells." I don't want to involve any attributes into the equation, but instead just want to always style "C7" in a specific way, for example. Is there any way I can do this? I have several cells to style individually, but how to set up these attributes to represent the rows and columns (I guess?) is blurry to me. There will be no dynamic values or anything, "C7" will be styled in one way and alway

Hi FME community.I am trying to color my 3D object based on its fme_color attribute but I don't know how to do it.Currently fme_color is set as cyan. So, if I can how this as 2D in the Inspector, it shows as cyan. However, if I switch to 3D, it becomes gray. I think this is a default color. I looked at the Front Appearance Reference and this setting is set as <inherited_or_default_appearance>.If I can set the Front Appearance Reference as same as fme_color, then this 3D object will be cyan color. I used AppearanceSetter to manually set the Front Appearance Reference but I don't know how to change it with transformers.If someone who knows how to do it, please share your knowledge.Thank you in advance.Hiroo

Hi,I am new to the appearance setter and while I having no trouble applying a colour using the appearancesetter, I am having trouble applying a texture. Can someone please me show me how?Attached is a FFS file with 9 roof geometries and 9 images, both having a _count attribute that references them to one another.Thanks is advance,Todd 

Hi,I have a workspace with an Reader (SDE Connection) writing to multiple different zipped folders before a FileCopy Writer inserts a common disclaimer into each zipped folder. I want to use the FileCopy FeatureWriter due to the output port would then allow me to connect to a S3Uploader transformer and simplify my workspace down from 2 to 1.I however receive a error of: Cannot have multiple factories with the same name. Multiple factories were assigned the name 'filecopy_FeatureWriter-FileCopy_d4291b7d_cbed_4650_990f_3e25feda4a160'Am I missing some parameter setting or is there some workaround using the FileCopy Reader that allows processing after the disclaimer insertion?

Hello, I am creating a workspace that will export photo (.jpg) and video (.mov) attachments from a FGDB. The FGDB contains a related table holding the attachments in blob format. Per the suggestion found here https://knowledge.safe.com/questions/58775/exporting-geodatabase-attachments-to-jpeg.html , I was able to use a FeatureMerger, RasterReplacer, and a JPEG Writer to successfully pull the photos out. I have isolated the "video attachment" records after merging the data with the related table via a Tester, but I am unsure how to proceed. Is it possible to write .mov or other video files from FME? I have not seen a writer for video formats (similar to the JPEG writer used to write the photos to file). Thanks!

Folks, This should be simple but I'm just not finding the answer.Using an AttributeManager I want to add a value "0.09" to all the existing values in a column of data from a Mapinfo table during translation amongst other things.The Column is "Average" and is a defined Decimal type field.The syntax I'm using is clearly wrong.@Value(Average)+0.09 returns -9999.00 for all values.What am I doing wrong?Thanks in advanceAndrew

Hello,I am new and just starting out using FME. I have several .LAZ files and I need to get the coordinates and elevation out and into a .CSV file. I have tried to use the LAS reader >>> Point Cloud Coercer >>> CSV writer. All I get is a file filled with commas. Can someone walk me through what I need to do to get the x,y, and z data?Thanks

I am trying to calculate NDVI with a RasterBandSeparator, Test Filters and NDVI Calculator. Prior to running the RasterBandSeparator I am also using the RasterMosaicker and RasterTiler since I want to remove the overlapping edge effects of the imagery. I have added an image of the workbench so you can see where the error occurs. Looks like it's occurring once data for the next tile is being passed to the NDVI calculator. Any help in debugging his would be appreciated. I could re-tile the imagery first I suppose but then I'm reading the source data multiple times. t

I have a deaggregator transformer in a custom transformer loop. When I run the workspace, the deaggregator holds on to all features until each row has gone through the loop. I am wanting one row to pass through the entire custom loop transformer, all the way, before the next row entering.

I have two files a csv file and an Excel file with 4 worksheets, I need to compare the two files to see if all records in the Excel file with all sheets are present in the csv file, there is a particular column in the Excel file, it is a string e.g. 'ff_abcd_12345', I need to get everything apart from the numbers from this and compare it to a field in the other file. There are thousands of records which need to be compared, all I need to do is check if the record exists and report it as matched or unmatched. Any ideas on how I deal with this will be much appreciated.