Using readers and writers to extract and load data.
Recently active
Related to writing 3D PDF:FME2014 – 32 bits: Option to «reorient 2D features for visibility»?FME2015 -64 BITS : No option to «reorient 2D features for visibility»?From the documentation I see:To maintain backwards compatibility:- Workspaces generated with 64-bit FME 2015+ use the PRC file format.- Workspaces generated before FME 2015, running 32-bit FME 2015 or later, will use the U3D file format.Is it not possible to use «reorient 2D features for visibility»? anymore?
hi, is it possible to make a published parametre for the table qualifier of postgis writer ?thx a lot for ur helphave a Nice day
Hello,I'm trying to add a element in my gml with 4 classes: restriction base="string"> <enumeration value="very good"/> <enumeration value="good"/> <enumeration value="medium"/> <enumeration value="bad"/>Can I do this in FME, because I only could add a parameter:So I want to change the type in order to have in my xsd file the several options:Thanks all for the support,regardsInês
I try to write multiple Raster images to a single PostGis table. Writing the records sequentially is working as designed.But I am using FME Cloud and want to write records parallel using multiple engines. The first record is written, but seems to lock the table. Therefor all other processes fail.How can I avoid the table lock in PostGis?Any suggestions?
Hi,I'm reading many LAS files in a workbench (FME 2015.1.2.1, 64 bits) and I don't undestand why I have this line in my log file for each of my LAS file:PointCloudThinner: Thinning point cloud from 2366939 point(s) to 50000 point(s)I don't use any pointcloudthinner in my workbench but it runs like if FME automatically reduce the number of point of my LAS file. If this is true, how can I control the parameter of that thinner?Thank youJulien
Hello everyone! I have an autocad file that contains anonymous blocks. I would like to be able to read them from FME 2013, meaning see autocad_block_name. In autocad, by going to quickselect, I see various block's name like: *U248, etc and I see on which layer these anonymous blocks are. In FME, I have to use schema reader to find the same layer, but I have no informations of the anonymous block's name. Can anyone help me? Thanks
I have a publication in FME Server that monitors a directory and sends a message to a topic when the contents of the directory change - for example, when a file gets updated. When I start the monitor for the topic in FME Server, I get this JSON output:Total: 1 Shown: 1 Test_DirWatch_Topic arrived at 7:40:03 { "ws_topic": "Test_DirWatch_Topic", "dirwatch_publisher_path": "C:\\\\ProgramData\\\\Safe Software\\\\FME Server\\\\Data\\\\xls\\\\New Text Document.txt", "dirwatch_publisher_content": "ENTRY_MODIFY C:\\\\ProgramData\\\\Safe Software\\\\FME Server\\\\Data\\\\xls\\\\New Text Document.txt", "dirwatch_publisher_action": "MODIFY", "fns_type": "dirwatch_publisher" }I also have am FME script that subscribes to the topic and takes action when the topic receives the JSON above. However, I only want the script to take action if the directory change is a "modify"
I am migrating ESRI shape file data to Smalword4.0 using FME. In migration process RWO objects migrated successfully. i am unable to migrate "Join Records"(Assets and Phases) and relation maintenance between tables. I need clear procedure to migrate join Records migration with relation maintenance.
So I am trying to read from a database and then take only the data I need and create and write to a file geodatabase. When I try the file geodatabase api writer all I have to select a .gdb file. Is it possible to just create it as well in FME so I can just tell FME to save to a certain folder where I want these GBD files at.
I'm having a simple script, which renames some exported attributes, then fetches the primary key sequence number using SQLExecutor and writes the result to an Oracle Database, but it seems that something gets done to the geometry during the process.I can inspect the translation result just fine, but when I attach the translation result to the Oracle Spatial Relational Writer, on translation every geometry gets inserted with an error (the column value is null): Bad geometry detected in the following feature; Geometry could not be encoded for Oracle.When I'm not using the SQLExecutor to fetch the primary key sequence, the script works just fine. Do I need to check something else to make FME leave the initiator geometry alone? Is this a bug?
When I use the KMLStyler and specify an icon image it invariably creates an "images" folder in the KMZ output. However, I want the folder name to be "files" which is what Google Earth uses. Is there a setting to force the writer to write a "files" folder? @jimo
How do I create an empty MS Access table in FME workbench without any records? If I use the creator, it will create one empty record but I need just an empty table.Thanks,
Hello,I'm having a problem running a workspace in my FME Server.When I run the workspace from my computer at the FME Client it works fine. But whe I try to run it from the server (another computer) I get an error file that it could not find my TNSNAMES file. Where does the server look for this file? Can I changed it manually?Thank you for your time,Kitty
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 area that are intersecting the AOI, since the original shape of
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, )