FME Form

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> 

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.

Does anyone have an example of how to successfully write out to 12d XML? 

I have a polygon .kmz over a portion of New Jersey USA setup as LL-WGS84. I need to create a 3m x3m grid across the polygon. I am using a Reprojector to *XY-MT* and then a 2DGrid Accumulator to build the grid. The resultant process only creates 1 grid. What am I doing wrong?

I haven't changed anything to these Excel writers, but after having added some transformers to the workspace they suddenly all start writing to column E instead of A. Even after having disabled the new transformers they still do that. I can't find any setting explaining this (I haven't set a start column, for instance).

Hi, I'm wondering if something is possible at all in FME. I have two parallel 3D lines on a railroad. A "left" line and a "right' line. I want to create a new line at the center of these two lines (the railroad center)Once this is done I would like to resample all three lines together so that they all have vertexes that are perpendicular to the center line.  This is exactly what the Topodot tool "center line extraction" does if you adjust element vertices. I was wondering if it is possible to do in FME so I can automate it. I don't have any python skills to make something The result would look like this Any advice would be appreciatedThanks

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    

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   

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.  

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. 

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?