FME Form

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! 

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

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?

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?

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?

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.

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

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

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 

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 .

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.

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.

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 ?

https://firebirdsql.org/

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?

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? 

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

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.

@Andrew.griffin@gmail.com

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

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

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 D

 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.

I can group separate features together for labelling purposes and this is what the attribute looks like as an autocad_mtext_string However, I can only assign one colour by using this approach.How can I assign separate colours to lines of text within a grouped mtext string so it looks like this? 

Hello,I am using the chart generator with some small numbers to make a scatterplot. I can't figure out how to display the axis values in scientific notation. See the example chart generator output image below using some made up values. The Y axis values range from 1.0e-3 to 1.0e-9. I would like to change the axis values to scientific from decimal.   Thanks for the help