Transformers

I have a standardized xls form that does not use columns. It is designed as a field form and has all cells locked except where the field personnel are to put data. This is more like an OCR type of conversion than excel. all the values I need are in specific (sometimes merged) cells. So there is not a column which contains a value. I am able to retrieve all the data and can see it all in inspector just not format I need. Each file is a separate event. Each sheet is a separate feature. The data for each feature is always in the same cells. I need to output each feature as a row. I have attached an image showing 1 sheet.

Hi, I am trying to extract a HTML page. I would appreciate if any of the expert can explain to me on how to extract :<tr data-group="Batu Pahat" data-group-2="Sekolah Agama Seri Chomel"><td data-field="Daerah" class="ew-rpt-grp-field-1"><span data-class="tpx1_1_Maklumat_Bencana_Daerah_Aktif_Banjir_Johor_PusatPemindahan">Sekolah Agama Seri Chomel</span></td><td data-field="Keluarga" class="ew-table-alt-row"><span>6</span></td> I would like to extract the bolded ones from the HTML page using HTML ExtractorYour help will be kindly appreciated

We have a workspace that uses a SystemCaller to run an exe for another application. This works fine on Workbench but fails to execute on Server.We have tried running exe from the command terminal on the server remote desktop and it also runs successfully. The log file for the job just states that the execution failed.Does anyone have any hints or solutions as to why this may be the case and how to solve it?

Hi there,I am new to FME, so please accept my apology if my question sounds too simple or stupid. I want to calculate two new attributes. Both attributes have different calculations. I am using Expression Evaluator. I can only calculate one attribute. For another attribute, I couldn't find any option to calculate another attribute. Am I supposed to use a new expression evaluator for another attribute? or is there any other way to calculate the new attribute? 

Hi, I'm new at FME and want to do the following:there's a process running at our server which is logged every night. We would like to get a warning when certain errorcodes pop up in the logfile.For those (= [ERROR] and [WARN ]) of that night (filter on date of today) the whole line should be placed in another file.The file looks like this:2019-12-10 12:45:58,644 [WARN ] TrfAgiv.TrfCeviErrorHelper terreinobject 7654048 - CRCODE 'aardTerreinobject' - 'grbAdmPerceel' (6004) wordt niet verwerkt (NAARGEM = 0)2019-12-10 12:45:58,646 [ERROR] TrfAgiv.TrfCeviErrorHelper terreinobject-huisnummer 20903264 - Niet alle noodzakelijke bovenliggende gegevens werden gevonden.2019-12-10 12:45:58,647 [DEBUG] TrfAgiv.TrfCeviHelperEf terreinobject-huisnummer id: 209033222019-12-10 12:45:58,874 [DEBUG] TrfAgiv.TrfCeviHelperEf --> straatnaam id: 55794 opslaan, synchroniseren: False There's an exemple of the file attached.What would be the best way to go?Thanks!Isalogfile.txt

Hi, I need some help on using the clipper transformer with sets of solid features: I have one set of solid features as clipper and another set of solid features as clippee, as a result I’d like the intersections of these solids with merged attributes (so that a feature ‘knows’ it’s an intersection of clipper X with clippee Y).In my simplified example the clippers are with yellow numbers, the clippees in red. In this case I'd like to have 4 new solids as a result. I thought Clipper would do the trick, but:my incoming clipper solids are going to the ‘rejected’ port, and although my workspace parameter ‘rejected feature handling’ is set to ‘Terminate Translation’, the translation continues (which is OK but unexpected, I think?)more annoying is the fact that the incoming clippers seem to be merged to 1 ‘multisolid’ taking attributes from the first feature? I expected 4 new solids as a clipresult, but 2 ‘multisolids’ exit the transformer:The selected solids in the printscreen indeed are

