- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,820 Posts
25,127 Replies

When you subscribe we will email you when there is a new topic in this category

6820 Posts

?I have a problem with writing to microstation tag

I have a problem with writing to microstation tag I want to write the tag to a different level than the cell I use microstation V8i and my input is shape

7 years ago

lgrant

asked in Data

How do I convert a .dxf file to LAS?

I have several .dxf files of bathymetric data that I need to convert to LAS files, they contain the following: Bathymetry (contour lines), Sounding (points), 1Xanno (points) and 0 (no idea). I am new to FME and managed to figure out how to convert .xyz files to LAS but these are a lot more complicated.Thanks,LG

Smallworld Translator Error: No URN handler for class unset

I am trying to migrate shape files data into smallworld by using FME. After configuring workbench i got bellow error's.Smallworld Translator Error: No URN handler for class unsetSmallworld Translator Error: Access denied to C:\\FME WORK\\enum_check\\Kofra_enum_log_report.csv.Thanks in advance for your help.

Does anyone have a way to Update or insert rather than have Writers that Delete and Insert. Something Oracle Merge? ThxMERGE Purpose Use the MERGE statement to select rows from one or more sources for update or insertion into a table or view. You can specify conditions to determine whether to update or insert into the target table or view. This statement is a convenient way to combine multiple operations. It lets you avoid multiple INSERT, UPDATE, and DELETE DML statements. MERGE is a deterministic statement. You cannot update the same row of the target table multiple times in the same MERGE statement.

Converting 3D shape file to 2D

Hello,is it possible to convert 3D shp file to 2D? If so, how can I do it?Thank you!

Maintaining field indexes on dynamic read/write

I'm upgrading the way we build data samples to use FME Desktop. With vector data, I'm using a dynamic reader (to save individually handling of many tables), passing through a Clipper to restrict the area and finally writing the output. It's simple and works fine, except... the field indexes on the output are not maintained. Having to put these in manually or in external software sort of defeats the purpose of using FME! Is there a way of preserving attribute index (and spatial ones for something like Esri Shapefiles) using a dynamic read/write workflow? Regards, Warren

How to create a customized writer?

I need to create a csv-file with a special structure. I 've two problems which I haven't an idea how to solve:1. How can I add a file-header before the actual content (The yellow part on the picture)?2. If an element has more than one coordinate pairs (in case of a line) how can I add the vertexes and the end-point on the same row (The part witch is in blue on the picture)? Yellow: File-header Orange: Column-Header Shades of Blue: Element coordinate(s)

130

7 years ago

fmeuser_gcContributor

asked in Data

Doesn't create Netezza spatial reader?

Unable to create NETEZZA SPATIAL READER, but it does able to create spatial writer.|ERROR |IBM Netezza Spatial Reader: No spatial package detectedAny ideas please? Thanks,

7 years ago

tbuckler

asked in Data

How do you specify the the kml_open attribute to force folders to be expanded in a KML?

I tried creating a kml_open attribute and set it to 1 but it doesn't expand the folders. Examining the markup, it doesn't appear that the <open>1</open> tag is applied to the root document. However if you set the kml_visibility attribute it will apply that tag to the root document.I am using FME 2017.1.1.1

Postgis Writer - geometry type setter

Is there a way of setting the Geometry setting on the output feature type with a published parameter?

Attributes handling and querying from Excel sheet

Hello, I have a problem with selecting and passing on selected parts of my table from one transformer to another. I have two datasets - GML data called Bygning, and table with specific styles, line weights, symbology etc. From the table I need to select only those rows that have also the Bygning name, and would be used to style the Bygning GML data. I do not know how to select only specific rows from my table automatically, based on the name of the incoming GML layer. I could use AttributeFilter and type manualy the name of the data, but I have dozens of datasets so the process needs to be automated. My current approach is attached. It works but is not elegant. I remove all the unnecessary data from the GML file, merge it with the table and then merge it again with data. That means I need to load data twice and due to data being huge it takes a lot more time than needed. Can you guide me how to select the needed rows from the table? Thanks!Sample data:

