Transformers

Hi there, I have two attributes (i.e. date and a field called wastage). Wastage is numeric field. I want to calculate the Running total of field wastage. I am using statisticsCalculator. I have attached the configuration of the statisticcalculator. Date is organised w.r.t. date. The problem is that calculated running total is the same for all dates (i.e. sum of all values of wastage). I mean it just calculate sum, its not the cumulative sum. Could anyone guide me where am I making the mistake? 

I tried attribute exposer to view the material properties of building element after I export to IFC from Revit. But, after I run FME it shows missing item in material name. How can I fix it?

I have a csv file with 55 attributes for each feature, I'd like to join only relevant attributes to various shapefiles (using FeatureJoiner). For example my Farm shapefile may need only 10 of those 55 attributes, my Buildings shapefile could require 20 attributes from the csv. For each shapefile I have an excel list of required attributes. How can I read in the main csv and filter it based on the xls - so only the attributes on the xls are passed to the FeatureJoiner?Have tried Attribute Filter, importing the xls but I can't see how to filter on this?Any suggestions?ThanksChris 

Hi,I want to reproject a raster but I'm not sure which reprojector transformer to use: Reprojector or CsmapReprojector??Can someone please tell me the difference and which is better for rasters?Thank you

Hello, I have a polygon geometry in that format:[[[(6.240171999999999, 50.590275999999996), (6.239148999999999, 50.5886), (6.238637, 50.58772), (6.238766999999999, 50.587680999999996), (6.239457, 50.587494) ]]](This is only a short extraction, I have around 10000 points for one polygon)What is the easiest to build the geometry and display it in the inspector? As I have around 10 000 vertices I don't want to do a split, create a list and vertices. Is there a shorter way?

Hello,I have vector 3D (vx, vy, vz) from some triangle.How I can transform/project vector 3D to vector 2D?

I have a workspace that has a Workspacerunner transformer. I find that the 'append to logfile option' works for this workspace, but not for the workspace defined in the workspacerunner. The logfile of the workspace in the workspacerunner contains only the last run, where I hoped the logfile would contain accumulative messages from all previous runs.Am I right about this and is there a workaround?Thanx again for any response!Regards,Pim

Hi, I want to set a normal vector for a plane (surface - roof)I have 3d buildings in 3DCityDB I used transformer "Triangulator" and I calculated the area based on "TIN Surface" and it's OK, but I don't know how to set the normal on surface? 

i have a map and it has too many devices and lines and lines connected to different devices and i want to know for specific lines ,which lines connected to which device and show me the ID of this device ( i mean at end of the line or start from this line should be connected to device )i want to know exactly which device is it ? and how many lines get in and out from each device . how can i write function for this line .Thanks

Hi, I have been asked to mimic the NORM.INV formula in FME which, in Excel, calculates the inverse of the normal cumulative distribution for the specified mean and standard deviation. I have the required values for the calculation (mean, random number and standard deviation) but unable to work out how to replicate it. Quite a specific question, but any help would be very much appreciated.Thanks, John

I am trying to use a conditional statement to update an attribute if it is null with the value of another attribute . However AttributeManager does not recognise the null or empty string . it does not work if I change the output to text or @Value(CaseOfficer) either.What am I missing here? 

Hi guys,I have a long line of points that are 1 metre apart. At roughly each kilometre point there is a value, but it is not exactly 1000 metres between these points (sometime more, sometimes less). I'd like to count each of the points in sequence between the values, and then have the count reset itself to start at zero at the next value. I've tried the Counter and it will give me a zero at each row with a value but will continue the count, not resetting back to 1.Any help will be greatly appreciated.Cheers, Dave.

Hi, I tried using a counter in "group by" mode, i.e., by using a countername from an attribute. Feeding the Counter Name attribute from an attribute that has numeric value, produces an error: "Termination Message: 'Counter output a <Rejected> feature. To continue...". I want to count the records for each value in an attribute.

On FME Server I am not able to obtain a zipped output file within the data download url. In the log it does show that the file is created, but it doesn't return in the download url. So to clarify, say I create a couple of files in my workbench:1. file1.csv2. file2.zip (directly containing e.g. file1.csv)3. file3.txt When I run the workspace locally, all of the files are created and placed in the specified outputfolder. If however I publish the workspace to FME Server I obtain a download link to a zipfile that only contains file1.csv and file3.txtAny ideas on what I'm doing wrong? Or is it maybe just not possible to use the data download service in combination with zipped output files?N.b. From browsing the forum, maybe the issue is related to: https://safesoftware.cloud.answerhub.com/questions/93696/fme-datastreaming-not-returning-zip-file.html 

