Using readers and writers to extract and load data.
Recently active
WHAT CAN I DO TO REMOVE DUPLICATED GEOMETRIES .DWG, I use the matcher but the geometries are not being detected as equal, they have differences of millimeters. Is there any other transformer?
I have a json array in the structure[{"name":"A","content":"X"},{"name":"B","content":"Y"},{"name":"C","content":"Z"}]how do I extract it as the name/content (key/value) pair so that end up with a feature containing the following attributes: A: X B: Y C: Z In the actual data there are about 40 attributes, so an automatic flatenning of some sort would be prefered.
Hi, we are migrating mapguide gis using oracle spatial to esri arcgis using sql server. I would like to check if there is a benchmark that can be used as a reference to compute for the loading time?IS there a rule of thumb in terms of number of features, data size?Thank You.
hiI have some data DWG stored in PostGis Database, there is one attribute packed, created by AttributePacker, with all features of the layer, for example line_weight, color in the others. If I use AutoCAD to read Postgis Database, it´s possible to show the colors and the others features stored by AttributePacker automatically?Thank´s
I want to add an image to a Word file. The image has to show a map with road names, house numbers and reserved areas.The map I get from a WMS service. The road names, house numbers and reserved areas I read from our PostGIS database as vector features.I use the "TextAdder" transformer to change the road names and house numbers from vector features to text and use the "VectorOnRasterOverlayer" transformer to create the raster image to use in the MSWordStyler. And I use the "FeatureColorSetter" to set the color of the reserved areas.It works well with the map and the reserved areas - but the road names and the house numbers isn't shown in the map.How do I change the text to raster ?
Hi everyone. I'm researching on how to convert an autocad file drawing to geotiff and found this software but I do not know how does it work. Could anyone help me the basic on how to convert autocad to geotiff?
Hi, I am currently trying to convert a WFS into an ESRI shapefile and other ESRI formats using FME. I am adding the WFS as a reader and the output as the ESRI shapefile. The process runs with 0 Errors however 4 warnings: "Coordinate (approx) 9E:49N outside grid file coverage; no transformation applied.Coordinate (approx) 3E:49N outside grid file coverage; no transformation applied.Coordinate (approx) 3E:61N outside grid file coverage; no transformation applied.Coordinate (approx) 9E:61N outside grid file coverage; no transformation applied."The transaction is successful however 0 features are read and 0 features are written. Any help on how to fix this would be great!Thanks
I have a set of imagery footprints saved as both a dxf and a dwg. I can load the files into FME Desktop fine but whenever I try to inspect or do any manipulation on the files I get the following error messages.AutoCAD Reader: An error occurred for dataset 'T:\\*************.Footprints_v2.dwg', in function AutoCAD2004Reader::buildPolyFaceMesh. Exception thrown: 'Invalid index' (Invalid index)AutoCAD Reader: Unsupported 3D raster feature. Skipping entityI've never worked with dxf or dwg before but I have worked with dgn. Any ideas?
I have data that was imported into PostGis and now I am exporting back to the DWG but I am not able to resubmit the texts. If you use the TextAdder it only exports the text, even though the parameters are KEEP for geometries. Can you help me?
When running the FME Server Installer on a CentOS system that is offline, the installer aborts with errors similar to the following:No matching distribution found for numpy No matching distribution found for matplotlib scriptlet failed, exit status 1
I'm having some difficulties converting a GML to KML/KMZ while using the automated Generate Workspace. I've tested GML with https://mygeodata.cloud and it converts properly, what setting is missing?I've attached the GML, KML produced by FME and KML produced by MyGeoData.cloud
Hi Guys,I have an ETL which writes to a Postgres database, before the writer begins the translation I would like the writer to run a script in Postgres to backup the database schema (including tables and indexes) as either a backup or sql file. I can run a script to backup/dump the entire database however I would just like to backup the schema.Creating a backup of the schema using the pg dump utility within PgAdmin 4 looks something like this--file "P:\\\\FINANCEBBK.BAC" --host "myserver" --port "5432" --username "postgres" --no-password --verbose --role "postgres" --format=c --blobs --encoding "UTF8" --schema "finance" "mydatabase"Any help greatly appreciated,Chris
How to write data in Postgis with the same color as DWG, after recording in postgis the recorded data comes out with the same color.
Hi, I was wondering how I can remove the point that is generated with the text in the Labeller and/or LabelPointReplacer transformers? I want to generate contour labels but I don't want the additional point.I am using FME2018.0 Desktop.Thanks,
Hi all,This is the first time I try to read WFS datas and I got some trouble.When I got to the parameters, eveything appears to be fine :Then when I tried to read it , this happened :The whole error text is : ERROR |XML Parser error: 'Error in input dataset:'http://wxs.ign.fr:80/---cryptedkey?---/geoportail/wfs/?SERVICE=WFS&VERSION;=2.0.0&REQUEST;=GetFeature&TYPENAMES;=ADRESSE-PREMIUM.LIEN.HEXA%3Alien_adresse_hexa&NAMESPACES;=xmlns%28ADRESSE-PREMIUM.LIEN.HEXA%2Chttp%3A%2F%2Fwxs.ign.fr%2Fdatastore%2FADRESSE-PREMIUM.LIEN.HEXA%29&OUTPUTFORMAT;=application%2Fgml%2Bxml%3B%20version%3D3.2&COUNT;=30000' line:6 column:3 message:expected end of tag 'hr'' ERROR |The XML Module halted on error, see the logfile for detailsERROR |A fatal error has occurred. Check the logfile above for details I guess that there is a problem in the XML, lacking something in it. When I ask the data provider, they say that can open it with no troubles ... so here I am, a
I'm attempting to use the standard javascript web socket to subscribe to the FME server web sockets endpoint.I'm simply doing: this.socketConnection = new WebSocket(webSocketUrl);That^ code connects to the web socket on FME server but never receives or sends messages. Am I meant to include a protocol? Does anyone know why messages would not be coming through or not be sent?
Hi: I'm new to this forum and just found out about FME. I was curious if there was a way to use FME to create a workflow that allows you to update changes to a .mxd in ArcMap then have the changes update to a .dwg in AutoCAD. Or at the very least make the process of transferring over pt/line shapefiles easier to AutoCAD for .dwgs that need regular update maintenance. In particular I'm thinking of a city/municipality utility map where changes are made on the ArcMap side then translated to the AutoCAD side (or vice versa as many engineering firms tend to create construction/as-built drawings with AutoCAD). Any thoughts?
I'm hoping someone can point me to a step-by-step article or post on how to use LiDAR from 2 different years to detect changes in topography. I've found this Q&A; Forum answer...https://knowledge.safe.com/questions/2487/lidar-feature-extraction.html... but it's sort of a broad-strokes overview of the process, and not detailed enough for me to do anything with, having never tried this before (on any platform).Thanks for any help you can offer!P.S. - My organization is using FME 2016.
Hi,I have a workspace with an Reader (SDE Connection) writing to multiple different zipped folders before a FileCopy Writer inserts a common disclaimer into each zipped folder. I want to use the FileCopy FeatureWriter due to the output port would then allow me to connect to a S3Uploader transformer and simplify my workspace down from 2 to 1.I however receive a error of: Cannot have multiple factories with the same name. Multiple factories were assigned the name 'filecopy_FeatureWriter-FileCopy_d4291b7d_cbed_4650_990f_3e25feda4a160'Am I missing some parameter setting or is there some workaround using the FileCopy Reader that allows processing after the disclaimer insertion?
Hi all,we are company that interested in using FME products. Main issue that we are blocked in current process is DEM generation. We compare results with Civil 3D and failed to tune FME workbench to get comparable quality. As I understood FME has only 2 settings for DEM interpolation: planar and constant. Planar gives us better results, but still interpolation doesn't seem good enough. It is not accurate. Ive attache some synthetic file that we use for quality assurance. And results from FME and Autocad Civil3D. Another question is what should be best input format for such operation, our pipeline set to work with 3d edges, but may be TIN would give better quality? May be anyone solved this task in the past to move process of DEM conversion of TIN from Civil3D to FME?Here is file that I am working with and results: files . Basically I dont understand why FME give so big difference in elevations and why it is not symmetrical for pyramids.
I have two files a csv file and an Excel file with 4 worksheets, I need to compare the two files to see if all records in the Excel file with all sheets are present in the csv file, there is a particular column in the Excel file, it is a string e.g. 'ff_abcd_12345', I need to get everything apart from the numbers from this and compare it to a field in the other file. There are thousands of records which need to be compared, all I need to do is check if the record exists and report it as matched or unmatched. Any ideas on how I deal with this will be much appreciated.
I have a workbench which writes individual objects to multi page PDF. The page number is defined using 'count' and assigning a 'group' which is then used after the PDF PageFormatter to specify 'pdf_page_number. However I now need to have 2 objects per page. Can anyone advise how I can group these automatically into groups of 2 to write per page?
I'm working with a client who has Bentley ProjectWise on-premise. We're trying to connect to that using the ProjectWiseConnector but we're having trouble figuring out the base url. pw:\\\\[servername]:[Repository] seems to work on the browser, but not in FME.Has anybody else done this before?
When trying to upsert a large dataset I get the following error: Socrata Writer: Failed to Execute `""C:\\Program Files\\FME\\jre\\bin\\java" -Xmx1g -jar "C:\\Program Files\\FME\\plugins\\socrata\\datasync.jar" -ph true -sc "C:\\Users\\dmingl\\AppData\\Local\\Temp\\FME_1533665505412_4848\\control.json" -i u8yq-kcrr -c "C:\\Users\\dmingl\\AppData\\Local\\Temp\\FME_1533665505412_4848\\config.json" --userAgent "FME/2016.7.23.16717" -f I'm using DataSync 1.7
Hello,I'm totally new to FME and learning from scratch and I've already did some coordinate system transformations (fomr xls to xls and dwg to dwg), but now I'm trying to transform a list of point from an excel file(name, x coordinate, y coordinate) into a dwg with a dwg template for the point name.Now the points creation is easy but the problem is with point name that should be as a "block reference", just like the one in the template.I'm not even sure if it DWGStyler is the right choice.Can anyone help me out?Thx.templateworkflow