190

7 years ago

reservoirdogSupporter

asked in Data

FME writes data to Excel with white font color ignoring Excel-Template

Since I upgraded to latest Build 17650 I first had problems with a corrupt FME Installation where e.g. StatisticsCalculator outputted only NULL-values (see this thread).Now I executed all our statistics batches finding out FME is now writing data in white font color with white borderlines, you can say as "white boxes". It ignores formatting of the template-Excelfile. The data itself is there, but not visible because of white color. The XLS-Template used (since 4 years unchanged) has standard formating in black with light grey borderlines...Are there any known bugs in the excel writer since Build 17291?If you change font color and borderline color manually you can see the values:

HTML in parameters (FME Cloud)

Do you know, if it's possible to write simple html code in the prompt of the parameters for a workbench in FME Cloud.I do it in Desktop (to have text color, bold or italic) and it's works good. But in FME Cloud the html is not translate.HTML Code in FME DesktopHTML Code in FME CloudHave you got an idea for this issue ?Thank youDamien

7 years ago

_trent

asked in Data

Relating AutoCAD block and text with entity handles

Reading an AutoCAD dwg, how do you get the entity handle of a piece of block text while also retaining an attribute to relate the text to its block?In my workbench I have the following parameters, which seem applicable, set:- Expand Blocks into Entities: Yes- Read Visible Attributes as Text Entities: YesThis gets me the block text entity with its autocad_entity_handle attribute set, but none of the attributes I can tell relate it back to the block from which it was exploded. It would seem that the autocad_block_name and autocad_block_number attributes would do this but they don't get populated.I am using FME Desktop 2016.1.1.0.

450

7 years ago

lazarlubomirContributor

asked in Data

How to fit DWG block to bounding box of exported data?

Hello everybody!I try to solve one big problem... I work with workspace which export some spatial data and all I need to do is to create envelope around exported data. BUT, I need the envelope which is composed by predefined AUTOCAD BLOCK in separate DWG drawing (e.g. frame or drawing stamp; block is everytime centered into 0,0 coordinates)... To better imagination I attached picture, where I decribed my aim.I would appreciate every help. Thank You so much!Lubo

7 years ago

kanthsri74

asked in Data

Using LIKE or Wildcardoperator in Feature Merger

Hi,I have to merge two tables with the common field.. one is from plain sql database and other is feature class..Here I am using Feature Merger transformer..But I have to query the data in feature class using wild card search (data) from table1.SQLDatabase-------------------(Select Code from Table1) ||FeatureMerger ----> I want to query the data FCField like Code | |FeatureClass -----------------(Select FCField from Featureclass)Any help would be highly appreciated.Cheers,Srikanth Dasari

Read Excel File with sheet names, row and column numbers?

I have a large number (~1000) Excel files that I need to import into a database table. They are many different formats, so using a reader with a defined schema will not work. I would like to have the output contain the following attributes:FilenameSheetnameRowNumberColumnNumber (preferably as a number but could be letters as used in excel)value (as text)I've tried numerous things and searched through many posts. It seems like this should be a simple task, but the Excel Reader attempts to detect a "schema" for a sheet, and it uses values it finds wherever in the excel as attribute names. Any suggestions would be greatly appreciated.

Could not create the File Geodatabase '-2147467259' error

