Data

Using a published parameter such as $(outputTableName) in a SQL writer to name a field.Taking the parameter value to name the identity field as in $(outputTableName)UKID resolves and creates the column no problem when using a standard SQL writer. So, setting the parameter value to "MyOutputTable" results in a field name of "MyOutputTableUKID".When attempting to do the same in a SQL FEATURE writer, the parameter will not resolve, and the column is created with the explicit string value '$(outputTableName)UKID'.Is this behaviour expected between the two varieties of writer?

Hello, I have las file in which some points after some manipulation produce separate cluster of points as shown on the image.How could I produce separate boundaries for each cluster?  

Hello, I need to write the resulting file to the same directory where my source file is, no matter where is the workspace. However, variables cannot be inserted into the writer's destination directory. Can anyone help?

We have a DWG that has a number of scale bars shown in paperspace. In the DWG the units are visibleBut when it is brought into FME the units are missing. My guess is that the units are dynamically generated in the DWG based on the viewport scale and as such are not really annotation but some attribute / tag associated with the line.Is there a way for FME to find the values so they can then be used to output to PDF.  Update 1:Here is a a sample DWG with the issue included. Update 2:What I have discovered is the scale bar is a 'block' and the text is a tag a

I have 2 dynamic writers in which data are coming from 2 readers (SQL Spatial and SQL non-spatial, respectively). Actually the readers are reading from the same database (A, for example) and the writers are writing out to the same database (B, for example). The reason why I have 2 readers is because there are spatial data and non-spatial tables in database A. I have a SQL script that can set ObjectID to Primary Key. It doesn't seem working properly when I put SQL script into the first writer (spatial). Therefore I had to put this SQL script into the second writer (non-spatial) to make it run properly. Any ideas? Thanks 

I have a CSV file where I need to read only the first line (or first column/line combo) of the file. Is there an easy way to do this with a reader? Or am I stuck reading the whole file? I've tried both the CSV reader and Text File reader. In both, I don't see anyway of isolating this first line of text/data. I'm forced to bring the entire table into the workspace. Thanks in advance!-Mark

I am trying to harmonise an average windspeed ShapeFile to INSPIRE GML.In the in EnergyResourcesCoverage application schema there is a RenewableAndWastePotentialCoverage feature type. However, I can't seem to add it as a writer. I only see the option of the RenewableAndWasteResource feature type. Does anybody else have experience with this? Or is there another way to create this INSPIRE GML?

How to create an index for a mongodb collection using a json templater ?Thank you

Is there a way to use FME to pull the stats for ArcGIS server and create a table or publish to a dashboard? I would like to pull these out and publish so management can see usage.

How could i convert oracle spatial data and non spatial to csv and read it again then use fme_feature_type in excel writer .  parameter tha t i did but i found after reader ,missing data ithat i gotand also after writer a few of my data has been written in temp.csv could someone explain me what should i do to convert from roacle to csv to excel writerThanks alot

I'm trying to read Feature Class from our Enterprise Geodatabase and because we have custom class extensions registered on all our our data.    I am not able to set the Reader to bypass the class extensions.  I get this warning in the log  "Unable to read from the table/feature class 'YK_SPATIAL.Buildings'. If 'YK_SPATIAL.Buildings' contains a class extension, make sure it is registered on this computer"  Thanks

I am trying to update 3 fields for all records in a SDE SQL GDB versioned Feature Class (where building id = bulding id). I have seen several posts and help files but am not having success with the reader + attribute manager + writer or the reader + SQL executer + writer combo. Can someone advise on how best to set this up? Many thanks,

Hello, I am a new FME user. im gonna store csv file in one folder daily. (ex. 20180914.csv)If it comes in daily, is there a way to read only today's csv file?Thanks in advanced.

Hi! I've tried looking for a solution for this but can't really get it to work.I have a folder with several PDF files that I just want to merge into one. Ideally I'm looking to specify that folder and then let FME do the job and spit out a Merged.pdf.Is there a simple way to do this? Tried a solution, but several attributes from the original PDF were lost in the translation. I want this to work with multipage input PDFs.I someone has a good solution to this and can give an example .fmw it would be appreciated! Thanks :)

I'm trying to read multiple spreadsheets and write one worksheet from each of them into a single output spreadsheet but am going round in circles...Input data: I have a parent directory with an unknown number( and names) of subfolders. Each subfolder has a spreadsheet, results.xls. Each spreadsheet has, say, 10 worksheets, ws1, ws2...ws10.Output: fme needs to search the parent folder to discover the subfolders. Then, for each subfolder, it needs to read the results.xls spreadsheet. A single spreadsheet needs to be written to disk containing worksheet ws5 from each discovered spreadsheet with each worksheet given the name of the subfolder that they came from.The FME excel reader seems to need to know the name of a spreadsheet in advance, so I used a Path reader to discover the subfolders but passing these to a featureReader doesn't seem to read in the spreadsheets properly.Any help would be appreciated.ThanksMacsmith

