Best Answers

I'm converting our Intergraph GeoMedia (SQL Server) data to Esri ArcGIS (SDE Geodatabase on SQL Server).  I've got a workbench created for translating various GeoMedia text feature classes into Esri annotation feature classes.  After a lot of sweat and blood, I have all of the issues with text size and formatting resolved, except for one.  Translated single line text appears to be a near perfect match to the position, size, formattting of the original text.  Multiline text matches the size and formatting, but the position is off.  If a feature with two lines of text is stored in GeoMedia with center/center justification, the origin is the middle of the overall bounding box of the whole text feature (or between the two lines of text).  When FME writes this into my Esri annotation feature class, the center/center point of the first line of Esri annotation text lines up with the coordinates of the origin of the GeoMedia text feature.  I've set the geodb_h_align and geodb_v_ali

Hi there,  I have a number of 3D points representing the bounds of an object, and would like to create a boundary representation of that object as a multisurface or equivalent (i.e. not linear), but I can't find any easy way of doing this in FME.  Tried the HullAccumulator which works for convex hulls but produces a garbage output, but for concave only returns a 2D representation.  Any ideas?  Dan

This has me stumped. I thought I had resolved this last week (I posted this in another question and thought it was resolved). The solution I thought would work was me clicking the buttons in Excel regarding Read Formulas and Read Hyperlinks. That doesn't work. I can't post the actual Excel file itself because it has information not allowed outside the company. But I've reviewed the field over and over and over again ... and there is nothing wrong with the field. For example, there are no hyperlinks or formulas in the field. The GIS ID is actually a text field because some GIS ID's have a letter in them. Like you might have 08786651 or you could have 08786677a01, 08786677a02, 08786677a03 for example. I'm attaching an image of the Reader parameters this time so you can see that the Reader does show column CF (GIS ID) in the Preview pane. But you can clearly see that a blank field is present for CF directly under CE (Lease Grid#) in the Attributes pane. Like it's t

Hello, I am converting shape files to variuos formats. Input shape file has been created by non-ESRI tool. When the shape file contains NULL attribute values for all features; that particular attribute is not in target format.  e.g. Shape file with attributes ID, NAME, URL, REMARKS with URL and REMARKS for all features is NULL. In this case output format there are only 2 attributes ID and NAME rest two are missing from output file.  I also observed that in "User Attributes" tab in "Feature Type Properties" dialog of a shape reader, I am not able to see these attributes i.e. in ablove case REMARKS and URL.  Is this behavior as expected? How can force FME to write out all attributes even if it's NULL.  Cheers, John

There's no rhyme or reason to this issue. No matter where I move a certain field in my Excel file (I've moved the row to the beginning, middle, and end) the Excel Reader simply ignores it. When you click Parameters on the Add Reader dialog ... You can see the field listed in the Preview pane under Parameters. But it is not present in the Attributes pane under Parameters. When I say OK on the Parameters and then OK on the Reader it adds the Reader to my FME job but the field is missing. Even when I expose the attribute it shows up as null in an Inpsector.  Has anyone encountered this? Any ideas on how to get it to recognize the field or why it doesn't recognize it?  FYI: I've even put in the range of the data in the Parameters and it still doesn't pick up the field. For example:  Field Names Row: 3 Cell Range (e.g. B2:G9): A4:CF16430 

Hi,   I have a list of filenames that are located within a specific directory.  The list of filenames is generated within the FME workbench.  What is the best way to get the Reader to read in only the files within the larger directory?  Note: the files that I want to read in are within a number of sub-directories, which I don't know what they are. I only know the root directory.  Thanks,

Hi all,  I have a column containing the coordinates information such as: 54960000.0 643600000.63 0.0 ....  I am wondering to know if there is any way to extract the first four integers for the X and Y values. At the end, I need to have the value like "5496,6436"  One possibility is for example using attributesplitter. But Is it also possible to use stringreplacer doing it only in one step?  Thank you, Mani

Hello,  I am new to FME and am having trouble performing a basic merge of attributes from a esri shapefile with multiple line attributes. I simply want to merge them all into one. The LineJoiner (I have successfully used this before) seemed to partially work but only in trimming 62 features into 33. I have tried fiddling with FeatureMerger, Aggregator but can't seem to get these to work either. All the attributes have the same common attribute (ID No.) but trying to group on this field doesn't work either. Some of the lines do not join with one another so this could be the source of the issue. I could easily perform this task in ArcGIS but wish to avoid having to switch between programmes.  Any help would be much appreciated.  Tom.

Hi There,  I am trying to merge two DEMs which are currently in TIFF format in different bands (one 64bit the other 32). When I convert them to both be 64bit and attempt to mosaic them, I get an error as follows...  " The band nodata value '-3.4028230607371e+038' of the selected band '1:0' does not match the band nodata value '-3.4028230607371' of the corresponding band in the mosaicked raster"  I've tried using a RasterBandNoDataSetter to ensure that noData cells match but the does not seem to resolve the issue.  Any suggestions would be much appreciated!

Hi,  when I reproject a tiff file it sets as black those areas that incure due to rotation of original file. Is there a way to set them in other color. Of course, using raster cell replacer you can. But that will change all black colors in photo which I'd like to preserve since they were there in original file.  

