Using readers and writers to extract and load data.
Recently active
Hi, I'm trying to overwrite a feature in a file geodatabase but i always get the same error Geodatabase Error (-2147024894): The system cannot find the file specified. Could not open File Geodatabase dataset `P:\\vmmGeoDB\\IND.gdb' for writing. Am i missing something? Whe i try to do the same thing with af shp it works fine. The intention is to write a shp to a fgdb. Can somebody help me? Thx!
Why ? Is it possible to encrypt the token ?
Hi, I have a few workspaces that are triggered in one main workspace to work in series. In my FME desktop the process runs perfect. Now the plan is to move the complete workflow to FME Server. All workspaces run perfect when started seperately. Now the issue is getting the integrated workspace working. I changed the workspacerunners to FMEServerJobSubmitters. But when running the main workspace the first workspace from the FMEServerJobSubmitter is queued. Only when killing the main, the second is started. Any suggestion on this one?
Hi All, My writer (csv file) is created only if i have results to input; But if there is no result, the csv file is not created. Is there possibilities to create it even if is empty? Thanks an advance. FarFar
Dear FME Users, I want to write water body inbto LandXML together with DTM TIN surface. I have the water defined as closed polygons. How do I do it? Should I triangulate the water polygons and save as another surface/s? What about watershed feature (not supported by LandXML writer I believe)? or should I write the water body as polygon/s. Any advice would be appreciated. Thank you. barani
Hi I'am trying to create an expanded set of numbers and therefore new records, based on a range of numbers. EG attribute START has a value of 1 and attribute END has value of 5. The result I am looking for 5 separate records where START is 1, 2, 3, 4, 5 & END is 0
For a particular process we hace come to conclusion that we have to do an eye check on the feature to decide if we want to pass it to the writer or not. Is it possible with a python caller (or other transformer) to show the features individually in a viewer with a button to route the feature to the writer and another that skip it?
I found some documentation for import psycopg2 but when I try to include this in a startup python script on FME workbench 2014 sp2 it says that there is no module named psycopg2. I am trying to read/write to a postgres db, more specifically i want to set a value based on a previous feature. I believe that you cannot iterate features in a python caller.
I am trying to update some old workbenches we have. Looking at our shapefile writers, we would like to use the 'spatial index' functionality that is available in FME 2013. I am looking for an efficient way of adding a new shapefile writer and then coping over the attributes and other properties from the old shapefile writer. Is there a non-manual way of doing this? Thank you for your time, Julia
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