Using readers and writers to extract and load data.
Recently active
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
Hello,I'm writing out to a text file with Line Termination: Windows. But when I open the text file in Notepad++, the end of line is Unix, except the last line which is Windows:25.000000000000 LF0.000000000000 LF0.000000000000 LF-25.000000000000 LF400012.5 LF1299987.5 CRLFI also checked in TextPad - that's showing "Unknown" end of line. When I open the text file in Notepad, the line breaks are ignored:25.000000000000 0.000000000000 0.000000000000 -25.000000000000 400012.5 1299987.5 Could you please help me?Thanks
Hello, I want to convert DGN file to PDF, but in DGN file are features in white color. I need to change background color of PDF 2D to black color, how can I do that please?Thank You so much!Lubo
Hi I have many dgn files (Version 8) that I am processing and writing again to DGN format. (Tags are read and written)The problem is with the larger files created by FME, when opened in Microstation, there are no element in it (blank file). The same file if I open in Data Inspector, the elements are present and can be viewed.There are no issues with the file less then 3MB.I know there is a limitation of 32MB with mircostation v8 files but my files are less then 15 MBAny thought?RegardsZubair
How can I change something like this:1Chris1Rock2John2SmallInto something like this:1Chris Rock 2John Small Thanks,Submi
What would be the best method of replacing walls from an architectural CAD drawing with a single line. I have tried a few variations with the Generalizer and not finding one that works well. I want to take an architectural drawing where the walls are shown as two parallel lines and replace with a single, much simplified version of the lines that preserves the general shape of the rooms. Preciseness and accuracy aren't that important it is just for visualization purposes.
Similar to FileGDB (https://knowledge.safe.com/questions/1652/writing-relationships-in-esri-file-geodatabase.html) Is it possible to easily write to a relation-table on MS SQL? And other databases? I see the db_relationship does not exist in those formats
how reduce ecw
Hi, I would like to know how i can import multiples txt file currently with 2-3 different formats and export it in csv. Validate it (If is fail to read it or if it succès and make a txt file with result)I have thousand of .txt file in a directory The goal is to convert all in one common format in this case .CSV. The majority of the file are in this format: "/" = SKIP LINE (Good point are without / ) Line begin with number are good On this case i want to extract 127,126,115 Cannot use the header its never have same number of line. //-----------------JOBFILE INFORMATION------------------------ / / Instrument: I 3" R1000 No.: 1610178 / Date: 2016-04-07 / Hours: 09H32 / By: / Job: 60407P3DICF / Description: ; / Location: ; /--------------------END OF JOBFILE INFO--------------------- 127(TAB)1005.4345(TAB)10.2440(TAB)477.0120(SOME SPACES WITH TAB AT THE END);2016-04-07(TAB)##FILENAME## 126 1005.4517 -0.0040 476.9552 ; 2016-04-07 ##FILENAME## 115 10