- - Community Resources
Ideas
Product Updates
Events
Groups
Support
Knowledge

Home
Forums
FME Form
General

General

A read-only category for lost FME Form topics. We hope to move them shortly.

4,042 Posts
13,932 Replies

When you subscribe we will email you when there is a new topic in this category

4042 Posts

david_Contributor

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.

510

2 years ago

bhkContributor

asked in General

Overwrite Existing Geodatabase When Using ArcGIS SDE Geodatabase and FME Writter

When working with a File Geodatabase Writer, FME gives us an option(FME Parameter) to "Overwrite Existing Geodatabase" or not! Can someone Please let me know if there is such a option when dealing with a SDE Geodatabase?So how we can prevent duplicating (appending data again into existing dataset) when we want to load data into? 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!

740

2 years 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])

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?

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.

2 years ago

mauliem

asked in General

please guide how to convert pdf file to excel

The information in the pdf file has the same columns as the attached excel file

Hello All , we have the FME scripts to translate RVT to OBJ files . while checking the OBJ files we are able to see the unwanted hidden feature , like scope box and etc .

We have remove the object from Categories à "Scope Boxes" OR "Levels" OR "Grids" from (Categories).Need to search for the Hiding Temporary Items>> Search for: "temp" from Attributes: Workset, Comments, Mark.please let us know how can we remove the above feature , thanks for your support .

130

2 years 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?

1800

2 years 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

7000

2 years ago

f.kemminjeContributor

asked in General

create a polygon from many lines inside it.

I've got walls. dgn file. In the source dgn file, there are numerous lines that are utilized to form walls.I wanted to combine all these different lines into a straightforward wall. so I joined manually the outermost wall line to create a walls shape/polygon.In the attached sample file , source features and One straightforward wall feature is created in "merged wall" level/layer number 2(blue color) for ref. I just drew one simple polygon feature how the expected feature looks like. . Please, if someone can assist me.

256

2 years ago

boubcherContributor

asked in General

incident detector from steaming data

Hello Guys need your support with this case we are getting car position from streaming data 30 thousand points every 30 seconds, we use time windower to get the position of each car every 5 min, then we use a filter to check if this car entered the delivery zone,what we are looking for is to store the event when the car gets in and when it gets out and we have to store only one record for each event this event will be stored in the database as follow Crad_id start_time End_time StatusTK256 14:20 14:35 within when we store the event in the database the first time there will be no end time since the car is still within the delivery zone as soon as it gets out we will update the end time Any Suggestions we want to achieve something similar to this connector Thanks

130

2 years ago

madeleine_rfsContributor

asked in General

FME Workbench 2022.2.1 failing to install some packages from FME Hub

Hi FME Community,Has anyone run into this odd issue? FME Workbench 2022.2.1 (FME Python 3.10+).I did have issues installing transformers from FME Hub within FME Workbench, though it now seems to have resolved itself. (Note: removed sensitive but otherwise inconsequential information)Initially FME would throw an error similar to: An error occurred while installing Python package with 'pip install --force-reinstall --no-deps --no-index --find-links C:\Users\<user>\AppData\Roaming\Safe Software\FME\Packages\22776-win64\PackageFiles\safe.emailer\python --target C:\Users\<user>\AppData\Roaming\Safe Software\FME\Packages\22776-win64\python\safe.emailer --upgrade --no-compile fme-emailer' : Process crashed. An error occurred while installing package 'C:\Users\<user>\AppData\Roaming\Safe Software\FME\Packages\22776-win64\PackageFiles\safe.emailer'Sadly FME isn't more descriptive than this. Feedback for FME Devs: could FME print out the Python traceback when transformer instal

How to extract from a Lidar point cloud the local maximum Z and its X and Y coordinates for each building footprint ?

Hi,I am a beginner on FME and I have some difficulties.I would like to extract from my LiDAR point cloud, the local maximum elevation with the x and y coordinates of each building footprint.I have as input :- a LiDAR point cloud- the footprint of each building in format shp.As output, I would like to have a .txt file with the maximum z of each point as well as the x and y coordinates of the maximum, all in the same .txt file.I was able to extract the LiDAR points for each building footprint using the Clipper tool.Then I used the PointCloudStatisticsCalculator tool.I get my zmax for each building as a table. But I can't get them together in one .txt file with x and y coordinates.Would you have an idea to solve my problem?Thanks in advance.

Translation "Successful", but not ending after python post-script

I am experimenting with a new workbench that has python startup and shutdown scripts. Everything seems to be running successfully. I'm using FME 2021 as I need 32-bit capabilities for ESRI. After the workbench is done, I'm calling a python script that runs a series of SQL queries. The script finishes and FME says "Translation was SUCCESSFUL". However, the workbench is still running and I have to manually click the Stop button. Any thoughts?

