Data

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

I've been trying to read CSVs from inside Zip files in 2017.0 (did some testing with 2016.1 as well). For example, I have 5 Zip files each containing 1 CSV.If I try C:\\Folder\\**\\*.csv, FME won't even create the Reader (I get errors like "CSV reader: Failed to open file 'C:\\Folder\\**\\*.csv' for reading. Please ensure that the file exists and you have sufficient privileges to read it").However, I discovered that if I edit the Source CSV File value in the Reader parameters, and manually set it to C:\\Folder\\*.zip\\*.csv then it works. Select Merge Feature Type to get all the CSVs presented as 1 Feature Type.

We want to be able to monitor an open FTP service but the Publication Service requires a user?

Hi there. I'm trying to update the .dwg Attribute autocad_text_string with attribute values from a corresponding excel file that was created from the same .dwg and manually corrected. The xlsx file is structured in a way that each sheet represents a layer corresponding to the .dwg and the column header is named autocad_text_string.The feature merger only takes the first column value of an excel sheet and gives all other dwg attributes of that layer that same value. Do you have any suggestions how to update each features autocad_text_string with the corresponding row value from the excel file?

At the end of our fiscal year, I would like to take the data that has "2018" in the title (a couple of feature classes and around 70 tables) and rename them to replace 2018 with 2019. Going from our production environment to our development environment. Using the readers and writers I see it can happen but I would need to manually edit the year. Is there an automated method that would replace the year in the title of each data file? I have not used FME before so this is all new to me.

I am creating a workbench to convert an excell spreadsheet using csv file into dgn to display coordinated refererence marks in microstation. This displays in Inspector ,however when the dgn file is used in microstation, points or cells does not display in microstation. Any way of showing a point or cell point in microstation using particular transformer(s) so this information displays in microstation? Further, is there a utility workbench that can assist me with this issue?Thank you in advance for any assistance you can give me.

Hi,I'm passing ID, fme_db_operation (as UPDATE) along with point geometry (set with GeometryPropertySetter) to small world writer.I'm receiving error as mentioned below...2017-12-14 01:12:08| 3.9| 0.0|ERROR |Smallworld Translator Error: No URN handler for class unsetWhether I'm leaving any other important attributes to pass to writer...

Hi,Is it possible to publish to FME Server old scripts developed in .FME, .FMI Files ?Thanks.

I have a problem with writing to microstation tag I want to write the tag to a different level than the cell I use microstation V8i and my input is shape

I have several .dxf files of bathymetric data that I need to convert to LAS files, they contain the following: Bathymetry (contour lines), Sounding (points), 1Xanno (points) and 0 (no idea). I am new to FME and managed to figure out how to convert .xyz files to LAS but these are a lot more complicated.Thanks,LG

I am trying to migrate shape files data into smallworld by using FME. After configuring workbench i got bellow error's.Smallworld Translator Error: No URN handler for class unsetSmallworld Translator Error: Access denied to C:\\FME WORK\\enum_check\\Kofra_enum_log_report.csv.Thanks in advance for your help.

Does anyone have a way to Update or insert rather than have Writers that Delete and Insert. Something Oracle Merge? ThxMERGE Purpose Use the MERGE statement to select rows from one or more sources for update or insertion into a table or view. You can specify conditions to determine whether to update or insert into the target table or view. This statement is a convenient way to combine multiple operations. It lets you avoid multiple INSERT, UPDATE, and DELETE DML statements. MERGE is a deterministic statement. You cannot update the same row of the target table multiple times in the same MERGE statement.

Hello,is it possible to convert 3D shp file to 2D? If so, how can I do it?Thank you!

I'm upgrading the way we build data samples to use FME Desktop. With vector data, I'm using  a dynamic reader (to save individually handling of many tables), passing through a Clipper to restrict the area and finally writing the output. It's simple and works fine, except... the field indexes on the output are not maintained. Having to put these in manually or in external software sort of defeats the purpose of using FME! Is there a way of preserving attribute index (and spatial ones for something like Esri Shapefiles) using a dynamic read/write workflow?  Regards, Warren

I need to create a csv-file with a special structure. I 've two problems which I haven't an idea how to solve:1. How can I add a file-header before the actual content (The yellow part on the picture)?2. If an element has more than one coordinate pairs (in case of a line) how can I add the vertexes and the end-point on the same row (The part witch is in blue on the picture)? Yellow: File-header Orange: Column-Header Shades of Blue: Element coordinate(s)