Skip to main content
  • EN

Best Answers

10374 Posts
J
johng
asked in Data
Attributes missing from Output file

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

767
J
L
longhornfan
asked in Data
Excel Reader seems to ignore one particular field

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 

374
L
A
aquamarine
asked in Data
Read files based on list of file names

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,

4199
gio
Contributor
M
mani
asked in Transformers
Stringreplacer

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

606
takashi
Celebrity
T
tomsouthall
asked in Transformers
Merging attributes in an ESRI Shapefile

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.

104
T
C
cpr__47
asked in Transformers
Converting DEM TIFFs into different bands

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!

64
C
zzupljanin
Contributor
zzupljaninContributor
asked in Data
setting default color while reprojecting tiff file

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.  

137
B
B
borone
asked in Transformers
Geoid Height Grid Format Description

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  

591
R
sigtill
Supporter
sigtillSupporter
asked in Integration
FME Server - Arcpy

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

221
david_r
Celebrity
B
bruno_de_lat
asked in Transformers
2D-OGC Validation of 3D planar surfaces

 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

132
B
R
richardh
asked in Transformers
use attribute value as regular expression in stringsearcher

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.

51
takashi
Celebrity
A
aquamarine
asked in Authoring
Oracle Reader Update

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, 

141
david_r
Celebrity
T
tlabs
asked in Data
Folder reader

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  

21
david_r
Celebrity
T
tlabs
asked in Transformers
primaryindex start value

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?    

61
david_r
Celebrity
ben_vanderford
Contributor
ben_vanderfordContributor
asked in Data
How to return the JOB ID in a notification from FME server

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?

223
ben_vanderford
Contributor
J
johng
asked in Data
Oracle Spatial Object and Synonyms

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 

42
J
J
johng
asked in Data
FME Error while converting shapefile

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 

105
gio
Contributor
L
luciole24
asked in Transformers
How to change a polyline with many little lines in a polyline with only lines and arcs

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

336
david_r
Celebrity
R
rvgeneug
asked in Authoring
Parameters ignored for file geodb reader

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

81
T
B
bino
asked in Data
In shape to DGN conversion,how to get all attributes in Level name seperated by underscore

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

51
fmelizard
Safer
tim_bkr
Participant
tim_bkrParticipant
asked in Data
DWG text justification not applied by AutoCAD

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              

461
david_r
Celebrity
graeme
Contributor
graemeContributor
asked in Transformers
SystemCaller not working as expected in FME Server

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.  

451
david_r
Celebrity
B
burbank
asked in Data
Format figures into letters

Hi. I would like to format the an attribute of the a tiler transformer (the column), to be listed in letters  instead of in numbers (e.g. A B C instead of 1 2 3), is this possible? 

01
david_r
Celebrity
M
miladahmad
asked in Transformers
Is it possible to create a " trapezoids" shaped line buffer?

Is it possible to create a " trapezoids" shaped line buffer?

1814
M
R
rvgeneug
asked in Transformers
file copy zip

Hello,  I have following situation: - Master workspace A (including 1 FMEServerJobSubmitter for Workspace B) - Workspace B containing a linked custom transformer  Workspace B generates the actual output (GML). The output location can not be defined by me because of a known issue (decision of Safe). Workspace A moves the data from the default location (based on attribute output_datasets{}.path) to the desired location. When doing this I would also like to zip the GML file. This is possible when the Destination File Copy Directory is like ...\\result.zip Both the actual output name should be set by an attribute like ...\\attributA.zip In order to do that I create attributes filecopy_source_dataset, filecopy_dest_Dataset and filecopy_dest_filename But by doing this, the created zip file is corrupt.It seems that just the extention "zip" is added but the data is not zipped.  Is there a way to move and zip a file and define the zip name based on an attribute?  Thanks, Rob

261
takashi
Celebrity

Badge Winners

Show all badges

Community Stats

31,790
Posts
120,759
Replies
39,405
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.