Data

Hi,I have a DWG file containing wells, trees, mast etc. They are symbolized using points but my users would like if it would be possible to use symbols instead of points. How can I do that? Thanks! Christian

There is a way to write in a attribute an excel formula?  For example to write =MEAN($C$2:C@Value(_result)), where result is another attribute.  I tried with text, varchar attribute types when writing but didnt work.

I am using Workspace runner to clip several shape files. I have created a Published parameter (Filename (Output) - ESRI_SHAPE. The ESRI shape writer that i am using is using a destination folder and I would like to change to Destination ESRI shape file.

I recently got a new cut of mastermap and converted it easily from the .gz files to the various .tab files (topo line, topo area etc). I was really pleased at how easy this was to achieve as the 'generate workspace' built the whole workspace for me.  This week I got my first COU disk but cannot work out how to apply this update to my current .tab files. At first I tried just running the conversion to my current files as the output but this just overwrote the files. (glad i took a backup)  Are there some settings you need to tweek to append the files rather than overwrite? or do you need to process the data after it has been converted from gz to tab (although I assumed that the gz files contained invisible instructions that explains what to add and what to delete)?  Can anyone help me with this please because I assume it must be possible using FME. I have been playing around with different transformers (such as ChangeDetector) but am having no luck

Hi All,I need to make a conversion from autocad to microstation. Where the layer names need to be changed. And the autocad-blocks need to convert into cells from a cell lib.any ideas?

Hi folks,  I want to create data replication, using ArcGIS Server's Geodata Service, in FME. and then I want  to schedule the FME Workbench using Windows Task scheduler. Is it possible to do that in FME? or I have to go back and use ArcGIS Tools box(Geodatabase Relication) itself.  Regards, Ravindra Singh

I have my own ArcGIS Server GeoCode Service web service available and was seeing how do I use it with FME? I'm accessing a table thru ODBC which has addresses and turning it into a shapefile. Thanks!

Does anyone know how to filter or trim the black "edging" from the surrounding of an ecw once it has been reprojected? Once the image has slightly rotated due to the reprojection process there is a black edge/border partially created, looks horrid..  Regards, Tony Jordan Mount Barker Council South Australia

Hi All,  I tried to sort fields “F1 & F2” of file geodatabase “T1” and each field has a default value, the fields are sorted “F2 then F1” but the default values are not preserved in the result file geodatabase “T2”.       What might be the issue here?   Best, Lubna 

Dear All, I am new to FME and have little experience but I am stuck on the below and hoping somebody will be able to point me in the right direction.Firstly, I have about 14 geo-database datasets that I am running through a clipper (for a particular boundary) and a number of other transformers before writing into an XLS. I want to find out which datasets apply to my area and produce a spreadsheet with multiple tabs, one for each dataset. Secondly I want to know how to select only certain attributes from the applicable layer in the geo-database.I would be greatful for any help offered.Thank you

I am trying to open DXF format file in FME Desktop. But it throws error. I want to open DXF formate file in FME and migrate data into Smalworld.Error Log:"Creating reader for format: Autodesk AutoCAD DWG/DXFTrying to find a DYNAMIC plugin for reader named `ACAD'Loaded module 'ACAD' from file 'C:\\apps\\FME\\plugins/ACAD.dll'FME API version of module 'ACAD' matches current internal version (3.7 20150407)SOURCE_ACAD Reader: Using rich geometry.AutoCAD Reader: Error opening file 'C:/FME WORK/Ganesh/tekirda? s?n?rlar?/tekirda? s?n?rlar?.dxf' during version checkA fatal error has occurred. Check the logfile above for details".Is there any separate dxf specifications open in FME.

Hi All,Present I know only how to configure FME workbench. I want to learn FME full-fledged any one helps me to learn complete FME. I am unable to find correct source for FME materials and Sites.

Hello,I faced with a problem while working with one workspace that I published on FME Server. Job aim is to accept mails with xml files and process them with extraction particular data and putting this data to a database (in my case Oracle). Everything works fine except that after some time job execution begin slow down, miss emails and even stops until you restart FME Server Database and FMEServer. I began to monitor Event logs and found that problems begin estimately after this event "LOG: automatic vacuum of table "fmeserver.public.fme_jobs": could not (re)acquire exclusive lock for truncate scan". If this could be a reason, is it possible to fix this issue? Thanks!

Hi I have the following datasets for an area1. DTM (Digital Terrain Model) 2. DSM (Digital Surface Model) 3. Building footprints Using the DTM and DSM, I would like to find 1) the maximum height of a building footprint2) the areas of all parts of a building footprint which are at different heights (this would give me the area for each floor)Any suggestions? Can this be achieved using FME?

