Data

Hello, I have the following problem writing SQLite files.I have several use cases where I want to write SQLITE files. For my application, it is important that the virtual tables are also generated in the SQLITE file. If the table name is Table_A, there should also be a virtual table fdo_table_A.I've created some workbench that worked. But I also have workbenchs in which the virtual tables are not created and I do not see the difference. Does anyone know the condition that these virtual tables are created?Many Thanks David

HelloI need to make a join between a geometry (polygon) from a block (DWG File), and the insertion point of this geometry : How can I do this ?Is there a unique common Identifiant betwen insertion point and geometry, for a block object ? I need to do this because I have to put the autocad_entity_handle of the insert point in the geometry (polygon) attribute (because autocad_entity_handle is not a unique ID for the polygon from the block). I used the "Preserve Insert Point" in DWG Reader Options : Thank you.

Hi, I have Vegetation data (tree) as pointZ. I need to convert the data into citygml with 3D representation and also I need to apply tree texture.Kindly let me how to acheive this. I used appearance setter to apply texture but it is not working. Citygml Schema : SolitaryVegetationObject ThanksK.Jayakumar

The issue I am having is the DXF data I have has been split up into "Sheet" level data. This means (in this case rivers) lines have a long distance between them. The snapping setting does not work as I have to use a parameter that is too high and it messes with the data. Is there any way to "close" these openings on the rivers? The first picture is an overview of the "sheet" level data I am talking about with several openings and the second is a zoomed look at one of the large river "openings". The third image shows the line I am attempting to create in order to close these spots off and in turn convert to a polygon. In the end I will be converting the data to shapefile.    

Hialthough I can read english quite fluently, for this kind of technical stuff I still feel more confortable doing it in my mother tongue, spanish. I feel I lose nuances that can make my processes more efficient becuase I did not select the right transformer.I have seen that there exist the FME in spanish, but I don't need it. I am OK working in english, it is just sometimes I waste too much time 'deciphering' the help :)I have seen that all the documentation (and you have a lot) is in english. Maybe it is just I did not look in the right place.So, is there any place where I can find the documentation in Spanish?Thank you very much in advanceAitor

Hi, I am new in FME - I need a help. I would like to convert an PDF file to JPEG.

I'm sorry if this has been answered before but I couldn't find the exact answer to my question which is:How do I change the output name of an excel sheet (or file) based on a specific attribute name. Example: I need my output sheet name to be "Namn" and automatically read from the attribute name since I have multiple similar datasets but with variations on "Namn". All of which should be put into a separeate sheet but in the same file.It is probably really simple but as I said, I couldn't find it.(For me the output parameters and schemas are real confusing) 

I have a workspace that I am attaching here . Its function is to cut the trails using the first network limit, now besides making this cut, I also need to cut the trails using park, but always creating polygons with the remaining cut parts. P.S. all input file are DWG    In this workspace if I use only network works perfectly (see image), but if I enter the park layer, the following error below appears:  INDEX FAILURE - requested predicate not implemented  Why does it happen? Can you help me? Thank´s

I have a DWG file and in a layer has a field in autocad_text_string that has a date. But in all 1000 records this field only appears 1 time obviously ... how do I make this date repeat for all other 999 features? considering that I will read a whole folder with several DWG files, how do I make each one have its own date? Thank´s

I have exported data from PDF file using FME. The output contains lines, polygon and text data. A sample of the text data is attached. I need to combine the different letters in points with the same TEXT_ANGLE and TEXT_SIZE to form a new attribute containing the full text and write it to 1 point feature.

I have a workbench that uses the SurfaceModeller transformer to produce a DEM (DEMRaster output port) from input polylineZ and break lines inputs. The output DEMRaster will be used as an input in various raster math operations with an existing terrain DEM. It is thus crucial that the DEMRaster output match the cellsize and be perfectly aligned to the existing terrain DEM. In Esri parlance this can be achieved using the "Snap Raster (Environment setting)". How can I achieve this with FME? I am using FME Desktop Professional 2017.1.1.1. I have tried using the RasterGeoreferencer as recommended in the Snapping raster output cells to existing raster template cells (same cell size) p

Good morning, I'm trying to extract a table from a website, but am having a difficult time doing so. The issue is that the website has a pull down option with multiple tables. I'm able to use HTML Table reader to extract the table that comes up as a default, but I need to pull one of the other tables. The URL that I'm using is https://eds.ospi.k12.wa.us/DirectoryEDS.aspx. In upper left, you have the option to select Reports by either District or School. District comes up as the default; but I am actually interested in the school table. Can someone help me achieve this? Using the HTML Reader, I'm able to see the default table that comes up on the website which is gvESDDirectory. However, the table that I'm looking for is called gvSchoolDirectory. I can see it using developer tools in Chrome. I'm just not able to figure out how to get FME to see that table. Thanks!

