Data

Im wondering if anyone can help me with the issue i am experiencing. Im attempting to output the published parameters used in a workbench to either a text file or json file, in addition to my shapefile writer. I have tried adding in a feature writer but when i run the workbench although my shapefile data is transformed as expected, the textfile which I want to contain my published parameters also includes all of the attributes which I do not need in the text file.Perhaps I have missed something extremely obvious or I need to approach another way?Many thanks

I want to make a connection with msSQL server with another windows userid/password than mine.If i select Windows Authentication in the connection set-up window, the windows credentials fields are disabled. In our organisation there is only 1 windows account for the SQL server.Is there a possibility to use a different windows account than mine for the connection.?Maybe an example connectionstring?Thank you very much, i hope someone can help.Kind regardskees@itay 

Hi,When i update my mongodb reader with "update reader and feature types" one column (properties.observations) of my collection (that i see with robomongo) doesn't appear in User attribute. I have try many times but nothing happen. It's really a big problem for me. The same thing when i delete and create my reader.When i use format attribute/mongodbjson i retrieve this column in the column mongodb_jsonIs it a bug ?Best regards

I have a number of DXF input files feeding a workspace that writes to a SQL Server File Geodatabase. These DXF files are sometimes there, sometimes not. The fme workspace fails with a Fatal Error when the Input Reader fails to find the dxf file during "version check". As failure occurs before there is opportunity to incorporate a transformer, I can't use FileExistanceChecker or other file exists processes. Is there a workflow I can use to ensure the translation continues if the input file is missing?

I need FME Desktop workbench to convert Custom XML (Smallworld) file to Multiple shape files based on the respective feature classes

Check out the FME Cloud Pricing Calculator for a new Help Me Decide. https://www.safe.com/pricing/fme-cloud/  Under the time frame section for Instances, this explainer has a number of different examples of how to use the calculator and situations your customers may find themselves in.  A snippet from the pop-up.

HelloI am totally new with fme software.I work with a drone to capture land photos, then i process the photos and add land coordinates. The output is in LAS format.When i try to enter this file to autocad map 3d, it's imported as one block and i cant manipulate the data.So i need to convert the LAS file to DWG or DXF so i can work with the dataIs that possible?Thanks

Hello,  I'm trying to convert a 4-channel Geotiff to a 4-channel ECW. Unfortunately I always lose the fourth channel (in my case the IR channel). As far as I know, the ECW format supports the multi-channel system. After I had another problem at the beginning, which I could solve with the workaround described in https://knowledge.safe.com/questions/81297/ecw-writer-this-format-does-not-support-writing-th-1.html, I haven't yet found a way to integrate my fourth channel into the ECW file. Is this possible with FME and if so, how do I do it? Enclosed still with current attempt.Thanks a lot for your helpGeoTIFF2ECW4Multichannel.fmw

I want to run a Workspace with each run a different Shapefiles as Source.I Use the "Directory and File Pathnames" Reader and set it to *.shp.Then i set the Source of the Shapefile in the Workspacerunner to windows_path. And here is the Problem:Now the Child Workspace runs with the Child Workspace Source Shapefile.But so many times as the "Directory and File Pathnames" Reader from the Main Workspace has.It doesnt get that he needs to Change the Source to another Shapefile in the Childworkspace.It only runs 8 times with the Child Workspace Source instead of Using the 8 different Shapes from the "Directory and File Pathnames". What am i doing wrong?

Hello all,I am trying to convert an ifc file (Industry Foundation Class STEP file) to MapInfo.I can get FME to read the ifc and it displays objects in FME. But if fails on writing to MapInfo.I understand that ifc is three-dimensional objects, so I just want a two-dimensional representation. I tried using 2DForcer, but am not getting results.I have attached the ifc file here

When running a workspace I get this error: FME Docker: Module 'MSSQL_ADO' is unavailable for use with this FME editionOther errors include:Could not load module '/opt/fme-engine-2019/plugins/fme_ado.so' : /opt/fme-engine-2019/plugins/fme_ado.so: cannot open shared object file: No such file or directory

Hi, I am working on a project to identify attribute values that do not match for many SDE layers (26 total). I would like to write the results into separate sheets within the same excel file; however, I currently am only able to write one sheet at a time in the same excel file. I would appreciate some advice and suggestions!

How to extract a smallworld data i.e., join fields from a collection?

how to include a magik script in fme while extracting data?

Hi,I am using a reader to read the local .gdb file (around 11 GB) and write one of the feature classes into a Postgresql table. Reading is quite slow especially after processed 100,000 features, while the writing is at normal speed and is not an issue at all. So far, it already taken me around 10 days to read and write only 400,000 features into warehouse, still not finished.I assume it is because memory shortage, so I also disabled the feature caching. Anything else I can do to speed up the work? have been stuck for 2 weeks.

Hello. I cannot seem to run any workbench invokving a WFS. It seems to workan extent where it reads the get capabilities to give me the feature list but when i try to run preview or run the workbench, i get the error "HTTP transfer error: 'Couldn't connect to server'" We work behind a proxy but i have configured this in the s, and it works fine for wms, arcgis featur services. Just not WFS. the WFS service itself is fine, i can connect via other software such as QGIS just not via FME http://geoportal.ancpi.ro/arcgis/services/AU/AU_WFS_STEREO/MapServer/WFSServer?request=GetCapabilities&service=WFS Working on desktop 2019.2 Many thanks

