Data

Is it possible to write transparent 3D objects to PDF?  I'm trying to create a transparent 3D water level on a 3D surface map, and am using the PDFStyler to give the water level a Fill Opacity of 0.4.  However, when it is written to the PDF, the water is a solid colour with no transparency at all. When I try to output the same thing to a 2D Geospatial PDF, the transparency works correctly.  Is this a limitation of FME's 3D PDF writer, or is there a way to do it?  Thanks

I am using the Esri Geodatabase (ArcSDE Geodb) writer and unlike the Oracle writer, there is no Writer Mode dropdown so I can select DELETE. How do I delete records from a geodatabase?Thanks

how to move microstation cell to desired leve

Hello!Is it possible to set only once the vertical text alignment (and put the fields in bold at the same time) for all the fields in my writer for an Excel file?If I have 20 fields, I would like to be able to do it only one time. I don't want to use a template each time.Thanks!

Hello everyone, I have an excel spreadsheet shows run, pull out and pick up and so on. There is one pull out and many pick up rows for each run. I want to keep only two records of each run; Pull out and the very first pick up. Is there any way to trim not required data? Here is the screenshot of spreadsheet:Thank you.Goraya

I've got a longer workflow which downloads and processes data triggered by change in a webservice. As of now FME Server runs automatically and creates an FGDB-ouput. Since I've also got a map series in ArcMap which I use to produce PDF-maps based on the data created by FME, I'd like to automate the whole workflow.Is there any best practice on how I can trigger this through FME?

