Authoring

I was looking to do a data transformation task by making use of the following high level workflow: Run a data audit to compile a database table of filepaths of MapInfo tab filesCompile data about the file discovered, included a field as to whether to transform this particular dataset (Field “TransformRequired” with Yes or No values).After our data audit is complete, use the Database table as an input list for the transformation, making use of the FeatureReader transformerUse a MapInfo Tab writer with a dynamic schema, using the “Schema from Schema feature” option as the Schema source. The problem I have is that the input table list will include MapInfo tables which have the same file name, but which are in different file system folders. The paths I am trying to read in include: \\Input\\GDA2020\\MapInfoV16\\PARCEL_VIEW.tab\\Input\\GDA2020\\MapInfoV17\\PARCEL_VIEW.tab\\Input\\GDA94\\PARCEL_VIEW_GDA94.TAB\\Input\\GDA94\\PLAN_ZONE.tab When reading the list into the FeatureReader transform

Is it possible in a startup script to access incoming shapefiles and set a private parameter based on a shapefiles attribute?For example, I am a reading shapefiles and at the same time I want to query a rather large database based off a unique id that the shapefiles contain. I'm currently using the SQLCreator because it seems to be the fastest database reader.I was thinking within the startup script, I could set a private or published parameter to a shapefile attribute, then in the SQLCreator, I could have a sql statement, that has db.attname = $(newParameter). Any assistance would be greatly appreciated. Thank you!

We have a startup python script that will run a kinit process using a keytab file on the server. Unfortunately it appears that even though the kinit was successful and the Kerberos ticket was created correctly, FME is not able to see the newly created ticket in the Kerberos ticket cache. Once the current FME process terminates any new FME processes after wards can see the new ticket. It seems to me the Kerberos ticket cache is read into memory with the initial FME.exe starts and updates are not known about by the FME process. Any idea how make the ticket cache update during the current FME process?  Any ideas or work arounds would be helpful! Current work around idea is to have a separate FME process run separately to generate the Kerberos tickets.  Thanks in advance!!

Fme server app return a failure message if I use drag and drop way to put my input;Hi All,Despite the fact when I running an app and putting the input data for example like that "D:\\Roads_Input.gdb" which way is more diffecult to end user, the app will run successfully with no issues, but When I use the easier way which is drag and drop the gdb file, The app return a failure message!What might be the issue here? Best,Lubna

FME server fails to display the fme app result url directly after running the app successfully,Hi All,Why the FME server fails to display the fme app result url directly after running the app successfully, I think It’s difficult to the end user to go back to resources with user name and password to download the result of the used app! What do you think?Best,Lubna 

I have data pulled from a DB and need to create a multi-page Word or PDF document. What I've got so far is arranging my attributes in the order I want them and sending them through the AttributeExploder so each Attribute can be in a list or table for vertical formatting.First problem: Once the Features go through the AttributeExploder, they are no longer sorted in the sequence I need them.Second problem: I need each Feature/Attribute set to be on a separate page, so separated tables. I've tried using the MSWordStyler, which puts everything in 1 big table, but I need to insert a page break in between each Feature, so a separate table for each. Any guidance or samples are appreciated.

Hi,I have meter data that is currently processed by FME into 15 minutes values, 96 values being in one day.I have been asked to identify if there are 3 or more identical values in the 02:00 - 04:00 that would be the same, as this may prove that the meter has flatlined and is no longer recording the flow.I've not done this before - can anyone please suggest any FME workflow which might identify identical consecutive values and add a value to an attribute? I attach some test data whilst I try and figure it out myself. CheersN

How to customize the name of input and output parameter of fme apps;Dear All,How I can change the name of parameters of app to be understandable to the end user Best,Lubna

I’m trying to emulate a CAD command for offset.  Essentially I want a parallel offset of a line with no curve stroking on the outside angle.  Similar to bufferer but with the ability to make the stroking density a value of 0.  Any easy way to do that?

I'm trying to get imdb movie reviews , for example the movie "The Matrix" has 4K reviews and I need to retrieve all of it.

