- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27683 Posts

Most replies

Most views

Newest first

fbrennContributor

asked in Transformers

Comparing two dates types

Hello!Here is my problem:I have a SDE db (let’s call it T1) with field “date_change” (type: date). I also have a table (let’s call it T2) that has a filed “sync_date” (type: date).I am trying to make a query where I select all features from T1 where “date_change” is equal or greater than T2 “sync_date”. I am using a FeatureReader and trying to apply it on the where clause. However, my query keeps coming blank. I think the syntax is wrong (WHERE clause: “date_change” >= “sync_date”). Anyone has any suggestions?Thank you in advance!

441

9 months ago

jonContributor

asked in Authoring

StatisticsCalculator not working for min/max for certain attribute

I’m on 2022.2 and using a StatisticsCalculator with a Group By (based on the name of a CSV) to get statistics (min, max, mean) on a handful of attributes. It works great for all but 1 attribute (Specific_Gravity) and I can’t figure out why. The attribute type (64 bit real) is the same between Specific_Gravity and Temperature_F so I’m not sure why one works and the other doesn’t. The kicker is that I can get Mean values for Specific_Gravity but not Min or Max.Do I have the transformer configured incorrectly, is it a data type issue, or something else??Screenshot of transformer with results:

963

9 months ago

kmbaltzlParticipant

asked in Transformers

Translation was successful, but I receive Error: Failed to initialize the reader in the temporary rendering process

I’m running a FME script that reads feature classes from a GDB, performs a handful of transformations followed by one inspector, then writes to a new GDB. After running the entire workspace, it says the translation was successful. But that message is followed by: Failed to initialize the reader in the temporary rendering process. I’m still new to FME, so I don’t understand this error, or what needs to be fixed. Can anyone provide any insight on this, or how I can troubleshoot this further? FYI I’m using FME 2023.1.1.1

5404

9 months ago

dhaulagiriContributor

asked in General

New warnings with FME 2023 cause translation error

