FME Form

Hi guys i just need to find a way to identify the areas on a dataset which is not covered by each of the field values from another dataset..  I also need this inspection to be done by one of the fields. e.g. my input layer A needs to get scanned through to find out areas not covered by Layer B. but on layer B there is a field and each field value will need to be scanned separately and identified at the output.. Im trying clipper - outside - group by attribute but doesnt seem can give me the output i need.. Thanks!

I've 6 SQL statements in SQL executor. I'm trying to execute these 6 statements only when name_<1-6> value exists. If any of this value is NULL or missing, then that corresponding SQL statement needs to be skipped to avoid error. insert into demo.lu_test values (@Value(id), '@Value(name_1)', 1);insert into demo.lu_test values (@Value(id), '@Value(name_2)', 2);insert into demo.lu_test values (@Value(id), '@Value(name_3)', 3);insert into demo.lu_test values (@Value(id), '@Value(name_4)', 4);insert into demo.lu_test values (@Value(id), '@Value(name_5)', 5);insert into demo.lu_test values (@Value(id), '@Value(name_6)', 6);  @david_r​ Please suggest. Thanks!

Our customer has data located in Romania, and has provided a proj string that includes non default correction and datum shift grids. I have tried to install these in FME Form (2021.2.4), yet the workbench complains it cannot locate the grid file (“PROJ: proj_create: Error -38 (failed to load datum shift file): hgridshift: could not find required grid(s).”). I have found some links in the docs (also related to install this in FME Flow), however I'm not yet able to run this transformation in my local FME Form.  Any help is appreciated. For reference, I have included the example proj string, grids, test data and workbench. Run it with the following parameters:

I'm using the feature caching Run option.I'm reading a postgresql table (no geometry) not a postGIS table. Unfortunately it is rather lengthy. For each record, I'm getting Adding to Spatial Index (paraphrasing) and after the last record a rather long pause before the processing progresses.This might be fine for small record sizes but it is crippling for larger ones.The bottom line is shouldn't there be no spatial index created as long as the reader has no geometry in any case - feature caching or not?Here are my details:Edition: FME Database Edition (node locked-crc) Version: FME(R) 2019.1.0.0 (20190704 - Build 19604 - WIN64) Locale: en_US Codepage: 1252 (ANSI - Latin I) Registration Key: 1-542-353-546 Customer Number:  Home Folder: C:\\Program Files\\FME\\Beta\\ Operating System: Microsoft Windows 10 64-bit (Build 17763) Thanks for any assistance or bug fixing.

I wanna be able to define a global python function (perhaps in the startup scirpt?) like this:def dosomething(number)new_number = number + ... doing something with itreturn new_number then, en would like to reuse this global function many times at different moment in my workspace on many different attributes that has to go through the same treatment. During the workflow of data_a, I'd call a pythoncaller this way:newNumber = dosomething(feature.getAttribute('num_1'))feature.setAttribute('num_1',newNumber)newNumber = dosomething(feature.getAttribute('num_2'))feature.setAttribute('num_2',newNumber) During the workflow of data_b, I'd call a pythoncaller this way too:newNumber = dosomething(feature.getAttribute('num_a'))feature.setAttrivute('num_a',newNumber)newNumber = dosomething(feature.getAttribute('num_b'))feature.setAttrivute('num_b',newNumber) I tried the same using a pythonCaller inside a customTransformer, but

