Data

Hi, I am new to FME, i want to know how to compare File Geo database(.FGDB) with some xml configuration file for Feature class, or attribute or topology validations. Short demo will be helpful for this. Regards Rahul Sumant

Hello, Is it possilble to remove an Oracle table by FME. Transform SQLExecutor and instruction "Name_Table DROP TABLE" does not work. Thank you for your return.

Hello. I am having some trouble with writing dates from a Mapinfo (MID/MIF) file format to an ssf. I have tried creating a field and then populating it with the specifed date but it does not seem to be writing. Any ideas of how i can make this work would be much better than having no date, or entering dates for the 2000 points I have. Cheers, Emma.

Hi All, While importing ESRI SDE (SDE3) Annotation feature to AutoCAD drawing with object data. We are getting Annotation features as polygons. Cloud you please provide suitable solution, so we can export attribute data of SDE to AutoCAD annotations as TEXT/MTEXT instead of polygons. regards Govardhan

This is a simple question but it's Monday morning so would appreciate help. I have a list of features, and one attrbute is between 6-8 characters long. I want to rename the attribute with the first 6 characters of their existing attribute (so drop the last two characters where they occur), and remove any features whose attributes are duplicateed due to the new name. eg. i want to make; AB1234AB to AB1234 and only leave 1 record of AB1234 in my output. i'm trying in BulkAttributeRenamer but think i may be over complicating it cheers

Hello, I am going to be upgrading to FME 2013 today, and after doing so, I was wondering if anyone could lend a hand in telling me if FME can provide what I'm looking to do. 1. We stored all data in a MapInfo .TAB file (flat files) for each customer 2. Customers will give us new data on a weekly basis; however, the data being given includes everything from the first submission, and then perhaps some additions that are legitmate. In doing step 2, the customer is actually creating duplicate objects stacked on top of the first upload. My question is can FME run a process to find and eliminate all those duplicate objects so that only one remains (since the others are useless). Thanks for any insight in advance. Nick

Trying to write 3D solids to Sketchup. I have managed to do it with buildings - however I struggle on writing a surface to Sketchup. I get the INFORM:SketchUp Writer: SketchUp face creation failed. Attempt to wrap face in SketchUp Group. Anyone know how to prevent this and successfully create a terrain model to use in Sketchup?

Hy, I have a point cloud. I want to have a regular grid. But I don't want to create points where I have no points. So Is it possible to create a rasterDEM with points clouds without interpolation? thanks in advance nicolas

I have a custom FME toolset that a client would like to run in ArcGIS. If they were to have the FME Data Interoperability extension purchased/enabled is there a way to upload/convert/run a full-suite FME workbench in the ArcGIS/FME Data Interoperability Extension? If so, how would I proceed? I work in both FME and ArcGIS but have not worked with both in this way before. Any help with this would be appreciated. Matthew Brucker

Hello, maybe my question has an simple answer, but I can't find a way to solve this problem. Is there any possibility to read out the data types of an input-file? For example: A shape-file with three attributes: Name --> char, Adress --> char, Number --> int. I need the data types (char, char, int) in a FME-List or something like that. Finally I want to write them in a simple Excel-Sheet. I'm using FME 2011. Any help would be appreciated. Thanks, Hans000

Morning All i currently need to extract OS data by polygon extents from a fgdb. Setting the polygon is not a problem, and clipping the data to this polygon works. The problem is that there are 6 readers, each reading in different OS features e.g. Area, Line, Boundary etc. The line readers reads in 64000000 features which crashes my FME and also takes an age. I know what i'm doing works as i can extract from the smaller feature readers, but is there a different transformer i should be using rather than clipper? or before the clipper to avoid reading all the data into the workspace? The reading of all the data seems to be the problem as it's reading in over 100,000,000 OS features. any help of guidance is greatly appreciated. Chris

I am using the dwg writer to create blocks based on xls input file. Everything is working fine except that I that I am unable to set the block names in the output. All block names appear as autocad_block_name : test_ACAD_1_FMEBLOCKn where n is 1 to as many blocks created. How can I enforce the block to be named one of my input field (blockname) ? Thanks

Hi, I'm tryng to do some fancy colour manipulation when using the Excel writer. I'm already using a template XLS to define the basic structure of my output worksheet and that's working fine. I'm also defining custom cell (column) formatting on the feature type user attribute definitions, which allows me to specify custom number/date/text format strings and a custom font colour. That's working fine. What I would like to do is set a custom background colour for a particular row. I know that FME is capable of setting the background colour because if I choose the "Simple" Format Type for the attribute column properties I can specify the font / font color / fill color for a column and it works. However, if I choose the "Custom" Format Type then I have to enter in an Excel compliant format string which onlly offers font colour and not fill colour. I've tried setting the fme_fill_color attribute on the desired features but it didn't have any effect. Has anyone been able to achieve anything li

