FME Form

HiI am migrating data from an Oracle Spatial database to PostGIS with FME.One table has a 3D geometry column. The features are read correctly as 3D from Oracle, in the visual preview graphics view the are shown under "3D". In the PostGIS table the features are only 2D, if I query the geometry column as text it contains only POINT(2532341.58213 1155047.32385) geometries.Is there a was to force the writer to write 3D points?Thanks,Jean-Marc 

Hi all.I'm tasked with updating a table that contains 10+ geometry fields. I'm opening it as a non-geometric table, extracting one (of two) geometries, and reprojecting this to a variable projection, based on other field data and/or coordinate values.This all works well, but when I try to update the targeted geometry field in the database table, all hell breaks loose in FME.I've tried to use the formats "Microsoft SQL Server Binary", "OGC Well Known Binary", and even "OGC Well Known Text".I usually get an error message about mixing image and geometry field types, but now it just times out all the update commands.I've tried using a writer with "update", and the DatabaseUpdater, but both errs, so I've ended up with a SqlExecutor (with an UPDATE command), which unfortunately times out.

Hello,I need to copy files in PDF format from an office location to a web server, so that they are accessible in a mapping application.Each file corresponds to a point feature in a database table. Each entity has a serial number that corresponds to the name of the PDF file.I have built with FME the path and the name of each PDF file but I don't know how to go about copying it. I plugged a CopyWriter into the output of my processing but I can't seem to use it with an attribute-based destination. Can you help me, please? Thanks

Hi.When reading multiple geometries from a single table, they're joined together in a single aggregate geometry collection.The individual geometries can be extracted by using a Deaggregator, with each separate geometry having its original field name as its "name". Writing multiple geometries back to the table requires the geometries to be aggregated, and a MultipleGeometrySetter set to Yes.If updating such multiple geometries, I assume that FME extracts each geometry from the aggregate, and updates the (geometry) field values designated by the individual "geometry name" as field name ?So, if I have a table with 3 geometry fields (A, B, and C), and want to use geometry A to update field C with a new geometry, should I create an aggregate with all 3 (original A and B + new C), or can I just include the new C value in the aggregate when updating ?Cheers.

Hi,I just added an end-sql statement to some workspaces, each with a comment on the preceding line. The comment is a T-SQL line comment on a separate line, i.e. with prepended "--" (two dashes).This fails, as it seems FME gobbles up the first dash before execution, rendering the complete statement invalid.If this WAD og a bug ?Is it possible to add comments as "/* ... */" instead, or would "--- ..." (i.e. 3+ dashes) work ? It also doesn't look like line-feeds in the statement are respected, so maybe line comments are a complete no-go ?CheersLars

I have several CityGML files put in the same directory, each having several features: such as address, building, buildingPart, cityModel, groundSurface, roofSurface, wallSurface, etc.   I can convert them into OBJ files using Batch Deploy, which creates a new folder for each CityGML file and in which separate OBJ files are created for some of the features containing 3D geometry information, such as roofSurface and wallSurface, respectively, as shown below.  

Hi,  I have a shp file I convert and style to a Mapinfo Tab file. I now want to add the below metadata into the Tab file to set up a hotlink. I am not sure how I use these attributes, mapinfo_metadata{}.name and mapinfo_metadata{}.value to write to the Tab file, How do I do it?  begin_metadata"\\ActiveObject" = """\\ActiveObject\\Expr" = """https://aims3d.geomatic.com.au/#/home?username=username&password=Password&PanoID=""+Pan_ID+"" """"\\ActiveObject\\Mode" = "HOTLINK_MODE_BOTH""\\ActiveObject\\Relative" = "FALSE""\\ActiveObject\\Enabled" = "TRUE""\\ActiveObject\\Alias" = """Click to vie

How can i join and have only the attribute having xy coordinates in the output file?

Hi FME wizards, I am trying to do a datum transformation on multiple files in a nested folder structure and save the outputs using an identical name and folder structure, but in a new directory location. I've created a replica of the folder structure using DOS commands and trying to replace the existing root folder with a new one.  I'm reading the source files in from a CSV, then creating a new 'outpath' attribute in AttributeManager using the StringReplacer to replace the source root level directory, e.g. the part in bold C:\\Project\\CurrentDatum\\Model\\file.ext with C:\\Project\\NewDatum\\Model\\file.ext. The source and destination directory are Published User Parameters and I use the following in the text editor: @ReplaceString(@Value(_dirpath),$(Source_dir),$(Destination_dir)). When I view this as a new attribute, the directory appears correct. I've used similar logic in Python and it works great but not sure how to