HI all, does someone have (or has someone had experience with this):JPEG reader: `C:\\Users\\USER1\\AppData\\Local\\Temp\\wbrun_1699971545629_16788\\fmetmp_4\\ImageFetcher1699971789428_20972' exists but could not be opened. File contents may be invalid, or the file format may not be supportedJPEG reader: Failed to open the dataset 'C:\\Users\\USER1\\AppData\\Local\\Temp\\wbrun_1699971545629_16788\\fmetmp_4\\ImageFetcher1699971789428_20972'. Please ensure source data is valid and correct reader is selected.The funny thing is I never had an issue with that and it was working perfectly.Any ideas?

Hi All, This post is primarily seeking guidance, or advice rather than answering a definite question. I am trying to figure out the best method to automate 2D files into 3D buildings and load them into an SDE database buildings table. Though possibly also receiving 3D files from said developers.  These files would be received by planning from developers and planning would share them with GIS (me). Would an FME App work better? Can it be dynamic and recognize all sorts of 2d or 3d files? Do I need a separate FME app for each file type? I created a PDF document that I want to share to my planning team so that developers can abide to for my future automated process. from my understanding, it should work, but I've noticed the tutorials (that use CAD) have an accompanying CSV with the building info. This has casted doubt on how i envisioned on using FME. I am very open to criticism as I am very green with FME still.   

Hi, I have a CAD file with 1000 polygon, 500 out 1000 are shifted 0.2m. I want to keep only 500 regardless of the shifting. please advice. thanks

I have a long workflow that transforms some DWG (for buildings), GeoTIFF (for terrain) and FBX (for trees) in 3D datasets (IFC, OBJ, FBX, glTF). The whole process takes a bit more than a day because it's on a quite huge input dataset. The output is fanned out based on a 500m x 500m grid.When I was testing my workflow on a smaller dataset, it worked fine on the four different file formats. Now that I tested it on a bigger dataset, it only works on the file based datasets (IFC and OBJ). The workflow is still able to write the first part (terrain) in the folder based datasets (FBX and glTF), but as soon as it starts writing the buildings in the all ready created fanned out folders, I get an Access Denied (that I didn't get when I was working on smaller datasets).Does anybody have any idea why ?

We have a custom python package project sitting in an azure repo, with build pipelines. This python package can be built on multiple python versions 3.8, 3.9, 3.10 with the help of the Hatch third party package. One of the pipelines produces an .whl artifact for the project, can this be used to install the python package locally on any machine, and simply point FME to this package? I don't really know all the intricacies associated with this approach, if it is possible can you please take me through the steps to achieve this or point me in the direction of a detailed article, any help will be appreciated

BonjourQuelqu’un peut-il m’aider à convertir en ecw ou jp2 le tif joint sur ce message.Je veux préserver la transparence.Dans l’ensemble, la transparence de mon test n’est pas préservée. RenommerRésultat.jpg en Résultat.jp2 pour voir le probleme (ouvert avec gqis 3.22)

The workbench I am putting together contains a feature reader to a dynamic write in several locations.  The workbench itself detects shape files in a folder location, validates projection, geometry and AssetID attributes. Then writes out any identified errors to a shape file for upload in another step.The dynamic write of the "errors" shape file works however the dynamic write of the upload file encounters a warning where the below appears in the log: Cannot define schema for '@Value(ENCODED,fme_feature_type)' as the feature does not contain schema information. While we have the schema mismatch the remainder arrive correctly.The features arrive with the new layer name that I want to use. Testing my workbench I have found that the dynamic writer performs as expected (and outputs the shape file) for every stage up to exposing the fme_feature_type, mapping the new layer name and setting the dynamic reader to the new layer name.I have tested this in the latest version (20

Hello, I am trying to create a folder with a prefix of Run_ and have the current datetime as the folder name. I am very new to FME and I am not sure what I am doing wrong with the setup that nothings gets created in the path I have as destination (screenshot below). I appreciate any help.

I have some FME translation files (4 or 5 of them) that I use regularly on different datasets. These have worked without issue for some time, and are still working now except for one strange thing that's changed. The process runs, ends with "Translation was Successful" in the log as normal, then about 5 seconds later "Translation Failed" appears in red.  As far as I can tell everything has worked fine, there are no errors in the rest of the log (usually if it fails I get good detailed error messages to help me fix my data problem). I think my data is good to go. But I'm not sure why I'm getting this delayed "Translation Failed" message in the log. One of the blue warning type messages (so not an error) says that my ArcGIS Pro v3.2 isn't supported, but this isn't shown as an error and my data appears to be translating fine. I think this ArcGIS Pro update is the only recent change that might affect FME though, so is that the culprit? 

Hi there, We have a workbench that takes as input a KML file, processes it and outputs a zip file.  After testing, this workbench has been uploaded to FME Server, and has data download capabilities. We want this workbench process to be run via python, with the inputs of the workbench  defined by the user.  We are using Python to upload the user file to the Data folder (FME_SHAREDRESOURCE_DATA)import requestsfolderConnectionURL = "https://xxx/fmerest/v3/resources/connections/FME_SHAREDRESOURCE_DATA/filesys/pvDesign?createDirectories=false&overwrite=true" uploadedFile = "zzz.kml"os.rename(outKMZFileClipped, os.path.join(os.path.dirname(outKMZFileClipped), uploadedFile))outFile = os.path.join(os.path.dirname(outKMZFileClipped), uploadedFile) headers = {'Authorization':'fmetoken token=token','Content-Disposition': f'attachment;filename={uploadedFile}','Accept': 'applicaton/json',                    }    with open(outFile, 'rb') as kmlFile:files= {'file':(outFile, kmlFile, 'application/

I have a work bench that transforms data from multiple sources and then inserts only the new records from the combined data into a table using a merge transformer and Feature Writer. For auditing purposes I need to log how many records were written to a table in the same Database as well as pass that info back to FME Server to include in a email via automations. I am able to do this currently with the summary output of the Feature writer, however I would also like to pass the count of the existing records and also set the total written to 0 rather than the undefined that gets returned when there is no new records to add. I've tried using counters but either I'm using them incorrectly or I'm missing some steps as the flow doesn't continue down the path when there are no new records.  

HelloI want to create a point in the middle of each line in my file. Each of these lines is made up of only 2 vertices. Can you guide me to achieve this. Thanks in advance

Here i have some Lines extracted from DWG and thought i set them to the correct projection. all seem right except for one file that is way off "Asbuilt - Sewer Existing" I noticed that the autocad_origion x,y are the correct extents but the geometry have different xy coordinates. any ideas on how to set this correctly would be appreciated. Many Thanks! 

I'm looking for some advice to get me started on creating a workflow. I'm an intermediate FME user but this problem has got me stumped! I'm dealing with roughly 100 areas that require tree planting. Each planting area will be a different size depending on the environment. Once each area is planted, we need to monitor 20% of the area to determine the success rate. The monitoring plots are 10 x 10 metres, so area of 100 sqm. The plots need to be placed at random and I need to find out how many monitoring plots can be fit wholly within a planting area where the total area of the plots is at least 20% of the total planting area. For example, if the planting area is 3000sqm, I would need to assign 6 x plots.20% of 3000 is 600. 600sqm would be 6 x plots. Any help or advice would be appreciated.

Hi, When i try to connect open service: https://gis4.waimatedc.govt.nz/arcgis/rest/services/Public/RoadClosure_Waimate_Active_Planned/MapServer using "Esri ArcGIS Feature Service" reader, I get Python exception error. There is no authentication required as its open service. The fact that I can use HTTPCaller and get the data with query service tells me, this service doesnt require authentication. Am I missing something? I tried few other rest service from this council with no luck. Python Exception <HTTPError>: 403 Client Error: Forbidden for url: does this error means anything to do their IT system infrastructure? Any help would be appreciated? Cheers,

I want to read a Geopackage file, but when I run the FeatureReader transformer, it creates a new geopackage file with the name of "file name"_0.gpkg so as cannot be located. I cleared several times my temp folder with ClearTemp.cmd, also Purge temporary files in my FME-script. But still I have problem with temp-file! Can you guide me how can I fix the problem? Thanks I can read my file via Reader and there is not any problem, but when I read it via FeatureReader, I have problem with temp file!

I was reviewing the article "Build Topology and Calculate Route Length" and had a question left unanswered. The dataset ends with a fork in the route. How would we set the topology builder to allow traffic from segment A to B, A to C, B to A or C to A, but to not allow traffic from B to C or C to B?

Hi,  I have just signed up with an FME account in order to access the FME Academy. When I follow the links through the Academy I end up at a SalesForce specific TrailHead. Foolishly, I created an account there to see if that would give me access to the Academy. Is the Academy functioning at the moment? Thanks,Chris

I am in the process of creating an FME script to download photos as attachments features in ArcGIS Portal using the FME ArcGIS Portal Feature Service.The script runs fine from the ArcGIS Pro application using the interoperability extension.The only problem is that images from all the features is downloaded, even if only some is selected in ArcGIS Pro.

Hi all, Something very strange happening just wondering if anyone has had the same issue. I have a process that both reads and writes ESRI Geodatabases. In recent weeks I have noticed that every time I try and read in a geodatabase I get an error "Workspace or Data Source is Read-Only". I have checked my permissions, I have checked I am the only user accessing and all is fine, and the error disappears if I copy the gdb locally - this error only occurs when reading across my work network between servers - but I 100% have the correct permissions for the task. To add to the complexity, the error only happens about 90% of the time but on the odd occasion all works as intended. Anyone any bright ideas? Cheers,Jack