Data

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

Hi,I'm merging a DGN file with excel table writing into a SHP (feature type definition 'import from Dataset' - I used a template given to me)The excel table contains date, I've used DateFormater- DestinationDateFormat: %d"/"%m"/"%Y, it looks like it should work and it is working when I run the workspace redirected for FME Data Inspector, dated are coming up perfect, fields with no no date have <missing> instead.When I view the SHP in Data Inspector as to 'open a dataset in a new view' dates are missing as they are missing when I view in in ArcGIS.How to make it the date viable?I've tried the FeatureWriter, dynamic properties and used the template .shp a s schema definition, that doesn't work either.Would anybody have any idea why the date is so difficult to write into a SHP? I use FME Desktop 2016.1.3.Would the proper XML workspace exported from GDB help? There is a .shp.xml given to me within the shapefile template anyway.Kamil

HiI'm having a problem reading and then writing shapefile into MS SQL database. Shapefile contains multiple polygons (and multi polygons), but apparently there are few with only single pair of LAT / LON coordinates. These are rejected and not written. Is there a way how to write them anyway?Thanks,

Hello everyone,after creating a few excel files in my workbench I wanted to sum them up in a pdf file. I used the FeatureWriter to create the Excel files. After each FeatureWriter I inserted a PDFPageFormatter which I connected to a normal Writer for the PDF. What happens is nothing. The Excel files and the PDF file has been created but the pages in the pdf are empty. I'd be thankful for hints.Best regards,Felix

I have a Microstation DGN file, and inside it is an imported raster (not a referenced raster file). In FME this raster image is coming through as a nongeometric collection. How Do I go about extracting the raster file from the DGN so I can use it as a raster image? I have tried using the geometry filter, but since fme reads the raster as a nongeometric collection it thinks there is no geometry instead of filtering it through the raster port. Are there certain attributes that need to be set on the raster image in Microstation in order for fme to register it as a raster?

Hi all, I am trying to create a workbench that will read/download 52 individual URLs and write them as 52 individual feature classes in a file geodatabase as well as 52 individual dwgs both using part of the original URL as the file name and for the file geodatabase as an attribute under the feature class. I will hopefully have this run monthly as a batch file.I have a list of 52 URLs that are stored in a spreadsheet (example of a few attached). Each URL is a download link for a .zip file that contains an individual GML file. I can pass the URLs successfully to my HTTPCaller which saves the response body to file. An example of the original URL called is this below:http://data.inspire.landregistry.gov.uk/Kensington_and_Chelsea.zipWhereas the response file that is saved is called 'http_download_1497369123968_8888.zip'I need to have a way to transfer the actual URL name from the spreadsheet so that it can be an attribute of my output. I'm not sure how to do this?Below is a

Hello, I have one question regarding conversion 3D city from SHAPEFILE to CityGML.I have more classes of objects (vegetation, cityfurniture, buildings, ...). I would like to ask how can I follow the structure of creating _AbstractClasses in FME workspace? How can I create abstract features and use them as gml_parent_id in those features which are in the hierarchy down below? Thank You Michal

Hi, I have some trouble when I want export the custom properties of a Revit file. After exporting in rvz with the "Export Revit property sets" checked, I can see them when I open it in the inspector, but I can't access them in the workbench, or export the properties in a csv (with the ID I could reaggregate the data).Could you help me ?

Hi,Does anyone know why FME server is unable to handle an SDE connection file with OS authentication? I have several FME desktop workspaces using OS Authentication and I publish it to FME server and run my FME Job Submitter service. I also have the conection file uploaded, but somehow during translation it fails to utilize/recognise the SDE connection which is setup with OS Authentication. On the other hand, the windows server where FME Server is installed has ArcGIS Desktop installed too and I am able to connect to the database using the OS authentication SDE connection file.