Skip to main content

- - Community Resources
Ideas
Product Updates
Events
Blog

EN

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,826 Posts
25,149 Replies

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

6826 Posts

How to extract attribute to file name?

Hi! I am fairly new to FME. I am trying to develop a tool which creates a bounding box around features in the database. I've managed to create the bounding box as well as all my features into a .CSV file. What I want to do is make the writer use the coordinates found by the bounding box when saving the file name for each file. I have tried using @Value(<attr name>) however this just tells me my schema isn't set. I have also tried using a fan out feature on the writer, doing this allows me to save the file with the coordinates, however this then just leaves me with a blank file whereas I need a table with all the features and their added bits with it. Any help or advice on where to look would be appreciated!

How convert tiif or jpeg2000 (jp2) multispectral (3 bands) in ecw

How convert tiif, geotiff or jpeg2000 (jp2) multispectral (3 bands) in ecw,Thank you,Best regards

How can I change the colors for a KML line when it is rolledover or selected?

I have some route geometry that I am trying to highlight when it is selected or rolled over. I think that I should use the KML styler but I am not sure how to proceed.

LAS to Custom Text Format

i have an LAS file and want to export a custom text file with X Y Z R G B Classification. how would i do this the writer for txt only exports XYZ values and i can't seem to find a way to get this information out of my point cloud.

Using PointConnector to create polygon shapefile from text file

I have a text file extracted from an Oracle Spatial Object containing an ID field and ST_GEOMETRY with a pipe delimiter between the fields. I would like to create a polygon shapefile from it using PointConnector, or any other transformer. PointConnector does not recognize the ST_GEOMETRY field.

kiranmaiinfosys

Issue with FME Add Reader- not showing the spatial column in Oracle table in FME

Hi all,we are in the process of evaluating the FME tool for one of our proposal to the client. since I am new to FME, I just downloaded FME trail version and tried to generate some easy report using Oracle Database spatial tables as source. here i tested with one oracle geospatial table which has one sdo_geometry column 'Coordinates' so i have used oracle spatial object reader type and selected the above table but it did not show the Coordinates column rest all it showed - can you please let me know how to get this column in reader table? and am i using the right type of oracle spatial category?

Junk attributes in microstation v8 elements's tag

Hi,I am trying to migrate microstation V8 graphic elements with tags into ESRI's shape format. I am using a dynamic reader and fanning out features in different shape files based on fme_feature_type.The problem is when I read elements from microstation several other attribute appear in the process which are not part of the TAG SET of microstation file. I tried removing those by adding attribute remover or attribute keeper transformers but those attributes are not visible as an attribute in any of the transformers, I can able to see it only FME DATA INSPECTORS attribute property pane, these junk attributes manages to pass through and write in the shape file which I don't want. Can anyone please help me solving this.Thanks in advancedIMRAN

raimondContributor

Moving middle of text to a coordinate

I have a database with fields for x-coordinate, y-coordiane and a textstring. Now ik have to create a Microstation dgn-file with the middle of the text on the xy-coordinate.I'm using FME Desktop 2015.0 In the workbench I start with a VertexCreator. Then I use LabelPointReplacer to place the text at the coordinate, but the coordinate is at the bottomleft corner of the text. When I set igds_oiginal_justification to 7 (centre-centre for Microstation), the coordinate moves to the middle of the text. So the text is not on the correct coordinate.How can I move the middle of the text to the coordinate?

philippebEnthusiast

Count number of unique characters into a string

Hi,I have this string for example : "Hello-World! Let's talk-about-you!"If I want to know the number of "-" (here would be 3) into that string, how could I do that with a transformer?Thanks!

How to convert a file CSV to oracle table (type POINT object)

Hi,I have created a graphic ORACLE table from a CSV file. The CSV file contains the coordinates X and Y to create points. Now the ORACLE table contains the points but the graphic column contains null values. It seems that I must : 1. Check the types of geometry it is passing to writer (i.e. line / point) , but how to do what ? 2. Define the parameter " oracle_type " with an attribute creator, but which value "point" or "oracle_point" or "SDO_point" ?Thanks you for yours answers

pratapContributor

dgn to dgn with tags

Hi All,I have attached dgn reader and connected to dgn writer (No transformers in between). Both reader and writer are V8 files and I have enabled "Write Tags" to "Yes". I'm getting the output dgn file without tags.Is there any action/option shall I have to do to get tags in target as present in source.Pratap

Detect points above each other

I would like to establish a QA script for photogrammetrically derived point clouds where a flag is thrown if there are double layers. I am trying to find a way to detect points on top of each other, or some other method of finding double layers of the same data.

surbhiContributor

Has anyone used ArcGISOnlineRouter to create multiple routes for multiple inspectors?

I am trying to create routes for multiple inspectors in FME. I think ArcGISOnline Router may be the way to go. Has anyone tried it out? If someone is using some other method, what would they recommend?

FME is giving error while importing data into SmallWorld from shape files.

The error says "SmallworldWriter Error: Object unset does not understand message field()with arguments: :fme_feature_type".Steps I have followed:-1- Opening a smallworld image.2- Making the alternative writable.3- TICS server was running on 30000 port.4- Mapped the reader to shape files, the writer configuration was given as local host & 30000 port. But the object & attributes got mapped to the writer directly from reader.It's easier to export data from smallworld, because the reader identifies the dataset & lists the objects. I am not sure about the the writer though.I am new to FME, please help me.

Shape column is not showing from oracle spatial table in both reader and writer

HiI am trying to transfer data from Oracle sde database from one server to other with same environment. But when i add reader and writer these get other columns but miss shape column.Please experts guide me.

