Transformers

Hi,I created a parameter in my custom transformer of the following form:PARAMETER_NAME: LRF_FILEPARAMETER_TYPE: OPTIONAL FILE_OR_ATTR LRF(*.lrf)|*.lrfPARAMETER_PROMPT: Label Rule File:PARAMETER_DEFAULT: $(FME_MF_DIR)No matter what value I enter for the Parameter_Default, the file box on the transformer GUI always initially shows up empty in Form. Can someone suggest what I’m doing wrong?Thanks,Martin

Started this this help article which is written for V8i and not CONNECT but believe I've added the line styles to the seed. Drew lines set to the appropriate layer and the line styles are correct. Seed is in a ProjectWise workspace and exported for use with FME:Workbench clip:DGN Styler configuration:DGN writer:

Hello, the workspace is close to “Creating CityGML Solitary Vegetation Object | Community” but without the issues. I would like to randomly rotate the instances along the Z axis. Dimensions are set as in the first matrix shown below. When I use the last row to rotate, as shown in the second matrix below, the rotation is ignored and dimensions change. I tried the rotators, and the 3D affiner after defining the matrix to no good results. It seems that CityGML only looks at the transformation matrix.  Any advise or workaround to force instance’s rotation is appreciated. I have a random rotation value stored in an attribute brought as an attribute of the location point. +++++ Matrix withOUT rotation +++++++++++@Value(width) 0.0 0.0 0.00.0 @Value(width2) 0.0 0.00.0 0.0 @Value(height) 0.0

Hello, new to FME here and am looking for some advice on which transformers might work for a workbench that I am trying to create. I have 2 road line feature classes stored in an SDE geodatabase. The lines store similar information but are created and maintained by two different departments (they have different road name standards and the geometry does not match). I would like to compare the lines and identify which ones from Roads_A are missing from Roads_B.  My main concern at this point is identifying missing subdivisions like the one in the screen capture below. 

I’m trying to use the FeatureReader to read 3 features from an ArcGIS portal feature service layer by reading in a spreadsheet and using a WHERE clause with an attribute in the spreadsheet. The FeatureReader will connect to the service and I can select the correct table in the “Feature Types to Read” parameter. But when I try to add the WHERE clause FME crashes before I can start creating the WHERE clause. The second image below indicated the point when it crashes.I can read the full table with no problem using the ArcGIS Portal Feature Service reader. How can I get the FeatureReader to run and read the required features?  

Hallo , How to Color the first column  at table in PDF ?I used the PDFPageFormatter but  I faced a problem that i want to color the first column at table in  PDF output, which contains the attribute names,that i have created a table by pdf page formatterCould someone advise me on how to color the first column? FME 2021

Hello,I’m converting DWG to DWG using FME and I’m wondering if it’s possible to style the XREF data within the DWG. Specifically, I’d like to set it to True Colors with certain grey values.Any guidance on how to achieve this would be greatly appreciated.Thank you in advance!

