FME Form

Hello,I am using the chart generator with some small numbers to make a scatterplot. I can't figure out how to display the axis values in scientific notation. See the example chart generator output image below using some made up values. The Y axis values range from 1.0e-3 to 1.0e-9. I would like to change the axis values to scientific from decimal.   Thanks for the help   

Hi,I am having an issue where I want to remove duplicate values from the results of the change detector and merge them all in to a single row to remove duplicate entries. I have provided an example below.If you need more information just ask. Thanks.

Hello,I'm trying to create geometry from Sql Server geometry Blob to shapefile. I'm trying geometryextractor but it is not working.(I can not create geometry in Sql server; I can only read data).Thanks for help

Hello fme team, I have a line of length 100M, When i load to fme the defualt measure is 0-100, the real measure position of the line is start = 15.0 and end = 16.0, the line has attribute columns start and end in the attribute table.  Any idea how i can assign the start and end as measure values instead of the default measure 0-100? regards,Keller.

FME 2021.2.3.0 (20220131 - Build 21812 - WIN64) I want to query an OGC API feature service by an attribute, to be precise, by a list of attributes.In my case, I‘m trying to query the cadastral parcel service of North Rhine-Westphalia by cadastral parcel numbers: https://ogc-api.nrw.de/lika OGC API - Features (WFS 3.0) Reader:Defining the parcel number as static parameter value works fine.Injecting the parcel number as published parameter works as well.But the 2 ways above are static. I have a list of cadastral parcel numbers to be processed.Normally the FeatureReader transformer

I am experimenting with a new workbench that has python startup and shutdown scripts. Everything seems to be running successfully. I'm using FME 2021 as I need 32-bit capabilities for ESRI. After the workbench is done, I'm calling a python script that runs a series of SQL queries. The script finishes and FME says "Translation was SUCCESSFUL". However, the workbench is still running and I have to manually click the Stop button. Any thoughts?

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.