Data

I've put a autocad template file with two test blocks, a Shapefile with points and a FMW-file in a . So I hope you can seen whats going wrong. I tried to export point features to blocks with autocad_od writer because I want to save other data as Object data. This does not work! When I use de realdwg writer it is still working right.What is wrong in the Autocad_od writer parameters?

Hello, I am receiving an error when I try to load an ACAD reader. I have no idea what could be the problem.Starting translation... FME 2017.1.2.0 (20171213 - Build 17722 - WIN64) FME Database Edition (node locked-crc) Temporary License: 20 days left. Machine host name is: DESKTOP-7U34IIO Operating System: Microsoft Windows 10 64-bit (Build 16299) Copyright (c) 1994 - 2017, Safe Software Inc. Safe Software Inc.Creating reader for format: Autodesk AutoCAD DWG/DXFTrying to find a DYNAMIC plugin for reader named `ACAD'Loaded module 'ACAD' from file 'C:\\Program Files\\FME\\plugins/ACAD.dll'FME API version of module 'ACAD' matches current internal version (3.8 20170315)SOURCE_ACAD Reader: Using rich geometry.AutoCAD Reader: Error opening file 'C:\\Users\\ddeja\\Desktop\\Projekti\\Bijeljina\\IZVEDENO SAOBRAAJNICA.dwg' during

Hi!I am using the wfs-reader in FME accessing the web feature service(wfs):http://slwgeo.artdata.slu.se:8080/geoserver/SLW/wfsFeauturetype: "AllSwedishOccurrences {All Swedish Occurrences}"I am trying to filter specific(e.g. "Margaritifera margaritifera" species in a municipality(Borås) Seems like I can´t get both criterias on the same time. Getcapabilities: http://slwgeo.artdata.slu.se:8080/geoserver/ows&VERSION;=1.0.0&SERVICE;=WFS&REQUEST;=GetCapabilitiesHow can I get scientificName Margaritifera margaritifera in municipality Borås by filtering in the WFS-reader? It would be ok to apply a bounding box on coordinates instead of using the attribute municipality Borås. I know some of xml, and I have been trying to find a solution,using the filter functions taught on Geoserver but now I reached a dead end. I have tried:<Filter><And><PropertyIsEqualTo><PropertyName>municipality</PropertyName><Literal>Borås</Literal&g

I have a feature class which already possesses a defined CRS. I am creating some polygon outlines from an Arc ASCII file and writing them to the feature class mentioned above. Also, i am reading a tiff image which contains the CRS information to be assigned to the feature class after the outlines have been loaded. So the goal now is to extract the CRS information from the tiff image(done) and assign it to the feature class to which the polygons are being written. How do we achieve it ? I am confused between the Reprojector and the Co-ordinateSystemSetter or is there any other way ?

Hello,I have a custom workflow built around the GoogleGeocoder transformer available in the FME Store.My company recently upgraded the server from which I access FME Desktop (from Windows Server '08 to Windows Server '12), and now the workflow errors out on the JSONFlattener transformer piece of the GoogleGeocoder transformer.All my other custom workflows continue to work perfectly...Below is the exact error message I get. Has anybody encountered this error before? If so, how did you remedy it? 2018-01-22 12:50:12| 4.2| 0.0|ERROR |GoogleGeocoder_JSONFlattener(JSONQueryFactory): A JSON syntax error was found at line 3, column 133 2018-01-22 12:50:12| 4.2| 0.0|ERROR |GoogleGeocoder_JSONFlattener(JSONQueryFactory): The JSON data is incomplete: Unexpectedly encountered the end of JSON data 2018-01-22 12:50:12| 4.2| 0.0|ERROR |A fatal error has occurred. Check the logfile above for details 2018-01-22 12:50:12| 4.2| 0.0|ERROR |A fatal error has occurred. Check the logfile abo

I wish to receive email with text from query (addresses). I am able to trigger a one time run of workspace and recieve text and notification. When i schedule same workspace i dont receive text but only notification?

Hello,I have a CSV file with 70,000 records. It has a header row identified by 10 in the first column. The data rows have 20 in the first column and the footer row has a 99 in the first column. I can split out the three row types, do stuff to the data rows and then combined them all back together again in the correct order – 10, 20, 99.However, the output file is too big for our thirdparty import routine to handle so I need a way of chunking the data into files with, say, 5,000 records in each. Each file needs the original header row (4 columns), the 5000 data rows (15 columns) and an updated footer row (2 columns) with a 99 and a count of the number of data rows in it. The importer should be able to loop through these smaller files without taxing the underlying JVM.I have got it mostly working using a fanout on the dataset using @Count(fanout,1,10) which creates 10 folders with a CSV file in each. However the header row gets written to the first file and footer row only gets writ

I am having trouble with the color format going from a dwg to a geospatial pdf. My workspace is reading the paperspace from a dwg and writing a geospatial pdf. I need help with the color format on the output pdf.

I'm trying to make a new DGN V7 file from DGN V8i. the cells are all exploded as lines and line strings. Is there any way to keep the cells intact?

Dear All, We are trying to export and import smallworld data by using FME.Actually as per client requirement’s we need to perform two processes by using FME. Process 1: Smallworld:cables data into Esri Shape files.Process 2: ESRI shape files to Smallworld database. We are trying these two processes on Camebride database only. But we are facing issue with cable collection. In cable collection we have “Spec”, “asset” and phase. How to convert these 3 into single ESRI shape files by using FME workbench? In Process 1 if we read CABLE collection data from Smallworld by using reader we are getting list of feature types. How to import single shape file to Smallworld by using FME. After insert if we check in smallworld it will display all the cable collections.We are facing issues and we stopped hear. Request you to please provide suitable solution for doing this task. We need step by step process documentation. Thanks in advance.

I have FME 2016 1.3.2 64-bit installed together with ArcGIS Pro 2.0.1 and ArcGIS 10.5 and uses the File Geodatabase ArcObjects reader and writer. When I run a workspace I can see the the line "Installed ArcGIS version is '2.0'" in the log indicating that FME are using the ArcGIS Pro installation to read and write the data. Now I have installed ArcGIS Background Geoprocessing to run some python scripts in 64-bit. But after the installation of ArcGIS Background Geoprocessing I am getting "Error running translation" in workbench after running all tranformers in the workspace and writing the data is done. I have compared two log files one from before the installation of ArcGIS Background Geoprocessing and one from after the installation. Before the log says: "Installed ArcGIS version is '2.0'" and after the log says: Installed ArcGIS version is '10.5'.  So my question is can I control which verion of my ArcGIS installations for FME to u

When attempting to create a writer for an Azure SQL database, I'm getting the following error:com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "java.security.cert.CertificateException: Failed to validate the server name in a certificate during Secure Sockets Layer (SSL) initialization.". ClientConnectionId:94d4ffe6-d46d-4b02-8a9a-055ac0e021e8There appears to be an issue with the certificate chain Microsoft is using to enable secure connections to SQL databases. I was able to work around this issue in another tool by setting trustServerCertificate=True on the connection string. The FME Workbench UI does not allow me to customize the connection string. Is there another way to set this parameter for database connections?

Hello!When I was using batch script to run automatically FME Desktop workspaces, I was able to map my drive with the NET USE command before calling my fmw. I was able to write on other servers outside my network.EX : net use Y: \\\\SERVERNAME\\data /user:JackDaniel AlwaysMore40ozNow that I use FME Server 2017.1, I don't understand how to map my drive. I found this article but it doesn't tell where to put UNC path : Mapped DriveI have many servers with different user name. Do you know what I can do? A clue?Thanks a lot!

looking to write in pdf file a polygon with a raster image clipped to. they will be 2 views one closer view and second with fare view Any suggestions

When invoking lmutil or lmgrd an error "no such file or directory" is returned.Investigation yields that lmutil is using the following interpreter: ELF 64-bit LSB executable, x86-64, version 1 (SYSV), dynamically linked, interpreter /lib64/ld-lsb-x86-64.so.3, for GNU/Linux 2.6.9, stripped.What can I do?

We have a server running FME Server 2017. Are we able to install ArcGIS server 10.5 on the same machine or is it something that should be avoided? What is the rationale either for or against installing them on the same machine? We are running it on a VMwareWindows Server 2012 R2 with 16GBRam

I'm trying to convert a CSV into separate JSON files, one JSON file for each row. The CSV has about 15 columns and is plain text.I'm hoping for each file to end up with JSON looking like this. { "type" : "kb", "id" : "1", "data" : "xyz" } But instead, the JSON data is embedded in an array. In my case, I need each file to not have the array or the files won't import successfully to ElasticSearch.Here is how the JSON is coming across.[ { "type" : "kb", "id" : "1", "data" : "xyz" } ]My ConfigurationI've tried this multiple ways but the latest attempt is very simple. A CSV Reader reads the CSV file and then connects to a JSON Writer. The JSON Writer has the "Fanout Dataset" checked and the Fanout Expression is "@Value(id)" which is a column in my CSV that I want the files named after. One thing to note is that the files wer

I have an Excel Table with two columns as shown in the picture below. Additionally I have a bunch of features which holds an attribute named INFOTEXT. I would like to compare this attribute of each feature with the SOURCE-column of the Excel. If the string of INFOTEXT and SOURCE is equal I would like to add a new attribute with the content of DESTINATION column on the same row. Is this possible with FME?

Hi,I'm exporting numbers to an EXCEL template. When I open the file in Excel some cells are marked with a green triangle and the following information is displayed: "The number in this cell is formatted as text or is preceded by an apostrophe".This only happens to those cells for which I perform a division in FME. Other cells where I only have numbers or sums are not affected.The problem also occurs if the template is just an empty Excel file.Any idea how to avoid this? Is there any setting in Excel writer or do I need re-format those numbers before they are written? I tried already to explicitly convert the numbers beforehand (@double(<float>)) but to no avail,Thanks, Rob 

Not able to read GDB database file..Database file link - http://fargo.nserl.purdue.edu/RUSLE2_ftp/NRCS_Base_Database/Latest%20Base%20Database%20and%20Updates/Database file name - BASE_NRCS_MOSES_03302016.zipActually my objective is just to read gdb file and transfer its data to postgres database.

Hello, I have DWG file and I was wondering if I can somehow transform it to a GeoTIFF or just TIFF? Thank You in advance

We want to use FME server in order to copie/backup files , Application , database and store it in safe area , at the oment the task is done manualy , each time system admin will have to go trough all those files , and backup the to the specific location

I used the reader ( directory and path file name ) and writer ( file copy ) to move all file from folder A to folder B, is there a way we could move also the subfolder in A to B and keep, instead of creating a reader for each subfolderis it possible to write it a zip file all this is used to backup dataThanks

Hello,I am looking for an easy way to get the user select the tables that they want to read and translate before the workspace runs. Is there an easy way to set this up using FME transformers or it has to be done resorting to other methods (i.e python scripting with specific postgis drivers) and if so, could I get some help on how to accomplish this?At the moment I have a creator, an SQL executor that extracts all tables from the schema I want the tables to be selected from, how can I convert this list into a parameter and then let the user select the tables they want to be then submitted to the PostGIS (or generic reader maybe) to then work with only that subset of tables?

I am trying to convert Excel file to KML. There is a column RPN# with the project number like RPN-123456 and also hyperlink embedded in it that opens local folder on the server. I have done this before with AutocAD file but I am having issues exposing attribute in Excel file. I attached pictures of the workflow. When I run translation I do not see RPN# in KML file, what am I missing here. Instead the dot representing RPN# shows generic kml_1 or something like that.Thank you very much.