Best Answers

Hi there  I am using FME 2013 SP1 and have installed GeoMedia Professioanl 2013 after removing GeoMedia Pro 6.1. When I now run a workbech that was writting to a Geomedia access databease I get the following error  The program cannot start because CFCacheName.dll is missing from my computer.   I know this file was used by GMP 6.1 but was removed when I did the uninstall.  Any help would be greatly apprciated  Cheers  Ron

Hi,  I am reading data for MySQL and would like to prevent migrating the same data each time i run the workbence (it will be running as a scheduled task). To do this I have created an 'export' field in MySQL, with a default value of '0'. The workbench has a tester at the start, that will only allow a value of '0' through, and at the end of the workflow, I want to change all '0' values to '1'. I get an error when trying to run this writing back to the MySQL database.  My question is this, normally I would use the database updater transformer, but this will not write to MySQL, so how would I update the MySQL database and change these values.  Many thanks in advance.

Hello,  I have AutoCAD dwg layer feature which i'm converting into another coordinate system. What I'd like to do is to preserve rotation and height informations of input data in output dwg layer (since input contains labelling information that I don't want to resize and rotate in output).  I'm kinda new into FME so I apologise in advance if this is a silly question.  Thanks.

Hi, I have a custom coordinate system that I was confused how to translate it to the MyCoordSysDefs.fme for use in Safe Desktop. Here's how it is represented in the prj file.   PROJCS["Lumos_Projection_Foot", GEOGCS["GCS_North_American_1983", DATUM["D_North_American_1983", SPHEROID["Geodetic_Reference_System_of_1980",6378137,298.2572221008916]], PRIMEM["Greenwich",0], UNIT["Degree",0.017453292519943295]], PROJECTION["Transverse_Mercator"], PARAMETER["latitude_of_origin",0], PARAMETER["central_meridian",-80], PARAMETER["scale_factor",0.9996], PARAMETER["false_easting",4921259.843], PARAMETER["false_northing",0], UNIT["Foot_US",0.30480060960121924]]  I read over the help for FME DEsktop, but the I did not know how to translate it because it had two units and so many Parameters. I appricate any help. Thanks

Hello all,  I'm trying to update an Access table of mine using generated GUIDs, lets say I have the following: Table_one PARENT_GUID,FIELD_GUID ABC123-EFT1,TEST23 ABC123-EFT1,TEST24 ABC123-EFT2,TEST23 ABC123-EFT2,TEST25  Also: Table_two PARENT_GUID,MEMO_FILLED_WITH_GUIDS ABC123-EFT1,#IF##AND##CONDITION#{TEST23}ISNULL#ENDCONDITION##THEN##DO#{TEST24}ISMANDATORY ABC123-EFT2,#IF##AND##CONDITION#{TEST23}ISNULL#ENDCONDITION##THEN##DO#{TEST25}ISMANDATORY  Now, due to some reasons, as you can see the FIELD_GUID is non-unique. I want to make it unique, and replace the FIELD_GUIDs with freshly replaced ones. However, seeing Table_two.MEMO_FILLED_WITH_GUIDS is a memo field filled with guids, I'd thought of using the replace function, within a SQLExecutor, like this:  UPDATE Table_two SET MEMO_FILLED_WITH_GUIDS= replace(MEMO_FILLED_WITH_GUIDS, @Value(FIELD_GUID, @Value(NEW_GUID_GENERATED)) WHERE PARENT_GUID = @Value(PARENT_GUID)  Where NEW_GUID_GENERATED is a GUID generated using FME.  How

I am looking to add vertices every X meters along a line (singlepart shapefile). Chopper seems to almost get me there, but it is making a multipart shapefile rather than working at a vertex level. Is modifying the abilities of the Chopper with another transformer the right approach?

I am doing a spatial join by intersect of points to areas (joining an attribute of the points to the attribute of areas). SpatialFilter does what I want exept when there is more than one point that intersects an area. The point attribute that is joined seems to be the max of the candidates but I would like the average.   I explored all the settings in SpatialFilter and there does not seem to be any parameter that sets the merge rules for this kind of situation. Do I need to bring in another transformer to join the average value rather than the default max value?  

I'm experimenting with incorporating Excel workflows into my FME workspaces and am stuck.  My workspace reads in a raster, then I get raster properties using RasterPropertiesExtractor, then I create a few more attributes with AttributeCreator, and finally I want to write to an Excel file with each attribute name in the first column and its value in the second column.  I tried many settings under "format parameters" in the excel writer, but with no luck. The main problems I am having is that 1) nothing seems to write to the excel cells no matter what settings I have under "format parameters", and 2) the image of the raster is inserted into the excel file, which I don't know how to stop.  I'm obviously missing a few things in my first attempt...    

Hi, Having some problem using SQLExecuter and SQLCreator with a Postgre/Postgre.  Error connecting to PostgreSQL database(host='**.***.**.***', port='5432', dbname='*******', user=postgre, password='***'): 'FATAL:  password authentication failed for user "postgre"  Its not really a authentication error since both the postgre and postgis reader and writer works fine with the same credentials. I can connect to the tables in the SQL transformers but when I hit run I get "authentication failed"  Anyone have an clue?  cheers Henrik Rinne   

I have a workspace that writes out one multipart shapefile (many rows in the dbf).  I'm looking to instead write out separate shapefiles that would correspond to each part (i.e. one shapefile for each row in the the multipart shapefile).  Not sure if my workspace requires additional transformer(s), modifying the writer parameter settings, or would involve both transformers and writer parameter settings.  I tryed experimenting with fanout settings in the the writer, but I haven't got anything to work.   

I noticed today that the dwg writer asks for a file name in a folder (unlike other writers that simply ask for a folder).  How can I force FME to call the resulting dwg by  the "feature type name" that I define in the name parameters of the writer? It seems that when I do define a name here, it still reverts to calling the output whatever I chose when I was first forced to chose a folder and file name of the writer.  

At the bottom of this (https://safecommunity.force.com/CommunityAnswers?id=906a0000000cg4JAAQ&v1=907a0000000cZZVAA2&v2=Up&#!/feedtype=SINGLE_QUESTION_DETAIL&dc=FME_Desktop&criteria=ALLQUESTIONS&id=906a0000000d05pAAA)page, Takashi commented that expressions written into FME translators have an FME specific syntax.  The syntax does seem very straightforward, but I was looking to see if there are some useful, more advanced features about it that I have not come across. I tried to find out more details about the syntax, but with no luck; I don't know what to call it when searching.  Is there full documentation to this syntax? Does it have a more formal name than "FME syntax"?    

Converting Areas, Ellipses and Arcs to lines,  I couldn’t figure out which transformation tools can convert Areas, Ellipses and Arcs to Lines such that they are collected in one ESRI feature class (polyline type).      Thank you   Best  Jamal

Error: “The spatial comparator received a feature with invalid geometry”  I have two CAD layers: Boundary (hatch type) and Roads (lines type). I wanted to clip the roads that are located outside the boundary.  http://www.mediafire.com/download/6md00ozcmk0w7dx/AlSawahra_Jerusalem_UrbanMasterPlan_04_X_04.dwg    I applied the workbench below but I got the message “The spatial comparator received a feature with invalid geometry”    What might be the issue here?   Thank you  Best  Jamal

I would like to collect data every week and save one weeks data to column. How can I save data from week 1 to column 1, week 2 to column 2 etc? I have tried to set 'Start Column' as $(xlsx_start_col), but that does not work. I also tried to use $(xlsx_start_col) as 'Use Attribute Names As Column Positions, but but didn't work also.

I want to include the workspace name as part of some metadata I generate   Running the workbench as a workspace the $(FME_MF_NAME) variable returns my workspace name Once I convert it to a custom transformer (CT)  this variable returns the fmx name rather than the calling fmw name  I set a published parameter to the value of the $(FME_MF_NAME)  in the CT Running as a Linked CT I get the following error   Starting translation...  Undefined macro `ArcGIS_MetaItemDescription_FME_MF_NAME' dereferenced in file `C:\\Users\\scooter\\Documents\\FME\\Transformers\\ArcGIS_MetaItemDescription.fmx' Program Terminating  Translation FAILED.   Running as an embedded CT I get the correct result   When I embed and run it using a private parameter I get the same error  Starting translation...  Undefined macro `ArcGIS_MetaItemDescription_FME_MF_NAME' dereferenced in file `C:\\Users\\scooter\\Documents\\My FME Workspaces\\wb-xlate-1399417605939_8048' Program Terminating  Translation FAILED

Hello,  I am transforming GML exported from Caris Source Editor, into GML (with coded values being translated).  In my Reader I have three feature types, which share some, but not all attributes. I use several different transformers on all of the features, then use a FeatureTypeFilter to send the records to the correct Writer Features. There are also three of these - matching the reader features.  The attribute names in the writer are different from the reader, so the attributes must be connected manually. That works okay, and the values (e.g. xml_char type attributes) will transform and appear in the destination file. So far, so good.  However, as soon as I shut the workspace and re-open it, half the connections are lost. Seemingly, the ones that are kept are the ones that appear in all three of the reader features, any that only appear in one or two of the features are lost and need to be reconnected everytime.  *Pulling my hair out here!*  Any ideas?  Thanks Dan  

Hi dears,  I've been try create a route with KMLTourBuilder. Could you help me with this?  I make a route in Google Earth and exported to kml. I add in a reader KML conected in KmlTourBuilder and writer KMZ. This correct?  Thank you for any help you can provide me.  Best regards.  Ramon Wallace.    

I use the template to make a LandXml header but i need to create Cogo Points (CgPoint) There is a way to make this form 3D Vertex point Creator. ?

With String concatenator, can I only concatenate an output for rows where data is null or blank in a different field? Example: I have a field with addresses, only some entries are null or blank. I do have house numbers and street names in their own respective fields for every entry.  I want to concatenate ONLY rows where the full address field is null or blank

We are trying to connect to Microsoft Azure SQL DB in cloud thru our client FME to transfer data.  Is it possible to connect SQL Azure with Encrypt connection option from client FME as available for SQL Server and shown in the attached screenshot.      It's critical to our deliver  can someone in FME support reply ASAP ?  Thanks & Regards  

Hi I Am new to the geopdf translation I would like to have an entire feature table of oracle spatial converted to geopdf with each record as a separate layer on the basis of an attribute .Currently fanning out by the attribute  creates new file

I'm writing out to an old SQL 2000 database, and I get the following error using the MS SQL Non-Spatial writer:  "'TYPE_ID' is not a recognized function name."  I checked the log file and before writing to the database, FME is trying to execute the following query  SELECT name FROM sys.columns WHERE object_id = OBJECT_ID('[TableName]') AND user_type_id = TYPE_ID('int') AND is_identity = 1  When I execute this query I get an error too: SELECT name FROM sys.columns  The error is:  Invalid object name 'sys.columns'.  Is there a problem with writing to such an old SQL database? 

All,  I posted a question here (https://safecommunity.force.com/CommunityAnswers#!/feedtype=SINGLE_QUESTION_DETAIL&dc=FME_Desktop&criteria=OPENQUESTIONS&id=906a0000000d05kAAA)but when I try to view the thread, I can see there is a response, but it is disappearing as soon as the page finishes loading.  I don't know if i'll be able to see responses to this thread, but if there's an answer, please email me at matthew_baker *at* dpsk12 *dot* org.  Thanks!!!

I have this workspace: read LAS ->PointCloudCoercer->RasterDEMGenerator  I also have read into the workspace a raster (ECW)  In the parameters of the RasterDEMGenerator, I have defined the resolution of the output as: Output DEM X Cell Spacing: $(SourceDataset_ECW) Output DEM Y Cell Spacing: $(SourceDataset_ECW)  This fails with the error: RasterDEMGenerator(SurfaceModelFactory): Fail to process the SAMPLE_SPACING clause because it contains an invalid entry or it contains an invalid number of entries.  The ECW file is very much not corrputed, and reads fine in Data Inpector.  How should I be referencing  the properties of an already existing raster with the RasterDEMGenerator?  The overall goal here is of course to output a raster from a point cloud that has the exact resolution of an already existing raster and is also "snapped" to it.