Data

Hello, i would like to get the cells information on table XLS.For example, i know that has a format attribute in xls reader ( xlsx_row_id ) but i need too the information columm. The image below is G 14, but how can i get it with FME wie a value attribute? Thanks.

Using FME Server together with FME 2013 Entines (Build 13547) I obtain the below error message:2015-11-26 14:41:42| 89.0| 0.0|ERROR |java.lang.Error: Unresolved compilation problem: The constructor IligmlWriter(OutputStream, TransferDescription) is undefinedI have no Idea at all what goes wrong. Any hints?

Hello,  I am pretty new to FME and transforming an ESRI GDB to KMZ for visualization purposes. I have a point file with ~10 different categories and I am using a KMLStyler to set the point's icon conditionally, ie campgrounds get one icon, beaches get another.  I was wanting to use the icons/gme/ icons (example gme/gx_campground icon for campgrounds), but after my workbench runs I  have the message: "KML: Cannot find the referenced icon: `'. Setting the icon href anyways" The expected ouput icon in Google Earth is replaced with a small X. To me it sounds as if FME does not have the icons it thought it did, or is unable to set them for some unknown reason. Does anyone have anyadvice?  Thanks  

Hello I am brand new FME this week and am intrigued by it's non spatial data integration possibilities. I have a variety of csv files to process. I know explicitly how the header of each file is setup so would like to be able to test for certain conditions i.e. 1st two rows blank and (row 3 column 1 = 'Datetime') is Filetype A if successful this will go forward to relevant workspace runner for that filetype so I can do the required processing. Is it possible to test the structure of CSV before determining how to process it? Thanks and kind regards

Hi,  After the translation failed message, I come to know whether source data is not as per the writer i.e. 12kV in source (present as type text) but writer accepts only 12 since it is integer...   Is there a way to check this type errors before, such that I can disable the writer and run the check. I will switch ON the writers when the data is correct.  Pratap

How do I write a shapefile that is larger than 2gb? It has to be possible right?

Hello, I am trying to understand the relationship between the PDFPageFormatter and the PDFStyler. From the output of three "AttributeValueMapper" transformers, I have three text values that I would like to place on a PDF. I have verified their existence in the Inspector viewer. All three values are ready to place, yet I cannot seem to get them to render in the resulting PDF. I am using a standard Arial font, size = 16pt. The PDFPageFormatter has three named objects in the display, let's call them TEXT1, TEXT2 and TEXT3. I was under the impression that as long as you have named objects, the AttributeValueMapper would place the text strings in those locations, based upon the "Destination Attribute"? What am I missing?   OS: Windows 7, 64-bit FME Workbench: 2015.0 (Build 15253 - WIN64)

Usually I would use arcmap to displayXY (to draw the points from the lat/long fields) and then publish to AGOL, Can I do this in FME ?

My workspace consists of conversion of shapefile -->> CityGML. It works quite fine. Now I decided to include some more properties into my model in form of Energy ADE. I decided to use this: http://www.sig3d.org/citygml/2.0/energy/0.5.0/ . After I have included this into my workspace, nothing has happend. Perhaps the reason is, I am pretty new in using ADE. Can you somebody help me with this issue? How to use custom ADE in CityGML?   Thanks a lot in advance.

Hi,   I have an Microsoft Access 2002 database with a number of look up tables and was wondering how I would go about migrating this to Oracle using FME 2015 while keeping the relationships between the main table and the look up tables.  Thanks 

I am working on a (generic) FME Workbenchthat clips and exports data from ArcSDE database into the File Geodatabase (FGDB) format. The SDE features are clipped using an AOI, that arrives in the workbench in the form of an ESRI JSON parameter. The ESRIJSON string / AOI is converted into a FME geometry using a ‘GeometryReplacer’. So far, so good.  AOI = {"rings" :[[[131064.8258, 451340.5549], [131064.8258,454729.4129], [135194.9964, 454729.4129], [135194.9964, 451340.5549], [131064.8258,451340.5549]]],"spatialReference" :{"wkid" : 28992}}  The first thing I notice is that after interpreting the AOI as a FME geometry some floating point differences occur. Which are not really a reason for concern at this point.:  Figure1 - AOI coordinates after interpreting the geometry.  The next step is to clip features from ArcSDE using the AOI. Actually I am also interested in the features outside the project

Kindly need help to extract XYZ for each vertex of linestring (CAD) to a excel file along with the attributes (layer name, first point, end point, color, )

I am using the KML writer to save output as KMZ by specifying Destination KML Dataset as "myoutput.kmz". This works, but I have an icon referenced in the KML output in the Icon->href tag as: images/D2.png  How can I add the images/D2.png folder and file to the output KMZ?  Thanks

