Data

I am reading in a postgis table with a hstore column. I want to create attributes from all the fields inside of it. What is the best way. Since I need the spatial index I was under impression I needed to read in with postgis reader. My python is not great so hoping it can be done without using python.Any help would be great.

Hi, I am new to FME, just learning bits and bobs as I go.I am trying to connect an sql reader to a non spatial sql server.No matter what I fill in for the connection it fails. The sql server is on a another pc which is part of a domain. For the server field of reader should I be writing an ip address or domain name or pc name too?Any guidance would be appreciated.

Today I noticed something about reading the same geodatabase feature class twice, using multiple feature types within the same reader. FME doesn't do this.I had one single merged feature type set up, to process all data within the geodatabase. This was the only reader in the workspace. At some point I needed one specific feature class from the geodatabase for a specific function, so I used the "Import feature type" function to do it. From there on, that feature class would no longer be output through the single merged reader, but only through the separate one. Suddenly my workspace was no longer outputting all data from my geodatabase, since the separate feature class was discarded halfway through the workspace. However, there was nothing that indicated that this was going on - looking at the properties of my single merged feature type, it still claimed to read all feature classes. Disabling the separate feature type did not affect the single merged feature type - it stil

I'm attempting to limit the number of records being read on multiple file geodatabases by setting the WHERE Clause parameter to yesterday's date:    Edit_date BETWEEN SUBDATE(CURDATE(),1) AND CURDATE()     "Edit Date" is Field Name and the Data type is Date.  I've tested a few different SQL statements, but can't seem to get the right combination? Is this the right approach or is there a better way?  Gary

Hi All,I want to see smallworld data in FME workbench using FME reader. Actually i tried the process same as Shape file but it displays Errors.

Hi,There seems to be a bug in the FMEServerEmailGenerator transformer. I had some issues in FME 2015 and hoped it would be fixed in the newer realeses in 2016.However when I recently updated to the present realese (2016 b16492) the problem still remains.When attatching a file, or several, the JSON messege that builds from the transforemer add the attatchmet twice in the text_line_data output. Therefore the Email won't be sent to the receiver.I have used a workaround with StringReplacers to get rid off one of the attatchments and made it work like it should. The problem is that I have to customize it every time I want to use a different massage or attribute to post. So it would be great to have this bug fixed in a new patch in the future. Thanks in advanceAndré

Hi There,I'm hoping someone can give me a hand with this problem. I've recently attempted to read a kml file from a url and bring it into my workbench.However, whenever I attempt to read it in FME 2016.1 claims there was an error and says: "Dailed to decompress to 'temp path location... - Failed to initialize the reader'. I've attempted to download the kml file and read it into my workspace from a file path and it works fine. Does anyone have a thought as to how I could fix this???Thanks,Warren

I am trying to read from an Esri SDE and write to a shapefile, but the length of the attribute names are causing problems for the writer. I've tried using AttributeRenamer to manually make all the attribute names under 10 characters, but is there any other way to address this problem? I'm using FME 2014.

Hello all,This question has been asked before, but despite an example found here i still can't manage to get the description-attribute from the following kml-file: . Somehow FME sees the values for the kml_description (and kml_description_raw_text and kml_description_text) attribute as missing. I know for sure there is a description as i see it when opening the kml-file in Notepad++. What i do see, when sending the data to an inspector is three attributes:- kml_description_b (with Value Onderwerp:)- kml_description_b{1} (with Value Status:)- kml_description_b{2} (with Value Nummer:)So the field name has become a value and the original value is lost.I hope someone can help me with this. I've also been trying this with the Esri ArcGIS tool 'KML to layer'. Then i do get the description in a feature class, but somehow all locations are placed at the same coordinate.Greetings,Antoon van HamCity of Eindhoven, Netherlands

