Transformers

Hi, I'm trying to use the attribute manager to replace all instances of double quote marks " with single quote marks ' for the values of the attribute 'testo' @ReplaceRegularExpression(@Value(testo),",') I can replace letters ok, but not quotes.

Hi, I have thousands of dgn files that need to be converted to shape files. I want to convert each dgn into corresponding shape file. Also I want to add the DGN file name, IGDS_level_name and the elevation of the feature as attribute in shape file. Is there a way of doing it quickly. Regards, Krishna

Hi,I have this message during a translation : Insufficient memory available -- error code was 2I have already read every thread on these memory troubles but none of them have a clear answer about that and how to resolve it.The 3 answers were always : adding ram/stop others software/move the temp dir...  My case : I have a machine with : 32Go of RAM TEMP_DIR set to a physical disk with 200Go of free space I need to transfer 3 Go of data from one table in an Oracle database to a PostgreSQL database whitout any tranformation, it is just a reader + feature type connected to a writer + feature type. On this machine, there is FME but there is the Oracle instance and the PostgreSQL instance too. They consumme some RAM :About 10 Go for OracleAbout 100 Mo for PostgreSQLAdd 6 Go for other stuf mainly Windows process So now I have only 15Go of free RAM (but 200Go of free physical space). When I start the translation I have these messages :System Status: 207.05 GB of disk space available in the FM

I'm seeing in my FME 2022.1.3 Esri Reprojector that my ArcPro 3.0.2 customtransformations installed at %appdata%\\ArcGISPro\\ArcToolbox\\CustomTransformations are not recognized. This wasn't the case in FME v2018/2020/2021. Is anyone else having the same issue? This happens even if I place the same transformation file in <FME_HOME>\\Reproject\\EsriPEGridData\\customTransformation.

Hello everyone,For example, I have the following pathname of the source datasetC:\\Temp\\FME Workbenches\\Kabelleidingen\\Klic\\Klicdata.dgn Then I would like to write the end result of the script to the followinglocation.C:\\Temp\\FME Workbenches\\Kabelleidingen\\Klic\\KlicData_analysisSo partly I want to write the data away to the root folder of the source dataset. Does anyone know how I can achieve that?The question is thus how I can get the value of the rootfolder that I subsequently can use in the writer.

I have an excel document with row 2 has merged cells for data category and row 3 has headers for attributes, row 4 onwards has data. how can I pull row as the data category? tried, columnstorow, and datapivot none seems to work as I expect

Hello everyone,I have some electronically signed xml files that I need to read with fme. These files have the extension .p7s and I did not find in the fme documentation how I could extract the .xml files (or any other format) from .p7s. Please, if anyone else has faced this situation before, if they have any suggestions. Thanks a lot 

Hi, Using an AttributeKeeper (or AttributeRemover) inside a custom transformer, I'm finding that it removes the value of any parameters that have been set using that attribute, is that the expected behaviour? (FME 2022.1 MacOS). I would have expected a parameter set from an attribute value to hold the value of the attribute, but it seems to just be a reference to that attribute? It's a bit odd as the parameter will have a value up to the point the attribute is removed, and after removing it the parameter will be empty. It can be quite tricky to track the issue down in a branching workflow too. I've attached a sample workspace with a custom transformer to illustrate, but also a screen shot:Thanks,Andy

Hi, I have a line which I want to offset. It the centre of a rail line, which I made from a group of points spaced every 0.1m ish along the track. 1Hz trajectory values from a liDAR scanner for those of you playing at home.  At each point in the initial file there is a timestamp, XYZ coordinates, and roll/pitch/yaw values. The line I made only uses the XYZ values and would lose all the other information So, I have a centre line I can offset left and right to estimate the actual rails of the train line. I would like to include the roll values from the original points into this offset so the offset rails are more accurate. These roll/pitch/yaw values are not consistent over the site though so I cannot plug them into the offsetter transformer on the centre line. Does anyone have any ideas how I can do this? Any help would be appreciated thanks

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?