Data

Hello!I would like to have a color in a tab when I write an excel file. I don't find the solution on the excel writer parameters, or excelstyler. I would prefer not use template file.Thanks!

Hello,I have a URL To a Google Sheet that can be read by anyone who has the URL. I can access and view this in Google Chrome, without entering any Google Account Credentials. Is there any way to do the same in FME?When I try to authenticate my own google account in the Google sheet Reader I get an error:400. That's an error.Unverified state_wrapper. That's all we know.Any ideas would be appreciated!Regards,Helen

We have had to stop using Slack and instead use Google Chat for our workspace logging statistics. How do I go about posting to a Google Chat room directly from a workbench?

Hi All,Did anyone use FME Workbench converting TIF with TFW files into JPEG format with GPS data embedded?I am hoping to use Autodesk ReCap to process the raw stereo imagery, but I only have them in TIF format with TFW files.Autodesk ReCap PhotoPlease help, really appreciate!Thanks,Reno

Greetings, I have built LOD2 CityGML from Shapefile and Point cloud XYZ data. Also the point cloud is converted into a 3D Mesh file. Available mesh data format of the mesh are *.obj, *3ds, *collada, *glTf.Is it possible to texturize the extruded buildings using the Mesh? Appreciate your time and suggestion.Mesh: LOD2 CityGML

hello,I used the Generic reader to read shpfiles in workbentch and it runs wellbut when I published it to FMEServer it can't read,why?I checked the fmeserver logs as follows:--------------------------Generic Reader: Unable to guess a valid reader name from dataset 'C:\\Program Files (x86)\\FMEServer\\Server\\Upload\\Samples\\sampleWorkspace2.fmw\\02E4A34DB47D2A91DAB1CA7252C23994\\JSON6.dbf,C:\\Program Files (x86)\\FMEServer\\Server\\Upload\\Samples\\sampleWorkspace2.fmw\\02E4A34DB47D2A91DAB1CA7252C23994\\JSON6.prj,C:\\Program Files (x86)\\FMEServer\\Server\\Upload\\Samples\\sampleWorkspace2.fmw\\02E4A34DB47D2A91DAB1CA7252C23994\\JSON6.sbn,C:\\Program Files (x86)\\FMEServer\\Server\\Upload\\Samples\\sampleWorkspace2.fmw\\02E4A34DB47D2A91DAB1CA7252C23994\\JSON6.sbx,C:\\Program Files (x86)\\FMEServer\\Server\\Upload\\Samples\\sampleWorkspace2.fmw\\02E4A34DB47D2A91DAB1CA7252C23994\\JSON6.shp,C:\\Program Files (x86)\\FMEServer\\Server\\Upload\\Samples\\sampleWorkspace2.fmw\\02E4A34D

Hi,is there any option how to set the readers options, that I do not need to add a new reader when I want to change a dataset? I have always Ersi Format, but a different Dataset, and the same workbench.Till now I added always a new reader with a new name, but now I have to do a lot of things, so I would preffer to change only dataset instead to add a whole reader.Thanks.

