FME Form

I tried FTPCaller using the full path to the file I want but I am unsure of authentication as it seems undocumented. I am unable to use username and password and must use SSH key files. Setting to ssh-agent seemed like the way to go but how do you choose your key file? I am publishing to Cloud anyways so I thought I would look at what was there and seems there is upload capability for sftp using a subscriber and ftp watcher (no sftp). Am I missing something?

I can see it in the reader parameters (Version From Historical Date and Time), however none of the attributes stick out as the correct one to expose.

I would like to know how many parts are part of the IFMEAggregate for each record. Are they always polygones? How many records contain lines etc.

Hi, @david_r​  help find a solution. I have a long line with a large number of segments, how could I extend the last sides of it, with the same angle, till the first intersection with another line or edge of the polygon.

How can we download the workbench from the FME server showing the output of each transformer in the downloaded workbench? I want to get the joins and unjoins from the databasejoiner transformer.

 I´m right now trying to learn the basics of FME and have been busy doing calls to open data in Sweden, primary published as json files. I have managed to read the, and explode a list and write back to an excel file. I now try a larger dataset of about 1 million rows. I can not figure out how to extract more than the limit 500 records. I have tried searching in the forum an Google without understanding how to proceed. I attach the links to the dataset below. I would realy appreciate if someone could show a setup that loops and writes all data to a csv for example.  Dataset:https://www.vgregion.se/ov/dataportal-vast/#esc_org=https%3A%2F%2Fcatalog.goteborg.se%2Fstore%2F6%2Fresource%2F1I

Hi, I have a workbench that joins and manipulates data, then at a certain point it reaches an aggregator and creates two columns:Column 1 output sample:20688<br>1476<br>14633<br>14516Column 2 output sample:560 Hague Street LAVINGTON NSW 2641<br>449 Smollett Street ALBURY NSW 2640<br>601 Stanley Street ALBURY NSW 2640<br>599 Stanley Street ALBURY NSW 2640After this aggregator I am trying to send an email which includes a simple output body like: 20688 - 560 Hague Street LAVINGTON NSW 2641 1476 - 49 Smollett Street ALBURY NSW 2640 14633 - 601 Stanley Street ALBURY NSW 2640 14516 - 599 Stanley Street ALBURY NSW 2640Any ideas how to get it from the simple aggregator with these two outputs into an email? 

OK, here goes.  I have some data in a SQL Server database but it is stored in an object-oriented fashion which means a normal SQL query doesn't work, I have to pivot data in order to create a traditional tabular view.  Now that in itself wouldn't be a problem, but all data is stored in the same location with each asset class (e.g. door, window etc.) having a different number of attributes, so depending on how I pivot I get the relevant attributes as fields.  All good so far?  OK, so I want to push this data from the source database into the target database (Oracle in this case) and the method for doing this is currently using SQLCreator to create the fields by which I want to pivot (based on the asset class as a parameter) and then SQLExecutor to retrieve the pivoted table, which works, up to a point.  What doesn't work is that the attributes of the output from the SQLExecutor are not exposed, and I can't get them to be exposed without Populate from SQL Query option, which fa

I am using FME 2019.2 to read multiple Autocad drawings (r.2018) and then write them out into a single combined DWG. I've referenced a template file with all of the block definitions in it for the writer, but cannot seem to get any of my CAD blocks to write. The log tells me that "AutoCAD Writer: 3189 feature(s) were rejected and not written to the destination dataset", but doesn't give any hint as to why they were rejected. I've tried this using both the RealDWG and Map OD readers & writers, and I've tried it both with and without a DWG Styler transformer. Why are my blocks getting lost in translation?

Hi, I want to create a dynamic workspace. I have an excel file and I want to execute everything from there. I want to send database information for sqlexecutor via excel. but I couldn't find how to add format and dataset information. Is such a thing possible? 

I work for a deck building company that consistently needs to find lot boundary markers, but due to lack of information sometimes we are unable to identify where the boundaries of a lot are. We are exploring and trying to find ways that we could easily find the part of the lot that is the physical boundary marker of the property. Assuming we are able to find longitude/latitude coordinates, we are looking for software that could allow us to enter that information in a smartphone in order to be guided to that point on a map on smartphone. Thanks for any input you may give!

Hi, I haven't used FME in quite a while due to the flu outbreak. I have FME 2017.1 and have found that it will no longer reach in to my SDE due to the Legacy deprecation from ESRI. Are there any transformers I can use in 2017 that I can use?

Hello FME community, I have a long number (see the picture). I want only up to 3 decimal places to be displayed. Thanks in advance for your help 

I would like to know if FME has a reader and writer that directly read and write data back to the ArcSDE database.

