Data

Hi, Looking to create a 3d sphere from the XYZ coordinates in the attached CSV and then add the "Filename" property to each sphere. Can someone help? Ive tried the Hub3DBufferer, but I cant get the geometry created. Happy with an AutoCAD or similar output. CSV file attached if anyone can help me

 Hi FME experts,I have stored polygon objects in an Oracle database. The geometry is in the GEOM field. For an interface, I have to convert the GEOM field into a text field. The GEOM field looks like this:select geom from VIEW_RIWE_2016_BORIS where fid = 70118sdo_geometry(2003,25832,null,sdo_elem_info_array(1,1003,1),sdo_ordinate_array(510843.904449149,5369878.15541307,510782.847025386,5369803.95356616,510757.074323074,5369773.29550141,510804.270134531,5369734.73477362,510819.559582734,5369752.69084497,510863.309430839,5369806.93171413,510890.267651986,5369838.63447086,510843.904449149,5369878.15541307)) The TEXT field must later look like this:POLYGON ((32563549.456 5934230.837,32563553.002 5934219.989,32563552.58 5934219.778,32563542.348 5934220.82,32563537.637 5934221.725,32563533.431 5934221.663,32563522.282 5934224.668,32563543.799 5934230.72,32563549.027 5934230.188,32563549.456 5934230.837))With a bit of text editing, I

Hello, I was asked by a colleague if I we can use FME to create a report with 3D Thumbnails like this:And I'm not sure? Is there a way?I guess I would have to create the thumbnails externaly and join it back together to create a pdf? 

HiI am clipping a LAS file and writing to a new LAS file. I have noticed in the LAS Header the following fields have not been updated and contain info from the original LAS file:system identifier generating software file creation day/yearWhen I clip using lasclip these fields are updated so I wondered if there is a reason FME doesn't?TIA 

I have approximately 170 tables from a sqlite database that I need to convert to geojson and save as @Value(fme_feature_type). I have a workflow to process each table individually but I need a way to automate the process. Passing all tables through the same workflow merges the schemas of all input tables. It isn't practical to pass each table through its own set of transformers when dealing with this amount of tables. Some type of loop control seems logical to pass tables through the workflow one after another while ensuring that output schemas are refreshed after each iteration. I'm fairly new to FME so any help would be truly appreciated.

I received a sample of IFC data and was asked to import it into MS SQL database spatial database.I was able to import the data but no geometry. How do I get the geometry? This is new data for me. @DaveAtSafe

Hi there,Probably a fairly simple one for you, but I'm a total novice!I have hundreds of thousands of files in PDF and TIF formats hosted on a server - lets call it Server 1.In a SQL2008 database on another server called Server 2, I have over 100000 records which contain a specific reference number which links these files individually (so that one reference number might be linked to several PDFs or TIFs using the same reference number, e.g. Ref number 19994321 on Server 2 will be related to PDFs/ TIFs with the Ref number 19994321 on Server 1).In an Excel spreadsheet, I have a list of the reference numbers on Server 2 that I want to retrieve files for from Server 1 and I need to call them using two field names in the SQL database which defines the PDF/ TIF- under either 'Subject_Name' or 'doc_Type' and containing certain words as a parameter to narrow the search: 'Site Location Map' and/ or 'Location'.I want to th

Hello. I'm currently trying to figure out a way to extract 3D layers from a project I have online. I'm able to extract the parent layers, but I'm having trouble trying to get attributes from the child layers. I'm using a JSONFeature Reader, ListExploder, and a FeatureReader, but perhaps my parameters aren't correct. If anyone has any suggestions on a workflow, I'd appreciate it. Thanks!

I have a workspace that I can run on my desktop 2018.1.2.0 however when I run it on server it returns the below error. I am running WIN Server 2016 with FME Server 2018.1.1.1 build 18578.  The class 'COM/safe/fmewebservices/FMENamedConnectionEnv" could not be located. Check your classpathError getting id for 'COM/safe/fmewebservices/FMENamedConnectionEnv' with signature 'COM/safe/fmewebservices/FMENamedConnectionEnv'  From the reference below I copied all of the main window into a new workspace and it worked temporaily.  https://knowledge.safe.com/questions/60124/the-class-comsafefmewebservicesfmenamedconnectione.html  

log.txtMy writer into an esri fgdb is failing.An error occurred while attempting to store a row into the table 'PriOHElectricLineSegment'. The error number from ArcObjects is: '-2147221230'. The error message from ArcObjects is: {} The error message of "{}" is not very helpful. I attempted to look it up with esri without any luck.Does anyone know the source of the problem?Thanks 

I have an Excel spreadsheet where I want to pass several attributes as variables into a SQL Query using a SQL Creator transformer. What is the best way to achieve this? I don't see how I can make the attributes as user parameters.

I am getting "Python Exception <KeyError>: u'token'A fatal error has occurred. Check the logfile above for detailsFailed to obtain any schemas from reader 'ARCGISPORTALFEATURES' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more informationUniversalReader -- readSchema resulted in 0 schema features being returnedReader Parameter(0) = >https://gisgateway.williams.com/portal<Reader Parameter(1) = >RETRIEVE_ALL_FS_NAMES<Reader Parameter(2) = >Yes<Reader Parameter(3) = >AUTH_TYPE<Reader Parameter(4) = >generate_token<Reader Parameter(5) = >USER<Reader Parameter(6) = >ckeating2<Reader Parameter(7) = >PASSWORD<Reader Parameter(8) = >********<Rea

