Using readers and writers to extract and load data.
Recently active
I have a folder containing hundreds of tif and related extension files e.g. NS26.tif, NS26.aux and NS26.rrd. I want to rename them adding a suffix i.e. NS26_c.tif, NS26_c.aux etc. I can manage this using filecopy to the existing folder but because the filename has changed overwrite won't work so I end up with new and old in same folder. Any suggestions?
i would like read two polygon from one reader not only one so what should i write in WHERE CLAUSE to read two polygons at the same time to execute both ofthem together .i am not expert in sql ,i am still beginner .could some one help me ? Thanks in advance
I am using a 'PythonCreator' and 'PythonCaller' transformer to create a series of SQL select statements. The latter are used in a 'SQL Executor' transformer to read many features from an oracle db. Eventually, these features have to be written to .json files. Because I initially used the PythonCreator, all the feature have 'fme_feature_type' set to 'PythonCreator'. When using the GEOJSON writer in FME Desktop 2017.0 (build 17259, 64 bit) , this results in an error message: 'Unknown feature type 'PythonCreator' passed to the JSON writer'. Other writers (SDF, shape, excel, etc.) work fine.If I use an attribute manager to set the 'fme_feature_type' attribute to other values, the writer works fine. Could anyone explain why the writer has problems with an fme_feature_type named PythonCreator? I could not find an answer in the documentation on the GEOJSON writer; so that is why I am asking it on this platform.
How can I read all Paper Spaces from Acad file? I can set 'Read Selected Paper Spaces' parameter, but I need something generic like using * character.@takashi
I'm in the process of migrating a number of workbenches/workspaces from 2018 to 2020. Many of these were created years ago in much older versions of FME. So I'm meticulously going through an updating all elements in the workbench, then running it in Desktop and finally publishing to Server 2020. Running into very few issues but I can't get Desktop 2020 to read zipped GDB using the GDB reader. Where it does so in 2018, it fails in 2020. Unable to connect to the File Geodatabase at 'path..../GDBName.zip'. Make sure the correct filename was specified, and that the geodatabase wasn't saved with a newer version of ArcGIS than the one installed locally. The error number from ArcObjects is: '-2147024893'. The error message from ArcObjects is: {}A fatal error has occurred. Check the logfile above for detailsIt will read the GDB just fine if I manually unzip it in the same location. So it's not permissions or issues with a bad GDB. Anyway, I can come up with a workaround - just wondering if th
I have almost 100 subdirectories, each with shapefiles of the same names, eg:/dir1/FileA.shp/dir1/FileB.shp/dir2/FileA.shp/dir2/FileB.shp/dir99/FileA.shp/dir99/FileB.shp Not only are there almost 100 directories, there are also about 30 shapefiles in each.Is there a smart way to get an FME workbench to read all these subdirectories (they are all stored under a common "mother directory") and files, so that I can merge them into one Shapefile each? What I want is to merge all FileA.shp into one file, all FileB.shp, into another, and so on.
read another input file and execute again my transformers, write in the writer, and so on for all my inputs files. regards,
I am trying to connect to an ESRI basemap through a REST endpoint and utilize the resulting raster within a VectorOnRasterOverlayer, but I cannot get the raster within my workspace to work properly. Here is the URL that I pass into the ImageFetcher. This results in an image but it doesn't know its spatial placement and such. I have tried to return JSON but I don't really know what to do with it...https://services.arcgisonline.com/arcgis/rest/services/World_Topo_Map/MapServer/export?bbox=-87.835947%2C31.067928%2C-87.601273%2C31.214859&bboxSR=4326&layers=&layerDefs=&size=&imageSR=&format=jpg&transparent=true&dpi=900&time=&layerTimeOptions=&dynamicLayers=&gdbVersion=&mapScale=&rotation=&datumTransformations=&layerParameterValues=&mapRangeValues=&layerRangeValues=&f=image Any help on this would be greater appreciated.
The WLAS reader can process version 2.0 and 3.0 files. Version 2.0 is very similar to 1.2 so possibly the reader can parse version 1.2 files as well.
I am wanting to set the twist angle on an existing viewport, I see twist angle in the DWG reader but I am having trouble finding how to identify the viewport in autocad since they are not named, can I use viewport order and only rotate view port with same order? After that I think it is simply a matter of inserting the proper attribute on export but I am not sure what the name of the attribute is.
Hi Guys, Can anybody help me with this. In condition statement i putted if a like b value is @int@rand()*4 which gave me random value 0,1,2,3. Now in else i want to put rand value 6, 7,8 How can i do this ?? It would be a great help Thank you 😊
I'm using FME Server 2019. i have created a fme workbench that reads from Shape file and writes to Smallworld. The workbench is working fine in FME Desktop. After publishing the workspace to FME Server and I run the workspace, I've got warning in the log saying Warning: not all FMESessions that were created were destroyed before shutdown. This may cause instability.I have 32-bit fme engine installed that can connect with Smallworld. I've started the tics server using fme_tics_server.start("30000",_unset, :electric_dm). All these parameters work well with FME Desktop. Is there any way to find more details on the error or debug this? Can anyone please help me on this.?
What software or extension do I need for connectin gfrom FME 64 bit to ArcFM 10.6.1a GeoDatabase (ESRI version 10.6.1) running on Oracle 19c? We know the 32 bit FME can connect with ArcFM using the Object Reader library but couldn't get 64 bit FME to conn
I gather @runneals has also had this. Writing (truncating) to an ArcGIS Online feature service (that was created by FME) fails with the following error. WARN |ArcGIS Online Feature Service Writer: 'addResults' error for a feature in 'MAP_WS_POINT'. The error code from the server was '1000' and the message was: 'The type initializer for '' threw an exception.' 2021-01-25 23:34:13| 24.4| 0.2|WARN |... Last line repeated 999 times ... 2021-01-25 23:34:13| 24.4| 0.0|ERROR |ArcGIS Online Feature Service Writer: 10000 features successfully written to 'MAP_WS_POINT', but the server rejected the 1000 features in the last request due to errors Anyone else getting this? Have asked our vendor but just posting here for wider visibility. It came up for the first time last night.
I'm new to FME, but we brought it in to manage the new Mapinfo .mrr grids we were getting. I'm having a few problems getting my head around it though.I'm trying to contour a classified .mrr file, with One band (0) and two Palettes (0,1).I want to write polygons with the Palette 1 string values(eg. AAA-1, AAA-2, AAB-1, AAC-1) so I used RasterSelector to pick band 0 and Palette 1 the RasterToPolygonCoercer to create a .tab polygon file. It writes the polygons correctly but assigns BAND 0 value not the palette value.What do I need to do to expose the Palette value?Edit: I'm using RasterPaletteResolver on the grid but it seems to crash on a <Rejected> feature...Palette Keys -> Values : Band 3 : Palette 0 : 2195 -> AAA-1 Palette Keys -> Values : Band 3 : Palette 0 : 2196 -> AAB-1 =========================================================================== RasterPaletteResolver_<Rejected>(TeeFactory): RasterPaletteResolver_<Rejected>: Termination
FME 2020: How to bring the value of point layer into polygons with the “SpatialRelator” tool? In the screenshot below, I wanted to bring the values of a particular field of point layer into polygons with the “SpatialRelator” tool but appears not to work. What could be the issue here?The data is attached
I have an FME Desktop Workbench 2019, with a Reader transformer that reads a webstie zip file and its shapefile. When I run this manually on Desktop it works fine and it can obtain the shapefile and read it. I need to automate this to run daily. When I publish this workbench to FME Server and run it there, I get the following error: 49 ESRISHAPE Reader: Dataset `C:\\Users\\FME-SVC\\AppData\\Local\\Temp\\fmeengines\\CAL-FME-GIS_Engine1\\FME_TempFileStore_1611253240189_1116820\\PLA_RTF_SHP.zip' lacks the required extension `shp' What transformer can I use instead of the reader so it can work in FME Server? Or should I download the zip file with HTTPCaller, store it in the server and then attempt to read it from the server? But I need to read the shapefile in the zip file. Is there a process or method anyone is familiar with to automate this in FME Server? Thank you.
I managed to add SummaryInfo Comments (also known as DWG properties) to DWG files (created by FME Desktop) using ObjectDBX in a Windows Powershell post process and wonder if it is possible to do it directly in FME Desktop:$srcDir = "C:\DWG\infiles\"$tgtDir = "C:\DWG\outfiles\"$errorFile = 'C:\DWG\error.log'$comments = 'C:\DWG\comments.csv' $AutoCad = New-Object -ComObject Autocad.Application$AcadVer = $AutoCad.ActiveDocument.GetVariable("ACADVER")$AcadVer = $AcadVer.Split(".")[0]$DbxId = "ObjectDBX.AXDbDocument."+$AcadVer$Dbx = $AutoCAD.GetInterfaceObject($DbxId) foreach($line in Get-Content $comments -Encoding UTF8){ $data = $line.Split(";") Write-Host $data[0] try{ $Dbx.Open($srcDir+$data[0]+".dwg") $Dbx.SummaryInfo.Comments = $data[1] $Dbx.SaveAs($tgtDir+$data[0]+".dwg") } catch{ $error_msg = $srcDir+$data[0]+".dwg" Out-File -FilePath $errorFile -Append -InputObject $error_msg Write-Host "Error: ",$data[0] }}comments.csv:4233-15_1;Last Change - VA40:21.10.20204
I have a very basic workbench, which reads data from FFS files and should write around 15000 lines in the ESRI ArcSDE Table (SQL Server 2014). Unfortunately, when the workbench is ready to write the data in the table, I receive "Error running translation" with two BADNEWS issues in log which appear only in Debug mode:....ArcSDE release: '10.0'. Underlying database: 'SQL Server'A default z-value of '0' will be used for all 3D features where z-values are not providedGeodatabase Writer: Not simplifying geometries being written to the GeodatabaseError running translation......Kindly find complete log here The writer which I use is "Esri Geodatabase (ArcSDE Geodb)". The same behavior I have with writer "Esri Geodatabase (Personal Geodb)" but if I change the writer to pure Microsoft Access, I am able to write in the data. In the Win Event Viewer I can find two error messages each time I execute the test (sorry that it is in German)I am u
Hi,I have a problem with adding a reader for a geopackage that contains a TIN. Adding the reader fails with the message: "No geometry mapping entry found for 'wkb_point' in metafile 'C:\\Program Files\\FME\\2020.1.0.1\\metafile\\OGCGEOPACKAGE.fmf'" Data is somewhat strange, since the layer identifiers are long (way over 30 positions) and contain spaces and minus signs. In QGIS, the data is displayed correctly though... Any idea what might be causing this error? The data is proprietary, so I can not share. I'm using FME 2020.1.0.1.
Hey thereI don't know if this is the right place to ask but here we go anyways.I am trying to get data from a geoserver and transform 2D Data into 3D Data as an IFC. I am absolutely new to FME and I am struggeling to achieve anything. I tried that short example with AutoCAD to IFC Conversion: https://community.safe.com/s/article/autocad-to-ifc-conversion-example I Mean, it works fine, but I dont know what it does exactly. I somehow want to do the same, but instead of a AutoCAD building I want to transform some objects from a geoserver (electricity lines or other objects that are in 2D) into an IFC. Can someone give me some tips? Greetings,Philipp
Hi Community,First post :)I have an IMAP publisher which downloads GML attachments. The files containing folder name is based on the email subject i believe. This seems to work perfectly when this file path is being processed by the Workspace subscriber. However, when the email subject contains an em/en dash character (i'm guessing anything not UTF8) the folder is then saved with the special replacement character in its name as shown.Once the workspace runs, it tries to use a JSONFeature to read the Topic message but the filepath is incorrect. FME log shows something like the following;XML Parser error: 'unable to open primary document entity '<FILEPATH>\\DBYD\\Incoming\\<FILENAME>_2??12_<FOLDERNAME>\\<FILENAME>_LLGDA94.GML'' Anyone any recommendations on how to deal with this please? Many thanksK
I have two inputs, a polygon shape file and a point shape file. The polygon shape file contains two area polygons, A and B. Each has a single, name attribute - A and B respectively. The point file contains 30 points and they also have a single name attribute, with attribute values ranging from A to E. Some of these points fall inside the polygons and others do not.As a rule, polygon A must only contain two A points and one E point while polygon B must only contain two B points and one E point. I input both shapefiles into PointOnAreaOverlayer transformer which filters out all points falling outside of the polygons. Within this transformer, I generate an attribute accumulation list on the Area outputs, with the selected attribute set to 'name'. Using listElementCounter, I can see if the correct number of points fall in each polygon - in this case 3. Using ListConcatenator, I can create an attribute listing the names of the points that fall in to the polygon, eg- A, A, E.I can
I try to import IFC file. I have a problem with combine informations from the IfcPropertySet and PropertySetDefinition sections. IfcPropertySet includes only: globalId, ifc_unique_Id and ifc_property_set_name. When I extructed elements from PropertySetDefinition section I see: ifc_property_set_name, ifc_properties.data_type, ifc_properties.name, ifc_properties.property_type.I don't see values for the name. What could be the reason for this?There is no id attribute. How do I connect these attributes with the right objects?
Hi,I may be missing some information regarding the TAB format, but I find quite inexplicable this behavior on file sizes: After creating a couple of layers, and sent to different formats (SHP and TAB) I appreciated that some of the brand new layers have large differences on sizes when comparing with same layers from a past delivery.Here are the figures from the 20th and 21st version of same layer: So, the new layer has decreased in vertexes, that's not peculiar, the strange thing is that with around 1k less vertexes SHP files decreased around 70MBs (0.001%) while TAB files decreased 141.000 MBs (55%). Is there any explanation for this? Thanks for your help!Juanma,