Data

Hi,I have a .add file that I just could open it as a text file in FME. Do you know anyway to read this file as CSV? Or a way to replace all spaces with one space?There are irregular spaces between them, and when I open it as a CSV, it is not a helpful file.I tried to use SrtingReplacer to replace many spaces with one space, but there are many different numbers of spaces in each attribute.Thank you for your assistance.

FME Workbench ver. 2021.2.3, build 21812FME Server ver. 2021.2.3, build 21812Hi Everybody.Sorry for my Canadian French, I try to be correct as much as possible in English, you may notice some errors on my part.Yes, I know, we should migrate to FME Form/FME Flow. The steps have been initiated with our supplier but we must wait until the migration from ESRI ArcGIS Desktop 10.8.1 to the ESRI Enterprise 10.9.1 version is completed. Premises:We maintain data that we share on a feature service hosted on ArcGIS Online with a subcontractor (different types, SQL Server, GDB and Shapefiles); The address of the feature service must remain constant for the processing of our subcontractor; The initial creation of the feature service goes correctly (an FME Workspace process launched manually for creation; We must replicate the update autonomously on our FME Server (same version as the FME Workbench, 2023.2.3, build 21812) so that the data is up to date over a 72-hour period.The update workspace fail

I need to set up a workspace to write a file directly into a specific Feature dataset within an ESRI File Geodatabase - is there any way I can set this up.

HiI got an ZFS Pointcloud (here) with integrated RGB colors. These are greytones (concrete) and visible in Autodesk Recap. From Recap i can export the PointClound to an e47 file and the colors are still included.But i got over 1’000 files, so I want to convert them with FME. With the ZFS Reader i can load the PointClound, filter it with the header information as decribed in the help (reflection), but the color is missing. Regarding the help, FME can read the color from an color file, linked in one of the header information, but I got no such files, the colors are integrated. How can I get access to these RGB values (color_red, color_green, color_blue)?

Hi everybody,I have a map with 'Layer A' (polygons district boundary) and 'Layer B' (lines roads).I would like to add a field on my 'Layer B' table with the name of every district crossed by each road.In this example, I would like my Road 1 attribute to tell me it crosses 'City A', 'City B', 'City C', and 'City D'. And my road 2 attribute to tell me it crosses ‘City A’.Could you please show me how to make it? Thank you  

 Hi, How can I shorten a line by 10 cm on both sides?

Getting the below error when trying to write the IFMEMultiSolid to Multipatch. I’ve tried to deaggregate the geometry but that didn’t work.The 'HAS_Z_VALUES' keyword is set to 'AUTO_DETECT'. With the exception of MultiPatch feature classes, the dimensionality of new feature classes will be based on the first feature written to the feature class. (Features with no geometry are considered 2D)A default z-value of '0' will be used for all 3D features where z-values are not providedEsri Geodatabase Writer: Not simplifying geometries being writtenTransactions are being used by the Esri Geodatabase WriterEsri Geodatabase Writer: The field 'OBJECTID' in table 'Dissolved123' will not be updated since it is not editableProcessing on a solid has failed. The solid may be too complex, not closed, or not orientable.Esri Geodatabase Writer: Failed to write geometry to MultiPatch feature class `Dissolved123' +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `Diss

Hi, I am trying to do check if data is correct in one of my tables compared to another one. To do that, I thought about merging/joining the two tables based on columns and conditions. The common column between the two tables is the City Code (postcode). Then I need to compare landmark values, which represent the location of objects in space. I managed to join them based on the City Code column but I don’t manage to do the landmark values comparison yet.  More context:My actual data is fields of grass along roads. Each section of road belongs to a city (City Code) and is separated into categories of landmarks. For example a road within city 1 is separated into groups of landmarks ranging from 1 to 1.5;  2 to 3; etc.; and the field X is situated at a specific landmark value 2.5.So the field should be in the landmark range 2 to 3 because its landmark value is higher than 2.  The tables: The first table has 3 columns and links city code and landmarks to a unique ID: City code: the city pos

Hello FME community,When creating a DWG file I would like to write some attributes to it. It is important that the written attributes appear in the properties of the object.The following picture shows more precisely what I mean. I want Attribute 1 and Attribute 2 to be appended to the DWG file.Does anyone know how I can attach attributes to the DWG file.Thank you

Hello , I would like to generate constant unique id for lots of points or lines that has not get  the id yet and keep the same constant unique for each time running FME (no change)i do not want any changing of id for each running Fme .lines or points should get constant unique id and after one month when I run Fme workspace and there are new lines or points .FME should provide the same constant unique id for old points or lines that provided them before and provide new constant unique id for new lines or points .The problem I am generating points that they are not exist before at GIS data and I am not able to save the points with id in Gis database but I want to keep the id for each point without changing in Fme thanks in advance fme 2021 

Hi, I want to find duplicate addresses in the data based on duplicate address numbers.The way that I found in ArcGIS Pro is using spatial join of the layer with itself using attribute matching “address number”. This way if a point has a duplicate with the same address number in the same location, is joining with the point with the same address number and if a join count is more than 1 display, there is a duplicate. I am looking for a way to do the same step in FME. I used SpatialFilter but did not get a result. I really appreciate any suggestion for doing this analysis.Also, in ArcGIS Pro, it is possible to join spatially "within a distance". Is this option available in FME?

Hello ,i have self intersection at specific line .but Geometry validator did not catch it .I have read at other article that it is better to use chopper vertex 2 and snapper segment to let geometry validator to detect self intersection issue ?I have tried it but it does not work .is there other suggestion that I have to try ?FME 2021thanks in advance .

Hello FME members,I have an IFC file with no coordinate information in the site feature.it is a 3dObject of a parcel that is supposed to represent the surface - but it is just a (3dObject) flat surface with an extrusion of 1]What I have done: I have at least 4 coordinates to transform, I tried to use:the 3daffinewarper, but the transformer showed me an error [because the transformation from 0,0,0 to x,x,444.1 is coplanar - and I only have 4 known points that went from z:1 to z:443] (I also tried 0,0,1 to x,x,444.1, but it didn't work) so I used the affinewraper to send the surface to the correct coordinate system)that worked!i need to know how to get the 3d object to the correct z value to display the surface (3d object) at the correct height.I hope someone can help me.Greetings Michael 

Hi,I have a dataset with Centerlines shown in blue, some lines contain too much detail which is not accepted as input for the LineDivider I use in the downstream pipeline.Is there a way I can smooth the blue centerline into something like the red line shown on the right?The Generalizer should be the way to go I guess but did not find the right settings yet.  

Has anyone successfully created a workspace that can convert Ordnance Survey MasterMap data to dwg format? I understand the process would be quite complex, but it would be good to get an idea of what’s involved from anyone who may have done this.

I'm creating a new excel file nightly and some nights there will be no data to populate the excel file, but I need the file to be created anyways. Is there a step in the Excel writer that I'm missing to do this?

Hi,I'm using a FeatureWriter to insert data into a PostgreSQL database. When certain features can't be converted into the desired data types, FME drops them without terminating the translation.The logger gives a message in blue:"Value of attribute 'test' could not be converted to type 'bool'. Feature will be logged and skipped" However, the issue lies in trying to capture this scenario and terminate the translation.Despite dropping some features, the FeatureWriter when outputting the summary feature still contains the FULL COUNT against the '_total_features_written' attribute. I was intending on comparing this number to a count of incoming features to check for a difference. Now the only other way I can think of is querying the database immediately after and getting the written feature count that way. I guess I have two questions:1. Is there an inbuilt way to halt the translation when a feature is dropped like this?2. Is the _total_features_wri

Hi guys,is it possible to compare two filegeodatabases in FME? In each fgdb are 443 feature classes (points, lines and area feature classes). After some testing with the first vesion of the fgdb, we had to update the fgdb in some feature classes and changed some attribute fields and add some new domains and values. Is there any transformer which can show me the differences between both fgdb’s?Thanks for answering in advance.Cheers,Fabian

I'm using a FeatureReader to read a wfs service and getting strange failures.The following error is being loggedHTTP transfer error: 'Failure when receiving data from the peer'XML Parser error: 'Error in input dataset:'https://data.linz.govt.nz:443/services;key=xxxxxxxxxxxxxx/wfs/layer-53382?SERVICE=WFS&VERSION=2.0.0&REQUEST=GetFeature&TYPENAMES=data.linz.govt.nz%3Alayer-53382&NAMESPACES=xmlns%28data.linz.govt.nz%2Chttp%3A%2F%2Fdata.linz.govt.nz%29&BBOX=-36.939824852066955%2C174.70954193086246%2C-36.91494916200109%2C174.76090622708065' line:1 column:121683 message:unexpected end of input'The XML Module halted on error, see the logfile for details<WFS> An error occurred while reading a GetFeature response, to ignore the error and avoid losing the previously read features, set the WFS "Ignore GetFeature Error" parameter.  Total features downloaded: '0'A fatal error has occurred. Check the logfile above for detailsAccessing the link and checking the file manually

I have manage to export shp in file geodatabase with datasets but now it seems that i have a strange problem (or bug).every shp that i have exported is missing 1st entry in geodatabase. lets say a shp file has 10 points then i’ll get only 9 points in gdb and the one is missing is always the 1st pont in shp file. every shp file is missing that 1st entry.the strange thing is that fme shows in information that it wrote all entries that the shp files has but somehow 1 is missing.there is absolutly no error in logs. i get some info about some fields that i don’t export anyway. i really have no idea why this is happening.the shps are also exported with FME from othe types of data.for writer i use Esri Geodatabase (File Geodb Open API) with some schemas that i read from a template database with featurereader and join it on shps (no schema was readed).so what im doing wrong?why there is no error about the missing entries?

How ı Cut the fme polygon from fme aggregate?You can find the photo attachedturquoise color object is fme aggregate .purple colored object is fme polygon .I want to cut below the yellow line. 

Hi,I am trying to add a timestamp to a file, which is being written using feature writer. The workbench is on a shared data directory with a Flow Environment.I have seen other options of using fanout option but seems like they are limited to writers only.I just need a simple timestamp on my text-file when its written so that I can keep records of what is being written.I also have made a timestamp attribute using DateTimeStamper and DateTimeConvertor but don't know how to add that to the file name.Any pointers will be appreciated.Thank you

I’m attempting to automatically add three lines to the start of a processed data set, in order to create a batch file.There is probably a very simple solution but any help would be appreciatedThanks 

Hello everyone,I am a beginner with CityGML and am currently trying to convert a dataset to CityGML 3 with generics extensions using FME Workbench. However, I am encountering a couple of issues:Warning about inheritance relationship: The output gives a warning indicating no inheritance relationship. I have used AttributeMerge to add gml_parent_id, but the system does not seem to recognize it.<GML_2 Writer> - '12482' orphaned features found, XML comments representing these features will be present in the output file: <!-- orphaned feature - parent id:'...', id:'...', type:'...' -->Geometry export issue: It does not export correctly after setting up the geometry. In the Inspector, the data appears as a table without geometry.Additionally, the original dataset complies with the CityGML 3 standard, and its geometry's encoding is Name (encoded: UTF-16LE). Could this encoding be affecting the process?My settings and the transformer export are shown in the attached image.I would g

Title!i’m trying to import shp files into a gdb database in separate dataset based on the folders that the shape files are located. i know i’ve read somewhere in the help to set dataset/feature name for feature name but its not workig.i get an error that its not possible without coordinate system. so i’ve added coordinate system to writer but i still get the same error.the error isFileGDB Writer: Cannot currently create feature datasets with unknown coordinate systems. Please specify a known coordinate system, or do not write to a feature dataset. Failed to create feature class 'B10/Shape_Z'so is it possible to write datasets in esri geodatabae with  Esri Geodatabase (File Geodb Open API) writer? if so can you post an example.