I have a workspace where I fetch las-files and clip them with a bounding box. I connected an inspector after the clip-transformer and the Inspector starts up but then crashes. The las-files are indeed created, and I can open them with i.e ArcGis Pro. I have also tried to open several of the original las-files with the Data Inspector but no success. I am using FME( 2019.0.1.0 (20190506 - Build 19253 - WIN64). I have also the 32bit-version installed(2019.0.1.0 (20190506 - Build 19253 - WIN32)) and the data inspector fails in the same way. I have run out of ideas and I hope someone can point me in the right direction. Thanks in advance.

Hi!I have a .docx document framework (template) and I would like to insert specific "field" with QuickPart or anything like that on the document. Then, with FME, write data on this specifics locations.Is it possible? I think not because I read on the Microsoft Word Writer description "The writer can either create a new document or append to the end of an existing template document ".Maybe with programmation?The same question on excel. I would like to write on named cells (like A2 is named "VALUE1" for exemple) in the best case scenario. Or if is not possible, write on the same sheet but on differents locations specified by number row/column. But when I duplicate writer, I can't give the same sheet name. Maybe do a series of FeatureWriter, but I don't succeeded. Thank for your answer.

Hello! I have a large CSV of thousands of properties in Edmonton that are in Lat Long, I want to convert these into UTM and then into UTM zone 12 N and show them in Arc, and advice? never used this software before

I have a workbench that reads an Access database. The workbench works fine on desktop but fails on FME Server.The log records the following error - 'Type=5;Data Source=\\\\server1\\file1\\file2\\example.mdb;User ID=admin;Password=********'. Provider error `(-2147467259) Cannot open a database created with a previous version of your application.'A quick google seems to indicate that this error occurs when you try to open Access 97 with Access 2013 or later. Is this the issue? and is there a workaround? I hope there is as my client is unable to update their version of Access .

I am adding a client's data from a Google Sheet to some shapefiles. I currently read the files online with my gmail sign in info but this is not a workable solution to incorporate into an automated workflow. Because these are not my files, but generated by the client, I'm not sure how to use Refresh Token or OAuth2. I am very new at all of this and none of those things make sense to me. Any suggestions on how to read in these docs?

Hello !I have a workflow that ends with a writer in txt format and an Emailer that should send the same text. An exemple of the txt file from the writer is attached. This are names of administrative areas, grouped by an attribute (set in an AttributeCombiner parameters) so in this exemple there are two "blocks" of text.Is it possible to sort by alphabetical order the text inside each group ? I can't figure it out since the text is already combine with the AttributeCombiner...I also need to send an email with the same text message. I tried the Emailer transformer but it sends an email for each group/block of text, so 2 emails here. I would need just one. Moreover, the text formating is lost in the email received (i.e. each administrative area in a separate line)... I tried to connect the Emailer to a FeatureWriter (in txt format) instead of the AttributeCombiner but I can't find how to Edit Value in the FeatureWriter... and the Emailer doesn't seems to provide carr

HI,I'm converting geodatabase GDB files to PostGIS. The table conversion works well but some of the attributes are empty after the conversion (only 5 attributes over 200 in 7 differents tables).The five attributes don't have the same types.Does anyone knows where it could come from?

Hello, I have one folder with multiple sub folders that contains multiple shp. I need to read in all shp with specific name from all sub folders.Is this possible in FME? Structure is something like this:Folder-SUB Folder1-1.shp-2.shp-SUB Folder 2-1.shp-2.shp Example, I need to read all 1.shp together.

I'm a newer FME user. I have set up a workflow to read an xlsx file and write out as a csv, however it seems that it only likes reading the first file that i ran it with and does not work with any other file. I've set a user defined parameter to read files contained within a folder. I'm not sure what else i need to configure.

Good morning, I have uploaded a workbench to FME Cloud 2018 that has a GDB as a writer. I would like to download and view the GDB on my computer every time the FME Cloud job runs to see the changes. However, I do not think FME Cloud 2018 has the ability to download folders. I have tried the data download option, but that does not work for GDB. I was thinking of utilizing the HTTP caller. Has anyone used the HTTP caller to pull files from FME Cloud? Thanks!David

I've inherited a number of FME workbenches that I'm trying to decipher and where possible redesign to improve future decipherability. I'm noticing that for certain writers, if I add a new one that is of the same type as one already in the FMW, parameters are different. How can I tell what version (vintage) a certain writer is. Do I need to dig through release notes?

Hello,  I have an issue when reading a DWG file with dynamic blocks in it. I'm unable to get proper autocad_block_name for dynamic blocks.  Here's what I've done: 1) I've prepared a dynamic block definition in DWG file: it is possible to move attributes of the block away from its original base position. 2) I've created a sample DWG file, where the block definition is used. For some of the block inserts I've moved the attributes away from the original position.  When reading the DWG with FME (viewer/workbench) I cannot access the original block name. Istead of proper name "UR_BLOCK" FME reads "*U76" for the blocks whose attributes were moved.  Following autocad forums, I've learned that the dynamic blocks get anonymous name like "*U76", when their internals change. This means that technically they are different from blocks that stayed intact. Still when using autocad I'm able to see orignal block name when editing it's at

I've had to point a FME Server workspace at a different network share output directory and it is not failing with the following error message:Destination Feature Type Routing Correlator(RoutingFactory): Could not create output folder `<my_directory_path>' for use by ESRISHAPE writerThis FMW merely reads a number of ESRI ArcSDE feature classes and writes them out to SHP. So about as simple as it gets. What is the Routing Correlator/Routing Factory?The workbench runs fine when run from my local machine. I've tested that the service account used for running FME Server has WRITE permission on the target directory.Any suggestions other than rebuild it and try fresh? Thanks.

Hi All,I'm new to FME and have been pouring over videos to try and do my first projection. Any help is much appreciated. I have a raster geotiff I'm trying to project onto a City map. I'm hoping someone can point me in the right direction with a start to finish video or thread to help guide me through the process.Thanks,Adam

I have a mapinfo tab file called PARKS, that I have done thematic mapping (IndValue) of a text attribute called CATEGORY, to get point symbols colored by CATEGORY. CATEGORY has about 10 different values eg bench, lamp. So that my mapinfo users are working from our corporate database, not flat files, I wish to get PARKS into a new MSSQL Spatial (v2008) layer/table, complete with the color coding. I'm hoping that a mapinfo pro v15 user can connect to the MSSQL database and see colored points. I want to use FME to read from the tab file and write to MSSQL. I have already imported from tab to MSSQL successfully, and the mapinfo users can view and edit the layer/table in MSSQL - great. a) I wish to import it via FME2018.1 and store the points' colors, in a new table for the mapinfo pro v15 users. b) later, I wish store points and their symbol shapes in yet another new MSSQL layer/table, for the mapinfo pro v15 users.I hope someone can advise, please.

