- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Search

Best Answers

9930 Posts

Recently active

Most views Most replies

michaelbreen

asked in Integration

Upload to SFTP goes missing?

Hi Community. I am putting together a workbench to upload specific (Plan) files to a SFTP and while I was there I thought I'd add in to download a list of existing files, match them against the options to upload and add/remove only what is necessary. So in summary:Get list of plans on network drive (file and path directory reader). Success!Filter plan name against spatial file (determines if plan is needed or not). Success!Download list of plans currently on the SFTP (FTP caller with SSH-Authentication). Success!Filter needed plan names against plan names already existing on SFTP. Success!Delete plan files from SFTP no longer needed (FTP caller with SSH-Authentication). Success!Upload plan files to SFTP that are needed (FTP caller with SSH-Authentication). No success yet. I'm happy to upload the template file I'm just not sure that will assist without the keys needed to access the SFTP (can't give these out). The creator/attribute manager are there for testing some of t

1633

1 year ago

viviancfhungContributor

asked in Transformers

Rename attribute when translation in dynamic mode and run in FME server

I want to translate a shp file into gpkg format, but there is a id(32 bit int in shp) field in shp file. I can't do it via FME serverIt throw errors of3792023-3-7 11:28:17 | OGCGEOPACKAGE writer: OGCGEOPACKAGE writer: For feature type 'd_y_n40', primary key attribute 'id' has unsupported type 'mediumint'. Primary key must have type 'int,PrimaryKey'I try to use AttributeRenamer, But it is not working.How can I use AttributeRenamer in this caseThe attached is testing dataset

224

1 year ago

salvaleonrpEnthusiast

asked in Transformers

Does anyone have a better way of capturing the first 30 lines of the translation log?

I need these translation log info to be part of my translation canvass so I can include them into the header of my report. I used to have this solution in place but I'm hoping to find a more efficient way to include the info in my canvass and not the shutdown. https://community.safe.com/s/question/0D54Q000080hedASAQ/using-the-processid-and-timestamp-as-my-log-name-failing-on-rename-with-py3x-but-not-27

How to use StringSearcher to find today's date in a list

Hello, i have a list of files from an FTP server that I have read into a List. The last field in the list is the file name. The file name generally follows this format: "ProjectInfo_YYYYMMDD". YYYY is the four digit year, MM is the 2 digit month, and DD is the 2 digit day. I want to choose the one that matches today's date. I'm guessing this can be accomplished with the use of a user param or regular expression but I can't seem to find a reference on it. Any assistance would be appreciated.

151

1 year ago

mlupienContributor

asked in Transformers

How can I get the ID of new row in a Non Spatial SQL Database

Hi, I am writing to a Non spacial SQL Database, using a FeatureWriter.When INSERTing new rows in the table, a UniqueID is created by SQL database.Is there a way to retrieve that UniqueID after INSERT completed sucessfully ?I would need the UniqueID for the next step of my Workbench.I do a SQL Executor to select the last inserted row, it will work, but, if multiple rows are inserted simultaneously, there is a chance that I won't get the right UniqueID. Any Idea ?Thank you.

854

1 year ago

afodContributor

asked in Transformers

Setting a single DateTime parameter on run initiation?

Is there a way to automatically set the datetime within a parameter and use it to fanout a dataset so that does not then create a folder for every minute the workspace was running. I just want the initial date time the workspace was run. The default date time parameter is not really ideal for this as it defaults to midnight and requires user input. I'm hoping to not have to use a workspace runner. Using DateTimeNow seems to create multiple folders as the outputs are written.

415

1 year ago

edhere

asked in Transformers

Can the Translation Log output be using in a workbench as attributes?

Hi all, I'm using the AmazonAthenaConnector to query an Athena database.In the Translation Log I'm seeing: "2023-03-10 09:04:27| 6.1| 0.0|INFORM|AmazonAthenaConnector: Query ran successfully. Run time: 5.225 seconds. Data scanned: 27694.09 kB" I'd like to use the info on the file size / Data scanned to do some cost calculation. 1: Is there a way to incorporate the output of the Translation Log as attributes in the workbench? Alternatively I guess I could load the .log file in a workbench and use that for the calculations... 2: I am wondering , can I run the main translation AND the .log file in the same workbench? (wait for the main translation to have finished so it can read in the log file and perform operations on that.)

1 year ago

kris_ab

asked in Transformers

neighborfinder with staked locations