This may or may not be only answerable by the good people at Safe, but does anyone know where the SQLite database generated by InlineQuerier is created? Is is a temporary physical file, or instead uses SQLite's temporary in-memory (virtual) instance option?Just thinking ahead to some workspace performance tuning options. My workspace InlineQueriers work fairly fast but then the underlying storage is my local PC's SSD so that performance may not translate when executing where the read/write to the SQLite DB involves a different physical file storage environment.

Hello @takashi I have an AreaBuilder before the ListCombiner. If areas are built they are then checked if they touch/ intersect via SpatialRealtor. After that the ListCombiner will group on the spatial settings. The problem is that if no areas are built (incomplete), I get the error message "PythonFactory failed to close properly". Is that probably because there is no attribute from built area to compute on in "orderByGroup"?So I wounder if there is a way to not activate ListCombiner (PythonCaller) if AreaBuilder returns incomplete? Please see attached image for log message.Thanks.

Hi everyone,I have this gdb with about 14'000 lines (alwas only 2 points). In the gdb there is an attribute for every coordinate of the points of the line (E_left, N_left, E_right, N_right).My problem is that the lines need to be generated from left to right which is not the case at the moment. How can I change the geometry "IFMELine (2coordinates)" so that the start point "coordinate 0" of the line is defined by the attributes E_left and N_left and the end point "coordinate 1" is defined by E_right and N_Right?Thank you very much,Davide

Hello,I'm a beginner in FME and I need to run a model that was made by my colleague.When I run it, I get error message:CS-MAP Reprojector: User specifed transformation 'SERBIA_to_MONTENEGRO' will be used for 'EPSG:31277mgi' -> 'EPSG:32634'Geodetic transformation (SERBIA_to_MONTENEGRO) not found in dictionary.CS-MAP Reprojector: Transformation 'SERBIA_to_MONTENEGRO' could not be loadedReprojector: Could not create reprojection engineStoring feature(s) to FME feature store file `C:\\Users\\dusan\\Desktop\\Transformacija_CG_GK_u_UTM_V1_log.ffs' As I understand this, I need to configure local coordinate system. My question is, what files I need to change to have this custom coordinate system in FME? Thank you in advance!Marko

We made buildings in Minecraft from 3D data. One problem is that the facades have twisted blocks, Is is possible to change the block orientation so the blocks point in the same right direction for every house?

