Using readers and writers to extract and load data.
Recently active
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
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
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|,
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
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.
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,
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.
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.
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
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
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 !!!
Hi, I need the conversion of 3D DWG (including solids, etc.) to 3D DGN. Does your software support this process? (FME Cloud, as well?)
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.
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
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
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?
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)
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
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?
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?
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?
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).
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
Ou comment changer la profondeur de codage d'une image (série d'images). Trouveé aucun transformer qui fait ça !