General

We recently upgraded our FME server and now the file upload in Server apps is no longer working? When i click upload file the app says "There was an error uploading the file."

Hello ,i am working with file geodatabase then writing the output into file geodatabase so my input :file geodatabase and it contains ObejctIdbut when I write the output into file geodatabase after finish work on the data .i have found that the output contains new attribute called objectid_1how to avoid the data from creating the new objectid_1 because I have already attribute Name called objectid and I do not need extra .fme 2021 thanks in advance

def add_double_slash(file_path):  modified_path = ''  for char in file_path:    if char == '\\\\':      modified_path += '\\\\\\\\'    else:      modified_path += char  return modified_path # Example usagefile_path = r'C:\\Users\\Username\\Documents\\file.txt'modified_file_path = add_double_slash(file_path)print(modified_file_path)

I have two tables. One is a large ODBC table in which I only want to extract the data when the modification date is greater than the last date of another table. The SQL for what I want to achieve is simple ; SELECT * FROM table1WHERE modwhen > (SELECT MAX(modwhen1) FROM table2);Any help is appreciated.Thank you,  

How can I replace different texts in a dwg file with the help of pairs of search/replace data from 2 columns in an xls table?

Hi,I have a floating license for FME. I want to know how this FME license validation works ?Is it like license is checked everytime when I run a script through command line / FME Workbench OR it checked only once when we open the FME workbench ?

I am getting an error when run a workbench on FME Flow. The workbench supposed to extract shapefile from S3 bucket and write it to the database.The shapefile has very complicated and big area in it. Not sure if it matters. The total size is 300Mb. Log file has just this error: Job doesn't fail, it looks like it is stuck. It lasts for hours, more than 12 hours. I had to cancel it.  I thought that the problem is explicit with shp.xml file. But I checked previous uploads and there were successful ones. Even with this file.  Please advice.

The FME exported obj model has no name attribute, it is all defaultobject, how to set it, I need to use cesium to design a simple query system to associate attributes through nodename

Just a minute ago I did discover something I did not know yet: it is possible - to my surprise - that it is possible to retrieve a password stored in a User Parameter using a simple ParameterFetcher!Passwords stored in User Parameters are encrypted (see e.g. this post), but the ParameterFetcher just returns the decrypted password in plain text... :-(So everybody with access to a workspace with passwords and FME Workbench can just use this fetcher to retrieve all passwords.OK - maybe I have been a little naive... :-) But this is surely something to take into consideration.

Hi, just wondering if anyone can interpret this log message for me and tell me how to change the workspace encoding under Windows, if that will help. Thx! (am including all the software version details for reference) Starting translation...Current FME version: FME 2022.1.1.0 (20220728 - Build 22623 - WIN64)FME_HOME is 'C:\\Program Files\\FME\\'FME Desktop Smallworld Edition (floating)Permanent License.Machine host name is: FBC-19-0068lOS Locale Name   : en_USOS Locale Encoding : windows-1252Process Encoding  : UTF-8FME API version: '4.0 20220615'FME Configuration: FME_BASE is 'no'FME Configuration: FME_MF_DIR is 'I:\\GISSBX\\ELECTRIC\\FBC_010_CA_Dashboard\\MXD/'FME Configuration: FME_MF_NAME is 'Condition Assessment Dx.fmw'FME Configuration: FME_PRODUCT_NAME is 'FME(R) 2022.1.1.0'Operating System: Microsoft Windows 10 64-bit (Build 19044)...The workspace was authored with a system encoding of 'windows-1252'. This will be the encod

