Data

I'm running into a problem with the Google Sheets (V4) Writer. We have a Tableau Public Dashboard connected to a Google Sheets Document. Tableau Public will only daily update it's data when coming from Google Sheets. Other data formats are not supported.To keep our dashboard up to date I'm writing a selection of the last 24 months of data from our internal database to Sheets. About 1,5 million records. Using a 'truncate existing' mode. Only 1 column of data. All columns from B to Z have been removed from the sheet. Writer is set to end at column A . So no extra colums are created.When starting with an empty sheets this runs perfectly fine but after a week of daily truncates the sheet contains nearly 10 million rows. Only 1,5 million contain a value, the rest is empty. So not a real truncate, just a 'delete value' is performed. The next day my workspace crashed because the sheet will exceed 10 million cells...A drop and create won'

I am importing an AutoCAD DWG with multi-leader blocks for asset locations. The issue I am running into is that the value showing up in FME for the "TAGNUMBERS' is the Default value vs. the value that shows up in AutoCAD.  From AutoCAD: I'm trying to extract the 'T9' text from the MLEADERs shown here:  These are custom MLEADERS developed by the drafting department.  After different attempts to explode blocks, expose attributes both in Model and Paper Space, different combinations of parameters, etc. I attempted 13 different combinations to import the DWG and now luck, I keep seeing this in FME:  FME is only recognizing the 'Default' Tag Number.  I've tried to bring in both Model and Paper Space in a single reader to match Entity Handles, but no luck.

As the question suggests I cant seem to find instructions on how to convert LAS scans to GLTF format and retain the color_red, color_green, color_blue values. I've expereince with successful conversion of CAD models to GLTF but the resulting LAStoGLTF refuses to play ball. I've tried various combinations of reading LAS > use PointCloudPropertyExtractor to expose color data and even forced the issue with PointCloudLASClassColorSetter but all to no avail. The resulting GLB is created using default white colors leaving me with non-viewable model. Is this translation just too new a possibility for GLTF writer or am I missing something fundamental here (most probably I hope!). Thanks for any advice.Source LAS from Drone:Resulting GLB model:

module skp/skp is unavailable for use with this fme edition

Hi everyone,I have a series of regularly produced Excel files, each containing a number of sheets. The number and name of the sheets in each file isn't fixed.I can read data from all the sheets no problem by keeping the reader parameters blank - but annoyingly for these files the header starts on row 2 and in some cases junk is written into row 1. As such, FME picks up attribute names from row 1, so for one sheet the attribute for column B might end up named"995" and for the next sheet it might be "376", so I end up with a lot of attributes where there should be one - ideally just called "B".Is there any way to force the Excel reader to always use column letter as the attribute name regardless of how many sheets are in a file and what they are called?

https://www.railml.org/index.php/en/

Hi, I'm trying to figure out how to write nested attribute structure to a GEOJSON file. For that reason I've prepared some sample data for a Quick Translation to see how FME would set up the writer feature type properly. But surprisingly, my nested structure is lost during that translation! So in fact my test endet up in two questions instead of delivering a solution:1.) Why does the Quick Translation fail2.) How do I set up the GEOJSON Writer properly to build the desired nested structure.2.1) In case JSONTemplater is the solution to this task, how do I have to set it up properly? I spent some time playing around but never came up with some suiteable result, especially for proper GEOJSON (geometry handling, type defintion and so on). Find attached my sample file. Looking forward to any suggestions (and maybe solutions 😁 )

Hi,I would like to Read a XML and convert to csv file, but preserving the sequence of Attributes from XML.The Structure XML:When I create a just workspace Reader ( XML ) to Writer ( CSV ) respecting Dynamic Schema, the Attributes are'nt in order.Thanks,Danilo

I have had FME writing to an ArcGIS Online Feature Layer, working no worries. I then decided to 'tidy up' my field names and alias, so I dropped a few fields and recreated with more appropriate naming convention. So in my FME workbench I have removed and then re-imported my feature type, thinking it would pick up my changes.Note: the fields were dropped and recreated using the AGOL web interface. Since reconnecting/importing the feature type and renaming the fields accordingly in the writers User Attributes I am getting the below errors, and I cannot work out why the workbench is still trying to write to those old field names. Below is the current field names, these were originally slightly different, as shown in the errors below. Here is my updated User Attributes panel, these fields match th

When using the ArcGIS Online Feature Writer, sometimes during truncation, AGOL will encounter an error on delete.  It looks like this:2022-01-12 18:39:01|  25.9|  0.0|INFORM|ArcGIS Online Feature Service Writer: Truncating layer/table 'Meters'. 2578 features remaining2022-01-12 18:39:39|  26.1|  0.2|INFORM|ArcGIS Online Feature Service Writer: Truncating layer/table 'Meters'. 1578 features remaining2022-01-12 18:40:47|  26.2|  0.1|WARN  |ArcGIS Online Feature Service Writer: 'deleteResults' error for a feature in 'Meters'. The error code from the server was '1018' and the message was: 'The specified feature could not be deleted or does not exist.'2022-01-12 18:40:47|  26.2|  0.0|WARN  |... Last line repeated 315 times ...2022-01-12 18:40:47|  26.2|  0.0|ERROR |ArcGIS Online Feature Service Writer: 6000 features successfully deleted from layer/table 'Meters', but the server rejected the 1000 deletions in the last request due to errors. See warni

