Using readers and writers to extract and load data.
Recently active
Morning, I have been happily using FME to translate out raw MasterMap GML files into DWG files for our architects. The fan-out by Attribute has been an invaluable tool. However, they have now asked if I can get the lines coloured in for them... I have tried everything i can think of but cannot seem to do it. Ill try to explain further... one of the readers is TopograhpicLine. When fanned out by Descriptivegroup our Architects can switch on and off buildings, a road, general features etc. It is these fanned out features they want different colours so for example buildings red, woodland green. Any assistance in this would be much appreciated! Ben
Hi guys! How do I use the Smallword 4 Reader and Writer with Smallworld 4.1? (I need a step-by-step tutorial) If I need to use Magik codes, post here, please. Thanks!!!
Hi! Im working on a PDF cartographic output application running on FME server. Recnetly I encountered the workspace is not flawless as it used to be. It seems around 1/3 of all executions will result in error similar to: PNG reader: Failed to open the dataset 'C:\\Users\\SAFME2~1\\AppData\\Local\\Temp\\ImageFetcher_21378914917511_5860'. Please ensure source data is valid and correct reader is selected This is a Imagefetcher. Used to get a WMS - PNG-image. Error is at 1.8 seconds, so it cant be a timeout. Pasting the WMS URL in browser works fine. Using the same imagefetchers and URL in other .fmw-files on the server works fine. Downloading and running the workspace on desktop with same identical settings as on the crash works fine. Im out of ideas. Should I clean the server up somehow? Any input most welcome. Thank you!
Hello, Apologies for the long winded subject. Is it possible using a transformer to set <Snippet maxLines="2"></Snippet> just under the <Document> tag? If I use AttributeSetter and set kml_snippet to maxLines="0" but in the resultant kml file I end up with <snippet>maxLines="0"</snippet> instead of what I want as <snippet maxlines = "0"> </snippet> I am using FME 2012 SP 2 Cheers,
in a log file i get this message: all channels have been allocated ....Last line repated 3 times....
I have an Esri shape file. I transferred it to a citygml file as a Land use object. I have one more field in my shape file as a coefficient for type of land use and I wanna have it as Generic Attribute in Land use object. How can I do that? I can also have it as GenericCityObject. I appreciate your advice in advance.
Was wondering if anybody has split text from a .csv column into to seperate columns? I have a column named "Coordinates" with x,y data with the word POINTZ before the coordinate. Example: POINT Z (-113.807295690 52.269077310 842.30) I would like to put just the values in seperate columns (X & Y) containing no text..... Once I have the x,y in seperate columns i'm assuming its easy to convert the .csv to a .shp Any thoughts
Hi, In a workspace, I will regularly update a source that is available as a zipped shape file from a secured ftp site with a username and password. So I’m using the shape reader, and using a path like(ftp://<3.ftp/*_*.zip) in the FME shape file reader location, but FME returned the following error when running the workspace ERROR |Shape Reader: No Shape Files found to process in directory,… Obviously, I need to pass my logging credentials to download and read the zip file, so how can I pass the username and password in this case? Sami
Does FME Desktop 2013 sp1 (20130325 - Build 13450 - Win64) support ArcGIS 10.2? Thanks Jim Q
Hi, i'm new in the world of FME and trying to learn the working of it. Mostly by using the help function, this website en offcourse Google. But some problems seems to be a bit difficult ;) What i try to do is comparing 600+ ecw files to 1 ecw file that i can use, by importing, in another program. I have been trying different ways to get the job done but still didnt find a way to make this happen. I hope to find some help on this site. Thx J-P
Has anybody had the issue where you add a shapefile (with a set projection, including a .prj file) as the reader and when writing this shapefile to an SQL database it does not bring the Coordinate system over with it? Example: Load a shapefile into a GeoMedia SQL database. For the Parameter Coord. System: you leave as the default "Read from source" This runs successful but when you go into GeoMedia --> Warehouse -->Feature Class Definition and review the Coordinate System, it is empty? Indicating that FME did not actually Read the Source Coordinate System and in return your feature class is left with no associated Projection? Does FME require a specific Projection file for it to "Read from Source" ? because regular .prj files it does not seem to reconginze.
Hi at all after successufll (tank to Itay and Takashi) managed the spatial conversion of xml to shape/kml/postgis I need other suggestions on how manage In essence, I would bring in the db (both ESRI geodatabse or postgis) a large part of the fields in the XML linking to their spatial compontent . How can I manage it in a few steps (I have a thousand of xml with same schema)? TIA best regards fz
I'm traying to export a numbor of polygon shapes into an CytiGML model. The shapes contain the roofs, walls, and ground of the buildings I've noticed that because of the way the polygon vertices are placed arownd the contour,(clockwise or counterclockwise) the faces that are created in cityGML are visible as front faces for counter-clockwise orientetion of the vertices and back faces for clock orientation. I've tried to filter the shape using orientation extractor and attribute filter but i don't get any result. What is the conection between the orientation and the vertex placement, if is there any? Has anybody encountered this problem before? The simplest way is to change the direction of the vertices in arcmap but i don't know if it is posible?Open for suggestion. Please help!
Hi Guys, I'm using FME Desktop 2013 connected to Smallworld databases. I need to convert geometry fields from my "reader" to geometry fields to my "writer", I'm adding the feature type together with the "reader" creation but the geometry fields aren't appearing, If I create my "writer" and after I import the feature type for the same table as a "writer", the geometry fields appear normally. Do I need to use any transformer for this? I tried to use GeometryFilter but I can't to see the geometry fields. Anybody help me? thanks, Allex
Hi all, I'm trying to set up a validate and load workbenches which will be run through FME Server. I want to use the Generic Reader so that user can load data of any format onto our system. I know that file geodatabases will be one of the main formats being loaded but I can't get get the Generic Reader to recognize the database when testing. When I 'Prompt and Run', I forces me to point to a specific file as the input and predicts the format type from that file. This works in case of a shapefile but not for file geodatabase files. In the documentation is says it will recognize a File, Directory, URL, or Database name. Any thoughts on how I can fix this? Thanks rkay
I have managed to create new features and put them on a DYNAMIC SDE30 writer that inserts the features, deletes the features and updates features correctly by using fme_db_operation = UPDATE, INSERT, DELETE and on the WRITER Writer mode: UPDATE. However when I try to do the same with an ESRI GEODATABASE_SDE it logs that the features are written - however there is nothing in the database (also not in any other features or tables on the same server). Doesn`t the ESRI GEODATABASE_SDE writer handle the fme_db_operation parameter the same way as the SDE30 writer? Any other tricks to be aware of when working with writing to ArcSDE?
Hi I've a lot of xml files ISO191115 (like the one at the link below) with some spatial info as the EX_BoundingPolygon that I need to extract for build up some feature in kml or shape format. Do you have any idea or suggestions? TIA ciao fz link to example file: https://api.echo.nasa.gov/catalog-rest/echo_catalog/granules/G26813121-LPDAAC_ECS.iso19115_2?token=3F8812EE-8A4F-EAFF-FE95-E6A036ACC3C1
When writing to a file based dataset, i.e. each feature type is a layer within a dataset does it matter in which layer you set and expose a format attribute, e.g. map extents / viewport within a geosptial pdf, does it need to be repeated for each layer?
Hi, I would like to merge several kml into one, but in keeping my hierarchical structure, that means Event Type > Countries > Year > Month > Link Then I would like to handle it in GoogleEarth but it would be too heavy. Is there a way to resolve this issue? Thanks in advance for your help. Regards Arnaud
Hello All, How do I input multiple raster files (in multiple directories) using a file-geodatabase or a CSV table? I have JP2 files in multiple locations. I have the outline geo-databse file that shows the paths & the file name. Using this table, I would like to convert these images to geoTIFF format in bulk. Any exapmles would eb fine too. Thanks
Hi, I am looking for a way to replace some (205 values) attribute values from a polygon feature class containing 45000 values. The new attribut values (the 205) are stored in another (point) feature class and the location is the only conformity. With all the other attributes it is not possible to determine the responding point to the polygon. Kind Regards, Markus
Hi, I am trying to update a geometry of a feature stored in oracle spatial. I've set the writer mode to UPDATE also I've mentioned the key columns (combination of four colums is unque). The workbench executes without giving any error, the log shows that it has written fatures but the geometry column does not change. Please suggest if I am missing anything in this. Regards IMRAN
Essentially what i need to do is for the user to upload a file to FME Sever using a custom web form and then send the upload location of the file to the published paramter of the job containing the workspace I need execute. When i try to run the job it just never seems to ever seems to start executing the workflow. From what i can tell i am following the correct stepsbut it seems as if the parameter is never getting passed. Also i think part of the issue is, i dont actually need to read the contents of the file. I just need to know its name and location so that i can upload it to the web. I have this process working on the work bench in terms of uploading the file correctly using a published parameter...so it must be something going wrong between the web form, FME Server, and the job. Any help would greatly be appreciated. Here is what i used as my main reference: http://fmepedia.safe.com/articles/How_To/Direct-Upload-and-Run-with-FME-Server
Hi, I have an excel file (.xls) containing the following columns: objectid, adresses, x, y where x= x coordinate and y= y coordinate. I would to create a new table in Oracle with the following columns: objectid, adresses, geom where geom is a SDO_GEOMETRY type. The geometry objects are created from the values in the x and y columns from the excel file. How is it possible to do that with FME? Thank you, Fabienne
I am writing to a ArcSDE Geodatabase with many Features. I want to make sure that only the existing features gets written - for instance: MyRoadsPoint MyHousePoint MyParkArea So if I create a feature_type called MyParkPoint and try to write this - it will fail because the MyParkPoint does not exist in this database. Is there a setting on the writer I have not seen? One solution might be to add the existing allowed FeatureTypes - however the allowed FeatureTypes and the Output database will chang between every run.