Data

MongoDB Reader creates Geometry Collections if the mongo collection contains more than one geometry field. Is there a way to choose which one of these fields should be treated as a geometry?

Hi everyone. I am reading data from an Esri Geodatabase. I have an issue with the Shape area reading as negative values. I have tried the geometry validator with Area Orientation set to “right” as with “Allow Left” and “Check doughnuts only” does not deliver any repair results. After the feometry validation, my repaired results still contain the negative area values. Negative values after geometry validatorIs there another way of solving this, I know the issue can be resolved in ArcMap wit geometry repair is there a similar way of doing this with FME?

I am attempting to convert a DXF/DWG file into the IMDF format. Following the instructions outlined in the first and second articles, I have successfully preprocessed and located the DXF file.However, I am encountering an issue at part 3 of the process. The Reader does not seem to be reading any features as expected.The tutorial I'm following can be found here. One thing, I updated the reader format from Autodesk AutoCAD RealDWG DWG/DXF to Autodesk AutoCAD DWG/DXF.Because I could not load module '/Library/FME/2023.2/plugins/realdwg/realdwg.so' .But i do not think that causes the problem.I would greatly appreciate any assistance in troubleshooting this problem. Thank you.   

Hi. I need to know how can I get data between two characters.I have an attribute like this:10 12 Street (Main) CamnoreFirstly I need to get data between two characters ( ) and Secondly I need to convert it into two columns with this result:10 12 Street Camnore10 Main CamnoreIs StringSearcher is helpful? if yes how can I get this result?I really appreciate your assistance

I am using the FME REST API v4 to try and retrieve all Workspace Apps (and Automation Apps and Gallery apps) but I only get http status code 404, although I see in Fme Flow that we have over 20 Workspace Apps. I can retrieve Schedules, Automations and Workspaces just fine. Is it a bug? Result:HTTP/1.1 404    NO_RESULT    {"message":"FME Server Workspace App automations does not exist."}    404 This works:$(FME_SERVER_URL)/fmerest/v3/schedules?limit=-1&offset=-1This doesn’t work:$(FME_SERVER_URL)/fmerest/v3/apps/automations?limit=1000&offset=0 

Hi,I'm attempting to filter the records in the reader using the WHERE Clause, but I'm having trouble making it work. I'm trying to select all entries created after 20230718. I've tried the following equations, but it failed."created_date">20230718000000.000000"created_date" LIKE '20231718%' Error ArcGIS Portal Feature Service Reader: Encountered an unexpected error. The error code from the server was '500' and the message was: 'Invalid data type for expression ["created_date">20230718000000.000000].'. Details: '' ArcGIS Portal Feature Service Reader: Encountered an unexpected error. The error code from the server was '500' and the message was: 'Invalid data type for expression ["created_date" LIKE '20230718%'].'. Details: ''

Hi All,I’m new to process LiDAR data using FME and just received a bunch of LAS files that need to process as DEM (output). I was doing some reading and users sue the _classifciation to classify the data but have just realised that my data isn’t classify as my classification filed is 0? Screenshot below: I’ve also tried to use the PointCloudLASClassifier but the classification is 0 so doesn’t work. Any trick to classify the data and be able to export the DEM?

Message: ArcGIS Online Feature Service Writer: 'addResults' error for a feature in 'LAYER NAME'. The error code from the server was '1000' and the message was: 'Arithmetic overflow error converting expression to data type nvarchar.

hello ,i have detected self intersection with geometry validator does it possible to convert the line that detected to straight line ? I do not need the triangle at image (I have detected the issue location with geometry validator ,but how could I remove the part unwanted that occurs it ) .thanks in advance Fme 2021

I am working with a workbench that was authored close to 15 years ago. We had to change out the SDE Readers that are pulling in our GIS features. Since changing the reader the text be written to the DGN is coming out in different sizes. I have checked the output in the inspector and although the text is visually different the idgs_text_size attribute is consistent. I have tried to override this with the DGN styler but there is something else going on. Any ideas on how to either assess or fix this would be greatly appreciated. 

Dear,I have a folder with 2208 xml files, approx. 30 GB. I read these files using a File Path Reader followed by an XML reader. From these files I select some features and save them locally. However, with my 16 GB RAM I run into memory issues. I already reduced the amount of data as much as possible within my workbench but still its not enough.Is there a method I read first 10 xml files – process them – save the outcome and go to the next 10 files, like a loop? My second question is whether it will safe memory in case I use a fanout expression or just write one final dataset with the results.My version is: FME 2023.2.1

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

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

 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

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 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:  

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’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 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! 

Hello,I need some help.I am a major student and I am in my final paper for my diploma. I Have to make a 3D map of a town using Citygml.I have used Arcgis to create the shape file and pgadmin to create a data base.But when I try to connect my database to Citygml It doesn’t work.When I open the command line to insert the parameters it says that there is a problem.I have installed postgresql and Java in my computer.i don’t know if someone can help me but you are my last hope haha(Not an native English speaker so if something is not explained good please be understanding)

I am reading data from a PostGIS table and writing to an ArcGIS eSDE, but I’m not able to create tables in the eSDE from FME, I can only write to tables created by ArcGIS Pro in the eSDE, is this normal?   I'm getting an ArcObjects error ‘-2147220655’, DBMS table not found. 

Hi FME users,  The main purpose of my recent FME workflow is to GET the files from the folder from the FME server using HTTPCaller. Although the process displayed green which means the process is running correctly, the inspector showed the HTTP status code 200, which means the results are rendered in the response body (Figure 1. ) but not created successfully in the local drive. Figure 2 is the basic setup in HTTPCaller. Figure 1. FME Inspector. Figure 2. HTTP Set-up  Then, I tried another URL copied from FME API using POST, /fmerest/v3/resources/connections/Data/download/Logo/CPB_Logo.jpg, then the FME gave me the

Hi, I'm reading around 5 million rows from the 252 Excel files. I need to view the rows to delete many columns and edit values, but indexing the results is taking a long timeHow can I improve this? Thank´s

I have an AttributeManager in a custom transformer (may be part of the problem but thought I would start simple with the AttributeManager) that has the following data (correct) on the input but the name of the attribute (not the attribute values) is assigned in the output.Input Attribute “Public_Water_System_ID” with correct values and output with wrong values:Settings in the AttributeManager is as follows:For data type I’ve tried buffer (default), varchar(20), and char(20). None of the other types seemed to make sense since the values are string.Perhaps a related problem is that this attribute (“Public_Water_System_ID”) is passed as a parameter into this custom transformer