Data

I have created a 32 bit DSN ODBC connection using the progress/openedge 11.7 driver which connects successfully. I am trying to then connect via FME 2020.2 and choosing the ODBC option to connect but I am getting a message returned as follows? The specified DSN contains an architecture mismatch between the Driver and Application

When I load my excel file I want the Day attribute to be read as type char so I can split it with string functions (Left/Right). The problem I have is that FME insists on reading the attribute as a 64bit real. I have tried removing the reader, purging the temporary files, saving the workspace, closing FME, and then add the reader again. But I keep having the same result. Are there any suggestions or is this standard for the Exel reader?

My workflow reads an SDE, carries out some transformations, and then writes to .xlsx using a feature writer and a template file. When I open the excel file and sort columns the sort function works the first few times but then it begins to only sort certain columns leading to mismatched data in the document. There doesn't seem to be any pattern as to which rows sort and which don't. Sometimes it is only the ObjectID column which will sort.

Hi, I'm trying to write mesh files incl textures from obj to Esri SLPK format. The problem I face it is takes a really long time. I'm a newbie on the slpk format and don't know if there is a smarter way to do the translation. Any help highly appreciated.

With ECW v3 Writer I get the following error message: ECW writer: An invalid parameter was used : date and projection setting are invalid. The coordinate system used is EPSG:2056/EPSG:21780. With the coordinate systems UTM / LL-WGS84 the ECW v3 Writer works correctly!Tested with FME 2019.2.1.0 (Build 19813) WIN64 and FME 2020 Beta (Build 20153) WIN64.

(English translation below) Bonjour, Dans le cadre d'un projet, j'ai pour objectif de créer une routine permettant de convertir des plans topographiques et de réseaux enterrés en modèle 3D au format IFC. J'ai commencer à chercher, mais il semble y avoir à la fois beaucoup de possibilités et à la fois aucune que j'arrive à faire fonctionner. Je vous explique un peu mes données d'entrées. J'ai : Plan topographique, dessiné en 2D, contenant des points topographique avec attribut (altitude). Plan de réseaux enterrés avec des étiquettes (bloc ou texte) contenant des attributs divers (nature du réseaux, profondeur du réseau, type d'élément (fourreaux, câbles, canalisation...), altitude de la génératrice supérieur, ect.). Nuage de point j'ai donc plusieurs besoin : 1/ Il faut que j'arrive à faire que mes polylignes représentant mes réseaux (polyligne 2D - Z=0) remontent à la hauteur où elles sont vraiment (soit hauteur TN - Profondeur ou Z de la génératrice supérieure (à laquelle je soustrait

Firstly, we have extracted the Schema of this Oracle database (sde) in MySQL FGDB format in ArcGIS Pro exporting this schema. Now, in FME Desktop I need to connect to Oracle database server and get this data as per feature classes present in datasets with all the attribution and its values with geometry in this MySQL FGDB Schema imported. Need help on this and which transformers can be used to get this Oracle data migrated in MySQL database Schema FGDB.

The attributes should be visible in the AutoCAD properties dialog. I have been able to write "extended attributes" that you can list with the XDLIST command in Autocad but I want to write attributes that are visible in the properties dialog in Autocad. Can anyone provide some advice on this or a sample. I think it must be simple but I am missing something???!

I am doing a simple landxml read to delete unnecessary data from a landxml pipe file and then write it again with the landxml writer. The Struct feature type should write out Invert{}.flowDir, but it doesn't. Anybody have an idea what the problem is?

When trying to use the SQL Azure SQL Database (JDBC) database connection, can that be used with the ActiveDirectoryPassword authentication type? I have a service account in the Azure Active Directory, but that is not the user our FME Server runs with, to be able to use the ActiveDirectoryIntegrated option. I have successfully used FME Desktop with my personal account as well as the service account (using RunAs) with the ActiveDirectoryIntegrated authentication. Any help you can provide would be very much appreciated.

How to get center point of rectangular or square ? i need to extract the coordinates of center point from any shape as shown as pic . FME 2020 Thanks in advance

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 records s

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

Using FME Server 2021. Uploaded workspace that has no problems to run on Desktop. When running on FME Server it fails with the message: FAILURE INCLUDE -- 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 created a wor

Can somebody please confirm that I'm understanding this correctly: https://knowledge.safe.com/articles/23883/working-with-geodatabase-subtypes.html Limitations At 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 coming th

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.