Using readers and writers to extract and load data.
Recently active
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?
I try to convert a stormwater AutoCAD file into ArcGIS feature classes. How can I identify the flow direction. i.e. for a pipeline, which side is upstream or downstream?
I have a question about transforming a KMZ file to a shapefile. Each time I import the KMZ file, which has several separate layers, FME is not able to identify the individual layers. The “Select Feature Types” lists out the typical feature types “Animated Update”, “Document”, “Fly To”… but the only feature type that translates into the appropriate geometry is the “Placemark”. However, when I transform the “Placemark” all the attribute information is lost. What am I doing wrong? Is there something I am missing in working with KML/KMZ data?
FME is unable to write to an ESRI enterprise SDE database. In the log file, FME says “An ArcGIS license is already checked out. The product checked out is 'ArcView'.” How can I specify FME use and Arc Editor or Arc Info license? The computer has ESRI installed. There is a concurrent license that is pointed to Arc Info. At this point there are several available Arc Info licenses.
Dear all, I'd like to work on a automatically generated 3d model composed by lod1 and 2 building. What i'd like to do is to apply some generic texture to this model starting from a datset of tiled textures of roofs and walls. I did some experiments but the obtained results are not really good for two reasons: - the texture is applied individually to each triangle of the model, thus obtaining a bad graphical result. - I'm not able to transform the lod1 buildings into lod 2 and merge the the result in a single datset in which each building has it's own wallsufrace, groundsurface and roofsurface. To apply the textures I used an apparenceAdder transformer and tried to set the Geometry Filter to "Geometry Type" "is one of" "IFMEFace" but nothing changed. To extract the lod1 bouildings from datset and transform it in lod2 building I used the approach find on this forum ( or the older Google group ) but in the output the lod2 building a
Hi All, I am trying to tranfer the objects into the internal world's of either pad,switchgear or substation..Can any one please let me know, is there any possibility way to transfer the internal worlds from source file like microstation. Thanks, Seshu
Hello, I have annotations stored in a file geodatabase, and can convert the text into dgn labels. Is there a way of translating the geomerty of annotation callout boxes into lines/polygons? They do not come through automatically... Owen
Hi, An easy one, I hope, for the ESRI experts :) I am writing a date attribute to an Oracle SDE feature class but the month and day are reversed. The feature class is a new table created via FME. So 20121128 appears as 11/28/2012 and not 28/11/2012 e.g. US and not European format I tried the DateFormatter without success. Any thoughts would be appreciated. Thanks, Annette
Every night I update a bunch of MapInfo Tab-files, using FME Desctop. My Issue: When no features enter the writer to a specific feature type, no update is made to that file. The old content remains. No features to the writer, indicates that I need the resulting file to be empty, rather than containing yesterdays data. The MapInfo write has no "Truncate first" option, witch would help me out here...
I accidentally noticed that FME automatically reads the projection system for DWG files when a PRJ file (created using ArcGIS) with the same name as the DWG file is present in the same folder. Initially I thought that FME can now read projection system from DWG files. But when noticed that the projection system was incorrect and further investigating the issue, found FME reading the projection system from a PRJ file which is part of SHP files created using ArcGIS with the same file name as the DWG. This was notice is FME 2012 SP4 as well the latest BETA build of FME 2013. Has anyone noticed this problem? However this is not happening with DGN files for me! Regards SRG
Removing FFS extended dataset files from the directory '' left no remaining datasets likely due to naming conflicts. Try renaming the source dataset files to avoid names like <basename>_<number>.ffs to avoid conflicts. Note that the FFS reader is sensitive to all files in the source directory and not just the selected files Not sure how to solve this. I have split the 500 files into 5 subfolders with 100 files in each, and that seems to solve the problem. Is the problem the number of files selected per Reader? If the Reader could not open all the files it should abort - and not let me "think" that all files are selected. Not easy to discover when you merge many files into one large one.
I want to merge a shapefile and a dbf file joined by an attribute and write them to a postgis database. Is FeatureMerger the way to do this? How do I extract the merged feature information (i.e. all the merged attribute metadata) and provide it to the postgis writer so that the correct table structure is created for the merged feature type?
For compatability-reasons with Geomedia I need to write an additional field of the type "varbinary(max)" to all the tables in our SQL Server Spatial database. In FME I can set the varbinary datatype, but I can't set the "max" value. I've asked around and so far it seems the only workaround is to create the field with the datatype "image" and then alter the datatype directly in SQL Server afterwards. Any ideas on how to do a better workaround?
Can you have a Step by Step manual that explains How can I migrate data (Intergraph Geomedia Warehouses) using FME to Oracle database (Oracle Spatial Object) ? Remember that Intergraph use GOOM Package for storage on Oracle. Have FME an alternative ? I appreciate your valious time. Regards, Iturbides
How do I set attribute symbology when converting from and ArcGIS dataset to KML? Can it be done during the conversion process through FME, or do I need to format the KML file after conversion?
Hello folks I trying to find away to convert ArcMAP text to AutoCAD Multi-line text. Is this possible with FME?
I have an 'update' file geodatabase and a 'destination' file geodatabase. I want to replace an existing feature class in my destination file geodatabase with the updated version from my update file geodatabase. I am using dymanic readers and writers. Usually when I do this with shapefiles I chose to truncate the table and it works fine. However, this doesn't seem to be working for my file geodatabase. The new features from the update file are being added to the existing features (i.e. the existing features remain in the file geodatabase). Is this to do with using file geodatabases (the writer mode can't be set for file geodatabases as it can be for SDE writers), or is it to do with using dynamic readers and/or writers? Can this be resolved?