Authoring

Hello,I have this problem when trying to open a directory with a python parameter.The line in my script causing the error:f=open(os.path.join(FME_MacroValues['path_orders'],ftp.nlst()[0]),'w')IOError: No such file or directory: '$(FME_MF_DIR)orders\\\\1234567.WI02290100.vg'How do I tell FME to send the full path as a string and NOT $(FME_MF_DIR)?

Apologies for cross posting.   What i'm trying  to achieve is from this Excel table  ----------------------------------- | Name     |  Listed_Item    | ----------------------------------- | Mr A     |  [1234]                  | | Mr B     |  [6352], [2344]    | -----------------------------------  TO  ----------------------------------- | Name     |  Listed_Item | ----------------------------------- | Mr A     |   1234               | | Mr B     |   6352               | | Mr B     |   2344               | -----------------------------------   I using StringReplacer to remove the "[ ]". Beyond that, I not sure how to go abt it. If anyone can just point to me the transformers needed to produce this.  Thanks.

HiI have an FME process that uses as its inputs a GDB file and its associated XML schema file. I want to generate the XML from the GDB at runtime, and I have a python startup script to do this in ESRI - this works. My issue is with populating the parameter for the XML reader to set the location (for the generated file). I've read through some of the articles and previous questions, and this one seems to be what I'm looking for, although given I'm not python literate/new to it, I wasn't able to make the solution work for me - apologies for the ignorance. https://knowledge.safe.com/questions/4296/set-published-parameters-in-a-python-startup-scrip.htmlI think I need to add 'import fmeobjects' and 'return ResultsXML' added to my current script (below), but when I do so I get an error about return statement being outside a function. I don't know how to place it inside a function,.. help please. Assuming that works, how do I expose it within FME? I was thi

Hi,In workspace_01 I have a WorkspaceRunner transformer that runs workspace_02 that uses a SQLExecuter transformer. The SQLExecuter utilizes a parameter to receive the Named Connection required (e.g., gisdata_01@SDEDB or gisdata_02@SDEDB, etc..) that's working great.However, the issue happened within the workspace_01 with the WorkspaceRunner, unless I select from the available named connection to assign, the workspace_02 won't work successfully; i.e. assign by 'Attribute Value' or 'User Parameter' from the sub menu.A closer look into the log window revealed how the parameter was interpreted/passed to the workspcase_02 as:--SDE_NAMED_CONNECTION {\\<at>Value<openparen>_Named_Connection<closeparen>}While it should be:--SDE_NAMED_CONNECTION' `gisdata_02@<at>SDEDB' `#FME 2016.1Please help

Hi All,I might be asking a silly question but here it goes:I am trying to pass some records through a Feature Writer and off the back of that pass the unique id of the written records into a SQL stored procedure so I can track it has been written successfully. However if I use the Feature Writer then I lose the attributes in the summary and therefore can't use the unique id in my stored procedure :( Is there a way to expose this attribute so I can use the unique id. I have attached some screen shots. 

Hi, Could anyone please help me to transform the 3D object from Revit to ArcScene? I exported the 3D using FME exporter to get RVZ file, however, when I tried to visualize the result in FME data Inspector, the texture of the building wasn't appeared or transformed. I am not sure of the options I have to choose from the Export dialog to export the texture. Any Idea? Also, I transformed the RVZ file as it is (without texture) using FME Workbench Desktop to Shapefile and I have noticed that the multipatch layers for the building didn't come/merge in one attribute in ArcScene, and of course the texture was not appeared as well. Thank you,

Hi guys,I probably can say I'm at the point of being very confident with my skills in using python including libraries such as os, xlrd/xlwt, numpy, arcpy etc. I can create simple to complicated scripts, which can have simple line of codes, or several functions or several class objects and I can pretty much work seamlessly side by side with ArcGIS. In our office we have FME. I am finding it difficult to see any reason why I should use it over my pythonic process. I am thinking if only I encounter a very unique data format that python thru arcpy or another library cant read will I use FME to possibly do some translation. Other than that, any spatial operation I can fully use arcpy. But I don't want my boss to think I'm wasting our investment. I want to use it but cant find anything on the web that will convince me its a practical tool over things I can set up with python.

Folks, first post and rank newbie. I've been using Mapinfo for 25 years and MSSQL for 15 so the basic GIS and query stuff I know well. First time user of FME.I've had a live chat today and the SAFE guys were super helpful but it's clear my lack of understanding of the FME nomenclature has prevented a better outcome.Hopefully I can explain here what I'm after.I have some Mapinfo tables and want to create a GML. That's the easy part. The hard part is that I have a single Mapinfo ID column that could have two different formats. One integer, one alphanumeric. The column is type char.Depending on the value, the ID could be written to a GML tag, techID OR name.My understanding is I use an AttributeManager (I could be wrong) and that I can somehow create a condition that will produce different results.However all the examples I've looked at seem to evaluate the input value, modify the value and insert the modified value into the target field.There doesn't seem to h

I created a custom reader and writer with the wizzards in the reader and writer gallaries. I can install and use the reader, but I can not install and use the writer. Attached the reader, writer and an example file.

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