Skip to main content
  • EN

Data

Using readers and writers to extract and load data.

  • 6,700 Posts
  • 24,699 Replies
6700 Posts
A
akituo
asked in Data
3D building smoothing

Hi,I have bigger guestion about working in fme with 3D geometry. I made buildings from pointcloud from certain city with different program. Everything went fine buildings look good and there is textures from aerial photos. But now I would need to make buildings file sizes smaller for game engine. There is most likely other programs to do this, but was thinking if I could make fme work with these files? What makes files so big is amount of polygons and ofcourse amount of textures on these every polygon.Goes maybe little hard way, but how I could make buildings smoother and still keep their textures?I know in sketchup there is own tool for this, so why it wouldn't be possible for fme? :)And yea.. There is about 1700 buildings to make smoother or just get their filesize smaller somehow. So Im trying to make fme work with all these buildings in one workbench.I have buildings in .skp and .dae formats for now.

2
mark2atsafe
Safer
8 years ago
I
iant1212
asked in Data
Is it possible to write a CSV file with no extension via Server Data Downloader?

I followed a suggestion from another post from 2013 which said to use only a period on the file extension type parameter. However when I do this the output file from the zip folder looks like this: `filename..`. If I set the extension type to nothing I get `filename.csv'. Is there a way to have it output just 'filename'? This is FME Server 2015.1

1
mark2atsafe
Safer
8 years ago
E
engincevik88
asked in Data
Multiple Screen Overlays in kmz

I was wondering is it possible to add multiple screen overlays to a kmz file?Thanks.

2
mark2atsafe
Safer
8 years ago
J
jonathan
asked in Data
Reading s57 with FME

Hi All, I'm trying to load S57 data with FME but have a few questions:  - FME Insists that catalogs have the .030 extension. However all the Hydrographic offices we deal with provide a file called CATALOG.031 instead. Even renaming the extension FME refuses to read it. How do you read the catalog file? Apparently since S57 Edition 3.1 (dated 2000), it's always been .031.  - FME only seems willing to read the .000 file for datasets. This works fine. However we have other extensions as well (such as .001, .002 and upward). FME struggles read to read these and shows no geometry. As I understand it these are "updates" to the given chart. How does FME handle these?  (Using FME 2014 SP3).  Thanks.

3
G
8 years ago
C
caldwellinva
asked in Data
OSM - Extracting Specific Key Value Pairs from Two Lists

Hi!I am reading OSM data in the .osm format and trying to write out selected key-value pairs based on the key name. The key value pairs are in two lists: tag().k and tag(),v. I would like to extract all the keys which equal "name" from tag().k and write the associated values from tag().v to a name attribute.I am having difficulty figuring out the best (or any) way to do this. I would like to accomplish this task just using the existing transformers if possible.Thank you!

3
C
8 years ago
I
iant1212
asked in Data
Is it possible to write a CSV without a containing folder in Server Directory for download

I am trying to output a directory structure like so:/metadata.csv/version.txt  /Dir1/    /FileA.txtWhen I publish to the Server and run as a Data Download job, the file structure in the resulting .zip looks like this:/dataset/metadata.csv/version.txt  /Dir1/  /FileA.txtI have specified the $FME_SERVER_DEST_DIR=\I have set the metadata.csv writer folder to link to $FME_SERVER_DEST_DIRHow do I have to configure this so that metadata.csv writes to the top level directory without creating a subfolder for itself?

1
M
8 years ago
gpt_geoinfo
Contributor
gpt_geoinfoContributor
asked in Data
DWG blocks attribute elevation (3D)

Hi FME'ler,I need some help with DWG and its blocks in 3D.InputDWG-file with a lot of blocks showing points, their name and their elevation as labels from attributes. Everything is in 3D. When reading this file into FME Inspector I can see the attributes having z-values.FME transformationIn FME I had to offset the blocks slightly in direction of xy. The elevation should remain. When inspecting the results before writing, I can see the z-values. Everything looks good.OutputWhen inspecting the output in FME Inspector (and AutoCAD) the block's points are at the correct position (with elevation), but their labels are on the ground (0). Does anyone know how the elevation of the attributes behave?! I already tried to set these values directly in FME, but the writer ignores(?) them.Thanks in advance!Maria

0
gpt_geoinfo
Contributor
8 years ago
gpt_geoinfo
Contributor
gpt_geoinfoContributor
asked in Data
Read DWG-Blocks - write DWG-Blocks

Hi,I'm struggling with DWG-Blocks...I have a DWG-file with a lot of points being in a block each of them (one point in one block), with some attributes. In FME I need to make an offset in direction of z. Then, I want to write it to a DWG-file again.Unfortunately the blocks don't get into the file. The file is empty.What do I need to know to correctly form blocks and bring them into the DWG-file?Thanks in advance!MariaFME-version: 2016 (16177), 64bit

2
gpt_geoinfo
Contributor
8 years ago
M
mahendra30627
asked in Data
How to disp[lay CSV file Name in CSV reader?

HI, I am using CSV Reader to migrate data into Smallworld. Actualy i have 11 types of CSV files names as 1. CSV point.csv.2.CSv Road.csv 3.CSV park.csv 4.CSV building.csv 5.CSV pole.csv......etc when i try to create CSV reader it displays "CSV"in CSV reader. As bellowActual name of the CSV file is "CSV pole.csv" but it displays only CSV. I want file name in that reader. How can i get that csv file name on CSV reader. I want to configure all the 11 csv files in single workbench. How can i configure all.Thanks in advance for your help.

4
M
8 years ago
E
emorecas
asked in Data
Sort folders in KMZ

Hi people, first of all sorry for my bad English . I need to sort the folders by group, I have 99 folders ( 0,1,2,3 ... 98 ) and I need to group from 10 to 10 Example 0-9 10-19 20-29 30-39 ... 90-98 how should I do it?Ty

2
jdh
Contributor
8 years ago
K
kouri1986
asked in Data
Trying to index a postgres database with sqlexecutor and have a timestamp

So I wrote to a postgres database all the data and now I want to index it using a sql executor and have a timestamp on the index. I tried to use "CREATE INDEX ct_table_data@Value('current_timestamp') on ct_table(data)The big issue I have is it doesnt seem to time_stamp. I am useing the FME sql date function tool but no luck. Anyone have a good solution?

3
erik_jan
Contributor
8 years ago
rbovard
Contributor
rbovardContributor
asked in Data
Duplicate point reader creates a multipoint writer

Hi all,Working with PostGIS, I noticed a strange behaviour concerning geometry type when duplicating reader to writer:postgis_point > postgis_multipointpostgis_multipolygon > postgis_multipolygonpostgis_multilinestring > postgis_multilinestringWhy the points are handled like that (point > multipoint)? And is there a way to avoid that?Thanks in advance.Rémi

4
rbovard
Contributor
8 years ago
L
landwalker
asked in Data
File Geodatabase to IFC

I want to convert a building of 3D Multipatch features in a File Geodatabase (ArcGIS) to IFC file to be used in AutoDesk Revit. Is it possible to do so? Thank you.

1
M
8 years ago
G
gonzikcz
asked in Data
How do I change one attribute in a reader?

I have a workbench with CSV readers. Now I updated the CSVs and some of the attributes changed names (e.g. from GAS Service Connection to Service Connection). Is there a way how to update single attribute instead of updating the whole reader? Thanks, Jan

2
G
8 years ago
P
pb1800
asked in Data
How do I set my writer to override existing file?

Lets say I have a routine with a writer and I run it. Now I want to run the same routine without having to change the writer file name. I want it to delete the old file and create a new one or Override the old file. How do I change the settings in the writer to do this?

2
R
8 years ago
erik_jan
Contributor
erik_janContributor
asked in Data
WFS with traffic info

Does anybody know a WFS link with up-to-date traffic information?It can be anywhere in the world.It has to be free of charge as I want to use it in a demo showing the WFS capabilities of FME.Thanks for any help,Erik Jan

4
mark2atsafe
Safer
8 years ago
R
rhansen
asked in Data
FME Server : problems writing to Oracle Spatial

Hi,I've run into a problem writing to tables in several different Oracle schemas using FME Server. In my workspace I have 5 different Oracle Spatial Object writers that I will write to depeding what data comes through. The Oracle schemas (users) are created with a .bat and several .sql files.The problem is that I only seems to be able to write data in 2 of the 5 schemas (the only differences between the schemas are password, srid and extent. All those have been verified). For example, writer 1 and 2 works but not number 3.If I delete all schemas and only create a schema for number 3 FME Server can write to tables in that schema. If I create all schemas (1-5), only number 1 and 2 will work.There are no differences between the Oracle schemas and FME will write data to all if I execute from Workbench. Unfortunately, I can't get it to work on FME Server. I have checked and rechecked the Oracle, FME Server and log files and I can't find any suspicious (connection ok, parameters

1
erik_jan
Contributor
8 years ago
M
mahendra30627
asked in Data
How to migrate CSV format X and Y coordinates data into Smallworld By using FME?

I am trying to Migrate CSV data into Smalworld by using FME.Using FME CSV_Reader for reading CSV data. I convert ‘X’ and ‘Y’ values into X_Coordiante,Y_Coordinate”.After this I am using “vertex creator” for creating point with “X and Y coordinates”.After that I add the vertex creator to “attribute creator” for attribute mapping. Here I got confusion what is the attribute name given for point geometry.But when I migrate data by using this the attributes are migrated successfully. But the geometry was not found.Previously I migrated ESRI Shape file data into smallworld by using FME successfully. In that I used “Attribute name=sworld_geometry{0}.sworld_point” for geometry mapping attribute connector.Can anyone tell me how to insert CSV coordinates point geometry into smallworld by using FME?After insertion “NOKTA, CBS NO” values are inserted. But geometry not showing in smallword.Summary: I am trying to migrate CSV file data into Smallworld along with geometry by using FME.

2
erik_jan
Contributor
8 years ago
vki
Contributor
vkiContributor
asked in Data
GML-Writer Error

I'm trying to write a GML-File using a workbench and a xsd-schema-file, which I got from someone else, but I get an error. Obviously, there's something wrong in the xsd-File, as this error occurs when the schema document is beeing parsed, but how do I find out, what exactly is wrong?(And strange enough, it used to work, I used to be able to generate the GML ...???) The workbench used to be FME2015, but now I use FME2016, but get the same error in 2015 and 2016.Creating writer for format: GML (Geography Markup Language) Trying to find a DYNAMIC plugin for writer named `GML' Loaded module 'GML' from file 'C:\\Program Files\\FME\\plugins/GML.dll' FME API version of module 'GML' matches current internal version (3.8 20151127) FME Configuration: No destination coordinate system set FME API version of module 'GML' matches current internal version (3.8 20151127) Writer `GML_1' of type `GML' using group definition keyword `GML_1_DEF' FME

