General

I am trying to use a "Where" clause for the reader but it does not identify the field in the existing geodatabase. I have a Esri Geodatabase connection named vg_esri and I wanted to select a table named vg_esri.sde.mm_poly_gh and select a polygon wíth its id polygon_id = 852364, I have used SELECT polygon_id FROM vg_esri.sde.mm_poly_gh WHERE polygon_id = '852364';Could not find the features in the table 'sde.mm_poly_gh'. One possible reason is that a WHERE clause was specified that references a column/field that does not exist in the table. The error number from ArcObjects is: '-2147216081'. The error message from ArcObjects is: {Invalid SQL syntax [ERROR:  syntax error at or near ";"LINE 1: ...FROM dg_esri.sde.mm_poly_gh WHERE polygon_id = '852364';)But I get this above error, What am I doing wrong, I cannot figure it out. Any input will be very help. Thank you... 

Hello, I have configured FME-Server for httpS. following this description https://docs.safe.com/fme/html/FME_Server_Documentation/AdminGuide/configuring_for_https.htm. But now is the file upload no longer working. "There was an error uploading the file"(https://docs.safe.com/fme/html/FME_Server_Documentation/WebUI/Uploading_data_files.htm) Any help is highly appreciated. Thanks.

Good morning, I would need to do a spatial join on FME. On QGIS, the tool is called "Join attributes by location". I would like to find an FME transformer that does the same as the QGIS tool. Thank you for your reply

Hello I have a file in xml format. Although I selected many xml formats in the addreader section of fme, I could not open my file. Can you help me?

I'm missing the Beta-Download:"There are no betas currently available to download. Please check back again in the future."

FME Desktop 2022.2.3

Hi, Just after a bit of advise. Within my organisation i am trying to request an app to connect to sharepoint. When this work on FME desktop i have to authorise with my own identity and it works fine. However, as my organisation has a 2 factor authentication policy which requires me to enter a text message password, i need to reauthenticate every 2 weeks. Would this be the same with FME server, requiring me to reauthenticate every 2 weeks (as not useful for a process i want to leave on a schedule)? or when i authenticate the app from FME server, would remove this reauthentication requirement? if not is there anyway around this? I would do trial and error to find out, but its taking me along time to get through internal processes, and want to ensure after the effort it take to get there, its going to work as hoped. Many thanks, Andy

I'm finding that the LineCombiner is causing issues when combined with an AreaBuilder. The non-combined lines in a workspace I have created successfully create areas but, when the lines are combined, they then make up incomplete areas. You can see in the below image that, once one of the line datasets go through the LineCombiner, they do not successfully create the areas. Is this a bug?

Hi,With FME(R) 2022.2.4.0 (20230303 - Build 22792 - WIN64) I am trying to load 1730 DWG files with attributes. The feature reader reads all the files and generates more than 81 million elements. The next step would be to expose the attributes from the DWG files. When I try to Import the attribute list from feature cache I receive the following error:An error occurred. Here is the information that FME was able to find on the errorbad allocationFailed to open the dataset 'C:/Users/csernak/AppData/Local/Temp/wb-cache-readalldwg-cKcBRr/Main_FeatureReader -1 3 fo 1 _lt_OTHER_gt_  0  4cd4d7e49164af1f4967e8da9131f3594634062d.ffs'DATASET INFO:    DATASET: C:/Users/csernak/AppData/Local/Temp/wb-cache-readalldwg-cKcBRr/Main_FeatureReader -1 3 fo 1 _lt_OTHER_gt_  0  4cd4d7e49164af1f4967e8da9131f3594634062d.ffs    NUMBER OF PARAMETERS: 0The files are there, the disk is half empty, the memory usage is just 400 MBs.With a single file it just works fine.Is there anykind of limitation around that?

When I am reading the files which are of size 192 MBit is working fine but when I am reading the file which is of the size 958 MB , getting an error. I am getting error in fme server while reading the particular file . Is there anyway to solve this error?

HI All, Any workaround to convert a date string (YYYY-MM-DD format) to DD/MM/YYYY ? The field type needs to stay as date string see below:  I've tried a few transformers (StringReplacer + ListExploder+ String Concatenator) but couldn't get it to work and show 21/04/2023 Thanks

At first, it successfully connected to the database, but later on, it started encountering errors that were resolved after some time. However, for the past four days, it has completely stopped functioning, rendering me unable to continue with the tutorial.

I have a script that was written for us by a consultant and it’s very intensive. The FeatureReaders are pointing to a connection file to read our SDE, as well as some file geodatabases that are stored locally on the server. The script uses a WorkspaceRunner to access a child script to then do some calculations. However, when I run this from FME desktop on our server, it never completes. It doesn’t throw an error, but it just gets hung up at the WorkspaceRunner. If I try again, the same thing will happen. There’s no common point in the script where this happens. It’s very random.I’ve also attempted to run this script from my desktop, and it works. It’s very very slow, but it does work. However, we need to be able to run this from our server, not my desktop.Any ideas on what I should be looking for in our Server environment? Our server has much more resources than my desktop, so I’m surprised it’s not working – so I must be missing something. Any leads on this would be greatly appreciate

I have a case where I need to determine which wells (polylines) belong to which unit (polygons) based on spatial relationships. I need to be able to know the percentage of those relationship (wells and units) and some key data associated with the unit. I need to determine percent of overlap and produce two outputs.  One to show only the relationships (between wells and units) with the highest percent of overlaps (including their percent overlap value) and an another containing all relationships (between wells and units) and their percent of intersect. Thanks!

Using FME workbench and fme.exe file. Both was working earlier. Suddenly both are not able to open any .fmw file. Only if run as Administrator it is working. What could be issue.FME version : 2016Server : Window 2008

The distance between the road and the plots are not fixed, so we can't use a buffer

File error! Couldn't open file. any idea what will be reason ?

Hello, I am using FME Server 2021.2.3 deployed on couple of machines in a fault tolerant configurationWe have an Oracle database 19c. I have tried to connect to the database in FME Server, but getting the error message below (see attached also). I can connect to the database from SQLDeveloper on the same server.A similar issue was reported in https://community.safe.com/s/question/0D54Q000080heRDSAY/not-able-to-create-a-new-database-connection-on-fme-serverHowever the solution needed a reinstall of FME Server.Does anyone have other suggestions ? 929028:SQL Query SELECT NCID FROM fme_nc_namedconnections WHERE connectionname = ? AND username IS NULL failed. Error: Unsupported feature

How to connect fme server to the network drive?

I am trying to setup oAuth. When I test the Web Service, I get this:The endpoint does not support the provided HTTP method I have setup oAuth 2.0 in postman with success. One difference I see is that postman sends a POST for Authorization while FME sends a GET. Any workarounds for this?

Hey there. Im trying to use the good'ol Creator->HTTPCaller->JSon'er method for the data here:https://www.fega.gob.es/atom/es.fega.sigpac.xml Where I am basically sending requests to fetch certain part of the data and then do some analysing on it before exporting to a format. But there is a problem here which is that the service requests you to accept to terms and conditions before you can start fetching.  Doing this through browser ain't a problem as you just click on the "LEER Y ACEPTAR LAS CONDICIONES" button and read through the document that pops-up and then press "ACEPTAR LLAS CONCIONES" which brings you to the data. It is using the HTTPCaller where i have the problem, cause just fetching the data (through the same URL) gives me the _response_body:<html><body>No has aceptado las condiciones y no puedes ver los ficheros</body></html> or basically "You have not accepted the conditions" Does anyone have suggestions how to include accepting the terms and

Hi all!I want to request the monthly average exchange rate for a whole year. So far, I have transformed the soap request to xml and pasted it into the xml templater. I then post the request by the HTTPCaller and extract attributes by means of the XMLFragmenter. This works fine as long as I request the monthly average exchange rate of one month of a specified year at the time.However, here is were I am stuck: To get all monthly average exchange rate I would need to post 12 request, one for each month. My idea was to do this by means of sub templates, but I have not succeeded in doing so. I tried to import a file containing a list from 1 to 12 (1= january...12=december) and connect this list to the sub port. I could add 12 xml templater and httpcaller instead, but this does not seem very effective. Is it possible to achieve this by sub template?Or is there a way to dublicate requests or is it in some way possible to loop through the request?Any ideas and help are welcome!Thanks in adva

Hello , i have question relates to neighbor finder .i have two different data of lines as input of neighbor finder .lines A lines Bmy parameter : no. to find (keep empty ) without value so as possible and distance 1 meter .my target to find which lines from lines A close to lines B within distance 1 meter .i have got the expected output with id .But does it possible to find ,which part exactly of lines that has distance 1 meter from other lines and save geometries with id for each part of lines .thanks in advance fme 2021

https://community.safe.com/s/

Hi all,Recently, I've been trying to load an Excel file using Python Creator.reader = fmeobjects.FMEUniversalReader('Excel', False)reader.open(FME_MacroValues['SourceDataset_XLSXR'])feature = reader.read()while feature:               attributes_list = feature.getAllAttributeNames()               for attr in attributes_list:                      attr_value = feature.getAttribute(attr)                      feature.setAttribute(attr,attr_value)               self.pyoutput(feature)               feature = reader.read()reader.close()Unfortunately, the above reading process loses the feature schema.Is it possible to use Python FME API to expose all attributes or load a feature schema from a source file?