Hello all,I am trying to validate DWG files and that they have been drawn using metric units. I have exposed the 'Read Drawing System Variables' and that gives me access to autocad_lunits but I am trying to figure out what the output means.In the image below the autocad_lunits comes back with a value of 2 on the 0 layer but not sure what 2 really means. Does anyone know what the range of options that AutoCAD produce or if there is another way to find what units are being used in the drawing?   Note: I know this particular drawing is in metric units but not sure what other values could be expected.

I'm having a hard time even coming up with a title for this problem that I'm seeking help on. But I'll summarize and provide context as much as I can.We are trying to parse publicly available medical data. This data is provided as a concatentation of multipe substrings (ex: 100 or more fields) in one long string. An accompanying document describes the start and end position of each substring that defines the value of a field. I was able to mock up a quick workflow to dynamically supply a single row Excel or CSV file with this data (see excerpt below that I used as a proof of concept) and then feed in the long string text data file:The workspace reads the above and uses an AttributeExploder to "transpose" this table. I then clean out unwanted features and do some calculations to create an appropriate StartIndex and EndIndex (which I use later to extract the substrings). After reading each line in the text file, I then use a FeatureMerger to stitch this together wit

Hello,I’m pretty new in using FME and I would like to add raw OSM highway data from a .osm file of iceland to my Geodatabase. So I used the „OpenStreetMap (OSM) XML“ Reader and chose highway as map feature. First it seemed that everything worked well, but then i looked in the attribute table of my GIS and recognized that some attributes are missing, f.e. bridge, tunnel, (see figure 1/2 to see the all fields of the exported OSM file) and some attribute values are emtpy, f.e. layer. (see figure 3).But the data are complete and all these missing/empty attributes exist in the attribute table of the same OSM data file that i converted as shapefile with QGIS. (see figure 4)So how can i get all attributes of OSM Data using FME? I tried some parameter settings in the OSM/XML Reader but nothing worked.Thank you for your help!

Hi.First let me say, that I absolutely love the incremental run abilities added to 2020. It makes incremental building and debugging workspace a breaze.However, production runs are a different matter. Here one always runs the full workspace and as fast as possible. I.e. no caching.I often utilize a master-slave workspace setup, where one workspace calls other workspaces as needed.Now, the caching is a Workbench setting, and cannot be set for a workspace, but does it only apply to the master workspace being run directly, or does it also apply to the initiated workspace that are called by the master workspace ?Cheers.

Hi list.This question has been touched on multiple times, but in different setups, so I'll ask it anyway.I have 16 datasets, that need to run thru the same set of 4 regular transformers. Each dataset has a varying set of attributes.I would like to create a single embedded custom transformer with these 4 regular transformers, and reuse the embedded transformer instead of having to add 4x16 (=64) similar transformers.The attributes are to be accessed in the contained regular transformers, creating a need to expose the attributes.Is this even doable in any sensible way ?Cheers

Hi,I have a set of 24 attributes each with a calculation which results in a numeric value. Is there a way to set a conditional statement across all of these in a similar way to how the NullAttributeMapper works?I want to apply across all 24 attributes "If value <0, then map to 0" but i want to try and avoid 24 individual conditional statements within an AttributeManager.Thanks,Jack

Hi, I have a IIS web server on the same machine that FME Desktop is installed. On the web server a php script calls a FME workbench using "shell_exec(same_as_batch_text)", and the workbench executes. The problem is that FME can't connect to the database when the command is being sent through IIS and php. I have followed the information on https://knowledge.safe.com/questions/61651/fme-failing-to-run-from-a-batch-file.html without getting any further. This means: - My database is made public. - The default paths are moved to a location with common access.Any suggestions? The log:2020-03-25 16:21:58| 0.7| 0.1|ERROR |Internal Error: Unable to access connection database