2
vki
Contributor
8 years ago
R
rara
asked in Data
How to convert a 3D CAD (dwg) to IFC?

I have a 3D CAD drawing consisting mostly of disconnected lines and a few circles - see screenshot. When I try to export it to IFC with AutoCAD, all it outputs are six small circles which aren't even visible in AutoCAD on import (only Solibri Model Viewer), so I'm trying to do it with FME. I've played around with an autocad-to-ifc tutorial* however I'm not really getting anywhere. Right now I'm using the 3D enforcer with autocad_extended_data{0}.world_position{0}.z and that seems to elevate the lines properly in the inspector. However both autocad_shape_height or autocad_extrusion_z do the same, so I have no idea which would be the right one to pick. Sadly when I use the IFC writer, it outputs a 2kb file despite saying it wrote 2722 features. How do I do the transformation? All I want is to go from one format to the other and copy all values. * https://knowledge.safe.com/articles/595/autocad-t...

3
I
8 years ago
nath
Contributor
nathContributor
asked in Data
draw lines between points

HiI have to draw lines between two points with different attributes. They have a common number but in another field.All point have to be connected with a line to the networkI have already made a table with the coordinates of the beginpoint and the endpoint in the same record.As the endresult i have to become lines with a unique Id and the attributes of the point where the ID starts with HP_.Can sombody help me please?Thx!Nathalie

