Data

Hi All,  We have a simple GeoRSS reader workbench here which we would like to publish to our FME Server. The server sits behind a proxy, so proxy authentication is passed into the GeoRSS readers advanced parameters.  Doing some testing on FME Desktop, if I set the proxy settings in the GeoRSS advanced properties, but don't have those setting set in the FME Desktop network options, the workbench hangs for a while whilst trying to call the RSS URL and eventually fails like below:    As soon as I set the proxy settings in the FME Desktop network options, regardless of whether it's set in the GeoRSS properties, the workbench runs fine. So first question is, what is the point of the GeoRSS Network Proxy parameter? If it doesn't seem to effect anything. Does the GeoRSS reader use a different HTTP Client library to other readers/transformers (i.e. HTTPFetcher)?  Also, are we able to set a global proxy setting for our FME Server, in the same way we set the network options in Deskto

Hi We are testing FME 2012 (32x) with MapInfo v12 on WIN7. When I want to extend MapInfo V12 with the FME Integration Console, I can't do it. It says I have to upgrade my licence. Is FME 2012 sp4 compatible with Mapinfo v12?  If not, we are also testing FME 2014 soon. Is FME 2014 sp2 compatible with MapInfo v12?  Thank you!

Hi,  I'm converting tiff (with tfw) file to ecw, but after transformation there is no eww (ecw's world file) neither is ecw properly georeferenced.  Yes, there is a way to georeference it by changing the extension of original tfw file, but that doesn't solve problem if you're running any other transformations (e.g. clipper) in between.  Thank you in advance.

Hello,  I need to read a file from an external Sharepoint server in FME Desktop. When I open the https link in the web browser I first get directed to a login page where I can type the username and password. Is it possible to pass domain\\username and password in the Source file parameter in FME so the Excel file can be opened in FME?  Thanks, Daniel

Hi,  Most of the docs on DGN tags are unfortunately about writing them. But I need to read them intelligently.  Tags are exposed as the list variable tag_names{}, which either contains the tag key names, or the tag values, dependent on the "Output Tags As Text" setting in the DGN reader.  And the values in the tag_names{} list is accessed used a numeric index, not the key names.  If one needs to build some logic to handle the situation, where individual objects has vastly individual tag assignments, both name wise and index wise, how does one go about that ?  Intuitively I would loop thru and test the key names, and assign the corresponding value to a variable of my choice. But as I see it, this is not possible in FME 2014 !?  Any experiences and thoughts and suggestions on - or alternatives to - this issue ?  Cheers Lars I  

I have a design file with used levels and unused levels. When reading this file in FME I can only see the objects, which means I can only see the used layers. But I am interested in the levels that I don't use. Is there any way to get to this information?  When programming in Visual Basic for example I can get information about the model and information about the document. How do I do this in FME?

I have two featureclasses in a geodatabase. These two FC are related with each other, 1st with Object ID and 'X' in 2nd featureclass. i want to update a field in 1st featureclass on the basis of 2nd FC, after it is joined.

Hi,  is it possible to connect to shape layers on an FTP site with a wild card?  for example this WILL WORK:  ftp://user:password@the.server.com/download/my_private_dataset.zip  But I would like to get this (or the same idea) to work:  ftp://user:password@the.server.com/download/*private*.zip  so the idea is that the reader would simply read all the layers which match the criteria.  Thanks for any suggestions!

Hi, I have a rather large workbench that brings features from a SQL Spatial Server and has four Feature Types that use GeoDatabase Writers. I was hoping that there was a way to bring everything into one Geodatabase that will fan out into separate feature classes. Instead it is fanning out based on an attribute, but it is making multiple Geodatabases, instead of writing into one Geodatabase with separate feature classes within it. Is there a way to configure the writers in order to get this accomplished? I attached the log from my last Translation to maybe better express what I am doing.  http://pastebin.com/taKBBib2

[Python] How to read shapefile and excel file in order to display data from the excel file on the dgn file ?  I want to choose in Python a shapefile and an excel file and merge them in order to display data from the excel file to the shapefile and have a dgn file as output.  If you want, I already have this one but I have two issues.    - Here the source dataset (parcels.tab) is a MapInfo tab and I want to use a shapefile as input. - I can't use another MapInfo tab, because I can't change the attribute PARCEL_ID to anoher. 

Hi, I am using the GeoDatabase Writer. I have no other option but to use a specific name field for the Fanout properties. I was having writing issues and I figured out that it is because these attributes have Spaces and it is causeing the problem. Is there any way I can have it eliminate these spaces in the name or replace them with Underscores? Thanks. Here is my log file. http://pastebin.com/EsSyBEQx

I'm trying to write a CSV file to a computer that is not on our domain, so I have to have FME login to it before it can write out the data. How do I pass the username:password credentials to the writer so FME can log onto that computer?

