FME Form

Hi all, In the attribute of my data, there is sometimes newlines and I want to trim them. I am using the AttributeTrimmer however it is not working. The data looks like this: {33}SCHOOL, BUS ONLY 8-10AM 12-4PM EXC SAT-SUN-HOL SEPT  THRU JUNE,I want to trim it like this: {33}SCHOOL, BUS ONLY 8-10AM 12-4PM EXC SAT-SUN-HOL SEPT THRU JUNE, Is my setting not correct? Best

I want to translate a dataset from shp to gpkgThere is a id field in attribute table in shp file. I added the transformer "attributeRenamer" to rename "id" to "shp_id"It is success on 2022.0.2 versionWe can't see shp_id field in gpkg and the value in id field is keptBut in 2022.2.3 vesrionIt throw the error as 627 2023-2-28 13:03:03 | OGCGEOPACKAGE writer: OGCGEOPACKAGE writer: For feature type 'd_y_n40', primary key attribute 'id' has unsupported type 'mediumint'. Primary key must have type 'int,PrimaryKey' Is any way can I fix it?Thanks

Hi y'all,I don't get it: I have a raster file with 3 bands: RED8, GREEN8, BLUE8, ALPHA8. The alpha band is either 0 or 255. There is no gradient. I need to hava a RGB24 raster with NoData, where Alpha is/was 0. The RasterInterpretationCoercer with "Apply the alpha band" will return these areas white. 🤷🏼‍♀️I already tried other solutions, but couldn't get what I wand.Can anybody help?

AllI am having trouble automating some workspaces as the data and folders that I receive are containing dates in the format MMMYYYY as shown below...\\\\server\\FMEData\\DataDownloads\\Supplier\\Data\\Data\\Name_Mar2020 The files are supplied as shapefiles and they are also named Name_Mar2020.shp etcHow can I automate the running of these workspaces for when the folder or file name changes to the next month?? I have tried using the * in various places, but to no avail and don't want to have to run these manuallyI know this is something obvious, but just cant figure it out... Regards  

Greetings,I am getting thousands of warnings, and would like to understand more about them. Let's take these two for example and go from there. Can someone help explain what these warnings are and how to correct them?Also, are these warning slowing the run time down? The run is quite slow, and it's unclear to me exactly why.Thank you,TylerFME Workbench 2022.1 

I've read the documentation on how to connect to Google Maps with an origin and a destination parameter; https://developers.google.com/maps/documentation/urls/get-started Now, let's assume that I have an Excel sheet with columns for origins and destinations, for maybe 100 posts. Is it possible to use FME to send these to Google Maps and then get each of the calculated travel times back, to create a "travel time" column for the excel sheet?

I have a polygon layer with overlapping polygons. These polygons have dates. What I would like to have is no more overlapping polygons.Where two or more polygons overlap, I would like to preserve the youngest polygon. If the size of the overlapping polygons are different, then I would like to cut out the youngest polygon and preserve what is left from the older polygon.

I am trying to read cell A1 from an Excel file but FME Desktop seems to have a problem with that cell for any Excel. Example 1 (fail): Example 2 (success with other cell): What is happening with cell A1? Why can't I read it like the rest of the cells? Any help would be appreciated! Thank you!

I have 64-bit FME installed and want to read ArcFM'ised ArcSDE data. I have ArcGIS Pro v2.8 on the same machine and 64-bit Oracle client as well. I was able to generate the .SDE connection file in Pro. However using the same .SDE file, I am not able to view the feature classes in FME. I am constantly getting the following error message "Could not open Enterprise Geodatabase. The error number from ArcObjects is -2147216072. The error message from ArcObjects is {Underlying DBMS error[Unknown error No extended error.]}" We also have ArcFm ObjectReader for ArcGIS Desktop 10.6.1a installed as well. What could be the possible reason ?

We sporadically get this error from the SDE-DB reader. We are using FME Desktop 2022, ArcGIS Pro 2.9.5, ArcGIS for Desktop 1.8.2 + Background Geoprocessing for 1.8.2.Log says the following:Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147220952'. The error message from ArcObjects is: {The Product License has not been initialized.}Please ensure the connection parameters are correct ([...])It could have failed to open because it contains ArcGIS Pro-only features, for example Arcade expressions. If this is the case, please install ArcGIS Pro or Pro-compatible ArcGIS Server and 64-bit FMEGEODATABASE_SDE reader: A fatal error has occurred. Check the logfile above for detailsFailed to obtain any schemas from reader 'GEODATABASE_SDE' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information

With the DGNStyler you can set a fill color, but is has to be a value. In Microstation there is an option to set 'No Fill' (see screenshot below).  Is it possbile to set a no fill directly in FME (with the DGNStyler or otherwise)? I tried a few things with 'igds_fill_color' and 'fme_fill_color'; however so far no success.   

I am working on developing a workbench to "warehouse" my organization's data on a weekly basis. The data is spatial in nature and stored in a SQL Server database. It needs to be moved to an Oracle environment on a weekly basis. Reading the data into the workbench has been very slow, especially for one feature class that contains around 9.5 million point records. During some testing, I noticed that when I remove the writer, the read time dramatically decreases (from around 40 mins to 10 mins). Is this expected behavior? Are there any ways that I can increase the performance of reading/writing these larger datasets?

I have parcel boundaries, And i need to create outer boundary for parcels using some attribute name. In my group there are 4 types of attributes will come (attribute value a,b,c, and d) so i need to create 4 outer boundaries.NO OVERLAPS on outer boundaries. and are gaps between parcels and sometimes parcels are far from each other. Pls anyone can help me? i tried hull , but hull overlaps some cases.