Hello!How can I zip shape files separately in FME server? In my FME I use FeatureWriter to do this and it works great. But when I publish my workspace to FME server it does not work anymore. I have 2 separate shape file types (points and polylines) and I want them to be zipped separately (for example point.zip and line.zip). Afterwards I want to download these zip files from FME server.

I'm basically using a set of 1) reader, 2) transformer ('PointCloudCombiner'), 3) writer for multiple input files in different folders so that I would like to automate this process by using a python script.What I'm expecting to see is something like using arcpy in ArcGIS as shown below.----------------------------import arcpyinputfile_name='111.shp'outputfile_name='222.shp'arcpy.Project(inputfile_name, outputfile_name, parameters...)----------------------------I've spent several hours for finding examples but I couldn't find one...If anyone knows how to implement this, would you please give me directions? (or related articles would be very helpful too!)

I have a workbench that has two ESRI Reprojectors that work fine when run in FME Desktop.The first ESRI Reprojector projects from NAD_1983_CSRS_Teranet_Ontario_Lambert to NAD_1983_Teranet_Ontario_Lambert and uses a custom transformation that I created using documentation from our parcel supplier (Teranet). The second ESRI Reprojector reprojects from NAD_1983_Teranet_Ontario_Lambert to NAD_1983_UTM_Zone_17 and does not require a datum transformation.I have copied the transformation file I created on my desktop pc to the server and put it in the same location:C:\\Users\\Administrator\\AppData\\Roaming\\ESRI\\Desktop10.4\\ArcToolbox\\CustomTransformationsAs well, I copied the grid shift file to C:\\Program Files (x86)\\ArcGIS\\Desktop10.4\\pedata\\ntv2\\canada as per the instructions provided by our parcel supplier (Teranet).When I upload the workbench to FME Server and attempt to run the job in FME Server it stops almost immediately with the following error EsriReprojector: Reproject: C

In my translation, the dwg writer has set the template file by using the published parameter "$(SourceDataset_ACAD)". When I run the batch deploy, it seems that the batch deploy can only recognise the first template file.The template file doesn't work in the others.Could someone help?

Hi, I don't have 3D Studio Max. I need to convert a file that is in ".max" format to obj format. I downloaded the FME software, TRIAL, but it looks like I'm doing something wrong ... FME doesn't seem to recognize a .max dragged into it. how could i solve this?

Hi there, I am writing data through excel writer. One of the attributes has got decimal numbers (such as 3.127). However, due to missing type of real32 data type, this attribute is treating as string. I tried to change it to the number but still it write as string. Any suggestions to overcome the issue.P.S. I couldnt use csv writer as few attrbutes has datatype date which I couldnt assign in csv writer.

In my FME2018,I defined some coordinate systems,and it works well.In FME2019.1.3 or FME2020 ,I use the same MyCoordSysDefs by copying the file to the relevant directory.But the reprojection failed.  My customed coordinate definition like this:It works well with FME2018.When I use it in FME2019,the log show:  Coordinate system named WGS84.TM-121SE does not exist.Coordinate system named WGS84.TM-121SE does not exist.Unknown coordinate system 'WGS84.TM-121SE' specified - abortingReprojector: Could not create reprojection engineStoring feature(s) to FME feature store file `C:\\Users\\msipc\\Desktop\\esrishape2none_log.ffs'+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `Reprojector_REPROJECTED'Attribute(string) : `Id' has value `0'Attribute(string) : `SHAPE_GEOMETRY' has value `shape_point'Attribute(string) : `fme_feature_type' has value `test'Attribute(string) : `fme_ge

When I use the EsriReprojector converter, FME can't recognize my custom Esir geographical conversion method. How can I solve this problem?

Hi,I am trying to automate pdf map production, having used FME's Cartographic Output Workspace as the starting point. I am unable to create a suitable civic address label for each parcel polygon. Most of the parcels are not perfect boxes, and are slightly rotated so I used a BoundingBoxReplacer (2D Oriented Bounding Box), Chopper, AzimuthCalculator (gets rotation of each side), LengthCalculator, Sorter (Sorts by civic address, then by segment length), Sampler (keeps longest side and the rotation), FeatureMerger (to bring the calculated rotation back to the original parcel shape. Using Labeller, LabelPointReplacer, or CenterPointReplacer and then TextAdder to create a central, upright label all fail.An example of what I need the workspace to be able to produce:Thanks!

Hi, has anyone looked at categorising streets in terms of effort to sweep? We're a UK based Local Authority looking to focus resource and want to establish streets within "blowing distance" of trees. Some sort of high, medium, low categories.We believe we could purchase / produce a tree map (IR/DTM/DSM) but does anyone have any experience of then relating that back to streets other than a simple distance to/from the street lines?Interesting to hear anything from you all. Thanks