Using readers and writers to extract and load data.
Recently active
Hi, Could anyone know How to convert (rlc) image format to other format detected by ArcGIS? Thank you, Rawan
How to convert the feature classes stored in SQL Server database to file geodatabase, I couldn’t figure out the best practice to convert the the feature classes stored in SQL Server database to file geodatabase. Thank you Best Jamal
“Replacing” the results obtained from the workbench with the existing ones, I wanted the outputs of the workbench to be replaced with the existing ones. This works fine if the “table handling” is set to be “truncate existing”. However, if the “no existing” data is available, then the workbench fails to write the outputs. Is there an option that can “replace” and “create” (if no existing data is available) the outputs? Thank you Best Jamal
Converting ESRI feature classes saved in file Geodatabase to shape files (in one folder), I couldn’t figure out how to convert ESRI feature classes saved in file Geodatabase to shape files (in one folder) The file geodatabase is saved here http://www.mediafire.com/download/6x08lo3h64o0pz8/H.gdb.zip Thank you Best Jamal
Hi all, Is above question possible? I try to use a parameterfetcher like this: @Value($Iterationcountattirubte) but it is always missing, at each itereation. Can this be done using python or tcl (like some GetMacroValue) or something. Or is it simply not possible? The logger seems to report the count, so should it therefore not be accesible?
The need to add *.gdb before storing each CAD layer in single feature class in it, I wanted to convert each single layer of AutoCAD into a single feature class stored in one geodatabase. The gdb destination is added to the workbench but with no use as it appears in the screenshot below. Is there a way to delete it from the workbench while still be able to store the feature classes in it? Thank you Best Jamal
The need to creating *.gdb before converting dwg files to ESRI feature classes, I couldn’t figure out if I need to create first *.gdb I order to be able to convert dwg files to feature classes stored in file geodatabase. Does this mean that I need to have ArcGIS, for example, installed in my machine to do so? Thank you Best Jamal
OK this has been asked before but the answers I've seen did not resolve the issue. Has anyone encountered this error message when running FME Server? Unable to perform any licensing related tasks. This is a 64-bit version of FME which requires a 64-bit version of ArcGIS Server What makes this strange is they are both 64 bit versions. Is this an ArcGIS setup issue? Any help would be greatly appreciated. Thanks! Tony
I need to build a list of new records that have the NEXT value for an alphanumeric primary key attribute. Thus, I need to fetch the largest value ( in the form 'ADR000xxxxxxx' where "xxxxxx' is a strictly ascending list of non-zero intergers) from one feature class and populate another (temporary) feature class starting with *that* value +1 . Thus, let's say my ADDRESS feature class has the largetst MXADDRESSCODE = 'ADR000521327' And I need to create, for instance, 4 more records. So I need to fetch the above 'ADR000521327', add one to the first, making it 'ADR000521328' and continue with 'ADR000521329, 'ADR000521330, etc. in my temporary feature class named ADDR_WORK. I have looked at Sorter, ExpressionEvaluator, AttributeFilter, StringConcatenator, and others, but just can't seem to turn the corner on this one. Thanks
I'm trying to retrieve photos stored in a non-spatial SQL Server table in a varbinary(max) column, input37_bin: The photos are JPEGs, and the varbinary column is recognised by FME as a field of type IMAGE. I connected a RasterReplacer to the attribute with JPEG format but get "not recognised as a supported file format" Any ideas greatly appreciated. Ian
In the workbench below, I wanted to collect the “Boundary” and “Buildings” layers in two feature classes in the same file geodatabase. What the workbench does is that it combines the “Boundary” and “Buildings” in the same feature class. How this issue can be resolved? Thank you Best Jamal
Hello All, FME workbench to transfer data from mdf “Enterprise geodatabase” to gdb I am trying to develop a workbench that will be able to replace the existing data (FC,Tables,Datasets,…) in a File geodatabase “gdb” by the one coming from the mdf “Enterprise geodatabase”. Is this can be done using FME ? if yes how can I start ? Regards, Ahmad
I'm trying to setup a FME workbench process that will run daily which will read a series of text files from a network directory, and load it into a a database. The header of the text file contains information about the sensor, including a georeference. The body of the file contains readings for every hour of the day. My aim is to create one database table containing the sensor information, and another table containing the readings, with the primary key being the sensor id. SAMPLE FILE Filename: 55_22_20130626_2359.txt Sensor Id: 55.22 [SEQUENCE] REVISION=1.0 [DESCRIPTION] ID=55.22 DESCRIPTION=Bypass Loop, Central Tunnel GEOREF=WGS84,-33.865977,151.205619 INTERVAL=60 QUANTUM=READINGS [55.22]:STARTS 20130626,00:00,40 20130626,01:00,37 20130626,02:00,27 20130626,03:00,19 20130626,04:00,16 20130626,05:00,29 20130626,06:00,30 20130626,07:00,19 20130626,08:00,24 20130626,09:00,26 20130626,10:00,33 20130626,11:00,34 20130626,12:00,42 20130626,13:0
Hi All, I am tring to build a model that would delete all the existing tables, Feature classes and Relationship Classes in a SDE geodatabase and then copy new data from another geodatabase. is there a tool that i can use to delete the actual tables and not the records in those tables? and a sub question, is there a way to create/update/delete domains in SDE? thanks you!
I have been asked to make a 3D model of some buildings for use in Sketchup I have Ordnance Survey building outlines with a height attribute and used the extrude transformer to make a model. The problem is that we need each building to be individually selectable/editable but the file i created merged them all into one thing. How can i extrude to individual buildings in one model? Since I dont know how to do it in Sketchup so thought I would try in FME as it seems to have a lot of 3D tools (i tried using the fanout in the feature properties but this made a skp file for each building and they werent in the correct geographic location - we dont want this)
This is the second time I report this issue without any solution from FME safe, the issue here is in writing to “FileGeodatabaseArcObjects” after upgrading to ArcGIS 10.3. FME safe keeps saying that the FME 2015 is fully compatible with the ArcGIS 10.3, but in the realty it’s not, trying to use the ArcObjects writer fails to write geodatabases after upgrading to ArcGIS 10.3 while it used to succeed in ArcGIS 10.2.2., so each time I try to use the ArcObjects writer my workbench fails and shows the following massage. “the Esri Product license used by this machine does not include licenses for the 'ArcInfo' licensing level Unable to perform licensing related tasks. Please ensure that ArcGIS is correctly installed A fatal error has occurred. Check the logfile above for details” Knowing that my ESRI license type is Advanced, as well writing to a shapfile for the same workbench works will. So what is the issue here. Regards, Ahmad
I'm reading a GIS (LINE) feature class from an SQL database and trying to output it to a Microstation v8 .dgn.The line style I want to output is a fence pattern. This fence patter is not pre-defined in the DGNStyler. I have set the linetype in the SEED file and set "by level" in the DGNStyler, but no luck? This fence style is not one of the standard 7 dash,dash dot...styles. I'm not sure if I can somehow import that specific style into FME in order to be able to assign it to the output via the DGN Styler, at the moment there is only numbers 0-7 and ByLevel to choose from in FME?.
I want to upgrade our Oracle 11g Database to 12c. Are there any Problems with FME 2013 while reading or writing 12c or is FME2013 full compatible with the latest Oracle version? Is an update to FME2014 nessessary? Has anybody experience with FME2013 and oracle 12c?
I am trying to transpose the output of an Excel writer. I have only 1 row of values to transpose perhaps there is an easier way? e.g field1, field2, field3 vala, valb, valc should become field1, vala field2, valb field3, valc I used the example Transpose2015.fmwt on http://fmepedia.safe.com/articles/How_To/Advanced-manipulation-of-Excel-tables-using-AttributeExploder. However my output attributes are not ordered. It appears the incoming order of the attributes is lost when the AttributeExploder is applied? Is there an easy to resolve this or an easier method to achieve the same? I had a brief look at the ListPivotDemo but am waiting for the database outage to be resolved before I can test. Thanks, Annette
I have images (3584 x 1792 pixels) and I'd like to set the RGB-values to zero for all lowest 300 rows of the images. I've tried this with a RasterCreator (to create a white band of 300 x 3584) and a RasterMosaicker, this works fine. But only one of my input images is being masked. Is there another way to do this? Maybe with the PythonCaller? But I don't know how to loop through the pixels, and change their RGB-values. J.
Hello, I am trying to convert a multipatch shape file to a DXF creating a block for each feature using one of the attributes as the block name. It seems that the DWGstyler only works for points. How can i proceed using 3d geometry? Thanks in advance for your help. Giuseppe
Hello! I am new to FME, so I am sorry if I am asking a too basic question. I have been searching the Interent and reading many comments/videos to try to find the answer. I simply have a drawing in AutoCAD, and I would like to bring this in to GIS as a shapefile. My dwg has points, and each point has one text attribute to it. I can bring in each point fine with FME, but I cannot bring in the attribute text as well. Also, I do not have anything when I expand the node for my dwg file within FME. I thought I would have the attribute in here, but it is blank. Here is what I see. Here is how it looks in AutoCAD. I would just like to bring in the point with the attribute text with it (Fl_#). Here is how it looks within GIS. Does anyone have any suggestions to help me?
I am attempting to insert a .cel from Microstation into a sequal database (GeoMedia) and the cell imports as multiple points evn though I have used the centerpoint replacer transformer? I'm not sure what setting is missing. See below for an example of the input and output. I have also switched the Cell Type: to Point in the .dgn
Having trouble reading OS Open Names. This product is supplied as multiple (headerless) CSVs packed into multiple sets of zipped folders. I want to create a single reader and assign column names.
Hi there Does anyone know why i cant edit the Data Download Service properties? The "Edit..." is greyed out. I have the very simple demo workbench (from samples.zip) - textline input and text output - and need to set the reader to accept HTTP content. But when I go to Publish to FME Server, the Edit.. is not clickable. What reason would there be for that? Many thanks Doug