Hi, FME communityI hope everyone is doing great, I am creating 3d tileset for cesium js and it is getting created successfully, but when I am using 3d tile validator tool(cesium team has implemented a validator tool here https://github.com/CesiumGS/3d-tiles-validator) then I am getting my tileset is invalid because of some errors, I do not know how to overcome of these errors using FME, please anyone if knows how to fix these errors, please let me know. please find the errors below:-   "type": "CONTENT_VALIDATION_ERROR",   "path": "data/data7.b3dm",   "message": "data/data7.b3dm caused validation errors",   "severity": "ERROR",   "causes": [    {     "type": "BINARY_INVALID_ALIGNMENT",     "path": "data/data7.b3dm",     "message": "The byte length must be aligned to 8 bytes",     "severity": "ERROR"    }   ]  },  {   &

HI. I would like to ask FME team about how to see the contents of storage inside of FME flow, and how to manage/delete the storage (temporal storage or primary disk) of FME flows. I would like to reduce unnecessary payment/charges, so please kindly let me know. Thank you. 

I have some floor plan DWG drawing with gaps (walls) between the rooms. The desired result is to make it simplified floor plan, i.e. keep just one line between the rooms.There are hatches that forms the basic shape of polygons to begin with. So far I could get rid of gaps by buffering twice (positive and negative), dividing overlaps and dissolving small artefact sliver polygons to bigger ones. Later snapping the segments. The result is more or less satisfying, I just wonder if there's more elegant solution. For example the snapper (segment) doesn't maintain the orthogonality and makes "crooked" lines...Thanks for any suggestions.

I am trying to update a feature class containing statistics. Basically i am using the following fieldsfme_basenamefme_featuretypeand each value from the fme_db_operation (insert, upsert, update, delete etc) is the number of eachmy problem is, that if there are no deletes i get no features coming through as expected, but how can i still send through the fme_basename, fme_featuretype, and for example the value of zero for the delete attribute.I want to be able to add the total records, but obviously can not do that if there is no value, hence setting as zero.From what i have, if there are changes then they go through the workflow as expected.Regards Andy   

Hi there. I'm preparing our GIS data to adjust to align with new cadastre boundaries when our state mapbase is updated as part of the Digital Cadastre Modernisation. So far with testing it all looks good, but I see one polygon on one the layers has disappeared in the shifted version. On investigating it looks like the adjusted parcel this features sits on looses a few vertices in one corner and the shift vectors being used possibly cause a self intersection. I've attached the example. On the left, the grey is the current parcel boundary and the purple is the shifted, with the shift vector joining.On the right is the particular layer that aligns with the boundary that is disappearing post shift. You can see the shape of the parcel changes and it looks like the shift vectors would cause a self intersection. Just wondering if there are any ways to avoid this? I can see a record in the output data but no geometry, or an invalid geometry. Thanks in advance. Josh

Hello , i have geodatabase data as input ,it includes different points ,lines ,annotations . I would like to read this data in FME workbench and filter specific data from them for city then write the output again into new geodatabase writer .my problem : when I use spatial filter and use the specific city as filter and the geodatabase data as candidate .so the passed port include all data together and for sure not each input has the same attribute names as other .How could I write the output for my data (passed port ) into geodatabase format and each writer includes only his own data without any problem . 

Hello everyone, I try to automate a monthly calculation of water deficit, based on monthly rainfall data. Each feature is characterized by a year (integer), a month (integer), and rainfalls (float). The calculation involves the water reserve at the end of each month ("final reserve"), based on rainfalls and number of rainy days.  My challenge is that I need to carry this quantity to the next month ("former reserve" of current month = "final reserve" of previous month). Easy to do in Excel, but I'm not sure if this is possible and how I should proceed in FME.  Is there a matter of "iterative calculation" here, since the data of each month depends on data of previous month ? Should I convert my "year " and "month" integer into date format ? Thank you in advance !Regards,Arnaud 

and error message below. Not sure where to from here. It was working but I am a total novice at web connection stuff. 2023-06-01 15:11:03| 0.9| 0.0|WARN |Request to update access token failed. HTTP Error: HTTP/1.1 400 Bad Request2023-06-01 15:11:03| 0.9| 0.0|ERROR |Python Exception <FMEWSException>: Type: 3, Number: 1, Message: Failed to get authorization header.2023-06-01 15:11:03| 0.9| 0.0|ERROR |Traceback (most recent call last): File "fmegeneral\\plugins.py", line 500, in input File "webserviceconnector\\fmewebfs.py", line 1096, in receive_feature File "googledrive\\gdrivefs.py", line 569, in handle_operation File "webserviceconnector\\fmewebfs.py", line 699, in handle_operation File "webserviceconnector\\fmewebfs.py", line 856, in handle_download File "googledrive\\gdrivefs.py", line 466, in get_item_info File "googledrive\\gdrivefs.py", line 241, in get_file_metadata File "C:\\Program Files (x86)\

Hello ,i need to convert from EsrI Database Arcsde Geodb to write into Geodatabase (File Geodb Open Api)Feature reader :to read all feature classes in Arcsde feature write :file geodatabase my target to write specific feature classes that belongs to one Feature dataset from Esri Arcsde into file geodatabase i need exactly sample of feature dataset to test in ArcGis pro .  FME 2021 Thanks in advance

One of them is:WARN MessageCould not load module 'C:\\Program Files\\FME\\2022\\plugins/MAPINFO.dll' : 'The specified module could not be found'Could not load module 'C:\\Program Files\\FME\\2022\\MAPINFO.dll' : 'The specified module could not be found' Translation is successful (Desktop or Server)

Hi,  I want to separately identify missing, null and empty values in a data array.I tried with the TestFilter, the sorting does not seem to be done correctly.Because, my file contains null and missing values but here all data exits in one place. Do you have a solution ? Thanking you in advance   

I have made a script that writes data to Oracle database, using FeatureWriter.Before I write data, I use FeatureReader to read number of records. At the end of the script I want to know how many records there are now.I also use FeatureReader for this. The results are always the same as before and after the transactions. It seems that the 2nd FeatureReader has already started before the transactions have been processed. I have tried with Oracle Reader, 2nd connection parameter, SQLExecutor.The results are always the same as before and after the transactions.Also using Triggerer and Decelarator. Something has to happen that the 2nd FeatureReader will 're-read' the table. Anyone has a suggestion ? Thank you in advance ! 

Dear Safers,I am trying to create this network using the 'From' and 'To' columns.So, the number in 'From' is connected to 'To', and then find this 'To' number in 'From' and find it's corresponding 'To', and again find the second 'To' in next 'From' and get it's corresponding value in 'To'.The catch is, the value in 'To' has to be greater than 'From'.I can think of a go to solution in SQL, but can't think of something using transformers.Thank you for the support.

Hi everyone, I am new to FME, please help me with the following issue. I am reading an excel file using FME. The name of the attributes (columns) is not right, and its in row 5 of the file. I was wondering how I can assign values in that row (5) as attribute names. I know that I can use a tool like AttributeManager to rename the attributes, but its too many attributes/columns (>100). I need a way that could assign the values from row to attribute name.Thanks

Using FME Desktop 2022: When attempting to write to pdf the following error occurs 'PDFWriter: Unable to successfully read the font from 'C:\\Windows\\Fonts/._TravelingTypewriter.ttf'. This font will not be available. Internal error code was '2'' FME has reading rights to this directory and the file exists. I haven't selected this particular font in the preceding PDFStyler-transformer. Any ideas why this occurs?