I built a simple workflow that converts a DWG to KML. I'd like to write the KML file back to the same location I read it from. For example, dwg from path C:\\Users\\admin\\Downloads\\test.dwg, writes to C:\\Users\\admin\\Downloads\\test.kml It's simple to manually select the Reader file and Writer location dynamically using User Parameters, but I want to only have to select the Reader file and automatically set the Writer location/file name. Doing it this way would save a step if possible.

I am trying to do what is described in the question with a dynamic Geojson writer set as shown in "screenshot_1,jpg". However I get an error (screenshot_2.jpg).  

I want to take Revit file to QGIS via FME converter.But the coordinate system doesn't fit.So I want to find a solution. Thank you.

The XML Templater fails when I give a conditional value in the root template. XMLTemplater_3: Invalid Test Expression: TEST<at>Value<openparen>template_root<closeparen>=1 I have attached a simple workspace, any ideas why the conditional check fails?Thanks

Hi all, I have an XMLUpdater setup in my workspace, but it's painfully slow. I'm trying to update XML documents with 10k+ updates in some cases, but it will hang and take forever to complete. On average it's applying approximately 1 "Update" feature per second, meaning 10k "Update" features is taking close to 4 hours (with caching on but it's also slow without cache). The XML has around 200k lines (10 MB file) so that's not helping. I have tried obvious steps such as removing unnecessary attributes and the geometry from the update feature, sorting the order first, and limiting the numbers of calculations/swaps that the XMLUpdater performs, but it still seems slower than it should be...  I'm applying a "Replace contents" update type, with XML path of the format "//Element1[@name=fme:get-attribute("_att1")]/Element2/@_att2". The only way I can

I have a workspace that has several outputs, some of them need to be without any information so that at the end of the workspace execution, an email can be sent via emailer, how can I implement logic like this? Does anyone have an example?

I have a workspace which reads files from an SFTP location. I am using FTPCaller to connect to the SFTP. The credentials will change depending on the env i.e. different creds for dev, qa and prod.What is the best way to store credentials for the SFTP connection? Right now, I have these in a config file stored in Resources>Data. My workspaces reads this into a variable and then uses it to connect to the SFTP. However, this is not safe since:credentials are stored in plaintext in the config filethey also get printed in the log like every other property from that file.

I have a workspace with an FBX input (file attached) which is essentially a cylinder with oval ends with a few transformations which then writes to GeoJSON. It has a CoordinateSystemSetter transformation applied set to EPSG:6677.When viewing the GeoJSON ouput via Cesium we noticed the cylinder is just slightly out from where it should display.We believe this is due to the origin point not being the center of the cylinder.I have applied the following to try and correct the issue which does look closer:Added a CenterPointExtractor transformer (_inside_[x or y])Added a BoundsExtractor transformerAdded a Affiner transformer which uses results from the above two transformers to attempt to center the point of origin (only interested in the x and y axis). The Affiner is set to:1 0 -(@Value(_xmax) - @Value(_inside_x))/20 1 (@Value(_ymax) - @Value(_inside_y))/2 Any thoughts on the above if I am doing it correctly and how t

An automation that runs frequently on FME Server failed this morning with an error message I can't find any information about. Does anyone know what it means?  AUTOMATIONS writer: Reading FME Server response from channel failed with error number Reading FME Server response from channel failed with error number 392008.. Thank-you,Kathy

I have a point dataset, there is also an attribute with height values.I want to apply a buffer of about 15 metres which will only check which points are nearest. I then want to keep the point with the lowest value in height and only keep this point out of all the points which fall in the 15 metre buffer.How can I go about this in FME Desktop?

The Scaler transformer looks to be the sort of thing I need, but seems to scale the entire feature, rather than just the top face. I seem to remember, years back, a tutorial where 3D features were deconstructed, altered, and re-combined again, so maybe there's a solution that works like that? Thanks.

I am trying to get the KMZ file from the Website and download it to my pc. When I tried to get the file from pc and run the featured reader, I got only two features.  and this when i nnot add on its

I've tried about every combination of Source coordinates I can but nothing is coming out right. If I leave it blank FME just copies the coordinates from the source and doesn't actually reproject anything. Do I need a custom coordinate system for the source?

Hello there I have a Multipointgeometry feature I want to break down to its point component.Thanks  

hi!I have an excel file with 2 colums : on A : the name of the attributeson B : the valuesI don't succeed to create the attributes on FME and to associate the values.I tried with ListBuilder, Exploder, Aggregator, but I don't succeed.Can you help me?Thanks !