Data

Hi, I'm new to FME. I have an Excel spreadsheet with X/Y co-ordinates that I want to convert to KML for use in Google Maps. I've managed to do the conversion OK and create the KML but Google Maps won't read it. Google Earth will read the KML OK but I need to display it in Google Maps. Any help would be much appreciated.  SeanOB

Hello, I'm new to FME and have a workbench that does a dgn to ArcSDE geodatabase (SQL Server)  feature class conversion of points.  I have the "drop table" set to "yes" which I assume deletes all the features in the SDE geodatabase before writing to it.  To that end, when I run the workbench, I get the error below.  I can see that the geodatabase has locks from ArcGIS Server (we have three instances of ArcGIS Servers running).  I would have to manually stop each ArcGIS Server instance before running the workbench to get it to run correctly.  Is there a better way to run the workbench and update the data?  Unable to drop the table/feature class 'Bollard'. The error number from ArcObjects is: '-2147215875'. The error message from ArcObjects is: {Table is already locked [aoc_gis.GISADMIN.Bollard]} A fatal error has occurred. Check the logfile above for details.    Thank you  Steve

Hi community,  I have a script which translates database content into an SDF3-file. Writer and Reader are dynamically. The Reader gets its schema from the writer. Now I got the effect that numbers with the value "100" are converted into "1e+031" in the SDF3-file. Within the scipt everything works fine. "100" stays "100". All other numbers, too. They are also correct in the SDF3-file. It just concernes the 100's. I already tried to set the attribute again to the value "100" and add an attribute to the Writer with a type 'decimal', without success.  Can anybody help me?

I have built an FME workbench that translates Ordnance Survey's MasterMap Topographic layer into MapInfo Professional TAB format.  Most features translate fine (once you get passed the line style issue with the MapInfoStyler transformer!) but I am having particular issues with the CartographicText feature type.  The GML format that Ordnance Survey provide their product in contains an attribute to set the anchorPosition of the text but I cannot get this to be recognised by MapInfo Professional at all.  I originally thought that using AttributeCreator to set the mapinfo_text_justification might do it but this just sets the justification within a block of text, not the original anchor position.  I'm pretty new to FME so there might well be something I'm missing but after having tried a number of different transformers I'm getting the feeling that it might be a limitation of MapInfo Professional and not FME.  Does anybody have any bright ideas?

Hi all,  I'm currently working on a project where the customer wants to use an existing configuration xml file, where they can enable / disable custom validations and store some validation properties (such as allowed feature class names).  I'm struggling to find a proper way to do this, can anyone point me in the right direction? 

Hi all,  Today is my second day with FME, so I apologize if my quesrtion is very basic.  I am trying to convert LiDAR (las) to DEM data (esri grid) but am having a problem with the interpolation. Any files that do not have adjacent las files to them - that is they are on the perimeter - interpolate all areas within their tile even if there is no data.   Is there a parameter that limits the distance for interpolation or somehting similar?   Thanks.

I am currently using the NeighborFinder to calculate the distance and direction between two points.  However, angle (direction) is calculated from the x-axis, counter clockwise. Is there an easy way for me to calculate the angle from the y-axis (ie north) clockwise?   Otherwise, I may be stuck doing some fuzzy math to rotate and flip the numbers!  Thanks in advance for any help.   Mattt

hi all I am trying to convert a shp to obj using the object id as fanout. The file name of each obj file has to be the same as the object id, right now the directory has the name...anyone know how to set this up? thanks 

Hi again, while I am trying with the help of support solve one problem, comes new one :) Ok, maybe it is not a problem, but I need explanation. If I have, for instance, 10 geotiff files, each has 1 Mb of size, how could be possible that one jpeg2000 mosaick file of those 10 files is ten times bigger i.e. 100Mb even If I used compression 20% . What kind of new informations appeared ? Thank you.

Hi all,  I am creating some PDF files for someone and they need to have the map scale and a scale bar on them.  Each map will be at a different scale so I could do with a way of calculating it and then create a scale bar based on this.  Any help would be much appreciated.

Hi,  I need to read a Map 3D .layer file (RDF) using FMR readers. But I can't see any such reader to read a Map 3D .layer file.  Please let me know how to read a Map 3D .layer file in fme.  Regards, Ananda