Hello, I have just updated FME: 2022 -> 2023 (2023.0.2 (20230727 - Build 23338 - WIN64). Checking that this upgrade doesn't cause errors when running several important processes, I see this warning message in the log of one of them: POSTGRES Writer: Renamed user attribute 'attribute{0}.fme_data_type' to 'attribute{0}_fme_data_type' based on format constraints for invalid characters, length, and casePOSTGRES Writer: Renamed user attribute 'attribute{0}.name' to 'attribute{0}_name' based on format constraints for invalid characters, length, and case This message was absent with the previous version. The transformer concerned is a FeatureWriter whose parameters are shown below. It has two upstream branches: one for table schemas, the other for features. Adding all these entries to the log file slows down processing considerably and, when many features are processed, the file can even saturate the disk (up to 40GB!). I've temporarily deactivated t

1927

9 months ago

jaygrg111_Contributor

asked in Transformers

Write the dwg files to new created folder from PythonCaller

Hello everyone,I am converting several SDE geod to respective CAD files. All CADs need to be written in the same folder (with suffix of the currentdate). I created this folder in Python Caller. How can I now route CADs to this folder?

411

9 months ago

nicholasContributor

asked in Transformers

Can the OGC GeoPackage Writer write metadata?

Can the OGC GeoPackage Writer write metadata to the gpkg file?Particularly metadata that conforms to the ISO 19139 standardThe geopackage file would be holding a vector dataset, like roads or parcel boundaries

813

9 months ago

nicholasContributor

asked in Transformers

PythonCaller that replicates the Windows command of "Send to Compressed (zipped) folder"

Hello all,I am trying to build a PythonCaller that replicates the Windows command of “Send to Compressed (zipped) folder”The goal is to prepare a fileGDB dataset for transfer by ftp by zipping itI want to give the PythonCaller a filePath such as D:\2024\03\project\data.gdbWhich then creates a zip file D:\2024\03\project\data.gdb.zip (that is, the zip file is sitting in the same folder as the data.gdb)And, when the end user opens the zip file they see the folder data.gdb which they can then extractI am trying using this code def input(self, feature): import os, shutil folder = feature.getAttribute('folder') fileGDB = feature.getAttribute('fileGDB') zip_file = feature.getAttribute('zip_file') if os.path.exists(fileGDB): print('fileGDB exists') if os.path.exists(zip_file): os.remove(zip_file) else: print('zip file DOES NOT exist') shutil.make_archive(fileGDB, 'zip', folder)

444

9 months ago

martin_fme_userContributor

asked in Data

FTP/FTPS/SFTP transfer error: Timeout was reached

Dear readers, A colleague of mine is trying to extract data from an FTP server.Using FME for this process would be beneficial to a large part of our organization, since it would enable us to create ETL processes for FTP-data. My colleague encounters the following problem:FTP/FTPS/SFTP transfer error: Timeout was reached The settings he uses are:URL: <url links correctly to a .csv on the FTP server starting with FTPS://FTP>Transfer type: Download to a File Target File: <.csv on OneDrive that does not exist yet>File Path Attribute: _downloaded_file_path Connection Mode: Passive / Active triedTransfer Mode: BinaryVerify SSL Certificates (ftps/ftpes only): Yes Authentication Type: Password < username and password correctly set> Proxy Type: Use FME Network Proxy Settings My colleague received the following error:FTP/FTPS/SFTP transfer error: FTP: command PORT failed We guess that this is a question for our FME functional manager, but any thoughts on how to solve this probl

2171

9 months ago

oliver.morrisContributor

asked in Transformers

PostGIS writer, excluded fields with defaults still populate

Hi, thanks for your help in advance, I am writing out to PostGIS, inside the attributes I have a UniqueID and a date timestamp field which have default values set in Postgres. When I come to populate the table in FME, I do not include these fields in the writer but when I use bulk insert set to yes, the records are added and the fields are not populated. When I have bulk insert set to no the workbench fails and the insert statement had the attribute fields in the insert statement.How can I get round this - I just want FME to be blissfully unaware of these attributes so that postgres can handle the population of these attribute fields.Any help on this would be great.Many Thanks,Oliver

Excel Reader is reading data that is no longer there.

Good morning, I'm currently facing a really weird issue. In my workbench I have a Reader that is loading a quite large Excel file, containing multiple tabs. I decided to remove all the unwanted data from the Excel sheet and keep only the tab I really need. When I try to update the Reader feature types the Excel tabs that I just removed keep showing! I have tried adding this Excel sheet to a new workbench; same result. What I've tried so far: - Adding the Reader to a new workbench in 2018.1 and 2019 beta. - Purged temporary files in FME. - Restarting FME / computer - Ran Windows disk cleanupNothing helped, I'm still seeing the tabs I deleted. Cheers, Ed

20913

9 months ago

jeaner

asked in Transformers

Writing to existing GDB w/topo, feature class datasets and domains

I thought I knew how to do this but it broke for some reason. My workspace has a GDB that contains a feature dataset that has domains assigned to a few of the feature classes and it also has topology. I set up a simple transformer to sort and do an area calc. Then, I need to write back to that same GDB while keeping the domains. I recently lost the domains assignment and when I tried to update the workbench now it fails to write anything. I've tried multiple methods and each has a failure like 'cannot delete layer that has topology' or 'cannot make edits out of an edit session'. How should I set up my writer? I'm not sure I want to overwrite existing if I can help it.

942

9 months ago

jccaseyContributor

asked in Transformers

Esri ArcGIS Server Feature Service Writer not found

Hello. The WRITER called Esri ArcGIS Server Feature Service Writer does not seem to exist. The reader is there.. but not the writer This is not AGOL and not Portal - just “Esri ArcGIS Server Feature Service Writer” It’s in the documentation as existing and I do need to write out to an Esri ArcGIS Server feature service using a rest endpoint url Please point me in the right direction if I’m missing it somehow. If it’s not there, why not? The documentation is at https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/arcgisfeatures/arcgisfeatures.htmThanksJim

444

9 months ago

fbrennContributor

asked in Transformers

Extracting the last successful run from a table using FeatureReader

Hello all! Relatively newbie here.I think my question is simple but I am just struggling with finding a query for it. I have a table in an SDE. An example of the structure:object_id job_id update_start status1 xxx 2/15/2024 13:00:00 Success2 xxx 2/20/2024 13:00:00 Success3 xxx 2/25/2024 13:00:00 Fail I am using a FeatureReader to read this table and I need to extract the most recent succesful run from this table (i.e. in this case only row 2). I am using the where clause but it keeps returning me blank and I ran out of ideas. Any help is appreciated!Regards,

565

10 months ago

afrancioContributor

asked in Transformers

HTTP caller - POST to add Cityworks WorkOrder Attachment

I am trying to post an AGOL attachment (i.e. an image) to a Cityworks Work order using the HTTP caller. My goal is to post a unique image to a unique work order (i.e. an image of a sidewalk crack for a sidewalk work order, a pothole image for a pothole work order etc.). The issue starts with my file. I am using AttributeFileWritter to write the file. I use a variable from the feature layer to name my output file (i.e. @Value(WorkorderID).jpeg). This writes to my output directory with no issues. When I go to try and upload this file, when I feed it the PATH + file name + file extension it results in an error “HTTP/FTP Transfer: Failed to open file for resource upload”. When I explicitly “Select” the file it will upload without issues. My workflow is as followsI write the image file I make the callMy body call This body call is what throws the error. When I add the variable name with extension for the file I want it to upload, it results in the following error “HTTP/FTP Transfer: Fail

968

10 months ago

parke372Contributor

asked in Integration

Rest API response - how to map response headers?

Hi All,Fairly new to FME, and brand spanking new to Rest APIs.i have an API integration that i worked out in Postman, but, i’m struggling to translate that to FME workbench for use in an FME Server Automation.In postman, i have to use a GET to generate an antiforgery token, then use a POST to log in, a second GET to update the antiforgery token and then a second POST to send the actual content i want to .. uh.. send.now, in Postman, my request looks like:GET {{DeskAlertsURL}}api/xsrf/getwith the following auto generated headers:Cookie:Host:User-Agent:Accept:Accept-Encoding:Connection:and the actual request headers look like (i {{shortened}} some of them for readability):GET https://URL/DeskAlerts11/api/xsrf/getRequest HeadersUser-Agent: PostmanRuntime/7.36.0Accept: */*Postman-Token: acbb9ca8-9dc2-44b1-888e-63468a39523fHost: deskalerts.ipf.msu.eduAccept-Encoding: gzip, deflate, brConnection: keep-aliveCookie: .AspNetCore.Antiforgery.awpUR7lE5Fk={{Shortened}}; XSRF-TOKEN={{X-XSRF-TOKEN B

1733

10 months ago

david_Contributor

asked in Transformers

Dynamic SQLExecutor to dyamic FeatureWriter (CSV)

Hi,I have a SQLExecutor with a dynamic SQL Server query like:SELECT * FROM value(@table_name)Obviously, as it is a dynamic query I don't expose any attribute.Then, I connect the schema and generic outputs to a featureWriter (CSV).When I run the workspace, It finish suscessfully but It doesn't generate the CSV file.The same problem if I try to generate the CSV file with a dynamic writer instead of a featurWriter.However, if I replace the SQL Executor with a dynamic featureReader, the CSV is generate correctly.I need a SQL Executor because the query will be a bit more complex.I think It is something related with schema but I missing something.Could anyone help? Thank you un advance! Regards.

696

10 months ago

limoSupporter

asked in Transformers

How to convert 1 channel raster into an RGB raster?

Hi all, I have a GeoTIFF with 1 rasterband (UINT8) that has palettes with 3 values (RGB).Example: I will convert this tiff into a three channel (RGB) tiff.Is this possible with FME? thanks in advance!

552

10 months ago

dmitribaghSafer

posted in Integration

Decipher This (._;>;);

Please feel free to take your best guess about the title of this post in the poll. Then, if you are curious about the answer, check my new transformer OpenAIOSMReader and the LinkedIn article.

722

10 months ago

djclient852

asked in Transformers

Workspace runner with “wait for Job to compete” = YES and setting a number of the concurrent processes

Is it possible to run workspace runner with “wait for Job to compete” = YES and setting a number of the concurrent processes? It should work the same way as “wait for Job to compete” = NO with the only difference on the time of showing the success or failure of the process run.

1598

10 months ago

styx_a38Contributor

asked in Transformers

Attributes to Keeper as User Selection

Hello.Is there a possibility to read an ifc file, retrieve a list of all attributes (like it is present after running a workflow once and click on import from feature cache in the attributeKeeper), be able to select the ones to keep and keep only those in the writer? Or at least read a textfile with a list of attributes separated with , and use them as attributes to keep?I build a workflow to work with IFC data and at the moment I specifically create a “new” workflow for every file, manually adjust the attributeKeeper from the feature cache and run the workflow with the same file a second time. I do not know beforehand which attributes are included in the ifc file, and it can differ with each file.I already figured that the attribute keeper can’t work with user parameters. I tried using the Attribute Exposer with “Import from Dataset” or the Feature Reader Schema Output for a dynamic writer...but either I did not understand the answers given in other community questions or I did someth

971

10 months ago

galigisEnthusiast

asked in Data

Convert 'fme_aggregate' to 'fme_polygon'

Hi All, I’m struggling to explode/conver the fme_aggregate to fme_polgon. I have already used 2DForcer and GeometryCoercer already, settings in the screenshot below:This comes from a DWG file and I need to create the outline boundary as AOI,Any ideas?

1642

10 months ago

vlroyrennSupporter

asked in Authoring

How can I write features to a temporary table with a Postgres writer?

I have a dataset of features that I'm trying to insert in a Postgres (pg14) database. That data has a number of text columns that together make up a "report name" plus a timestamp. The name and timestamp together make up the primary key of that dataset. There are also some more columns that contain the actual data. The table I'm inserting this in currently has 800 million rows, and I'm inserting in batches of around 50k rows about a hundred times a day, so keeping indexes small is important. Given the above situation, the text columns from the "report name" have been put into a separate "dataset_reports" table" (~60k rows); with the timestamp and actual data being stored separately (with a foreign index) in their own heavily partitionned "dataset_reports_data" (~800M rows) table. In order to insert data in that table, I need to upsert dataset_reports with all the unique report names in my feature set in a first pass, then get the FK value for all these reports and then I can insert the

harishContributor

Hi Community, I am using some SQLExecutors in my workbench and the this is taking so much time to execute. Is there any way I can execute it faster. Is it because the statement going from fme to outside db and execute it in batches of 1000 and commits the edits making the whole delay?. Is it possible to execute the whole sql actions using a plsql script and bind it to fme?. I may also need to have logs or exception tables for plsql script. Is it possible through fme?

losancaContributor

Hi! I'm trying to transfer the information from the layers and tables of one geodatabase (with domains and relationships) to another geodatabase with a different data model. I need the GlobalIDs from the reader geodatabase to remain in the writer geodatabase. In some tables/layers, I manage to keep them by setting "translation type: none" and "preserve GlobalID: yes," but in others, it's necessary for the translation type to be edit session, and then the GlobalIDs are not preserved. Is there any way to maintain the GlobalIDs regardless of the translation type or in any other way?I have read several posts regarding this issue but I can't find a solution.thanks!

2132

10 months ago

a_ericssonContributor

asked in Transformers

Too many recursive macro substitutions

Hello! I have recently started working with FME Flow. I’m just testing the possibilities of writing to the Fme flow temporary resource directory, which causes the translation to fail immediatly. My script is just a reader, which in this case is reading from a shapefile, as well as a feature writer. The featurewriter is set to write to [FME_SHAREDRESOURCE_TEMP] and the response i’m getting when running the workspace is this: Has anyone encountered this before, and is there any hope for me and my workspaces in FME flow? Thanks!/Alex

2915

10 months ago

1
...
72
73
74
75
76
77
78
...
1108

Page 75 / 1108

Badge winners

arhayeshas earned the badge Welcome Back
mariakahas earned the badge FME Form Advanced Training
johnzhas earned the badge Welcome Back
k80goddinghas earned the badge FME Form Basic Training
philschas earned the badge Welcome Back

Show all badges

30,395: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.