Authoring

Hi,    I have SQL Server Non-Spatial writter with ~80 tables (features). How can I set to insert into identity column for all features and Key column, too? It is same column name for all features. Is there a way to do this, without setting to every feature separately?    Thanks!

Hi,     My workbench is published in FMEServer. At the end of workbench execution, i have to log the generated LOG file and FFS file complete path in database . I thought of doing it in shutdown script. But i do not know how to get their location.  Any pointers will be highly helpful.  Thanks. Subrat

Hi Folks,  I'm having a bit of a moment. I know this is possible and have done it before, but can't remember how nor find out how from the docs.    I have a text writer. I'd like to set its destination using an attribute.  So:    fme_writer_dest = "c\\:thisdir\\filename.txt"    How do I do this? I don't want to use fanout due to its limitations for my scenario.    Anyone know what the attribute name is?  Thanks.

Hi,    I have many attributes with len 13. Need to remove first 5 characters of each of them (these 5 can be different). E.g. att1=1001478577259          att2=1247833654578 and so on.  need to get : att1=78577259                         att2=33654578 How to do this without putting multiple SubstringExtractors?

I have created a string of feature types that I pass into the FeatureReader that looks like this: "'D:\\LiDAR and Such\\Las\\CoV_4900E_54590N_BE.las':'D:\\LiDAR and Such\\Las\\CoV_4900E_54580N_BE.las'"  That is, each LAS file that I want the feature reader to read has the full path, enclosed in single quotes, and separated by a colon, as the documentation specifies. I have also tried it without the outer double quotes. In the Query Operation screen I select Query the feature types specified in the attribute below and select the correct attribute.  However, nothing goes through the LAS or Other ports. I have tried putting in a relative path to the LAS files, but nothing works. What am I doing wrong?  Thanks.

Hello,   I am trying to disconnect users of SDE using python . When I use the below code   arcpy.DisconnectUser(arcpy.env.workspace, "ALL")  arcpy.env.workspace = r"C:\\Connections\\SDE.sde"  I am getting an error  Python Exception <TypeError>: Could not open SDE workspace.  Has anybody encountered this error ? Any Ideas ?

Hello everyone,  I have a set of polygons that I would like to chop into a grid, create points on each corner, and create an id for each point starting from the southwest corner of each 12x12 area. Each polygon gets divided into a 12 x 12 grid and the corner points of the grid would be something like PolygonA_0,0 at the southwest corner 0,2 0,2...0,12 all the way up to PolygonA_12,12 in the northeast corner. This would be the same for each larger polygon. It woul be just like a point grid created by the 2dGridCreator.  So far I've use the Tiler to divide the polygons into the 12x12 grid and a TopologyBuilder to get the nodes, but I am a little stumped on how to get the IDs for the nodes.  Does anyone have an idea on how to get these iIDs populated?  Thank You Justin

Hi all, if i launch a workbench, it executes no problem but i see this error into log file when i checked "Log Debugging information" from Tools==> FME Options==> Runtime=>Log file Default". ERROR |BADNEWS: File C:\\Program Files\\FME\\metafile\\MULTI_WRITER.fmf could not be opened (tabrdr.cpp:997)  ERROR |BADNEWS: File C:\\Program Files\\FME\\metafile\\PythonFactory.fmf could not be opened (tabrdr.cpp:997)  ERROR |BADNEWS: File C:\\Program Files\\FME\\metafile\\QueryFactory.fmf could not be opened (tabrdr.cpp:997)  What that means this error?  Thanks an advance.   FarFar

I have a problem where I am trying to load a specifically named .csv file into FME. Basic right!?!? The problem is that the dataset I am loading is broken up in subfolders.  For example, I am opening “Folder A” with a hierarchy of “Subfolder A”, “Subfolder B”, “Subfolder C”, and so on. Within each subfolder is CSV file named “example.csv”.  I need to batch grab “example.csv” out of each subfolder. I considered using “Merge Feature Type” option but I’m a little rusty on how to structure my *\\**.csv setup.  I hope I’ve explained this well enough and would appreciate any direction on how to merge the CSV files (of a specific name) as a reader in the subfolders.  *Note, in the meantime, I manually added the 100+ files as a stopgap but it’s not an elegant or sustainable solution.  Thanks,   Matt

Hi,  When using 'Fanout by Attribute' on MS SQL Spatial Writer I can't seem to get it to write using the Database Username, it always writes out to dbo.  Is there a tip or trick I may be missing?  Thanks 

What is the difference between static and dynamic schema when adding a writer to the workbench?  Regards,  Hani  

Hi ppl,  In a workspace I have several published parameters all have the same type (choice), when prompting the translation, some of the parameters have a extra button to select attributes (which is not ncessary) and some do not. Anybody an idea on how to make the extra button go away? what is causing this difference?  Cheers, Itay

