Best Answers

Hi, Anyone knows how to pass a different file path (parameter) in Batch File?I am calling my fmw in a batch file however I cannot change my source and destination path.

Hello,I have a trouble with zipfiles.I made a script that take multiple files and put them into a PostgreSQL database (in a binary column).My script works really great : I'm using a datafile reader to get files and the PostgreSQL writter put them into my DB without any problems.Where it doesn't work : when I try to import zip files, FME try to unzip them.  I don't want them to be unzipped, I want them to be imported as zip files directly into the DB. Have you any solution ? Thank you for your answer.Best regards.Arthur Bazin

I think this can be done using FME, but I'm not sure where to start... I'm looking for a way to decode IOT dataframes. I attached the documentation, not sure what to do more because I really don't know where to start. Can anyone give me a pointer?

I'm trying to create a ellipse2D or circle shape from four points. i have 4 coordinates (North, South East, West) i want to join up the points with a round shape. I have tried 2D ellipseReplacer, and used East+West for the Primary Axis & North + South for the secondary Axis. its seems to almost work but the scale an shape is slightly differentI have managed to create a Square using BoundingBox Accumulator - But need to fill that box with a round shape, touching all edgesusing 2019.2 DesktopThe image attached shows the 2D ellipse shape overlayed on the 4 points/box. As you can see it's not right. Even when I scale it down it's still incorrect Grateful for any assistance

FME Desktop 2018.1.01. on Windows Server 2012.I started a translation at 1523 yesterday which simply reads point data from SQL Server Spatial and writes it to an ArcSDE layer. At 1821 STATRP lines started appearing in the log. And at the end I got 2 lines saying "Translation was SUCCESSFUL with 1 warning(s)..." instead of the usual 1 line.Statistics are ticked in the translation options but I've never noticed this situation before. What is STATRP, and how is it different from STATS?2019-06-17 18:21:30|9989.8| 2.5|INFORM|Transaction #3779 was successfully committed 2019-06-17 18:21:34|9993.1| 3.3|INFORM|Reading source feature # 3780000 2019-06-17 18:21:34|9993.1| 0.0|INFORM|Transaction #3780 was successfully committed 2019-06-17 18:21:36|9995.6| 2.5|INFORM|Transaction #3781 was successfully committed 2019-06-17 18:21:39|9998.1| 2.5|INFORM|Transaction #3782 was successfully committed 2019-06-17 18:21:40|9999.4| 1.3|INFORM|Reading source feature # 3782500 2019-06-17

Hi - I wanted to find out if a trial license will be lost if FME Server is upgraded? Is an uninstall/re-install and then restore config backup.Will this loose the trial license? If so - how does one continue the trial?e.g. FME Server 2020 installed and wanted to upgrade to 2020.0.01 which I see was just released.Thanks

I have two tables having ID column in common. These IDs are repeated multiple times in both the tables. Now I need to merge these two tables into a single table based on this ID field. I tried using Feature Merger, but the results were not as expected. Some data were missing. Is there any effective way to do a many to many join in FME?  

Hi all, I saw that a WMTS reader has been requested. But meanwhile, I would like to ask whether anyone of you implemented a workaround to read WMTS.I want to read the orthophoto via https://www.basemap.at/wmts/1.0.0/WMTSCapabilities.xml and crop it by a polygon. However, I cannot currently read it. Thanks in advance and stay safe!Best, N

Hi all,I am trying to run a workspace on FME Server (2019) through the Data Download service. This generally works fine in terms of authorization etc. I can successfully pass parameters (and directives) to it as a query string. However, one of the parameters is geometry, currently encoded as OGC Well-Known Text. The input for this parameter can become quite large, as the geometry will be passed to FME Server from a web map. When this happens, the URL exceeds tens of thousands of characters and this seems to break the request.Because of this, I am trying to pass the request as POST, keeping all parameters in the body and thus the URL nice and short. However I can't get this to work - the parameters in the body are ignored and the workspace is run with the default parameters every time.The FME Server Data Download logfile has this line every time:POST request received. Redirecting to GET method. Is it possible at all to use POST to start the Data Download service? If so, how do I pass pa

Hello,I need to retrieve the value of a column header in a CSV file. The column header contains the ID of a meter I need to use as an insert into a database. Unfortunately I can't use a filepathreader as the id filed isn't included. Any idea how I might do this? I have attached a test file. The value I need to extract from the column header is the string after the undescore.

Hi All,Is it possible to write an AutoCAD Layer to a DWG File with no geometry, so that it acts as a placeholder for the end user before starting the digitization process?Thanks,Ana

i used Network topology builder calculator , and each line has specific id so i get the output for which id is connect to which id ,but i have one problem when more than one line intersected it repeats id more than one time bcs as example id 5 connects with id 7 and id 9 and id 10so it repeats one id ,many times it depends how many lines connected to the same point ,so i would like to ask ,how could i give for all connects point the same id_network bcs if A connects to Band B connects to Cso A CONNECTS TO C so all of them should have the same id _network id_network for A =8id_network for B= 8 id_network for C = 8I WANT TO give the same id_network for all lines connects to the same point i do not want to repeat one id more than one time .  

