Transformers

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 

Hi,  I am looking for advice how to turn a JSON file into a JSON LD (linked data) with FME.This is an example of a JSON LD formathttps://json-ld.org/spec/latest/json-ld-framing/#example-3-flattened-library-objects There are 2 parts:1) @context: where you place the link to the complete vocabulary of the model2) @graph: where the features are written.How can I introduce these 2 parts when writing JSON in FME?Jasper

I am trying to figure out how to create map tiles along a route where the tiles have a certain amount of overlap, something similar to strip map index but not with rotating map view.   

Hi there, I am calculating four attributes related to date using attribute creator and then I use Datefromatter to convert those attributes into the desired format (i.e. %y%m%d). When I write those attributes into CSV file, I found that the cell format of those attributes is still 'General'. It didn't change to the date format. Could anyone guide me on how to fix the issue?

I have a simple workspace that converts shapefile contours to CAD (dwg). When I create this workspace I specify which I field from my shapefile will be used to make it 3D (using the 3D forcer) and also which field I will use to define the Layers in the CAD file. These fields will be the same. I'm converting my workspace to a template so my non GIS/FME guys can do the conversions themselves. I have my input and output parameters created but I'm not sure how to create a parameter where a user can specify the field from the shapefile. Can something like this be done in FME?Here is my workspace:I'd like the user to be able to select the field from a drop down when they hit run:

I am trying to export data from SQL to CMDM Geodatabase. 200 values got truncated. I changed some of the attribute widths in CMDM, and truncated values decreased to 4. Instead of trying to check each attribute manually, is there any way to find these values directly?

I want use cyan Circle clipper Pipeline diagram?but I want to keep red section,how Ishoud do?

How create dim like this ? Can provide detailed steps?

Hi there,I am calculating the current and previous regulatory start and end years dates. For instance, the regulatory year starts from first May of every year and ends on the last day of April next year. So for the current year regulatory year period would be from 1-05-2019 to 30-04-2020. For the previous year, it would be 1-05-2018 to 30-04-2019. I am using following code to calculate the start and end of the year:Current Year Start : @DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-P8M),%B %Y)Current Year End: @DateTimeFormat(@DateTimeAdd(@DateTimeNow(),P3M),%B %Y)Previous Year Start: @DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-P20M),%B %Y)Previous Year End: @DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-P9M),%B %Y) With the above code, the day is missing. If I use %d, it starts the day with reference to the current day. I don't know how to get the end or start day of the calculated months. So I decided to concatenate the hardcoded day with the above calculated months. The problem I a

Hi, I have been trying to figure out how to correct reproject from UTM to Ground. I have many datasets in an SDE environment (WKID: 26910) that I want to convert to Autocad DWG format so the engineers can use the data without shifting to local reference points.Dataset Coordinate System:NAD_1983_UTM_Zone_10N WKID: 26910 Authority: EPSGProjection: Transverse_Mercator False_Easting: 500000.0 False_Northing: 0.0 Central_Meridian: -123.0 Scale_Factor: 0.9996 Latitude_Of_Origin: 0.0 Linear Unit: Meter (1.0)We have a trimble unit that GPS's in Ground with the following Projection settings:Zone Parameters:Zone Record: 10 North Zone Type: Transverse Mercator Origin Lat: 0 00'00.000" N Origin Lng: 123 00'00.00 W Origin North: 0.00 Origin East: 500,000.000 Origin Scale 0.9996000Project Azimuth: North Azimuth Coordinate Direction: North East  Datum Parameters: Datum Name: Nad 1983 (Canada) Translation X: 0.000m Translation Y: 0.000m Translation Z: 0.000m  Ellipse Parameters: Ellip

Hello  I am looking for a way to remove zeroes from some attributes, but not all.  1) I have sliced up a string using the "AttributeSplitter" with delimiter "3s4s" 2) original data is 1234567  ->  two new lists (list1: 123 & list2: 4567). 3) Sometimes list2 have 0 as the first character. I am looking for a way to delete this 0 without deleting values with four characters.  Regards, Stig

So I'm usually fairly aggressive in large workspaces in keeping the in-workspace Schema tidy and as small as possible after running data through various Transformers that all like to add their own default Attributes and Lists etc.This trimming of the Attributes and Lists at mid-points through the Workspace is under the belief the passing features with unnecessary attributes and lists that are no longer required through the Workspace would cause overall significant performance penalties. This makes something like AttributeKeeper a very common Transformer in my large or data heavy projects.However, I find that using AttributeKeeper, AttributeManager and AttributeRemover all have their own overheads to run, and you could slow your Workspace down by using them too often (well so I believe anyway!) The question is: When and how often should you use these in large projects/workspaces? Is there a best practice in FME for getting a balance on these?

From the attribute above containing newlines, I'm trying to extract each line of coordinates into a list using a StringSearcher with regex: \\n.+°.+°.+\\nI don't want lines of text to be included in the list that are not coordinates, so the first line starting with "Buoy" would not be captured. It should also be noted that the lines that are not coordinates may contain a '°' symbol, such as "Range line at 186°". Because of this, my methodology consisted of matching any set of characters containing 2 '°' symbols that fall between two newlines.My example regex seems to close, but it is also capturing the first 2 numbers of the next string. How would I need to format my regex to avoid this?