Hello everyone, I should start by saying I'm an FME beginner user. I'm currently toying with an old ESRI coverage dataset that still has some importance. The files are split by index (grid) and so each layer is stored in a separate folder like shown below. My goal is to extract the data from only one theme ("batim_p" which is building point data) and to merge it into a unique layer. Although the schema is always the same, it is possible that some index folder do not hosts the data folder. The thing is that I have an arcpy script that does this within about 40 mins but the FME process I constructed (which basically is only a feature reader) takes almost 10 hours to do about the same thing. I believe my problem comes from the fact that the reader scans EVERYTHING, although I have only selected the feature typ

I've been noticing something and having trouble resolving it.  I have a workflow that runs every half hour, it runs fine however I noticed that it is creating a legend.tiff file in temp in a numbered folder within /tmp. This does not seem to clear and is about 1GB. I would like if this file was not created or at least removed when the process finishes. It will eventually create too many of them and lead to the disk getting full. I can remove them manually or with script on intervals, however I feel there must be a way for FME not to create them. If any one has any tips on what transformer is creating them that would be great.

I'm using an SQL Creator to return data from three tables (Microsoft SQL Server), one of which contains a geometry column.  Initially, I was just joining two tables and this all worked as expected with the geometry being correctly displayed within FME. When i amended the SQL to include a third table, the geometry column seems to have stopped being interpreted as geometry and is now displayed as an attribute containing binary data.  A bit more investigation, if I limit the fields being returned by the SQL creator, the geometry is interpreted correctly (bottom SQL creator). If i attempt to return all fields (explicitly naming or using *), the geometry field is returned as an attribute   Additional information, only the table I'm attempting to get the geometry from has a geometry column. Am I missing

When I am translating Smallworld 4.2 using a seed file that has a coordinate system set the file that is created does not have a coordinate system set. If I create a file from within Microstation using the same seed file the new file does have the coordinate system set. I verified that during the translation using FME the correct Seed file is being used. I then created a translation of a V8i Microstation file translating to another V8i Microstation file using the same Seed File and the coordinate system is unset in the created file. Am I missing some kind of setting? or is there a know problem with Coordinate systems and Microstation files?

Looking to use these building footprints from Google, and they're in a format I haven't heard of before, a 'spatially sharded CSV'. Has anyone ever worked with this dataset or know how I could read in the spatial data? Here's more info from the page at Google Research: Building polygonsBuilding polygons are stored in spatially sharded CSVs with one CSV per S2 cell level 4. Each row in the CSV represents one building polygon and has the following columns:latitude: latitude of the building polygon centroid,longitude: longitude of the building polygon centroid,area_in_meters: area in square meters of the polygon,confidence: confidence score [0.5;1.0] assigned by the model,geometry: the building polygon i

Hello, I am having trouble with an DWG plan containing arrows. Workbench: Does changes in the model space and writes the modificated plan into a new DWG file. I am using a DGW styler just before the writer (I don' have selected more parameters). Writer parameters: Preserve template paper space data: yesOutput (see image): Plan (green rectangle) and arrows (red rectangle) are seperated. Does someone know why this occurs and has a handy solution? Thank you!

Table1Table2 Reader data from soap and writer is oracle spatial object. I use inline querier and featureMerger for using xml hierarcy that is "STATUS_REASON_SEQ_ID ". So, I merged two tables and created. But I expect to see foreign key(references Table2 (SEQ_ID)) in Table1. What should I use in this case. ?

Is it possible to add a "$filter" parameter to an OData reader in FME 2021.2 ?  

I try to make a setup of a script workbench and a runner workbench. The script consists of a postgis feature reader and a gdb writer. The schema of the postgis feature reader is defined as a user parameter, and so is the destination of the gdb writer. The runner consists of a Postgis reader that reads a table containing schemas and paths for the gdb, and a workspace runner that runs the script and defines the user parameter mentioned above using the schemas and paths from the PG table.  However i just this error when trying to read the table of the schema: "021-12-21 12:53:57|  0.1| 0.0|ERROR |Error executing SQL command ('select * from "FME_PostGIS_SCHEMA"."DF_Mast" where false limit 0'): 'ERROR: relation "FME_PostGIS_SCHEMA.DF_Mast" does not exist" So it just inserts the name of the user parameter rather than the actual schema it was support to insert.  I hope you can help.

FME Desktop 2020.0.0.0: What does “untouched” indicate for in the “geometry coercer” tool? For example, in the screenshot below, I got 3 features as “untouched”. What does this indicate for? The data is attached      

I am importing landxml file that has alignment(s) with stationing. I'd like to view the alignment(s) with stationing labels including tick marks in the Graphics window. Is this possible?

Hi,  After converting the tif to ecw, ecw always comes with a background. I don't see the background in FME inspector or ArcMap, but there is always a background in Smallworld. Is it a way to remove the background colour of the ecw?

I have an AIXM 5.1 file which clearly states at the beginning that the encoding of the file it is in UTF-8. However, when I use the AIXM 5.1 Reader suddenly all my attributes are in UTF-16LE which is not what I want. I could use the AttributeEncoder to change everything back to UTF-8, but that seems like a waste of time as my data was good to start with. Also is my geometry converted into XML and reading that will give errors as declaration inside the attribute is then UTF-16LE while I converted the attribute to UTF-8.

FME server get current logged in user from token

I have FME Small world Edition license on my system but I am unable to read the data as it shows below error. Please help me with this.