Data

I have a layer that was created with the tiler transformer and rather than column (0 - n) I want to covert them to an alpha equivalent i.e. 0 => A, 25 => Z, 26 => AA etc Does anyone have a approach for this please?

Hello! I'm new to FME and I'm wondering if it is possible to integrate PDFs into a CityGML model (LOD1). I need to link a different PDF for each building of the 3D model. Can anybody help me? Thanks in advance

I have the need to utilise a dynamic writer for coordinate conversion of a user uploaded file.The schema will be unknown therefore the need to be dynamic.I am using FME (20201027 - Build 20787)I have used a writer transformer and have set the schema to Dynamic and the schema is set as "Schema From Schema Feature".  I am wondering if this has an impact on the first feature being used to dimension the dataset and is not written to the table. However this would be unusual because I have used these writer transformers before with more success. The noted difference I can surmise would be that the schema and features have been split up after the reader and I have used the schema to determine the coordinate system of the incoming dataset features to check that it conforms to the eventual conversion, then the features and schema are brought back together using a Joiner transformer.This works for other formats (CSV and TAB) with which I have used the same logical design.The cached rec

Currently, within FME desktop me and my colleague, we are trying to convert a DGN file to a DWG file (realdwg). The DGN file has a size of roughly 90 MB. However just using simply a Reader and a Writer does result in a DWG of around 600 MB! I don't understand why the file became so big and ideally we would like to keep the size of the DWG lower than 100 MB.  Edit:Are there things which we can try to make the filesize of the DWG as small as possible and ideally below 100MB

Hello,We are drawing with Autocad. We want to use dynamic block with Custom part (Visibilité1 and Angle1 see PrintScreen 1). With FMe Desktop, is-it possible to have these values in a fields/attribute ? Our objectifs is to import data in a GIS with the values of Visibility to define some objects. Best Regards.Bernard Dinon Print Screen 1

FME Desktop 2022: How to dissolve based on a particular field and then to get the COUNT of the dissolved features as well as the FIRST value of other field? For example, in the screenshot below, I wanted to dissolve based on the “autocad_color” field and then to COUNT the features that have been dissolved while taking the FIRST value of the “landuse_arabic” field. This can be done easily in Pro with one command (dissolve) The data is attached           The data is attached

FME Desktop 2022: How to filter all records based on the “null” value of particular field? In the screenshot, I couldn’t figure out how to filter all records that have “null” values in the “ump_layers”    

In a Workspace of acad2acad, some leader lines and arrows do not come through or move. RealDWG Reader and Writer solves a few scaling problems with blocks, but there remains a few leaders that don't make it or move:Before After It's not clear if the orphan leader on the left has anything to do with the annotation (different geometry and entity handle). autocad_arrow_head_on is TRUE for all. If it is something in the original CAD file, I have yet to find it. Not all leaders and arrowheads disappear.The leaders stay until it hits the Writer:Also, I am using a template that is set to the source file in order to get the paperspace titleblock. That is the only way I can get that specific paperspace info into the file (is there a better way?). If Preserve Model Space Data is set to yes, I get the leaders, but also objects that I was trying to change as well as the mystery "mirrored" orphan leader. To be clear, this occurs in multiple different drawings. Any insight is appr

