- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,822 Posts
25,137 Replies

When you subscribe we will email you when there is a new topic in this category

6822 Posts

jhawksContributor

Generic Writer questions

I don't know much about the generic writer but I'm hoping to use it to write to: shapefile gdb dxf dwg dgn V8 I eventually want to expose these options in a drop down menu on a public fme server, I'm trying to duplicate the functionality I have in this Spatial Direct page which were finally getting rid of migrating to fme server 2013. http://ocs-spatial.ncd.noaa.gov/SpatialDirect/translationServlet?SSFunction=prepareFetch

Fetching a zipped CSV file from an ftp site

How can I read a zipped CSV file from a FTP site, extract it and save it. Nothing I have tried seems to work. Has anyone done it successfully? Would need to do it on the both FME server and desktop. I would be thankful for any input.

140

11 years ago

sdepriestContributor

asked in Data

Oracle Reader Grayed Out in Reader Gallery

i'm stumped... I have FME Workbench installed on 2 different machines. On one machine the Oracle readers are enabled and available to be chosen and on machine 2 they are grayed out and disabled. Yes there is a dot in the Licensed column of the Reader Gallery on both machines, so I believe I am licensed for it. I have the Oracle client installed on both machines. Machine 1 is Windows 7 64-bit. Machine 2 is Windows Server 2008 R-2 64-bit. How do I "enable" the Oracle readers on machine 2? on Machine 1 the Oracle client was installed first, then FME 2013 SP1. On Machine 2, the Oracle client was installed after FME 2013 SP1 was already installed. Does that matter? Sarah

460

11 years ago

nrichParticipant

asked in Data

Concatonated publish parameters and FME server

(working with server and workbench 2011 32-bit) Hi, I'm trying to use a published parameter that is a combo of two other private published parameters in fme server. e.g. full_path=$(drive)$(path) where drive="D:/" path="afolder" i'd expect D:/afolder to be returned from $(full_path) as it is in workbench. however i get the unresolved string '$(drive)$(path)' instead once i've published the workbench to server. The full_path parameter is being used as an esri personal gdb dest_dataset parameter. Can anyone explain why this may be? Are joined parameters like this supported in FME Server 2011? I thought they were. Nick

150

11 years ago

jhawksContributor

asked in Data

Generic Writer questions

When adding the Generic Writer into the Workspace I dont seem to be able to select multiple formats to write to. I can only pick one. FME Desktop 2013 Build 13263 I have public web forms now but whichever format the user picks from the drop down menu it writes to shape. Because I only have Shape writers in the workspace. So I need to replace the Shape writer with Generic Writer and have it be able to write to shape, file gdb, dxf, dgn. https://fmeserver.ncd.noaa.gov/encdirect_extract_approach.html

Restore Repository from FFS lost Service Connections

I recently backed up my running 2012-sp1 machines to a FFS and did a update to 2012-sp4. When I run a workspace to restore my FFS to Repository I can see all my workspaces are back in the appropriate repositories. But None of them are linked anymore to the Job Submitter service, so its like they don't exist anymore. Is there a option where I can go and re-assign them to the proper service again? Otherwise I will need to republish all 40+ workspaces and that is just a time killer. Thanks; David (DEWright_CA)

130

11 years ago

asked in Data

Reverse engineering in CAD from point clouds

We use a lot of point clouds, a few here and there for GIS/Civil application. Our more common usage are using land laser scan in big existing plants (brown field,) place them as reference in our CAD software to do the CAD design of existing structures, equipment, etc. We then redraw what is exiting on top of the point clouds. We can have hundreds of designers and engineers spending time re-drawing the objects on top of reference point clouds. If we could recreate surfaces of structures and equipment, to recreate the shape of walls, beams, piping, etc. That could save use an enormous amount of time (and money) We do have many Point clouds management software and add-ons for CAD, but always look for alternate solutions; does anyone found ways of recreating thos type of shapes efficiently from Point cloud using FME?

FGDB Raster to 3D-PDF

