Best Answers

Hello.  I have several hundred .xyz files that I want to translate to las/laz files.  Using a reader-writer (Point Cloud XYZ- LAS) does the job:  Inputs are something like 100903_120345.xyz, 100903_120736.xyz but the output files have names like POINTCLOUDXYZ.las, POINTCLOUDXYZ_1.las and so on What I would like to happen is for the output files to inherit the base name of the input so that the outputs would be named 100903_120345.las, 100903_120736.las etc. I'm very new to FME so apoligies for this simple question.  Thanks  Justin.

AttributeExploder seems to output attributes in a different order to those in the input.  Is there a way I can either prevent them being reordered or somehow tag and re-sort to the original order later?

i have a string with coordinate pairs forming a polygon. the missing parameters are created using sql. I was wondering if there is an easier method setting up a default polygon in the desired geographical area. just the sdo_ordinates vary for each inserted line in the table.

Hi,  I am creating a data download service with FME Server that should provide an ESRI File Geodatabase and an MXD file. The MXD file should be postprocessed with Python and arcpy in a shutdown script to fit the feature classes, extent and projection of the extracted data. The workspace transfer the MXD is  to the FME Server output location together with the File Geodatabase. This works well in FME Desktop. The MXD is accessed programatically using an output folder published as a parameter. The same method does not work with FME Server. How do I access the MXD file  in the FME Server output location programatically from Python?  Regards, Knut Olav

Thre should be a simple solution for what I am trying to do, but for some reason I can't think of it.  I have two polyline feature classes.  Feature Class 'A'  is made up of segments of the Feature Class 'B'.  However, not all segments of a line from 'B' exist in 'A'.  Some segments are missing.  What I need to do is compare the two to find out what is missing in 'A'.  Basically just looking for a "subtract" feature for lines.  I know how to do this for polygons, but not for lines.   Any ideas would be much appreciated!  I feel like it is really simple and I'm just overlooking the easy solution!

Hello,  I'm trying to calculate the amount of overlays of features in a geodatabase. Im using the AreaOnAreaOverlay transformer for this. However, what comes out of the transformer is quite strange. The amount of input features is 13, yet, the _overlays attribute gives values upto 24. Additionally, it fills in gaps (holes) that aren't part of the shape but are surrounded by the shape.   In the attached file I provided the workspace and files I'm working with.  ftp://ftp.safe.com/incoming/FME_AOA_error.zip  I would really appreciate the assistance, I don't quite understand how this is happening.

I have a workspace using a "Swiss Interlis" writer that produces an XML file. The writer takes the full path of the file from a parameter. I have linked this destination parameter to a Python scripted parameter that generates the file names dynamically depending on user input.  That workspace works fine in FME Desktop and as a Job Submitter service on FME Server. If I publish the workspace as Data Download service it fails with the error message: "The filename, directory name, or volume label syntax is incorrect" and also returning the source code of the Python parameter. It looks like the Python source code is used as a file path rather than running the script and using its result.  I changed the script to only return a filename instead of the full path, but I still get the same error message. If I enter a hardcoded file name into the writer destination parameter (instead of the Python script) everything works fine and the file name is used in the downloadable zip

Hello community!  I tried several times to get mtexts of a dwg into sqlite without success. the mtext-entities are represented as points in sqlite, transferring text-string and text-rotation as attributes of these points. text-string as well as other stuff (height etc.) can be exported without any problems, but with rotations i never had any success. i tried "autocad_text_rotation" as well as "autocad_rotation" as well as "fme_rotation" but always gives a "0" as result in sqlite. datatype of rotations in dwg is always "number, 31,15". I tried using "decimal, 31,15" for the sqlite, but it says in the log, fme can only create "decimal, 29,15" datatype in sqlite.  What's the problem? Why can't i use the dwg-mtext-rotation? thx for any help, best regards from switzerland.

I have done features migration into FGDB to Oracle SDE Format through Mapping using FME  . There is any tool , this will give me mapping between Writer  & Reader In csv  or any other format .

We are trying to view in FME for connecting the Oracle Spatial data. We are encountering issues when connecting.  Can you suggest while looking at the log.   The following is FME  connection error   FME Data Inspector Version 4.0 Loaded module 'OCI' from file 'OCI.dll' Environment variable ORACLE_HOME has value `D:\\Oracle11gDatabase\\product\\11.2.0\\dbhome_1' Connecting to ORACLE database `pgeprim' with user name of `GRBGAE' and password of `***' Error connecting to Oracle database: message was `ORA-01017: invalid username/password; logon denied'. (serverType=`ORACLE8i', serverName=`pgeprim', userName=`GRBGAE', password=`***', dbname=`') Failed to open database with username='GRBGAE', retrying using uppercase username Environment variable ORACLE_HOME has value `D:\\Oracle11gDatabase\\product\\11.2.0\\dbhome_1' Connecting to ORACLE database `pgeprim' with user name of `GRBGAE' and password of `***' Conn

I have developed many workbences having parameters username=ADPUGSD Servicename : Stage . But I want to move my data into another server having another servicename : 'stage_new' . Then I will modify scripts with changes in parameters on writer side or I will add another writer and then mapped to source. Pls clarify & do needful asap