5
nath
Contributor
8 years ago
pratap
Contributor
pratapContributor
asked in Data
Edited Dimensions

Hi,I have a dgn file with dimensions for which value of each dimension is edited i.e. If we measure between the dimension lines then it is 105.456 but the dimension value has shown as 500.When I have seen in inspector it shows 105.456 but not 500. Do any one knows in which attribute does the value (500) store???

0
pratap
Contributor
8 years ago
D
david_allan
asked in Data
How use the legacy SDE writer with versioning and archive tables

Is there a parameter that needs to be set or a specific trick to getting the legacy ESRI sde writer to update archive tables when inserting records?The current setup is as followsA direct connection to an ArcGIS v10 geodatabase in an oracle 11g database, writing directly to the DEFAULT database version. The schema for the feature class is derived from a workspace resource pointing at the same sde database with the same connection detailsThis correctly updates the Adds tables for the versioned feature clases but no records are inserted into the archive tables. Is this just a product limitation, a bug or am I missing something?I can get the archive tables to update correctly when using the ESRI Geodatabase writer, but want to avoid this due to the ArcGIS license requirements and the performance benefits of the legacy writer.

1
fmelizard
Contributor
8 years ago
D
danpaoly
asked in Data
ArcGIS Portal

Does anyone know if it is possible to load ArcGIS Server feature services to ArcGIS Portal or will FME only work with the free outward facing ArcGIS Online.  Thanks 

2
G
8 years ago
keitho
Contributor
keithoContributor
asked in Data
Custom linestyles containing point graphics not displaying when writing to DGN v8

Using FME 2016 writing to DGN (v8)Having trouble with custom linestyles that contain point graphics displaying within my DGN file after translation. I cannot draw or even change an existing line to one of those styles. These linestyles exist in the seed that I have attached to the DGN Writer and I can draw them within the seed. Note all other non point linestyles within the seed display correctly in the translated DGN. Any ideas?

0
keitho
Contributor
8 years ago

Badge winners

Show all badges
29,707
Posts
Terms & ConditionsCookie settings