FME Form

I'm migrating records from one Salesforce org to another org using FME Form. But during the translation, some of my records are passed and some are failed. Though some of the records are failed to migrate, it shows a successful translation message in translation log window. I know the number of records that are passed and failed. But the problem I'm dealing is occurring while sending email. I want to send the number of total records, passed records, failed records and along with the failed records it should also show the error that why those records failed to migrate. How can I show this information in email?

Has anyone been able to mine Oracle redo logs using logminer? I’m beginner to Oracle but it seems to me that it should be possible. I’m trying to create cdc process from Oracle to postgres and I’m able to query insert and update operations sufficiently enough from date fields that tell me when rows are updated or inserted. However, I can’t catch delete operations that way and it would be beneficial to be able to read the redo logs for the actual operations. I know I can query and compare id’s from source and target to detect deleted rows. However, this is time consuming because that would mean querying hundreds of millions of rows for the workflow.If I understood correctly, I need to setup DBMS_LOGMNR package and session for the logminer to be able to query V$LOGMNR_CONTENTS that would hold the transaction information. I guess DBMS_LOGMNR is part of Oracle database? Would that mean that I need Oracle database installed with license to be able to use logminer? The source Oracle database

Hello,I have encountered a problem, and I hope someone can provide guidance. I need to extract segments of a gable roof. I have attached a picture that illustrates my input data, which consists of polygons indicating the gable roof among other roofs in a digital orthophoto.I have utilized the CenterLineReplacer tool, which yielded satisfactory outcomes in most cases. However, I am experiencing difficulties in situations depicted in the image below (the line should be in a different direction): Does anyone have any ideas on how to solve this?Thank you in advance for your assistance.

Hi FME people,When creating a reader or writer, our typical procedure involves selecting an SDE database connection, such as SDE.EDIT.R. Following this selection, we establish a link to a deployment parameter, assigning it a local value. In this scenario, the local value corresponds to the database connection SDE.EDIT.R.    This works well, except when we try ‘view source data’ or ‘view written data.  The connection is set to the deployment parameter but the local value is not used instead.Anyone who is experiencing the same thing? We use:FME Form: 2023.2.2FME Flow: 2023.2.2Thanks a lot,Francis

The WSG transformer gets following error when I try to upload files to Projectwise: ProjectWiseWSGConnector: Uploading file "testfile.shp" to Bentley ProjectWisePython Exception <AttributeError>: 'NoneType' object has no attribute 'encode'Traceback (most recent call last):  File "webserviceconnectorfactory\webserviceconnectorfactory.py", line 227, in input  File "webserviceconnectorfactory\webserviceconnectorfactory.py", line 1129, in _handleException  File "webserviceconnectorfactory\webserviceconnectorfactory.py", line 200, in input  File "webserviceconnectorfactory\webserviceconnectorfactory.py", line 467, in _doUpload  File "webserviceconnectorfactory\webserviceconnectorfactory.py", line 511, in _uploadFile  File "bentleyprojectwiseconnector\bentleyProjectWiseConnector.py", line 320, in uploadData  File "bentleyprojectwiseconnector\bentleyProjectWiseConnector.py", line 282, in _uploadNewData  File "bentleyprojectwiseconnector\bentleyProjectWiseConnector.py", line 233, in _upl

 Hi all, I seem to be getting a strange error when trying to attach an image from a feature layer in AGOL to Cityworks using the HTTP caller. My goal is to download and upload each unique image from the AGOL feature layer and attach it to the correct Work Order (i.e. picture of stop sign for sign work order, picture of a pothole for a pothole worker). My workflows is as follows, read in the AGOL feature layer, save each image using the AttributeFileWritter, create the work order, attach the image using the HTTP Caller. The error occurs when I try to upload the image will using a variable name in the output PATH + .jpeg extension. When I explicitly set the image in the file upload, it runs no problem. However when I use the variable name in the path I get a “ HTTPCaller_2 (HTTPFactory): [11]: HTTP transfer error: HTTP/FTP Transfer: Failed to open file 'C:\Path\To\Documents\WorkOrder_Pictures\.jpeg' for resource upload”.  Here is my Cityworks API callI write the image to a folder using a

My workbench creates a number of excel spreadsheets. Sometimes it fails due to users having one of the spreadsheets open when the workbench runs during the night. Though that spreadsheet cannot be updated due to the lock, it would be very useful to still be able to update the other spreadsheets rather than the entire workbench stopping completely.Can a writer error be bypassed or ignored?

FME Configuration: FME_PRODUCT_NAME is 'FME(R) 2023.2.1.0' HelloFeatureHolder is suppose to wait for all feature to arrive then process then further but as shown below it’s not working.I’m basically re-adjusting the first part of my FME App.Get Path location / file extension Hold Features Check if file is correct then proceed further File is correct then check is .SHP file extension existsWhen I run my workspace, it stops here:  Not sure what’s going on or if I misunderstood the process.Thanks

Rebooted my computer, no crashes, no issues, upon reboot, FME Workbench throwing this error and not starting.  Any suggestions to fix the issue?

I am running a translation in batch and it is failing when it attempts to cleanup temporary files. Is there a setting that will allow it to continue when this is encountered? ERROR |Failed to delete the following files: 'D:\\Projects\\temp\\fctspatrel1688832115746_12608_1'. Please ensure that the files are not in use and that you have sufficient privileges to delete them. ERROR |Failed to delete the following files: '%0'. Please ensure that the files are not in use and that you have sufficient privileges to delete them.