I have a folder containing 77 Esri Layer Files. I would like to consume each of these 77 layer files and then write them into SDE. I have a dynamic reader/writer workflow setup. Dynamic Reader is set to read the folder with the features in question, then a Feature Reader, then the Dynamic Writer into SDE. Currently the workbench is attempting to merge features together. I want the workbench to read one feature, dynamically write the feature/schema into SDE, then write the next one, etc. I have tried the WorkspaceRunner without success. Maybe this is an option and I have it misconfigured?

Greetings, I’m needing to loop through a list of zones and run a series of calculations and spatial intersections that require a rather lengthy model. The trick is I need the model to still grab the next value in the list and run all the calculations accordingly. The only way I know to do this is to use a workspacerunner and call a separate workspace containing the list each time I need the next value. This seems highly inefficient so is there not a better way to setup a single workspace and have it loop through the list at the beginning, run all calculations, and proceed to next value in the list?

We recently installed FME 2020 we get the following error message when running workspaces with a Python Startup ScriptPython Exception <ImportError>: No module named fmeobjectsFailed to import `fmesite' System setup:Microsoft Windows Server 2016 StandardFME Desktop 2020.0 64-bitArcGIS Desktop 10.6.1ArcGIS Desktop Background Geoprocessing 10.6.1 (64-bit) + ArcGIS Desktop Background Geoprocessing patch for Oracle 19COracle Client 19cOracle instant client 19.5 64-bitWorkspace settings:Preferred Python Interpreter: Esri ArcGIS Python 2.7Python Compatibility: Esri ArcGIS Python 2.7 The problem doesn't occur in our previous version (FME 2019.2.2) with the other settings the same, so it seems it only occurs with FME 2020.Any idea how to fix this? 

Somewhat simple question that I have not been able to find much info about: is there any possible way to set the max number of features per feature type in a FeatureReader? Or, is there any sort of workaround to have the same effect?

Hello Everyone!I have an issue with connection to OneDrive account via OneDriveConnector (Graph). During configuration of parameters this transformer I set new connection to OneDrive.  But when I tried to open this account and choose file or folder, which are in my account I get an error:  And FME FME cannot see any contents that are in this account: And in log I have:Python Exception <ModuleNotFoundError>: No module named 'webserviceconnector.webserviceconnector'; 'webserviceconnector' is not a packageThe python function `fmemodules.lastError' was not found. Check your python path & module importsI tried:to choose other action (Upload, Download, List) to connect with other OneDrive Accountto use other version of FMEAnd every time I get the same error. Did anyone has a similar problem and could help me? Thanks in advance!

Hello Team, I have installed new FME Server 2019.2 and published my existing workbench.When I ran this workbench from server I am getting following error, Could somebody help me to get out of this error, I have a start end shutdown python scripts embedded with the workspace. 2020-03-23 08:42:19| 21.5| 2.8|ERROR |Python Exception <ImportError>: No module named win32com.client 2020-03-23 08:42:19| 21.5| 0.0|ERROR |Error executing string `import arcpy, fmeobjectsclass mmLicenseStatus:  mmLicenseAlreadyInitialized =0x32 # from enum mmLicenseStatus  mmLicenseAvailable =0xa # from enum mmLicenseStatus Present I am using deprecated version of python27, If I want map with latest version of the FME then what could be the process for it. Thanks in advance.

I am new to FME ...simple question. I have a Feature Writer, which I would like to name with the value from the attribute (@Value(myattribute)_example.dwg) that I can see is there from the logger, but the writer fails to find the value of the attribute, it only creates an empty file with "_example.dwg" with the geo features and an empty file with foo_example.dwg ... I am able to use the reader with file name from @Value(attrr) (I am using the latest version FME desktop trial 2019.2.3.1) I would appreciate any tips ...thanks

Not sure if this is a bug or I'm just doing it wrong.I've got a FeatureWriter that does an Update on a SQLite Table, and then follows this by doing an Insert on the same SQLite Table.It doesn't work. The Update operation runs, but the Insert doesn't. If I split the FeatureWriter into 2 separate FeatureWriters, one for Update and one for Insert, then it works.Is this just a limitation, a bug, or I've set this up wrong?