Hello,I was given a PDF with survey benchmark information on it. Each page in the PDF is has information on one benchmark (see attached "Benchmarks_sample.pdf". I wanted to get this information into a tabular format so I can have a list with the columns: BenchmarkID, Easting, Northing, Description. All of the info for the columns are within the PDF but I'm having a hard time extracting the information into the columns. I'm using the PDF2TextReader from the FME Hub (https://hub.safe.com/publishers/timalbertvictor/transformers/pdf2textreader) which works pretty well for extracting the data. However, I am having a hard time isolating the pertinent information to the appropriate column.Any tips/help on this matter would be helpful. Thanks!  

Hi to all,I'd like to add to my insert procedure a specific sql function for example add a to_tsvector(my_column). I've tried to add it in different manners but the result is always my value with the function name written in the column. Is it possibile to do what I want with a writer or I have to use an SQLExecutor and write my desired insert statemenet?Thank you

Hi,Is there a way to do both operations at the same time? I want it to update the existing ID's and insert the new one in a access database so i can store the data. There is not always an update required , sometimes the existing ID's are not given again.Thx!Nathalie 

Hi Community,I have a simple task I thoughtm but I can't get it to work. I have a long string (URL) with lots of forward slashes. I would like to find the last one or actualy I would like to get the string after the last forward slash. To find the last forward slash I used the @FindString function: @FindString(@Value(exampleURL),"/",-1). It returns -1 instead of the actual place of the slash. When I search from the beginning it works fine: @FindString(@Value(exampleURL),"/") it returns 5 which is the postion of the first slash in an URL. What am I doeing wrong?Thank you

No real question, but I want to share some insights for my Belgian colleagues. In FME, there are two 31370 coordinate systems: EPSG:31370 and Belge_72.Lambert_72_FME. They are exactly the same, except for the Esri WKT Description. The first one contains false easting and northing up to 5 decimals, the second one only three (like the OGC WKT). Until ArcGIS 10.6, you have to use the EPSG:31370, with the additional decimals.Starting from ArcGIS 10.7, ESRI changed the description of the coordinate system and applied the OGC values with 3 decimals.  Opening a filegeodatabase with EPSG:31370 in ArcGIS 10.7 leads to a 'custom coordinate system', not recognised by the software. Using the Belge_72.Lambert_72_FME coordinate system in FME avoids this issue. I hope this post will help some people saving some time.

How this can be achieved in FME?https://support.esri.com/en/technical-article/000011817Source data – 2D point geometry with attributes 'FROM' and 'TO' (elevation values stored). The goal is to create 3D lines from those values.

Is it more efficient way to separate outputs based on multiple attribute value? In this case, I have 3 attributes and 3 testers, alongside 3 attribute renamers. The goal is to have all three attributes merged horizontally (by adding features) in one attribute, filtering out empty values. See the attached workspace.  

Stupid question, but I'm wondering how much post-processing I need to do on the output of a ShortestPathFinder before writing it into say, an FGDB.So, a Path is not a Line feature in FME, it seems to be really an aggregate of its component segments, and each segment has a direction indicator on it so that the Path "knows" how to virtually act as a line with the correct virtual Vertex order, regardless that the component segments that are its aggregate, could alternately be running in opposite directions from each other, and one of a Path's segment's start vertex be an adjacent segment's start vertex as well (ie. The adjacent segments run in opposite direction to each other)However, if I put the output straight to say, SpatiaLite or FGDB, then the writer needs to downconvert the Path to Line. Fine, this is desirable behaviour in my case.My question is though: In what order do the vertices get written? In the direction of the Path, or does it depend on the orien

Hi!I have lines connected to a feature. I would like to give a number to my lines on clockwise orientation in relation to this feature.Do you have an idea?Thanks! 

Hello FME´ers,please, there is one big challenge to generate walking route for postman in census. What I have:- points (households) - one point can represent one or more households, accorging to attribute value- lines (streets)I need to generate routes for postman that contain visiting of 50 households per day, every household must be visited only once. Every route should be unique.Please, is there any idea, how to figure this challenge?Thank You so much!Lubo

Hello,How is that possible that the log is showing inconsistent timestamp values?  

Running the VoronoiDiagrammer is producing some very weird results. Mainly huge strangely shaped polygons around the edges covering the whole globe as seen in the first image. The image below that is from qgis (same input data) and shows the output I was expecting. Anybody know what is going on?

I can't seem to line up my elements/attributes on this lookup table I'm creating. Thanks in advance!Below is the screenshot of the XML attribute I'd like to create a feature from.Below is the parent-children tree of the elements I want to retrieve from my XML file.This is the screenshot of my workspace and configuration. Enable Flatenning is checked and all options are default.This is the result I'm getting from the workbenchBelow is the expected result  DomainNetworkNamenetworkSourceIdNetworkSourceNameAssetGroupCodeAssetGroupNameAssetTypeCodeAssetTypeNameElectricDistribution6ElectricDistributionDevice1Arrester1Distribution ClassElectricDistribution6ElectricDistributionDevice2Breaker1Air PoweredElectricDistribution6ElectricDistributionDevice3Capacitor1Fixed CapacitorElectricDistribution6ElectricDistributionDevice4Circuit Breaker1Air PoweredElectricDistribution6ElectricDistributionDevice5Elbow1Load BreakElectricDistribution6ElectricDistributionDevice6Fuse1Automatic Secti

 Hello,I am trying to find a soultion of workflow in FME, as to the attached image.My first attempt was to use the "NeighborFinder" and check if a footprint touches another. Then group/ list those (light blue circle). Then perhaps do another "NeighborFinder" check within a i.e. distance of 15, and make that a merged list (dark blue circle).I appreciate any idéas. Thank you!