Transformers

Hi,In the question https://knowledge.safe.com/questions/44413/lineonlineoverlayer-in-dynamic-segmentation.htmlLineOnlineOverLayer is used to have the desired table. If I have the same first 2 tables (without geometries) and I’d like to do the segmentation before creating geometries to get the desired result like in the example, Is-it possible to do that? thanks

I have a spreadsheet with lines of names and addresses which have comments by the author in square brackets in the names. e.g. Eon Energy [formerly Powergen]. I want to be able to search for and remove everything in the square brackets (and the brackets themselves).  Does anyone know how to do this?

Hi guys,does anyone know if / when the DWG format changes in AutoCAD 2018 will be supported in FME? Will it be in FME 2018.0 or is it in 2017.1?There's some brief info about the format changes on the AutoCAD website here "There are no specific changes that you need to make to use your existing drawing files with the latest release, but you might need to save any new drawing files that you create to an earlier drawing file format to exchange or use them in a previous release."The current FME documentation states that there is support for "reading and writing AutoCAD file versions up to and including 2013"Ch

HelloI need help with FME transformation. I am trying to split the route data collected with GPS into separate line segments at vertices. Then I need to find our the length of each line segment in miles or inches or yards. I need to figure out mph using distance and time.Time is fixed interval but need to figure out length for calculations. Thanks for help!

How would I go about getting a Joiner to read from a CSV created earlier on in a workbench?Currently the workbench extracts coordinates from las files and writes them out to three separate csv's; (Ground, Vegetation and Building) by using a Feature Writer. After a Python distance calculation Vegetation and Building values are then merged separately with Ground, with X and Y being the Requester and Supplier. This takes a considerable amount of time. I'm tested out using a Joiner with the Ground csv being the Reader and it cuts down the processing time. How would I do this dynamically within a workbench and set a Joiner to read a csv that has yet to be created?

Workspace + csv FilesHello i want to create a LandXML with all the points in csvIts work for the creation of the file.But i want to built groups points for each csv in the LandXML output file.I Built a new attribute for the filename: NEWNAMEWhen i write the new LANDXML i have all points in the same CgPoints groupand the rest of the CgPoints with no point.How i can fix this ?Thx

Hi. I've been tasked with plotting the locations of photographs taken from an iphone 6s into a GIS (Data is based in the UK). I've been successful in exposing the jpeg_exif_gpslatitute and jpeg_exif_gpslongitude from the images. With these attributes exposed I've run a series of substring extractors to extract the hours minutes and seconds from the lat long data. I've also been successful in displaying the points at the correct location in the inspector view by using the DecimalDegreeCalculator and vertexCreator transformer. All that seemed straight forward, once I exposed the attruibutes. However I'm now stuck ... I need to create an excel table from FME that holds the six digit UK Easting and six digit Northing for each location. I've tried numerous transformers with no success. (I will be using the workbench to process multiple photographs) I know it is possible as this web page:

Hi Folks,  I have a requirement of browsing parcel boundaries with particular attribute value and create a outer boundary for all browsed parcel boundaries. Here the browsed parcel boundaries are not all connected together, there are some gaps between the parcel boundaries. Please guide me that how can I outer line for parcel boundaries. Thanks in Advance.  Regards, Seshu

I need to generate Near Table between two point ArcSDE feature classes which are in WGS84. The ESRI's solution is arcpy.GenerateNearTable_analysis(baseFC,candidateFC,NEAR_TABLE,"2500 Feet","","","ALL"). It gives NEAR_TABLE with 82 records. If I only want the "closest" candidates, I use this arcpy.GenerateNearTable_analysis(baseFC,candidateFC,NEAR_TABLE,"2500 Feet","","","CLOSEST") which gives 26 records.I think the nearest transformer to do this in FME is GeographicNeighborFinder. See below image. However, it gives 29 records. I assume it only searches the closest candidates. But why is it different than the 26 that ESRI "CLOEST" gives? Does FME has another transformer that does what arcpy.GenerateNearTable_analysis(baseFC,candidateFC,NEAR_TABLE,"2500 Feet","","","ALL") does?

How to update related table automatically without duplicate record.UG and OHTL are two feature classes. related table CircuitSection and ElectricLine.Circuit section will keep 2 records UG and OHTL with the same Line name = A-B ans type as UG or OH.ElectricLine one One record as Linename =A-B and total length which will be equal to all UC segments + All OHTL segments length. How i can update these two related table automatically without duplicate records.Thanks & Regards,AZA

I need to connect a stream of consecutive input points into a series 2-point line segments. I need to retain the attributes of each point.   This seems like an easy problem, yet I cannot find an efficient way to do it. PointConnector wants a "break" attribute, which causes a new segment to start at the "breaking" point, not at the previous point.   1 2 3 4 ... to infinity and beyond X X X X ...   I need segments [(1,2),(2,3),(3,4)]   I'm about to write a python script to do it, but it seems like it should be a simple enough pattern to be able to do with transformers.   --Brad