Morning all,I have points (A) at the intersections of streets/lines. Also I have points (B) scattered everywhere. I need to keep location points A at intersections but would like to bring attribute information from points B. Point A can get all other points around it and stacked at this location.

Why is the FTP Directory Trigger not working when "Watch Subdirectories" set to "Yes"?

Hello. Using FME Server 2022. I have an issue monitoring our FTP. I want to monitor all subdirectories for changes. I keep getting an error where "/." is being appended to the "Path to Watch Directory" an infinite number of times. I get thousands of errors from the automation. Here is the error message:When I check into our ftp client logs, here is an example of the file path that FME Server creates: /upload/Directory/./././././././././././././. Why doesn't the trigger just detect and stop at the directories that exist?

355

1 year ago

tvaContributor

asked in Transformers

Search list for values on multiple attributes

Hi,The listsearcher makes it possible to search in a list for a certain value on 1 Attribute.Is it possible to do this (without listexploder) to search in a list for values on different attributes?list example:_names{0}.LC = Arabic_names{0}.NA = Latin_names{0}.PN = true_names{1}.LC = Arabic_names{1}.NA = Arabic_names{1}.PN = true I want to search in names list where PN = true & NA <> Latin and get that indexback. In this case it would be 1If it's not possible in FME, how would I do this via python in FME then?

Download Geometry Filtered WFS Data

I have tested 7 different ways to download all WFS points within a geometry and all give an error using FME 2023.0 Tried the "Initiator OGC-Intersects Result", "Bounding Box OGC-Intersects",Tried settings a Filter<Filter><Within><PropertyName>Geometry</PropertyName> ... GML Polygon Data ... </Within><Filter> Filter Overlaps etc.Filter BBOX with and without namespace declarationsFilter Envelope Nothing seems to be the right settings. I remember having the right parameters when using FME2019 but that doesn't seem to work anymore. Maybe my service is not responding according to specs?https://geodata.nationaalgeoregister.nl/inspire/ad/wfs?request=GetCapabilities&service=wfs

15910

1 year ago

aaronContributor

asked in Transformers

Syntax to extract children into attributes with XMLFragmenter

I am using an HTTPCaller to return some XML which I then want to turn into attributes. I can extract the Project fragment below using the XMLFragmenter (with Projects/Project in the Elements to Match parameter) but I haven't figured out how to directly extract the children into fragments or directly into attributes. Using Projects/Project/* doesn't work. For instance, I want to extract ProjectNumber and Status more directly into attributes. So far my solution has been to use a StringSearcher and SubstringExtractor to get each attribute. That's a tedious way to do it. Any advice on a better way? <?xml version="1.0" encoding="UTF-16"?><Project ProjectId="508DKDS6B2KA" ProgramId="YAK0C5V4UNVH" ProjectNumber="EST-00001" Status="Cancelled/Archived" StatusTimestamp="2021-04-01T12:23:55-06:00" LastChangeTimestamp="2021-06-29T14:15:01-06:00" ></Project>

212

1 year ago

david_Contributor

asked in General

Is it possible convert milliseconds to %Y-%m-%d %H:%M:%S?

How I can convert milliseconds (for example: 1663767945000) to %Y-%m-%d %H:%M:%S ? I tried with a DataTimeConverter transformer but it doesn't detect the input format. Any ideas? Thank you.

384

1 year ago

james_c_452Supporter

asked in General

Count distinct/unique component values of a pointcloud

