Data

Folks,Pardon my nomenclature, I suspect that's part of my problem.I've been adding Mapinfo Readers as I've needed certain tables to be converted to CAD. That's left me with a list of 10 separate readers in the navigator.Previously when I did something similar for MI > GML I just added ALL THE TABLES in a single Reader as a group.Changing data sets is snap you just open the new set.With the individually added one-reader-per-table I need to go into each Reader and open the corresponding table.Is there a way to "group" these readers so I can open the referenced tab files as a set?

Hiya,Im having a problem using an Airtable API https://airtable.com/ to pull data into FME. I have followed a similar solution to a previous API link, yet Im getting this error below. Can anyone help with the below?JSONFragmenter(JSONQueryFactory): A JSON syntax error was found at line 5, column 9JSONFragmenter(JSONQueryFactory): Unexpected character: 'v'. One of the following characters was expected: '"', '}'The below feature caused the translation to be terminated

Hello,I have our own FME plugin which works fine on FME 2016 and 2017.On FME 2017 I see "Where Clause" and "Select statement" added to Parameters tab of Feature type dialog (dbl click on Reader). See the pict below:Question: do you know what changes / additions shall I make to my plugin .fmf file (or any other file(s)) to enable these "Where Clause" and "Select statement" settings for my custom plugin as well?I checked "oracle_spatial.fmf" but do not see what exactly code causes Oracle Spatial plugin to enable these two settings.Thanks!

I have an example of something I can do in Excel but looking to do in FME. Please refer to the PDF attachment....The first image shows a snapshot of a fictional table of data. Each employee has a unique "EmployeeNumber" and also a unique "CardNumber". The field called "Event" shows a record of every instance over a week, where an employee has either "swiped in" their card to enter an office building, or has "swiped out" to leave. So for example, Hannah has used her card 5 times in the week to either enter (swipe in) or leave (swipe out) the office.The second image shows a pivot table in Excel, which sums the number of times an employee has either swiped in or swiped out. I have then added the field called "Difference" as I simply wish to compare the number of times an employee has swiped in compared to when they have swiped out. And I am especially interested where the difference is 1 or more.My query is this ; can FME replica

Howdy y’all!XML newbie here and I have to build a workspace to parse a xml file. I’ve been messing around with the xml reader a bit this morning and cannot seem to get any results. One of the things I noticed immediately is that the field names seem to be only contained in the metadata. Can someone out there maybe show me how to parse these data and write them to something more favorable (excel, shapefile, geodatabase etc)?Here’s a link to the xml file I’m trying to translate - https://drive.google.com/open?id=0B52_Im1hHfSbOWM2cnA0NDAxdGcThanks in advance for any/all help.

Hi all, I am new to FME.Which transformers should I use to solve the following problem ?[1] The input Excel file has 3 worksheets, each with 4 columns (1 primary, 3 secondary).[2] The output Excel file should have 1 worksheet for each secondary column, and the data should be labelled by input worksheet name.[3] What if there are a few hundred secondary columns in each worksheet in the input Excel file ?In other words, "transform feature types to attributes".I was trying to use AttributeManager but did not know how to get hold of the name of the feature type.Thank you.* Input Excel file :* Expected Excel file :

Hello! I have ESRI feature classes stored in oracle Geodatabase. It uses ST_Geometry. I do not have oracle spatial installed on oracle database. Can I still use FME oracle spatial object writer to write to such ESRI Feature class?

I'm transferring data from an ESRI Geodatabase to ERSI AGOL cloud. One of the attributes in my feature is a string field that contains html text. When I run the workbench I get the following error message:ArcGIS Online Feature Service Writer: Encountered an unexpected error. The error code from the server was '400' and the message was: ''. Details: 'Field DESC4 has invalid html content.'An exampe of the string that is being transferred isHere is a video with more information on this project: <a href="https://www.youtube.com/watch?v=Kkce_ySK5Cs#t=17" target="_blank">Ripple.</a>If I remove the two '=' in the href portion of the html. The data is successfully loaded into AGOL. However without those the link does not work.Anyone have ideas as to how get this data into AGOL?