I've had great succes in FME  2012 using attributeValueMapper. In 2013 beta I find it completely bogus - whatever I do the values are mapped from null to null, including the  "default value" field.   Opening a workspace created with 2012  and inspecting it I see that my mapping are replaced with null to null relations.   This probably means I'll have to revert back to 2012, just as I was starting to appreciating some of the new shiny things of the 2013 beta... :(   Or is it some new functionality / logic / whatever that I get wrong?

I have an automated nightly process that runs and outputs several tables to SQL Server 2008.  This week we have had intermitten issues with connecting to SQL server.  One night it failed and the next it worke and then again it failed.  It is giving me an warning message of:    MS SQL Server: Connection not properly cleaned up, please contact support@safe.com. Connection key '1_|_3_|_TABLENAME_|_DATABASENAME_|_<unused>_|  I am looking for any insight of what might be causing this.  Is it an FME issue or a SQL DB issue.  I am running FME 2012 SP2 Build 12235 WIN32.  Thanks Travis

I try to convert a stormwater AutoCAD file into ArcGIS feature classes. How can I identify the flow direction. i.e. for a pipeline, which side is upstream or downstream? 

So I am using the schemamapper to batch map attributes from one format to another using a CSV. In the CreateAttributeMap screen I have it set remove the source attribute. When I run my features through, it appears that all the attributes in the CSV are being assigned to every feature regardless if they exist on the source and attaches them to the output feature as an empty attribute (which is why in my last post I asked about removing all empty attributes).  Has anyone else seen this behavior? Is there a setting in the schemamapper that tells it to only map attributes that exist on the source?  Using FME 2013 x86 b13187  Thanks, Sean

Hi All,  I am trying to tranfer the objects into the internal world's of either pad,switchgear or substation..Can any one please let me know, is there any possibility way to transfer the internal worlds from source file like microstation.  Thanks, Seshu

We are running FME Server 2013 Data Streaming which is driven from a MapGuide site and outputs PDF files. This is quite a complex workspace which generates logs up to about 2MB per request. I would like to be able to turn down the degree of logging to just ERROR if possible. Some of the other services seem to have the option in the .properties file to set the DEBUG_LEVEL = SEVERE. This does not appear to be an option in the Data Streaming config file. I tried adding it anyway with no success.  Anyone have any thoughts? Am I missing something basic here?  Thanks, J  

I am reading a line feature class in sde and the output is a buffer polygon. I am going to sum an attribute in dissolve but want to make sure the attribute is  updated.  the original data is in a projection with meter as the unit.  I want to update 2 fields with the length in feet and the length in miles.  Is there a way to do that in the same workspace?  In arcmap I would have to start an edit session, select the coordinate system, calculate geometry, then choose the unit to output.

I would like to use FME to calibrate a regular street network for use as the basis of a linear referencing system.  Business rules are pretty simple: - routes should be built from constituent street segments without merging said segments - assume that valid routeID's already exist as an attribute in street segments - routes begin in cardinal south and end in cardinal north - routes begin in cardinal east and end in cardinal west - route measures are based on lengths of geometries composing the routes.   I recently created the results I want using Geomedia Pro with Geomedia Transportation Manager, but I would like to migrate to using FME so that the workflow is more easily reproducable.   Any resource that can help me get this done is appreciated.

How do you take a specific attribute from a grouped/sorted set of features, and cumulate the sum feature by feature and store in separate field?

Hallo, I have to import an Esri Geodatabase to Smallwworld Gis 4.1.1. To import polylines and points are no problem. To import an annotation is probably, because the justification is alyways on the lower left side. How i can set the annotation to the middle center of the polyline. I use the labeller to set and import the labels from an annotation list. I read the the article from FMEpedia (Article Number: 000001996) but i don't understand this. How i have to use the attributes sworld_vert_just and sworld_horiz_just?  Thanks from Austria wasc

For compatability-reasons with Geomedia I need to write an additional field of the type "varbinary(max)" to all the tables in our SQL Server Spatial database. In FME I can set the varbinary datatype, but I can't set the "max" value. I've asked around and so far it seems the only workaround is to create the field with the datatype "image" and then alter the datatype directly in SQL Server afterwards. Any ideas on how to do a better workaround?

I am reprojecting Rasters,  63 of them. They are all pretty much the same size 1.1GB.  It took 2h to reproject the first one.  now we are at # 32 and it's taking around 4h.  Is there a way of doing a memory dump or starting fresh after each raster when doing batch reprojection?  Thank you.  Dominic

I need to batch-convert a lot of featureclasses from an Oracle Spatial database into SQL Server Spatial 2008. In it's own, that's not a problem to do, but I need to have all the attribute names and values in lowercase due to compatibility reasons, as all our data in SQL Server will be exported to our hosted WebGIS-server, which runs PostGIS. I can use the CaseChanger to make all attribute-values lowercase, but I cant seem to transform the attributenames themselves into lowercase. Only workaround I can see is using the AttributeRenamer or AttributeCopier and then renaming every single attributename by hand. I'm looking at converting well over 200 featureclasses, so doing it by hand is not an option. Anyone got an idea how to make all attributenames lowercase?

Take a look at the What's Great page for FME 2013.  I'll wait while you do that..........  Done? OK, which of the new functionality are you looking forward to the most?