poncetaContributor

Is it possible to write 3D Geometries with the PostGIS Writer on newer versions of FME?

Hi!We're stuck on a 3D geom linestringz import into a postgis 2.0 database. Seems not possible on FME 2014, right?Is it possible on newer versions?Working around with sql executer.

copy external files based on result names

Hi, I want to copy files based on workspace result values. Example: a, b, c builders are applied for tenders of xyz road construction. All 3 companies tenders are integrated into one document and named as xyz road (its same as fme workspace result road names)so when fme workspace result record contains xyz road, then pickup "xyz road" excel/pdf tender files and copy them into a specified folder path (or create new folder and copy files). Any guidance on how to check the result road names with external files present in a directory (Lookup tables?)? is it possible in an easy way to automate it ? How can i compare result and copy respective files into a specified folder. Any guidance is helpful.Thanks,khk

How can I convert a gml attribute in xml read with feature paths to geometry

I have an xml with feature bag_LVC:Pand with this structure (example): <bag_LVC:Pand> <bag_LVC:identificatie>0003100000117485</bag_LVC:identificatie> <bag_LVC:aanduidingRecordInactief>N</bag_LVC:aanduidingRecordInactief> <bag_LVC:aanduidingRecordCorrectie>0</bag_LVC:aanduidingRecordCorrectie> <bag_LVC:officieel>N</bag_LVC:officieel> <bag_LVC:pandGeometrie> <gml:Polygon srsName="urn:ogc:def:crs:EPSG::28992"> <gml:exterior> <gml:LinearRing> <gml:posList srsDimension="3" count="17">254059.737 593504.637 0.0 254059.227 593500.0 0.0 254059.216 593499.899 0.0 254058.242 593500.0 0.0 254057.914 593500.034 0.0 254057.893 593500.0 0.0 254057.807 593499.863 0.0 254052.074 593490.692 0.0 254052.182 593490.639 0.0 254058.138 593490.002 0.0 254057.932 593488.165 0.0 254074.487 593486.413 0.0 254075.981 593500.0 0.0 254076.265 593502.583 0.0 254076.561 593502.55 0.0 254

Synchronizing GIS and CAD (DGN) with FME -- can it be done?

I am a newcomer to using FME products. I have been reading several documents relating to my question. However, I would like to have an answer directly from your staff.We are a two shop software (Bentley Product) MS – used by our designer. GIS – used as an asset management tool.At this time we are also maintaining our assets data in MS as well as in GIS. The purpose for this practice is that our designers are able to consume the historical data while designing a project from our MS asset registry data repository. This process is becoming a lot more Painstaking an enormous amount of work for our MS and GIS staff as well as major duplication of effort. My goal is to be able to maintain one assets data repository (GIS) and have our designer consume this data in the MS environment thru a conversation/extract tool from GIS to DGN. At the same time, thru transformation, be able to maintain and display the feature Standard developed by our designing staff with the collaboration of Bentl

??????KML?2D???3D???????????

??FME???2D?shape?????????????KML?3D??????????????1.??2d?KML?????????????????cad???cad??????? 2.????????KML????????????????? 3.??????3dForce?KMLpropertySetter??????3dKML???????????????KML?????2d??????? ?????????????????????????? ????????????????????????cad????????????????fme????????? https://knowledge.safe.com/articles/18762/basic-3d-kml.html

How can I Force Upper Case attribute names when writing to Oracle DB in FME 2016?

I try to follow this instructions https://knowledge.safe.com/content/kbentry/109/forcing-upper-case-attribute-names-when-writing-to.html but it seems that it is for FME 2015 and the metafiles are different.

change input data (same file structure)

Hi i've only just started using FME (2016) so this is likely a very simple problem. i've created a workspace that takes a series of MI tab files, and re-maps some attributes to a writer. it works fine. now that its finished i want to run the same tool again with different data (same structures). what is the best way of doing this?i've tried right clicking on the reader > edit 'NAME [MAPINFO]' parameters and changing the data there and that doesn't seem to work when i run the tool. nether does reader menu > update feature types.Data_1 Col_A Col_C Data_2 Col_C Col_B Data_3 Col_B Col_A Output Col_A Col_B Col_C

Shape (latitude and longitude) identification

Converting a shape file to a MySql table and all is working with the extraction of each attributes except i can not identify the latitude and longitude values that represent the point geometry. Can any one help me with how I identify and split out the coordinates in a shape file. thanks

ESRI personel Geodatabase(mdb) file to ArcSDE

hi,I am working on CAD to geodatabase: for which I will have .mdb(esri pgdb) as output, can I check how do I create a modal to push this mdb file into ArcSde, such that every time I run this modal it will append the new data. This will help me convert the data for different areas and migrate them in ARCSDE.Appreciate your suggestion ThanksAnshul

Read and Split XML

Hi,Although, I have worked with transformers but I am fully new to XMLs.I have an XML input file, but, unlike other XMLs, when I open this xml in notepad++, its as good as a text file only. Its not parsed ad segmented. Although, I tried some transformers, but didn't work. Once these XMLs are written, I would like to split it in 50 attributes in each file. Anyone with the solution !!

1
...
225
226
227
228
229
230
231
...
274

Page 228 / 274

Badge winners

mpimiskernhas earned the badge English Speaker
mpimiskernhas earned the badge German Speaker
albineprohas earned the badge Student (Bronze)
albineprohas earned the badge Student (Grey)
albineprohas earned the badge Expert (Grey)

Show all badges

30,463: Posts

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login

Login to the community

An FME Account is required to contribute

Login

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.

OK

This file cannot be downloaded

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

OK

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.