Using readers and writers to extract and load data.
Recently active
I have a workbench set up where I create a Feature Class inside a file geodatabase. the next step is to create the metadata and load it into the same Feature Class. This all works fine. I'm doing the exact same thing with a zipped file geodatabase and it's giving me errors. Attempting to create table 'XXXXXXX' with 'geodb_type' set to 'geodb_metadata'. FME features of 'geodb_metadata' can only be written to existing tables. If intending to write metadata, please ensure the table already exists. If intending to create a new table, ensure the 'geodb_type' is set to a valid table type. A fatal error has occurred. Check the logfile above for details I've checked all my parameters and they are the same between my zipped and non-zipped file geodatabase. Any idea why? Thanks
Hi there, I have some solids (GTYPE 3008) in Oracle and simply want to write them out to a DGN v8 file, but I can't seem to get anything except decomposed line strings as an output, am I missing something here? Surely this is supported, if I write to a DWG instead no problems, but DGN just isn't producing the goods...
Hi, Does anyone know whether it is possible to write UTF-8 data to Sqlite spatial? You get the option to specify encoding when using the Spatialite writer but not the Sqlite spatial writer? Any ideas? Thanks
(easy ? and I shoud know this)...When I create the workbench on my desktop I write to c:\\somepath but when I publish I want it to write to d:\\someother path. How do I set the path in workbench? Both workbench and Server are 2014. The workbench extracts data from oracle and writes shapefiles.
In the FME Workspace it is possible to fill the properties to describe the workspace: Name, Usage, History, Legal, Category, Description.... Is it usefull to fill them out? I ask because the most example workspaces from the safe-software webpage do not use them! The most workspaces use an annotation in the workspace. Is it possible to bring the content from the properties into an annotation automatically? What is your best practice to use or not to use the workspace properties?
Hi all, When writing to a GML my srs is set to srsName="EPSG:31370" as my data is actually in this coordinate system. But I want to have an URL in stead of this "EPSG:31370". Any suggestions on how to do this? Regards, Rob
Hi I'm trying to use FME to get shapefile to Postgres (postgis) but there is no option in the writer to choose point, or line, etc. .. What I get in postgis geom type geometry and not geom type point or lines, etc... any help will be appreciated... thanks
Using generate workspace in FME Desktop. Using Oracle/SDE as reader source, and file geodatabase as writer target. I want to copy feature datasets and features from sde to file geodatabase. Because some feature classes have multipolygon and polygon features , a geometry filter is automatically put in and splits to 2 newly named feature classes. Even if template is used it does this. Is there anyway to turn this automatic geometry filter off, so the copy happens just like ArcCatalog, 1 for 1?
Dear All Converting CAD to shpae , it works only with the CAD that intially used to build the Workbench , when we upload another CAD with different schema , not output prodcued . Thanks,
Article 000002244 seems to provide the solution I am looking for (using python script to specify feature types), but I'm unclear about setting the path for each microstation file that I am loading. I can create a list of the files I want to load to the reader, but there are multiple paths. I am creating the list by iterating through a directory and subdirectories and searching for files with microstation file extension. I'm not sure where to include the path information for each file?
Hi, I want to use the FMX GoogleGeocoder but when I open it in workbench It say that my "AttributeCreator" doesn't have the right version (in FME 2013) and if I try it in FME 2012, It says my HTTP fetcher is not right too. I need to build back the attributcreator for the "GG_FullAddress". Any Idea how is the syntax? thanks
I am having a bit of a frustrating experience with the CenterlineReplacer that I am hoping someone can help with. Desired Outcome: Centerline the entire length of the polygon "tiles." The length is a user-parameter and will determin the length of the line. By having the centerline "clipped" inside the polygon I am losing the correct length. Background: I have a number of 'tiles' (ie polygons) that I want to essentially spit in half and keep the centerline. Sounds like a job for the CenterlineReplacer. However, whenever I run the transformer I get 3 undesirable results. First, it does not split the entire lengh. It essentially starts partway down the middle. Second, one of the centerlines always "snaps" to the corner of one polygon. Third, the line directions vary. I would like all line directions in the same orientation. Note, I have a process that fixes this but it's more of a hack. Here is a screenshot of the undesireable output
Hi All, I need to retrieve a path of writer to remove this writer file from its directory to another one. I couldn't retrive the writer path using Shutdown Python Script. Example : src_file = "c://temp/file1.csv" dst_file = feature.getAttribute("fme_basename") ?? shutil.move(src_file, dst_file) I can't retrive feature into my script ! Any idea? Thanks an advance. Farfar
Hi all, I need to move my Reader file (toto.shp.zip) from its location to another directory after traitment. I think the best way to do it is into Shutdown python script. But i can't find the code to do it. Could some one to help me? Thanks an advance. Farfar
Our organization is exploring the use of FME cloud to push data out to Google Maps Engine(GME). We currently have 2 FME Desktop 2014 licenses which we use to load data into GME. We run change detection to incrementally update features in GME from our on site SQL Server 2012 database. This is crucial as we have to pay for storage with GME and need to minimize update size to reduce costs. I would like to publish our workspaces to FME Cloud but am trying to figure out the workflow for such a thing before investing in it. Would our data need to be published as a shared resource in FME Cloud everytime we'd like the workspaces to run? Is it possible to direct those workspaces to our database without punching a hole in the firewall? Or is there a way to run change detection locally and then upload the new data to FME Cloud and have workspaces run only when things have been added, updated and/or deleted?
Hi, We are trying to create a 3D PDF file out of a OBJ file for a masterplan. Its a large file and we are running out of memory when making the write. This is becasue the 3D PDF writer is only available in the 32bit version. Are there any tricks to get FME to manage the memory better in this type of workflow? Thanks, Greg
On the GML reader if I leave the FEATURE_TYPES value blank I can read all feature types into a single merged feature type without having to name them in teh workbench. I'm trying to recreate this with an ESRI File Geodatabase reader. In this case I only get features back if I have explicitly named them in the FEATURE_TYPES parameter. How can I specify FEATURE_TYPES with a wildcard so that it will read all feature classes in my geodatabase?
Hi Can you use a Case Changer on an unexploded list. So all values within that list are put to the same case so it makes it easier for ListSearcher queries to work (or can I do something in the ListSearcher to make this happen) DL
For FME 2011 ESRI Shapefile Writer, what is the maximum column name length?
My tasks to do with FME looks like this: - Start the workspace and choose a shapefile.(The schema is not known before) - Write the feature type with all attributes to a Filegeodatabase. I can create a workspace with shapefile reader and dynamic fgd writer and a published parameter to get the input from the user. But my problem is the reader which needs some predefined features. If i select a shape file I get the following "unexpected Input" error: "some features were read that did not match a reader feature type...." Is there a way to define the feature at runtime out of the input? Something like a dynamic schema reader? Cheers
I've written some .net code that will run a workbench I've created in FME 2014 using: IFMEOSession fmeoSession = FMEObjects.CreateSession(); IFMEOWorkspaceRunner fmeoWorkspaceRunner = fmeoSession.CreateWorkspaceRunner(); fmeoWorkspaceRunner.RunWithParameters This works in a standalone .net application. I need to extend the program so that it also makes use of some ArcObjects code before calling FME. I'm using ArcGIS 10.2.1. The Arcobjects code also works in isolation. The problem comes when trying to integrate the two. It seems that after running the ArcObjects code a call to FMEObjects.CreateSession() will return an error message 'Session could not be created. Registry mapping to FME core DLL could not be found.' I've also tried running this on a machine with the ESRI Data Interoperability extension installed and in this case I get a success = false from IFMEOWorkspaceRunner.RunWithParameters with no log or error messages. I can see from deb
Hi, I have pointcloud xyz-files that I want to write to Esri ASCII Grid-format. I use a RasterDEMGenerator in the process with Interpolation method: Planar. It is 2 meters between the points so I use X/Y cell spacing 2 meters. But when I look at the resulting files it is a gap between them with no data (see image). How can I connect them togheter? If I process the two pointcloud-files at the same time then they will merge into one single perfectly shaped ascii-file. But the problem is that I have 234 pointcloud-files with each 1,5 million points, and I have tried to merge them into a single ascii-file. It took about 80 hours for FME to process them, but still FME didn't manage to give me a resulting file because of some strange error. Any suggestions please? Cheers Hans
I presume I can't write a .lyr file since no such writer exists (is this an ESRI restriction?). Is there any hack that would allow for setting colours based on attributes and then write this information to some other type of file that can later be used by a GIS to color a .shp automatically?
Hey all, Had a browse around on the internet for this but nothing clear popped up so asking the group. I have a SQL Server (non spatial) reader and I need to be able to specify the table name in the database to read at runtime. I've tried setting the Feature Types to Read parameter within the SS reader but all I get is that error message stating "some features were read that did not match reader feature type" - I cannot seem to parameterize the Feature Type Name. I know you can do this but I'm hitting my head against a brick wall on this. I've got potentially hundres of tables to download so I need this to work so I can let it run overnight in batch mode. I've got the writer part parameterized nicely but the read keeps defaulting to the table selection I made when I added the reader and throws that error (mentioned above) when I try to parameterize it Any ideas what I'm missing? I know it's simple but just can't work it out.
Hi. I have .csv file with name, lat and long attributes, (+ bunch of others). Problem is, that gml writer doesnt write any <gn:geometry><gml:Point> tags. What am I missing? Some transformer? Im new to this, so bear with me, please... Thank you.