FME Form

The workflow looks like this: I'm downloading a .zip file via an API and unzipping it using the ZipExtractor. Connecting the ZipExtractor 'File' output to a Feature reader, I was hoping to be able to upload the gpkg-file from 5 different output ports to 5 tables in a postgis database. This works fine if I specify the geopackage file manually in the 'Output' section of the feature reader. Is there a way to use a transformer or to edit the FeatureReader to make it read the output ports directly/automatically from the gpkg-file in the folder the ZipExtractor has unzipped?  Thanks!  /Alex

Hi All, Does anyone have any experience getting a pointcloud out of PostGIS? We're using the PostgreSQL extension "Pointcloud" - https://github.com/pgpointcloud/pointcloud  Currently the data is stored in pcpatch data types and we extract it with pc_explode(column)::geometry. This returns to FME all of the individual points which if desired we can then recombine into a pointcloud.  But is there a way to get a pointcloud out *as* a pointcloud? I've tried PC_AsText, but the JSON it returns isn't GeoJSON so I can't just feed it straight into a GeometryReplacer. And there's no PC_AsBinary for the pcpatch datatype.  Anyone have any thoughts or experiences with this? Thanks, Jonathan

Hello, I have a wms that I'm clipping with a polygon bounding geometry. It work but the problem is that FME don't refresh the maps to the level of zooming of my bounding geometry. So It cut the whole planisphere and I have only one giant pixel as result of clipping ... how can I do to have a a detailed map ? Here is url if you want to test : http://ows.terrestris.de/osm/service

Hello Sir/ Madam, My goal is to run a batch processing so that I can count all the attributes in each input excel file in a particular folder. Then, I would like to output the result in a single excel file. Is it possible? My caseData - 2 excel files: A.xlsx & B.xlsxWorkbench: "Value count" by using statisticCalculator transformerOutput : 1 single excel file Problems that I encountered:1) I try to run the "Batch Deploy" in the workbench and it returns the result files indivdually. Can I group all the output into a single excel file? 2) In my workbench, May I ask how can I count all the attributes values? The "StatisticsCalculator" must defined the attribute name in order to do the counting. However, I would like count all the attributes in the excel file. It is because my input excel files may have slightly different attribute names in it. Thank you ve

When writing data to a zip shp. file often the data doesnt comply with the 3 decimal points put down in the CoordinateRounder. It usually ends in a couple decimals and then ending on 00001. In the AttributeRounder description it states that this is an issue that can occur: The CoordinateRounder may not always behave as expected, due to known limitations in floating-point computing. I am looking for a way to always make coordinates end on 3 decimals. The data comes from an Oracle Spatial reader, which after some transformers, goes through a Generalizer and then a CoordinateRounder before writing the data as a zip shp. Hopefully anyone here can help me out?

Hi I need some help with parsing the json response from the rest server api /transformations/jobs/completed with parameter competedState: failed What I want is a complete table with all attributes except TMI and NMI Directives. From PublishedParameters I only need subsorter and its corresponding value. This is a problem I cant solve. As it is now I can get subsorter and its value but no other attributes like "timeStarted". It would be great if it was possible to parse the whole json file and get a nice table with only 1 fragmenter. I attached a workspace where the json code is embedded as an attribute. Thanks in advance if someone could point me in the right direction. 

Could anyone help me understand why I get the following error. It currently occurs at a junction but if I replace the junction with a normal connector then it just occurs elsewhere so it doesn't seem to be related to the transformer. Junction_139_Output Feature Recorder -1 2147615843 (RecorderFactory): File C:\\Program Files\\FME\\metafile\\ffs.fmf could not be openedFile C:\\Program Files\\FME\\metafile\\ffs.fmf could not be opened I've tried running FME as an administrator in case that helped but got the same result. I also googled and found a similar issue but that related to just \\.fmf file and was apparently caused by databasejoiner which I'm not using. I've also uninstalled and reinstalled FME. If I disable feature caching then the workspace runs fine but that means I can't debug anything unfortunately.

