Using readers and writers to extract and load data.
Recently active
I'm using FME desktop workstation and application server to write output kmzs to our client server. For some reason, kmz files exceeding 5 kB in size result in empty files with 1 kB file size, regardless of whether executing at the desktop or from the server. However when writing to a kml to the same client server or writing to the desktop, it works fine as usual. The user account used is able to write large files to the server location. The application log files show nothing unusual. There didn't appear to be a user permission issue. The service account looked fine. Where else should I look to troubleshoot?
how do i get FME to create the spatial index on a SQL Server SDE database -- documentation references GRID 0 - but there is no parameter for it in FME2014?
Hi: I have a layer with zoning, and a cadastre layer - the boundaries dont match up so i was trying to user a negative buffer to shrink the parcel a bit to eliminate most of the missmatches - but then i am getting too many null buffers. trying to do it with a spatial relator and a matcher and it is getting overly complicated. So time to rethink how i am doing it. What is the best way to copy the zoning text attribute from the zoning layer to a parcel layer on top of it - there are parcels with multiple zones? Thanks, Mike
Hello! This is serious failure I have here: after installing FME 2014 I cannot get my Oracle connection working properly. All the previous workspaces will crash if I try to save them over. I figured out that the problem starts even if I try to add "Oracle Spatial Object" type reader on the blank workspace, it crashes: It's weird that with 2014 beta I did not have that problem - I changed all my 30 or so workspaces, to use 2014 (2013 SP3 was our previous, still working with Oracle). But the database <null> support that came out with 2014 was a crucial benefit for us, so switching back would be really annoying. What could cause the FME 2014 to crash workspaces with Oracle Spatial reader? And, it is weird that using "Oracle Non-Spatial" reader is not causing crash... With regards, Raivo Alla Estonian Land Board
Hi, I have a feature class of polygons that I would like to convert to a text layer in the DGN file with one of the attributes as the text shown. I have played about with GeometryCoercer and tried changing the format attibutes (igds_type and igds_text_elements{}.igds_text_string) but cant get text to display in the place of polygons. Has anyone managed to do this?
Hello All, Just a quick query re the new GME Tables format. I've managed to connect successfully to our GME instance, list our projects, list our tables, and retrieve features. Unfortunately, the list of available tables seems to be limited to 100. Has anyone had any luck in working out how to retrieve tables beyond that first 100? I've tried manually entering the assetIds as a workaround, but with no success. Cheers, Keith
Before I proceed in my FME training I wanted to see if it is possible to create FME workspaces where it would require for it to ask for an input GIS file (Mapinfo TAB) and for it to run various processes (conversion, reprojection, renaming) based on where it is coming from. I would need this to be a reoccuring tool that I would run for different folders at different times. For example I have different folders that store different GIS files based on the specific geographic area it is in. I have many of these folders that I run the same processes at different times based on which area I happen to be working in that day. So I wanted to know if I could open an FME workspace and have it ask for an input file, then runs the process I set up for it to do based on the folder it is from? output file names would need to be custom to where its coming from everytime. I am basically trying to decide if I need to learn FME, or Mapbasic to create mbx tools. Or can FME do anything a programing la
Dear All , We need to combine all the attributes from AttributePivoter into another feature class , we used FeatureMerger to combine the attributes but we are not getting all the attribute from AttributePivoter . if we write AttributePivoter to excel directly it is working fine , but now we need to use the excel output into the same feature class . so what is the way to get it in one shot 1) AttributePivoter with FeatureMerger but not getting all the attribute 2) or if we write it to excel how can we use this execl as input again on the same work bench 3) or call another workbench from the same workbench to read the output excel file and merge it with another feature . Thanks,
Hello Everyone I have multiple Geomedia text features that I would like to split by a mapsheet border. Example: if 182 Street NW crosses the boundary where 182 is inside and Street NW is outside I would get two labels back 182 | Street NW. Any ideas I'm using FME 2013 SP 3 Cheers Ron
Hi all, As you can see, I have a quite complex question. Some genereal information: I'm using Windows Server 2012 FME Desktop and Server 2013 ArcGIS Server 10.2 What I want to do: Using a Web Harvesting program, which searches on a OpenData-Site for accessible WMS Service, which I want to integrate in my WebMap. The WebHarvesting program stores all WMS links in a txt file. The links look like this: http://gateway.hamburg.de/OGCFassade/DE_HH_WMS_INSPIRE_A3_4_Bodennutzung_lokal.aspx?SERVICE=WMS&REQUEST=GetCapabilities&VERSION=1.3.0 Now I want to use FME Desktop, which reads/parsed the line and after that, FME should publish these links to the FME or ArcGIS Server Rest Interface. So....firstly my question would be: Is this possible? And secondly: If it is possible, how to realize it? Regards!
I often need to convert large numbers of layers from TAB to DWG CAD format. Is there a way of doing this on bulk or looping a workflow to repete an action over a list of inputs. If i need to convert TAB to SHP all i need to do is put them into the 'generate workspace' and it makes a workspace with the correct number of reader and writer feature types and copies across the attributes. HOWEVER, I cant do this with TAB to DWG files as it asks for the destination folder AND file name then merges all the input layers together into one file. I have therefore had to translate each file separately (and when you have about 60 files this takes ages) Now I want to go one step further and add a clip function. I have 32 TAB files which i need to clip by a boundary and then write each file to DWG. Currently the only way i can see of doing this is making a workspace with 32 reader feature types, 32 clippers and 32 writer feature types (remembering each time to say copy attributes from reade
Hi, I have a process that converts a DWG to PNG tiles. The last transfomer before the writer is a RasterBandPropertiesExtractor to check what will be written. This shows that each tile is RGB24 bit (red8, green8, blue8) also the tiles that are completely filled with background (255,255,255). But when the PNG tiles are written the tiles with only background are converted to a 1bit image instead of a 24bit image. Is there a way to force RGB24 tiles like you can with the tiff writer? Regards, Rob
Hi, I'm trying to use a gdb file with FME 2013 but am getting this error: |ERROR |Geodatabase Error (-2147220965): This release of the GeoDatabase is either invalid or out of date. |ERROR |Could not open File Geodatabase dataset `D:/flood/GDB/uFMfSW_Banded_Vector_SK00.gdb' for reading. I'm using the "Esri Geodatabase (File Geodatabase API)" reader. I do have ArcGIS 10.1 installed on the same machine, but for some reason FME isn't picking it up so I can't use the ArcObjects one. How do I read this?
Hi, I am trying to convert a CSV file (no header, just X Y and Z columns) into either a LAS or POD file format. However I keep getting the error: "Failed to obtain point cloud from feature. Only features with point cloud geometry are expected" Is there a step that I'm missing here? Thanks,
I am trying to build some 3D planes from XYZ centre points. I have generated the planes using sector generator coerced these as polygons then 3d Forced them @ZValue rotated them CLOCKWISE them using ) and I am stuck trying to get the resultant planes to rotate/tilt on their Z axis about their @ZValue centre using an @Value(Dip) can someone please provide a screenshot of a 3DAffiner example of a Z-axis affine of say 10 degrees AND a 3DRotator example of a custom axis example OR z-axis example to apply a 10 degrees to each plane element? the help file for these two transformers are for irony and i am unable to debug why nothing is tilting. Kind Regards, Steve
Hey! I am trying to convert XML informations (30K non geospatial elements) into formated PDF for each of my elements (30K). What would be the best way to do that? - I am able to create a table for all my elements, but I don't see the way to create a formated PDF each elements. - I checked out about the XSLTProcessor, but It doesn't seems to be useful to create a formated PDF. Am I wrong? Anyway if you have better ideas I'm wide open! Thanks
I have a hiperlinked text in an Excel spreadsheet, and I want to load this spreadsheet into an Oracle table but the hiperlinks saved in the table, not the text in the Excel cell. Can I do this in FME? I am using FME 2013.
Is it possible to automatically name the output writer based on parts of the folder name the reader/TAB came from AND the name of the reader itself? For example, This is the folder where the reader/TAB came from: "KNKA208 CMA 028A Indianapolis" And the readers/TAB name is "Authorized CGSA" and I want the output to be named: "A-KNKA208-028-Indianapolis-Authorized CGSA" Thanks! Joseph
Hi, In a mapping file while importing data to smallworld we have exposed format attribute "fme_basefilename". Using this name only we have to set the current world. Know please let me know how to get handle on this exposed format attribute so that i can set the current world.
Hi, I am trying to combine 2077 Raster images into one big one. I chose TIFF as the output file format which threw this error. (SYSTEM: Desktop FME 2013 on Win7 4gb Ram) "TIFF writer: The resulting file is too big (approximately 207.87 GB). This format cannot support a file size over 4.00 GB. Consider tiling the raster to reduce the output file size" Nice error message, but what is my alternative? Should I use the BigTIFF format? Thanks, Rob
I was wondering what the intention of this Reader is. It seems to only read the data in from the underlying FeatureClass. A layer file contains a lot of important information used for the display of the data in ArcMap. This includes visible fields, field aliases, defintion queries and scale ranges (to name a few). I am wondering why the reader does not expose these properties of the layer file. We are using 2013 SP4.
Is there any FAST way to write TEXT-features to ArcSDE, either via the ArcSDE (SDE) or Geodatabase (GEODATABASE_SDE) writer. I see the tip is: Avoid annotations Avoid or minimize the number of annotation features, because writing to these is slow. It has been improved when writing annotations with no user-defined fields. However how to save text-features withouth this approach? Have looked through this already: http://fmepedia.safe.com/articles/FAQ/Improving-Performance-when-working-with-Geodatabases The number of text-features to insert is around 2 000 000.
Hi, I'm using an ESRI Filegeodatabase writer with a dynamic feature type to copy feature classes from one file geodatabase to another (with some processing on the way). I'm finding that some of the longer feature class names are being truncated when they are written to the new geodatabase. Everything else is working fine, the geodataset names are ok. I've tried specifying an attribute with the feature class name too, but it still truncates the name. Any ideas on how to resolve this? Thanks!
I am converting Oracle Point feature to Oracle Text feature for GeoMedia (6001). 1. I have Reader with fme_text_size, fme_text_string and oracle_orientation. 2. Next AttributeCreator Attribute Name Value geomedia_rotation oracle_orientation geomedia_type fm()_text geomedia_justification 1 3. LabelPointReplacer for Text Label 4. Writer I connect geomedia_rotation to fme_rotation, geomedia_type to fme_type, geomedia_justification to geomedia_justification. The output table's geometry has (3001,,(,,),(1,0,6000,4,1,1,7,1,0,,,, insteat of (3001,,(,,),(1,0,6001,4,1,1,7,1,0,,,, It should be 6001 for GeoMedia Text feature. Can someone please show the answer?
Is is possible to expose a jpeg attribute on a dynamic writer? I have a workbench that extracts the GPS coordinates from jpeg exif data (taken with a GPS camera) and plots the positions as a points feature class. I need certain attributes exposed, e.g. exif_gps_latittude. Can the set the dynamic writer to expose them? Also, liking the new forum!