Hi, I have a pointcloud where I want to count the unique number of values in a component. In this case I want to find the number of unique GPS time values in a point cloud (The point cloud is made from individual epochs of a lidar scanner, but there are time gaps so I cant use the max/min values) Basically is there something like the hub transformer AttributeValueCounter (which doesn't work on components). I do not know how to use python so I can't work out how to edit their method to work on components rather than attributes I can kind of do it by using the PointCloudSplitter and counting the files, but this is really slow Thanks

How to use FTPCaller to download a CSV at the beginning of a process.

Hello, new FME user here. I am modifying an existing script to download a CSV from an FTP site. I want this to trigger at the beginning of the process as shown in the diagram below. I want the newly downloaded CSV to feed into the CSV reader. How can I trigger the FTPCaller at the beginning of the script and how can I feed the new CSV file into the CSV reader? Any assistance would be appreciated. Thank you!

573

1 year ago

dustinInfluencer

asked in General

IF statement based on published parameter SQLCreator

In a SQLCreator, I want to return the records from a specific table, if a certain choice is made in a parameter. I have a published parameter "check_choice", that is a Choice Multiple Parameter. In this example, I want to return table records from BUILT_UP_AREA_S if 'BUA_Road_RTY' is selected in the parameter. The database type is Microsoft SQL Server Non-Spatial (JDBC) in my SQLCreator. The statement below results in an error Incorrect syntax near ','. What am I doing incorrectly in this statement?IF($(check_choice) LIKE "%BUA Road RTY%",SELECT * FROM dbo.[BUILT_UP_AREA_S])

1 year ago

mowo

asked in General

Read and write Shapefile in same workbench

Hi, the following problem: I want to update attributes of a shape file. To do this, I first read them in using a reader (regardless of whether it is a "shapefile reader" or a FeatureReader transformer), update them and then overwrite them using a writer. When I execute the Workbench step by step, everything works. If I run all steps at once, I get the error message SHAPEFILE writer: Shapefile writer: Failed to write to file '<pathToFile>\\Grid.dbf'. Please ensure that the file is not open by FME or another process, you have sufficient privileges to write this file, and that sufficient disk space is available. It looks like the reader is blocking the .dbf file. Does anyone have any advice on how to proceed?

643

1 year ago

philipwhittenContributor

asked in Transformers

In amalgamating different pipeline datasets I need to identify which pipes are duplicated. The FuzzyParrelLineFinder is not reporting a match for for some pipes that have identical coordinates. In what situations does the FuzzyParrelLineFinder not

I am sending the FuzzyParrelLineFinder 3 features that are lines with 2 coordinates only (i.e. start and end points). The coordinates are identical. The lines are 64 m in length and I am using the parameters of: Sampling Distance = 1 and Search Distance = .30. The FuzzyParrelLineFinder is not identifying the lines as matching. Are there situations where the FuzzyParrelLineFinder doesn't work or have I miss-understood the parameters?

1 year ago

vishnunv

asked in General

Hello everyone, I have an issue on writer section, the data process completed but doesn't export output data into folder FME version 2022.1.3 Please Find Attachment Any help and advice would be welcome.

1 year ago

sibe

asked in Transformers

I would like to know how I can transfer z-coordinates from nearest neighbour point features to all the vertices of a polyline in such a way that each vertex gets a unique z (so multiple unique z's per polyline)?

The Z-coordinates are not the same and varying. The points are located within a buffer of 0.1meter and extend over the entire area of the polyline. I have to join them based on a search area I think of 0.1 meters. The points are created from a las and transformed using the pointcloudtopointcourcer. As an example, I would like to have for this polyline which has 5 vertices 5 unique z-values from the closest points.

5112

1 year ago

kyle_rContributor

asked in Transformers

How can I calculate perpendicular angles of a line at points along that line and apply the angle value to each point?

I have a highway line feature class and a highway distance markers point feature class with points created at 2km intervals along each highway line. I am being requested to create a rotation value to apply to each point on the line that is equal to the perpendicular angle on that line at each point. This angle value will then be used to apply label rotations to ensure each label comes out perpendicular to the line feature it is on.

402

1 year ago

sunsilk11Contributor

asked in Transformers

DataUpdater not updating Oracle non spatial table

Hi, has anyone had an issue with updating a non-spatial Oracle (19) table. The table has been registered in SDE, hence has OBJECTID also.There is no failure, but the record is not updated. If I use an SDE writer with update operation, it works fine, but takes over an hour for 300K records. I am using FME Desktop 2022.1Any ideas ?

Does FME support Firebird databases?

https://firebirdsql.org/

271

1 year ago

armando_amadorContributor

asked in General

How can I insert images in html?

I´m using a Chart Generator to create pie and bar charts, and I need to insert them into an email created with Emailer inside the proper HTML syntaxis. I tried to write the charts into a png writer but I cannot link it to a parameter so it can be there.I also tried to set the image into a sharepoint (corporate) and use the url to link the image but it still do not work. Any thoughts?

1122

1 year ago

nedwatermanContributor

asked in General

Installed Python package not found

Hello,I have pip installed a python package to FME Desktop using the advice on the site:https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Desktop/Workbench/Installing-Python-Packages.htmThe package shows in the correct folder:However when I try to import the package into the PythonCreator FME tells me it doesn't exist:Can anyone please tell me what I am doing wrong?Thank you

5117

1 year ago

Page 69 / 398

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.