Hello,I get Geodatabase Error (-2147024894): The system cannot find the file specified. Could not open File Geodatabase dataset `\\\\coacd.org\\dfs\\PDRD\\IT_Services\\GIS_Group\\Programs\\Zoning\\test.gdb' for writing when using FME Server. This works on my desktop.I've checked on permissions, and was told I have modify privileges. I tested that by writing a shapefile to the Zoning folder and that worked. As you can see I am also using the UNC path. I've also played with both the arcobjects and API writers. I have a sample workbench that I am testing. I would appreciate anyone looking at that or giving me some clues on this issue. Thanks!

I am having trouble connecting to an Oracle database using the 12c client with FME 2017

7 years ago

egaru

asked in Data

ArcSDE: Write empty geometry instead of NULL geometry in FME

HiI have an issue with NULL geometry features in ArcGIS. Such point features occur when I write them without a geometry to a ArcSDE DB by using FME. We found out that not only FME has problems reading such NULL geometry features (when using an ArcSDE Reader), but also when reading them through ESRI Mapping Services. However, when using an empty geometry instead of a NULL geometry, no errors occur.In the Oracle database, a NULL and an empty geometry are differently defined:NULL geometry: NULL Empty geometry: MDSYS.SDO_GEOMETRY(3001,2056,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,0,998,1,1,1),MDSYS.SDO_ORDINATE_ARRAY(1,1,1))Is it somehow possible to write empty geometry features in FME (2016/2017)?Greetings, André

430

7 years ago

m_tengbrandParticipant

asked in Data

Aviod geometrycollection in MS SQL?

I have made an aggregation of lines that I have saved in MS SQL. when I then make a STGeometryType () on the table I find that a GeometryCollection has been formed. I want to avoid this and instead save it as a MultiLineString. However, I do not find any settings where I can control this. (then I will do the same for points and spaces to completely avoid GeometryCollection.)

Anonymous

Power BI allows the developer to access data either by a direct connection to a database or by importing a dataset from a database. The import makes the operations in the Power BI report faster because the app doesn't have to go directly to the database, but the data is not fresh. Are any plans to create an FME writer that could access and write to Power BI to emulate the import process? That way an FME script could be run on a regular basis to refresh the imported data.

Writing out to a Versioned SDE runs out of memory error number from ArcObjects is: '-2147216072'

I keep getting this error when trying to write out large amounts of data from a workbench to the Default version of a versioned feature class in a SDE:|Error while retrieving an ArcObjects update cursor for the table/feature class 'ILMOCDBO.gtlf_ln'. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error [[Microsoft][SQL Server Native Client 11.0][SQL Server]The app domain with specified version id (11) was unloaded due to memory pressure and could not be found.] [ilmoccmp.ILMOCDBO.gtlf_ln]} From what I've learned, that error means that the SDE ran out of RAM on the server that it is installed on. This happens because when FME is writing out the data, it is being written to a view in the SQL and the view lives on RAM while this happens. The error occurs when trying to write out large amounts of data, but can vary depending on the size of the data being written out and the amount of free memory. What I am

Choice with alias (Multiple) in FME Cloud

I have a published parameter of type "Choice with alias (Multiple)". In this parameter, I import all the towns, departments, regions... of France (like 40 000 lines) from a postgre table. When I run the workbench in FME Desktop, it takes a little time to filter the values according to what I'm writing and to select them but it can be ok. But in FME Cloud, it's very very very long and I can't really use it.I've try with a list without the towns (7 500 lines), it's better but still not usable.... Have you got an idea for my problem ?I know it's a big list for a parameter but it's the goal of my workbench. I have a table of 19 000 000 lines and I have to do a filter according to selecting territory by the user.Thank youDamien

7 years ago

jjaksic22

asked in Data

AutoCAD zero-length lines to stay lines

Hi all,I'm trying to process one DWG and create another DWG. There are some blocks inside and I used DWGStyler to make it all right. And that works. But there are also a number of zero-length lines for which I want to stay lines in the output DWG. Instead, they are turned to points and converted to blocks. I've tried to set the advanced parameter "output zero length lines as lines" but it is not working. No matter what I do, they become points and convert to block in output. Their position is identical to block position. I need them to stay there, and stay as lines or points but not to convert to blocks. Any advice what to do? Thanks.

200

7 years ago

Page 178 / 273

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.