Using readers and writers to extract and load data.
Recently active
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!
How to convert/transform a ArcGIS 10.0 Geodatabase (*.adf) Esri ArcGIS Binary Grid to a SHAPE File including feature types? 1. I open an ArcGIS 10.0 Geodatabase (*.adf) Esri ArcGIS Binary Grid (AIG). 2. With Inspector I can analyse the Grids. It says: Raster Point Info: Cell Value (INT16): 653 Row and Column: 3028, 7828 Ground Location: 675689.057708 3. What I need is the Cell Value as a feature type for a Shape-File. Does anybody know how to do that? What I want is the SHAPE with POLYGON-Grids with the Cell Value (INT16): 653 as a feature type. Is that so difficult? Many thanks for any hint!!! Best wishes, Timo
Hello, Sorry about the long subject. I have an issue where SOME workbenches published to FME Server, the data is being written to the ...FMEServer\\Server\\repository directory instead of a file server (via UNC path). Sometimes when go to run the workbench via the fmejobsubmitter web page, the parameters only have the last folder name not the UNC prefix I.E. the path should be \\\\fileserver\\folder1\\folder name2\\folder3\\data.csv on the web page it is folder3\\data.csv. I enter the full path with the quotes and run the job. The data ends up in repository\\folder3. After the job has completed, I look at the log file and it has the correct and complete destination path. Any solutions other than upgrading to 2013? Cheers,
Hello I create a Tiff/GeoTiff in FME and then visualize it ArcMap. I build pyramids and use "bilinear resampling" in ArcMap and I get a quite bad display quality. If I read the same image into irfanview and save it (with nothing changed) and then use this Tiff in ArcMap the display quality is much better (smooth lines, better text readability,...). A colleague, which is quite an expert in raster, analysed both files and couldn't tell any difference except for the internal block size used. Is there any idea what is hitting me here ? What does FME bad with the raster so that ArcMap cannot display it with good quality ? This behaviour seems to be independent of the resolution. Thanks for any helpful idea Michael
Good morning. My name is Ramón Castro, from the University of Vigo and I am a new user of FME sowtware too. I am looking for the way to transform a .dxf to CityGML. I am not sure about what transformers I have to use. Anyone could help me?? thnak you very much
I'm reading a file which is delimited by a space using the csv reader, some of the fields are enclosed in quotes (although this doesn't appear to be related to what type of data they contain). If i read the file with the parameter strip quotes from fields set to no and then rewrite the file with quote output values set to no i get an error that a string value could not be converted to a float. Any ideas on how to read this file and write it out again in the same format?
Hi, is there a way to create use workbench to analyze and list the readers and writters from other work spaces? Thanks for the help. I hope all is well Merry Christmas to all
I made an affine transformation on my dwg file . in fme Data Inspector 2013 the transformed result is good .but When I opened the resulting dwg file in AutoCAD 2008, I found the text position remained unchanged , only others like point ,line ect is at the correct location. why ? Can any one help me ? thanks in advance.