General

Hello ,How to convert file geodatabase to arcsde ? thanks in advance FME 2021

Hi FME Community..Need your guidance , I'm receiving different dates in a particular column called "date_1" total records 401 including null when im using date time convertor to standardise it , Give me all null values to that column..Need expert GuidanceI have attached the templateThanks

Hello,I have a json response body that I am trying to get into a table. Using the JSONFragmenter I have gotten each record to populate as a different fragment. I have a long string with all the key value pairs. See below, {"ActualFinishDate":"2023-06-01T18:00:00Z","DateSubmitTo":"2022-05-02T13:37:46Z","Description":"FLT - Service Requirement","InitiateDate":"2022-05-02T13:37:46Z","StatusDescription":"Completed","WOCost":0,"WorkOrderId":"3006845","Comments":null,"Instructions":null} Now what I would like to do is create a table that would have each of the value keys as an attribute column and to have that tabled filled out with the corresponding data.  What would my next steps be?     

When writing to a hosted feature layer in ArcGIS Online we are getting duplicate features on occasion. In the latest run where this happened, there were 15,304 features in the dataset which were reported as written to ArcGIS Online, although the feature layer actually had 16,304 features written to it. Features with OBJECTID 9001 through 10000 were exactly duplicated making it seem like a batch of 1,000 features were written exactly twice during the process. OBJECTID 10001 was an exact duplicate of 9001, 10002 was a dupe of 9002 and so on.... After this batch of duplicates, subsequent features were not duplicated (features before OBJECTID 9001 were also not duplicated).

Hi, I have a bunch of fairly complicated SQL queries, which I frequently use in an SQL Creator. This saves me a tremendous amount of featuremergers and such, because the sql basically re-creates the business object from the normalized database tables. Up to version 2020 this worked just fine: insert an SQLCreator, select DB Connection (SQL Server 2016 SP3), copy-and-paste SQL from my code snippets, click on the ellipsis to Expose attributes, click on Populate from SQL Query, and I'd be done. Now that we've upgraded to 2022, that does not work anymore. The Attributes to Expose dialog stays empty, and no error messages or warnings appear in the log. It is rather annoying because I have to do this all the time, and now I have to copy the attribute names manually from my sql statement. It's causing me quite a bit of extra work. Am I missing something? I am currently using FME(R) 2022.2.6.0 (20230523 - Build 22800 - WIN64) , and up

I've gone into Manage Web Services and managed to configure the Microsoft Mail (safe.emailer) web service and it tests and authenticates without issues. However, when I add the Emailer transformer from Hub and go to select the Email Service from the Service section I only see Generic SMTP and Gmail. Is there something special I need to enable or refresh for the transformer to see my new web service? edit - have tried this in both versions of 'Form' I have installed (2022.0, 2022.1) thanks

Hello , i would like to create a line between two attributes that has coordinates at same tableThis table has many points .Id_1 | x1 |y1|id_2|x2|y2 x1 ,y1 relates to id_1x2,y2 relates to id_2Both of them are points. How could I create a line between id_1,id_2 and add text that include the value of id_1 and add text of value of id_2FME 2021

Hi Community, I'm trying to run an existing FME 2018.0 workbench on FME 2020.2. and just received ArcObjects is: '-2147219879' error. Tried to search online but couldn't find the workaround/solution. The FME workbench reads a GDB and applies metadata based on XML file as well as an excel file. Attached the log file for reference.  Any help more than welcome 🙂

I have workspaces that allow a users to define an area of interest when looking for data. Instead of the openstreetmap coming up, now it is just a grey box. Coordinates still get passed, but the user cannot see where they are drawing their polygon.

Introduction: I am encountering an issue with an Esri ArcGIS Server Feature Service link. Over the past few days, the link has been functioning correctly; however, starting yesterday, it started throwing an error. As a newcomer to FME, I lack the necessary understanding to interpret the error message, specifically the AttributeError: 'NoneType' object has no attribute 'name'. I would greatly appreciate any assistance in resolving this issue.Problem Description: The link causing the problem is as follows:Link: https://mapservices.weather.noaa.gov/tropical/rest/services/tropical/NHC_tropical_weather_summary/MapServer/Details: Upon accessing the aforementioned ArcGIS Server Feature Service

I have a workspace which is scheduled through Windows Task Scheduler on a Virtual Machine. This workspace writes out to an Excel file on a mounted drive. When running the workspace manually, it has no issues. However when running through Task Scheduler, the workbench gives an error "Can't open file for writing". The target Excel is not opened anywhere and I do have writing permissions for it. Has anyone dealt with a similar issue before?

For a job that has been working for years, it is now endlessly polling job status and returning awaiting worker. In Server, the last message you get is about the Socrata Write executing. In the desktop software you get more information and it reflects endless polling. Something has changed and I'm having trouble figuring out the cause. 2 of 24 of these (county specific) ran and the rest hung, and now even the two that ran initially will hang. It appears to be happening in the last step involving the Socrata Writer. This is the last log information, with the "Polling the job status: Awaiting worker" repeating endlessly. Other jobs that write to Socrata are still working. It isn't blanket failure on writing to Socrata. Any thoughts on cause or leads to investigate are welcome. ThanksSocrata Writer: 0 features treated as points, 0 features coerced to point, 0 features with unsupported geometries written without geometrySocrata Writer: Invoking Socrata DataSync with

I have a zip file that has a csv file and multiple jpgs. I tried a CSV feature reader-- not a CSV reader-- as I was trying to read the file with in the zip file but that didn't work. I am using FME 2022.2.2. Is there a way to only extract a particular file from the zipfile? I dont want to unzip the entire thing as it will take a long time. Thanks in advanced.

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 som

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

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",

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.