I´m trying to use api http-url as a data source and merge two APIs.The url is: https://alpha-nuukaopenapi.azurewebsites.net/api/v1.0/EnergyData/Monthly/ListByProperty?Customer=Helsinki&Record=PropertyCode&SearchString=PROPERTYCODE&ReportingGroup=Electricity&StartTime=01%2F01%2F2019&EndTime=12%2F31%2F2019  PROPERTYCODE changes and it is read for another data source / table. HTTPCaller I tried to make proper URL call with text editor: Any hints, why this is not working? Thanx!Please see the attachment: 

Hello everyone! I need your help urgently! Please help me!I have a point cloud data from Faro Laser Scan. Scan is from a archeological site. I want to see how much of the area is in related parcel boundaries. So, I mean want to see our scan area on our parcel lines. Parcel boundary is in dwg. format. And both of them in same coordinat systems.,In which format is most useful for point cloud export from Scene Software for this?

Hello,I'm trying to find only the letter D on its own in a string such as the following: B,G,D,DM,TD,DM,TD,D. In this example, that would be 2 D's (the third D and the last D I've marked in red).Unfortunately, all the regex expressions I've tried also gets the D within TD (e.g using D,|D$). Thanks.Tony

I used the surfacedraper to drape the cogopoints on a surface, i'ts look like he doesn't do anything.My goal is to compare the height of the cogopoint with the height of the surface on the same x-y coordinate.My thought was to drape the cogopoint on the surface and compare the height. civil3d2none.fmwbasic.dwg

Hoping someone can help with this. Since upgrading to 2019.2 our existing workbenches have begun to fail. Each time a coordinate system is called on it appears to be missing a curly brace at the end. E.g. "{EPSG:27700 is not a valid key name." or "{OSGB-GPS-2015 is not a valid key name.... Last line repeated 11 times ..."These are only warnings until eventually the workbench fails under:"No definition was found for coordinate system `{EPSG:27700' "Wondering if this is a bug or if we are missing something? Let me know if I need to provide more info.

Reader: MSSQL_ADOWriter: Esri File GDB Feature classTransformer: AttributeManager I am trying to see if I can first set a Where Clause to check if two fields (one from the SQL table and one field from Feature class) match each other. Once this is checked I want to update three other fields in the feature class using the information in the SQL Table

I'm trying to generate a cell averaged DEM to generate smoothed contours within FME. After converting bare earth las points to a DEM using the Raster DEM Generator (1' cell), I want to average the values of those cells for smoother contours and it seems that the Raster Convolver is my best bet. Within the Raster Convolver I'm using a 5x5, weights all set to 1, Divisor set to 1 and Operation set to Mean but my results arent really matching what I can create in ArcGIS, they appear to be shifted to the side, about 2.5'. The Focal Statistics tool in Arc can be used to average the cell values of my initial DEM in a 3 cell radius with proper results. Are there different settings I should be using in the Raster Convolver or is there a better way to go about this?

I have approx 600 points based on top of a surface. I want to be able to generate a 5 meter long line in each of these which is in the normal direction of that surface.This is to be used for planning boreholes in a tunnel.Finding the normal of a surface is ok - but the normal of the point on a surface seems to be more difficult. The lines that needs to be generated is created manually on the last image. 

I tried converting a shapefile to cesium 3dtiles but after conversion some wall surfaces of the shapefile buildings are missing.When i inspected the data in fme data inspector the missing wall surfaces are transparent.Why some surfaces are transparent, I have attached the image of the shapefile viewed in inspector .How to bring all the wall surfaces in the output tileset without missing.

I have two MicroStation Files, one is a parcel map with parcel numbers inside each parcel polygon. The second file is a right of way polygon that intersect the parcels. How do I create individual parcel polygons of just the right of way intersections and attribute each polygon with the parcel number?

"2046": {        "ID": "020935",        "Address": "Bagg Close 9, 29643 Churchtown",        "Provider": [            "D2 - GSM09",            "D2 - LTE08"        ],        "Locationdocuments": {            "stob": {                "date": "/Date(1412546400000)/",                "Applicant": "Vodafone",                "STOB": "c8859eec-63b2-4a75-a2c2-00a586110005",                "TD": "74c192b2-0067-40fc-a41d-f5b5f73afbf1",                "BZ": "0eb422f8-0561-4f4f-8324-d7110ff56ff0",                "LP": "0b37ed04-4d01-4f07-b67f-d8bd2590a66c",                "AD": "c019cc03-c812-4816-8024-407cedeb461c",                "IBA": "9684e283-10e6-4e95-8931-3906fd3a62cb"            },            "12.09.2014": {                "date": "/Date(1412546400000)/",                "Applicant": "Vodafone",                "STOB": "c8859eec-63b2-4a75-a2c2-00a586110005",                "TD": "74c192b2-0067-40fc-a41d-f5b5f73afbf1",                "BZ": "0eb422f8-0561-4f4f-8324-d7110ff56ff0",               

Somehow I have lost my ribbon in FME. How can I turn this back on?

I would like to ask ,if I have four excel file I want at first to compare between two attributes ,Id attribute ,both of them should have the same attribute but some times one excel file has more than another.So ,I would like to check which has more and If first excel file has more than the second excel file so I want to know the new id and extract for each new Id from the third file the data in this row belongs to this id. And at the same time If the second file has more id than first time ,so I would like to extract know which Id is more in second file and add them to first file and extract the data from the fourth excel file .So I want both of excel file ,first and second should be matched in Id and each one extract the missing data from separated file .Because only common between first and second is Id and the rest of data from another two files