I was hoping someone who understands how FeatureHolder works can let me know if I can use it successfully to help with an issue I am having. I have some workspaces on flow that had been working as expected for well over a year but recently I have had two separate ones glitch on me in the span of a few weeks.I am not 100% sure what went wrong but from looking at the log, the portal feature service reader did not read in all of the records from the table. Looking through the log, I see a line that indicates the metadata fme is accessing lists the correct number of records in the table. However, the summary shows that for that run, it actually read in less than that number.I have not yet identified what caused the reader to behave this way in these two instances. My question is:If I put a feature holder right after the reader, will that solve this problem? Will it make the workspace wait until all of the records are read in? (i.e. the nu

I have a transformer that pulls data and returns something like this:All values in the _count column should be the same.  How would I go about determining if there is more than one unique value?  

I’m using an HTTPCaller to applyEdits using ESRI’s REST API. It includes sending along some JSON to add to a table in a feature service. The workspace runs successfully testing with 1 or 2 records in the JSON parameter, which is all sent with a single HTTP call, but fails when testing with 10 records. It looks like FME is truncating the HTTP string, which causes the request to fail. That’s what it looks like in the FME log anyway; the query string appears on two lines (see attached screenshot). If I try applyEdits in a web browser at the REST endpoint and paste the JSON in manually, I can add the data without issue. Is there a parameter or formatting change I need to make to keep FME from truncating the HTTP call? (FME Desktop/Form 2023.2.2.0, build 23764)

ArcSDE Writer is very slow, taking 1 hour to write approx 60000 records. The operations is set as UPDATE and the feature classes has index on the matching column. How do I improve the speed? The Simplify geometry and validate spatial index options are set as NO 

I might be missing something really obvious, but is the version of the package installed displayed anywhere?I expected it to be listed here, but that’s displaying the latest package not what is installed

I have a folder of old aerial imagery tiles with .txg georeference file. Inside .txg file, there are coordinates of the four corner. I can manually copy those corner coordinates into the RasterGeoreferencer transformer, but is there any way to automate this process and mosaic all tiles into one raster?

 This is the source table. The verblijfsbagid is a unique number of a building. Where the colum leegstand = J, i want a value in the colum leegstaand_maanden. The first empty row is 1 then 2 then 3 etc. I used diffrent transformers, like neigborfinder but it didnt work.Here under is the output that i want to see (red numbers):  

Hi, We would like to be able to calculate the real world footprint of drone images to result as a trapezoid polygon. This should be possible with only the exifdata that we get from the custom transformer "exifReader" as far as I can tell.  I found a python version here, but it requires additional installation of vector3d from the python script. Anyone got a solution to calculate drone image footprints?https://gist.github.com/luipir/dc33864b53cf6634f9cdd2bce712d3d9 The custom transformer FootprintCreator promises something similar but requires a CSV-file from the camera. Anyone got a suggestion/solution? It would be a neat transformer that I think a lot of people would benefit from. We have a couple of different DJI drones.

I used the FeatureReader to read all feature classes in a file geodatabase and dynamically update the same feature classes in a different geodatabase. Some of the feature classes use attribute domains with code values different than the descriptions. This causes failures in the update. For example, a feature class has an attribute Country defined as integer, and its domain Description is country names (text). Behaving like ArcGIS, the FeatureReader reads the Description text values and write to the destination feature class, which has the same Country defined as integer. The data type mismatch between the FeatureReader output and the destination caused the update to fail. As it is very typical in ArcGIS for a domain to have different code and descriptions values and therefore I would think FME should have been able to handle this gracefully, but I don’t see a workaround option with the FeatureReader. I am at FME Form 2022.2.2. I hope I don’t have to use those Customers or Hub GDB Do

I have a RUN_DATE field in a File Geodatabase Feature Class Attribute Table. In this field is the current date (today’s date). I want to use a Tester after the DateTimeConverter Transformer to select only the values in the RUN_DATE field that are today’s date. I have tried this and get no passes, all failed. Is there a specific date format that needs to be used for the @DateTimeNow() function?Here are the parameters in the Tester (that is immediately after the DateTimeConverter Transformer:  Here are the parameters in the DateTimeConverter Transformer:   Here are the values in the attribute table (after the DateTimeConverter Transformer has been r

How to get to the bottom of this error message?An error occurred while attempting to create an Esri Spatial Reference from an OGC Definition for the feature feature class 'wildlife_key_areas'. The error number from ArcObjects is: '-2147024809'. The error message from ArcObjects is: {The specified WKID (factory code) or WKT (definition string) is not a Projected Coordinate System.}GEODATABASE_SDE writer: An error has occurred. Check the logfile above for detailsThe Feature Information inspector on the incoming data stream says the item has a coordinate system and is happy to display it. The OGC WKT from that dialog is:PROJCS["NAD83 / Yukon Albers", GEOGCS["NAD83", DATUM["North_American_Datum_1983", SPHEROID["GRS 1980",6378137,298.257222101, AUTHORITY["EPSG","7019"]], AUTHORITY["EPSG","6269"]], PRIMEM["Greenwi

I am trying to both add and update Equipment to CityWorks using the HTTPCaller - it seems to work fine except for custom fields.  They do not seem to add or update with the equipment record. I am passing in the “Data” query string parameter with the following json data:{"EquipmentUid":"@Value(EQUIPMENTUID)","Description": "@Value(DESCRIPTION)","Manufacturer": "@Value(MAKE)","Model": "@Value(MODEL)","ForCheckout": "@Value(FORCHECKOUT)","RateType": "@Value(RATETYPE)","UnitCost": "@Value(HOURLY_RATE)", "CustomFields":     {      "FieldName": "DIVISION CATEGORY",      "FieldValue": "@Value(DEPT_ID_DESC)"    } } This does not work but is what I could gather from the internet as correct (for the custom fields)

Hello,I have encountered some issues with a workspace that I have not seen addressed previously in the forum. The issue concerns exporting to an SQL server database where the file format is interpreted as GeometryCollection when it is essentially only MultiPolygon at most.This is what my workflow has looked like. I have a workspace that retrieves line segments from an SQL server, which are then combined and the attributes processed. These lines are generalized and buffered to form areas. I then use Dissolver to merge overlapping areas with a Group By function based on a common ID (the field INSATSNR in my screenshot). However, there are several areas with the same ID that are located in different geographical locations and do not overlap. Therefore, I use an Aggregator with a Group By function on the same ID. This ensures that areas with the same ID are collected in one field in the attribute table—exactly as I want it.However, when I want to expor

Here is my code: import mathimport fmeobjectsFEET_PER_M = 3.28084TURN_THRESH_DEG = 5.0  # minimum angle to count as a turndef haversine_m(lat1, lon1, lat2, lon2):    """Great-circle distance in meters."""    R = 6371000.0    phi1, phi2 = math.radians(lat1), math.radians(lat2)    dphi = math.radians(lat2 - lat1)    dl = math.radians(lon2 - lon1)    a = math.sin(dphi/2)**2 + math.cos(phi1)*math.cos(phi2)*math.sin(dl/2)**2    c = 2 * math.atan2(math.sqrt(a), math.sqrt(1-a))    return R * cdef bearing_deg(lat1, lon1, lat2, lon2):    """Bearing from (lat1, lon1) to (lat2, lon2) in degrees 0-360."""    phi1, phi2 = math.radians(lat1), math.radians(lat2)    dl = math.radians(lon2 - lon1)    y = math.sin(dl) * math.cos(phi2)    x = math.cos(phi1) * math.sin(phi2) - math.sin(phi1) * math.cos(phi2) * math.cos(dl)    brng = math.degrees(math.atan2(y, x))    re

Is there a resource/database somewhere that has a list of what FME release each version of a transformer was initially released/updated in? You can get it pretty easily for transformers on the Hub, but not for inbuilt transformers.I’ve had a dig through the various Python APIs and I haven’t come across anything (doesn’t mean something doesn’t exist mind you!).Each version of FME does come with the previous versions of the transformer, otherwise this would break the backwards compatibility of the software.

I have an excel file with 100 records (100 rows) with 5 columns. I have a process that will filter one record to update one column field called ‘Last Update’ in that particular record row. So The column ‘Last Update’ for that 1 record should be updated and the rest of the 99 records will remain the same. Keep in mind that the one record being updated, only one column is to be updated which is the Last Update column and the rest of the columns fields will remain the same.  How can I configure the FeatureWriter?I currently have the following set in the FeatureWriter Parameters and in the configuration but this does nothing. The excel sheet  looks the same as before with all 100 records the same and the one record that Im looking to update does not have the Last Update column updated. 

Hi all,I’ve successfully solved one issue of enumerating points along the lines (to define flow direction) using this post - Line to connect in order. | Community. Is it possible to enumerate segments of the line the same way using enumeration of points?

I'm getting a weird error at the very end of the log (after Translation was SUCCESSFUL) The dataset is LL-GDA2020 but at the end I get this, even after adding in a reprojector just in case and setting it to reproject from source to LL-GDA2020: +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `'Attribute(string: windows-1252): `fme_geometry' has value `fme_point'Attribute(string: windows-1252): `fme_type' has value `fme_point'Coordinate System: `_LL-WGS84_0'Geometry Type: IFMEPointCoordinate Dimension: 3(148.19125855756474,-32.732898266064595,0)===========================================================================Unknown coordinate system '_LL-WGS84_0' specified - aborting+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `'Attribute(string: windows-1252): `fme_geome