Using readers and writers to extract and load data.
Recently active
Hi,While writing to the writer transformer(database), if it is failed in between (after writing 1000 features), then i need to take backup before starting the process and write this to the database..Please suggest any solution.Cheers,Srikanth Dasari
Hi,I have an issue in writing a GeoBorder feature in AIXM5.1 with the XML_Templater:When i try to write the geometry <aixm:border> in the GeoBorderTimeSlice, it writes two records <aixm:border> and it only needs one record.I used a XML_templater transformer to write the xml because i have to write <gml:geodesicString> in place of <gml:linestringsegments> ( this one is given by the GeometryExtractor transformer but i don't need this form of writing at the end of the process)I send you my work project.If you have any idea about this issue and how to solve it, your help will be appreciatedThanks to all
When loading ESRI shape files into ArcSDE using ArcGIS tools (such as arcpy), the processes usually seamlessly bypass some errors and complete the load. Those errors can include both geometry and attribute errors. However, when using FME to do the same data flow, the process will stop on any errors. Some of the geometry errors can be fixed in GeometryValidator, but some not. I just ran into a shape file which has a row with an invalid attribute value in the dbf file. When loading in ArcGIS, this row is automatically filter out without giving any warnings or errors. But when loading this shape file to ArcSDE in FME, it gives an error, and stop the FME process. Is it possible in FME to force bypassing data errors in loading shape files into ArcSDE? The ESRI shape files and file geodatabases have wider tolerance for geometry and attribute incompatibility or poor integrity, but ArcSDE (Oracle) has more strict rules. This has been a major issue in my converting python arcpy data loading scr
converting oracle geometry from one projection to other using FME desktop 2014 sp2 version.While doing so ,some of the arc segments (3 vertices) automatically gets converted to linear segments with (~ 30 to 40 vertices) . How can we avoid this ?Is there any parameter to disable these type transformations ? (req : Arcs segment need to be maintained)
Dears,any one please let me know FME can handle Oracle Nested tables reading and writing ??If Yes Please help me.
I have a GIS application using postGIS database . For some reasons i have to migrate from postGIS to oracle . And i got familiar with your awesome software Migrating from a shape file to oracle is all right but when i am trying to convert data from postGIs to oracle, i have issues in converting geometry data , actually the source SRID is 4326 but when the convert is done , the geometry column is not in the right SRID and GeoServer is unable to load geometry data . I tried different methods in converting data such as 1- select SRID from source and 2- using EPSG 4326 on Oracle writer SRID but i still have the same problem
Hi I am using FME Cloud. Please can you let me know how to access \\Server\\fmeEngineConfig*.txt to change the value of FME_RESULT_LIFETIME Thanks Mark
Hi, I am trying to do a simple conversion of my DXF file to KML. I do the following steps:1. I launch Start > Generate Workspace.2. Select format "Autodesk AutoCAD DWG/DXF" in Reader and give path to my DXF file, and add some coordinate system.3. Select Google KML format in Writer and give output file path.4. Click Ok. and it shows some input and output boxes directly connected to each other.5. I click RUN. In the terminal I see Success in the end and the file is created.6. I open the KML in Google Earth.In Google Earth I see whole earth covered with KML lines.Can you guys help me with this please? I am using FME workbench 2017.1
Hi,Could you please help me on how to read a zip file which contains multiple shape files and write to a multiple feature classes.Cheers,Srikanth Dasari
I have an AutoCAD drawing with some polylines and other types of objects and I converted the whole drawing to KML file.Text have embedded hyperlink to external AutoCAD sheet sets. When conversion is completed polylines also contain hyperlink which I do not want/need.How can polylines be opted out from having embedded hyperlink. Should I use Tester or GeometryFilter or maybe something else. I do not see polyline option in GeometryFilter , is Line option gonna work?Thank you
I am trying to concatenate a string for a path of a file that will be placed into:fmeserver/resources#/FME_SHAREDRESOURCE_TEMP. When I am into StringConcatenator I set up the string as a FME Server Parameter and click on OK and save the whole workspace. When I open the transformer again FME desktop sets the parameter as public and is highlighted in red (of course I do not have a public parameter called like that). Is there a way to prevent FME Desktop to take its own decision to change the setting of the transformer and pick up the user choice? I am working with a cloud instance of FME Server.
Hi,I want to use the source dwg as template so I'm copying the source dwg file with filecopy.Is there any way to clear the contents from the copied dwg file either thru FME/python. I have to place the same in the same work bench.Thank youPratap
Hi, I got the below error after running the same workspace that I have been running for months. Any help is appreciated. thanksComplete Error Message:"Plugin 'FM0' was loaded, but a reader could not be created. Error was #913823: This format is not supported by this edition of FME"
Dear Supportteam,I am trying to export smallworld data into ESRI shape files by using FME. I created workbench by taking smallword as reader and ESRI shape file format as writer.While click on run it is created .shp and other supported files.But it creates only Attribute filelds without data. The data is not expoerted into shape file.Request you to please provide detailed steps to exporting smallworld data to ESRI shape.Actually i followed "Smallworld-Pathway-Training-2015" documentation for creating workbench.But the data is not getting exported. I m trying it on Cable dataset. Thanks in advance.Thank you.
The project I am working on requires that I take geotiffs and compress them using JPEG compression method at a 75 level as well as write them to another projection. The problem is that when I remove the Alpha band (JPEG Compression doesn't support more than 3 bands) it leaves a black border that would normally be transparent with the alpha band still attached. I could use the LZW compression method, however the size difference after the compression is fairly significant, in comparison to the JPEG compressionIs there a way to insert back in the Alpha band to keep the black border transparent or even a way to clip the black border after the compression. I should also mention that the black border comes from when the image is projected and slightly turned. Any help would be appreciated!
I'm not sure how the FeatureReader is working when using the spatial filter on Oracle SDE data. I see the following entry in my log file:Notice - reader format `GEODATABASE_SDE' does not support querying by spatial predicate, but supports envelope queries. FME will create equivalent results by performing spatial predicate calculations locally
Hi,I'm converting excel sheets to gdb feature classes and I'm not sure why but some of the values in my attribute table are different from the actual values in the sheets. Example images:This wouldn't be a huge deal except for the fact that the fields with the decimal values are being recognized as text. I have to create new numerical fields and migrate the data using the field calculator and would like to prevent this somehow. There isn't any formatting in the cells, and when I do migrate the data to a new field, the values revert back to what they are in the excel sheets. I've tried copy/pasting values into a new worksheet and end up with the same thing in my attribute table.Has anyone seen this before? Thanks!
Hi,I am looking to create a workflow that allows the conversion of large raster data sets from Geotiff to PNG format for use in a web based platform. Typically, this will require a transformation of individual raster tiles from a state plane coordinate system to a UTM coordinate system. The issue we are having is accounting for the rotation of the image after transformation and assigning a transparency to the no data areas that are generated. Most of the rasters we will be processing will be 32bit (8bit per channel) 4 band RGBN Geotiff orthophotography tiles. The PNG images to be created will be RGB with the near-infrared band stripped out. We do need to allow for transparency in the no data areas of each image tile. Ultimately, the PNG images will be ingested into MapProxy and displayed as a seamless mosaic. This will require the no data areas to be transparent. The FME workflow we have developed so far uses the RASTER INTERPRETATION COERCER to add an alpha band to the transfor
I need help to convert autocad .dwg files to collada format .dae files along with textures embedded. If anybody has done this, could you kindly throw some light on what options precisely I should use, and also will it be using mere translation between the formats or with intermediate transformers ?
Hello,I needed to decompose my .dgn file in to .shp to get all the layers by them selves. After that, I used line closer --->>> area builder in order to finish my polygons. That is where my problem starts. When I do this from my personal laptop I get good result and when I click on inspect, I can see that results are good, but if I try to do the same on my computer on my work, I am facing a problem that says following:"During translation, some features were read that did not match a reader feature type in the workspace. This can happen if the reader dataset is changed, or a reader feature type removed or renamed."I don't understand why am I getting this message when I did make sure that reader hasn't changed, neither was removed or renamed. Thank You in advance for every possible help. With respect, Dejan
Hi I'm a new user to FME, but I am familiar with model building. I have a process that takes LiDAR point clouds and turns them into DEMs. A branch of this process takes the outline of the initial point cloud and clips the DEM to the point cloud boundary. There are two possible point cloud outlines created by this process (depending on if there are holes in the data). How do I get the clipper to use outline A if it exists, else use outline B? I know the logic required here, I just can figure which transformers / settings / parameters to use to get this process to run
Hi,I have set of coordinates for a polygon in CSV format, I need to create the polygon from the coordinate in FME. Kindly let me know which transformer I have to use.RegardsK.Jayakumar