Hello all, this question is related to question 83147, I have the same problem.  I use a generic reader and refer to the attribute values in the Excel file using the attribute dereferencer. This wiorked fine with my first tests. But now I have an Excel file which shows the columns completely at a different position than in FME!Excel: FME: The Kennung, in Excel the last column is the second column in FME. The specification to the service I provide via FME server is that the colum 1 and 2 in Excel (so 0 and 1 in FME) shall be used as X and Y. From what I see in Excel it should work but my workspace fails because the "Kennung" value is no valid coordinate. Any suggestions? I can't find a reason why FME changes the column order File is attatched:

We are unable to use the Oracle Non-Spatial reader to retrieve table schemas from the database. The error returned is as follows:Failed to obtain any schemas from reader 'ORACLE_NONSPATIAL' 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 informationUnfortunately that is the log file, so there is no further information. Oddly enough, once the workspace is generated it can be run perfectly fine and read data from the oracle database without error. We have tried Oracle clients 11.2 and 12.1 with FME 2017, 2018, and 2019 and all error. The Oracle Client has been correctly installed and works great from sql developer, arcgis, and other applications. There is also a TNS_ADMIN environment variable to the TNS names file and the client path is in the PATH environment variable. Additionally we are unable to retrieve SDE feature class schemas from the oracle database using the

 Hi All,  I have a workbench that takes an Intergraph Access Warehouse, massages it, and then writes to a Intergraph SQL Warehouse. In our environment, using windows authentication on the SQL DB, users only have permission to insert into the SQL DB.  In the workbench, I have 'Use Windows Authentication' set to 'No'. I then use a specific SQL logon that has full rights to the SQL DB.  When I run the translation, it fails with the following error log:   Using user supplied ODBC DSN 'ELP_Maintenance' as dataset Successfully connected to source dataset 'ELP_Maintenance' GeoMedia SQL Writer: Table 'ELP_UG_URDBox' has IDENTITY column 'ELP_UG_URDBox_ID' Database error: '[Microsoft][ODBC SQL Server Driver][SQL Server]CREATE VIEW permission denied in database 'ELP_Maintenance'.' SQL is: 'CREATE VIEW "FME_VIEW_1" AS SELECT [Asset_Status], [Asset_Owner], [Asset_InstallDate], [Asset_Acquisition], [Asset_WorkOrder_Install

Trying to make my life easier by setting up some Database connections in FME Server to help with updating workspaces, as I'm having to repoint them to a new SQL Server instance. So I'm trying to set up a named SQL Server connection using Windows Authentication. As expected, user and password fields are greyed out. But when I click on "OK", I'm prompted "PASSWORD is required". What am I doing wrong? Bug?

Hello, Iam looking for an Oportunity for IFC-Mapping. After working through a few Tutorials.Set other Strings in "Names or Descrition" is no Problem. Creating own Property Sets is possible too.But my Problem is the IfcMaterial Attribute/PropertySet.I got an IFC File which i can open in "Solibri" and Data "Inspector". It contained the Property layer Set "Material" and Identification Attribute "Material".After Running the blank Workspace both Attributes disappear.The AttributeExposer gives me these Opportunities but no progress here.or are the IFC-Writer settings the key? (Reprentations to Read?) I Want to write in Ifc 2x3. I hope you can give me a hint :)Thank you!Richard

I need to extract data from smallworld,from a collection(wire segment) I have an attribute (again a collection - Bay).I want to extract the data i.e., Id of wire, Id of Bay , Asset ID of Bay -- in the properties tag along with linestrings. Now I am trying to extract the data, but in the properties tag only the size of bay is displaying.Can someone please help me on that?

Hi,I have upgraded FME server on our test server (on prem, Windows Server 2016, express install, default install settings), using these instructions: http://docs.safe.com/fme/html/FME_Server_Documentation/AdminGuide/Upgrade-in-Place-Same-Machine.htm I took a backup of the FME config and tested it worked, which it did on 2018.1.1.1.After upgrading the server (version 2019.2.1, Build 19813), I tried to restore the backup but then it failed.It has this error: “Could not write FME Server request message. Connection may have been lost. An existing connection was forcibly closed by the remote host”I also noticed that the FME Server Core service stops during the restore and I have to restart it manually to get the server working again. I think the service stopping is the cause of the failed restore. I have tried restoring the backup pre/post licencing the server, running the services as 'local system' or as our specific account, multiple restarts and re-installs, but still no success.

HelloI want to export a table from PostGis databse by keeping only the columns that don't appear in a text file. This is an example to be more clear : Text_file : A B C ZTable columns :ID 7 T Z F K B         Export result:ID 7 T F K       Thank you in advance for your answers.Best Regards

I have a DWG file that I am needing to validate and one of the tasks is to assess the font.  1. How do I find out the font or fonts used in the DWG? Secondly, once I know the original font, I want to use that same font to write out the drawing using MapnikRaster. 2. How do I set the font and font size based on what is in the original drawing?