FME Form

how to extend and trim

Hi I want to know why this happens so I can correct it in the feature. I attached the example file "Excel" containing only one row so you can test for yourselfs.  In Excel both coordinates have comma. When I use Excel Reader in FME it changes only attribute value for attribute aa to a dot. But for bb its still a comma.This is maybe why I cant create a point using vertex creator, even tho I use string-replacer to change both values to dot or comma it refuses to create a point. This happens fairly often so It would be nice to know what cause this issue and how I can solve it. It might be a bug or something to do with Excel. If I create a new excel file and manually enter every value then it suddenly works. But this is not something I can do with an Excel containing thousands of rows. Iam using Fme 2020.2.5.0 Build 20827 - WIN64   

How to extend and trim

Hi everyone, I just started out using FME Desktop for my job. I am trying to find out how it would be possible to use group by based on a combination of attributes. The example is just something I thought of, so not based on real data. Initially, the source data in this imaginary case would just have an overview of all the shops. First, I would like to have an overview of the amount of shops per mall. So first I have to group by based on which mall the shop does belong to. Thereafter I would like to group by based on what type of shop it is. E.g. Clothing store, ~department store etc. So for example from the 100 shops that belong to mall A 10 are clothing stores for example , 4 restaurants e.g. i tried it with the StatisticsCalculator, however when I put put all these attributes in the group by field, I don't get the result below. Instead of grouping first on the type of mall and thereafter looking at the type of shop, all attributes are considered in the grouping equally. So

Dear FME community, I have an important question concerning the FME workbench. I would like to know how one can extract the coordinates of the intersection-points of a line intersecting an area (a mesh with poligons). The coordinates of the intersection-points should have a maximal precision.  To give you some more information about my problem I have attached some screenshots.  here you can see a part from my workbench. Basically I just want to somehow combine the mesh and the lines and then extract the intersection points.   here you can see the lines I was talking about above and the 3d-mesh. Now each line intersects the mesh at some point. I want to receive the coordinates of these intersection-points.  I would be very thankful, if you could provide any information on how to solve this problem. If you need any more infos, just let me know :)

I have a task where I need to extract data from a database and save it as a csv in SharePoint I had hoped to b able to specified the path to the SharePoint folder in the csv writer, but this does not seem to work.  The error I get is CSV writer: Failed to open file 'HTTP:\\\\projectzone.tnad.tasnetworks.com.au\\business-projects\\iap\\TE\\HVDC Cable Specifications\\SATVUE_99021037_2021_08.csv' for writing. Please ensure that you have sufficient privileges to write this file. If the file already exists, please ensure it is not open in another application I am using FME Server and the FME Server service account has permission to write to this location.

HiI generated a CityGML model in LOD 4 with its respective appearance using AppearanceSetter. I am trying to load the model to Cesium Ion but it loads without appearance. Can anyone help me with some idea to solve this issue.

I have an existing ArcSDE table with several fields but there is one field called 'state' that has no value. I want to assign the value 'NY' to this field with no conditions, so all records should have the field 'state' with a value 'NY'. I can do this in ArcMap or using SQL, but when I try it with FME using the Feature Writer it does not update anything to that field. I have an Attribute Manager that sets the value 'NY' to the state field, I then connect it to the FeatureWriter Feature Operation: UpdateTable Handling: Use ExistingUpdate Spatial Column: No Row Selection:Columns: state FME Desktop 2019 Thank you. 

Hi. I have a FGDB (esri) table and i want to reorder column. I try attribute manager to redorder column and it not seem work. Can you help me. Thank

Below software were installed...ArcMap & Arc Catalogue 10.8 with ArcFM 10.8.1ArcGIS Pro 2.864Bit Background Geoprocessing toolsFME 64Bit 2021.1.2 Build 21627 Data has been restored using SQL Server 2016 in server and I tried to add the writer using ArcSDE Geodb in client workstation. After selecting the writer format and entering all the required parameters and last by selecting the feature class name, neither writer is added nor error is prompted in FME environment. On the other end, I'm able to add feature class in ArcMap and add features but I'm not able to add feature class in ArcGIS Pro. Can someone suggest what is missing in my process... Thank you

I have a workspace that's reading in some data and I've added a counter after it. The Counter is giving me some valid count numbers, but a lot of the attribute are a weird string like this: `@Value(__fme_ft_return_valuebbc4ad18-5750-4f14-a514-caca849d5cc2)'

I am trying to download a Revit file from Azure Storage and pass it to a FeatureReader so it can process it, but I am getting fatal error```FeatureReader_rvt_2_<Rejected> (TeeFactory): FeatureReader_rvt_2_<Rejected>: Termination Message: 'FeatureReader_rvt_2 output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation''FeatureReader_rvt_2 (QueryFactory): Termination Message: '%0'AttributeFilter_3_Filter (AttributeFilterFactory): Termination Message: '%0'A fatal error has occurred. Check the logfile above for detailsPythonFactory output feature was rejected downstream. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for detailsError encountered while calling method `input'AzureBlobStorageConnector_CALLER (PythonFactory): PythonFactory failed to process fea

Suppose there are some features in different state, I want those features to be written like that: ABC_STATENAME_DATETIME.xls.,, so that all the features for a particular state are written in a separate file with datetime and all features in other state are written in other file like that. I tried using attributevalue and datetimeformat in feature writer but it was taking too much time because datetime was being calculated for million for features that were coming in. I just want it to be a 1 file with a final timestamp, not multiple. Any easy/fast way?