Hi, Is there a setting somewhere that dictates the maximum file size that can be uploaded by the file upload service on FME server 2013? We are finding that anything larger than 27mb will cause an error, even though we have changed the tomcat configuration to allow a maximum file size of 100mb to be posted. Thanks, Andy

We've started having problems with a number of existing fme workspaces that have worked fine for a number of years. The workspaces run, however looking at the log file there are several warnings titled "Unexpected end of file". The end result is mapinfo tab files written out with geometry missing from a varying number of features. Sometimes rerunning the script produces the same errors but with slightly different numbers of features written without geometry, sometimes rerunning gives no warnings and everything is processed fine. I have already split the workspace into two separate workspaces in case it was a memory issue. This worked fine for 5 days (it runs overnight) before one failed again. Any ideas on where to start?

I have FME desktop professionnal version, but I can't choose 3D PDF as writter. Do I have to activate something? thanks in advance Nicolas

Hi Just wondering if anyone knows if this is possible?

Is there a way to silently link a generic writer to a generic reader format? Ie if the user selects a geotiff as input the output would be geotiff, if DTED then DTED. I can publish the output format, but the user would still have to manually change the output format.

I am trying to load an FME Workspace that generates KML into Bing. I used to be able to do it, but now every time I try, I get the error, "Unable to load source file." Strangely enough, when I put the URL into a browser, I get a KML returned. But, when I try the same exact URL in javascript for Bing maps integration, I get the "Unable to load source file" error each time. Already tried and did not work: 1) Specifying ports in the URL (:80) to no avail. 2) I can load KML into Bing maps from an FME url ("http://fmeserver.com/fmedatastreaming/Demos/REST-kmlstreaming.fmw") but not from the server that FME is loaded on within my corporate intranet 3) I have tried running the web page on IIS directly (port 80) instead of using the WebMatrix IIS express (which uses port 7313) to host the pages; still get same error. 4) I have tried granting full permissions to the fmeguest and fmeuser roles, still get the same error. Know that: - The computer I am running IIS on is on the same corporate intra

Hi, Fairly simple one conceptually. I have a string: /geoserver/ows?TRANSPARENT=TRUE&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetLegendGraphic&EXCEPTIONS=application%2Fvnd.ogc.se_xml&LAYER=ROAD_SECS_BY_CLASS_WSHIRE&FORMAT=image%2Fpng&SCALE=19999.99999369495 I want to explode it into its component attribute/value parts, so the above would become a bunch of attributes in FME (or a list I can explode into said attributes): (attribute name -- attribute value) transparent -- TRUE service -- WMS version -- 1.1.1 etc. This seems like a very obvious thing to want to do, does FME have a transformer to do it or am I going to have to do it a hard way? I can't seem to find a transformer for it. Thanks, Jonathan

Hi, My reader is a shapefile which is transformed to ten kml files. Each folder Output is composed by 2 files, one file (included all hierarchical organisation folder: event type,country,year, month, event) and one placemark (included coordinate, styler...). So I would like to merge all these kml files in a single one in keeping the structure I have (event type,country,year, month, event). Is there a tool to do that? Thanks in advance for your help. Regards Arnaud

Hi All, I have a workbench which calls several Feature Classes from a Feature Dataset on an SDE. Each month as property is processed, a new Feature Dataset is created on the SDE containing Feature Classes of the same names. I have tried to set a parameter which prompts the user for the Feature Dataset location each time the workbench is run (Parameter) but all to no avail. The closest I can seem to get is to point it to the SDE. Has anyone encountered this problem before? Know of a way around? I have mainly been trying with a "Directory (Existing)" parameter, however in desperation have even tried a "Text" parameter! Any assistance would be appreciated.

I try to convert an Oracle Spatial table to MapInfo .TAB. There is an MI_STYLE column. The spatial table looks all right in a MapInfo linked table. In the workbench I ticked ' Apply MapInfo Symbology' and set the Style Column to MI_STYLE and Index Column to MI_PRINX (as they are in the database) n the Oracle Spatial Object Parameters panel. However I get this eror message for all the objects and the style of all the objects in the output MapInfo table are the same (default): ORACLE Reader: Failed to parse MapInfo Symbology string. String was `Pen( 2, 2, 32768 ) ' All the objects are lines and polylines. Does anyone have an idea why FME cannot parse the symbols?

Hi all, new to FME and would like to know: I have an excel sheet with a column of (Attribute id's) and a column of (lengths m). I also have a tab file that relates to the excel sheet and has the same Attribute id's. Can I change the spatial length of the polylines in the tab file to be the same as the lengths in the excel sheet??

Hi I have an issue with using the Dynamic writer in FME Server 2013. It produces the zip file but its empty and the location is has written to on disc is also empty. When running the workbench it works but not when uploaded to server 2013. I had no issue with the dynamic writer on 2012, is there a setting that i have missed out? Even the standard ''easytranslator'' does not produce and files so something to do wth the writer rather then the individual workbench Regards