Hi !   When using several python installations on the same server, they usually don't use windows python path environment variables. How ever, FME cannot start the python module without these (error messages about not being able to find libraries, as you can imagine)  Is there a good way to define unique environment variables (python home, python path) for fme in a config file ?

I'm importing data from a ArcGIS .gdb to a POSTGIS DB using FME Desktop 2016. For this I need first to rename single attribute names using the AttributeRenamer transformer. My poblem is that, reader attributes with width 254 (data type "text") are automatically transformed to writer width 200 (type "varchar"). Why does FME cut the width of the attributes, is it a bug? However, this issue only appears when I use an AttribruteRenamer. I also tryied the BulkAttributeRenamer, which retrieves the same. Any ideas? Thanks

How can I simplify my 3D bounding boxes of pointclouds so that they aren't 3D polymeshes on output but simplified 3D solids? Also is there a way to merge them at the same time into one 3D solid?This is my workspace as it is at the minute

Hi,After converting the DWF to a DWG file, all layers were meshed into one. Also hatches are completely different from the original - hatches converted into singular lines. Is there any way through the Transformer Gallery sets to convert it to the most similar possible version and with all layer names?Thank you!!

Dear takashi, I am facing a problem regarding inputting values in my metadata xml file from another table field. I have an element name <bnr:methods> in my xml and this element value is coming from a metadata table , for some column the value will be 'NULL' and for others it could be " 100, 101, 102..." together. This means a certain column method element has a list of values, but we want to see the real Method names as a list instead of ID list. for example " A, B, C.." where ID 100= A, 101=B, 102=C and this data is stored into another table name METHODE. I have prepared my xml root template expression but this is not working, can you please correct me! ?Thanking youWith best regardsMuqit

Hi,I've got a formatting problem with dateTime that comes with the FileProperty-Reader (as part of Workspace-Reader). The dateTime is not formatted like YYYYMMDDHHMMSS as expected. If month, days, hours, minutes or seconds are just one digit, there is no leading zero. So it displays something like '20171127135' which could be 12th of January 7:13 am and 5 seconds or maybe 27th of November?I'm using 2016.1 and can't check this on later versions so far. Are there ways to get this issue handled or is it an early version bug?Thanks in advance,Maik

So I am having some issue's in pulling the table data from www.nextgenstats.nfl.com. I have tried the HTMLTable reader, and I keep receiving an error message when trying to connect to it. Any suggestions would be great!

I have the following string with duplicate values "Lighting; Lighting; Roads; Streets; Roads; " inside an attribute. I know there isn't a transformer to handle this apart from the StringElementDuplicateRemover custom transformer, is there another simpler solution to this?

I'm working on removing duplicates in a list, but need to filter this based on multiple fields. I can remove duplicates with only one field easily, but am having trouble where it relies on multiple fields.  Scenario: Where a Business has the same name/address duplicates need to be removed. However if a Business has the same name, but a different address, I want it kept in the list.  Example:  Name Address Action McDonalds 123 Brown Street - Keep McDonalds 123 Brown Street - Remove McDonalds 999 South Road - Keep Burger King 999 South Road - Keep   Where I'm at now all I can output is: McDonalds 123 Brown Street Burger King 999 Sourh Road  My actual list has about 15,000 records.  Any help would be much appreciated. 

A friend wants to know if we can publish workflows from GitHub to FME Server?

I have 1000 dwg that has text and lines on 2 layer, i want to merge them all in one dwg and the final dwg should have as layer names all the filename and all the objects (text,lines) should be in only one layer which is the filename the come from.e.g t1.dwg, t2.dwg... -> merge.dwg (with two layer t1,t2...) every object from t1.dwg should be inside t1 layer in the merged dwg, same with the object from t2.dwg should be all inside t2 layer on the merged dwg, and so one for all the dwgs used as input.

Hi all I'm trying to add the zip file size to the data download service notification email.  This is the method I'm using: Workspace writes the data to be downloaded and a json file containing the information elements I will use in the email.Python shutdown script gets the zip file size from the zip file and appends a 'zip_size' element to the json (this doesn't work)workspace published as a data download service with its own success topic and publisher.  The publisher is set to access the info in the modified json file (set as 'Data to Post') when workspace published (this doesn't work) I'm not sure if this is possible.  Can anyone suggest any alternatives or ideas? This is my python shutdown script  import os import json import fme def sizeof_fmt(num, suffix='B'):     for unit in ['','K','M','G','T','P','E','Z']:         print "unit: {0}    number: {1}".format(unit, num)         if abs(num) < 1024.0:

Hi all!After upgrading Clipper program I cannot open DBF format file.The error message: 'Corruption detected Clipper'. I tried to search from google but no answer.What's the problem? What should I do?