Hi all,We have FME server on linux using docker; FME Server 2017.1.1 - Build 17650 - linux-x64.Unfortunately we found out that some processes are generating core dumps and hss_err_pidxxxx.log files.Does somebody know, what could be root of the issue or where should we start to find out the root of the issue? Also how to identify what process exactly is causing generation for core dump and hs_err_pidxxx.log creation?thanks a lot in advance!information from hs_err_pid153.log file:# # A fatal error has been detected by the Java Runtime Environment: # # SIGSEGV (0xb) at pc=0x00007f6469201630, pid=153, tid=0x00007f644203c700 # # JRE version: OpenJDK Runtime Environment (8.0_131-b11) (build 1.8.0_131-8u131-b11-2ubuntu1.16.04.3-b11) # Java VM: OpenJDK 64-Bit Server VM (25.131-b11 mixed mode linux-amd64 compressed oops) # Problematic frame: # C [libfmeutil_jni.so+0x1

I need to use the elasticsearch writer with authentication - works great in Beta but I need to get it into production with both desktop and server.It would be great if I could some timescales so that I can feed back to the project team

I have created a workspace based on https://community.safe.com/s/article/creating-pdf-cartographic-outputthat outputs a simple PDF. Users can input a specific attribute (via a published parameter) and query out this feature, buffer around it and the output map is centered around this feature. Background data such as hydrology, roads and text are clipped to a bounding box from the buffer and displayed to give context to the location of the queried feature.  This works very well when there is only one feature as it produces a simple map zoomed to a suitable scale showing the queried feature and the surrounding background data.

My goal is to be able to have an AGOL feature service that overwrites the previous version each time the workspace runs on FME Server. As of now, I can't get the AGOL writer to work at all. The error I am getting is 'ArcGIS Online Feature Service Writer: Could not find a layer/table matching feature type '"featurename"'. Any tips regarding using this writer?

When writing las files fme defaults to determining its own scale factor and offset values to utilise in the output file. For a las to las conversion is there a way of forcing fme to maintain/use the same offset and scale factor values that the input las file has?

Hi, ACAD reader has \\ as an illegal character, breaking hyperlinks.AutoCAD Reader: Renamed attribute 'G:\\Stuff\\Morestuff' to 'G__Stuff_MoreStuff' to remove the following invalid characters '<>/\\&$|:!~ ()"@'Is there a known workaround in the meantime? Thank You

Hi,I'm trying to automate a process where FME reads in an Excel sheet in a specific format, but i need to split the Sheet into two parts (as they are completely different structures) and treat as two different datasets effectively. Is there a way in the Excel sheet reader to effectively duplicate a sheet in order to choose the different cell ranges that i require?

I'm working with FMEServer.I developed a small workbench that connects to s3, reads the content of some folder and downloads it into FME resource folder. The problem with downloading occurs only while first running. I get the following error:FAILUREjava.lang.Exception: COM.safe.fmewebservices.FMEWebServiceException: COM.safe.fmeserver.api.FMEServerException: QSInvalidRequestWhen I repeat a job, right after that, the job is done successfully.In both cases, engines are turned on.My workflow is as follows:Any idea of solving this problem?

Is anyone successfully using FME 2018 with Oracle 18? I can't find information on whether or not Oracle 18 is supported.

I am running some simple jobs that merely move datasets from one location/format to another to provide access from multiple systems and applications. When one of the source datasets contains a field name that is a SQL reserved work (SQL Server in this case) FME Workbench is unable to create the output feature class and the job fails.  For example I have a Shapefile of airports that has a text field in it named "Name". When I attempt to write this dataset to an enterprise geodatabase without changing that field name the job fails with this error -"An error occurred while attempting to create the feature class 'airports_metro'. The error number from ArcObjects is: '-2147215961'. The error message from ArcObjects is: {Invalid database name [08004:[Microsoft][SQL Server Native Client 11.0][SQL Server]Database 'NVARCHAR' does not exist. Make sure that the name is entered correctly.] [EGH_PUBLIC_WGS.ARCMAP_ADMIN.airports

Hi all, I've city buildings in .gml formats.And also i have aerial images of city.I would like to texturizing buildings from aerial images.So, i want to use texture coordinates of images.How can i describe and correspond texture coordinates and my buildings?

I have a workspace in FME server, that includes PythonCaller.The PythonCaller includes a script that needs a directory as one of its input parameters.The directory that i want it to use, is provided to the PythonCaller as hidden user parameter. The definition of the user parameter is just text, and the value also consists of other user parameter values, that were provided from a desktop workspace which triggers the server workspace.I have tried everything. I've changed the parameter definition and i've to put r and quote marks around the value. Still the workspace fails.This error message for example comes, if i just try to input the user parameter value as just plain directory (D:\\Data\\citydb_temp\\...)" Python Exception <OSError>: [WinError 123] The filename, directory name, or volume label syntax is incorrect: 'D:<backslash>Data<backslash>citydb_temp< ..." So how do i put a user p

What I'm trying to do, is to convert a JSON response form a HTTP caller to a standard table format (Excel or CSV). The issue is how do I tell FME that I want the specific keys as column headers?