Hi, i  have one fme flowchart and, in that flux, i have a lot of repeated transformers . So, the problem is: is there a way of change the parameter of all transformer at the same time, or i have to change one by one? Thanks !

Hi,  If I define a published parameter for a custom transformer, a menu button always appears in side of the parameter input box.   I want to hide or disable the menu button; the interface like Copy Number Attribute of the Cloner is what I want.   Is there a way? Thanks in advance.  Takashi

I have an FME workspace I run monthly. It compares old data with current data. The old data is usually last month's data with the date stamp as part of the name. Because the feature type changes each time, I want to be prompted to select it. I can't simply use feature types to read because new feature types are being added to the file geodatabase each month (i.e. - it's not a static list). I need FME to read all the feature types in the file geodatabase at runtime and then prompt me to select one. Is there a way to do so? (Win7 64-bit, FME 2014, Build 14230, 32-bit).  Thanks,  Aaron Albuquerque, NM

I have installed FME Server 2014 and would like to set up the data distribution html / js / css files as in the demo at http://demos.fmeserver.com/datadistribution-googlemaps/index.html. However, I can't find the web root of the FME Server Web Application Server. Where is it, such that when I go to:  http://myhost:8080/fmeserver/datadistribution.html   ...I wil find that datadistribution.html page?  Thanks

Hello all ,   I am trying to read all the file paths from a text file which is going to be the source file paths for the dynamic reader . I am using below private variable to generate the source reader's path  # Get the file from a published parameter ListFile = (FME_MacroValues['Config_File']) f = open(ListFile,'r') featureTypes = '' # Read the file and add each line to the featureTypes Variable featureTypes = f.read() f.close() #Return this list to the parameter return featureTypes  And I am publishing it to FME Server . When I run the job I am getting error saying it cannot read "C:\\temp1 C:\\temp2 C:\\temp3" .  Any suggestions ???

In a spreadsheet I need to compare the value of an attribute in record 1 to the same attribute in record 2, then move on to compare record 2 with 3, then 3 with 4 and so on.  What is the best method?  Cheers,  

I need to load data from multiple reader to a single writer . I would like to take a backup of the current data before the process begins . I would like to set the option to truncate the features in the output GDB and reload from all the readers . During this process if it fails is there any way to roll back the process ? Can anyone help please . Thanks 

Hi, I'm trying to identify what open source components/libraries (and specifically, what versions) are used / deployed with FME2014, but I can't find any definitive statements about this. Does anyone have any info, or can advise?  Much appreciated, Pete

Hello,  I have noticed that FME Data Inspector is taking to way too long to open sometimes about 30-40min. It stays on splash screen. Also FME workbench doesn't end translation it keeps running for any simple translation even after following message in log window --------------------------------- Translation was SUCCESSFUL with 0 warning(s) (6 feature(s) output) FME Session Duration: 2.5 seconds. (CPU: 1.5s user, 0.6s system) END - ProcessID: 984, peak process memory usage: 134752 kB, current process memory usage: 134752 kB ---------------------------------- Everytime I have to terminate it by clicking "stop translation" button.  Is there any reason for this?  Thanks john

I would like to do what has been beautifully described on the following blog.  The issue is that I currently have FME2013SP1 and the blog is using newer transformers (NullAttributeMapper and newer functionality of FeatureMerger)     http://fme-memorandum-takashi.blogspot.ca/2014/02/merge-two-lists-so-that-elements-will.html    I am looking for suggestions on how to get the same results but by using what is available in FME2013SP1 (until I am able to get 2014 installed).    Thank you

I am to use public parameter to append to SourceDataset macro. I want to keep initial folder fixed in my case it's /roor/FME/.  Steps taken -Define Published Parameter as INPUT_DATA which will contain relative e.g. path /data/shape/1.shp. -Append above param to SourceDataset_GENERIC by "/root/FME/$(INPUT_PATH)"  This is working well on my windows machine (FME Desktop 2014) but when I publish it to FME server (linux) somwhow it is retaining a reference to my windows machine's path as a result of this it's throwing an error as "No Shape Files found to process in directory `C:/root/FME/data/1.shp'. Check directory and ids statement in mapping file"  I am struggling to find a reason for this behaviour.

I have a workbench set up in FME 2014 that makes use of dynamic schema to convert a large number of TAB files into shapefiles as wekk as reproject them into a different coordinate system.  However there are certain tab files that are corrupt and so when I run the workbench it keeps failing. Is there a way to get the workbench to skip the files that are corrupt?

Hi all,  I have managed to make workflows using transformers and workspacecallers. Create any attribute and acces them without exposure. Took me 4-5 days to figure out, works like a charm!  It is based on the solution i provided for community question by Robbie B Creating dynamic attributes per "fme_basename"  If anyone is interested i can elaborate next week. (i'm off now..:)