Data

I've been trying to read CSVs from inside Zip files in 2017.0 (did some testing with 2016.1 as well). For example, I have 5 Zip files each containing 1 CSV.If I try C:\\Folder\\**\\*.csv, FME won't even create the Reader (I get errors like "CSV reader: Failed to open file 'C:\\Folder\\**\\*.csv' for reading. Please ensure that the file exists and you have sufficient privileges to read it").However, I discovered that if I edit the Source CSV File value in the Reader parameters, and manually set it to C:\\Folder\\*.zip\\*.csv then it works. Select Merge Feature Type to get all the CSVs presented as 1 Feature Type.

We want to be able to monitor an open FTP service but the Publication Service requires a user?

Hi there. I'm trying to update the .dwg Attribute autocad_text_string with attribute values from a corresponding excel file that was created from the same .dwg and manually corrected. The xlsx file is structured in a way that each sheet represents a layer corresponding to the .dwg and the column header is named autocad_text_string.The feature merger only takes the first column value of an excel sheet and gives all other dwg attributes of that layer that same value. Do you have any suggestions how to update each features autocad_text_string with the corresponding row value from the excel file?

At the end of our fiscal year, I would like to take the data that has "2018" in the title (a couple of feature classes and around 70 tables) and rename them to replace 2018 with 2019. Going from our production environment to our development environment. Using the readers and writers I see it can happen but I would need to manually edit the year. Is there an automated method that would replace the year in the title of each data file? I have not used FME before so this is all new to me.

I am creating a workbench to convert an excell spreadsheet using csv file into dgn to display coordinated refererence marks in microstation. This displays in Inspector ,however when the dgn file is used in microstation, points or cells does not display in microstation. Any way of showing a point or cell point in microstation using particular transformer(s) so this information displays in microstation? Further, is there a utility workbench that can assist me with this issue?Thank you in advance for any assistance you can give me.

Hi,I'm passing ID, fme_db_operation (as UPDATE) along with point geometry (set with GeometryPropertySetter) to small world writer.I'm receiving error as mentioned below...2017-12-14 01:12:08| 3.9| 0.0|ERROR |Smallworld Translator Error: No URN handler for class unsetWhether I'm leaving any other important attributes to pass to writer...

Hi,Is it possible to publish to FME Server old scripts developed in .FME, .FMI Files ?Thanks.

I have a problem with writing to microstation tag I want to write the tag to a different level than the cell I use microstation V8i and my input is shape

I have several .dxf files of bathymetric data that I need to convert to LAS files, they contain the following: Bathymetry (contour lines), Sounding (points), 1Xanno (points) and 0 (no idea). I am new to FME and managed to figure out how to convert .xyz files to LAS but these are a lot more complicated.Thanks,LG

I am trying to migrate shape files data into smallworld by using FME. After configuring workbench i got bellow error's.Smallworld Translator Error: No URN handler for class unsetSmallworld Translator Error: Access denied to C:\\FME WORK\\enum_check\\Kofra_enum_log_report.csv.Thanks in advance for your help.

Does anyone have a way to Update or insert rather than have Writers that Delete and Insert. Something Oracle Merge? ThxMERGE Purpose Use the MERGE statement to select rows from one or more sources for update or insertion into a table or view. You can specify conditions to determine whether to update or insert into the target table or view. This statement is a convenient way to combine multiple operations. It lets you avoid multiple INSERT, UPDATE, and DELETE DML statements. MERGE is a deterministic statement. You cannot update the same row of the target table multiple times in the same MERGE statement.

Hello,is it possible to convert 3D shp file to 2D? If so, how can I do it?Thank you!

I'm upgrading the way we build data samples to use FME Desktop. With vector data, I'm using  a dynamic reader (to save individually handling of many tables), passing through a Clipper to restrict the area and finally writing the output. It's simple and works fine, except... the field indexes on the output are not maintained. Having to put these in manually or in external software sort of defeats the purpose of using FME! Is there a way of preserving attribute index (and spatial ones for something like Esri Shapefiles) using a dynamic read/write workflow?  Regards, Warren