I'm creating KML folders by using KML IDs approch (kml_parent and kml_id). The folders name are in French, so I would like to use characters like : é, è, à... but it doesn't work. I can change the folder name directly in the KML file but I would like to do it directly in FME. Is there a way to do this directly in FME?

Hi everyone, i have two raster files (.GRC, .GRD formats). I need to export these files to Oracle as BLOB. Can anyone please explain how to do this. Thanks in advance.

I ahve two formates of data text(.txt) and (Excel(.xlsx) The data is in bellow form.I want to insert this data into smallworld by using FME. The data Formate as bellow in .Txt and Excels.

Does anyone know if it possible to get fme to write out tab files as .TAB rather than .tab

When filtering CityGML dataset (with AttributeFilter) the Inspector shows different results than Writer outputs. Why?I have cityGML with a lot of buildings, but based on their id I need to filter few of them out. I use AttributeFilter and when I check result in Inspector everything looks like I want it to look, but when I write the output it has lost all geometry and is completely different.

Dear community,I have a hypothesis which states that using the csv module and Python 2.7 to perform a simple processing task using the data stored into a big *.csv is going to have a significant positive impact in the time needed to perform the task in contrast to using  the FME tools to perform the same task. I have assigned both software the following simple task into a "startup python script" in an empty workspace with one published parameter ('OSG_SDTF') which is used to acquire the path of the *.csv to be used in the task.(A) Read a big *.csv file (i.e. 17,977,400 records with the values found in 19 columns which are stored within a single 2 GB comma-delimited *.csv file).(B) Return a set (i.e. not duplicates are allowed) of the values found within one column of the big *.csv ('col0').(C) Print the result into the 'Translation Log' in the FME workbench.The code that I used is following:### USING FME TOOLS ###import fmeobjects, fmedef param_value(parameter_name):    return fme.macr

I know we had to previously make sure FME Server was on the same server as ArcGIS. Is that still the case for new installs on a new server?

Dear FME community, Problem description: Attempting to run an inner table join between two tables using SQL within the FME PostGIS reader (i.e. under the "Format Parameters" tab in the "SELECT statement" form) does not output the correct number of records expected; in contrast to running the same query in the PgAdmin III Query window which outputs the expected number of records.Data: I use the Ordnance Survey (OS) AddressBase Premium data (EPOCH 36) which are stored in nine tables according to the OS documentation within a test environment PostGIS 9.4 database (localhost). A "geom" column including not null values and representing points is stored within the blpu table while the other tables although they have a "geom" column the values stored in them are null.SQL statement:SELECT DISTINCT dvp.uprn, dvp.dependent_locality, dvp.double_dependent_locality, blpu.geomFROM public.abp_delivery_point AS dvp, public.abp_blpu AS blpuWHERE dvp.uprn = blpu.uprn AND dvp.dependent_locality != ''Fe

Can someone help me with the best process for getting FME 2015 64-bit working with the ArcSDE30 reader?The process outlined in the knowledge base article on this issue (here) is rather cumbersome for a general FME user (one that isn’t also the SDE administrator).The knowledge base article calls for one to install the SDE SDK, however when I search the ESRI site I don’t see where I can get this.The only solution I could find was to download and install the ArcGIS Server for Windows software on my local PC. I was lucky enough that I’m high enough in my organization to have access to the ESRI downloads for their products, otherwise I wouldn’t have been able to do this.Does ESRI still make the SDE SDK?If so where is the download for it? Is there a plan to make this more streamlined with FME 2016?I would think that ArcGIS Pro would have the 64-bit DLL’s that FME needs so maybe you all could plug into that instead of requiring this rather hard to find install.

I would like to write a text file and put the information on multiple lines using the CSV writer. I see how to put multiple fields but I cannot find how to put my information on multiple lines.Thanks for your help!

I am facing a problem related to Arabic text visualization in Geodatabase after translation of data from (Oracle10g [Solaries])ArcSDE to geodatabase . Even in source oracle database showing the arabic attributes but after translation it dosn't. In place of real context these are showing string of "¿¿¿¿¿¿¿¿"