Hello,since updating to 2016.1 I have a problem with my sql statements to execute after translation. I need to update sequence values, because I am manually inserting data into serial column. However I am getting following error:Error executing SQL command ('select setval('$(Schema).unip_property_attributes_id_seq', (select max(id) from $(Schema).unip_property_attributes))'): 'ERROR:  syntax error at or near "$"LINE 1: ...property_attributes_id_seq', (select max(id) from $(Schema)....                                                             ^'PostgreSQL Writer: SQL statement To Execute After Translation failed; see above for detailswhere unip_property_attributes_id_seq is the name of the sequence I am trying to modify (set value) and $(Schema) is a published parameter where the name of the schema is stored. Seems like after updating to 2016.1 there is some problem with addressing published parameters in sql commands after translation, because $(Schema) parameter used in sql executor

SDE_ERROR_CODE(-25) Insufficient permissions

I'm a new FME user, so any help would be greatly appreciated. I'm using FME 2014. I have a workbench with just a reader and a writer. The reader is set to start reading at row 2. This works great until I save the workbench and go back in, and then it seems to reset to start reading at row 1. This has happened twice so I don't think it's just me? Can you point me in the right direction? Thanks!

Hi Folks,New user here so I appreciate your feedback (and understanding). I am working with a KMZ and while I am able to write it to a MicrostationV7 format, it falls in the right place but I am only getting a simple line style as my only feature in place of the Placemarks. I would like to give them style and weight as they are so tiny I can barely see them in my map. Is this possible? Or am I looking at having to work in Microstation to "amp up" the symbology (points and lines).Thank you for your feedback! Enjoy your day.

Is it possible to set the ArcGIS Online properties (Description, Access & Use, Properties) when uploading a feature?

Hi all,I'm trying to translate an Access select query to a FME script. I have two Excel files in Access: one that contains data (LINC_RawData) and a comparison file (Linc_Recoding_Scheme)Below select Access query shows records that have a value in the "Category" field and that do not have a value in the "UID" filed.How can I translate this to FME? Basically, all data should flow through to a writer except when it matches above query, I'd like it to appear in a separate output (or list / filter)Thanks,Ed

Hi ,Is possible to have a relation table (Like a transformer) between microstation reader and ESRI.ArcGis writer ???.I explain , there is any way to assign diferent values of attributes in the writer in function of the values of attributes of the reader codifieds in a Excel or Acces ??Any idea ??? , thanks in advanced for your help , regards !!!

I am writing data as different users to a ArcSDE Geodatabase via .sde connection files. How to make settings to automatically match each users' data to corresponding connection file?

I create a CSV and define the schema at creation. if I modify the csv, I cannot go back and edit the fields (add or rename) as all of them are grayed out, I can only delete and recreate the reader to do this update.. is there a way to edit the csv reader once created? thanks!

Writing spatial index on File geodatabase with a specific grid size

Hi,is it possible to create password protection on AutoCAD dwg files?Thank you.

I am trying to join attributes from three SDE tables into an SDE feature class. I keep getting an error saying "Column 'Customer_ID' of type 'char(50)' specified in mapping file but not defined in existing table 'PARKS.CEMETERY_SPACES_BURIAL_CUSTOMERS'", where 'Customer_ID' is a new field I'm adding from one of the joins, and 'PARKS.CEMETERY_SPACES_BURIAL_CUSTOMERS' is the feature class I want to write all of the results to (I have built it so it has all of the resulting fields already created, but it is currently sitting empty). Has anyone seen an error like this before? I'm using an Esri ArcSDE writer and reader.

Hi, I have an XML-File which I read with flattening. Part of the XML structure is something like:<element>   <points>       <startPoint>          <value1></value1>          <value2></value2>       </startPoint>       <middlePoint>          <value1></value1>          <value2></value2>       </middlePoint>       <endPoint>          <value1></value1>          <value2></value2>       </endPoint>   </points></element> StartPoint and Endpoint must occur once, middlepoint can occur many times. I have to transform this in a structure like:<element>   <newpoints>       <pointNumber>       <value1></value1>       <value2></value2>          </newpoints></element> Obviously newpoints must occur at least twice. Any Suggestion how to combine those points with different attribute-names into the newpoints?Thanks!

Hi,so, is it possible to add digital signature to AutoCAD dwg file and how?Thank you.

When translating an object with multiple lines of text into MicroStation is there any way of setting the line spacing. Currently it automatically sets to "0"

My dgn file has a rectangle shape in level 60 and I'd like to extract all elements within that shape and create a new dgn file.