FME Form

Hi, I have a workspace that truncates an SDE geometry table and refills it. The workspace runs daily and sometimes there are no records to write. In that case the writer only has to truncate the table. I don't see an option truncate first or anything like that in a sde writer.How can I truncate a table while the writer is empty?  

Hi, I'am creating a citygml model (lod2) based on roof and ground with the help of BRepSolidBoundaryCreator.Now I have definded lod2MultiSurface as citygml_lod_name!I need in addition to lod2MultiSurfaces a lod2Solid Geometry for each building like this:<bldg:lod2Solid><gml:Solid gml:id="UUID_93353a82-d426-4090-8aa5-d852bcad8f35" srsDimension="3"><gml:exterior><gml:CompositeSurface gml:id="UUID_2a60da73-2d26-4f2a-a623-b9acc31661e2"><gml:surfaceMember><gml:Polygon gml:id="UUID_bf94ba8a-c9b1-41e3-b4a4-9f932cfc358f"><gml:exterior><gml:LinearRing gml:id="UUID_b8b135e2-705d-4255-8b2c-63b8558eaec6"><gml:posList>603363.9649999999 5792993.036 80.696 603363.8160000006 5793003.66 80.696 603357.9249999998 5792998.265 81.57 603363.9649999999 5792993.036 80.696</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></gml:surfaceMember><gml:surfaceMember><gml:Polygon gml:id="UUID_284c30a5-944c-4222-9ef0-

I have a very simple workbench that is taking a MapInfo file, reprojects it and sends it to an ArcSDE database in Oracle. For some of the MapInfo files it works fine but others only the objectid and shape attributes come across. The writer, drops and creates the table but does not create all fields in some cases.  Does anyone have any ideas why this might be the case? Regards Dean

hello,Is there a way of extracting data(maybe from loG) about start and end of workspace execution, as long as errors (if there are any?), in order to insert them in a table? thx,Nicu 

I am working on a script that uses the OpenIfcShell library to create IFC files as a workaround for the IFCWriter's gap in functionality.  So far so good:  I can create the basics of an IFC file using one feature.  Now the challenge is to scale up with a dataset that has many features and feature types.  Here is the code I have so far:import fmeimport fmeobjectsimport uuidimport timeimport calendarimport tempfileimport ifcopenshell class FeatureProcessor(object):     def __init__(self):        pass     def input(self, feature):                # Create FME Log File object name called logger        logger = fmeobjects.FMELogFile()         # Call logMessageString method to add custom text and set WARN severity level        logger.logMessageString("Testing the mud",1)                        ifc = ifcopenshell.file(schema='IFC4')                O = ifc.create_entity('IfcCartesianPoint', (0., 0., 0.))        X = ifc.create_entity('IfcDirection', (1., 0., 0.))        Y = ifc.create_entity('If

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?

In my case, I have JSON object that contains table and it values in array. I am trying to extract each table object from JSON and insert it features(columns) array values into postgresql table based on table name. The json structure will change every time and it is dynamic. Input:{  {    "table": "Table1",    "key": "2343",    "features": [      {        "status": "Finished",        "id": "1234",        "kind": "Unknown",        "project_name": "XXXXXX"      }    ]  }  {    "table": "Table2",    "key": "2667190",    "features": [      {        "column1": "test",        "column2": "A",        "status": "Unknown",        }    ]  },} Expected output:

My database is >13.000 points from 6 different vessels. I need to create lines for each day, for each vessel. The lines have to be created in chronological order. I'm trying to group the dates after sorting, for then build the line using both datetime and vessel name parameters. I have converted date time format (ex 20210415165357, which is YYYYMMDDHHMMmm) to 2021-04-15 (YYYY-MM-DD). Any ideas how to solve this?

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.

FME Desktop 2022 Build 22304: How to get an esri feature class generated in case the number of passed filtered features are zero (no features are filtered)? For example, in the screenshot below, no passed features are filtered as an output for the tester transformer. How to get this result reported in an esri feature class stored in file geodatabase? Currently, no feature class is generated in case no features are filtered    

Hi All, I'm try to find the best way to analyse the begin and end of line and check if this line is connected in the both vertices ( begin and end ). As you can see in image bellow, the line number 3 is connected in the begin and end of the line.And the others line are not.A DGN file is attached. Thanks in Advance,Danilo

