Using transformers to modify data.
Recently active
I am trying to have my FME workbench to delete a folder on a windows directory. I was able to use the FeatureReader and read my Directory and File Pathnames and feed it to the FileCopy but this only deletes the files in the folder, not the folder itself. Is their a way to delete the whole folder and its files opposed to just the files? thanks
I am trying to remove all the points inside the red polygon that I drew. Does anyone have any ideas how I can do that without messing up the rest of my blue polygon?Thanks in advance!on
Hi, I have a field has strings and digits, I want to keep only the digits which are falling in different places in the value. What expression I have to use ?Thanks for your help !
Hi, I'm trying the new Projectwise connector in FME 2018, however I can't seem to get it to work or even connect to the projectwise server. This is the error message I get: "Retrieval Error : Unable to make the request to Bentley ProjectWise. Ensure your machine has internet connectivity"Have anyone had any luck with this connector? Thanks! /Jacob
I was using the DateDifferenceCalculator to work out the difference in days between a completed date (contains date and time) and now. This is to find out if the completed date is in the past 30 days. I have now converted this to a SQL query using the DateDiff function: SELECT DATEDIFF(day, completed_date, CURRENT_TIMESTAMP) from ...The SQL function returns different results to the DateDifferenceCalculator, often 1 day less. For example DateDifferenceCalulator says the difference between today (14th September) and a completed date of 17th August is 29, but SQL Server (and Excel) say 28. To be precise, the completed date is 17/08/2018 00:32:00 and the comparison was done at about 14/09/2018 17:20:00. Excel give the difference as 28.7 which I would round down to 28 because it's not yet been 29 days.Looking at the embedded transformer, it appears that DateDifferenceCalculator is rounding up the output value if the decimal point value is greater or equal to .5. SQL Server DateDif
: I'm trying to use Attribute manager to rename/reorder attributes so they appear differently in kml pop up balloons. However instead of getting renamed the attributes are being removed.
I have scanned historic maps in tiff format. None of these images are georeferenced. I have the corresponding bounding boxes for all these files in shapefile. The names of both the raster sheets and the bounding box tiles match. Is there any way I can match the shapefile index with the raster and then georeference the raster tile from this?Any help is appreciated.Thanks
Hi! I'm making a workspace that reads files and folders and upload/recreate these files and folders on a web location. I can't find a good way to upload entire folders to FME Server when submitting jobs. Instead I made a solution that uploads and unpacks zip files to get the entire folder structure to the server. Of course it worked fine with all my own files but when trying a zip file my colleague have made I get the following error using the "ZipExtractor": ZipExtractor_Terminator(TestFactory): ZipExtractor_Terminator: Termination Message: 'Unexpected error: 'ascii' codec can't decode byte 0x94 in position 32: ordinal not in range(128)'ZipExtractor_Terminator: Termination Message: 'Unexpected error: 'ascii' codec can't decode byte 0x94 in position 32: ordinal not in range(128)'Error encountered while calling method `input'ZipExtractor_PythonCaller(PythonFactory): PythonFactory failed to process featureA fatal error has occurred. Check the logfile above for detailsUsing the Unzipper
I'm trying to extract a download-URL within a href. I have tried using the HTMLExtractor, ListExploder and XMLYQueryExtractor to isolate the specific URL to an attribute but with no luck. I need too isolate the URL with the .zip (http://gpt.vic-metria.nu/data/land/NM.zip) from this http://mdp01.vic-metria.nu/geonetwork/srv/en/csw?request=GetRecordById!!!service=CSW!!!version=2.0.2!!!elementSetName=full!!!id=c6b02e88-8084-4b3f-8a7d-33e5d45349c4!!!outputSchema=csw:IsoRecord" target="_blank">webpage . Is it possible and how?
Hi all,I have a multi line string and like to do some adjustments.For example: remove the first line of the multi line stringHow do I select the first line or the first two lines?Thanks in advance!
Hello, I am new to FME, so I'm asking just in case someone faced the same problem as I do.I am trying to convert an autocad DWG file to an SVG file.I succeeded in generating the SVG by mapping an autocad reader to an SVG writer, but the generated SVG contains a transformation :<g fill="none" stroke="black" stroke-width="0.885356531023703" transform="translate(0,6886.85) scale(1, -1)">My svg is consummed by a js componnent which doesn't support scales other than (1,1)I tried to use a scaler transformer with 1x/-1y factors but it was unsuccessfulIs there any way to fix this ?
Hi allsimple question ... I have a street network with polyline and I need to extract a centroid of polylines but the polylines are aggregates so if I use CenterPointReplacer I obtain the centroid but not on the polyline Can you help please ? In Arc also if the polyline are aggregates feature to pint create a centroid along the line. Francesco
Morning, I have a list of attributes that I've created with DateTimeConverter in the format %H:%M:%S. However, there is a decimal point at the end with a couple of numbers.Eg. 08:13:56.236Does anyone know a way to get rid of everything after and including the decimal point? I've tried attribute splitter and rounder and also @int() and @floor(). But nothing seems to be workingThanks in advance :)
Hello During the clinging process I get the result below, is there a way we could remove the highlighted lineusing FME Thanks
I have a raster representing rainfall intensity as detected by radar.The image is in a custom gnomonic projection. I want to reproject into a Lat/Long GDA94 projection.How do I define a new custom projection in FME?The projection information I have been supplied with, in a .map file is;IDR663.map66 Brisbane (128 km) projection = Gnomonic center_longitude = 153.24001 center_latitude = -27.71810 lon0 = 151.93095 lat0 = -28.85765 lon1 = 151.95828 lat1 = -26.55640 lon2 = 154.53113 lat2 = -26.55632 lon3 = 154.55867 lat3 = -28.85755Thanks!
What does the term "FME orchestrator" mean?
So, I have two files. File 1 contains 1 point and file 2 contains 10 points. Basically, for every point in file 2, connect it to file 1 and I will end up with 10 points.I can do this in Python easily but not sure how to do it in FME yet. I am using FME 2016 btw.Thanks in advance!
Hi! Is it possible to add layers to an empty (contains no features) dwg-file which already contains some layers? The new layer's names are contained in an Excel-file. Unfortunately I can't upload the empty dwg-file for some reason (the upload progress bar comes to 100% but then nothing happens; the file is only 97 kb), so the Excel-file is the only attached file. Best regards, Ken
Dears,My purpose is to find routes which connect the pink polylines (by Shortest Path Finder) within the area features to the black marked network elements, taken into consideration one attribute value (_sum, the higher the better) of joining lines of the same network (displayed by green) at every intersection. I have already created a loop, containing two SpatialFilter transformers, where Filter is the pink polyline and the Candidates are the green ones. By using this, I could iterate through the green marked network, but it neither considers the value of '_sum' attribute nor the location of the black network elements. Therefore my question is: how can I spatially select those green lines which hve the highest value of '_sum' attribute in order to form a continuous connection between the black and pink networks?I hope, my explanation was clear, but let me know if you need additional information.Every suggestion is very appreciated.Kind regards,Niki
Using infoworks ICM we have run 2d simulations on a flooding scheme. We have run a baseline series and two solution scenarios however due to the solution involving a water basin, the ground model has been altered and therefore the mesh is not identical to the baseline.I previously created a tool which takes the baseline 2d results for each mesh triangle and compares to the flood depth to the solution 2d results but this tool only functions correctly when the mesh tables are identical. Therefore we believe that the next best way to do a comparison with two different mesh tables would be to create a raster for each and calculate the following (baseline depth raster - solution depth raster) in order to gauge the solution performance. However being new to the software I am struggling to work out how to create the rasters and furthermore, how to compare them. Any tips?FYI - The current tool uses max mif files exported from the simulations in ICMCheers
Hi,I thought I'd solved this issue with a spreadsheet reader however I appear to be experiencing the same thing with a CSV reader. Whenever a record with a null date field hits the writer it will have the error "attribute could not be written. The containing feature has been dropped." - but I still require that record. With the spreadsheet reader once the spreadsheet date fields were cleaned up so they only had either a date or a null value (the cell contents were cleared in excel) it worked fine. I would've thought that a CSV reader would have less difficulty. Is there a transformer/parameter out there that remedies this issue?Any ideas FMEers?Cheers,Mike
Hello all,I have two layers, one of roads (lines) and one of electorates (polygons). The roads intersect the electorates and one road can intersect more than one electorate.For each road feature, I want to add the name of the electorate that the majority of the road falls within.I am using a SpatialFilter to populate the roads with the names of electorates but I don't know how the transformer chooses which electorate to populate the road feature with. Is it just the first electorate that happens to intersect?
I have a large raster with 1 band (NDVI) though it could also be multiple bands (different vegetation indices). I also have several hundreds of polygons. I would like to use zonal statistics to determine min/mean/max/stdev of NDVI values of these polygons. How can I do this in FME? In ArcGIS and QGIS this is a one click affair.I am aware of the existence of Rasterstatisticscalculator, but it does not have that much documentation. My current workflow is as follows:but the following things are confusing me: Why does rasterstatisticscalculator turn the three clipped rasters into 1 raster? And how do I extract the results back into the shapefile? Example workflows of how to perform an efficient zonal statistics would help immensely!Thanks!
Hi all,I'm fairly new to FME and have an issue I hope you can help with. I have a shapefile of overhead powerline spans and have been using the FuzzyParrallelLineFinder custom transformer to find spans which (likely) share a right of way (ROW). Each span of the line is a separate feature. Often the ROWs are more complex with not quite parallel lines (hence the Matcher not quite doing the job) but this is just an example:My ultimate goal is to merge these spans into a single ROW centreline with attributes taken from all of the input spans. The transformer has been working great and the matches I am getting back are really promising and make sense. It provides each matched feature with a _line_id and a _match_id linking to the best case match _line_id, along with various other stats I can use to filter matches. There is also a list of best case and additional matches. I can use the stats to filter out matches that aren't useful but beyond this I am unsure how to use the output t
What's the best way to rasterize a 3D polygon (not constant Z value)?The NumericRasterizer is very efficient (3.2 seconds) but uses a single z value (first vertex?) for the entire polygon. The RasterDemGenerator produces the desired results, but takes over 1.5 hours to run. Is there an alternative to the RasterDemGenerator that is more efficient?