Using FME Server 2021.Uploaded workspace that has no problems to run on Desktop. When running on FME Server it fails with the message:FAILUREINCLUDE -- failed to evaluate TCL expression ` FME_CleanseFMEUUID {StringPairReplacer_9f3b9011_1d33_4123_9fa5_4f7dd23e28558} ' -- invalid command name "FME_CleanseFMEUUID" while executing "FME_CleanseFMEUUID {StringPairReplacer_9f3b9011_1d33_4123_9fa5_4f7dd23e28558} "

Is there any possiblity to configure/customize fme server error messsages on server side? Any good idea for this?

Last week I was contacted by a colleague to process a text based dataset that reminded me of something I had seen in the past for Fortran based datasets.  In particular, the text based dataset looks somewhat like a CSV dataset, only now columns are separated by a fixed width. See below for an example of how it looked:I was wondering if there is maybe already some type of reader that can deal with such type of data? Of course, if you get such a dedicated dataset, you can use a text_line reader, cut/split the text line into separate features (based on the known width (e.g. using a '#s#s#s' format string in an AttributeSplitter, see third example on the documentation page)), and then using e.g. an AttributeTrimmer to remove excessive whitespace. However, this method needs to be configured for each individual dataset, so I was wondering if there was maybe already a tailored made reader that could do this (by first automatically detecting the column widths).  Out of curiosity I crea

Can somebody please confirm that I'm understanding this correctly:https://knowledge.safe.com/articles/23883/working-with-geodatabase-subtypes.htmlLimitationsAt the time of writing, FME will not allow you to associate different domains based on a particular subtype. For instance, you would not be able to set range domains of 0-50,000; 50,000-100,000; 100,000-250,000 and apply them to a subtype definition containing the values of Small, Medium, and Large. In order to achieve this, you would need to create the domain:subtype relationship in ArcGIS.In our database (ArcSDE 10.3.1 w/ Oracle 12c) we have a feature class which has a subtype field and within each subtype there is defined a different domain for a "subclass" field. I want to be able to resolve the subtypes and domains (both in and out of the subtypes) but the above paragraph makes me think this is not possible for domains defined within a subtype. I have had no success in my testing as of yet - only coded values are

Hi,When exporting to Datasmith all the meshes origin is located in 0,0,0. This courses some problems for us in Unreal, especially when we are working in large worlds.Is there a way to make the change in FME so that the meshes have a pivot point in the center point instead? (There was once a time that adding the CsmapReprojector from same to same coordinatsystem worked, but not in FME 2021)

How can I create a generic writer where the user can choose between DXF and DWG amongst other formats? The problem is that DXF and DWG use the same output format, but with the normal writer the format changes when you change the file extension.

I have tested different transformer and way, but I don't understand how to apply an input in order.

I use to run the conversion process of GeoTiff to ECW with compression of 90 and generate TAB file using FME2020, i never experienced any issue. I recently upgraded FME to 2021.2, I have to convert JP2 to ECW with compression of 90 and want TAB file as well. I ran the process multiple time, but I don't get TAB file generated in output folder. Even I found new attribute in this FME version, where it asks to select ECW Format version (2 or 3), which one to select..?

tested it with 3ds, shape and object.the CRS is 25833 GeometryValidator => passed through "Solid Orientation"FME 2020.1  

FME is aware of the file extension .nc, but appears to be unrelated to the file type I am using. Please see attached file sample (note the original file name is louves.NC)

(on FME 2020.2) Hi,  I have a workspace with an Oracle reader in which I want to filter the features to read with a WHERE clause on a column, let's say COLUMN_A. I created a Choice type published parameter named colA, which contains the possible values for this column.This way I can filter the features from my table when COLUMN_A contains the value selected in the Choice list. The WHERE clause is : "COLUMN_A" = '$(colA)'Quotes character are used to handle the values with spaces. Problem : the values can contains the quote character as well !What is expected for the database (Oracle) is that the simple quote in the value should be doubled. For exemple the colA value TES'T should be transformed to TES''T. I tried to find a way to replace the simple quotes with two quotes in the WHERE clause using SQL string functions, without success because it always require to have the doubled quote. The only workaround I found for the moment is to change the Choice parameter to a Choice with alias par

Hi, I have a set of hundreds of shapefiles and another set of hundreds of rasters. I don't want to use ESRIReprojector transformer individually for each reader and writer. What's the most efficient way for batch transforming their CRS in FME?

When using the MariaDB/MySQL in either Update or Delete mode, how to you specify the key to match the record? Is it using the fme_where format parameter because there doesn't appear to be mention in the Writer docs. Does it support fme_db_operation also?

I have a workflow in which i convert .dgn and .dwg files to postgis, in this process I spatially join the text to areas, as I need them for attributes. My problem is the text alignment for the dwg files is baseline_left.Even though my colleague centered these. Is there any workaround, or possibility to get the placement to center?I've tried using an offsetter, but the areas are very different in size, so the offset is not uniform distributed between the points.  The .dgn files does not have this problem.  EDIT: The problem is that: the placement of the points are not what my colleague sees in her program, there they are centered. But they are not centered in the areas when I open the file in FME.  Thanks in advanceJonathan

Anyone run into this error before trying to write data to ArcGIS Online with the writer (applyEdits)? In this instance, this came from ArcGIS Data Interop running on ArcGIS Server.{"code":1000,"description":"The request limit has been reached. Contact esri support for assistance."}(Also cross posted on the esri community)

I have read http://fmepedia.safe.com/articles/FAQ/Autodesk-AutoCAD-Civil-3D and wonder how you are handling surfaces. Inputdata is a Surface/TIN and I also want to write to a Surface/TIN in DWG-format.  Can you read the Surface in Civil3D as as "triangles" , then aggregate these within FME and write them out as Surface?

Hello, I would like to get the value that comes from a Counter transformer through the Initiator input in a SQL Executor transformer, to make a query that uses this number Here is my request: FME_SQL_DELIMITER ;alter sequence cajxg_CE_sequence increment by '@Value(COUNTER)'; I tried or without the quotes, I also tried using TO_NUMBER and if I replace my attribute by a number, it works But when I perform the query I get the error ORA-01722 (Invalid Number) When I try to do a select with this attribute, it works Thanks,