Hello, I have a large workspace and there will be more developers that will develop it.I was wondering if we can use Git from inside the workbench. A visual diff that would identify changes in nodes and their properties, like e.g. Node-RED does, would be extremely useful.We already have the project in Git and treat it like a binary file.

I was following this example to write/update the metadata from SDE.https://community.safe.com/s/article/working-with-geodatabase-metadata-writing-to-xml READER features: from SDEREADER metadata: from SDE WRITER: GENERIC (4 options: SHP, FGDB, DWG, KML) I was able to write both spatial features and their metadata to FGDB (using ArcGIS Catalog to view both features and metadata).But when I picked the output as Shapefile, the features were written out with a boundary (for lines, but not for points). E.g. I have a point file with 722 features it will be written as 722 features. If I write a line file with 1000 features then I will end up having 1001 because there is a boundary linework written as one of the spatial features.Also, the metadata wasn't included in the shapefiles (using ArcGIS Catalog

Hi all.I'm trying to expand an existing workflow, that outputs Shapes and TABs (and FFSs) just fine with an option to output GeoPackages as well. This does not go well.I'm using dynamic schemas, and merges the relevant schema information onto each feature. Then I use FeatureWriter with "Schema from schema feature" to output the data to a file, to be attached to an email. I normally use ZIP, but in this case I just want to use GPKG.The first problem is, that the writer ignores the request for dynamic schema, and attempts to output any and all exposed attributes.The second problem is that each attributes gets the data type TEXT(200).Is there a trick to have FeatureWriter outputting a Geopackage with dynamic schema ?Cheers.

Hello,i tried to read a mesh model in the format .osgb, but it doesnt work.The osgb-files are made with the SURE Software.As information it says "OSG Reader: Ignoring unsupported node".Regards Isabell 

FME API version of module 'NULL' matches current internal version (3.8 20200115)FME API version of module 'NULL' matches current internal version (3.8 20200115)Loaded module 'LogCount_func' from file 'D:\\FME2020\\plugins/LogCount_func.dll'FME API version of module 'LogCount_func' matches current internal version (3.8 20200115)InputStream::decompress(): No such compressor zlibError running translation.

I have to combine 30 sql tables into 1 while preserving globalID unique identifiers. These tables have slight differences in column names (i.e. GlobalID vs globalid or JobsiteGlobalID vs JobGUID). These need to be mapped during the insert. I want to be able to run this multiple times so I'm looking for an "if not exists" append transformer. Any recommendations? I've looked as FeatureMerger, but it doesn't seem to work with 30 readers. I've tried a simple append, but re-running causes issues.Thanks.

Hi folks, When working with XML files, often I find it really usefull to be able to use the XSD reader to directly structurize the XML in FME feature types, AND to be able to use the known XML schema to generate the correct schema (attribute names, list elements, data types etc). However, when working with the XSD reader, I noticed something peculiar, which I think might be a bit of a bug.  The thing is, when you select a feature path, FME will generate a feature type with all attributes/lists that are contained at that path.What I think is quite nice and usefull, is that when you select both a feature path and a subpath of that feature path, the attributes/lists that belong to the subpath, are not included in the feature type of the parent path.  So in my case, when I select only 'msg:GMW_PPO' for the feature path, the feature type contains all contents of that feature path, including a list attribute for the su

I have a layer with 75 parks. I need to buffer all of them with 300 meters. But after this I need to clip the buffers with roads and railways(barriers). When I done this I only want to keep the polygon that are on the right side of the road. Sometimes these areas intersect an other park. So if I go for spatialfilter areas are kept even though they should not be. On the pictures below I only want to keep the selected polygon(yellow) because that polygon are intersected of the orgianal park. I've tried group by i spatialfilter but get no success. Is it possiable to solve this? Have attached my workbench with orginal data.  best regardsJesper

I PyhtonCaller that renames some feature classes/tables once they have been loaded to SDE database and checked using arcpyWhen I run the workbench on FME desktop I have not troubles, but when I publish the workbench to server the feature classes/tables can not be found. The Error is ArcGIS Pro: 000732: : Dataset does not exist or is not supported. As the arcpy works on my desktop, this would indicate that the paths are correct, but I may be missing something needed on our server.The environments areDesktopFME 2021.0ArcGis Pro 2.6.1Python 3.6.10FME ServerFME 2021.0ArcGis Pro 2.4.2Python 3.6.8 One of the paths is \\\\tnad.tasnetworks.com.au\\share\\Applications\\ArcGIS\\SDEs\\Dev\\BaseData_gisadmin_gisdbsdev1.sde\\BaseData.DBO.land_district Only difference between the paths is the feature class/table name and some have a Featu

Hi, are there any plans for implementation of the following raster formats in FME: • USDZ • 3dsMAX • PLN (ArchiCAD) • 3dm (Rhino) • C4d best regards Thomas

Is there a way to read SAS tables without the Stat/Transfer application?