Hi, I'm trying to understand XSD Driven XML Writer and wrote a simple example that reads 3 CSV file with customer and address data and write a xml file containing all of the feature types. The resulting xml is empty when I run the whole process. Running "customers" only writes at least the top element into the xml. I connected all feature types with xml_parent_id and xml_id together. Unfortunately the error message is saying nothing that would help me to find my problem. Please help me with providing a information or repairing my work sheet.I could also not find any example for this problem.  

Hi Support team, Could you please provide temporary license to test the FME server V2022. So that we can tell user to run jobs on FME server for testing purpose. Please provide if you have any manual instruction and document for FME server update and configuration on new server.

Hi, I need to have parts of an othophoto in ECW format with absolute values. Previewing the raster in FME shows that the pixels have my preferred value of 0,0,0. When I write to geotif it works and I get the desired black areas with exactly 0,0,0, but not when I use an ECW writer. The black areas in the ECW have the black areas replaced with 1,0,1 or something similar.  TIF with mask at 0,0,0: ECW with mask at 0,0,0: I have tried disabling the compression on the writer and removing the alpha band, but the result it the same. Any suggestions?

I have an issue regarding reading of an Ifc-file with IfcIndexedPolyCurve. I get the following error message:"Skipping instance #76275: Instance is not syntactically valid."Row #76275 (and #45512) looks like this in the Ifc-file:"#76275=IFCINDEXEDPOLYCURVE(#45512,((1,2)),$);""#45512=IFCCARTESIANPOINTLIST2D(((0.0,0.0),(529.509035052,0.0)));" Any clues? I think that the Ifc-file is exported from ArchiCAD. //Johan

I got a fgdb dataset which is multi-layer. Some layers are the table without geometry information.I tried to convert them into shp file.But it is failed. And the converted layers are crashed also.The attached is the datasetThis is error message.Thanks  

Hi.I have a html report from FGDB feature class. I want to symbolize the data by field. Can i do that ? Thank for help.

DEBUG: urllib3.connectionpool Retrying (Retry(total=7, connect=2, read=2, redirect=None, status=2)) after connection broken by 'SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1129)'))': /?format=json&q=Willow+Street%2C+Vancouver%2C+British+Columbia%2C+V5Z 

Hello FMEs, I wanna know how I can switch the license call variable.Can machine B be like machine A to read gdb? 1）Both have ArcMap 10.2.2 and ArcGIS Proin machine A & machine B2）machine A has FME x64 but can read gdbcurrently.3）machine B also has FME x64 but can not read the same gdb

Aside from 2 sparse mentions in FME docs and a video discussing how to use the JSON Reader to parse a STAC that might be hosted out on the net somewhere I don't see anyone talking about FME and STAC - Spatial Temporal Asset Catalogs. Is anyone been working on tools, in or out of FME, that build said catalogs? We've got ~20 years of imagery stashed here and there on our servers. It would be good to get them indexed in a STAC to increase discoverability within our org. (And for those which are not contemplating building Stacs, what are you doing instead?)

I am just starting to test out 2022.2. Using a ODBC 3.x connection with SQL executor and getting errors I have never seen before. .....was skipped as it was not a valid SELECT statementBADNEWS: Attribute name 'fme_type' removed from schema feature as it doesn't have a type. Current value is 'fme_no_geom'(C:\\code\\fme\\foundation\\framework\\control\\metamap.cpp:1872) class StatusInfo *__cdecl STFMetaMapper::mapFeature(class STFFeature &,bool,bool,bool)BADNEWS: Cannot convert null string into an integer(C:\\code\\fme\\foundation\\framework\\util\\stf\\stfutil.cpp:347) class StatusInfo *__cdecl STF_stringToUInt(const class ObsoleteString &,unsigned int &)... Last 2 lines repeated 40 times ... The query still runs and I get results. The query works fine in 2021 with no problems.The job runs multiple statements and I don't want 1000+ errors every time the job runs.If I switc

I have a non-overlapping dataset of polygons. I change some attribute values around and dissolve on one of those attributes. Now my dataset has overlaps. Dissolver is on automatic accuracy. Changing this value manually did not change it for the better. The resulting overlap is small (approx. 1mm width), the dataset is only in the scale of several 100 meters though. So this is not some sliver in the nanometer range. How does this even happen, and how can I avoid it?

We see the below error in logs most of the times.NV-FME-P0001_Engine1  FME Engine failed to register with FME Server 'localhost' on port 7070: Could not establish connection to hostWed-22-Feb-2023 10:46:24.831 AM  INFORM  Thread-13  KNV-FME-P0001_Engine1  Program TerminatingWed-22-Feb-2023 10:46:24.831 AM  INFORM  Thread-13  KNV-FME-P0001_Engine1  Wed-22-Feb-2023 10:46:24.831 AM  INFORM  Thread-13  KNV-FME-P0001_Engine1  Translation FAILED.Wed-22-Feb-2023 10:46:24.831 AM  INFORM  Thread-17  KNV-FME-P0001_Engine2  Wed-22-Feb-2023 10:46:24.831 AM  INFORM  Thread-17  KNV-FME-P0001_Engine2  FME Engine failed to register with FME Server 'localhost' on port 7070: Could not establish connection to hostWed-22-Feb-2023 10:46:24.831 AM  INFORM  Thread-17  KNV-FME-P0001_Engine2  Program TerminatingWed-22-Feb-2023 10:46:24.831 AM  INFORM  Thread-17  KNV-FME-P0001_Engine2  Wed-22-Feb-2023 10:46:24.831 AM  INFORM  Thre