Data

Hy I want to know if it is possible to georeferencered the PDF before to use the PDF reader to obtain in the output a DWG or Esri GeoDb with the correct coordinates system thxFrancesco

I am trying to add geometry columns to a postgres instance on FME Cloud and I am getting this error.ERROR: function addgeometrycolumn(unknown, unknown, unknown, integer, unknown, integer) does not exist LINE 35: SELECT AddGeometryColumn('cad_qa','WATERLINES','geom',2277,'...Here is the select statement, it is from an FMEpedia github project,SELECT AddGeometryColumn('cad_qa','WATERLINES','geom',2277,'LINESTRING',2);

Hello,I need to work with OSM PBF, but in FeatureReader tranformer in version FME Desktop 2018.0, there is missing configuration file parameter (e.g. INI file) for OSM PBF. But in version 2017.1, as you can see below, the parameter is there...Why is this paramater missing? If it is purpose, how can I solve substitution of configuration file?Thank You so much!Lubo

Hi,I have a FME Server and I would like to use jobs function. But the my workbanch is not working in the fme server. Normally it is able to work from fme dekstop. Server says that there is no defined Coordinate but I have. ITRF96 was added as custom. My question is how han I fix the problem.***********************************************************FME API version of module 'NULL' matches current internal version (3.8 20170315)MULTI_READER(SWORLDSWAF_5): Done reading 0 features from 2 readersCreating reader for format: Smallworld 4/5Trying to find a BUILTIN plugin for reader named `SWORLDSWAF'Trying to find a DYNAMIC plugin for reader named `SWORLDSWAF'FME Configuration: Source coordinate system for reader SWORLDSWAF_6[SWORLDSWAF] set to `ITRF96'Coordinate system named ITRF96 does not exist.Failed to get parameters for coordinate system `ITRF96' -- No definition was found for coordinate system `ITRF96'This FME edition does not recognize the `SWORLDSWAF'

I am reading in shape file and using attributepivoter to calculate stats. I then write the results to a separate excel sheet for each source file. After the attributepivoter I can no longer assign the source filename (fme_basename) to the sheet name in the writer

I have a MIF file with no matching MID file (attributes) which is intended to store purely geometry. I am able to drag it into my FME work space but when I run, it complains that the "...*.mid is missing"  I can get around this my importing the MIF into a TAB in MapInfo but is there a way FME can read in a MIF on its own?

Hi everyone,We use the FME Exporter for Revit but we have a lot of Revit files to convert. Do you know of any way to automate / script the export from .rvt to .rvz so it can be ran as a batch processing ?Thanks for your helpMat.

Hi! I'm trying to import some CityGML to Infraworks via the quick translator. I'm getting errors that seem schema related, and I saw when I colleague used the full trial so that he could see the workspace details, that the schema seems not to be defined. Is that possible? In the log file I have:2018-03-21 10:16:07| 1.4| 0.0|INFORM|mapping file Keyword: `CITYGML_1_ONLY_FEATURE_TYPES_IN_DATASET' occurs 1 time(s) 2018-03-21 10:16:07| 1.4| 0.0|WARN |UniversalReader -- readSchema resulted in 0 schema features being returned 2018-03-21 10:16:07| 1.4| 0.0|ERROR |The XML Module halted on error, see the logfile for details 2018-03-21 10:16:07| 1.4| 0.0|INFORM|Closing the SCHEMA Reader 2018-03-21 10:16:07| 1.4| 0.0|ERROR |The XML Module halted on error, see the logfile for details 2018-03-21 10:16:07| 1.4| 0.0|INFORM|Translation FAILED with 4 error(s) and 54 warning(s) (0 feature(s) output) 2018-03-21 10:16:07| 1.4| 0.0|INFORM|FME Session Duration: 2.0 second

We used this article (https://docs.safe.com/fme/html/FME_Server_Documentation/Content/ReferenceManual/Directory-Account-Permissions.htm) to give permission to write files to the Data file in resources, which was successful to write to that parent folder. We then created subfolders in the Data folder through the web interface for different processes we have. The subfolders say that the owner is 'root' and therefore the fmeserver service account does not have permissions to write to that folder. Is there a way to make it so any subfolder will get the same permissions as the parent folder?

I need to use an FMW script to extract xyz files from a single netcdf file. When using the data inspector, I see that the netcdf has several variables and multiple bands of data for each variable. Ultimately I am desiring the u and v datasets. I feel like I am close with my FMW file, but somehow it is not extracting the u and v datasets correctly.My steps thus far are as follows:1. Open FTP directory: ftp://ftpprd.ncep.noaa.gov/pub/data/nccf/com/rtofs/prod/rtofs.YYYYMMDD/ (you need to adjust the date characters YYYYMMDD)2. scroll to bottom and open the rtofs_glo_uv_YYYYMMDD_hcasts.nc.gz file3. use gzip to uncompress the file: gzip -d rtofs_glo_uv_YYYYMMDD_hcasts.nc.gz4. Open FME Workbench 2015 (I only have 2015 desktop)5. Open FME script (attached here) 6. Provide input parameters:SourceDataset = rtofs_glo_uv_YYYYMMDD_hcasts.nc (netcdf file that was downloaded above) DestDataSet = C:\\The expected output is to have a u_velocity and a v_velocity xyz file. Each file will have the follo

Hi, I am writing to my database (SQL Server Spatial) and would like to in this case, overwrite the automatic sequential numbering system that SQL Server gives each attribute. Any idea how I would go about this?

I get this error while writing from SDE to PostGIS. The job runs forever and doesn't do anything.The specified coordinate exceeds the valid coordinate rangeIt has around 20K features. The features doesn't even read through inspector. But if I update the filter to have around 10K features, it does write.There is no issue with the features for sure. Just wondering if there is any limitation from SDE? I haven't seen this before and definitely it worked before for writing more than 100K features.Thanks

I can't figure out how to use a mongodb writer to update existing documents (specifically, I want to insert new elements in a list within the existing json structure)  I don't even see any parameter to set the writer to update or upsert.

I have a workspace that is using a polygon drawn by the user to search multiple layers, write a html report and email the html report to the user. The html report is generated using the htmlreportgenerator, htmllayouter and writehtmlfile. The workspace is run in FME server.In the workspace, I'm saving the username, email and polygon to a SQL database to keep a record of what reports are run. However, I would like to be able to save the html report to the table as well so that it can be retrieved to see what results have been provided in the report. It would not be possible to rerun the report as the data changes and it is important to see the data results as it was generated for the user at that time. Is it possible to do this and if so what attribute type would you use to write the the html output to the SQL table?If this can't be done, does FME server save the output of the workspace somewhere? The HTML report would have the date and time appended to the report name so

Hi,  I have about 50 feature classes in a geodatabase. In the feature classes, some of the field names are the same but a lot are different.For example: in one feature class field names are – Sample_ID, Easting_NAD83_UTMz19, Northing_NAD83_UTMz19, Au_INAA_ppb, Ag_INAA_ppm, Fe_ICPMS_ppm, Fe_INAA_ppm, Ca_ICPOES_ppm. In another feature class, field names are – Sample_ID, Easting_NAD83_UTMz19, Northing_NAD83_UTMz19, Ag_INAA_ppm, Au_ICPMS_ppb, Fe_INAA_ppm. I want to create a new feature class called “INAA_merged” where every field that contains “_INAA_” will be in it as well as the Sample_ID, Easting/Northing fields. I’d like all the other fields containing for ex: “_ICPMS_” and “_ICPOES_” to be deleted.    So basically I want to merge all the fields together in one feature class that have the same name and delete all the others.    Is this possible? Is there a way to set up conditions for merging – ie to keep certain fields if they contain certain characters and to delete others?

Hello, I am trying to read from a SDE feature class. when I try an add the reader I get the error  "Error while retrieving layer info structure for layer 'shape' in table 'VEG.NONPRODUCTIVE_AREA_EVW'.:SDE_ERROR_CODE(-20) Layer not found"  It the table is a a postgis table with versioning.  I can see the table in my table list when connecting. Any one have any advise?

Hi all,I am doing my first steps with FME.I am trying to parametrize a CSV reader as follow:But parameter is replaced by its value:How to do this? Many thanks for your help!

Hello, I've geoereferenced a raster map using ArcGIS and exported it as GeoTIFF, however, I can't read it properly in FME data inspector, the image appears all black. Have anyone before faced the same problem ? Thank you.

Hi all,I am doing my first steps with FME.I am trying to read a MongoDB collection using the Mongo reader. To retreive the unique document identifier _id, I use the mongodb_id format attribute. Is it correct?Then when data are loaded, this attribute does not seem well encoded: Id (encoded: utf-8): ??{y?q?M????z?'How to fix this? Many thanks for your help!

Hi,i want to geocode addresses by my own ArcGIS Server geocoding service. The adresses are in a csv-format. In a second step I have transform the adresses from csv in to JSON. After that i want to get the geocoded adress via the HTTP-Caller because it is not possible to post adresses via the Geocoder-Transformer in the JSON-Format.It doesn`t helped me to post the address in a single LineString.Can anyone help me to geocode the adresses?

Dear All,I have an issue while using Dissolver and Aggregator I get multiarea of 5 polygons, which look merged in the Inspector. But when writing to PostGIS, aggregated geometry is split again into separate polygons. PostGIS is accepting only polygons as geometry. I know that if the PostGIS accepts only single polygon, but writer attempts to load a collection, then a collection will be split. The question is if there's a way to aggregate multiple polygons into one without collection. Single polygon needed only to set the extent of the layer, so envelope like feature will do as well.Thanks a lot for your answer.

Hi! I received an IFC file from a costumer and when I tried to inspect the file in Data Inspector, I received the attached error message. I don't know much about Revit so I'm at a lost. Any help to what this means, would be greatly appreciated! Thanks,David

Hi,When I try to open a workflow file that has a PostGIS reader or writer FME Workbench crashes immediately, without any dialogs or crash logs. This happens whether I open the file by double clicking, right click "Open with...", drag and drop the file or "File > Open".Similarly, if I try to open a PostGIS table in the data inspector it crashes too.I can open the database and its tables in PGAdmin so I know the database is up and running.I've just updated to the official release of FME Desktop 2018 on Windows 10 (I've previously been using the beta versions without issues). Thanks,Aiden

Hi I have a set of .asc files. I am looking to use FME to generate a point cloud then build a Terrain in an ESRI's dataset from the asc files. Is this something I can achieve using FME Desktop or do I have an ArcGIS 3D extension license.

Hello,I'm new in FME but have some basic knowledge. I am trying to fetch some data from excel file and use it for analysis and making graphical representations (charts) but I am stuck with the steps much prior to this analysis. Unfortunately, excel file is not very well organized nor structured so I'm trying to overcome this problems and I managed to read some amount of data in structured form.What I'm having problem with is this: excel is organized in many sheet: first (main) sheet has summary data from all the rest of sheets and one column is hyperlink to a specific sheet which holds the data in more detail. I would like that after the running of the workbench I have the ability to choose the specific sheet for analysis based on list of sheets I have already obtained from hyperlinks in the main sheet.I tried to figure this out for the whole day without success. I would appreciate any suggestions or pointers.Thank you in advance!