Hi all, This should be really simple, but I can't work out what I'm doing wrong in my workspace. Any help appreciated...I need to update a couple of attribute fields in a SDE feature class with values from an Excel table (attributes only, no geometry. Yet.). Using the Excel and 'ESRI Geodatabase (ArcSDE Geodb) readersI'm using the 'FeatureJoiner' transfomer to join the two readers together based on a unique identifier (ESRI Global ID field in the SDE feature class, which the person who created the Excel table also used to capture their new data), then put it through the 'Attribute Manager' transformer so I can map fields between the Attribute Manager and my writer (the columns in the Excel file and SDE feature class have slightly different names, but I know which ones correlate)I'm using the 'ESRI Geodatabase (ArcSDE Geodb) writer, settings:Feature operation: UpdateTable han

I am trying to setup a job in FME that reads a CSV file where the filename changes daily. The filename looks like this HHSVENDORS_02242020.txt. The HHSVENDORDS_ is always the same, but then it has the date appended in the format MMDDYYYY. Is there a way to dynamically create/read the input filename on a CSV reader? So when the job runs each evening, it will pull the correct file.

Hello. So I'm currently having an issue with the excel reader and I'm not sure I'm missing something. If I drag and drop or add the dataset to the workspace and configure it, it will read correctly. In this case, I want it to start reading the data from row 6 (1 to 5 are the header) and go from there. This works for the initial file, but if I change the source data to pick up a different file with the exact same format, the settings are somehow reset and it starts reading from row 1, resulting in no attributes or features being read. I've tried updating the reader feature types and changing the Microsoft Excel Parameters for it, and while it works when inspecting the data, when I run it, it goes back to missing. What I need is to be able to feed different datasets into this reader but all with the same format, so there's no need for it to be dynamic. However I can't understand why the parameters only work for the first file it reads, despite it being f

I have been provided with a set of dwgs which have autocad text in it and rotation values expressed in degrees e.g. '96d'. I need to read the value as '96', how do I do this? This is the first time I've seen the rotation units expressed this way. When I translate the dwgs the rotation values do not translate into text or numbers. I'm converting the CAD files into Esri fgdb feature classes and have AutoCAD 2019. 

Does anyone have any idea what this means and how to fix it? PDF2D writer: invalid map<K, T> key It has something to do with fonts when trying to read from a local font directory. If I clear the true type font folder, I don't get the error but the output PDF is not correct. 

Hello,Is it possible to automate the backup of ArcGIS Online feature services and associated relationship class(es) within AGOL with FME?I have a current workflow that backs AGOL data both within AGOL and locally as a file gdb; however, the relationship class is never replicated in either backup. I understand for file gdb's that "Relationship classes cannot be created through FME and must be set up through ArcGIS prior to running the translation." However, I was wondering about the AGOL backup data. Any way to retain that relationship class using FME when backing up (writing to) AGOL?

I have files with raw NMEA AIS messages that I need to decode to a delimited text format. Sample raw messages:\\c:1581638400,n:24896*14\\$ANZDA,000000.00,14,02,2020,00,00*79\\c:1581638400,n:24897*15\\!ANVDM,1,1,,A,15Nh=bP00hqWTC:E<3F<6Ign20Sd,0*1C\\c:1581638401,n:24898*1B\\!ANVDO,1,1,,Y,E1IDWe0:aPQRg`94QRagV0W24W3tkNcA:UujH00000P020,4*09\\c:1581638401,n:24899*1A\\!ANVDM,1,1,,B,15N8ct0P00IWliDE;UJpMOv42<1:,0*2C\\c:1581638401,n:24900*1B\\!ANVDM,1,1,,B,15N3Ib?P01IWiupE<espU?v40D0t,0*6B\\c:1581638401,n:24901*1A\\!ANVDM,1,1,,B,15O0JF?013qWbjPE;VwUKDP00<1C,0*3D\\c:1581638402,n:24902*1A\\!ANVDO,1,1,,A,E1IDWe0:aPQRg`94QRagV0W24W3tkNcA:UujP00000uP20,4*4C When I try to read the NMEA strings as AIS messages, the header isn't recognized by FME as a valid AIS message. The documentation lists the only acceptable message type headers as "!AIVDM" or "!AIVDO". I've been told the messages

Hello Team, Is arc SDE32 bit writer supports with FME Server 64 bit?, We have Arc SDE 10.1 with 32 bit and FME server 64bit with 32 and 64 bit engines installed in the same machine. Is it valid configuration to run a workspace?Thanks...

Hello,I know (hope) that there is probably an easy solution for this. I'm trying to read the XML file using the Feature Paths configuration type but it seems I can't get it right... I have simple xml file like this:<A>    <B>        <ATT1>10</ATT1>        <ATT2>20</ATT2>    </B>    <B>        <ATT1>30</ATT1>        <ATT2>40</ATT2>    </B></A> I want to read it like this:ATT1ATT2 10 20 30 40  Instead, I'm getting this:ATT1 ATT2 10 <missing> <missing> 20 30 <missing> <missing> 40 Can somebody please tell me what setting I have to apply in XML reader. Thanks!Mario