Data

How to convert dwg files to kml.Tried to convert get ==============================================================================Total Features Written 0=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-KML: Writing dataset to filesystem...KML: Feature does not have a coordinate system specifiedStoring feature(s) to FME feature store file `.\\mapping_log.ffs'

There are two types of Esri Geodatabase writers for file geodatabase - "File Geodb API" and "File Geodb ArcObjects". Can anyone explain the difference and why I should use one over the other?,

Hi,In my workspace I have a featurereader that reads GeoTiff-files enclosed in ZIP-files. Subsequently I create a shape-file containing the bounding boxes of the GeoTiff-files and three attributes. The attributes bestand and lufo_jaar only contain values when I add an inspector to the featurereader. When I disable or remove the inspector, the attributes in the shape-file are empty. What is wrong with my workspace?I built the workspace using FME Desktop 2015.I'd really appreciate your help with this problem.Willy

Hello, I have an element which contains child elements but I only want to extract the text of the element ignoring all the child elements. Here is my example : <list_item>  <paragraph>A wreck exists in position   <location>America>  </location>  </paragraph>  </list_item>What I would like to extract is A wreck exists in position. Usually I use the Attribute Exposer but in this case it is not workingbecause the closing tag of the paragraph is after the location.What transformer should I sue in this case?Thanks for you help.

I'm trying to post an idea, but I can't upload an image. Does anyone experience the same thing? Tried it on Mac and Windows, with Chrome and IE. Didn't matter: the upload bar never progresses.Strangely enough, it does work for Q&A; posts like this one:

Hi,If possible could someone answer these general Point Cloud Questions, apologies if they are obvious? 1. What does the PointCloudConsumer actually do? It is effectively acting as a valve which restricts the maximum number of points (as specified within the block size) being read in at any one time? If this is the case, then I assume it is used to ensure that the downstream workbench processes are not overwhelmed by the size of point cloud points? However, I assume that the block size means that the whole point cloud data will be read, but effectively it is read iteratively, rather than in a single hit. If it it not doing any of these things then what does it actually do?2. Does encoding a LAS file as a blob using the PointCloudExtractor pretty much only change the encoding; but not really ‘compress’ the data in terms of size. I have a LAS file which is about 18MB in its native format. I have read it into FME and then used the PointCloudExtractor to convert the file to a blob. I have

Hello,I want to attach all address-attributes (city, postalcode, street etc.) to my citygml-lod2-buidlings. And I want to add them in the right way (not as generic attribute). I know, I'll need a citygml-writer called "Address" beside my "Building", "RoofSurface" etc. and I'll need to point the gml_parent_id to the gml_id of the building.So how do I have to create/fill the attributes, so that the address is properly written to the citygml-dataset?

Hi All, I'm trying to import JSON into a postgres table which has a JSON column, Unfortunately I get an error of:PostgreSQL connection: Column 'data' has unknown type with OID 114, treating as char(80)Is there a way to increase the default past 80 characters? As the reason its failing to insert to postgres is the JSON isn't valid cause it gets truncated to 80 characters.

Hi.I am writing to a Microstation V8 DGN. I have used the DGNStyler transfomer to convert a series of points to cells, and now I want to set the color of the cells based on an attribute. However there doesn't seem to be the option in DGNStyler or in any of the igds format attributes to set the color of a cell.Any ideas?Thanks,

Hi,I have got citygml files. I need to extract the footprint of each building and the corresponding building id, such as:<bldg:Building gml:id="_26991">One building can have more than one footprint.I'm not very familiar with citygml / fme. Can someone give me a hint how to extract the footprints (which seems quite easy) but additionaly get the building id as well. It seems I need to access the "building" for the id and "footprint" for the footprint. But how do I get building - id for each footprint?Many Thanks, Rob

Would be grateful for some advice on this. FME is refusing to load any data from this WFS service. I can see the set of layers (get capabilities) from the service when I try to add the reader but when I select the data layer I need and hit ok the log is giving me the error below.This WFS service loads vectors just fine into Qgis but not FME. Any help would be appreciated.http://www2.guildford.gov.uk/ishare5.2.web/getows.... The top-level type definition referred to by the 'type' attribute in the element declaration is missing from the XML SchemaQName: 'ms:ogc_fid' | namespace uri:'http://mapserver.gis.umn.edu/mapserver'QName: 'Integer' | namespace uri:'http://www.w3.org/2001/XMLSchema'<element xmlns="http://www.w3.org/2001/XMLSchema" name="ogc_fid" type="Integer"/>

Good Day FME'ers,I have recently upgraded to FME 2016 and I have been testing all our production workspaces to make sure they run correctly. Some of our workspace write data out to CartoDB and they have all no started producing errors. The log record is as follows:2016-01-28 11:42:05| 17.1| 0.0|ERROR |CARTODB writer: HTTP Error 400-599: HTTP error code : 4002016-01-28 11:42:05| 17.1| 0.0|ERROR |CARTODB writer: Error returned by server : relation "{table_name}_cartodb_id_seq" does not existwhere {table_name} is the cartodb table.The data or table structure has not changed since upgrading and this did not occur in 2015.1. I'm not sure if it's a bug in FME or an issue with CartoDB. I could delete and recreate the tables in CartoDB but I would lose the styling.Any thoughts?Thanks,David McDermott

I have to transform various datasets in gml-files which have to have a certain structure (>xsd-schema-file). The gml-files get imported into a subsequent application which checks the structure and throws an error if something is missing.In my original data though, not all the featureclasses exist in all the datasets, and in the gml-files that are written, those featureclasses are not contained and I get errors afterwards.I would like FME to write all the featureclasses to the gml that are defined in the schemafile, so that if there is no data for a featureclass, the tags for this featureclass are written into the gml-File, but without data between them.There's a parameter for the GML-writer "Write all featureclasses", but the tags are still not written for missing featureclasses.(In the docs it says concerning this parameter: Every GML writer DEF line is translated to the output GML application schema document as an XML Schema element declaration and a corresponding

Im frequently receiving this warning that forces me to delete postgres or postgis readers and add the readers again. There are cases that forces me to always keep the workspace open otherwise i will need to re-ad readers and set again exposed params. Anyone else noticing similar thing with PG readers ? Thanks Jorge

Hi Guys,another question for an issue i never did in FME.... with which transformer i can do such operations before writing excel ? (screenshot substract) 

Hello everyone!I am extremely new to FME Desktop (2011). I've been playing with it for the last few days. I am at a point where I would like to ask for your help! I would really appreciate all your suggestions/answers.Background:Currently, I'm trying to modify an existing workbench. This workbench grabs data from an Oracle database. The data goes through a series of transformers: Joiner -> AttributeClassifier -> 2DPointAdder -> ListExploder -> FeatureMerger (where another Oracle table is merged) -> ListExploder_2 -> FeatureMerger_2 (where a new CVS file, with 277K rows, is merged) -> ListExploder_3 -> AttributeFilter -> MapInfo TAB file.Current Situation:The above seems to be running okay for a small subset of data (1000 rows from Oracle).There is another CSV file (60+ rows of lookup data) that I would need to merge into the existing workbench. (Creating another table in the Oracle database might be a better solution for this lookup table. But

Why does TextPropertyExtractor expose no Attributes?

I am trying to work with LiDAR LAS files but am having an issue.  When FME reads the file or when I open it in inspector all I am getting is the bounding box of the points, what am I missing to work with the points themselves?  Thanks

Hi! I am fairly new to FME. I am trying to develop a tool which creates a bounding box around features in the database. I've managed to create the bounding box as well as all my features into a .CSV file. What I want to do is make the writer use the coordinates found by the bounding box when saving the file name for each file. I have tried using @Value(<attr name>) however this just tells me my schema isn't set. I have also tried using a fan out feature on the writer, doing this allows me to save the file with the coordinates, however this then just leaves me with a blank file whereas I need a table with all the features and their added bits with it. Any help or advice on where to look would be appreciated!

How convert tiif, geotiff or jpeg2000 (jp2) multispectral (3 bands) in ecw,Thank you,Best regards

I have some route geometry that I am trying to highlight when it is selected or rolled over. I think that I should use the KML styler but I am not sure how to proceed.

i have an LAS file and want to export a custom text file with X Y Z R G B Classification. how would i do this the writer for txt only exports XYZ values and i can't seem to find a way to get this information out of my point cloud.

I have a text file extracted from an Oracle Spatial Object containing an ID field and ST_GEOMETRY with a pipe delimiter between the fields. I would like to create a polygon shapefile from it using PointConnector, or any other transformer. PointConnector does not recognize the ST_GEOMETRY field.

Hi all,we are in the process of evaluating the FME tool for one of our proposal to the client. since I am new to FME, I just downloaded FME trail version and tried to generate some easy report using Oracle Database spatial tables as source. here i tested with one oracle geospatial table which has one sdo_geometry column 'Coordinates' so i have used oracle spatial object reader type and selected the above table but it did not show the Coordinates column rest all it showed - can you please let me know how to get this column in reader table? and am i using the right type of oracle spatial category?

Hi,I am trying to migrate microstation V8 graphic elements with tags into ESRI's shape format. I am using a dynamic reader and fanning out features in different shape files based on fme_feature_type.The problem is when I read elements from microstation several other attribute appear in the process which are not part of the TAG SET of microstation file. I tried removing those by adding attribute remover or attribute keeper transformers but those attributes are not visible as an attribute in any of the transformers, I can able to see it only FME DATA INSPECTORS attribute property pane, these junk attributes manages to pass through and write in the shape file which I don't want. Can anyone please help me solving this.Thanks in advancedIMRAN