I usually only work with vector data but now have a task to create 3DPDF documents for distributing to a project team. My issue is this: how to generate a colorized raster representaion in 3DPDF using the raster contained within an Esri FGDB. I am completely new to this process and can get it to produce a TIN from the raster, but i am unsure of how to colorize the raster and have it represented in a 3D model of the source raster. Any help would be great, thanks!

11 years ago

sdepriestContributor

asked in Data

MS SQL Server Writer: Failed to parse `Date' from attribute value

I'm getting this error below: MS SQL Server Writer: Failed to parse `Date' from attribute value `05/07/2013' for column `EAST_current' My source is an Excel file and I'm writing to a regular non-spatial SQL Server 2008 table. All the columns in the SQL Server table have the datetime data type. What could be the problem? Do you see that single tick mark in front of the 05 in the error? could that be a literal value? I tried testing for that tick mark character in a Testor using the Match RegEX test using [`] and \\A[`] as the right value, but the row came out of the Failed port. So I don't think the tick mark is really there. The source data looks like this when I view it in the Feature Inspector while the translation is running: 5/7/2013 so I use the DateFormatter to conver the month and date to 2 digits with this date format: %m/%d/%Y this seems like a simple problem, i just can't see it. Sarah

Variable database feature reader

Forgive me if this question has been asked before. I don't know how to phrase it in such a way that I can find an easy answer though. Bascially, I'm developing an fme script to QA incoming topographic data against our business rules and then compare it against our database to determine the change. What I want to do, is have the database reader only pull feature classes from our database that match the incoming data: eg: only pull the roadsegment feature class from the database if a roadsegment feature class was provided. If I haven't given enough information or this questions was answered elsewhere please point me in the right direction. Appreciate any help. Thanks.

11 years ago

anderst

asked in Data

Set priority for scheduled jobs in FME Server

Hi Is there a way to set priority for scheduled jobs in FME Server 2012? Thanks, Anders

FME Server - Microstation v7 and V8 output

Hi all, We work regularly with both Micsotation versin 7 and V8 formats. We are trying to build a workbench that will allow users to select output format using the Generic Writer. Since the seed file dictates the microstation version output, we need a means of allowing users to select the output seed file (depending on if they request v7 or V8 output). Is there a means of publishing the Seedfile parameter in a workbench file to allow the end user to select the file? Is there another method of telling FME what version of Microstation to output? Thanks, Mike

Converting MS Excel to Google Maps KML

Hi, I'm new to FME. I have an Excel spreadsheet with X/Y co-ordinates that I want to convert to KML for use in Google Maps. I've managed to do the conversion OK and create the KML but Google Maps won't read it. Google Earth will read the KML OK but I need to display it in Google Maps. Any help would be much appreciated. SeanOB

11 years ago

steve

asked in Data

ArcSDE Geodatabase Locks

Hello, I'm new to FME and have a workbench that does a dgn to ArcSDE geodatabase (SQL Server) feature class conversion of points. I have the "drop table" set to "yes" which I assume deletes all the features in the SDE geodatabase before writing to it. To that end, when I run the workbench, I get the error below. I can see that the geodatabase has locks from ArcGIS Server (we have three instances of ArcGIS Servers running). I would have to manually stop each ArcGIS Server instance before running the workbench to get it to run correctly. Is there a better way to run the workbench and update the data? Unable to drop the table/feature class 'Bollard'. The error number from ArcObjects is: '-2147215875'. The error message from ArcObjects is: {Table is already locked [aoc_gis.GISADMIN.Bollard]} A fatal error has occurred. Check the logfile above for details. Thank you Steve

1370

11 years ago

gpt_geoinfoContributor

asked in Data

[SDF3 Writer] Number format not correct - 1e+031

Hi community, I have a script which translates database content into an SDF3-file. Writer and Reader are dynamically. The Reader gets its schema from the writer. Now I got the effect that numbers with the value "100" are converted into "1e+031" in the SDF3-file. Within the scipt everything works fine. "100" stays "100". All other numbers, too. They are also correct in the SDF3-file. It just concernes the 100's. I already tried to set the attribute again to the value "100" and add an attribute to the Writer with a type 'decimal', without success. Can anybody help me?

11 years ago

darrenContributor

asked in Data

Setting text anchor position in MapInfo Professional

I have built an FME workbench that translates Ordnance Survey's MasterMap Topographic layer into MapInfo Professional TAB format. Most features translate fine (once you get passed the line style issue with the MapInfoStyler transformer!) but I am having particular issues with the CartographicText feature type. The GML format that Ordnance Survey provide their product in contains an attribute to set the anchorPosition of the text but I cannot get this to be recognised by MapInfo Professional at all. I originally thought that using AttributeCreator to set the mapinfo_text_justification might do it but this just sets the justification within a block of text, not the original anchor position. I'm pretty new to FME so there might well be something I'm missing but after having tried a number of different transformers I'm getting the feeling that it might be a limitation of MapInfo Professional and not FME. Does anybody have any bright ideas?

270

11 years ago

pruiterContributor

asked in Data

using xml configuration file

Hi all, I'm currently working on a project where the customer wants to use an existing configuration xml file, where they can enable / disable custom validations and store some validation properties (such as allowed feature class names). I'm struggling to find a proper way to do this, can anyone point me in the right direction?

LiDAR to RasterDEMGenerator

Hi all, Today is my second day with FME, so I apologize if my quesrtion is very basic. I am trying to convert LiDAR (las) to DEM data (esri grid) but am having a problem with the interpolation. Any files that do not have adjacent las files to them - that is they are on the perimeter - interpolate all areas within their tile even if there is no data. Is there a parameter that limits the distance for interpolation or somehting similar? Thanks.

How to Calculate Angle in Degrees From North

I am currently using the NeighborFinder to calculate the distance and direction between two points. However, angle (direction) is calculated from the x-axis, counter clockwise. Is there an easy way for me to calculate the angle from the y-axis (ie north) clockwise? Otherwise, I may be stuck doing some fuzzy math to rotate and flip the numbers! Thanks in advance for any help. Mattt

Covert shp file to obj fanout

hi all I am trying to convert a shp to obj using the object id as fanout. The file name of each obj file has to be the same as the object id, right now the directory has the name...anyone know how to set this up? thanks

Hi again, while I am trying with the help of support solve one problem, comes new one :) Ok, maybe it is not a problem, but I need explanation. If I have, for instance, 10 geotiff files, each has 1 Mb of size, how could be possible that one jpeg2000 mosaick file of those 10 files is ten times bigger i.e. 100Mb even If I used compression 20% . What kind of new informations appeared ? Thank you.

185

11 years ago

adrianContributor

asked in Data

Calculating Map Scale and Scale Bar for PDF file

Hi all, I am creating some PDF files for someone and they need to have the map scale and a scale bar on them. Each map will be at a different scale so I could do with a way of calculating it and then create a scale bar based on this. Any help would be much appreciated.

Read a Map 3D .layer file

Hi, I need to read a Map 3D .layer file (RDF) using FMR readers. But I can't see any such reader to read a Map 3D .layer file. Please let me know how to read a Map 3D .layer file in fme. Regards, Ananda

11 years ago

chrismugdan

asked in Data

cannot produce mixed case shapefiles

I am trying to create a set of shapefiles with mixed case attributes but, even with what I think are the appropriate settings, I am getting upper case attribute names. I am using a writer with dynamic schema to write the set of shapefiles with the "Use Upper Case Attribute Names" unchecked. I read in the help for writers that this setting will not be used unless you create a new workspace and add the writer to that. I did this but to no avail, I still get upper case attribute names. The input features all have miced case attribute names. What should I do? I am using FME 2012 SP4 Win32. BTW, how do I add the workspace and log to this question? Perhaps having those would show the problem? Chris Mugdan

Create and Ellipse Based on a Volume (Acres)

Hi FME Community, I have a problem where I am trying to create an ellipse based on a published parameters "acre" input. It's a fairly straightforward process to do this with a circle/buffer as the radius of a circle can be calculated based on a volume, in this case number of acres. However, I want to create an ellipse where the radius of one axis is 2x the radius of the other but still sized volume-wise by the input of the published parameter. Is there a way to create "circlular buffers" and, for lack of a better term, turn them into ellipses by stretching them as they alreay have the correct size by acreage?

220

11 years ago

Page 266 / 273

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

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