390

2 years ago

viviancfhungContributor

asked in General

Translate from shp to gpkg

I want to translate a dataset from shp to gpkgThere is a id field in attribute table in shp file. I added the transformer "attributeRenamer" to rename "id" to "shp_id"It is success on 2022.0.2 versionWe can't see shp_id field in gpkg and the value in id field is keptBut in 2022.2.3 vesrionIt throw the error as 627 2023-2-28 13:03:03 | 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' Is any way can I fix it?Thanks

townestContributor

Greetings,I am getting thousands of warnings, and would like to understand more about them. Let's take these two for example and go from there. Can someone help explain what these warnings are and how to correct them?Also, are these warning slowing the run time down? The run is quite slow, and it's unclear to me exactly why.Thank you,TylerFME Workbench 2022.1

550

2 years ago

david_Contributor

asked in General

How can I read only cell A1 of an excel file?

I am trying to read cell A1 from an Excel file but FME Desktop seems to have a problem with that cell for any Excel. Example 1 (fail): Example 2 (success with other cell): What is happening with cell A1? Why can't I read it like the rest of the cells? Any help would be appreciated! Thank you!

I am not able to read ArcFM ArcSDE data in 64-bit FME

I have 64-bit FME installed and want to read ArcFM'ised ArcSDE data. I have ArcGIS Pro v2.8 on the same machine and 64-bit Oracle client as well. I was able to generate the .SDE connection file in Pro. However using the same .SDE file, I am not able to view the feature classes in FME. I am constantly getting the following error message "Could not open Enterprise Geodatabase. The error number from ArcObjects is -2147216072. The error message from ArcObjects is {Underlying DBMS error[Unknown error No extended error.]}" We also have ArcFm ObjectReader for ArcGIS Desktop 10.6.1a installed as well. What could be the possible reason ?

FME server update and configuration on server.

Hi Support team, Could you please provide temporary license to test the FME server V2022. So that we can tell user to run jobs on FME server for testing purpose. Please provide if you have any manual instruction and document for FME server update and configuration on new server.

2 years ago

embee

asked in General

Hello everyone, I am doing the geocoder exercise and keep getting this warning(see below). Any help would be greatly appreciated!

DEBUG: urllib3.connectionpool Retrying (Retry(total=7, connect=2, read=2, redirect=None, status=2)) after connection broken by 'SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1129)'))': /?format=json&q=Willow+Street%2C+Vancouver%2C+British+Columbia%2C+V5Z

770

2 years ago

gislinchuxianContributor

asked in General

Can machine B be like machine A to read gdb?

Hello FMEs, I wanna know how I can switch the license call variable.Can machine B be like machine A to read gdb? 1）Both have ArcMap 10.2.2 and ArcGIS Proin machine A & machine B2）machine A has FME x64 but can read gdbcurrently.3）machine B also has FME x64 but can not read the same gdb

We are experiencing FME server not processing jobs intermittently. Once it stops taking job requests, we have to restart the FME server services for it to start taking job requests again. What could be causing FME server to stop processing jobs?

340

2 years ago

djmcdermottContributor

asked in General

Workbench Documentation: Best Practice Template

Hello,We are slowly getting new users into using FME and building a catalogue of production level FME Workbenches . As a result, we need to start properly documenting them beyond bookmarks and annotations. I am looking for a template, advice or best practice. Things like description, reader/writers, data sources, FME Server components. Many Thanks, David

4100

2 years ago

scarterContributor

asked in General

Creating lines from (possible) WKD strings

Hello Group, I'm wanting to see if I can can create lines from what may be well known binary (WKB) strings (e.g.: 0xE61000000114297C137101D7B2BFE65D8A76C0BF494030842DCBFFD3B2BF70EC7899C0BF4940). To be honest I'm not 100% certain that they are WKB. I have a csv containing these potential WKB values. The workspace is... Creator>FeatureReader (reads in the csv setting the field called 'sp_geography', which contains the WKB value to varchar>GeometryReplacer (with encoding as OGC Well Known Binary and the geometry source set to 'sp_geography'). When I run it all 171 records goi to the Rejected port. There's a curious blue message in the log: "Invalid WKB encountered.... Last line repeated 170 times ..." This is odd as the WKD values in the csv are, as far as I can see, all unique.

190

2 years ago

Page 39 / 162

Badge Winners

hdnguyenhas earned the badge Student (Grey)
hdnguyenhas earned the badge Teacher (Grey)
rune.van.sevrenhas earned the badge FME Certified Professional
nasirhas earned the badge English Speaker
aidsterhas earned the badge Conversationalist

Show all badges

Community Stats

31,790: Posts
120,751: Replies
39,405: Members

Latest FME

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.