Skip to main content
  • EN

FME Form

A space to discuss FME Form

10000 Posts
bhk
Contributor
bhkContributor
asked in Authoring
How to Author A User Parameter to Select Which Writer to be used when having same Data source and many end point

I am writing a WS which is reading an Excel sheet for two Writers which are supposed to write in two different environments (DEV and TEST) As you can see since the source data is same I am using only one stream workflow instead of duplicating the transformers for each writer (DEV and TEST) I have created a User Parameter like this  Now, can someone please let me know where and how should I assign this into the workflow to select the endpoint (Which Writer to be used)?  Thanks   

260
bhk
Contributor
arthy
Contributor
arthyContributor
asked in Data
Python Exception <KeyError>: 'esriGeometryMultiPatch' when writing to Arcgis Portal

Hello I would like to truncate and write data to a feature layer on arcgis portal.I'm getting the following error and I don't know what's wrong with the workbench.  

300
evieatsafe
Safer
hasant1973
Contributor
hasant1973Contributor
asked in Transformers
No error message when having a typo in XSD driven XML Writer.

When working with XSD Driven XML Writer I noticed that I don't get an error message when I have a typo in the feature_type name or attribute name. It simply does not add it to the output. And this makes it very difficult to find bugs and problems.  Also the validation of the XML ends with a message that "something went wrong". But no details where and what.  Is it possible to list all items that could not be found in the XSD?Maybe some setting in the FME Desktop general settings? Thanks. 

110
deanatsafe
Safer
J
jkin
asked in General
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
daveatsafe
Safer
dustin
Influencer
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]) 

101
dustin
Influencer
M
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?

1310
M
hendriksdaan
Contributor
hendriksdaanContributor
asked in Data
What happens between FME PostgreSql writer and postgreSql running a query?

Hi, In my workspace I work with coordinates in different projections. I store them as numeric values. E.G. Geolat: 52.0324234. I want to write this to a PostgreSql database, which has the same type as is required for the value. Seems all good. But. When I start writing I get an error where it complaining about the input syntax is not of type 'numeric'. I see a query inside the log, Where it changes the value 5.2023617 from Longitude to " E'5.2023617' ". Which is a string. Which I dont require.  Does anybody know where to look at or how to solve it?

340
hendriksdaan
Contributor
philipwhitten
Supporter
philipwhittenSupporter
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?

80
philipwhitten
Supporter
V
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.

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.

40
V
M
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

1880
N
townest
Contributor
townestContributor
asked in Transformers
Table View: Failed to read rows due to 'No query Unable to fetch row'

I recently received the subject error. The error occurs when inspecting any downstream table of an AutoCAD dwg reader. The workspace appears to run successfully, then while scrolling down the transformer inspection table (in visual preview), the inspector suddenly throws an error and breaks out of the visual inspector table into the translation log showing the subject error. Clicking back on the table, and no records are shown past 100 (there are actually 1000s of records). Any ideas about what is going on? Thank you,TylerFME Workbench 2022.1

1030
evieatsafe
Safer
mferwerda1111
Participant
mferwerda1111Participant
asked in Data
SharePointOnlineConnector Type: 3, Number: 1, Message: Failed to get authorization header.

Any thoughts on why this Transformer would work, and then just stop working with this error when trying to browse Sites in the transformer ? Nothing has changed on eh FME Side, and I do not think anything has changed on the SharePoint side 

3360
mferwerda1111
Participant
rajaramk
rajaramk
asked in General
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
daveatsafe
Safer
S
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.

1060
daveatsafe
Safer
kyle_r
Contributor
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.

700
kyle_r
Contributor
sunsilk11
Contributor
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 ?

130
sunsilk11
Contributor
W
weilnich
asked in Data
Does FME support Firebird databases?

https://firebirdsql.org/

470
david_r
Celebrity
armando_amador
Contributor
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
armando_amador
Contributor
T
tforward
asked in Authoring
How to pass a user parameter to a custom transformer and used in a pythonCaller?

How does one pass a user parameter to a pythonCaller that's inside a customTransformerimport fmeimport fmeobjects def processFeature(feature):    p = FME_MacroValues['SomeUserParameter']    print p I read here "If you put your pythonCaller inside a custom transformer, the parameter name changes to {customTransformerName}_SomeUserParameter. "I tried then doing this below but still does not work.import fme import fmeobjects  def processFeature(feature):     p = FME_MacroValues['{customTransformerName}_SomeUserParameter']          print p What am I doing wrong? 

3020
jdh
Contributor
nedwaterman
Contributor
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

6950
nedwaterman
Contributor
f.kemminje
Contributor
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
nielsgerrits
VIP
A
andrewegriffin
asked in Integration
FTP CALLER How to use the transformer to list all .zip on sftp and download

@Andrew.griffin@gmail.com

61712
fmejamesl
Contributor
boubcher
Contributor
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
mattmatsafe
Safer
arthy
Contributor
arthyContributor
asked in Transformers
How can I publish images to arcgis server image using FME?

How can I publish images to arcgis server image using FME? I'm newbie on arcgis server image. Thanks

1480
evieatsafe
Safer
madeleine_rfs
Contributor
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

2460
madeleine_rfs
Contributor

Badge Winners

Show all badges

Community Stats

31,758
Posts
120,641
Replies
39,382
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.