FME Form

Hi there, I am connecting to Vicmap as a Service (VAAS), which is an ESRI ArcGIS Service Feature Service, which will allow me to bring in the state property data and push it straight into our SQL Database. This will replace a weekly download of MapInfo files which are pushed into SQL via automated procedures. The ESRI data is in Vicgrid GDA2020 (EPSG:7899) and I am trying to push it out to SQL as UTM55S GDA2020 (EPSG:7855). It doesn't matter which projection tool or coordinate system tool I use the data still outputs as Lat Long with an SRID of 7844. Is there a way I can do this? I thought perhaps I need to output to a different file format and then reproject that file and push into SQL, but I'd rather avoid an extra step if possible. Regards, Josh

Why might I be getting a 401 or 404 when creating a web connection to FME Server from FME Workbench?

I have a database table that contains many attributes, one of which is controlled by a domain of acceptable values. I have a list containing a unique list of these valueI want to step through this list and each time through the loop select just the records from the table that would be selected if the unique value were inserted into in query:SELECT * FROM Table WHERE AttribInQuestion = WhateverColorFor instance, "Red" the first time through the loop would return:I've setup my Reader to read the SQL table I want to query, generated a List of my unique values, and created a TestFilter. The TestFilter works if I just type 'Red' into it, but I cannot figure out how to feed the filter a variable to save my life. I'm not asking about the looping (I've created a custom transformer for that), what I'm asking about is how to insert the 'Red' value into my filter using a variable? Thank you for any help you can provide. K

I have a workspace where permit data is joined to GIS data through a series of joins. That data is then written into separate feature classes. The 3 datasets in order are as follows BIN Join, BBL Join, a spatial join using the Point On Area Overlayer transformer. After all of these joins happen I'm dumping any remaining unjoined records into a point feature class called Fallout Points. However all of the records from the spatial join are ending up in the Fallout Points layer. How do I exclude them (or delete them after)?

I have 1,000's of 1km asc files which are simply named 1.. 10,000 which I wish to merge in to 5km asc files, and appropriately name with the correct OS Tile Ref. I have managed to perform a spatial filter and added the OS tile ref. I now wish to filter so all 1km tiles within an identified 5km tile go forward for merging. Is there a way to automatically filter based upon the present OS tiles without creating the individual condition filters manually?  

We are trying to create geopdfs for different defined area having multiple devices , features in them. Adding labels to symbols using LabelPointReplacer Parameters and set the label scale that most of the area fits to it. But few areas are having labels that are overlapping with the symbols as shown below Is there a way to adjust the scale based on different areas.  

In some cases I like to create cumulative statistics using the StatisticsCalculator. I'm glad it's kept as a Advanced option in the StatisticsCalculator. However, it feels a bit odd that the StatisticsCalculator seems to require/expect attributes for 'Summary statistics'. I.e. if I only want to create cumulative statistics, the StatisticsCalculator shows an error (Red Cogwheel) indicating; 'Parameter 'Statistics to Calculate: ' must have a value'; Although it's possible to ignore the error and run the translation, or provide a dummy attribute to calculate regular 'summary statistics', it doesn't feel fully correct. It would be nice to also have the option to only create Cumulative Statistics. I guess that may be possible by (also) embedding the regular 'summary statistics' in a Checked ParameterGroup (and be default checked).

Hello All, I have a Tester transformer that ideally produces no Failed outputs but I want to count the number of Failed outputs, even if its zero. I've tried a few things with no results. The Failed output from the tester doesn't seem to produce any data or if it does, I don't know how to access it. Thank you,Kevin

I have one dataset that has overlapping polygons. I want to advise the data owner of this and ask guidance for what to do when I come across these overlapping areas. I think the best way to do this is to show them all the overlapping areas. I was able to add on the overlap counts to each polygon (AreaOnAreaOverlayer) which is great, but what I really want is to create a new dataset with the overlapping areas. I have had a look at the AreaOnAreaOverlayer and Clipper. Is anyone able to provide further guidance or point out if I should be using a different transformer combination?

I have two enterprise geodatabases, each with an annotation feature class (annotation version 2.x) that I need to keep synchronized. Edits are made in the feature class in the source geodatabase, and (ideally) updated nightly to the feature class in the target geodatabase, using an automated FME workbench on FME server. The annotation feature class in the target geodatabase should have all of its features truncated and replaced by the annotation features in the source geodatabase feature class. This works great for a number of other feature classes (polygon, points, etc.), and it works fine with older versions of the annotation (Desktop version), but not for this annotation version. I'm testing this out locally, using ArcGIS Pro 3.0 and FME 2022.0.0.2 (Build 22343), and regardless of how I set up my workbench, I'm not able to read and write the annotation features between these two data sources. Currently, I'm getting the following error from FME Workbench: "An error

Can anyone suggest a really good changedetector tutorial or documentation? I'm having difficulties understanding the output where a change in attributes and/or geometry is found. I can't tell which attributes changed (before and after) and I'd like to see exactly where the geometry change is instead of only seeing which features have changed. Hope that makes sense. I'm still learning.

Hi All,Workbench is returning an error message I've never seen before when trying to write some photo's to an attachment table of a versioned feature class and i'm getting the message; "Unexpected execution path. please visit http://www.safe.com/supportGeodatabaseRelationshipFeaturesPipeline::GeodatabaseRelationshipFeatures (SortFactory): A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for detailsSome error has occurred closing the pipeline factory, see previous warning" in the translation log. Any ideas where I can go from here to try and trace the troubleshooting?

Hi, I've got a 3d model made of cubes (points extruded in 3 dimensions) and would like to export it as Cesium3dTiles. I did styling with AppearanceSetter and everything is okay except the cubes consist only of 6 squares that are colorised and they are not filled in the inside. Having these solids filled is important to generate cuts through this model. Any suggestion on how to get filled cubes?Regards,Maik

I already had a look at the following link and it helped me in the right direction, however I am still stuck. I use values from the boundingbox transformer for determining whether I need a portrait or a landscape layout. See image below how I have defined it. In case the length of the xdifference is bigger than the ydifference, then I would go for a landscape layout.Then I tried several ways to define the size:1) defining the values shown above in the attribute pdf_page_size in the attributecreator transformer. 2) Create a user parameter from above and use it in the pdf writer under parameters "Page Size (points)"3 Using a TestFilter in combination with two PDFPageFormattters don't work I get the following error  PDFPageFormatter (PDFLayoutFactory): Invalid page object '<at>Value<openparen>Grootte<closeparen><space>=<space>Portrait' parameters 'MINX;-260;MINY;1152;WIDTH;255;HEIGHT;39;FIXED_ASPECT;Yes;CLIPPING_ENABLED;No'.  All point positions must be a pos

