Data

I have some shapefiles which FME reads and then writes the data to PostGIS. I have added a Spatialite writer to the workspace as well as I have some users that need file based access to the data.  The data loads into PostGIS fine and I can see the Norwegian characters æ, ø and å fine.  But the data loads into Spatialite with these characters replaced.  The data is writen to PostGIS and spatialite in the same workspace, so it goes through the same transformers etc.  Can anyone suggest how I can fix this?

Trying to read: http://docs.safe.com/fme/html/FME_ReadersWriters/Default.htm#geodatabase/Writer_Directives_EntGeodb.htm  To figure out what the parameter setting: Validata Features to Write does. However I can not see any documentation on it. I "assume" it will only write Valid Features to the database (ie - features that have all Attributes) and that it will FAIL and ROLL BACK once it meets a feature which misses an Attribute in the feature (that is not null)   

Hi,     I am new to FME. I want to know how I can perform following task using FME  1. Convert PGDB (.mdb file) or shape format (.shp/.dbf/.shx) into FGDB format.  2. Perform topology and attribute validations (eg. Check for required feature classes) on uploaded FGDB format files using geodatabase workspace XML file template.     If you can provide links to related documents/pdf’s/video; it would be great help.        Thanks & regards,  Priyanka Foss.

Hello List  I need to be able to change the setting to create default spatial columns from YES to NO in existing workbenches writing to PostGIS.  From this question (https://safe.secure.force.com/apex/AnswersQuestionDetail?id=906a0000000ciBiAAI) and Mark's answer:  Another setting that may help, when you add a new writer look at the properties dialog and there is a setting called "Create Generic Spatial Columns". As long as that is checked the table should be a generic one and not need a geometry type set.  I have been able to get my (new) workbenches to work the way I want them.  However, I have a number of old workbenches with the option checked.  When I connect my QGIS to PostGIS I see duplicate entries in the layer picker - one for the table with correct geometry and one for the table with unknown geometry.  Can I retrospectively edit my workbench to change this setting?  Thanks  Ross

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

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

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