Data

This question is related to the last question I asked regarding the date and time seperation issue- https://safecommunity.force.com/CommunityAnswers?id=906a0000000d6Yi  Now, I have a column Date in my table which is having different dates, and the number of datasets in large amount. I just want, if the user runs the WB from 'Prompt and Run Translation', he can select valid dates from the respective  input colum. Suppose there are dates from 1/1/2014 to 1/2/2014 (DMY), he should be able to selelct from and to dates according to his needs and the output should show only those section of dates and other related columns also.   Please feel free to ask questions if i am unable to explain !!!

Hi. I’m having some problems with the 3D-bufferer. When I run the 3D-bufferer on some of my data sets I get the log error shown below.   The data sets consist of 2D lines created from coordinates through the vertex creator (the 2nd picture shows an example from the inspector). Some data sets work with the 3D-bufferer but many don’t. Any ideas what input could be causing these issues? Is it limited by a large number of features?  3DBufferer error message   2D Lines before 3DBufferer   Workspace with coordinate vertex creator in red box.

Hi All, I look for a method that can add a blank line between field names and data into CSV Writer. Any idea?  Thanks an advance. FarFar

Hello to all,  I am trying to use a 'generic' reader because I want an input for a workspace to be either an ESRI shapefile or a file geodatabase. I am supposing this is the best reader type to use for this purpose.  When using the generic reader, features are read from the input destination but upon inspection it seems that the imported features have no attributes. A message is displayed in the Data Inspector table view: 'Empty Table - No Schema Available'.  I can't seem to find a case like this on the FME community forum, is there anyone who can help me finding out how I can import attributes together with geometry with the generic reader? Or is this impossible (which would not make much sense to me) ? I can't seem to figure it out by myself.  I am using FME 2014 SP4  Thanks in advance for any help ;)

Hi,  Are there controls for the spacing of each character when using a process which involves labeller and text stroker? For example I have a string "CA" , I would like to be able to set the distance between each character e.g 1.5m or 1m distance.  Thanks.

I am running FME 2014 SP4 and am having trouble when transforming data between Oracle Spatial Object to MapInfo TAB file. The transformation is very easy: I am simply stripping out a few attributes from a parcel dataset and then writing to TAB file. When I compare the output TAB file to the original data there is quite a bit of offset. It seems that almost every parcel has at least one vertex added or removed that changes the shape. It seems that coincident boundaries are preserved.  My original thought was that there was a problem with the Arcs in the data so I introduced the "ArcStroker" transformer and no matter what the settings, the data comes out looking similar. There are large gaps and slivers(>4 feet(1+ meter)) being taken away or added to many parcels.  I need the data to be accurate as it will be used to digitize other features based on property lines. I work for a large metropolitan city of more than a million people so if the data is not accurate then this cou

Hello!  My goal is to enable a FME user to select certain trajectories of waterways, on basis of attribute values, prior to executing the Workspace for the selected trajectories.  I accomplished to define a User Parameter that has as type "Choice (Multiple)". By importing the input file I could also select all the (unique) attribute values to take them into account as a valid choice.  Using a Tester I make a simple Test Clause to select the trajectory by setting it equal to the User Parameter.   If I now select a single trajectory, the Workspace is successfully executed. If I however select multiple trajectories as User Parameter, no trajectories will pass the Test Clause and the FME Workspace will not be executed accordingly.  My guess is that the User Parameter stores the trajectories as a list, and that the Test Clause for some reason is not selecting the trajectories individually but attempts to find trajectories equal to the the list of trajectories.   Does anyone have a

Hi all,  I would like to write a CityGML file which only contains buildings. Hoewever, I need to write for each building their walls and roofs. I know how to use the CiytGML writer to write lod0Footprint or Lod1Solid, but not how to create objects with higher semantic information. Do you have any hints?  Best regards

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

Hi there,  I'm trying to create a pdf file to visually represent some basic shape files I have. Using the Adobe geospatial PDF writer, everything seems to be fine. Until you zoom in a bit, then you see this:    The red lines are some simple boudary polygons, that aren't normally as spikey and those green "pie charts?" are roads, standard roads. These exact layers display perfectly fine in ArcMap, so I'm very confused as to where these strange geometrical anomalies come from. At this point I'm not even using any transformers, so it's a basic reader to writer translation. Any tips on what I might need to fix this, or even a suggestion on an alternative output format that's good for display purposes?  Kind Regards,

Hi, I am working on Win7 Machine with 8Gb RAM. While creating an XML from a shapefile, comments are being generated automatically which I want to remove. Tried XMLFormatter and StringReplacer, but didn't get the desired output. Can someone help me with that (: (The rows inside the box are automaticallygenerated and should be removed) 

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,

Hello, I would like to do a jp2000 file with a tif. My conditions : 1- the tif is black on white so i want my jp2 black on white 2- the siz of the jp2 must be less than the tif  Using rasterpalletremover my jp2 is 500Ko big but i need to specify nodata=0 in Qgis to see it in black on white instead of white on black.. See joined files (fil and jp2 500 Ko). I test many ways like rasterpaletteresolver and the viewing is ok but the files is three times bigger!!!(2.9Mo).  If anyone can help me  thanks,  dowload my file here : https://drive.google.com/file/d/0B90n7rx5ph0ZMXFUUUtvbVplUXM/view?usp=sharing  PS : si vous parlez français dites le moi!!

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.  

I know you can incorporate FTP in a Esri Shape reader to pull a zipped shapefile but was wondering if you could do this for a zipped esri geodatabase?

Hi,  I have a need to change some text so it is in the form of a polygon. I was looking at some functions with labellers and wondered if they can be output in a shapefile for example and be in polygonal form.   I have seen a function MapTextLabeller which seems to output polygonal text, but its a paid plugin. Are there alternative methods?  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  

Hi. I want to create an attribute whose value is the sum of the three following values an existing attribute (Code in the picture). How do I write this formula in FME, specifying the value cells? I would rather not do this in excel as I would have to transform to xlsx and back.   

Hi,   I have a file geodatabase that i need to update weekly with a CAD file. How i can set up the update on the file geodatabase? I am using Esri Geodatabase (File Geodb ArcObjects)  Thank you,   David

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 

How to create DEM from ERDAS IMAGINE(*.img) raster?