Data

Hi!  How do I change the output format "datetime" in Excel_ADO writer? In the reader the date is on YYYY-MM-DD format but when i'm writing it into Excel_ADO the format changes to YYYYMMDD000000, probably on the format YYMMDDHHMMSS.  How can I get the Excel_ADO writer to print it in the ouput file on YYYY-MM-DD format instead?  Best regards  Christer

Hi all,  Is there a way to set the colour (background or text) of a row in excel based on an attribute value?  I would like to be able to highlight certains rows in the file based on whether they passed or failed validation.

Hi,  I have a geodatabase reader looking at 1 feature class. I have edited that feature class and my workbench is not picking up the changes. I have: Updated the reader feature types Removed the reader and added it again Moved the reader to a new gdb and added it again Deleted the temporary files in the c drive  It is as if FME is looking at the previous data that no longer exists?

i have an esri geodatabase with a point feature class with an attribute A This attribute A has about 50 different contents (like A1,A2,A3,A4,....) Each content has its own symbology. Now I want to convert them into dwg and each content should get a different autocad_block. How can I do that in FME? (because in the DWG Styler I can choose only 1 BLOCK) I need about 50!!!  Greetz and Thanx FRanco    

Hello,  When using the Generic Reader and running a CSV file through it, is it possible to specify the CSV parameters somewhere. In the Log file when I run it as is I see:  Opening the GENERIC Reader on dataset `C:\\Temp\\Northgate_Edgbaston.csv' CSV Reader: Opening CSV files in directory `C:\\Temp/\\' CSV Reader: Separator Character: ',' CSV Reader: Skip Duplicate Delimiters: no CSV Reader: Strip Quotes From Fields: no CSV Reader: File Has Field Names: no CSV Reader: Field Names Follow Header: no CSV Reader: Number of Lines to Skip: 0 CSV Reader: Number of Footer Lines to Skip: 0 CSV Reader: Encoding name '' CSV Reader: Allowing Spaces in Column Names: no CSV Reader: Max features to scan for schema: 10000 CSV Reader: Opening dataset 'C:\\Temp\\Northgate_Edgbaston.csv'  But I'd like to be able to set these parameters so that I can specify that the CSV file has field names and to strip quotes from fields.  Thank you,  Peter.

Hello,  (i'm running Fme2014 sp1 - and looking for an answer within this release)  I'm posting data via http to a remote service api that requires a multipart stream consisting of a image (photo) and 4 parameters (metadata against the photo, description,title etc)  the problem I have is that the receiving service checks the file type to ensure it's of a type begining with 'image/*' (where * could be any of the image types), however for some reason the httpmultipartuploader is passing the image as 'application/octet-stream'.  Is there any way to force the transformer to use a different type?  or failing that can any one suggest another method of acheiving the same thing?  thanks for any help in advance....  Nick

Hello,  I have a csv file with columns as ID, NAME. I want to use ID to query Oracle table and create a shape file from that result.  Currently I am using CSV reader to read csv then querying database using FeatureReader (in where clause CODE=@value(ID)) and writing to shape file. My problem is I am not able to get attributes in shapefile.  How can I export attributes as well of selected features.  Cheers

Hi, I wonder if you can help me, I have a NetCDF file containing daily rainfall data (given in julian days, i.e. 1 = 1st January, 32 = 1st Feburary, 60 = 1st March [not a leap year]). I am trying to aggregate these values by month and output them as ASCII files, I was thinking of just using a simple lookup table to convert the julian day to month, but am struggling to figure out how NetCDFs are read into FME and how I would go about this and also outputing the result as an ASCII grid. Best wishes, Ed

I have a number of lidar files in LAS format that I want to convert to one compressed LAZ file. I can read the LAS files with one reader, but when I use the ASPRS Lidar Data Exchange writer to write, it writes multiple LAZ files. This is true even if I set the Compress Files parameter to Yes. How can I get just one LAZ file?  Thanks

Hi ,  I have a featureclass stored in a SDE Geodatabase. How would I go about witing a txt file with one column containing the features geometry in Oracel (MYSYS.SDO_GEOMETRY) format?   I assumed I would use Geometry Extractor, but there doesn't seem to be an oracle geomtery encoder included?  Would I need to write the feature to another Oracle Spatial database then extract the information from that?  Many THanks  Bkicker22

Is there any way to determine the width (in coordinate units) of AutoCAD multiline text output?  I need to offset the text to the left for callout tags where the leader line leans to the left of the item they are describing (subtract width amount from x coordinate) - but I have yet to figure a way to extract the "rendered" width of the longest line to do so.

Hi FME-ers,  With Desktop 2013, is anyone familiar with a workflow I can use within FME to populate two attribute fields (in a stormwater pipes layer), with corresponding IDs from a connected stormwater pits layer which is snapped to the start and end of each pipe.  The pipe layer is digitised in direction of flow so I would be looking to populate the corresponding upstream and downstream pit attributes to reflect this.  Note: ESRI used to have a VB Script which did this but it is no longer supported in 10.1.  thanks!!!

I am running a workflow using various transformers on data (eg. BulkAttributeRenamer, AttributeCreator etc) is there a smart way to retain the feature data types through to the writer?  When connecting the writer, I copy attibutes from the previous transformer and it lists all columns as "text" "200". I do not want to have to manually change the type in User Attributes.  Cheers!

HI All,   How to send an output from a workspace to fmeserverjobsubmitter.   For Instance I am having a workspace which checks if a field exists in a feature class if not then notify the user.   If I publish this workspace in the server and use it using fmeserverjobsubmitter how can I access the output   How can I achieve this ?   Thanks

As I have to run the same script for many shapefiles I wonder if there is a way/transformer to name the newly generated output shapefiles (dynamic) automatically the same way as the input shapefiles. I am new to FME and appreciate an answer which I can follow easily..  Thanks a lot!

Can anybody explain the workaround for when FME runs but reads the previous Writer that was there.  Explained: I have .MIF files that I download from a GPS and input into FME every week.  FME is reading my last weeks file count when it should be reading the new file?  Even when I erase and re-add the new writer, it still reads my old ?  The features have the same name but I thought FME should recongnize it is a new Writer (because I erase all files in FME and re-add NEW) and thus have different feature counts.  Is their a CACHE somewhere in the workspace where I can empty to solve this issue? 

Hi,  Is there a way to compare schema between ArcSDE Feature Class and File Geodatabase Feature Class . Schema(Any format) works for file geodatabase feature classes but not for ArcSDE Feature Class . Can anyone tell me if there is a FME approach for this ?  Thanks and Happy Christmas to all

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