Creating and organizing workspaces. How to use Workbench.
Recently active
This may be more of an idea for an FME enhancement but I'm curious to know if anyone thinks this is possible, or if there's a way to do it...I want to create a truly generic/dynamic workflow. The source and target data and schema requirements can be driven by database tables, as can reprojection requirements. The majority of the time this will likely be sufficient to achieve what we need, however, there may be cases in which a simple source->target mapping is insufficient and we need some custom ETL transformations. Is there any way that the name of a custom transformer can be passed in as a parameter at runtime and have that transformer called during processing?This functionality could be partially met by using the WorkspaceRunner or the FMEServerJobSubmitter but both of those transformers fire up a whole new translation for each feature that enters them. What I really need is a "TransformerRunner" transformer. Something that can dynamically include a (custom) tra
I am trying to update a feature class in sde with a new one. Two of the fields in the existing table are not in the new table so I want to add them to my new table. I have tried featuremerger and not getting the results I want. This seems simple enough but featuremerger isn't copying over the additional two fields. One is modified user and the other is a Gazettedate. Any help would be appreciated to resolve this issue.
I'm trying to run a workspace from the command line and I get an error that the metadata template cannot be read, I am not an FME user and I am coding this for another department in our company. Any help is much appreciated.import osgdbW=r"C:\Users\YouDoWellItDoesGood\Desktop\1701051\DB_TGS_8171_AF2113452_30_C00_00_20170210.gdb"qcWorkspace=r"C:\Transglobal\larry_d_gester_qc_basic.fmwt"def fnRunFromCmd(gdbW,qcWorkspace): os.system("start cmd /c fme.exe C:\Transglobal\larry_d_gester_qc_basic.fmwt --gdbPath C:\Users\YouDoWellItDoesGood\Desktop\1701051\DB_TGS_8171_AF2113452_30_C00_00_20170210.gdb")fnRunFromCmd(gdbW,qcWorkspace)
Related to this post: Datetime: %s / Epoch Time / Unix TimeGreat enhancements regarding date/time manipulation have been done in FME 2017.0, but I think there still is a room to improve the behavior of Date/Time type user parameter on Workbench. 1. Currently (FME 2017.0.0.1), a Date/Time type parameter edit field only accepts a datetime string formatted with %Y%m%d%H%M%S, and rejects decimal places of seconds and a timezone specifier (UTC offset). It would be better if the field could accept datetime representation formatted with Standard FME Date/Time Format, which allows both decimal places and a timezone specifier optionally. 2. Even if you entered a datetime formatted with %Y%m%d%H%M%S successfully, it will appear with a local format in the Navigator window and the re-opened edit parameter dialog. The implicit formatting is also done when selecting a datetime from the date picker tool. It would be better if the datetime would always appear in the parameter field with Standard FME
Hi,When testing a workbench files with a large number of features, is there a way to only test a certain part of the workbench instead of reading through the whole workbench every time you run it, so as to save time?I have access to FME Desktop 2016 and 2017.Thanks
Hello All,Greetings !!I am new to FME tool and wanted to check with you folks here. We have to do a migration of few contents to Documentum, wanted to know the list of meta data files which are supported by it? Could you please help in same, will be grateful to you.Thanks,R. Singh
Hi All,In 2016.0, I have a list like this: _list{0}.class = 1 _list{1}.class = 2 _list{2}.class = 3 _list{3}.class = 5 _list{4}.class = 2 _list{5}.class = 1 I need to know how many of any given class there are with the feature.ListHistogrammer does this nicely: _histo{0}.value = 1 _histo{0}.count = 2 _histo{1}.value = 2 _histo{1}.count = 2 _histo{2}.value = 3 _histo{2}.count = 1 _histo{3}.value = 5 _histo{3}.count = 1 My problem then is turning those into attributes simply. I don't want to have to explode or deconstruct my feature further (this workspace is already too large and slow). In this example, I'd like my output feature to have attributes like these: first_class = 2 other_thing = 2 third_item = 1 fourth_item = <missing> final = 1Any ideas how to do this? I could likely do it with a PythonCaller, but surely there's a better way?
Is there an easy way to download (or backup) whole repositories from FME Server 2015.1 to workbench-files for use in FME Workbench (Desktop)? In older versions of FME Server I could locate the files in the file system on the server, but not any more.I'm not really interested in backing up the whole server configuration and I not sure how I would use that from FME Desktop.I have seen the FME Server Repository reader/writer and in the help it seems that it can be used for backup, but I haven't figured out how to do that. What I would want to do is basically do a "Download from FME Server" in Workbench, but for multiple files or whole repositories.Any suggestions?/Tomas
Hi.I have defined a custom transformation in the file "MyCoordsSysDefs.fme":XFORM_DEF Test \\ SRC_DTM ED50 \\ TRG_DTM ETRS89 \\ DESC_NM "7 parametros" \\ GROUP "Custom" \\ INVERSE Yes \\ MAX_ITR 8 \\ CNVRG_VAL 1e-09 \\ ERROR_VAL 1e-06 \\ METHOD 7PARAMETER \\ DELTA_X -130.5090 \\ DELTA_Y -89.9490 \\ DELTA_Z -145.9030 \\ BWSCALE 5.2690 \\ ROT_X 3.1126 \\ ROT_Y -0.4718 \\ ROT_Z 3.3181How can I tell FME to use th
Hi all,I have the following scenario:A "master" workspace calling 3 other workspaces on FME Server 2017 using FMEServerJobsubmitter transformers.Followed by a FileCopy writer (in the same "master" workspace) copying the files on the FME Server (using the resources folders).This works perfectly (files are created and copied to the right location).But I want to run the "master" as a Data Download service.The ZIP file is created and a link is delivered. But the ZIP file remains empty.It does not seem to collect the output from the FileCopy writer.Am I missing anything (other than the option to re-read the data using a FeatureReader and writing using actual writers)?Thanks for any suggestions.
Hi there, I don't think the Input Ordered parameter (Input is Ordered by Group in older versions) works properly in FME 2017.0 build 17271. See the following movies and attached workspace: - created with FME 2016.1.3.2 build 16717Run the attached workspace with FME 2016.1.3.2 build 16717. Looks good.Run the same workspace with FME 2017.0.0.1 build 17271. The PointCloudCombiner seems to cache all input features before starting processing, even if the Input is Ordered by Group parameter is set to Yes.Am I missing something?
We sometimes encounter a conflict between a format attribute held by the feature and writer parameter setting, especially in a case where the writer format is the same as the reader format.It may be difficult to define generic rules regarding which one should take priority, but in this case, I think the Compression Method parameter setting for the writer should be respected regardless of the value of "geotiff_compression_method".Convert Packbits geotiff to lzwHow do you think about this?
Hi,I'm new on FME and I've to copy data from a VDB to oracle. I'm working with FME 2013 SP4, I think I've to initiate a new reader with the JDBC driver but I don't know how.Is it possible to have some help/information about that ?Thanks by advance,Slop
Hi All, during the process, I use the Matcher to split up the features that have identical geometry. For this set of features, all kinds of attributes can have changed (in other words, there is no fixed ID). Hence, I would like to use the Update Operation of the Oracle writer. I cannot use the 'Match Columns', since they all might have different values,even though the geometry is equal. Is there any way to have a WHERE clause I could use? I see SDO_EQUAL, but what are the arguments for the geometry already in FME and the one in Oracle, so both can be compared? Would that be slow?I could use a delete statement and then an insert, using FeatureWriters, so I am in control of the order of execution. I was just wondering whether it would be possible to make it work like described above. regards, Jelle
Hello All, I have a .dbf table created in ESRI's UK Productivity Suite - it's simply a table to point to raster files of base mapping, with a field containing the file path to .tif files, an OID field and fields for xmin, ymin, xmax, ymax. My problem is that I want to find and replace the file path with a different path. I have tried this in ArcMap but the file locks and isn't editable. I can't even think what Transformer I need to do a find and replace of text! I'm sorry - it's Friday and I'm very tired..... I'd be very grateful if anyone is able to help. Many thanks, Jane
Hello Team,I am try to use Clipper function in Python API for Raster.When i run my Workspace a crash is happen:Attached my Workspace.Thanks in Advance,
After upgrading FME Server versions and running workspaces which have an FMEServerJobSubmitter, the parent job runs but hangs after the child workspace enters the queue. The 'Wait for Job to Complete' is set to yes, shouldn't this start the child process running at the same time?
I have two shapefiles, A and B:A includes the object id (Field TLNUMERO) and data fields for a long list of TLNUMERO objects. Each TLNUMERO can be listed on many rows, as data about different angles around the object is found on different rows.B includes among others the same objects (their id also specified by field TLNUMERO) but otherwise other data / fields. Each TLNUMERO is listed only on one row. I want FME to insert the data from two fields (say xxx and yyy) from the row with a specific TLNUMERO in table B into the rows with the same TLNUMERO in table A.
Does anyone know if the HTTPCaller sends multiple requests simultaneously, or if it's only one-at-a-time?We're looking to make lots of calls to a web-API, and we don't want HTTPCaller to wait for a response to any given call before the next request is made. The web-API can handle multiple connections at once, and we would like HTTPCaller to do the same.Can it do this? I can't see anything in the docs allowing setting the number of simultaneous connections.
Hello everybody,Last year i was programing some scripts in python that use the FME module call fmeobjects. Now, I am using FME 2017 (last version) and I want to use these scripts but they show me some errors.Before I put the following lines in my code to import the libraries:fmePydPath = "C:\\apps\\FME\\fmeobjects\\python27" #Python FMEfmePath = "C:\\apps\\FME\\" #FMEif fmePydPath not in sys.path: sys.path.append(fmePydPath) #Try to add pathif fmePath not in sys.path: sys.path.append(fmePath) #Try to add pathSomeone knows the directory for the new site? because I read that the directory is now in "C:\Program Files\FME" so i tried to put this code:fmePydPath = "C:\\Program Files\\FME\\fmeobjects\\python27" #Python FMEfmePath = "C:\\Program Files\\FME\\" #FMEif fmePydPath not in sys.path: sys.path.append(fmePydPath) #Try to add pathif fmePath not in sys.path: sys.path.append(fmePath) #Try to add pathbut i get the next error:"ImportError: DLL load failed: %1 is not a valid win32 applica
Hi,I´m trying to extract data using an ArcGIS Server Feature service reader which is going okay. For some of the layers I´m getting the following error:Python Exception <UnicodeDecodeError>: 'ascii' codec can't decode byte 0xe5 in position 10: ordinal not in range(128)I´m guessing the problem relates to some characters in the tabel of the layer which can´t be read by the ArcGIS reader? Or could the problem relates to the transformer being programmed in Python 2 instead of Python 3 (which i´ve been told is handling encoding-problems better)?I only need the geometries (and the layer names), so is there a way for me just to be able to read the those?If that´s not possible is there a way for me to encode the tables so that I wont get the error-message?Thanks in advance :) Christian
Everything is in the title.
I have merged a spreadsheet with a points dataset. The spreadsheet contains multiple records which will merge with a single point. There can only be a single point and we need to store each set of records on the relevant feature. To do this the requirement has been specified that each records attributes will be stored with a prefix, e.g. 1_AttributeA, 1_AttributeB, 2_AttributeA, 2_AttributeB etc. The maximum number of records in each spreadsheet is unknown so I have used a ListElementCounter to identify this and then a ListIndexer inside a custom loop transformer which should prefix the attribute names for each set of features. FME Inspector shows the attribute names correctly as above, but when output to a file the attribute names are shown e.g. @Value(Prefix)AttributeA. AttributeRenamer and AttributeManager can't handle the output either, indicating in red that the attributes don't exist.Any ideas?Thanks!