Using readers and writers to extract and load data.
Recently active
Hi,Would like to assign color to elements through colorbookIn AutoCAD Instead of Index Color, I would like to assign Color(ColorName) from the ColorBook (.acb file)I am not able to find FME attribute where I can set this value.Please suggest.RegardsZubair
FME 64bit hangs reading or writing to Geodatabase SDE (Oracle). I have ArcGIS 10.2.1 with background processing installed? When I run the workspace it hangs. Why is it hanging?The two last lines in the log file are:INFORM|An ArcGIS license is already checked out. The product checked out is 'Advanced' 2016-09-19 INFORM|Installed ArcGIS version is '10.2.1'
What happened to the Autodesk GIS Design Server (VISION) GINA(General INterchange and Archive) file format in FME 2016
My workbench uses an s3downloader to acquire a DWG, then uses a FeatureReader (Autocad DWG) to read in model space data, then I add a few layers to model, using a FeatureWriter (Real Autocad DWG) with original DWG as a template, and finally upload updated model to s3, using an s3uploader.The workbench completes without any errors in the log, but my updated model does not contain any of my original layers. It only contains the newly added layers. Further, the log states the following, "No AutoCAD Template file specified". Yet, the FeatureWriter has a template file specified (I save the template file as a parameter).Any thoughts? Thanks for your support!
Hi,I'm now working at Stedin, one of the Dutch electric and gas grid operators.I'm trying to do some analysis of land rezoning using the Dutch national development plan. Basically I want to checking if agricultural land has changed to industrial or residential use. The data is available to download from PDOK; however the GML file available (Enkelbestemming.gml) is 6Gb. I'm able to read and write 1.2 million of the polygon features with FME Desktop 2016.1 but then I get the following error:Error in input dataset:'file:///C:/Apps/Temp/Bestemmingdata/Enkelbestemming.gml' line:43002043 column:24505 message:input ended before all started tags were ended; last tag started is 'gml:posList''Is there anything I can do to fix this file or do I need to contact the data owner which is the Kadaster? I don't have a file editor that opens the file.Perhaps there is a better way to achieve this task?Thanks,Annette
I have a KML transformation workspace that seems to create the placemark (lat/lon) in the correct location looking at the text of the KML, but when it renders in Google Earth doesn't appear in the correct place. Has anyone seen this before. I have attached the KML. The icon should be placed on the final position of the aircraft which is close to Riverside Airport. Instead it places it closer to the beginning of the flight.
Hi,I'm trying to write existing features into a relationship class with the new SDE writer. My source and destination features already exist, and I want to populate the relationship class with the known PK of each features, but it seems impossible with this writer. I follow this article : https://knowledge.safe.com/articles/28340/working-with-geodatabase-relationship-classes-atta.html, but it seems we can only write to relationship class if we also write the corresponding features in their tables.Is there any way to write to a relationship class like a regular table?Thanks
I am currently translating from Microstation and want to take attributes from a cell and a text node and combine them to output one object. The cell and the text node do not know each other so I am guessing a neighborfinder will need to be used. I have been struggling on how to get it all done and was hoping for an example :)
I find that when I add a featurewriter to my workspace and try to open the settings FME crashes. How can I find out what is causing this? I can add another writer to the workspace, but it crashes when I try to get into the settings.It is a relatively decent size workspace with about 10 readers/writers and just over 140 transformers.
Hello,Is it possible to create a new schema in a PostGres/PostGIS database using FME?Thanks
I have around 1300 las (lidar) files. For these las files i have a few shp files with breaklines and polygons where i should remove the ground. (houses/lakes/rivers)I need to export contour lines for each las files using breaklines and also remove the ground inside those polygons.Each block should have a buffer around them to fix the problem on the edge.So i need to load each block with the buffer around it and generate contours after removing the ground and also to use the breaklines.But here is another problem. i need to drop the lines first and filter them out base on z difference of each vertexes and keep only the original line that fits the z difference.Now what i know to do so far (on a single block):i manage to filter the lines. is there a transformer to simply this? right now i compare each line start z and end z against each otheri know how to generate contours with breaklines.i know how to remove points inside polygons.i know to create a buffer around a tileWhat i don'
Hi!I'll try to describe my situation first: I heed to transfer data from an old database (DB) into an ArcSDE-DB (based on Oracle). In this old DB, I have feature classes (FC) that have many-to-many relations with each other. These relationships, however, are stored in a single FC in the following way: 'Origin_FID | Origin_FC | Destination_FID | Destination_FC'. I transferred the FCs into the ArcSDE-DB, enabled archiving and created N:M-relationship classes (RC). By using FME, I want to write the relationships from the FC in the old DB (filtered according to the respective FCs) into the RC of the new DB.The data and relationships have to be written not only als an initial, "complete" load, but also regularly in the form of incremental updates.My actual problems: On this FME-page, I've found a way to write data into relationship classes. Unfortunately, according to this tutorial, the ObjectID (in the form of geodb_rel_origin/destination_oid) must be present. In
I'm relatively new to using the ArcGIS for Server Data IO extension and I have experienced an odd behavior, that I think is unintentional:We have created an ETL tool in Workbench. The tool can read multiple shape files and converts them to different featureclasses in SQL Server. The input is set as a user parameter.When running the tool in Desktop (ArcMap) the input dialog automatically filters the file types, so the user will only sees the *.shp files in the directory he browses to. Different *.shp-files are selected, and the tool converts the data as expected.We then publish the tool as a service on ArcGIS Server (10.3.1) with Data IO extension. After publishing, the tool (GP-service) input dialog is opened, but now you'll have to specify all parts of the shapefile (shp, dbf, shx) in the directory - otherwise the tool will fail. This is not very convenient to an end user that could easily mistake something in the directory browser...Am I missing something here in my setup/con
Hi everybody,Anybody knows why if I have a map in V8 of 712 elements , the indicators of FME indicated that in the conversion has been converted like 14.000 ???. The ouput is correct only there are 712 elements but in FME appears that 14000 has been converted.The conversion is from V8 to V8.Thanks in advanced for your help !!
Hey,i try to write some Features with two Attributes A and B into an excel-sheet with an Excel Writer.It allready works but I want to write the Name of the Attributes into the first row of the sheet, so that it looks likeA | B1 | 32 | 23 | 4... | ...Is it possible? Thank you for your helpNicole
Is it possible to generate an empty ffs file?I have a data conversion process where some optional datasets used in a workbench might not exist. I do not want to use the Ignore Failed Readers option, as I want the translation to error-out if the required datasets are not present. A predecessor workbench will normally generate these optional ffs files if the input exists, but if no input exists, no ffs is created. I cannot find an option for the workbench to write the ffs file even when it has no input. I could also potentially copy an empty ffs file into the expected reader location, but I cannot figure out how to generate an empty ffs file.Or could this be handled a better way?Using FME Desktop 2016.1.1.0
I've created a simple workspace that streams tweets, does a point in polygon and and writes results to a CSV file. Now the Tweetstreamer is a perpetual streamer - i.e. it requires manual intervention to stop. The problem is that the CSV writer appears to flush all the writes only after correct completion of the workspace. If the user manual stops the workflow (as required by the Tweetstreamer) the CSV writes are not flushed and data is lost. Is there any way to automatically flush the CSV writing after each record (or another workaround?)
I have two sql tables. One contains inspection records as shown:The other contains questions for each inspection as shown:I need to combine these and put them in access as such:InspectionID; InspectionName; Date; InspectedBy; Old_Spill_ID; Spill_Type; etc.Any help is much appreciated!
Hi ,I have elements of kind measure ( formed by a line/s and text) , anybody knows what geometry is this ??? the input give me it like lines , but the text disappear.Thanks in advanced for you help.
I have problems to get the right idea to write an excel sheet Maybe for you an easy one. See screenshot: i will write an excel sheet..row names like Attribute names and one column for each element_index? how i have to set the params?Thx and greetzFranco
Hi CAD Experts!Is it possible to create groups on features that are written by ACAD Writer? I'm investigating capabilies of FME in this field. Find attached two files that indicate what I'm trying to archive. File demodata-layer.dwg shows the initial situation. I'd like to combine all lines of one building into one group. File demodata-group.dwg presents the desired result. The groups were formed interactively in AutoCAD to show the principle feasability. Within my wokspace I'm having all needed attributes to form groups upon them, so it's really a question of implemented functionality of AutoCAD Writer.
Good day!Does FME password parameter into SDE Reader/Writer sensitive to symbols?I encountered a problem with SDE connection parameters. Some of our SDE connection passwords contain one parenthesis. And when I try to connect via SDE Reader/Writer with parenthesized password value I have an error message: 'Unbalanced parenthesis encountered on line 13 of file ***** -- line was `"DEFAULT_MACRO" SDE30_IN_PASSWORD pas(sword'Program Terminating'I've never seen this error before in previous FME version (2013), as I remember...Does it is really and is it an innovation?Thanks)
Edition: FME Oracle Edition (node locked-crc) Version: FME(R) 2016.1.1.0 (20160722 - Build 16609 - WIN64) Locale: en_US Codepage: 1252 (ANSI - Latin I) Registration Key: 1-628-344-195 Registration: Evaluation License 361 days left Serial Number: NBGL-UEC6-12L8 Customer Number: 95780 Home Folder: C:\\Program Files\\FME\\ Operating System: Microsoft Windows 10 64-bit (Build 10586)I am converting some linear data in an ESRI File GeoDatabase to GML using the GML SF-0 writer. I then load that data in to SQL Server 2012 for conversion into geography instances.The FME data has namespace prefixes for every tag:<fme:FeatureCollection xmlns:fme="http://www.safe.com/gml/fme" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:gml="http://www.opengis.net/gml" gml:id="id78f185fa-6116-47e5-b873-8d66e48aa1dc"> <fme:featureMember> <fme:Roads gml:id="idd3bb702b-f7a7-4207-ae24-f509a17
Hi everybody ,In a part of my FME process I do a copy of a input V7 DGN , but when I look in results I always have the same result ,all the element in level 1 and color 20 , don't takes the attributes of the input.Finally , to test I'm doing a direct copy , conecting the input V7 directly to output V7 , and the result is the same.Any idea?? , thanks !!
FME Configuration: No destination coordinate system setIFMELine was given memory that was NULL or invalidA fatal error has occurred. Check the logfile above for detailsKML: Error finishing writing datasetProgram Terminating