Transformers

Is there a setting to suppress fme_rejection_code attribute creation with DateTimeConverter Transformer? Thank you, TylerFME Workbench 2022.1

Hi everyone, I am wondering how I can have a FeatureReader that dynamically adapts itself to any changing feature type name. The feature type name is linked to a private parameter, but since the output port created by the reader is ''named'', everytime I change the value of the private parameter, the output port keeps its original name and just goes empty. It there a way to make that ''named output port'' dynamically change its name to fit the value entered in the private parameter?  I am using a Geodatabase reader. See attached files for screenshots. Thank you!!

I need to transform an Oracle geodatabase using st_geometry to postgresql using postgis. Ultimately it will be moved to the cloud (RDS on AWS). Is FME the correct tool for this sort of conversion? Would it be fast (roughly 15GB database(

The writer seems to be trying to write '00000000' for these features rather than leaving it as null Is there a way to stop this behaviour? In a standard workbench I could set a default value but it feels like I shouldn't need to do that as postgres can handle null values in date fields and I don't know how I could change the values as it's a dynamic schema. Errors in log:Value of attribute 'createdate' could not be converted to type 'date'. Feature will be logged and skipped Attribute(string: UTF-8)      : `CREATEDATE' has value `00000000' ---Schema definition for field:attribute{8}.fme_data_type fme_dateattribute{8}.name CREATEDATEattribute{8}.native_data_type dateThe next line is missing for features that do not have a value:CREATEDATE 20031118 

Hi folks, I have some CAD files (dwg, dxf) that have custom line type information (so line types, the engineer defined by himself/herself. I know that the DWG format has some attributes to be exposed that indicated a "DASHED" line etc.I can read out lets say the linetype "FENCELINE" or any custom made linetype in an exposed attribute (I guess it is called "Autocad_resolved_linetype").  problem: While the complex linetypes are defined in the "acad.lin" files, the custom linetypes a user can create are just visible in AutoCAD. Is there a way to display those custom/complex linetypes to get this automated somehow?problem: I know the "LinePatterner" helps creating the simple line types. But how can I created a complex line pattern? Something with circles or characters in between?Many thanks if somebody can share his/her knowledge 😄  Best,Ferid

I stumbled across the following challenge in FME:how to deal with NULL values if you want to perform a calculation for a new attribute. For example, I want to sum up values (could be any other kind of arithmetics).The expected result is fine as long as no NULL Value is involved. FME turns any calculation into a NULL result if any NULL is involved (see documentation).   The question that haunts me is, how to treat those NULL values as 0 in the calculation without changing the value to an actual 0 (as the NullAttributeMapper would). The result I am looking for is the following: If all values are NULL i want the result to be NULL, otherwise I want the NULL value to be treated as 0. Furthermore, I dont want the NULL values to be changed to 0, so I can distinguish between NULL and 0 in further calculations.

dear FME,I've been having problems with converting dgn(v8) file format to dgn(v7) file format, and after exploring the forums looking for a solution, I encountered a similar problem with reference number PR#72482 that no solution was posted to it, and I wanted to know if anything has changed regarding the referenced problem, or is it still a low priority for a fix? thanks in advance

So far in searching I've only found instances where the Oracle DB was dumped into file geodatabases via copy and paste. Then another copy and paste into the target DB. Sort of a part two question:Regardless of the method used for the migration is it possible to process deltas from Oracle to Postgres directly?

Hi all,  I am using FME desktop to publish XMLs out. I'm currently using the XML templater and need to edit one of the attributes that is coming through via a feature reader.  The sub template expression looks like this (redacted some lines due to data):<data> <dataid>{fme:get-attribute("dataid")}</dataid></data> There's several other attributes in the XML but I'm not interested in those.  Basically what I would like to do is trim the value in that attribute as the attribute has the current format ABCD*00000000001. I only require the numbers in the attribute and only want these written to the final XML output.  How do I go about making changes to the XML attributes. I have tried looking at XQueries but not got very far. Many thanks

I'm trying to use the AttributeTrimmer to trim forward slashes from the beginning and end of a string (e.g. - /SomeText/) but I can't find the correct escape character. Thought it was a backslash. Who knows what I need to use to trim /SomeText/ to SomeText? (FME Desktop 2020.1.2.1 - build 20624). Thanks, Aaron

Can someone please suggest something to  improve the performance?

FYI - I'm fairly new to FME and would like to start using it much more in our workflows, any help is appreciated. I'm converting a model from Revit to FBX. Where I am transforming the coordinates to a local ENU CS prior to export. I have created a transformation matrix using the Python Caller, where I intend to use the generated coefficients in a 3DAffiner. Manually adding the coefficients into the 3DAffiner works well:Here I simply printed the values of a1-c4 with the first run of the workspace, then pasted these values into the 3DAffiner to produce the FBX file. What I want to do is pass the a1-c4 attribute values from the PythonCaller into the 3DAffiner, as below:Although I recieve an error when doing this:3DAffiner_ecef_local_origin (TeeFactory): 3DAffiner_ecef_local_origin: Unable to convert @Affine parameter A value `<Null>' to a floating point value As you can tell, the issue is because the feature to be transformed by the 3DAffiner doesn't have these attri

I ran into some quirkyness with lined custom transformers today\\Normally, when one has a workspace with a linked custom transformer, and you change the stuff between the input and output ports of that transformer, the next time you run this workspace uses the new functionality. That is when you save the transformer and don't make a new version.The parameters of the linked transformer are not changed. Obviously that goes for the published parameters, you set in the workspace through dropdown menu's etc. on the linked custom transformer, but it also seems to go for the private parameters of the linked transformer.It looks like they are stored in the workspace as wel in some sort of way. When you have changed these during the rework on the Linked transformer, still the old private parameters seem to be used when running the workspace!In my case the private parameters were python-scripted parameters in the linked transformer. I changed the python-scripts. When running the workspac

In the new, fantastic, InlineQuerier (2023 beta), a geometry column can be selected. Is there a way to call directly the geometry of the feature without geometryextractor? On the same topic, is there a way to define the ouptput geometry without using an ST_asText followed by a GeometryReplacer?

On the VM there is a C drive with 80 GB on the C drive and 80 GB on the D drive. Wanting to ensure we don't run into any issues.

 I have attached an excel spreedsheet. I would like to merge and convert the table in sheet 1 ("Year_2035') and sheet 2 ('Year_2050') into a table structure like that one in 'RequiredFormat' sheet. I have never transformed such a complex data structure in FME before. Can anyone kindly help with good suggestions?

Hello everyone,  I am trying to round the x, y and z components of Pointclouds to a precision of 3. I have tried the coordinaterounder but as is already stated in the Coordinaterounder documentation (http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/coordinaterounder.htm) the behaviour of this transformer can be erratic. For some points I get far more then 3 decimal places, while for others it is rounded to an integer. I have also tried the Pointcloudexpressionevaluator as in this solution (https://community.safe.com/s/question/0D54Q00009HJ87MSAT/rounding-ifmepointcloud-xyz-components-with-pythoncaller) but this also does not seem to work for my data.  Is there another option I could try or is there maybe something I might be missing from the previous solution?  Thank you in advance!  

Hi, Does anyone know if there is also an issue for writing textures to geometry for OBJ and FBX format writer in FME v2022.2? It seems the same issue for Sketchup writer has been fixed. During test the issue for OBJ and FBX format seem to be present.

I have simple script with adding color palette to raster ASC after cell value replacer . In ouput GeoTIFF i received too many palette colors represented with black color. |In attachment i send script. It's possible to have only 3 selected colors without black numbers?

Hello Sir / Madam, I have a gdb file that have several layers. I am just wondering how can I extract all attributes from the layers?  I tried "Schema" reader and list exploder to explode the data. However, I only able to get one table attributes. May I ask how can I extract all attributes from all layers? I have attached a sample data in here. Hope someone can give me a hand. Thank you! Thank you in advance.

Hello Sir/ Madam, So I have a CityGML file, which is based on XML. In each of the 3D model, I would like to extract the attribute name and values. Basically, what I want is that those with gen:string attribute name and bldg are the values where I would like to retreive. Here is a part of the file <gen:stringAttribute name="BuildingStructureID">    <gen:value>15169952</gen:value>   </gen:stringAttribute>   <gen:stringAttribute name="BuildingCSUID">    <gen:value>3917120211T20050430</gen:value>   </gen:stringAttribute>   <gen:stringAttribute name="BuildingID">    <gen:value>1108233601</gen:value>   </gen:stringAttribute>   <gen:stringAttribute name="ModelIdentityNumber">    <gen:value>B391712021101062A0</gen:value>   </gen:stringAttribute>   <gen:stringAttribute name="UUID">    <gen:value>22fe4b82-05e8-44ec-91cc-3408862e240a</gen

This would be simple to do in Excel, but I can't figure it out on FME. The problem is I need to transpose or pivot rows to colums, as in example (I have formatted and calculated the totals to first box):I have tried with AttributePivoter and AttributeCreator/Aggregator, but it doesn't work. Any help would be appreciated, I've tried to google, but with no luck. I have also tried to pivot the unprocessed data and calculate it there.

Hi, Yesterday I came across the situation where I wanted to split a text file into several portions. For 'new lines', the file contained both single Line Feeds (i.e. LF or \\n) as Carriage Return - Line Feed (i.e. CRLF or \\r\\n) combinations. Thus both the Unix End Of Line (EOL) methodology and the Windows EOL methodology were present. I used the StringSearcher to match relevant parts of the text file, and then wanted to use (concurrent) all_matches{}.startIndex to fetch the relevant portions of the file. However, I found out that when I then use the found startIndex in e.g. the SubstringExtractor, it doesn't doesn't return the same (starting) characters as found in the match. Digging a bit deeper, it seems that the StringSearcher all_matches{}.startIndex seems to skip counting CR (\\r). I'm guessing it identifies CRLF (\\r\\n) as an individual character c.q. index? See the screenshot below for a demo workspace illustrating this issue. Also, I found that the equiva

How can I maintain my Z values in my featuresclass using surface draper while replacing the vertices that lack a Z value using the surface provided?

I am trying to create a workspace that writes AGOL features to AutoCAD Map format with object data attributes. Not having much success. :-(