Hi,I am querying a DB table for some records and filtering few of them to create an XML string then sending this to an web service through HTTPCaller.After successfully sent this XML,i would like to update the table back with status filed = 'Y' for all the records i have fetched initially.The records i am fetching has got ID field which i would like to use for matching purpose but how could i store this ID within the workspace initially after fetching from DB and reuse for my update at the end of my process?Any help would be much appreciated.Thanks,reachmj

Hi ,I am trying to convert an access file to gml. I have an attribute in an access table that is of URL data type (with a value: www.test.com). I am mapping this attribute with the corresponding attribute of the writer that is of xml_buffer data type (the writer is defined based on an existing application schema). Then, in the produced GML, it appears like this: #www.test.com# Could you please let me know how I could avoid these # (hashtags)?Thanks you in advance, Valantis

Tried to copy feature classes from a Microsoft SQL database to a postgresql database using SDE Connection files. The workbenche does fine on FME Desktop 2017 but on the fme Server 2017.1 i get following error: "Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147155644'. The error message from ArcObjects is: {Cannot connect to database because the database client software failed to load. Be sure the database client software is installed and configured correctly.} "

Hello, I'm working with some IFC files for a project. As part of the project I need to change the GeoLocation of some of these files to better match the final model that I'm making. I'm doing the final model in Infraworks and the IFC are exports from Revit.

Hi,I'm trying to export my data to excel. My workbench was working fine and suddenly I can't even run it.I'm having the following error and I don't know what could be the issue.I restart my computer and I close all the excel files on my computer but the issue persists.XLSX Writer: Saving changes to dataset 'folder_name'XLSX Writer: Failed to save changes to the spreadsheet 'folder_name'. Check that you have write permission to the file, it has no password protection and is not opened by another application. Error message is 'Permission denied.'A fatal error has occurred. Check the logfile above for details... Last line repeated 2 times ...Note that folder_name is the localisation path where I want to export the data.Thanks

Has something changed within the JP2 reader between FME2014 SP4, and FME2017? I'm using a simple workbench to convert from JP2 to Geotiff, which worked fine in 2014. I'm getting a message in 2017 that I do not get in 2014, "JPEG2000 reader: Mercator projection should not define both StdParallel1 and ScaleatNatOrigin. Using StdParallel1 and ignoring ScaleatNatOrigin." The resulting geotiff does not seem to retain the coordinate system.

we have configured our Active Directory with FME server and some active directory user already added to access and run FME workspace.But when I try to add new user then its asking to set password. we no need to set password. User can use there AD default password.

I am converting Sketchup file to City Gml v2.0 , I want to give seperarate layer names for Building, Lift , door,park and lift ? Can anyone suggest me a the way to follow?

Hi all,I seem not able to rotate text objects written to a png file.They are rotated, rotationfield has correct value when arriving at the writer.Even using gif_text_rotation or fme_rotation...nothing seems to make the png have the text rotated .Anyone know this issue and maybe what I'm missing here? (please answer in relation to png writer if possible...;))

Hi all,I need to create a .mdb access file from excel file which have informations about field name, width and type datal. Could you tell me how to make it from FME workbench?This is my excel data (input). I want to make 4 columns in .mdb with type, width data the same here.

Hello,In the Text_File writer I cannot select an attribute I've just created How can I solve that?Best,Harmen

Regarding this thread: https://knowledge.safe.com/questions/43262/png-text-rotation.htmlCould somebody from Safe reach out to Gio? I don't know if he actually filed a support case regarding this, but it seems the only answer he's willing to accept is that it doesn't work.

I am using an AutoDesk Revit Reader to transfer an RVZ file to a Feature Class in an ESRI GEoDatabase (ArcObjects). When using the 2DForcer to transform the 3D RVZ data to 2D data the translation fails and there error I get is 'Cannot write a non-area feature to an area feature class.' I am using a Geometry Filter which has the solid and area options checked, followed by a GeometryValidator with all options checked. and the output feature class type is set to polygon.

. but not getting desired results

To get an xml file automatically we are currently storing all attribute table of sql server DB into a enterprise GDB in sql server, which is creating a trouble that everytime it is taking the primary key field as OBJECTID and changing the name of the field. So we want now to have the attribute table as it is in a non-spatial database, and want to read it's table name, field names and datatype into an xml file. But I cannot read the field names and data type as a list thus I can use it inside our own schema. Can anyone please guide me.?