Using transformers to modify data.
Recently active
I have a scenario where I need to convert the bit depth of a raster from 16 bit to 8 bit, or vice versa, but the type should remain the same. ie Gray16->Gray8, Int16 -> Int8, Red8 -> Red16, etc.Given that the RasterBandInterpretationCoercer does not accept attribute values for the Destination Interpretation Type parameter, is there an alternate method to testFilter for all allowed types, and 14 hardcoded RasterBandInterpretationCoercers?
I have an XML extract using a Soap interface that has a section with lists of user defined attributes. I have a schema for these but I am having trouble extracting the contents. I expect to be able to rename the fields based on the order after extraction. For example in the IDENTIFICATION path there are UserFields{1} to {5} that I want to extract and label like this 1 Manufacturer No Alphanumeric 40 2 Manufacture_Date No Date 11 3 Model_Number No Alphanumeric 40 4 Make No Alphanumeric 40 5 Serial_Number No Alphanumeric 40
Hi,I'm trying to download table data from Statistics Finland PX-Web API (documentation here http://pxnet2.stat.fi/api1.html). URL for example for the cube and the table containing population demographic data is: http://pxnet2.stat.fi/PXWeb/api/v1/fi/StatFin/vrm/vaerak/statfin_vaerak_pxt_001.px . Px-Web API can return table data in various formats, including csv and excel.Using HTTPCaller and GET or/and JSON-reader I've been able to receive nested JSON containing list of all the different variables of the desired table, but the problem is that this request does NOT retrieve the actual data.In my understanding I should send a specified JSON-query using GET/POST-command to API to be able to download the actual data. But I have no clue how to do this in FME. I've tried to go through JSON-readers schema scan using JSON-query, and I looked for the HTTPcaller but don't know if Query String Parameters or Body settings could help me with this. JSON-query should look somewhat like this:{ "query
I want to connect the orange and green points together to form 3d polylines (I'm in effect wanting to create a ray). The orange points represent a point on the ground and the green points represent the point in space where an image was taken of the point on the ground.
How to convert trimble sketchup (.skp)-files to Esri MultiPatch, with first alignment en clipping on a GIS-buildingunit-layer
How can i create a generic fmw file(X format to Y format) that can convert any x format file to y format.Instead of creating new fmw file for every(X format to Y format) conversion.Is that possible.
Hi guys,I am comparing 2 sets of data (6 months apart), in separate file geodatabases. There are approximately 18 feature classes in each database with a roughly 50,000 features in each class.Is there a way I can run a change detector on each feature class without having to add each feature class individually to the workspace?Cheers, Dave.
Hi. Me and my collegues have encountered this problem many times but we still haven't found an adequate solution. Please help! This is actually exactly what the Excel command Transpose does (when pasting copied data).I want this data to be transposed to this dataAnd if there a more ELEMENTS (after Zn) it should dynamically be included... We have looked at all the transpose posts here but we haven't found a good answer. ELEMENT, As, Ba and so on should be turned into attribute names for further use in the script. Any help will be gratefully accepted.Peter et al
Hi FME experts, I'm having difficulties updating below: Left is what I currently have, right is what I'd like to have. Have Want Toi et Moi (Villa) (Villa) Toi et Moi Wilgenerf ('t) Landhuis ('t) Wilgenerf Landhuis Gheestelic Hof (Het) (Het) Gheestelic Hof So if it finds anything in between brackets, take that and put it in front of the string. I've been trying the StringReplacer with the following RegEx: (\\(.*\\)) - but no luck so far.Cheers, Ed
I have a bulk soap extract that has a list of assets with attributes as properties, not elements. I cannot find in the many XML transformers what I need to do to get the assets back into a simple table with each property as an attribute.Here is a snippet of the first two AssetSummary elements.
When using a negative buffer value on too small polygons, they are always output as rejected features (since there is no valid part of the polygon to output). Is there a way to filter beforehand such that these features aren't rejected?
Hi,I have a polyline feature class in a File Geodatabase (10.3.1) describing the routes of pipelines. These are 3D polylines. Each vertex contains four properties: the first three describe the X, Y and Z coordinates, and there is a fourth "ID" property that contains an integer value. This "ID" property is never used by the feature class to hold any information regarding the vertex index. It's basically an empty tag. In my case this integer value was used to hold some status information. Now, I wonder if it is possible to access this "ID" property. I have not found a solution in FME Desktop. In the end I need to extract all vertices in order for each polyline, describing the X Y Z and ID values as field attributes in a table.The "ID" property was set using ArcObjects. It can also be accessed this way and I believe the ESRI's Geoprocessing framework (python) can read/write it as well. But for my solution and FME workbench would be a better
I am trying to get information from a QGIS project and layers and produce a new project based on new analysis results made on FME. (I know that the qgis project file is an xml and so I can read it as an xml, but i am trying to build a bridge between qgis 2.18 and fme desktop 2018)How to install the PyQGIS module and then using the custom python interpreter in FME Desktop?I am using QGIS-ltr 2.18.23 (from OSGEO4w64) and FME 2018.1.0.1 (Win64).
Hi,I have one table that I'm using for several schema mapping depending on the object.To do that my schema mapping is a combination of a test filter with several outports and each of these outport is connected a schema mapper (see below). All the schema mappers are reading the same table but their where clause is related to the the condition used in the Test filter.Is there a way to dynamically change the where clause inside the schema mapper transformer so that instead of having this complex custom transformer, I can use a simple single schema mapper transformer? Thanks
Hi allI searched the Knowledge Center, but I didn’t found a solution (maybe I overlooked something). I have an AutoCAD drawing with polylines containing arc and line segments and I want to write this polylines to a GeoPackage database. The geometry of the gpkg feature class is »line (CompoundCurve)«.When I write the polylines to the database I don’t get arcs but only line segments. (refer to attached picture). Is there a solution to write the data with lines and arcs in the database?I get the correct feature, when I’m writing »interlis« data to the GP database .
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!