Skip to main content
  • EN

Data

Using readers and writers to extract and load data.

  • 6,827 Posts
  • 25,152 Replies
6827 Posts
itay
Contributor
itayContributor
asked in Data
Download workspace online data

Hi,I am encountering issues with downloading data via an HTTP call, sometimes it get's downloaded and sometimes not. The error reported is:2016-08-12 16:46:58| 0.8| 0.0|INFORM|Feature Type: `HTTPCaller__Rejected__LOGGED' 2016-08-12 16:46:58| 0.8| 0.0|INFORM|Attribute(string) : `_error' has value `Couldn't connect to server' 2016-08-12 16:46:58| 0.8| 0.0|INFORM|Attribute(string) : `_http_status_code' has value `'I was wondering if anybody has any ideas or better yet tools to verify why is this happening.I suspect this is due to network connection, but I would like to verify it in someway.Any help is appreciated.Itay

30
itay
Contributor
8 years ago
lavairye
Contributor
lavairyeContributor
asked in Data
Hello,

60
lavairye
Contributor
8 years ago
chris_rmw
Contributor
chris_rmwContributor
asked in Data
Module FME_ADO is unavailable for use with this FME edition

I have a workspace that reads data out of SQL Spatial, reprojects it and inserts it into a series of ArcSDE featureclasses. It runs perfectly fine in workbench, however after publishing it to FME Server and running it I received the above error. As well, there was a warning Library 'C:\\Program Files\\FMEServer\\Server\\fme\\plugins/FME_ADO.dll' was found but could not be loaded. Ensure that all the dependent modules exist for this library. As well, there was a warning that the FME_ADO.dll was found but could not be loaded.I only installed FME Server yesterday, so perhaps there is something I missed??Creating reader for format: Microsoft SQL Server Spatial 41INFORM0.03.1Today at 14:53:12Trying to find a DYNAMIC plugin for reader named `MSSQL_SPATIAL' 42WARN0.03.1Today at 14:53:12Library 'C:\\Program Files\\FMEServer\\Server\\fme\\plugins/FME_ADO.dll' was found but could not be loaded. Ensure that all the dependent modules exist fo

760
ciarab
Contributor
8 years ago
G
golugury
asked in Data
no dataset could be opened for electric_dm spacial object controller open datasets aborted!

Dear Support Team,I am using FME on "Smalworld434 demo camebridge database" after loading “FME430” product .When I try to start “FME Import & Export” it shows following error.“no dataset could be opened for electric_dm spacial object controller open datasets aborted!”After this I goto “SOC Configuration” using “Manage_soc()” based on datasets in soc configuration and professional-smallworld Core properties I changed ace_name and soc_name as bellow.In fme430 product swaf_fme_application module “register.magik” file. "D:\\FME\\fme430\\modules\\swaf_fme_application\\source". smallworld_product.register_application( :swaf_fme_application, :application, :resource_module_name, :swaf_fme_application, :html_help_file_name, "swafProFME", :html_help_resource_module_name, :swaf_fme_application, :description, "FME import/export application using the swaf architecture.", :external_name, "FME Import & Export", :ace_name, :|EO|,

50
G
8 years ago
K
kouri1986
asked in Data
Turning off the info logging on FME Server

Is their a way to turn off info logging on FME server. i have sql queries in my workbench i uploaded and wanted to know if i could turn off the info logging just for this workbench so the log isnt huge. When it logs the full queries it takes up space, i just want to see error, warn and fatal error messages for this one workbench

1520
mygis
Contributor
8 years ago
chriswilson
Supporter
chriswilsonSupporter
asked in Data
RealDWG not supported in 2016 - workarounds?

We are running FME Server 2016 on Windows Server 2008 SP2 and have found that the RealDWG writer is not supported by this. We use this for outputting data to CAD due to the basic ACAD writer having issues with block attributes. I am investigating this but if anyone knows of a workaround that would be helpful. Thanks.

140
chriswilson
Supporter
8 years ago
C
canpernano
asked in Data
Using a cursor. The error number from ArcObjects is: '-2147216072'

Hello:  I have re-created some layers with the exact same parameters in SDE, to run a final test of some workbenches.  During execution, I get this error:  n error occurred while attempting to insert a row into the table <table> using a cursor. The error number from ArcObjects is: '-2147216072'   This seems to be not clearly documented by ESRI. Does anyone know what this could be related to?  Many thanks,

5210
mark2atsafe
Safer
8 years ago
P
pbraun
asked in Data
Evaluating a data set for errors of omission and commission

I am evaluating FME and am wondering how the software suite can assist me in evaluating an existing geospatial dataset for errors of omission and commission. Any feedback would be appreciated.

90
mark2atsafe
Safer
8 years ago
C
crayxt
asked in Data
DLIS support?

DLIS stands for Digital Log Interchange Standardand is widely used in Petroleum industry.The standard is described here http://w3.energistics.org/rp66/v1/Toc/main.htmlCouldn't find any library for processing that format.

290
C
8 years ago
P
phikar
asked in Data
Adding a point cloud on top of another point cloud

Hi I want to add a point cloud on top of another point cloud (in Z) but I can't figure out a good way to do it.I got a big point cloud (over 7,000,000,000 points) of a city and then I got a point cloud with a lot of pillars I want to place on roofs in the city point cloud. The pillar point cloud is aligned in X and Y but the Z value is way off so the pillars ends up inside or under the roofs. Is there any way to read the roofs Z value and then set the pillars Z value to the specific roof Z, or is there a better way to solve this?ThanksPhilip

100
fmelizard
Contributor
8 years ago
H
honkovam
asked in Data
MS SQL Spatial - Orient Polygons

Hello,I can't find anywhere in the Help what "Orient Polygons" means? It's one of the parameters of MS SQL Spatial Writer.Thanks

42
H
8 years ago
X
xavigarciamar
asked in Data
Convert Texts Microstation

Hi , Anybody knows , what are the atributs to change the heigth and width of a text , when you do a transformation from v8 Microstation to v8 microstation ????.Any help would be greater , thanks !!!

120
X
8 years ago
E
eduardstifter
asked in Data
3D DWG to 3D DGN

Hi, I need the conversion of 3D DWG (including solids, etc.) to 3D DGN. Does your software support this process? (FME Cloud, as well?)

174
E
8 years ago
J
james_rutter
asked in Data
Update JSON document via Box api

Hi, got a bit of an issue updating metadata templates (json documents) using the Box.com api with the httpcaller in FME. Specifically I have some content in Box which has some metadata associated with it and it can be updated via an api call. The call needs to be a PUT and the content type needs to be application/json-patch+json as per their documentation here. Using the http caller there is no option to set this sort of content type in the 'Content type' selector in the httpcaller 'body' dialogue. Would be grateful for some ideas. I did try to set the content type by manually inserting into the header but this just returns an http 400 error.

50
J
8 years ago
H
honkovam
asked in Data
BoundedBy to geometry

Hello,I want to run a translation from GML to MS Spatial. There are two geometries (xml_geometry) in the feature collection feature type of my GML: TileExtent and BoundedBy. I would like to write either of them into a polygon.If I inspect my GML with the FME Inspector, neither geometry is being picked up - BoundedBy example:<gml:boundedBy> <gml:Box srsName='osgb:BNG'> <gml:coordinates>405000.00,205000.00 410000.00,210000.00</gml:coordinates> </gml:Box> </gml:boundedBy> Could you please point me in the right direction?Thanks

270
H
8 years ago
M
mappymatty
asked in Data
Restricting files read from zip

Apologies if this question is a bit newby...I'm only an occasional FME user...I've downloaded a zip from Ordnance Survey containing .csv files called, for example,HP40.csvHP60.csvHT82.csvHT84.csvSE00.csvSE02.csvSE04.csvSD06.csvSD08.csvTA00.csvTA02.csvI have a CSV reader looking in C:\\OS_Open_Names\\Latest_Source\\*.zip\\**\\DATA\\*.csv which will read all the .csv files.Is there a way I can update a single reader to read only the SE, SD and TA files?Thanks

77
erik_jan
Contributor
8 years ago
M
morten_aagaard
asked in Data
Read DWG text without getting txt bounding box

Hi allIm converting an AutoCAD drawing into a GIS map in FME 2016, the AutoCAD files contains a number of texts that I will be using as labels. This is fine but when I read in the dwg files FME creates a box around the texts that interferes with the rest of the map. These boxes are difficult to remove because the have the same color/size/layer/geometry type as other data that needs to stay so I have on easy way to filter them out.Is there any way to read only the texts without getting the bounding boxes?

80
gio
Contributor
8 years ago
P
phatnine
asked in Data
Using template in excel writer

Hi guys,In a workbench, I need to create an excel file as a sort of validation that all data has been written how it was supposed to be. I need to compare input and output and highlight differences in red. I'm able to create the excel file where all input columns are next to their output.For the highlighting part, I created an excel file containing all column names in the A row, and conditional formatting that highlights cells in red if output <> input. I tested it directly in the excel file and everything works ar it's supposed to.So, I added the excel file as a template. I tried every configuration I could think of, but every time I launch the workbench, it results into a copy of my template, without any data written.How do I insert values into the excel file, while using a template file?Thank you(FME 2015.1, EXCEL 2013 file format)

330
ciarab
Contributor
8 years ago
mmccart
Contributor
mmccartContributor
asked in Data
Has anyone used FME to Create ArcGIS Online Feature Collections?

I am trying to use FME to create ArcGIS Online Feature Collections instead of Feature Services. I assume I need to write some Python script for it but wanted to see if anyone else had perfected this process.-Mark

120
mmccart
Contributor
8 years ago
M
mariuskolleck
asked in Data
SDE Writer - How to set up Oracle metadata correct for SDO Geometry?

We're trying to write data via "ArcSDE Geodb" writer in SDO_GEOMETRY format and make it readable for non-ESRI software. We're using ArcGIS for Desktop 10.3.1 on an ArcSDE 10.2.2 on Oracle 11g with FME Desktop 2015.1 (but the same problem apperas in different combinations of software versions as well).Our main problem is that in the oracle geometry metadata entries the axis-definition can't be set correctly no matter how we're trying it. SQL:select DIMINFO from user_sdo_geom_metadata WHERE TABLE_NAME = 'SDOTEST_FME_WRITERCRS';RESULT:MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT(NULL,3447000,3467000,0.001),MDSYS.SDO_DIM_ELEMENT(NULL,5422000,5440000,0.001))As you can see, both axis are defined as "NULL" instead of "X" and "Y". Is there any way to tell the writer how to set this up correct?

413
M
8 years ago
M
mikesando
asked in Data
Does FME have the capability of......

Curious question w/ FME making strides in the industry. Does it have capability of extracting lets say a manhole cover using PointCloudStatisticsCalculator (or any other transformer) with an average Z value and intensity?

70
mark2atsafe
Safer
8 years ago
lazarlubomir
Contributor
lazarlubomirContributor
asked in Data
Corrupt shapefile - repair in FME?

Hello,I have problem with shapefile with line features. I can´t read it, because log shows me following info:"The DBF file seems to contain less records than the Shape file"It looks that in shapefile are more features than in shapefile. How could I exctract these problematic features from shapefile please in FME?

1160
P
8 years ago
M
mikeymess
asked in Data
Split single KML into multiple KML files with equal record count

I have a large KML file that I would like to split into several smaller equal size KML. My original KML file has 311,055 polygon records and is too large to open in Google Earth as is. I would like to create several sub files from this file (e.g. 5 KML files with 62,211 records each).

3620
arnold_bijlsma
Enthusiast
8 years ago
A
aidenprice
asked in Data
SQL Statement to Execute Before Translation Double Encoded

Hi,Not sure if this is a bug. I've found that the PostGIS writer's SQL Statement to Execute Before Translation can accidentally double encode the SQL such that it results in a fatal error on trying to write.As a process;Enter this SQL code in the advanced editor (by clicking the elipsis button on the writer's Edit Parameters pane);FME_SQL_DELIMITER ;DROP INDEX IF EXISTS "TEMPSpeciesSightings_Catalogue_Number_Index";DROP INDEX IF EXISTS "TEMPSpeciesSightings_Conservation_Index";DROP INDEX IF EXISTS "TEMPSpeciesSightings_Date_Modified_Index";DROP INDEX IF EXISTS "TEMPSpeciesSightings_Spatial_Index";DROP INDEX IF EXISTS "TEMPSpeciesSightings_stateConservation_Index";FME encodes this to;FME_SQL_DELIMITER<space><semicolon><lf>DROP<space>INDEX<space>IF<space>EXISTS<space><quote>TEMPSpeciesSightings_Catalogue_Number_Index<quote><semicolon><lf>DROP<space>INDEX<space>IF<space>EXISTS<space><quote>TEMP

120
A
8 years ago
Y
yro1958
asked in Data
Comment convertir du PNG 32 bits en PNG 8 bits ?

Ou comment changer la profondeur de codage d'une image (série d'images). Trouveé aucun transformer qui fait ça !

380
david_r
Evangelist
8 years ago

Badge winners

Show all badges
30,470
Posts
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.