Data

Can FME read and write features that are in ESRI's SDE.ST_GEOMETRY in an Oracle Spatial database? I have a table that is in ST_GEOMETRY, but the Oracle Spatial reader cannot show it because there is no entry in the user_sdo_geom_metadata table. I don't see an ESRI reader that would be able to read from Oracle. Likewise, when I try to write from a file geodatabase that is in ST_GEOMETRY, FME converts the geometry to SDO_GEOMETRY.Thanks

Hello,  I have to read sources that have the same structure in n paths all structured in the same way that I therefore designate to read by ..... dep \\ com ??? \\ shape \\ parcel.shp. ??? Is 001, 002, 003, etc ... No problem for reading. However, I would like the destinations to be written each time in a subdirectory (example: ..... dep \\ com ??? \\ shape \\ l93 \\ parcel.shp.  Can you help me ?  Thank you.

Hello FME Users,I need to put the color in Attributes Names in my XLS file. I saw the configuration in Output XLS, but it change the color all my columm:The Line 1 is the Attribute Name The Line 2 is the Value.Thanks

Hey Safers,I was wondering if it was possible to position an attribute to an exact row/column position!Using the image below as an example I want to designate an attribute 'LICENSE' to the cell indicated by the red arrow, let's say its at G-5Is there a formula I could use? The spreadsheet can't reference a raw data table as its a fan out of many pipelines in one workbook (a,b,c,d)Thanks,Patrick

Hi All,I am facing an issue while translating data from Oracle Spatial to ESRI Geodatabase. while translating the data using FME workbench getting error message "Unable to drop the table/feature class 'GD_EXPANSION_JOINT_point'. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {FDO error: -2147216072}". i did google search for this FDO error number but did not find anything. Could anyone help me out in this error.Thanks in advance.Thanks & Regards,Ravi Kumar

Is it possible to read data from $(FME_SHAREDRESOURCE_DATA) with the feature reader? In a workspace i write excel datasets to $(FME_SHAREDRESOURCE_DATA), I want to read these because they contains attributes which i need to dicede to send a mail (or not) with another job.(The full path to the data is : $(FME_SHAREDRESOURCE_DATA)/Informatie_Management/Vaarwegmeldingen/Meldingen_borden.xls)I use FME server 2015

I currently have a custom Transformer that gets a parameter MaxTileCount (the value of _num_tiles) from a WebMapTiler and it counts the number of features and sends a HTTP message every 10 messages to show progress.That is all working fine.However, now I have issue. The PNGwriter is no longer a PNGRaster writer, but has changed to a FeatureWriter that does a fanout. Well that takes a lot of time, So I want to move the Notifier to later in the pipe, after the "pngWriter (FeatureWriter). The issue I have is that I don't know how to count anymore the number of files written by the FeatureWriter as they are emitted, nor do I have access to _num_tiles which is the total number of tiles coming from the WebMapTiler.In simple words, I want to send a HTTPPost message with count/total as the files are written by the FeatureWriter any idea who to do this?The second notifier fails. So I disabled it.

I'm using FME Desktop 2017.0.1.1. I have a csv file that I need to merge with 6 different csv files. The 6 different csv files are derived from MapInfo table that Intersects with another table and the selection is exported as a csv. I have AttributeManager, AttributeCreater, DateFormater and FeatureMerger for each csv. These csv files are FeatureMerger with another csv and the writer is a 6 sheet excel workbook. When "Translation was SUCCESSFUL with 0 warning(s) (81575 feature(s) output" the excel xlsx file contains errors: "Removed Part: /xl/sharedStrings.xml part with XML error.  (Strings) Unexpected end of input. Line 1, column 1614248. Replaced Part: /xl/worksheets/sheet1.xml part with XML error.  Unexpected end of input. Line 1, column 1614250. Replaced Part: /xl/worksheets/sheet2.xml part with XML error.  Unexpected end of input. Line 1, column 1614250. Replaced Part: /xl/worksheets/sheet3.xml part with XML error.  Unexpected end of input. Line 1, column 1614250. Replaced Part: /

Hi,   I'm trying to insert block in a DWG file with a specified rotation.    If I use feature and replace them with a block they all appear with the wrong rotation.   Here I set the rotation at 0 for all of these :  

I noticed that some users delete their questions, even though answers helpful to other users have been posted. I think it would be better if there were a restriction that a question having answers cannot be deleted unconditionally.

Hi,Can anyone provide some advice as to the most efficient way to explode a huge free text field or fields into all of its character elements retain a single instance of each. I am essentially trying to complete a pre-flight check in order to understand whether there are any ‘odd’ or ‘unexpected’ characters in an ever expanding data set, over which I have no control. I have created a process below which completes the task; however, it is very inefficient and as the number of records increases it will become too slow. 1. Derive string length of free text field 2. clone by number derived in 1 (clone number created in process) 3. substring extract using clone number to obtain character at that position 4. Duplicate remover to create my list. 5. Expose character code. 6. Output listThanks in advance,Rob

While converting from Oracle 11g to 12c, we executed a simple Oracle Non Spatial Workspace that moved 4 million rows from a CSV file to an Oracle table on 12c. It consistently threw the ORA-12592: TNS:bad packet error after running for 30-40 seconds.We ran the same workspace against 11g and it worked fine.After researching the issue we ended up modifying the Oracle 12c Server SQLNET.ora file by adding this parm:SQLNET.SEND_TIMEOUT=600Modifying the client side SQLBET.ORA did not resolve the issue. Modifying the server side SQLNET.ORA file did.

is it able to Change a Color from a Block-Definition, so that a Symbol gets a other color as defined in the Block-Definition.I want to change the green Symbol from Blockdefinition to overwrite in blue Color

geopackage

Hello people, i splitted one DXF-File into 4 separeted DXF-Files. One of them i tried to open in ArcGIS, but can not see the features there. Somehow DXF-Files, which were written through FME, could be read only in FME Viewer, but not in ArcGIS. Do you have any ideas, how can i fix it? I tried already all possible format of DXF in FME to write, but still does not work. (the main DXF-File can be open and the features could be seen in ArcGIS as well)

How can I define the Export Parameter $INSUNITSWithout Settings the Export to dxf is:$INSUNITS  70  1  9the second number must be Change to 6

point cloud screen shot.Geotiff infrared image of an electrical board.

Hello Everyone,   I have a polygon-feature Geodatabase that I need to be converted into an ESRI GRID feature with 30m x 30m cell resolution. I really don't need to transfer any cell values. I’ve tried using the suggestions at this Knowledge Center article “Converting Vector data to Raster” https://knowledge.safe.com/articles/1099/converting-vector-data-to-raster.html but to no avail.   Currently I’ve tried the AttributeCreator/ImageRasterizer/RasterBandSeparator transformer process and then tried writing the result with a ESRI ASCII GRID Writer but the process fails with an error message stating that the output cannot be written to a raster because of an invalid format.   Thanks for any assistance,   Cheers,   - Craig

Hi I have used a FeatureWriter to write to an SDE feature class. While this seems to work, I am still getting an error in the log file. Any ideas?Total Features Written                                                    9669=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-The below feature caused the translation to be terminatedStoring feature(s) to FME feature store file `C:\FME\BatchProcesses\FMEDailyProcesses\log\pipes_logFile_log.ffs'+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `Tester_PASSED'Attribute(string)                 : `_dataset' has value `<Unused>'Attribute(32 bit unsigned integer): `_feature_type{0}.count' has value `9669'Attribute(string)                 : `_feature_type{0}.name' has value `wgis.pipes'Attribute(encoded: fme-system)    : `_num_features_read' has value `9669'Attribute(32 bit unsigned integer): `_total_features_written' has value `9669'Attribute(string)                 : `fme_g

I am reading many features in a database, putting them through a 'spatialfilter'. All features that don't intersect are to be sent to the 'emailer'. How can i group a single attribute from many features as plain text so i can add this list to the 'emailer' body?

We have geoereferenced tiff files which we would like to integrate with some existing dwg'sHow to do it?

Hi !I would like to know if it's possible to transfert LAS files to Landxml ?Just like XML files are exported from a surface in Autocad.The purpose of this transformer is to load LandXML surface into Autocad Infrasworks as a Terrain so i can drape Buildings/Roads/City Furniture/Streams on it. Let me know if you think it's possible.Best regards

I have to convert these lat/lng to geom data type, such these lat/lng are in space (here I have done wrong), Kindly guide how I can convert them (lat,lng) to geometry such that they occur in space. Thank you