I need to create a csv-file with a special structure. I 've two problems which I haven't an idea how to solve:1. How can I add a file-header before the actual content (The yellow part on the picture)?2. If an element has more than one coordinate pairs (in case of a line) how can I add the vertexes and the end-point on the same row (The part witch is in blue on the picture)? Yellow: File-header Orange: Column-Header Shades of Blue: Element coordinate(s)

Unable to create NETEZZA SPATIAL READER, but it does able to create spatial writer.|ERROR |IBM Netezza Spatial Reader: No spatial package detectedAny ideas please? Thanks,

I tried creating a kml_open attribute and set it to 1 but it doesn't expand the folders. Examining the markup, it doesn't appear that the <open>1</open> tag is applied to the root document. However if you set the kml_visibility attribute it will apply that tag to the root document.I am using FME 2017.1.1.1

Is there a way of setting the Geometry setting on the output feature type with a published parameter?

Hello, I have a problem with selecting and passing on selected parts of my table from one transformer to another.   I have two datasets - GML data called Bygning, and table with specific styles, line weights, symbology etc. From the table I need to select only those rows that have also the Bygning name, and would be used to style the Bygning GML data.     I do not know how to select only specific rows from my table automatically, based on the name of the incoming GML layer. I could use AttributeFilter and type manualy the name of the data, but I have dozens of datasets so the process needs to be automated.     My current approach is attached. It works but is not elegant.  I remove all the unnecessary data from the GML file, merge it with the table and then merge it again with data. That means I need to load data twice and due to data being huge it takes a lot more time than needed.     Can you guide me how to select the needed rows from the table?   Thanks!Sample data:

Since I upgraded to latest Build 17650 I first had problems with a corrupt FME Installation where e.g. StatisticsCalculator outputted only NULL-values (see this thread).Now I executed all our statistics batches finding out FME is now writing data in white font color with white borderlines, you can say as "white boxes". It ignores formatting of the template-Excelfile. The data itself is there, but not visible because of white color. The XLS-Template used (since 4 years unchanged) has standard formating in black with light grey borderlines...Are there any known bugs in the excel writer since Build 17291?If you change font color and borderline color manually you can see the values:

Do you know, if it's possible to write simple html code in the prompt of the parameters for a workbench in FME Cloud.I do it in Desktop (to have text color, bold or italic) and it's works good. But in FME Cloud the html is not translate.HTML Code in FME DesktopHTML Code in FME CloudHave you got an idea for this issue ?Thank youDamien

Reading an AutoCAD dwg, how do you get the entity handle of a piece of block text while also retaining an attribute to relate the text to its block?In my workbench I have the following parameters, which seem applicable, set:- Expand Blocks into Entities: Yes- Read Visible Attributes as Text Entities: YesThis gets me the block text entity with its autocad_entity_handle attribute set, but none of the attributes I can tell relate it back to the block from which it was exploded. It would seem that the autocad_block_name and autocad_block_number attributes would do this but they don't get populated.I am using FME Desktop 2016.1.1.0.

Hello everybody!I try to solve one big problem... I work with workspace which export some spatial data and all I need to do is to create envelope around exported data. BUT, I need the envelope which is composed by predefined AUTOCAD BLOCK in separate DWG drawing (e.g. frame or drawing stamp; block is everytime centered into 0,0 coordinates)... To better imagination I attached picture, where I decribed my aim.I would appreciate every help. Thank You so much!Lubo

Hi,I have to merge two tables with the common field.. one is from plain sql database and other is feature class..Here I am using Feature Merger transformer..But I have to query the data in feature class using wild card search (data) from table1.SQLDatabase-------------------(Select Code from Table1) ||FeatureMerger ----> I want to query the data FCField like Code | |FeatureClass -----------------(Select FCField from Featureclass)Any help would be highly appreciated.Cheers,Srikanth Dasari

I have a large number (~1000) Excel files that I need to import into a database table. They are many different formats, so using a reader with a defined schema will not work. I would like to have the output contain the following attributes:FilenameSheetnameRowNumberColumnNumber (preferably as a number but could be letters as used in excel)value (as text)I've tried numerous things and searched through many posts. It seems like this should be a simple task, but the Excel Reader attempts to detect a "schema" for a sheet, and it uses values it finds wherever in the excel as attribute names. Any suggestions would be greatly appreciated.