Skip to main content

Data

Using readers and writers to extract and load data.

  • 6,932 Posts
  • 25,504 Replies
6932 Posts
farfar
Contributor
farfarContributor
asked in Data
Csv file writer empty!

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

451
T
B
barani
asked in Data
Water body into LnadXML

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

40
B
P
phildel
asked in Data
Expanding ranges and adding records to a DBF file

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

60
gio
Contributor
B
burton449
asked in Data
Visualize feature and decide to output it or not (python caller)

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?

60
B
Y
yamabushi
asked in Data
Is there a python library to make calls to a postgres db in a startup script?

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.

341
david_r
Evangelist
J
jrozema
asked in Data
Replacing old Shapefile Writer with a 2013 Shapefile Writer

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

82
J
D
dominic_doiron
asked in Data
Creating metadata in zipped file geodatabase

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

30
D
G
gnrevolution
asked in Data
Write Oraacle Spatial Solid to DGN

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...

20
G
J
jmoggie
asked in Data
Does SQLite spatial writer support UTF-8 characters?

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

160
J
jhawks
Contributor
jhawksContributor
asked in Data
Desktop destination Directory is different from the servers?

(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.

60
L
S
sbaktzg
asked in Data
Is it usefull to fill the workspace properties (Name, Category, Description)?

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?

50
david_r
Evangelist
R
rvgeneug
asked in Data
Change srsName in GML

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

450
R
M
miladahmad
asked in Data
How can I make FME writing to postgis (line) and not geometry type

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

580
M
G
gil
asked in Data
sde geodatabase holds multipolygon and polygon

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?

71
G
K
khalid_omer
asked in Data
Any cad to shape

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,

60
gio
Contributor
K
kflaw
asked in Data
pass a list of microstation files to a reader

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?

110
K
francis_m
Contributor
francis_mContributor
asked in Data
GoogleGeocoder FME 2012 or 2013

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

50
david_r
Evangelist
M
matthewbrucker
asked in Data
CenterlineReplacer Error

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: Does anyone have any better ideas/suggestions on how t

822
M
farfar
Contributor
farfarContributor
asked in Data
shutdown python to move writer file

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

130
david_r
Evangelist
farfar
Contributor
farfarContributor
asked in Data
Shutdouwn Python Script : Move file from work directory to another directory

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

120
farfar
Contributor
M
mbrow149
asked in Data
How to set up incremental updates using FME Cloud?

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?

111
K
gschleusner
Contributor
gschleusnerContributor
asked in Data
Out of Memory 3D PDF -32bit

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

120
gio
Contributor
A
abridle
asked in Data
FEATURE_TYPES wildcard for File Geodatabase

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?

290
david_r
Evangelist
darkspatiallord
darkspatiallord
asked in Data
post to fmepedia

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

120
takashi
Contributor
M
mikehouston
asked in Data
For FME 2011 ESRI Shapefile Writer, what is the maximum column name length?

For FME 2011 ESRI Shapefile Writer, what is the maximum column name length?

70
david_r
Evangelist

Most helpful members this week

Badge winners

  • FME Flow Authoring Training
    kokilamhas earned the badge FME Flow Authoring Training
  • Student (Bronze)
    rmpayabyhas earned the badge Student (Bronze)
  • Welcome Back
    fbcgfirefoxhas earned the badge Welcome Back
  • FME Certified Professional
    reneecwlinhas earned the badge FME Certified Professional
  • Integrate Data with the FME Platform Training
    smirhas earned the badge Integrate Data with the FME Platform Training
Show all badges
30,846
Posts

Popular tags

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.