Hi, I would like to add a local geoid height grid to FME. I''m able to create such GDC file. But how is the GRD file format description? I found the file "..\\FME2013\\Reproject\\GridData\\WW15MGH.GRD". Is is possible to create these file formats with FME?  best regards Borone  

What is the minimum needed files to be able to run Arcpy on FME Server. It should be possible to only copy the related python-files and libraries and not the complete ESRI-stack. Also after looking at this: http://fmepedia.safe.com/articles/How_To/Choosing-a-different-Python-Interpreter-installation  it would be very nice to define the python-interpretor in the workspace ithself ie: FME_SERVER_PYTHON = c:\\ARcGISpython\\ to make it ieaser to move between python interpretors and from desktop to server

 Hi all. I'm a bit stuck with this one. However I know it must be possible. I would like to validate 3D planar surfaces of 3D Buildings. (So buildings with a ground surface, walls and roofs). I can assume that all the surfaces are planar (That is something I could already check with the PlanarityFilter), but I also want to know if each individual planar surface is OGC valid.(self-intersecting,...)  My first idea was to use the GeometryValidator directly for that but it seems to work only for 2D surfaces. (For instance a wall surface which is perfectly vertical (polygon) would become a selfintersecting polygon if seen from on top on a XY plane surface. So I get an error for that one while it is no error)  How can I check the 3D planar surfaces with 2D validation rules?   I had an idea of changing the XYZ coordinate axis: To turn around in 3D my XYZ-axis as such that my planar surface would have Z =0 for all vertices. I know it must be possible (http://www.geonovum.nl/sites/default/f

I think this should be easy but cannot work out how to use an attribute value as the regular expression in the string searcher transformer.

Hi, I have a number of FME workbenches set up that read from a particular table in Oracle.  This table is subject to regular changes such as adding/deleting/changing field names.   Instead of constantly deleting and then re-adding the Reader in FME, is there a way to simply refresh the Reader so that it now reads the updated Table?  Thanks, 

I have a "master" folder which contains 50 sub folders, all of the 50 subfolders contain a shapefile with the same name (this is just the way trimble exports their data).  I want to be able to write all 50 shapefiles into one SQL feature class by somehow reading the master folder?  is this possible  

I have a simple process where I write out a .shp to an SQL database and I would like the Default Primaryindex column to start @ 1000 rather then the default of 1.  is this possible?    

I would like to know how to get the JOB ID included in a notification I get from FME Server. With lots of job's running each  night and I need the job id when I get notified of a failed run. Can someone point me in the right direction?

Hello,  I am trying to view Oracle Spatial data in FME Data Inspector. I need to view spatial data from a synonym but when try to retrieve table list I am getting only tables not the synonyms.  Is this expected behaviour of FME? Is there any way around to view data from synonym?  Cheers, John 

Hello, While converting shapefile to any format I am getting an error "IFMELine was given an index beyond its current range.". So I guess this must be to do with shapefile but I can open shape file in Data inspector. Could somebody please point out what is causing this error?  Any resolution?  Cheers, John   Cheers, John 

Hi,  I have a polyline that I have reprojected in a new coordinate system. Before it was lines and arcs but after the transformation the arcs are many little lines. Is it possible to transform back this little lines in arcs?  Thanks

Hi,  My workspace reads 2 file geodatabases containing both several feature classes. 10 parameters (5 for each file geodb) are set by the user (or other workspace): - min/max XY (4) - max features to read (1) All file geodb parameters are linked to the correct published parameter. When running the workspace all parameters are ignored and all data is read.  Even removing the published parameters and setting the reader parameters manually does not solve the problem. Even manually setting the parameter "max features to read" to "0" results in reading the complete dataset.  Workspaces are created in FME2014 SP3 (build 14391 - WIN64)  Any insights on this issue?  Kind regards, Rob

In shape to DGN conversion,how to get all attributes in Level name seperated by underscore(_)

Hello, I'm converting ArcGIS geodatabase annotations to text within a block using a dwg model. Everything works ok except that AutoCAD (several versions 2010-2015) does not apply the text justification. The text property is recognized by AutoCAD but for some reason, it is not graphically applied as you can see in the image below.   When I click that Justification dropdown and reselect the same choice (middle-center), then the text aligns in the center of the triangle.  What needs to be done in FME for the justification to be taken into account by ACAD ? I'm using script. Here is the reader/writer snippet: MULTI_READER $(_SDE3UserName).MOB_SL_GROUPEFEUXA              \\     geodb_text_string            %text_value                                                  \\     ANGLE                        %angle_value                                                  \\     ANNOTATIONCLASSID            %ref_name                                          DWG MOB_SL_GroupeFeux              

Hello,  I have a simple workbench script that uses a SystemCaller to run a batch file, then checks for success/failure.  It runs fine through workbench when logged in using the FME server user, but not when published and run through FME Server.  In FME Server the job looks like it completes successfully (return code 0, no warnings/failures), but it doesn't actually execute the instructions of the batch file.  Since there is no error message in the log, there's not much to go on for diagnosing the problem.  It isn't due to a path problem because the caller fails if I give it a bogus filename.