Hello!  I have a CityGML dataset consisting of MultiSurfaces - atleast that is what FME tells me:  an example of a surface:  I would like to extract the surfaces' triangles, so each triangle has its own feature/record in the output.  So far i have tried 3 methods: using the deaggregator. Looks like it didnt do anything. using the geometryPartExtractor. I have extracted the "IFMEface" geometry-type from the surface, but this just looks like original geometry, where all triangles are one geometry. Afterwards i added another geometryPartextractor and tried to extract the IFMEPolygon - but this seemed to just remove the triangles from the geometry.

Hi! I'm trying to download a .zip-file using HTTPCaller. The zip-file is accessed via API by an order number generated when I placed the order for the data.  The response body looks like this: [{"href":"https://download-geotorget.lantmateriet.se/download/99d120aa-9532-43a9-a5a7-6128b333bc88/files/root/anlaggningsomrade_kn0125.zip?q=_9yzl22V_4v728pM........"}] (shortened down, was way to long to post here).  The 'anlaggningsomrade_kn0125.zip' is what I'm after. Is this possible? Any help is much appreciated 🙂   

Having recently disabled older SSL & TLS versions on our servers, fme desktop/server sql connections have broken. The workaround for other applications was installing OLE DB v19. I've tested this using a blank .udl file and confirmed it works creating a db connection with v19 but not the other. How do i get fme desktop/server to recognize this new version? As the error still suggests its using the basic oledb driver. The connection string fme complains about i think should have'provider' set to MSOLEDBSQL19 instead of just MSOLEDBSQL Any suggestions are appreciated! 🙂

Hi,I have a question regarding the AreaGapAndOverlapCleaner and I dont know how to solve my problem...I have multiple polygon layer which I want to overlay. The lines of the polygons are not totally coincident as different data sources are used. Many sliver polygons are created when the layers are overlayed. I would like to remove these small sliver polygons with the AreaGapAndOverlap Cleaner (it does it job well - I used a tolerance of 1 m). My only problem is, that the AreaGapAndOverlapCleaner itself creates some little gaps between the polygons. Is there a way to prevent the transformer from doing it? Using Fill All Gaps does not make sense in this case, as there are some big gaps (exclaves) that I want to keep. Do you have any idea to prevent the AreaGapAndOverlapCleaner from creating gaps? Or is there any other transformer which suits better?Thank you!

If I have a date field formatted as month-day-year is there a way to retreive just the month and use it in a tester? I want the user to input a month and then if it matches the month in the date field it will select all of those records. The data is in a geodatabase if that matters.

Hi !I have an xls file with 2 columns. One contains a code and the other contains numerics values. I would like to create an attribute that group my data when there are a break on the values and group by code. For example : code valuea 1 => group 1a 2 => group 1a 3 => group 1a 10 => group 2a 11 => group 2b 1 => group 3b 2 => group 3 I saw "AttributeRangeMapper" but I have to indicate the bounds. In my case I would like that the bounds are create automatically because my datas change every time.My values can be integer or decimal. Thanks ! 

Hi friends, I have an ESRI filegeodatabase with 3D multipatches. I want to cut out areas there. I have tried this with the clipper, but no result. Not only that, but I also tried extruding the clip extension. But also without result. Does anyone know the best way to clip this? Thanks!

I want the user to be able to select the tables to be read from a geodatabase. I added the reader using the single merged feature type. This gives me a list of tables for them to choose from. What I want to happen is depending on which tables are selected, it will output to a schema mapper which reads the tables and writes to a geodatabase. So, I was thinking I would want a tester but the tester doesn't have the ability to show the tables. Anyone have any idea of how this can be done?

I have a process were I need to create a downloadable zip file that contains a file that has an odd extension. So far I am able to create the folder, but the file copy writer is renaming the folder instead of making it a file with odd ext. I have added a picture to show how the folder displaying how the folder got renamed instead of changing the extension and making it a file.Thanks in advance for any feedback.