So i have been going through tutorials and JSON documents on safe.com and I cannot figure out how to bring out the attributes I need from this for my workbench. I am getting this http call in json format and I want to get this down to working with these attributes  action, custom_1, height, class, MATL_TYPE , F_ID, POLETYPE, F_ROUTE, F_O, F_Y, EMINY, EMINX, DATABASE_NAME, DESIGNATION, objectType  I cannot figure out the procedure to be able to pull these attributes out and their values to work with in my workbench. Any help would be appreciated. The original message is below.  MESSAGE:  {"action":"CreateOrUpdate","instance":{"fields":[{"allowNull":false,"allowUpdate":false,"targetField":"custom_1","value":"5b8e3770-cf35"},{"allowNull":false,"allowUpdate":false,"targetField":"height","v

How to add customer icons in FME KMLstyler?

I'm new to FME Desktop so this may be a basic usage question. We are using Photoshop to process GeoTIFF files. However, since Photoshop is not aware of the spatial metadata in GeoTIFF files, the files it creates are saved as regular TIF files with no georeferencing. Would it be possible to copy the spatial metadata from the original GeoTIFF and apply it to the TIF that Photoshop creates? Thanks -Mark

Hi FME community  Spatial objects in FME that include arcs consist of several segments, each belonging to an arc or a subsequent series of straight lines. When you use the transformer ArcStroker to get rid of the arcs, you still have these separate segements (whereby each of them belongs now to a series of straight lines).  When you write these objects (polygons in my case) into PostGIS, they are automatically stored as "CurvePolygon" which cause problems. It needs a lot of transformers to decompose (donut-)polygons into their individual buildings blocks and to rebuild them.  My question therefore is: Is there a transformer or parameter to set so that the required simplification of the object's data structure after removing arcs happens automatically? If not, it would be desirable that Safe Software introduces this Feature in future Versions of FME. I mean are there any reasons to keep the polylines separated by segments after the

I have a custom format I am trying to write to. It's for consumption into a program called Petrel (used for 3D modelling in the oil and gas industry) and ends with a .ev format. Here is a link to more info on the .ev format: http://petrofaq.org/wiki/How_to_import_completion_event_data_in_Petrel#Well_event_file_format  The challenge: Going from a structured database format to the following schema.  FROM  WELL-1 01/01/2004 perforation 4000 4020 .5 0  WELL-1 01/12/2002 barefoot 3500 .4 -2  WELL-1 01/01/2005 rework 3600 3900 .380.5 WELL-2 01/01/2004 perforation 4000 4020 .5 0  WELL-2 01/12/2002 barefoot 3500 .4 -2  WELL-2 01/01/2005 rework 3600 3900 .380.5  TO:  UNITS FIELD  WELLNAME WELL-1  --DATE EVENT MD1 MD2 Diameter Skin  01/01/2004 pe

 Having a unique constraint on a table is there a way to avoid FME stoping the bulk copy or insert simply ignoring the duplicate values and keep on with the translation, just reporting the warning ?  Or would be there any other alternative to UNIQUE constraints to avoid duplicates entering database without stopping the translation ?  Cheers    

I received dxf coming from Eplan Electrical schema's. Opening the dxf in Microstation shows that Tagsets are available but not working correctly. The batch Conversion tool in Microstation works correct but it is tedious.  With FME level, line, color, text etc mapping are easy, but I can't get the tagsets to behave correctly. The Tags are all in one Tagset instead of linked to their specific Cell.  Ideas/exemples anyone?     

Is there something needed to be done on db side so that FME can read PostgreSQL Materialized views , or this is something not possible to do ? Thanks, Jorge Vidinha

Our workflows creates a MS SQL Spatial database. However we are getting a significant amount of Linestring type entities when we open the same database in Postgis. What are the optimum defaults in the sql spatial writer which could avoid the problem. Are there any other steps we could add to our shape file preparation workflow which could also assist with the issue?

Hello,  I am running FME Cloud and have been receiving a "winmail.dat" file in the email attachments and my feature reader that recognizes the attachments from the publisher is having difficulties with it. I read recently that Server has developed the ability to handle these files and extract the info from them, but I have yet to discover how.   Any help is much appreciated.   

For some reason my FME translation is not recognizing the GlobalID column in my target feature class. I can see the GlobalID column in ArcCatalog and the DBA sees it on the table in SQL Server Studio also. Any suggestions about what could be wrong or missing?  2015-11-02 15:14:15| 12.9| 0.0|ERROR |Column 'GlobalID' of type 'guid' specified in mapping file but not defined in existing table 'DBO.T_TRANSMISSIONSTRUCTURE'   I'm using FME 2015.1.1.0 build 15515 64-bit. This is a new version for me and I was using FME 2013 SP1 previously.

Hi FME community,  I was trying FME SERVER 2015 with a recorded tutorial and I was really impressed by its simplicity and strength. However I would like to go in deep about FME SERVER foundation, maybe some technical literature related to the PUBLICATION-SUBSCRIPTION PARADIGM.  Please could anybody give me suggestions about articles or even better, books about the paradigm FME SERVER use?  Thanks in advance,  Raul