I am trying to create a set of shapefiles with mixed case attributes but, even with what I think are the appropriate settings, I am getting upper case attribute names. I am using a writer with dynamic schema to write the set of shapefiles with the "Use Upper Case Attribute Names" unchecked. I read in the help for writers that this setting will not be used unless you create a new workspace and add the writer to that. I did this but to no avail, I still get upper case attribute names. The input features all have miced case attribute names. What should I do? I am using FME 2012 SP4 Win32.  BTW, how do I add the workspace and log to this question? Perhaps having those would show the problem?  Chris Mugdan

Hi FME Community,  I have a problem where I am trying to create an ellipse based on a published parameters "acre" input. It's a fairly straightforward process to do this with a circle/buffer as the radius of a circle can be calculated based on a volume, in this case number of acres.  However, I want to create an ellipse where the radius of one axis is 2x the radius of the other but still sized volume-wise by the input of the published parameter.  Is there a way to create "circlular buffers" and, for lack of a better term, turn them into ellipses by stretching them as they alreay have the correct size by acreage?   

Does anyone know the latest, most stable postgre postgis version tested with fme server 2013 sp1 for windows 32 bit?  Or even just a recommendation?   I suspect it is postgre 9.1 with postgre 2.0.x on stackbulder  but i wanted to confirm as we are configuring a new dev server.    Thanks, Reed

Hi,  I am new to FME, and am in the process of creating a workbench (in FME Desktop 2013) that joins an ArcSDE Feature Class to an Oracle Table, and writes the output to KML.  I was fairly successful, but am having difficulties in writing arbitary/additional XML data using <ExtendedData>.  See this link for info about KML Extended Data (scroll to the bottom for the arbitary XML part) https://developers.google.com/kml/documentation/extendeddata   I would like to include the following in the KML:  ExtendedData using xmlns:pdif="http://www....." pdif:Agency pdif.Status pdif.StartDate pdif.EndDate Values for these fields will come from the joined data.  I am not sure how to do this, and would appreciate any help/input.  The ExtendedData required are in addition to some other fields such as Name, Description, Geometry, etc.  Thanks for your time and consideration.  Regards,  Sendhil     

Hi FMErs.    I have workbench on FME sever where I want to have either dwg or shp as the input file.  I have set up a paramer called clipper_reader_formats which is choice based (with alias).  In the configuration I have imported the two formats and then linked this parameter to the Reader Input Formats.  In FME server I now have options visible that let me select the appropriate reader.  However, I am having trouble with the actual Source dataset field:  If I have it as: \\\\glofme02\\data\\Tasks\\Clip_By_Polygons\\Reader\\Clippers\\*.* it doesn't work  It does work if I put in: \\\\glofme02\\data\\Tasks\\Clip_By_Polygons\\Reader\\Clippers\\*.shp but this only works for shp files obviously.  I'd like the workbench to pick up the relevant files, but only for the formats specified or selected.  I'm not sure what I need to put in this field.  Thanks.

Hi  Trying to convert some DGN multi-part text nodes into ESRI geodatabase annotation using FME2012  Build 12258  Currently I have the setting Advanced>Split multi test  set to No and the file is going through a Geometry Filter - String Concatenator- TextAdder sequence.  But, I get the error : "Invalid geometry type received for an annotation feature. Please split multi-part annotations using the SPLIT_MULTI_PART_ANNOS keyword on the reader to 'yes', or switch to classic geometry mode before attempting to write them to a Geodatabase"  How do I solve this to enable a multi-part annotation to be written to the geodatabase, and then also set the leading/line separation, please?  Thanks Tim 

Hi I'm having an issue using a User Paramater inside the END SQL with the Oracle Writer.  I can use it in the WHERE clause on the Reader no problem but using the same format on the END SQL is causing me some problem. I'm sure it is something simple that I've missed!  Reader WHERE: USERUPDATED = '$(P_USERNAME)' Writer END SQL: DELETE FROM DB_UPDATED WHERE USERUPDATED = '$(P_USERNAME)' It literally tries to find the string $(P_USERNAME) Here is the contrived example (yes I would normally do this in SQL!): http://db.tt/kWQgcu3j

I would like to know how to convert SHP file with its attributes to DGN . DGN should include all data and its  attribute .

