Using readers and writers to extract and load data.
Recently active
Hello, I've connected my FMEserver with one active directory. I can connect to my FMEserver and I can navigate between the differents menus except the security menu where i have an error : javax.servlet.ServletException: javax.servlet.ServletException: COM.safe.fmeserver.api.FMEServerException: Could not read FME Server response message. Connection may have been lost.Une connexion existante a dû être fermée par l’hôte distant COM.safe.web.servlet.PageServer2.doGet(PageServer2.java:107) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:722) COM.safe.fmeserver.webui.sitemap.SiteMapFilter.doFilter(SiteMapFilter.java:40) COM.safe.web.servlet.CharsetEncodingFilter.doFilter(CharsetEncodingFilter.java:538) COM.safe.webservices.security.FMEServerAuthFilter.doFilter(FMEServerAuthFilter.java:164) Do you have an idea ? Thanks
I have an Oracle table with two geometry fields, POLYGON_GEOMETRY and CENTROID_GEOMETRY. I want to copy the table to a new Oracle Spatial database but I have to specify one or the other geometry column names in the reader. How can I copy both geometry fields to the new table? Thanks
Is there a simple way to add cross hatching to an output TIF file? Looking to see where it can be styled in advance of the Writer Output... something similar to a MapInfo Styler, etc, would be good but can't seem to find an equivalent. Thanks!
How would I execute a workbench from a Silverlight Viewer on the ArcGIS Server side? I want to have a button that pops up a form with a few user parameters. Then those parameters are passed to FME desktop or Server. (Either one). Then the server executes the process with the parameters. If someone could explain how to do that it would be awesome! Thank you so much!
All, I've got a sql view that joins SQL 2 tables together, one of which contains geometry for address points. I want to take that view and write it to an SDE feature class using FME. The problem is, when I choose SQL Server Spatial as the reader format, the shape (geometry) column isn't recognized. When I chose SQL Server Non-Spatial, the shape column is recognized, but the output SDE feature class doesn't have a recognized spatial reference, and the points don't display at all on the map (ArcMap). Is there any advice for trying to accomplish this? Using SQL for geometry joins, spatial functions, etc. is what we're planning on doing for generating data for SDE feature classes... Many thanks! -m
I have a set of CSV files and for each of them I would just like to read in the first line of the file. Is there an easy way to do that? I know I could read them in and use a counter and a tester to throw away all but the first line - but that would still mean that the whole of the file was read first - these are large files so I would prefer not to do that. cheers IanM
Hi all. I'm trying to run example from FME Server Playground (http://fmeserver.com/userweb/sharper/playground/index.html) called "Stream KML to ArcGis map" on my own FME Server(trial). I've download REST-kmlstreaming.fmw and Transit.sdf. I also publis REST-kmlstreaming.fmw to my server. When i'm trying to run example with my URL (http://<my server>:<port>/fmedatastreaming/test/REST-kmlstreaming.fmw) i recieve this error: dojo.io.script.jsonp_dojoIoScript2._jsonpCallback({"error":{"code":400,"message":"File not found. Wrong url or out of memory.","details":[]}}); But if i run Data Streaming Service from server i recieve correct kml file. FME Server 2013 SP3 Any suggestions what i'm doing wrong?
Hi guys! I used Labeller to put a text in a street and I got success (1 and 2) , but my customer required the text centralized (3 and 4). The Labeller starts the text in Mid Point, so, how do I centralize the text? Purple Line: Bounds Green Point: Mid
Hello, when exporting data to a PDF writer how can i set the scale? For example, when doing a simple translation from geotiff to PDF, but with the scale 1:50.000. Thanks
This should be simple. I have 30 shapefiles of the same points (300) with one column which is the elevation taken from a DEM (ie 30 different DEMs queried with the same point theme). For analysis, I would like all 30 columns to be in one file (e.g. csv, dbf). tried my luck with featuremerger but with no success. Thanks, Uwe
Hi Folks, It is very simple question but still I need some suggestions; I created a workbench that downloads WFS, reproject it and save it in File Geodatabase in the local Geodatabase folder. We would like to use same workbench multiple time (lets say may be once a month), but the problem I am having is, it works perfect for the first time but when I try to use same workbench for same WFS file (a month later date data), I change the parameter (destination folder for another copy) the massage I get is "Translation was SUCCESSFUL with 1 warning(s) (0 feature(s) output)" Can anybody point me out what am I doing wrong? Since I am downloading same data from same WFS link, I don't do anything on Reader parameter :)
I would like to read and reproject Tiff-File. It is not a Geo-Tiff, the Geo-Informations are in a tfw-File. FME seems to ignore the tfw-File. How do I tell FME to read the coordinates etc from the tfw-file? Thanks very much.
Hello, I am trying to connect to a WFS url (which works fine in various GIS software). Looking at the log, I see that the FME WFS reader uses GML 3.1.1. Can I change that so it uses 2.1.2?
Hi All, I hope I can explain my issue properly. 1) We upgraded our PCs to Windows 7 (64bit) and upgraded FME 2013 SP4 64bit and using ArcGIS 10.05, (natively 32bit) (Desktop, Engine etc) 2) We have large number of workbenches with writers using FILE_GEODATABASE (ArcObjects). 3) When I run my existing workbenches I get the following error messages; “Unable to perform any licensing related tasks. This is a 64-bit version of FME which requires a 64-bit version of ArcGIS Server A fatal error has occurred. Check the logfile above for details” 4) I changed my writers to use the file geodatabase (API) and all seem to run fine. Questions; a) Are there any issues with switiching my writers to use the file geodatabase (API)? b) Any ideas on how to batch change my writers from GEODATABASE_FILE (ArcObjects) to use the FILEGDB (API)? Thx in advance, Ken
All i have a 70gb national dataset. I want to extract a clip of this data based on a predefined polygon. This is fine, but it takes 7 hours to read the dataset in before carrying out the extraction, and as i only need a small area of this data, is there a way to only read in the area of data i need to extract? Thanks in advance.
Hello! I need convert many xyz files to raster. I use ImageRasterizer, but i can´t to get z value. Allways the transformer get fme_color and return an error: "No valid input feature.". Other information message says:"16 input features where discarded because they were not compatible with any band in the raster. Bands with a numeric interpretation requiere vector input features that have Z coordinates." I don´t know how configure this transformer for it do this numeric interpretation or which another transformer i can use for this job. Thank you very much to all the community.
I have floating license servers for both ArcGIS and FME. To keep administration simple, I want to run both of these services on one server. The problem is that they both try to use port 27000 and only one can run at a time. I've tried changing my safe.lic file to port 27009 and it does open that port but the FLEXnet Licensing Service for FME still opens port 27000. Has anyone gotten this to work?
I have built a simple workspace with source and destination SHAPE-dataset. Then I used the fmedataupload-service to upload a zip file with SHAPE-Sourcedata. Now I want to use fmedatadownload-service to run the workspace and download result dataset. But now I get following StatusMessage: Shape Reader: No Shape Files found to process in directory `test_upload.zip'. Check directory and ids statement in mapping file My questions are: Are this steps to run the worckspace correct? How I must specify source dataset so that fme server can find them?
I am trying to learn how to manipulate xml files with fme. I thought it would help me to set a small project, but I´m already lost. Project outline: Retrieve GetCabilities.xml from a URL. Manipulate the xml file to extract layer names, contact person, Boundingboxes, and KeyWords and write these into a Shapefile. I´m basically lost at the first hurdle because I can´t really understand which methods/transformers I should be using. 1. Create xml Writer and tell fme to create fme-feature types for Layer, Contact, BBOX,KEyword. 2. This splits the elements up into 4 fme-feature types. Next I thought I should somehow extract the coordinates and make a point feature which can be grouped according to layer-name and converted to a polygon. Obviously this is not easy. Could someone offer me a step for step way to do this? or is it too difficult for a beginner? Yours, Rob
Hello In order to get a GML formatted string, which I need for later XML/GML writing, I use the GeometryExtractor transformer with variant GML v3.2.1. So far so good. My problem is that it in many cases it creates Geometry of type <gml:LineString ...> and for reasons I cannot influence (German NAS Standard ;-() in many cases I need to get geometry of type <gml:CompositeCurve ...> otherwise it will NOT validate .... In GeometryExtractor I don't see an option which allows me to control this. Any ideas out there how to solve this problem ? Thanks Michael
There must be an easy way to read a JSON file like the one I have below, and create a stream of feature objects, each with the attributes (idx, type, path, date) but I am missing how to do this (FME2014). If I use the JSON reader, I get a flattened list with lots of attributeX values. (yes, that is what the doc says it does). I see some examples of people using the FileTextReader and then JSONFlatten it out and exposing attributes. Is that the way to go? I think this should be easy, and yes, the path is a windows UNC, so I want to be able to use the in the RasterReader transform, I hope it understands UNCs. { "Zoom" : 9, "CenterLat" : 50.055084228515625, "CenterLon" : 19.938812255859375, "FrameList" : [ { "idx" : "22504704", "type" : "CIB10", "path" : "\\\\\\\\TEST-EGPL\\\\F\\\\SIS\\\\NGA\\\\CIB\\\\CB10S0009601\\\\RPF\\\\N51E020\\\\000MJ046.I13",
I am trying to convert a Bentley dgn file to ESRI shp. Lines and text are no problem. But there are a lot of "layers" in the dgn file as cells (e.g. Cell : Inferred Feature: MANHOLE : MANHOLE \\ Line) It seems that no matter what I do, i can only get the graphic out as lines. I tried to use the CoordinateExtractor and the 2DPOINTREPLACER in various setups. Without luck. Is there someone out there that knows how to get the point data out? It doesn’t matter much to me if I convert the cells in Bentley or through the FME
Hello community! I'm trying to write all contents of one oracle db-user (Map 3D 2014) to another one with the same schema. when "inserting", translation fails because of : 2013-11-22 09:55:09| 3.2| 0.0|ERROR |Execution of statement `INSERT INTO SELBSTRECHT_L ( "LENGTH", "FID_PARENT", "LINIENART", "IMPORT_ID", "GEOM" ) VALUES ( :"LENGTH", :"FID_PARENT", :"LINIENART", :"IMPORT_ID", :"GEOM")' did not succeed; error was `ORA-29532: Java-Aufruf durch nicht abgefangene Java-Exception beendet: java.lang.ClassCastException ORA-06512: in "MAPSYS.TBCOMPOUND", Zeile 3 ORA-06512: in "AV_TEST.SELBSTRECHT_L_AIS", Zeile 18 ORA-04088: Fehler bei der Ausführung von Trigger 'AV_TEST.SELBSTRECHT_L_AIS''. (serverType=`ORACLE8I', serverName=`mapsrv25', userName=`AV_TEST', password=`***', dbname=`') Before i had problems with duplicate FI
I would like to get some stats from Shapefiles to an existing Excel file. For example, update the km of aqueduct in a specific cell and the number of manhole in another. I'm able to get the stats in the Excel file using Name parameter (Sheet1) and in the writer parameters. I use Update_Cell_Contents with xlsx_row_id for getting the specific cell and I use Start Column. But the question is how can I write a value in a new Column in the same Sheet1? I can get all the information I want in different row but only in the same column. Thank!
Hi everyone, I'm fairly novice at using enterprise style databases and could do with a few tips. I have an SDE database called Roads (with geometry), which has the following fields: Road Name: Road Ref: I have a SQL database called Survey (no geometry) that has: Road Ref: Type: Condition: Year: I have FeatureMerged the two datasets on the Road Ref field so the Survey data has been added to the Roads database. I now want to write this out the same Roads SDE database. This where I'm tripping up! I'm assuming FME can create a new featue class/type with the relevant felds (i.e. all of the ones from Road and Survey_, but can't see where to do this in the settings, and I'm getting errors. I've tried a few different combinations settings, but could do with some pointers! Also, is it possible to create the feature class in a feature dataset in the SDE? Thanks everyone. Amit