Authoring

I am curious to know if Oracle connection is shared between FME workspaces and transformers.For example, I have a workspace which has SQLCreator, SQLExecutor, and Workspace Runner among the others. The workspace in the WorkspaceRunner will also have a bunch of SQLCreators, SQLExecutors, as well as FeatureReaders and FeatureWriters.My question is will they all share the same Oracle connection/session?  

I have a Feature Writer configured to write a csv to a parameterised path. In FME Server, this is configured as a Resource Path. This works OK and writes to: \\FMEServer\\resources\\data\\file.csvA subsequent (text) Feature Reader uses the same parameterised path (with the filename). Unfortunately this appears to read from \\FMEServer\\repositories\\repository\\workspace/file.csvRefer attached - have I configured this incorrectly or is this not supported? This is for: FME Server 2016.1.0.1 - Build 1649  

Hello,When I try to connect to existing stored database connections or new database connections. I get the errors outlined below. The error sound like either a java or permission error. Does any one have advice on how to figure this issue out?Thanks!Background InfoSQL server and SDE connectionsCan connect to local (SQL Lite) databaseI have previously connected to all the databases I currently can't accessI currently have permission to access the databases, tested with SQL server management studioIssue appeared in the last week or soConnecting with windows authentication (not server authentication)Desktop bit FME(R) 2018.0.1.0 (20180518 - Build 18310 - WIN64)Similar to these topics:https://knowledge.safe.com/questions/70504/can-not-add-a-database-connection.htmlhttps://knowledge.safe.com/questions/71360/fme-20180-getting-error-trying-to-access-or-create.html SQL Server and ArcSDE I get the error:"Unable to Retrieve connection NameOfConnection Please check log file. The message

Hello,My FME Workbenches crashes when I choose to add a tester transformer to the canvas.My installation:FME Desktop Oracle Edition (floating)FME(R) 2018.0.1.0 (20180518 - Build 18310 - WIN64)Every time I add a tester, the workbench just crashes, no warnings, no nothing. Is this a known problem or can someone help me out? Already tried reinstalling. Thanks in advance!

Hello,I would like to run simple maintenance arcpy scripts on feature classes after a load. Without reading those feature classes. Example of scripts: attribute index, spatial index, extent calculation: arcpy.AddIndex_management(in_table="C:/Users/xxx/Documents/ArcGIS/Default.gdb/tablename", fields="Name", index_name="name_1", unique="NON_UNIQUE", ascending="NON_ASCENDING")arcpy.RecalculateFeatureClassExtent_management(in_features="C:/Users/xxx/Documents/ArcGIS/Default.gdb/tablename") For both file geodatabase feature classes and Enterprise Geodatabase. How do I achieve this with either a shutdown python script or PythonCaller / Creator? Thanks

I’d like to create a multi-page word document grouping text, table, raster map with point and image per page. I’ve managed to do this in PDF using PDFPageFormatter but can’t find equivalent functionality in word transformers? I’ve looked at MSWordStyler and MSWordGnerator but still can’t see how to group items to write to individual pages. Can anyone help?ThanksChris

Hello,Screen shot attached is an answer from HERE API. What I do not get is : why I only see the first 3 attributes in the TableView window within the Inspector ? If I can understand a little more on that one, that would be helpful to then process info from response.isoline{*}.component{*}.shape{*} (encoded: UTF-8) records especially.Thank you for your inputs, regards.

I have to two geometry (Polyline), segment lengths are different and spatial aligned. I want to transfer the attribute of 2nd geometry to 1st geometry? Some attributes of the segment are calculated on the bases of length. I only need to transfer attribute which is overlaped by 1st geometry segment.

Hi, I have a model in ARCGIS model builder that perfectly iterates through features. What i do: I grab a polygone from a dataset make buffer around and than clip over it 3 other shapes - I would like to do this for 30 polygones (each with uniq ID). In FME workspace i built a complex model with a tester transformer, but it it is too complex, because one of the shapes that overlays and have to be cliped has over 7.5 million of rows.Any solution? Thanks

My dataset has an attribute that contains a list of item descriptions and hyperlinks:Item 1|http://www.item1.com^Item 2|http://www.item2.com^Item 3|http://www.item3.comI'd like to change the contents of the attribute into a bullet list in Markdown:* [Item 1](http://www.item1.com) * [Item 2](http://www.item2.com)* [Item 3](http://www.item3.com)What would be the best way to do this? The list in the attribute can contain zero, one or n items.

I have point feature with duplicated and sometimes tripiclated or more. But for each point we may have the attributes with different values. My goal is to have only a unique point, but keep all the attributes. So I used the Matcher (with generate list enabled) and then ListConcatenator connected to SingleMatched output. It's work perfectly, I have now only single unique points and I setup the counter option, so I know how many points this single point represents. If I click in one point in the inspector a can see all the attributes and expand the nested list. I have up to 6 list for some points. What I want to achieve is to be able to export the point to feature class and keep all the nested attributes from the list. Is that possible? Will be like expose the nested list.Thanks in advance,Dilson