Hello,    I am very interested in upgrading my development  and production web servers to FME 2013 due to an issue I am having when trying to convert AutoCAD .DWG files into Adobe Geospatial Files.     The error I received from the FME 2012 SP4 log when using Universal Viewer is as followed: AutoCAD Reader: Unknown or unsupported version of AutoCAD file 'AC1027'. Most recent supported version is 'AC1024', which is also known as 'Release2010'    I am assuming that the .DWG was created with a version of AutoCAD that FME 2012 SP4 can not handle; however, I am hoping FME 2013 can.  The big thing is that I am hoping to not have a production server outage.    If someone can help me out, I'd appreciate it!  Thanks in advance!  

Hello all, I am confronted with a task in which i have 100's of LAS files in which i need to find minimum distances from part of the data to another.  For example, in one LAS file i have trees, structures, powerlines water pipes etc (standard urban environment) is there a way i can find out the minimum distance between say the powerline and the nearest tree? OR adversely have a limit to say no trees within 5m of powerline and 10m water pipes and have FME spit out the a result set of trees/structures too close to the powerlines/water pipes etc?   any help would be appreciated. cheers

I am trying to use wildcards/regular expressions to identify multiple FFS files to read through one FFS reader in the FME workbench.  If I use something like "C:\\SomeDir\\*83.ffs", the FFS reader reads all files that end in 83.ffs in the SomeDir directory.  I can even use "C:\\SomeDir\\*8[345].ffs" to read all files that end in 83.ffs, 84.ffs, or 85.ffs.  Now I want to read all files that end in 11.ffs or 83.ffs.  When I try "C:\\SomeDir\\*(11|83).ffs", I get an error message "Invalid FFS dataset directory 'C:\\SomeDir\\*(11|83).ffs'".  I have also tried a comma, semi-colon, or space separated list of filenames to no avail.  Is this possible or do I need to create two FFS readers?  Any suggestions would be appreciated!  I'm using FME Desktop 2013 SP1.  Steve   

Hello,  I have serveral different directories within one directory that have TAB files (of point, line, and polygon geometry type) that I would like to merge and convert to SHP by there unique name.  For example:  \\\\one\\test.TAB \\\\one\\test2.TAB \\\\one\\test3.TAB \\\\two\\test.TAB \\\\two\\test2.TAB \\\\two\\test3.TAB  What I want is for the output directory is, all the same name files to be merged and converfted to ESRI SHP, e.g.  \\\\export\\test.SHP \\\\export\\test2.SHP \\\\export\\test3.SHP  I defined my TAB reader to the TAB directory/sub directory as Single Merged Feature Type.  For my SHP writer I defined my output directory, however I'm not sure where to go from here since it is asking for a particular geometry type and the input TAB files are of different geometry type being point, line, and polygon.  I guessing there is some automated way of using one reader and one writer instead of creating seperate readers and writers for each unique input dataset?  Thank you

I am using ArcSDEQuerier with only an attribute query to fetch geometry for features. The where clause uses an attribute value populated by an earlier SQLCreator transformer: "POLYGON_NUMBER = @Value(POLYGON_NUMBER)". I have noticed that the query running in Oracle uses a hard-coded value rather than a bind variable.  This adversely affects performance. Is there any reason why the ArcSDEQuerier does not use bind variables? Also is there way to alter the SDE connection CURSOR_SHARING session parameter before running the translation so that I can force the use of bind variables?   I am using FME 2012 desktop, the Oracle version is 10g and ArcSDE version is 9.3. 

Hi,   does anyone know if the MODULE_PATH parameter has any impact for java plugins? You'll need a db file with 3 entries in /pluginsinfo:    PLUGIN_NAME|MODULE_PATH|MODULE_TYPE  For all java examples the MODULE_PATH is not set and tests with different setting show no effect at all. FME seems simply to add all jar files in /plugins to classpath.  The reason why i am asking: We have a plugin which requires a lot of 3rd party jar files. If we put all files just into /plugins it just works fine. But we would like to put all our files in a subdirectory, e.g. /plugins/myFac/*.jar so we do not clutter the directory. But this seems not to work, even i we manipulate the system wide CLASSPATH before starting FME.  Any suggestions/hints?