Data

Hello,  I am currently using a feature type reader with the Merge Feature Type filter * - wilcard to load a reader from command line, ex:    --folder all --data fullcoverage (the path formed with publish params: C:\\all\\fullcoverage\\area.shp What I would like to do, is to allow a user to choose between a default reader (let's say, the YES choice, which would be the above example) or to allow him to insert a completely new path (the NO option). So, if the choice is YES, it will take him on a branch, if the choice is NO, on a different branch. It should work somehow like this: "--choice yes" -> would load the default reader C:\\all\\fullcoverage\\area.shp "--choice no" (should require the "--path" param where the user could indicate the path for a completely different shapefile) which should create a reader like C:\\cities\\test\\dummy.shp if the command is: "--choice no --path C:\\cities\\test\\dummy.shp" I hope I stated t

Hi,  May I know how can I find all the feature class that has not been committed after a run?  Yes I know how to save those feature that have error/ignored by setting the writter but there are those that are miss out because they are not commited anywhere.  I do not wish to manually route them to a database or shape files because it can be quite a tedious task.  May I know if there is anywhere to say all feature classes not saved to be commited into a file or database table?     

Hi,  I want to move text  the in Y direction,using the line as a base(text created along the line nodes already) how to mve this?

so i have a point cloud (lots of them actually) in a LAS file and all of the data is unclassified.   I am wanting to extract the ground heights from the LAS file and then use those height values to create a DTM.  my thinking is to create a 1metre grid over the top of the area covered by the LAS file (or get FME to do this for me?) and then find all points within that 1m grid cell and assign the lowest Z value to the grid cell.  then once each cell has the lowest Z values i can use that grid to create a DTM. I know there will be cells that have tree tops etc in them and therefore the lowest Z value will be much higher than the ground, how to fix this i am not sure as i do not believe FME has convultion filter style transformers availabe?  so is my approach a effcient way? or is there other ways i can go about doing this? any other ideas on how to solve the inevitable issue of cells with no ground points in them?  any help would be apprecaited.

Hi all,  I've got a directory of MapInfo Tab files. I want to convert these to DBF files, and along the way restructure the Directory.  Currently, The Directory structure has 16 categories at the top, and each category has U.S. State subdirectories within it. The tab files are within the state folder.   For example:  USA_ACC (folder) >  CA_ACC (folder) > CA_ACC (TAB files)  I would like to rearrange this directory structure such that the U.S. states are at the high level, and the Tab Files for the 16 categories are within the state folders.  For Example:  CA (folder) > CA_ACC (DBF file)   I have experimented with 'Batch Deploy' and the 'File Copy' writer, but I still dont have a clear idea of how to achieve what I'd like to.  Thanks in advance!

Hi,  Input data are in fgdb_1. Ouptut data will be in fgdb_2 which is acctually copy of fgdb_1. One of columns (attributes) is Shape_Length with already known values. In my workbench I am doing some string manipulation and populate some another attribute. Output values for this attribute are being populated without any problem as well as others without changes, except Shape_Length attribute which now has value <Null> for all objects. Right before writing output data I inserted Inspector to check If there is still values for Shape_Length, and yes, values are there. But after writing to fgdb they dissappear. Where is a problem, why values for shape_length are lost? Tips? Database overwrite is set to NO, transaction type is transactions, table drop no, table truncate yes, attribute names are the same of course, i don't know..

Hello folks,  I'm sure someone has ran into this issue before, but I can't seem to find any intuitive way of accomplishing this.  I am trying to setup an excel spreadsheet reader with the constraint that my header (column name) data is contained on row 3 and my actual data begins at row 4.  Row's 1&2 contain groupings of the column names (in row 3) and can be disregarded all together.  How can this be done in an FME workbench?  Is it possible out-of-the-box? or is custom coding/scripting required?  Thanks in advance.  Regards, JP

Hi folks,  I've had luck outputting the Mapinfo table from Oracle including the MI_STYLE that picks up the symbology. The issue I'm having is the tables are coming out as a native table rather than linked. I'm using FME 2012 Desktop and I've not found anywhere in the Oracle reader or the MITAB writer where the metadata tags can be exposed.  We parse the U:P to our tables so we can refresh them in Mapinfo when required rather than outputing a new table.  Below is the tab contents that I'm expecting to see. What I'm currently getting is the attributes sans the metadata at the bottom of the file.  What have I missed???  Thanks  Michael   !table  !version 550  !charset WindowsLatin1 Definition Table    Type LINKED Charset "WindowsLatin1"    Fields 56      DOP_UID Decimal (10, 0) ;      DPR_UID Decimal (10, 0) ;      DRILLING_OPPORTUNITY_NAME Char (30) ;      CASED_AND_SUSP_EST_COST_JV1 Decimal (13, 3) ;      CASED_AND_SUSP_EST_COST_JV2 Decimal (13, 3) ;

Hi Is there an Autocad equivalent of the Microstation Convert_Dimensions.fmw file ?  I have tried modifying the settings in this file to suit Autocad attributes but can't seem to get it to work.  Can anybody please give me some pointers to modify it properly or provide a link to an already modified version?  Thanks Tim

Hi FME Gods,  I'm new to the FME world, so I'll try to explain my problem as good as I can.  I'm receiving the following error, when running my workspace:  "Geodatabase Error (-2147220655): The table was not found. Could not open File Geodatabase table '\\Skovkort\\Teknisk_anlÅ|g'"  Now I'm Danish, so I use the special characters :æ, ø, å. The character 'Å|' in the end of the error message, is actually the character 'æ' in my ESRI geodatabase, however FME has changed it in the error message. I have not had any problems with my other data, which do not have any special characters in them.  So my question is this:  Do anyone know if FME has problems with reading in databases, which have special characters in their name, and if so, do anyone have a solution?  Looking forward to any replies.:-) 

Hi, How can i set the character set for an Input CAT (txt) file. It seems it is not possible and when writing to a database (UTF-8) the scandic characters get messed up. Shold FME be able to recognize the character set from the file?  

I have one spatial point feature class(X) having 10 records with unique id (1,2,3,4,5,6,7,8,9,10). I Have one object table(Non-Spatial) (Y) having 25 records with foreign key (1,2,5,6,7,8,3,10,4,5,3,6,7,9,2,1,3,5,10,2,4,5,6,10,8).  So my question is can I create spatial feature class of (Y) which is Non-Spatial, using spatial feature class (X)  by Using any FME transformer.  Now i am having X-feature class with 10 records graphically.  I want to have Y as a spatial feature class with 25 records using X-feature class geometry.  I have Data Interoperabality tool.

Text x - y offset   when I migrate text that uses point to for location to arcgis enterpise geodatabase (annotation)     I notice the text will never be at the same position because annotation has a box and the text is contain in that box.    may I know how do I remove the margin?

I don't know much about the generic writer but I'm hoping to use it to write to:   shapefile gdb dxf dwg dgn V8  I eventually want to expose these options in a drop down menu on a public fme server, I'm trying to duplicate the functionality I have in this Spatial Direct page which were finally getting rid of migrating to fme server 2013.   http://ocs-spatial.ncd.noaa.gov/SpatialDirect/translationServlet?SSFunction=prepareFetch

How can I read a zipped CSV file from a FTP site, extract it and save it. Nothing I have tried seems to work. Has anyone done it successfully? Would need to do it on the both FME server and desktop. I would be thankful for any input.

i'm stumped...  I have FME Workbench installed on 2 different machines.  On one machine the Oracle readers are enabled and available to be chosen and on machine 2 they are grayed out and disabled.  Yes there is a dot in the Licensed column of the Reader Gallery on both machines, so I believe I am licensed for it.  I have the Oracle client installed on both machines.   Machine 1 is Windows 7 64-bit. Machine 2 is Windows Server 2008 R-2 64-bit.  How do I "enable" the Oracle readers on machine 2?  on Machine 1 the Oracle client was installed first, then FME 2013 SP1.  On Machine 2, the Oracle client was installed after FME 2013 SP1 was already installed.  Does that matter?  Sarah

(working with server and workbench 2011 32-bit)  Hi,  I'm trying to use a published parameter that is a combo of two other private published parameters in fme server.  e.g.  full_path=$(drive)$(path)  where drive="D:/" path="afolder"  i'd expect D:/afolder to be returned from $(full_path) as it is in workbench.  however i get the unresolved string '$(drive)$(path)' instead once i've published the workbench to server.  The full_path parameter is being used as an esri personal gdb dest_dataset parameter.  Can anyone explain why this may be?  Are joined parameters like this supported in FME Server 2011?  I thought they were.   Nick

When adding the Generic Writer into the Workspace I dont seem to be able to select multiple formats to write to. I can only pick one.   FME Desktop 2013 Build 13263  I have public web forms now but whichever format the user picks from the drop down menu it writes to shape. Because I only have Shape writers in the workspace. So I need to replace the Shape writer with Generic Writer and have it be able to write to shape, file gdb, dxf, dgn.   https://fmeserver.ncd.noaa.gov/encdirect_extract_approach.html

I recently backed up my running 2012-sp1 machines to a FFS and did a update to 2012-sp4. When I run a workspace to restore my FFS to Repository I can see all my workspaces are back in the appropriate repositories.  But None of them are linked anymore to the Job Submitter service, so its like they don't exist anymore. Is there a option where I can go and re-assign them to the proper service again?  Otherwise I will need to republish all 40+ workspaces and that is just a time killer.  Thanks;  David (DEWright_CA)

We use a lot of point clouds, a few here and there for GIS/Civil application. Our more common usage are using land laser scan in big existing plants (brown field,) place them as reference in our CAD software to do the CAD design of existing structures, equipment, etc. We then redraw what is exiting on top of the point clouds.  We can have hundreds of designers and engineers spending time re-drawing the objects on top of reference point clouds.  If we could recreate surfaces of structures and equipment, to recreate the shape of walls, beams, piping, etc. That could save use an enormous amount of time (and money)  We do have many Point clouds management software and add-ons for CAD, but always look for alternate solutions; does anyone found ways of recreating thos type of shapes efficiently from Point cloud using FME?       

I usually only work with vector data but now have a task to create 3DPDF documents for distributing to a project team.   My issue is this:  how to generate a colorized raster representaion in 3DPDF using the raster contained within an Esri FGDB. I am completely new to this process and can get it to produce a TIN from the raster, but i am unsure of how to colorize the raster and have it represented in a 3D model of the source raster. Any help would be great, thanks!

I'm getting this error below:  MS SQL Server Writer: Failed to parse `Date' from attribute value `05/07/2013' for column `EAST_current'  My source is an Excel file and I'm writing to a regular non-spatial SQL Server 2008 table.  All the columns in the SQL Server table have the datetime data type.  What could be the problem?  Do you see that single tick mark in front of the 05 in the error?  could that be a literal value?  I tried testing for that tick mark character in a Testor using the Match RegEX test using [`] and \\A[`] as the right value, but the row came out of the Failed port.  So I don't think the tick mark is really there.  The source data looks like this when I view it in the Feature Inspector while the translation is running:  5/7/2013  so I use the DateFormatter to conver the month and date to 2 digits with this date format:   %m/%d/%Y  this seems like a simple problem, i just can't see it.  Sarah

Forgive me if this question has been asked before. I don't know how to phrase it in such a way that I can find an easy answer though.  Bascially, I'm developing an fme script to QA incoming topographic data against our business rules and then compare it against our database to determine the change.  What I want to do, is have the database reader only pull feature classes from our database that match the incoming data: eg: only pull the roadsegment feature class from the database if a roadsegment feature class was provided.  If I haven't given enough information or this questions was answered elsewhere please point me in the right direction. Appreciate any help. Thanks.

Hi  Is there a way to set priority for scheduled jobs in FME Server 2012?  Thanks, Anders

Hi all,  We work regularly with both Micsotation versin 7 and V8 formats. We are trying to build a workbench that will allow users to select output format using the Generic Writer.  Since the seed file dictates the microstation version output, we need a means of allowing users to select the output seed file (depending on if they request v7 or V8 output).  Is there a means of publishing the Seedfile parameter in a workbench file to allow the end user to select the file? Is there another method of telling FME what version of Microstation to output?  Thanks, Mike