My first question is regarding the GeographicBufferer. There is a documentation page here on this transformer but I cannot find it in the FME Workbench (2021.0.3.0). Has this transformer been removed and/or its functionality incorporated into the regular Bufferer ? I was hoping the GeographicBufferer would be able to correctly handle the buffering of polygons across the antimeridian (180° E/W). The Bufferer seems to have a problem if the buffering crosses the antimeridian. Does anyone have an idea how to handle this case - maybe with additional transformers?  Attached please find a zipped geojson file which contains the coverage polygon of a navigational chart. Using the Bufferer and trying to buffer this polygon by 1200 metres results in an error on my side. What can I do to properly buffer this polygon?

Hello Community, I need to write objects in a versioning complex feature class, but FME gives me the following error: An error occurred while attempting to store a row into the table 'UTARC.FCL_S_MESSPROJEKT'. The error number from ArcObjects is: '-2146233079'. The error message from ArcObjects is: {Der Erfassungsmaßstab wurde nicht initialisiert.}

Hi everyone, I am experimenting with using the new BIM360 Docs transformer on Desktop to search trough a specific folder and download some files. The first step I want to perform is to use the list command in the transformer to get a list of available files so I can find the id of the files I actually want. Unfortunately I cannot get the list command to actually work. I can browse through my Hub, Project and Project Folders so I think the connection is working correctly. I have also tried the download command which is working correctly and letting me download a prespecified file. I am using FME Desktop 2021.1.0.0 and the workbench is a simple creator with Null geometry which is connected to the BIM360 Docs transformer. Action is set to List, I can select both the Hub, Project and Folder and the include subfolders is set to No. I have currently set the 'Attributes to add' to empty but this doesn't fix the error. The Error in the logfile:2021-09-17 12:06:22|   0.5|  0.0|FATAL |The below 

it's now possible to connect FME to SQL Server Analysis Services?

Hi! I need to thin out a uniform(?) point cloud where the points are spaced out evenly, the result should also be spaced out evenly. I tried the PointCloudThinner but it does not seem to do what I want. See attached pictures. The circled objects are the ones that need to be removed. I Hope I explained the problem clearly enough😊

Hello everyone,It's time for a weekly look at the latest FME news... FME AR UpdatesThe FME AR apps have recently had new versions released. FME AR Android v1.2 (1.2.0.13) is now available in the Google Play Store and FME AR iOS 1.7 (1.7.0.53) is now available in the Apple App Store.  So what's new? Well, you can find that information in the app store notes, but the biggest change seems to be in the format itself. The format at the core of FMEAR files was OBJ, but that's now changing.  According to the release notes, the Android version "added initial limited support for the glTF model written by FME AR Writer in FME 2021.1" and the iOS version "adds support for the new FME AR Writer in FME 2021.1 that replaces OBJ with USDZ data models". ArcGIS Data Interoperability BlogDid you know that the ArcGIS Data Interoperability extension had its own blog? Well, it does - and there are some great articles on there that are well worth a read. Of their recent &quot

Please vote if you need the 3d Studio Max format and you use it in your projects. https://community.safe.com/s/idea/0874Q000000TkuyQAC/detail

Hello, I am trying to create a workspace that takes multiple user parameters and reads Esri Shapefile using the feature reader. But I have problems using the Feature reader when the dataset is not hardcoded. This works fine, no errors:$(FME_SHAREDRESOURCE_DATA)\\$(ENV_NAME)\\sve_1milj_Sweref_99_TM_shape.zip\\svk\\riks\\*.shp But if I create another parameter called FME_SERVER_FILE_PATH and set its value to sve_1milj_Sweref_99_TM_shape.zip\\svk\\riks\\*.shp. So that the feature reader uses the dataset:$(FME_SHAREDRESOURCE_DATA)\\$(ENV_NAME)\\$(FME_SERVER_FILE_PATH) The Error I get is: Shapefile Reader: 'C:\\ProgramData\\Safe Software\\FME Server\\resources\\data\\3DViewer-Dev' is not a valid Shapefile and cannot be read Is it something I'm missing or maybe a bug? I am using FME Server 2021  

Hi! I am working on trying to automate a fanout for individual maps based on one point layer in ArcGIS Online. The maps should show one point per PDF with parcels and streets labeled in the background. So far I have been able to have a one page write out per point feature but the scale in the PDFs is extremely zoomed out to the point where all the point features would be shown. Additionally, the parcels and streets don't show on every page unless the _order field is set to the same number as the point feature. I am new to writing out PDFs and PDF transformers. I have tried using the PDFStyler, PDFPageFormatter, both Bounding Box transformers, and the sorter so far. I have tried to use the MapFormatter and was hoping if someone could tell me if that would be my best shot at getting the scales fixed. My two questions are: How do I set the scale for each individual PDF to be zoomed in to each point feature? How do I Include the streets and parcels in the background with labels? Than

I am working in an ESRI SDE geodatabase (SQL). I have a table with X/Y coordinates I successfully transformed to a point feature class. SDE is the owner of the feature class. New records have been added to the table but I am getting an error that the new records can not be added to the point feature class.I wonder what parameters I have incorrectly set that the new records are not being translated.

Hi, today I get a little bit of confused by the new Sorter Mode "Natural":Please, can somebody explain me, why the Mode Natural work like this?Thanks!

After change the version of WB from 2.7 to 3.6+, the startup python script doesn't work automatically. How we can enable it ? I changed the version of python script in both places (in translation part and Python compatibility part)