I got exported FBX file from INFRA WORKS 360 with actual coordinates system, but when i got convert that file into citygml by using fme that coordinates value change to LOCAL values, Even I did inspect of the reader file .fbx its on local coordinates value. My question is How to read the fbx file with actual coordinates system by suing fmeNote: I have supporting file for fbx is .pos file, In FME there is no option to add the .pos file while using the reader for FBX....,

Here is the log file from today along with a few notes from myself:Error when trying to connect FME 2018.1FME version 2018.1.0.0 Build 18520 Win64I have tried both AD account and Email account and getting same issue.I have had our SharePoint admin, make my account an Admin on the site.Trying to determine if this is FME or SharePoint to troubleshoot. Failed to obtain any schemas from reader 'SHAREPOINT' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information

Good morning!I need to export data from a WFS to a GML. The data is INSPIRE compliant, so I'm using the INSPIRE GML Writer.This is what I'm getting for the "nationalLevel" attribute:<au:nationalLevel xlink:href="http://inspire.ec.europa.eu/codelist/AdministrativeHierarchyLevel/6thOrder"/>And this is what the person using the GML wants:<au:nationalLevel xlink:href="http://inspire.ec.europa.eu/codelist/AdministrativeHierarchyLevel/6thOrder">6thOrder</au:nationalLevel>I thought that wasn't a big deal. I just added the following attribute to the writer:I use an AttributeManager transformer to set the "nationalLevel" value.But the GML hasn't changed at all.Does anyone know how I could achieve what the user wants? I don't know if I'm doing something wrong in my workspace or I'm missing some concept about the INSPIRE GML, but I'm stuck.The workspace I'm using is also attached.FME 2017.1 (32 bits)Thanks for any help provided!!