Data

I am trying to figure out a way to plot a series of points based off xy values in a table. The initial xy values is a lat long and the each of the other points is a set of xy offsets. So, I may have record 1 with.. -107.55 36.55 and the offset is .01 .01. So, the new xy for 1 would be +.01. Then I need it to goto the next record and use the new offset xy. Keeping in mind that the 2nd record has no spatial and needs to adopt the new xy from the last record. In the end the table will create a line based off the 1st starting point. Any thoughts on this? I've tried using the offsetter but without the previous coordinate attached to the offset it doesnt work. Any thoughts?

I am trying to read in an excel document and the frist row contains my column names. After reading in the document all I see in FME is Column 1, Column 2 and so on. I am not sure what I am doing wrong, other than when I use the Microsoft Excel ADO (deprecated) format the headers appear in FME, and when I use the newer excel format the headers do not appear in FME. I would appreciate any healp with this.  

is FME can be used to change name of file and folder and cut files in another? If you prefer I don't want that FME read, i want to use it basically because i have 100 folders to tidy.

I don't kown how to convert the dimension geometry entity,and I need a model of FME to solve the problem. Another, I also need convert the GDB feature like dimensions to CAD formate. thank you.

I have a workbench that works perfect in FME 2012 SP4 but when I run the same one in FME 2013 SP1 (and 2014 beta), the number of features that are created are different. I have narrowed it down to the PointConnector and the way it is handling lists. I set the connection break to the parent_id field (which is the same for all of them) and set the list name to origSeq. Now in 2012, the point are connected and the original attributes that were present on the points are stored in the list as origSeq{0}. I then add a ListIndexer and set to 0 then remove the list and now the lines have the original attributes from the points. In 2013, the last point to get processed has its original attribute shifted to the index of 1. Anyone else seeing wierd behavior with the point connector?  I wanted to send this to the community before I send to Safe support.  Thanks, Sean  

Hi , I come across PSV (pipe separated values file) file as a data source. It is quite similar to to csv but I couldn't add as an input into my workspace. Is there any way to add to this file into my workspace?  Cheers, Engin

Hi,   My workbench is able to read xml files in FME desktop. While publishing, i upload needed files along with it and it works fine. But each time to change fil list, i have to download workbench and modify reader source file list.  First please tell me how to read xml files using publish parameters.  Second, How can i make this dynamic?like placing xml files in a directory and pointing my workbench to read all xml files inside that.  Thanks. Subrat

attribute value of a field in a specific order of my attribute I have an issue as I would like to sort my output kml file in a hierarchical way. I have for the moment sort by country (alphabetic, 1order), by year(numeric,2 order) and I would like to sort now by month but not in an alphabetical way, but from jan, feb, mar...... That means in a monthly order. I have got the value in a field of my shapefile, but I do not know how to display it correctly by month.  Does anybody know the way to do it ?  Thanks in advance! Arnaud

My problem is that I have many files to convert with differents attributs and a static shema seems to be not avalaible (lost of attributs). It's very important to me to solve this problem and i work to solve it but with no success.I think it's a hard case. To understand my problem here is the link of my whole MIF data to convert :  https://docs.google.com/file/d/0B90n7rx5ph0ZaXZXZ21RNUh1WkE/edit?usp=sharing   Now how to obtain : R120_1-1_SHP_LAMB93_FR-ED121 with all the SHP 2D in the same folder than source.( I know how to do that but only in dynamic shema)  thank you

Hi  I have just received LiDAR data in .las format. I am using MapInfo but cannot directly open them in this program. I also have access to Engage 3D (but not Pro)  Can someone please help me with advice as to how I go about converting them in FME workbench into a usable format for MapInfo.  Essentially I would like to get contours, point data (x, y, z) as well as being able to create DEMs. Must warn you I don't use FME often - so please dumb down any advice.  Thanks in advance.  Keiryn McCartney GIS Technician - GTCC

Hello,  I have converted mif to shp and someone quote that it's shape 3D. It's a pity to have z=0 for each point. I look the answers you still gave and try it but no satified results.  So now i want the answer please.  Why the setting i put are not effective?(2d forcer,2D in destination setting..) thanks

Hi, I use into ws FMEServerLogFileRetriever transformer that need to pass it the value of job id. I passe @Value(_job_id) but don't work!. Is there an issue on FMEServer?  There is another idea to get job id value that i passe to my transfomer? thanks an advance.  Farfar

I have a table in PostGIS with a timestamp(4) (with time zone)  data type.    I am trying to insert a value of:  2013-07-06 14:24:50.200  What i get is the following:  2013-07-06 14:24:50+04  The +04 is obviously the timezone, which is fine, however i loose my precision on the seconds.   I have tried most everything and am stumped.  I am currently on still stuck in FME2011.  Thanks in advance for any insight!   