Hi,  I am using a Geodatabase writer and I keep getting the error: Geodatabase Error (-2147024894): The system cannot find the file specified. Could not open File Geodatabase dataset `\\\\Vdi-standard103\\data\\LumosM4WMS.gdb\\Line_FPA Multiports' for writing. I made sure there were no locks on the database.  I'm not sure why this is happening, do I have to pre create the feature classes that I am expecting to be written? that seems like unneccessary work as I have it set to fan out based on a name field in the SQL Server Database. Maybe I'm missing a setting? Any Help is greatly appriciated

HI All,  I never really thought about this one until now, but is it possible to featuremerge on wildcard values?  For example,  I have a point file with an ID value.  The ID values are unique.  ie A, B, C, D I have a many table of values with a ID value of A_1990, A2, A, B1,B2,BC,D1,D3,D9  Is it possible feature merge based on a wild card? ie..  *A* join to A_1990,A2         *B* joins to B1,B2,BC        *D* joins to D1,D3,D9  

Hello, I'm new to FME 2014 and trying to figure out how to transform a csar file to csv.  Can someone point me in the right direction or show the steps?  Very much appreciative.

Hi, I'm looking for best practice solutions for writing to a SQL Server database mid-translation. I need to write mid-translation because I have foreign key constraints on the database and some feature types need to be inserted before others.  As far as I'm aware there's no way of telling the writer to insert feature types in a specific order.  I would prefer to do all this in a single workspace (ie. not have multiple workspaces called by the WorkspaceRunner).  I think my only solution is to use the SQLExecutor but inserting records using this transformer is not well documented and it does not seem to provide any feedback as to it's success.  Any thoughts?  thanks, Nic 

Hi,    I have one SQL Server Non-Spatial writter with ~80 tables (feature types), and need to insert into identity column. I enable this option in each writer's Feature Type, but it is still throws me error that FME cann't perform SET operation on my table(s). What is all about?    Thanks

Hi,  Is there a way of reducing the size of a TAB file that I've created in FME?  Any help with this or info on reducing any other files sizes would be greatly appreciated.  Many thanks   Jo

Hi, I am translating a CSV file to a Sqlite3 database. Some of the entries have accented characters, e.g. "Mhaol Mhòr" - a mountain in Scotland, but after processing it is displaying as "A' Mhaol Mh�r" in the target database when I query the record.  I can't see anywhere in the writer where I can specify the character encoding.  Any help or advice much appreciated, thanks.  Jason

Hi there,  I have a fully functional workspace that dynamically does calculations on shape files contained within a selected folder. My output is an xls that is fanned out baie the “filename” attribute retrieved from the “FileNamePartExtractor” transformer.  My problem is, I need to do the same calculation for a GDB file now, containing multiple layers(such as WATER, FORREST, etc). Now obviously, “filename” only retrieves the name of the .gdb (AFR_Complete.gdb in this case) so that no longer works. I’ve also tried “fme_basename” and “fme_dataset”, but with no success.  Is there a way that I can fanout by the contents of the GDB file?   Thanks in advance

Hey  i am trying to do a simple workspace of placinig a point at Lat & Long coordinates within a CSV file  if i inspect the data i can see the coordinates   but when i link in the VertexCreator transformer and put it to Lat and Long, i get a error that it cant find the data     i have done this a few time before on different sets of data, but i cant seem to work this one out!!  cheers for any help you guys can give, i am sure i am just missing something simple!  cheers

Hi,  I am developing a workspace (published on FME Server) triggered by an email whose attachments are elaborated and the final result, an xml file, emailed back.  The xml file is not accessible from une of the attributes of the features, it is an AIXM 4.5 xml file created by the workspace at the end of the elaboration and usually stored in a file on the disk.  So I guess I should retreive that file and send it by email to the user, but I don't know how...  I think I can't use the Job Submitter and Data Download Services because I I need the email with its attachments to activate the workspace.  Does someone know how to solve this issue?  Thanks,  Alessandro

Hi,     I have two workbenches published in server. First workbench generates an FFS in server. Upon completion of first workbench, irrespective of success/failure, server should call second workbench using POST_COMMAND in SUB_SECTION with FFS location as published parameter.  I can execute the workbench on system using command line, but i dont know the syntax for above workbench call from server.  Any pointers will be highly helpful.  Thanks, Subrat 

Can the TCPIPReceiver within a workspace running on FME Cloud listen on privileged ports?

Hi, We are unable to access Excel file from shared locationin FME server,  get error "XLSX Reader: Failed to open the dataset 'given Shared path'.  Error message was 'can't open file for reading' , but the same excel from local drive we are able to access without error.  Any idea  Regards CNG