I want to read a csv from a URL, but I am failing to connect.I add a ReaderFormat: CSV (Comma Separated Value)Dataset: http://www.bom.gov.au/fwo/IDQ60801/IDQ60801.94418.axfunder ParametersDelimiter Character: ,Field Names Line: 20Data Start Line: 21 but I get the errorCSV reader: Failed to open file 'http://www.bom.gov.au/fwo/IDQ60801/IDQ60801.94418.axf' for reading. Please ensure that the file exists and you have sufficient privileges to read itWhen I use chrome to visit the URL I succeed. The URL and resulting csv file definitely exist.What I want is to read (and process) the csv file using FME

I have tried multiple combinations, but it seems the "Max Features to Read Per Feature Type" value is being ignored. I have 14 Feature Classes selected in my "FEATURE_TYPES" Published Parameter, so hence, if I set the value to 2, it should read 28 records but unfortunately it seems to only read 2 records from a random Feature Class. I am using v2016.1.0.1Refer @mhab's comments in this idea post: https://knowledge.safe.com/idea/25361/add-a-max-feature-to-read-per-feature-type-paramet.html

I've attached () a DWG file, which have 2 layers, I need to create / close polygons using the TRAIL layer, however the TRAIL layer in some sections cross with NETWORK, and so the polygon is not created. How can I create a polygon from the moment that TRAIL touches the first line NETWORK? See the images below:  Thank you

Hello,I have a simple workspace that renames and exports pdf documents to tiffs. Its the PDF2D reader, some renaming transformer,s and the TIFF writer. The tiffs need to be 400 dpi. No matter what I do, I only get 96 dpi. Is there a way to control this?I have been able to get the 400 dpi using other software, but it's either clunky or will cost me more money. FME is obviously the preferred method if I can fulfill this one requirement.I appreciate any help.Thank You, FME(R) 2018.1.0.1 (20180730 - Build 18528 - WIN64)

I have two separate Oracle clients on my machine. When I create an Oracle reader or an Oracle writer, it defaults to whichever Oracle client is first in my PATH variable. Is there any way to tell FME to use the other Oracle client?

Dear Community, Last year I created a very large FME Workspace that became even larger in time as new feature requests came in while there was no time to restructure the FME Workspace. At the end the FME Workspace had more than 1300 Transformers and FME Workbench had trouble to open it. (The file was 25 Mb large.) Moreover development work became slow as I had to wait about 10 seconds every time I clicked within FME Workbench. Fortunately I convinced my client to restructure the FME Workspace and now there is time to do just that.With an upgrade of the FME Server from 2016 to 2018 it becomes possible to make use of Parent-Child-relationships. Hence no additional engines had to be bought and that made it possible to reshape one FME Workspace in two FME Workspaces. Unfortunately I was surprised that if I ran the Child FME Workspace alone (which is in that case by definition no Child) a File Geodatabase could be read. (See job 274 in the screenshot below.) I

Hi, Im trying to Convert a DFX file to a GDB. The CAD file is a repesntation of a Piping System. The conversion runs successfully but pipes that run vertically (along x axis) loose their shape length. For the Reader in the format attribute tab: autocad_color, autocad_entity, autocad_layer, fme_attrib_info{}.field_value are checked. I'm using FME Desktop 2014, AutoCAD 2013, ArcGIS/ArcScene 10.1The DFX is 2007 Format  

Hi,  I can't seem to read layer descriptions from DWG files. I have tried different versions of FME, different reader settings and different DWG types with the same result.  It does seem to read a few of the layer descriptions but I have no idea why it would differentiate them as they seem identical when I open the files in AutoCAD.  Has anyone had the same issue?  Thanks!  

I have an elasticsearch instance that requires a password for writing. Am I understanding this correctly that FME can't write to a secure elastic search?

Hi,I don't find out if there is a rule to manage the execution order between a SQLExecutor and a Postgres Writer.I want that the SQLExecutor is executed before the Writer because it makes a backup of the table before writing.And I can't use the "SQL to run before write" field in my writer because I use feature values in my SQL instruction and this field doesn't handle feature values. The strange thing is that in one of my Workspace the SQLExecutor is executed before the writer and in another the Writer is executed before the SQLExecutor (the second one handles far more data).I tried to change the horizontal and vertical order of both but that doesn't change anything. Thanks for any help,Christian

Hi, I need to set color for Lod2Geometry features (vegetation) to create city GML. Please find the snapshot of the workspace. I am able to view the color in FME inspector but not in FZK viewer 

Following is an example I am suffering from now, just don't know how it could happen and the solution for us so far is just to manually move impacted columns back to the right position, which is stupid of course:1. Columns (Latitude and Longitude) are at the begining of the excel file:2. After imported into the FME, the order of these two columns (Latitude and Longitude) changed and moved to the last for no reason:

Hi,I have a 3D polygons file that I would like to convert to obj format. I tried several times but I always have one polygon in the output that is strange.any advice or idea?thanks!