I have a zip file that contains 2 excel files. The names of the files are dynamic (Name Current Date.xlsx), and there is one tab within each spreadsheet. For both spreadsheets, the tab has the same name. When I try to read the zip file, FME is pulling all the records from both spreadsheets, instead of just the first spreadsheet. Since the tabs are the same name, I can't see a place where I can specify which feature to read.  Does anyone have advice on how to only bring in one file from a zip file where the file names within the zip change every day?  Thanks!

Hi, I look for retrieving LogFileName and copy into my folder. example : When i launch a job, i get a log file in : serverjobsubmitter/FME_74061B13_1373896868934_15164.log. i'd like to move it into another folder like "C:/logs" for each traitment. Thanks an advance.  farfar

Hi  We have a GeoMedia Access Warehouse with about 170 tables in it. When we try to add a reader to this warehouse, we got an error-message:  GeoMedia Reader: Reading from GeoMedia Access Warehouse version 5 or better Database error: '[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.' SQL is: ' SELECT "csguid","basestoragetype","geodeticdatum","ellipsoid","projalgorithm","zone","falsex","falsey","latoforigin","lonoforigin","hemisphere","latoftruescale","scalereductfact","standpar1","standpar2","stor2compmatrix1","stor2compmatrix6","stor2compmatrix13","stor2compmatrix14","stor2compmatrix15","azimuthangle" FROM "GCoordSystem"' Successfully closed GeoMedia Access Warehouse reader   Adding readers to Warehouses with less tables

We have upgraded out FME server 2012 sp4 to arcgis 10.1.  For some reason it seems not to be able to see the ESRI Libraries now.  We installed full ArcGIS 10.1.  What can we check to see why it is not finding the libraries ?

I am creating features with SQLCreator on Oracle 11g.   I have some complex joins and filters ... and a LOT of them to issue.  So many that Oracle CPU performance goes to hell.   I'm told because it can't do all that hard parsing, because there are no "bind variables"  I am using FME Server 2012.   There are 16 engines, each submit 2 queries per job to get the features it needs to process.  At any given time there are 32 queries executing at once and by the end of an hour 250+ jobs will have to run.   That is over 500 queries needing a hard parse.  With CURSOR_SHARING set to EXACT, the CPU thrashes itself to death.  How can I get SQLCreator to use bind variables?   Or should I use a reader and parameterize all the SQL for the Reader?   Do readers force bind variables?  Brad

Guys,   I try to create a spatialite file with Dynamic porperties. The workbench works well but when I want to add this file in QGIS (connect a spatialite table database), I have the following error message :    "dbname='...sl3' table"..." (GEOMETRY) sql= is an invalide layer and cannot be loaded.   But, if I drag and drop the file in QGIS, it works correctly.     Does anyone kown why ? It's really annoying becose I'd like to keep the same Qgis project working with Postgis (same layout and layers, just the database changes).     It must be a problem with Generic geometry ou Specific geometry    Cheers   

Hello  I need to use a spezialized Font in order to create text characters which represent symbols with predefined symbolization.  All this because Mapinfo's Font-points are not scaled usefully while zooming, so I will try to use Text instead. I have a specially defined Font and I know the number of each character in the font-table.  My problem now is, that I need to create an attribute with a char-value which I cannot type in through the keyboard, as I only know the number of the font character.  How can I create an attribute with a one character-value whose font-char number (e.g. 45) is in the attribute "symbol_number" ?  I guess Tcl or Python may do the trick, but how ?  Thanks Michael

Hello,  How can i choose my tablespace when i create my spatial index with FME 2013 ?  Thank you  Raphael

Hi,  I need to change the direction of linear element any diection into clockwise direction.I used orientor transformer,it change the direction of shape only line,linestrings directions are not chaged. any other option is there to change the directon of linestrings. 

Hello, I am very new to programming and recently downloaded the trial version of this software because I saw this link:  http://fmepedia.safe.com/articles/How_To/How-Do-I-Label-Google-Earth-Polygons#heading_toc_j_0  I have no idea how to use this program, and I have quite a short deadline so any help on this matter would be helpful. I have several hundred polygons on Google Earth and they must all be labeled, preferably with a placemark. Can this software do that?  Many thanks in advance.

Hi....I am trying to figure out how to convert 4 band high resolution raster TIFFs to black and white raster TIFFs....I'm not have much luck searching around.....I'm using FME 2013 Pro.....any tips are greatly appreciated.....Scott

Hello,  I'm trying to load a SHP file into an existing SDE Feature Dataset (MS SQL).  Using SDE30; however I cant see where you can specify a Feature Dataset? It will happily write to the Root.  I have found similar issues reported: https://groups.google.com/forum/#!topic/fmetalk/STzkdjCzJfo however I'm still stuck.  Any assistance would be greatly apprieciated.  FYI I'm not a big user of FME.  FME Desktop 2012 - MS SQL  Thanks