Best Answers

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

How to retrieve width and height of JPG and PDFs?

When reading features from a GeoSpatial PDF created by ArcMap, CRS EPSG:28992, I get the following warning in the log:Unsupported projection provided; Using Non-Earth projection insteadThe result is shifted 117 meters north north east.Checked the CRS of the frame:pdf_frame_coordinate_system: _Netherlands-RDNew-2008_0In the Coordinate System Gallery this CRS is known under the names: - Netherlands-RDNew-2008 - EPSG:28992Is the underscore in the pdf_frame_coordinate_system causing the problem?

I have several CSV files exported from Hadoop so the separator is the SOH control character. What do I type as the separator for the CSV reader? I've tried the hex code (\\x01) and copying/pasting the SOH character from Notepad++ but neither work.Thanks,Aaron

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.

I have a web service that I want to access with FME. How can I do that? There is something about REST and OAUTH and such. help?

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.

So I have a collection of 50 Tiff files (historical aerial images). Metadata exists in a separate file, and I get to choose - CSV, XML (FGDC), or KML for the Metadata (I have the metadata in each of the formats.)Metadata includes: Raster Filename, Lat/Lon of image centers, Lat/Lon of each image corner, as well as some more specifics on the image collection. My question is- how do I combine the metadata with the raster files and write out to GeoTiff?I tried FeatureMerge and the data inspector shows what I expect to see after the merge- raster files that have a feature table. When I go to write the files, this "feature table" (metadata information from CSV, in this case) disappears.What am I doing wrong here?Thanks,Andrew

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?

I have a fancy Python script running in my PythonCaller, but I want to use a "Group By" logic to process my features. I'd rather not have to manually split my features and plop down a PythonCaller for each separate stream. Is there an easy way to do this within the Python script? Or any way??

Hello,I'm struggling with an integration problem.I've published a workbench in FME server that must be called from an external application.The standard URL of the published service is like this:http://11.111.111.11:8080/fmedatastreaming/sample/FindAddressCandidates.fmw?param1=AAA &f;=json&maxLocations;=&searchExtent;=&category;=admin&POI;=fme123&outFields;=&forStorage;=&outSR;=while the external application can only call the service using the following URL (without ".fmw" extension)http://11.111.111.11:8080/fmedatastreaming/sample/FindAddressCandidates?param1=AAAIs that possible?Thanks in advanceRoberto

Hi @takashi, I was using your method of importing an external startup & shutdown python scripts instead of typing them directly into the fme. However, I have a Global variable in the startup python which is used in the shutdown script but the Global variable is not recognised when the startup & shutdown python is imported as external scripts. eg.import sys sys.path.append('D:/Scripts') import StartupPython

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

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

Hello,I am new-ish to FME and primarily used model builder for previous needs which may show in how this model was created.So I am reading from .sde, changing some field names among other things and outputting the data to both a kmz and to individual shapefiles to a zipped folder. Not all of the feature classes have NFID within their table so I am using this parameter not only for the output file names, but also to select the line with the specified NFID and then buffer to select surrounding features.I created this to run for one project at a time using a parameter NFID which is basically a project name/number to select the correct data and to name the output folder and kmz file. I want to expand this further and have it run through ideally a list of NFIDs and ultimately read from a good sheet and run based on those values when project status is updated in the table but that will be the next step once I can get this to reset and run for each NFID entered. Current Process: input projec

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 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

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!

I have an oracle .dmp file from FRAMME data and I have no way of reading the data. Can anyone help me with this?

I am looking to write to word doc using the new wordStyler transformer, the images with their header, the problem is I am getting all header together then images. Attached the WS as referenceThanks