Transformers

I recently received the subject error. The error occurs when inspecting any downstream table of an AutoCAD dwg reader. The workspace appears to run successfully, then while scrolling down the transformer inspection table (in visual preview), the inspector suddenly throws an error and breaks out of the visual inspector table into the translation log showing the subject error. Clicking back on the table, and no records are shown past 100 (there are actually 1000s of records). Any ideas about what is going on? Thank you,TylerFME Workbench 2022.1

The Z-coordinates are not the same and varying. The points are located within a buffer of 0.1meter and extend over the entire area of the polyline. I have to join them based on a search area I think of 0.1 meters. The points are created from a las and transformed using the pointcloudtopointcourcer. As an example, I would like to have for this polyline which has 5 vertices 5 unique z-values from the closest points.

I have a highway line feature class and a highway distance markers point feature class with points created at 2km intervals along each highway line. I am being requested to create a rotation value to apply to each point on the line that is equal to the perpendicular angle on that line at each point. This angle value will then be used to apply label rotations to ensure each label comes out perpendicular to the line feature it is on.

Hi, has anyone had an issue with updating a non-spatial Oracle (19) table. The table has been registered in SDE, hence has OBJECTID also.There is no failure, but the record is not updated. If I use an SDE writer with update operation, it works fine, but takes over an hour for 300K records. I am using FME Desktop 2022.1Any ideas ?

How can I publish images to arcgis server image using FME? I'm newbie on arcgis server image. Thanks

I can group separate features together for labelling purposes and this is what the attribute looks like as an autocad_mtext_string However, I can only assign one colour by using this approach.How can I assign separate colours to lines of text within a grouped mtext string so it looks like this? 

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 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.

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

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?

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 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?

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, 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.

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 switch to only data features i still get the error:BADNEWS: Cannot convert null strin

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?

Hi FME'ers,I have trying to parse and analyse the log file from our ArcGIS Licence Manager. I have managed to exact the user, the date/time, licence type, machine name and check-in/check-out. I am now trying to determine how long a user checked a licence out for. This would require aggregating or joining the in and out records for a particular user (I think). The difficulty I am having is identifying a unique session, e.g. user A check out the licence at 0900 and checked in at 1700 on 01/01/2019. There is no unique session identifier, just a series of in's and outs and these may span over more than one days. My best guess would be to isolate the user (group?) then do some kind of 1:1 join.....maybe. You help would be greatly appreciated.Thanks,David

Hello all,I had one file which contains some null values and some state values. So in that case I am using the tester to filter null and non null values .but another file contains all the null values in the same column.so in the both cases we are getting the output in failed port as both files contains​ some null values. So how to differentiate whether a particular file contains all null values in the column or only few null values. So that if file contains all null values then we can send the error message.

HiI noticed a strange behaviour of Esri reprojection transformerI don't have fields with date/time formatsee picturecan you help ?  thx Francesco

Hi, Can anyone help me with process to extract schema from a GDB format

Hi, I have created a view in SQL and brought that on as a reader to FME. The SQL view has done all the filtering and grouping that I need and usually provide more than one row of results.When I attach this reader to an Emailer directly, as you know it will send an individual email per row of data. I tried to add an aggregator, but it needs grouping which has been done on the SQL side already. Is there anyway that I can email out the result of this SQL view, in a table format with all the rows included?