Creating and organizing workspaces. How to use Workbench.
Recently active
I'm trying to create multiple attributes during a loop depending on the amount X. If x = 3 the attributes created should be Foto_doc,Foto_doc2 and Foto_doc3.I have a working flow with loop in the below example but the attribute creator does not work correctly with the @value(attribute_name) option. Is there something missing in this flow or is it not possible to use attribute values for naming attributes during a loop?
How do I insert a loop from within another loop to a text output. Ex: main text 1secondary text 1secondary text 2main text 2secondary text 1secondary text 2
Hello, I'm trying to use FeatureWriter, output format SHP. The output SHP name is linked to a parameter, but I end up with a SHP myparametervalue_polygon?How do I fix this?Thanks for any suggestions.
Hello, I have these recordsNoticeNr Coordinate ListID1130 56-41N 11130 56-30N 21130 001-57W 31130 001-29W 41134 52-15.0N 002-30.5EI would like to aggregate the NoticeNr 1130 to two records having the following coordinates (56-41N 001-57W ) and (56-30N 001-29W). The goal is to have it as NoticeNr 1134, so the order (Listid asc) of lat long values in the table should be respected. What is the best way to do so? It is also possible that there are more than two records for longitude and latitude.
Existing SAFE software appears to have a new cloud component, FME Cloud. We are interested in purchasing this component but I require software prerequisites to support FME Cloud. Please reply back letting me know Browser support and if there's any other software component required like .NET Framework, Browser Add-on etc... Thanks! -Matt
Good morning! Has anyone used a FeatureReader in a workspace but set the dataset with a path that included a parameter?The issue I'm having is because the parameter is there and not the actual file, the reader is not able to determine the structure and I get this message:Has anyone encountered this?
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