Hello everyoneI hope someone can help me. I try to convert an INTERLIS (Switzerland specific dataformat) into a File-Geodatabase and got always the same error message: Could not create the File Geodatabase 'C:\Users\Documents\IBI INTERLIS\Test\ibi_saxeten.gdb'. A possible reason is that you may not have permission to create the Geodatabase. The error number from ArcObjects is: '-2147220902'. The error message from ArcObjects is: {} Could anyone explain to me what this error message means, because I have literally no idea what causes this problem. Thanks a lot and have a nice week :) 

Hi,I’ve got a strange issue.I am using a FeatureMerger to match values from a lookup table.Then I use a DuplicateFilter to check that all the terms from the lookup table are used. And strangely, with certain non ASCII caracters, there are duplicates coming out the Unique port ! Another strange thing is that these duplicates in Unique port dont appear when I check for duplicates immediately on the lookup table.So what happens in the FeatureMerger that makes the DuplicateFilter dysfunction ? Here’s what the Excel lookup table looks like. When I replace the non ASCII caracter, the problem doesn’t appear.What to do ? 

Hi allDoes anyone have experience in using Google Earth Engine (GEE) in FME Desktop (I work with FME 2023.2)? I would like to access some remote sensing data in FME, process it and combine it with other data.I found out that the transformer “PythonCaller” could be used to integrate some Python code in FME. GEE advice to use the package ee/geemap for formulating requests to the engine. Accessing the GEE via Jupyter Notebook does work, but I’d rather integrate the processing in FME.Thanks for any help/advices.

 I have a workflow that takes a file in input , does a conversion , then outputs the converted file.I published this workflow to fme flow . and i want to use it to in my simple node js project : simply : the user clicks on “Choose an input File” , and chooses the file he wants to convert ; and after clicking on “Convert and download result!” , his file should get uploaded to my fme server , the workflow gets applied on it , and the resulted file gets downloaded to the users computer.  And I don’t know how to apply the workflow on the file that the user chooses , because the filepath of the reader dataset is static , and can be changed only manually in the fme flow web interface ;​​  

Hi All,Is there any way to read multiple GDBs saved on the company Sharepoint? Does the Sharepoint need to be publicly accessible? I get an error when try to use the URL link and load the GDB,  Also I would like to know a workaround to read individual GDBs, Any Ideas? The GDBs are saved in individual folders so need to iterate thought these, example of the folder structure below: Example of the individual content folder below:  

Hi Guys..I need your Guidance to accomplish above scenario..I was able read a GDB and Excel as source from Feature Reader and also able to do required Results Now , At attribute Manager , I want to add around 52 new field names along with field alias from importing it throughexcel and this would be new field and then i want to write a GDB , so All field along with other New fields which has alias name to be written to GDB.. How can i do this ? Anyone , Kindly Guide..Thanks

Hello ,  any idea , how could I get benefit of using transformer chat gpt to improve my workbench for GIS data ? Why are using chat gpt transformer ?Fme 2021thanks in advance.

Hello FME Community,I'm currently working on a project that involves a large number of subdomains and domains, and I have my data available in table format. I'm looking for guidance on how to organize this data into a geodatabase (GDB) using FME, while adhering to domain conventions.Specifically, I would like to know:How can I create subdomains within a GDB using FME? What steps are involved in defining domains for attributes within the GDB? Are there any best practices or recommended workflows for organizing subdomains and domains efficiently?Any insights, tips, or examples would be greatly appreciated. Thank you in advance for your help!Best regards,Vishnu N V

I am trying to insert a new item/child into an existing XML element. I want to add: <keyword>USA</keyword> to either the top of this list of keywords (Note this is part of a larger XML document.) I’ve tried to use the XMLUpdater to no avail after a substantial Forum search. Here’s where I am at with the XMLUpdater:I assume my XML/XQuery expression is the issue. Any help would be appreciated. Thanks in advance!Version: FME 2022.2.0.0 (Build22765)

I’m looking for a way to move points which are spaced at “x” distance from one another to a nearby road (line) shapefile. I want to maintain the same “x” spacing along the road once the points are moved to the line.

 Hello,  I am updating an existing AGOL Hosted Feature Service with changes in a File Geodatabase. The workbench in the screenshot is what I am using. The Feature Service updates no issues, and it does update the feature service. But I have a question:When I add 1 new feature in the file gdb (Updated FGDB Feature Class Bookmark in screenshot), I run the workbench and in the ChangeDetector it shows 1 record Inserted and 238 records updated for a total of 239 records; The only change I made was to add 1 new feature (which I expect to be in Inserted), but why would there be 238 records in Updated in the ChangeDetector when I only Inserted a single record and Updated zero records, should these 238 “Updated” records be in Unchanged?I then reran the workbench it showed 239 records in Updated (which includes the one I added in the 1st run), but I Updated zero records so I would assume these 239 records should be in Unchanged?  The ChangeDetector Parameters I am using is in the screenshot. 

Greets,  Any idea to cut the polygons in the layer 2 based on the polygons in layer 1 in the same shape and close or same ratio of cutting , please note that there is a shifting between tow layers.or move the polygons in layer 1 to match the location of polygons (based on corners) in layer2    

Hello everyone,I'm facing a challenge in processing data in Excel and I'm seeking assistance. I need a method to search in one Excel table for entries that contain values from another Excel table and then create a new table with the found entries.Specifically, I want to search an Excel table (Table A; 8 collumns) for certain keywords. These keywords are located in a separate Excel table (Table B; 1collumn). When any of the keywords are found in Table A, I'd like to create a new table with these entries.I would greatly appreciate any advice, tips, or examples that could help me solve this issue.Thank you very much in advance for your help! 

Hi all!I have a polygon where every vertex/point (don’t know the correct termonology) has a xyz coordinate. I would like to create a buffer where the buffer size depends on the z-coordinate. Couldn’t figure it out how to do it. Anyone who can help me figure this out?

Hi,I have some texts and want to export them as IFC along with the other geometries.Can anyone help me please?