Hi, I'm trying to built a webscraper tool for italian website using CSS (NO API available) and since each website has a different structure I put the css selector in a POSTGRES table and then in the HTML extractor I use these selectors as parametersThe probelm occurs when in a website an attribute is missing eg normally I extract data_inizio and data_fine but in some case data_fine isn't present.So I suspect that the html stop if th css for a specif parameters is missing, I tried to use the conditional value butthe only possibility is stop So the question is how can tell to the HTML if the css selector in a parameter is missing proceed ? Hope the explanation is clear thx for support Francesco

I have a file with points and as an attribute I have the measurement with respect to the LRS. How to view the points on the map?

Say I have the following data;for which I can see the following information in the Feature Information window;feature 1; text (bytes): 48656C6C6Ffeature 2; text (string: UTF-8): WorldIs there a way that I can filter the features on the basis of the indicated data type (i.e. 'bytes' vs 'string (UTF-8)'?

I am trying to use the string search command to extract the file names from a text string, Path attribute. by reverse searching the path string in order to establish the location of the last sub directory i.e. \\ @FindString(@Value(Path),\\,-0,caseSensitive=TRUE) The forward search works but I can't get the reverse (right to left) to work! using a negative startIdx  

When rerunning my entire workspace, the transformers don't run one by one. They run to where all the transformers are being used at once and it takes an astronomically long time. It's faster if I run each transformer individually. Is there a setting to make each transformer run one at a time when I rerun my entire workspace?

Examples:10 > 105.1 > 5.0999999046325610.1 > 10.10000038146972720.1 > 20.10000038146972717.6 > 17.60000038146972720.3 > 20.2999992370605478.4 > 8.3999996185302735.3 > 5.30000019073486207.97 > 207.97000122070312

I'm struggling to find documentation or an article for this problem I am running into. I have a validation tool I created that checks for all sorts of different errors within a GDB. The errors that are caught are then written to ArcOnline where the data can be visualised. The validation tool handles mostly missing/null data. Once the null/missing data is found or fixed, you run the validation tool again to update the ArcOnline data. What I am trying to achieve is that the updating of the data is replaced based on a specific attribute- 'Project_ID'(PID). The ArcOnline layer could have entries for 'PID_1', & entries for 'PID_2'. If the tool is ran again and some existing errors have been remedied for 'PID_1', only those with 'PID_1' will be removed and updated, and those with 'PID_2' are left untouched. (When running the tool, the input data will never have conflicting Project IDs. So it is ran on a project to project basis.) Hopefu

Hi there I am trying to connect a reader to sharepoint to read some information in. When I press authenticate this is the error that I get. I was wondering if anyone knew how to fix this?  All the best-Ed

Hello, FME Desktop users and educators, I hope you are all doing well. Today, I'd like to discuss a pressing issue I've encountered with FME Desktop while using it alongside classroom management software for teaching and geospatial data processing. It seems that there are compatibility challenges between FME Desktop and certain classroom management platforms, and I'm eager to hear your insights and experiences on this matter. As a geospatial instructor and avid FME Desktop user, this software plays a vital role in my classes for data integration and transformation. However, since incorporating classroom management software into my teaching methods, I've come across the following issues with FME Desktop: Screen Sharing Glitches: Attempting to share the FME Desktop interface during live classes or collaborative data processing sessions often leads to screen sharing glitches and freezes. These interruptions disrupt the flow of the lesson and hinder students' ability to

I have the lakhs of electric line features in FGDB , I want to find out the line features which are overshoot and correct those . Can you please help me with the FME workspace ?

Hi, I am using a FeatureWriter to create a Geopackage. Although I set the Spatial Column name as "SHAPE" it is changed to lowercase "shape" in the output. Can I prevent this behavior somehow or is there a workaround for this (e.g. renaming the spatial column with sqlite in a PythonCaller)?