Using readers and writers to extract and load data.
Recently active
Hello. I have several hundred .xyz files that I want to translate to las/laz files. Using a reader-writer (Point Cloud XYZ- LAS) does the job: Inputs are something like 100903_120345.xyz, 100903_120736.xyz but the output files have names like POINTCLOUDXYZ.las, POINTCLOUDXYZ_1.las and so on What I would like to happen is for the output files to inherit the base name of the input so that the outputs would be named 100903_120345.las, 100903_120736.las etc. I'm very new to FME so apoligies for this simple question. Thanks Justin.
Does anyone know the correct way to ensure a shapefile is always created with its accompanying .prj file during the ESRI Shape writer process? For the type of translations I'm doing, I'd ideally like to have FME output the same projection file as the input for shape-to-shape conversion, i.e. create .prj files dynamically based on the input files, not from a hard-coded script parameter. I searched for but couldn't find any documentation about how/if a .prj file is created when writing to Shape. From mapping file translations, sometimes this projection file is created alongside the core shapefile components and sometimes not. Next week I am going to test a hunch that setting the COORDINATE_SYSTEM directive (or equivalent workbench parameter) for the writer allows FME to output a .prj file, while having it not set results in no projection file.
Hi, I'm having trouble to read data from a dxf file. This file has been built with autocad map 2012. It has one table associated to one layer feature types. It does'nt seem to be simple xdata because I can't read it by just using an "attribute exposer". I also tried to add my source data as "Autodesk AutoCAD Map 3D Object Data" but I stil can't read it. What do I need to do? Thanks for your help. Charlotte
Hi, I have - 16 dwg that are our original workfiles without xdata - a DXF file which is the result of a FME treatment and which contains xdata I created ID for several layers and I need to retreive this IDs so when we will update our workfiles, and I will pass them into my treatment to make a new DXF file, my IDs for existing features won't change. I have to retreive the xdata "ACCESS1_ID" from the DXF to put it, as XDATA in my orginal files (DWG). I have a way to merge correctly the DXF with the original files thanks to a block attribute I have kept as a xdata in the DXF. But I don't manage to obtain a file which would be exactly the same as my workfiles (DWG) with adding xdata in it. Thank you for your help. Charlotte
How can I publish a feature class in an ESRI file geodatabase as a source parameter rather than just the file geodatabase to use as an AOI? I am using FME to create contours from DTED using an existing AOI as my CLIP. However the exisiting AOI will not always come from the same feature class or even database. So I need the user to be able to select both the source database and/or feature class within it.
I want to create an inner tiled GeoTiff with internal Overlays for use with GeoServer. I know FME can do the inner tiling, but can it do the internal overlays too and if so, how? Thanks
Hello If I run a workspace on FME Server through an FME-Engine, and - if this workspace writes some output, - and the output is specified without a path e.g. write DXF to "test" ... --> then the output is written to the FME-Server Repository directory, which is NOT where I prefer to get the result. Is there a way to specify the working dir for the engine at runtime, like with a parameter ? I found FME_WORKING_DIR in the engine configuration, but it seems to be static. Thanks for any advice Michael
Hi, I have problem with the joiner-transformer. When joining tables from an Oracle database all unicode characters are not handled correct. Ex æøåÆØÅ. But if I create another reader-import-type with the same table it handles the unicode characters correct. Is there a setting on the joiner-transformer that i have missed? Or is it a bug? (I'm using fme 2012SP4 right now but the problem was also present the previous version I used. I think it was v2010.) /Tim
Hi, I have runned into some strange behaviour with FME Desktop and ArcGIS. My ArcGIS licences are 1 ArcInfo, 15 ArcEditor and 15 ArcView hosted on a license server. Under Citrix I set the variable ESRI_SOFTWARE_CLASS=Viewer as a default environment variable. This works fine, and for example a "double-click" on a MXD icon will launch ArcView. Given this as the default behaviour I provide users with separate startup icons for ArcEditor and ArcInfo (ESRI_SOFTWARE_CLASS=Editor or Professional respectively). But, when I launch FME and start an ETL-workflow which requires an ArcGIS license, then FME try to launch ArcInfo. Seems like ESRI_SOFTWARE_CLASS=Viewer (i.e ArcView) is not honoured by FME. The same seems to be the case for local installs. FME honours license settings from the ArcGIS Administrator and not what i set by ESRI_SOFTWARE_CLASS. Anyone knows a way to force a specific ArcGIS licensetype to be used by FME? best Pål Herman Oslo, Norway
Thre should be a simple solution for what I am trying to do, but for some reason I can't think of it. I have two polyline feature classes. Feature Class 'A' is made up of segments of the Feature Class 'B'. However, not all segments of a line from 'B' exist in 'A'. Some segments are missing. What I need to do is compare the two to find out what is missing in 'A'. Basically just looking for a "subtract" feature for lines. I know how to do this for polygons, but not for lines. Any ideas would be much appreciated! I feel like it is really simple and I'm just overlooking the easy solution!
Hi! Has anyone ever had the need to specify which sqlnet.ora file FME uses? Unfortunately, I need to use 2 different ones to access various Oracle databases and FME does not like the one I use mainly. I have tried hacking about with both version to merge them but then I have FME not working or TOAD not working, or in some cases neither! Any suggestions would be great as I am fed up having to keep swapping over :(
Can I have 32bit and 64bit versions of FME Desktop on the same machine. I need to use some of the datatypes for some projects, but need >4GB memory space for tothers. Thanks H
Has anyone tried to clip an ECW using a shapefile? For some reason the clipper does not respond to the ecw format the same as it does for others. Having the ouput routed to the viewer shows a clipped image. However, when you open the output file again in either the view or in another program the file is back to its original shape. If i do the same process in arcCatalog, (extract by mask) it works, but it is very slow and requires a few other processes to extract the data afterwards to make it usable.
I have done features migration into FGDB to Oracle SDE Format through Mapping using FME . There is any tool , this will give me mapping between Writer & Reader In csv or any other format .
We are trying to view in FME for connecting the Oracle Spatial data. We are encountering issues when connecting. Can you suggest while looking at the log. The following is FME connection error FME Data Inspector Version 4.0 Loaded module 'OCI' from file 'OCI.dll' Environment variable ORACLE_HOME has value `D:\\Oracle11gDatabase\\product\\11.2.0\\dbhome_1' Connecting to ORACLE database `pgeprim' with user name of `GRBGAE' and password of `***' Error connecting to Oracle database: message was `ORA-01017: invalid username/password; logon denied'. (serverType=`ORACLE8i', serverName=`pgeprim', userName=`GRBGAE', password=`***', dbname=`') Failed to open database with username='GRBGAE', retrying using uppercase username Environment variable ORACLE_HOME has value `D:\\Oracle11gDatabase\\product\\11.2.0\\dbhome_1' Connecting to ORACLE database `pgeprim' with user name of `GRBGAE' and password of `***' Conn
I'm trying with the workbench to create a new file. I want to read a .xyz file. And want to write to a other file (shp, dwg or oracle spatial etc.) and use it in a GIS system. There are many points (to many) i want to display those points on a distance of 100meters and only inside our city borders. Result must be all points (raster 100m) with a text z-value in our city I h've: .xyz file and an oracle spatial of our cityborders It's clear , i'm a beginner can someone put me on the road to solve this question? greatings, jopie
Hi....I need to figure out how to write the source path name of a file to the attribute table of a SHP file. I wanto to do this to generate field hyperlinks in the SHP file.....I can expose the format attribute "fme_basename" to get the filename, but I need to write the entire path out.....can anyone point me in the right direction.....Thanks....Scott
Is it possible to write to .NTF format? I see that the OS NTF option is in the list of readers, but not writers? Is there a reason for this? I'm having the same issue with space delimited .XYZ files - I can ask FME to read these, but no writer either? Any tips much appreciated!! Lisa
The user funning my FME workspace enters a year at run time which is used for selecting records. I want to use the year they entered in the name of a user attribute in the writer feature class. Referencing the parameter in the user attributes using $(parameter) doesn't work. I can successfully rename an attribute to incorporate the parameter value with the AttributeRenamer transformer, but the writer feature class won't use that attribute. What do I need to do to make this work?
I am having to convert MicroStation V8 to MicroStation V7 design files. In doing so I am required to select a seed file for the V7 design file output. Is there a way to use the global origin and units of resolution from the source V8 file? Is there a way to strip off the element linkages that are not valid in a V7 design file?
I have developed many workbences having parameters username=ADPUGSD Servicename : Stage . But I want to move my data into another server having another servicename : 'stage_new' . Then I will modify scripts with changes in parameters on writer side or I will add another writer and then mapped to source. Pls clarify & do needful asap
I have several MicroStation V7 Files of contours and I would like to convert them to ESRI shape files. In the DGN files are lines, linestrings, polygons and text. I want to convert only the lines, linestrings and polygons that are on certain levels. Has anyone got a good solution? Dennis
Hi, I have a reader and writer to load and re-project a shapefile into MS SQL Spatial 2008 R2. All good. Now I want to run an existing stored procedure once after the file loads correctly. The stored proc has no parameters. Help greatly appreciated. FME Desktop 2012 SP3
Hi, I have been provided an update of aerial photography in ECW format, I know that some of these files contain areas of black, i.e. there is no new photograph for this area. I was wondering if there is a way FME can look at each file and tell me is there it contains and area of No Data without me looking at each file individually? Thanks Adrain
How to log into the log file, not only on the Workbench log window, the workspace parameters used to start it?