Hello FME experts,Is there a way to read an Excel table containing file paths (100's of them) and load the data into a workbench?I would like to open the MapInfo TAB files to know the projection parameters and list them in the spreadsheet.Any help would be greatly appreciated.Thanks, Thiru

I am in the process of developing a java based reader/writer for a custom data format. That data format is a single file containing records of different data types. I have implemented the readSchema() method in the reader and the information is also retrieved by FME when the reader is added. However, only one feature type (the last type reported by readSchema()) is added to the list of feature types and the workspace. When the feature types are extracted by adding a new writer with the option "Extract from dataset...", all feature types are successfully extracted and added to the workspace.Is there anything special that is needed in either the code or the metafile to enable that functionality for the reader? I can see from the spatialite reader, that it is possible after all but currently i have no idea what controls that behavior.

I was loading a set of LAS files to process through the RASTERDEMGENERATOR transformer and kept receiving an error which would stop my workbench "Either all points are linear or initial set of points did not consist of 3 non NAN elevations". After scouring the log file I noticed some of the las files being read contained no points. Once I manually identified those las files the processing went on with out a hitch. My question is how can I test incoming LAS files so they will filter out files with no points in them?

I have a folder that contains all the excel files I need to parse. I need a way to combine all the workbook files and work sheets and parse the data into a new workbook in a table format. Can FME do this?

Habe eine Geländemodell im ArcGrid Format von "http://viewer.nationalmap.gov/basic/#productGroupSearch" heruntergeladen und möchte das jetzt in ein GeoTiff umwandeln

Hi,I have used FME 2015 to transfer data from shape, mapinfo file, etc. to postgis and everything was correct.. Now with FME 2016 nothing is correct.. In Postgis I get the type of geometry (geom (geometry)).. But i want to have it like before geom (point), or geom (Linestring), etc. Is-that possible?Thanks

I'm looking for the best combination of server and data provider for a geodatabase...and recommendations of open source options?

Hey there. Some weeks ago got an idea to remake my hometown in Minecraft. First I did so by hand, but I quickly figured out that it took too long and it would probably not be so precise.Then I looked around the internet and I found out about .dem and GeoTiff and how to make these into a 8 bit greyscale map, and making this into a Minecraft world. But after a while I figured out that it wasn't precise enough either. Then after some more thinkering I got the idea "What if one could take a GeoTiff or a .dem file and directly make it into a Minecraft world?".I googled about it, and then I found that there were someone who already had the same idea that I had, and made it possible!Now this is where I am stuck. The guide How to make Minecraft worlds uses a .Tiff file, which doesn't seem to work with my .GeoTiff/.dem files. I don't got e

Hi,I want to convert microstation v7 design file to shape file using FME. I have feature in levels, there are two features in level 7 have different styles. I want to extract them in two different shape file. One feature is in lv=7, style=0, wt=1 and color=0 and another feature in lv=7, style=2, weight=2 and color = 1.I want first one with style= 0 to stream_dry and another one style=2 to stream_perennial.Is it possible to convert both to single shape that is stream and they can be differentiate in their attribute of Type=dry/perennial.Please help me.Thanks Sachin

I am attempting to connect to a team site using the SharePoint reader(Microsoft SharePoint List) in FME desktop.2016 from a Win server 2008 using the Python27 library. I enter the team site URL followed by user name and password and select the NTLM connection. On click the button besides 'Lists', FME crashes with no errors or dump file creation. I confirm that my account has the right privileges to access & open the xls file on the teamsite. One thing to note is that I don't have a complete installation of MS Office on the windows server machine. I am not sure if this is related though. Any clue what might be wrong?

Hi,I have many cells features in design file like hut_p, hut_t, hut_op, tank_p, tank_d etc. hut features are in level 1 and tank features in level 3. I want to convert them to shape file in two types of shape: hut and tank. I have done the same but my problem is that I want a field "type" in attribute of hut and in type field value i want value of feature, let me explain ::: for hut_p output for "type" value should be "permanent", for hut_t value should be "temporary".similarly in the case of tank there will be one field in attribute table "type" which will have values : for tank_p value should be "perennial" and for tank_d value should be "dry".Can anyone help me.Regards

Hi, I am trying to solve an issue, where there is a not null column, and the required input is generated by the database.Normally, this would be achieved with something like the similar:INSERT INTO TEST_TABLE(NAME, FUNCTIONAL_ID) VALUES ("STEVE", schemaname.getFucntionalID());I have achieved this in the workbench using the SQL EXECUTOR by populating a variable and passing that along the workflow, however, this is not efficient when thousands of records are required to be pulled across.Is there some way in FME, to specify this function call, so that it is handled by the database, and FME is not waiting for a response back.Just to give you an idea, a file that previously took about 15-20 seconds, is now taking 12 minutes using SQL Executor.Many Thanks,Steve

I would like to extract the geometry from b.xml, but i can't find the right reader.

In order to keep correct informations about labels in MapInfo WOR files, is it possible to keep blank lines in MapInfo Tab file after tranformation?The problem is that WOR files keep coordinates of labels who have been placed manually.Layer 4  Display Global  Global Pen (25,2,16711680) Brush (1,16777215,16777215) Symbol (35,0,12) Line (1,2,0) Font ("Arial",0,9,0)  Label Line None Position Center Auto Retry On Font ("Arial",257,8,16711680,16777215) Pen (1,2,0)   With NUM  Parallel On Auto Off Overlap Off Duplicates On PartialSegments On Offset 2  Visibility On AutoPosition On AutoSizes 4 AutoSizeStep 25 SuppressIfNoFit Off AutoCallout Off  Object 299 Anchor (526735.90947750001,192384.23560000001)   Object 21 Anchor (526975.95545250003,192220.68780000001)   Object 16 Anchor (526949.57676249999,192204.86060000001)   Object 52 Anchor (526916.60343250004,192

Hello everyone,I am new to working with Data beyond the basics, and have recently been placed in a position to start learning new ways to simplify workflow, and was pointed to the FME system to see what it can do. What I need is to populate an existing (empty rows) SQL database with data given by a client concerning their property assets in an .xlsx Excel spreadsheet, while being able to query and change the formatting of certain columns during the 'translation' process, instead of manually trying the built in import tool in SQL Server and then using a separate script file to individually query the desired column data.For example, I need the data in the AcquisitionMethod column from the spreadsheet copied to the SQL DB under acquisition_method while being queried by the script below, while other Columns need no scripting, just copying, and this all at once, if possible;case when [AcquisitionMethod] = 'Donation' then 'DONATION' when [Acqui

Hello,I have a problem to generate a unique ObjectId in Oracle. This is a Number.I want to copy data from a shape to Oracle. No problem for the data, but Oracle requires a Unique ObjectId. I can generate this once with a Counter, but I want to run the workbench daily with different shapes. So if I use the counter and let it start at 10, the next day it will also start with 10 and then Oracle doesn't accept te data because the ObjectId isn't unique.How can I let FME generate a Unique ObjectID each transformation?Thank you, Marlies

Hello!I use spatialfilter to know if 2 layers match each other. I would like to be informed if they match or not and export the result in a text file such as: "6 entities of layer A doesn't match layer B".I guess it's possible to do this with FME by including a SQL query but I don't know wich transformer or structur I should use?Thanks for helping meHugo

I have had some great success using the KML "Generate Super Overlays" to create tiles of imagery that can be easily viewed using Google Earth.  Now I would like to go the next step and show my DEM information textured with the imagery also in KML using Google Earth. I can certainly generate a KML file with the DEM data textured with the imagery as a 3D model that Google Earth can view. The problem of course is that I need to keep my files small (~1MB) so Google Earth can open them. And my DEM data is just as detailed as my imagery.  I figure the solution must be similar to what the "Generate Super Overlays" does now.  So the question is: How can I generate tiled 3D models and KMLs at various resolutions that will mimic the behavior and file setup of the "Generate Super Overlays"? What transformers should I be playing with to get this behavior?  Thanks for any help you can give. 

From Spring 2016 OS will be upgrading OS MasterMap Topography Layer data to the version 9 schema: https://www.ordnancesurvey.co.uk/business-and-gove...Will this have any impact on the OS (GB) MasterMap Reader in FME?