Hi, I have a problem extracting data from my text file.The file looks like this:******************************************#Textlimiter=;#Decimalsign=.#ProvadmColumn1, Column2...ColumnX;"Value1";"Value2"...""ValueX";"Value3";""Value4"..."ValueY";#ProvdatColumnA, ColumnB...ColumnZ;"ValueXX","ValueYY"..."Value11";"ValueQQ","ValueRR"..."Value22";#End******************************The ProvAdm-section can contain one or more rowsThe ProvDat section can also conrtain one or more rows I want to read ProvAdm section into one table (SQL Server) and ProvDat into one table (SQL Server) but I dont reaaly understand how to find out where ProvAdm section ends (how many rows should be read) or where ProvData starts (where should I start reading) An additional dimension to the problem is that I need to read multiple files at one go... Perhaps my explanation is not complete b

 Hi !I'm having a problem while writing into a template file, see image of log error. In fact, out of about 20 translations, there is one with this problem arising while writing data. Can someone tell me if it's a bug with FME or about my parameters ? I doubt the problem with my parameters, because very often it works well while wring the Excel file.Please help ! Thank you.

Hi, I have lengths for two different types of cable and i need to see the difference and generate report. Calculating values using excel formula in a column. The formula returns TRUE and FALSE values in CSV output. I want to manipulate more to filter out TRUE and FALSE values and outputted as a separate CSV file. Its seems like difficult to do as my column in FME look like this: I would appreciate any help and suggestion to accomplish this task! Thank you,

I have some texts that I have read from DGN format ,texts are colored.I would like to aggregate the texts and be as one together .i have found that the colors converted to black and white .so my question , how could I aggregate the texts and still has the original color . Thanks in advance FME 2018

FME Desktop Build 22304: The fme workbench has “parsing error”, I couldn’t figure out why the fme workbench has “parsing error”. As I open it, all the transformers are deleted. fortunately, I could restore it from the backup What could be the issue here?   

I am trying to extract text from a data catalog website to use for metadata updating. I think I have all the pieces to get a line of text with the correct CSS selector. The problem is that the HTTPCaller doesn't even seem to register anything after the <header> tag so I can't extract anything in the main body. My output always comes out null.Here are a few screenshots of trying to just extract the title of the dataset page:The _response_body returned from the HTTPCaller doesn't even have the main <body> section.Is there any way to force the HTTPCaller to recognize anything past the header tag or is this a security feature of the government website? Thank you for your help!

The error occurs once in a while in a Workspace that is reading a PostGIS/PostgreSQL 12.9 database and writing a GEODATABASE_FILE using 64-bit ArcObjects from underlying an ArcGIS Desktop 10.8 installation. The error is triggered in a DatabaseJoiner, when attributes are joined in from a PostgreSQL table and written to the File Geodatabase simultaneously. The error happens once in a while (every second run or so), but it does strangely not occur on a PC with 64-bit ArcObjects from underlying an ArcGIS Desktop 10.4 installation or in any other variants of the workspace writing to other formats. The error occurs both on Desktop and Server. FME version is 2020.2.3. The error message does not say anything about the GEODATABASE_FILE writer, only the PostGIS reader, but the writer is obviously a part of the problem. If I disable the writer, nothing happens. If I bypass the DatabaseJoiner nothing happens. The message POSTGIS reader: stk::ex::bad_expected_access is discussed elsewhere on this f

I have tried using the unique value transformer but it only accepts a single column. The SQL Executor doesn´t read FDGB. So how could I do an SQL distinct on two columns?

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.

Hi everyone,we have hundreds of excel-files that we would like to read in and format with fme. But the data is scattered over one spreadsheet each. like this:We would now like to sort this data so that it is in order in a row.Is this possible with FME? If so how. Thanks for your help

How to convert esri SLPK file format to PLY file format?

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.

I have been trying to clip/snip a set of multipart linear features with measures based on from and to measure attributes. I've tried running the linear features through the Snipper transformer but all that seems to do is deaggregate the lines.  Is there a way that I can replicate this functionality in FME?

I have a process that reads a dataset from Smallworld to a point feature class in an esri file geodatabase. I works fine in 2019. In 2021 it now fails because apparently there are a few fme_aggregates in this dataset. How can I get these features to write again? GeometryCoercer and DeAggregator aren't working. I need this to work in 2021 but can't figure out how