Hi.I'm working with a dynamic workflow. I have an ArcSDE reader and in some of my tables (I don't know which ones) I have a date (1899-12-30) that I need to set to null.My idea was to first filter the attributes with a date format, then filter the values and finally set the value to null.I know how to do it with one table because I know which attributes are set to date format. But with a dynamic worflow, how can I detect date attributes in all tables of my ArcSDE DB ?

So I want to delete the duplicates, or find the distinct combinations across two columns.I know I can do that with SQL on a database. But I just have a table here and want to do that directly in my FME script. Does someone has an idea?

I use XMLtemplater to design my XML file from Excel, but i have problem with the result:This result, it coincides with each output data field: I want to group like this:And this is my model FME:Anybody help me, pls !in my excel file, the fields "table_id" in sheet "table" and "table_id_field" in sheet "fields" are key fields to link these two data tables together

Hi,I'm downloading a bunch of text files from an FTP server and the contents of each file is stored in an attribute. The format of a text file is as follows : Station1;2022-04-12;09:00;Var1;True;30.4;Var2;True;0.5;Var3;False;0.0;Station2;2022-04-12;08:00;Var1;True;33.4;Var2;True;0.5;Var4;True;10.3;Station3;2022-04-12;09:00;Var1;True;27.4;Var3;True;0.5; What I would like to do is transform this text to a table as in the attached screenshot, but I have not found any easy way to do it in FME. Would you have any suggestions? Thanks! 

Workbenchs/ Connection String work fine on existing server. Moved them over to a new server and get: ArcGIS Desktop 10.8.1 and Background georproccessing 64 installed, TNSNAMES is fine, can ping to oracle server.  822022-5-13 12:41:01 | Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216028'. The error message from ArcObjects is: {No SDEHOME environment variable set}832022-5-13 12:41:01 | Please ensure the connection parameters are correct (server=`sde', instance=`sde:oracle$sde:oracle11g:ocspub', user=`encdirect', password=`***', database=`', version=`SDE.DEFAULT') Edit: added SDEHOME Variable C:\\Program Files (x86)\\ArcGIS\\Desktop10.8\\bin Still no good  FME Server 2021.2.5Build 21816 - win64

I'm upgrading from 2016.1.3.2 to 2021.2.5.I have geometry stored in PostGIS -> GeometryReplacer converting from Hex OGC WKB -> optional Reprojector -> Shapefile or FileGDB (both types). According to the log files, for 2016, there's barely mention of GeometryReplacer and Reprojector, but for 2021, there's a significant chunk of runtime devoted to passing through the two transformers. There's minimal changes to make for them to upgrade so it's bizarre why it's adding nearly double the runtime. (See log attachments) For production concerns, jobs are taking several more hours to run. Here's metrics for another dataset:2016:2021: Thanks,Janet

I'm having a few issues with the ESRI ArcGIS Portal Feature Service Writer (using the FeatureWriter). I'm writing to a known ESRI Feature Service using Branch Versioning, and I'm creating a new branch to make the edits in. Using FME Desktop 2021.0.3 (64 bit), I'm finding I can write the Inserts and the Updates to the service, but not any Deletes? FME is completing successfully, so the ‘call’ seems to be successful, and no errors seem to be returned in FME, but any Deletes just don’t seem to be appearing in the branch. I've checked permissions in ESRI, and the user does have editor permissions (including Deletes), and I've successfully deleted a feature using a Branch in ArcGIS Pro itself. Anybody had a similar issue, and if so, how did you overcome it? Many thanks,

I am trying to covert geotagged photos from a mobile phone and convert them into a KMZ file, every works great except the actual photos are not being inserted into the KMZ file... How do I fix this? 

I have added an extra column in the shapefile using attribute manager. How can I edit the values in that column?