Transformers

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: { "qu

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 data And 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 fit.

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 all I 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 DateDiff functi

: 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 details Using 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 string How 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 unsuccessful Is there any way to fix this ?

Hi all simple 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