My workspace has a python startup script which calls a REST API and downloads and saves a zipped file geodatabase in zip file called out.zip. The zip file is then unzipped into a Downloads folder. However, because the zip file also contains a folder, and the folder name changes each time (out of my control), I don't know where the final file geodatabase will be located.For example, when I run the code, the location will be something like this:...\Downloads\20181018\QSC_Extracted_Data_20181018_103130077000-7024\data.gdbThe next time, the location will be:..\Downloads\20181019\QSC_Extracted_Data_20181019_111958123000-8024\data.gdbIt's that folder right above the data.gdb which changes.My workaround was to have a python scripted parameter which searches the date folder (20181019) for a file named data.gdb and return the path. However, it seems that the python scripted paramter is run at run-time prior to the download of the file geodatabase and so, when the translation begins, it can't fi

When I try and perform a backup using the ‘Backup to Download’ option in the FME Server Web UI (v2018) it says the process failed but when I look at the log file there are no reported errors and in History the status is marked as success.

On the Backup & Restore page in the FME Server Web UI I choose to ‘Restore from Upload’ and upload my .fsconfig file but when I try and ‘import’ the restore fails but no errors are reported. What else can I do?

Does dynamic reader and dynamic writer works for legacy sde in FME 2018?

I have a couple workbenches that retrieve data fields and pass them to a second workbench as @Value(xxxxx) using the FMEServerJobSubmitter. In desktop 2016 the values comes through to the second workbench (on both desktop and server) as @Value(xxxxx), how ever when using desktop 2017 no values reach the second workbenchAbove has the @Value(SITUS_CITY) using DT 2016 on Server 2017Above is missing @Value(xxxx) using DT 2017 on Server 2017

I need to create an FME workspace where I query the applicant id's in a table and then loop thru those passing each to a web service call. The return value will then be put into a table with the id passed out to the web service.

I have a Workbench file that invokes other Workbench files (using FMEServerJobSubmitter). These called FMW's do all the work as far as reading and writing records is concerned. As a result the parent is shown to have read 0 and written 0 records. I would like to be able to pass the information on how many records are read and written by the child back to the parent and have those values appear as the number of records read and written. Is it possible to do this?

Hi I have used Directory and File Pathnames to get the latest file name from a directory containing a list csv files.I then try to pass the fme attribute path_windows to a FeatureReader to read the csv file (see attached). However this is not working. When I click on Preview, I expect to get a preview of the csv data. Also, it doesn't output the data from FeatureReader when I run it.Any ideas

I am using an attribute creator that is given a List of coordinate. From that list i want the last x value( or the second to last in my example). How do I do it?In this picture I have tried calculating the number of elements in the list with a list element counter and then i simply write: @Value(_indices_normal{@sub(@Value(_nbr_indices),2)}.x). However this return a sad <missing>.  I haven't been able to find anything in the tutorial: Tutorial: Working with List Attributes or the links provided in it about this specific problem. The closest to an answer that I've found is this lecture slide show: list-manipulation-in-fme.

I am using a chopper to extract vertices from lines. I want to get the order of these vertices for each line and have that stored in an attribute that I would like to copy to a csv along with the coordinates. I was able to get the coordinates but not the vertex order. What is the work around for this?

Watch out for this gotcha if you're using a FeatureReader on formats like Microsoft SQL Server: You can specify a Where Clause as part of the SQL Server Reader parameters, AND in the FeatureReader Parameters as well. This creates the possibility that one Where Clause will conflict with the other as in the example below. The Where Clause in the FeatureReader parameters appears to override the one in the SQL Server Reader parameters. So if you're wondering why the wrong number of features are coming out of the FeatureReader, check the Where Clauses...

Mark2AtSafeHi Mark Hope you can help me out with questions in regards.1) I am using arcgis and FME 20182) In FME, I am trying to do an analysis and results output I would like to have the destination attribute fields based on Multiple source featureless. So I am flowing the same method used in the below article. “I have following this https://knowledge.safe.com/articles/33838/dynamic-workflows-destination-schema-derived-from.html” I am not able to get this working.3) I have got two parts to achieve :a) I want the results of output to be split in different folders – example from featureclass B on the attribute value field "E" -I managed to do this by fanout @ value C b) I want the results of the multiple feature class to have the specific attribute in the output and I wanted to remove some of the unwanted fields – Example : FClass A with attributes A,B,C & CLASS B (D,E,F,G) The output results of special selection with criteria class A & to have the attributes value(

I am trying to run FME workbench with input and output file destination and directory. This workbench is copying file from one directory and pasting in another directory.I tried with different methods of IFMEStringArray but doesn't seem to work and I can't find documentation on the internet. IFMESession createSession = COM.safe.fmeobjects.FMEObjects.createSession(); IFMEWorkspaceRunner createWorkspaceRunner = createSession.createWorkspaceRunner(); IFMEStringArray createStringArray = createSession.createStringArray(); createStringArray.append("C:\\\\test\\\\test.csv"); createStringArray.append("C:\\\\test2"); createWorkspaceRunner.runWithParameters("C:\\\\test\\\\Initialization_VIC_DataSet.fmw", createStringArray);Above is my code. Can someone please help?

Hi,I'm trying to connect to sftp server by creating subscription on FME server 2018.1.0.2 to upload some files to sftp server, but I get this error "Host name is invalid", however I use the same host name on WinSCP and works normally. what am I missing?can someone please explain what shoudl I do and what steps I should take.I flollowed the steps herehttp://docs.safe.com/fme/html/FME_Server_Documentation/Content/ReferenceManual/SFTP_Subscriber.htm ThanksSaman