Data

I have read an article on the forum entitled Writing Microstation (DGN) Text Nodes with FME but after trying to understand all of the multiple items needed demonstrated in that article, I can't get text nodes to write properly into Microstation using FME. The DWG's are so nice in that they write multi-line text perfectly but Microstation just goes crazy. Is there a simpler way to write them? Whenever I do, they lose a lot of the linkages and no matter what I do I can't get the text to recognize carriage returns or new lines. Can somebody help me?

Hi,i am trying to read a segy file.the coordinate are ok but the attribute no.They show weird character (maybe encoding?)How can i configure that? I can't find any option on segy reader.Is this possible?Thanks.

I am converting Microstation DGN to AutoCAD DWG drawings. One thing I'm trying to translate exactly is the text insertion point and horizontal alignment. While the values come through exactly, visually, some of the text don't match. I have the following mapped:igds_original_justification -> autocad_justificationigds_insertion_x -> autocad_alignment_xigds_insertion_y -> autocad_alignment_yAnd conditional values set for the following:autocad_width_factorautocad_shape_nameOne thing I noticed is in Microstation, one can set both text height and text width. For DWG, the text width seems to assume the height (or size) value. See the attachment for the difference in the alignment:I'm hoping the alignment issue will be resolved if the width is the same as in DGN. Is it possible at all to set text width for DWG?Is there any other way I can get the alignment to match perfectly?Thank you.

First post ever!I am exporting from Revit (RVZ) to FME and finally importing the ESRI Shape file into ArcMap. The problem I am getting is that I cannot get the Revit instance parameter "Mark" to eventually show up in ArcMap.I've tried many options but have not succeeded. Please help!!!Thank you

Revit to 2D Floorplan

Hi,I'm using FME Server (2016.1) to read a text file using the TEXTLINE reader, but it appears to be caching the contents of the file - it's stuck on a version of the file from a week ago.Does anyone know how I can turn off the caching?Thanks!Roland.

Hi there,I'm having some trouble with performing conditional checks on some shape files I have. Basically, this is what my input looks like:CityDistrictAA1A2BC C1DEWhat I want do do is exclude Cities with blank districts IF they have entries where District is present, but Cities that only have one blank entry should be kept. In this case, I want to keep A1; A2; Bblank; C1; Dblank; and Eblank, whilst removing Ablank and Cblank.I tried toying with using a tester an making it a composite test, but I have no idea how to use the correct expression.Thanks in advance,Robbie

Hi,is it possible to install PostgreSQL to non-standard port (5432) during FME installation?

Hi,A dinosaur has raised its head from the tar pit! We've been given a set of Paradox data tables to import.As far as I remember, it was something that the long-time retired Borland Database Engine (BDE) could access, but how do you read such data in this day and age (if at all) ? Preferably directly with FME of course.I was happy to find a Paradox ODBC driver from Microsoft in my Windows, but it doesn't seem like it's capable of reading any of the provided table files (DB, and MB) :-(Do anyone here have any insights on this issue they want to share ?CheersLars I.

Hello FME community, Can someone help me with this error message on FME Server ?"Excel Reader: Failed to open dataset '<filepath>'. Error message was: 'damaged or not a zip file.'I run a workspace on FME Server which reads an Excel-file (.xlsx), but FME Server reports that the input Excel file is zipped or corrupt. Although, the Excel file exists on that particular location and is not corrupt or zipped. The file is published with the workspace so it's on the same directory on server.I don't get this error when I run the process on my local computer.Dries

Hi,I am trying to set the Writer Destination folder to dynamically or automatically set to the location of the Reader Source folder but I am not having much luck.I thought the easiest approach would be to use the FilenamePartExtractor and set the _dirpath as the attribute value or user parameter of the Destination folder but it doesn't work.Does anyone know the best way to set these parameters in FME?ThanksAndrew

Hi, I'm simply trying to write a summary list of the layers used in all dwgs in a folder to excel. The workbench will do this to inspector but not xls but I can't figure out what's going wrong, any hints?

Hello,I am trying to read or write the various text attributes such as "Title" or "Comments" listed in Microstation under File -> Properties. I have checked all format attributes in my DGN Reader as well as trying different reader parameters to get the attribute to show up in my inspector - no luck so far.Is there some way to read these as FME attributes?Thanks in Advance 

I am attempting to write lines and polygons to an SDE annotation feature class. If I create the annotation feature class without a custom field this works fine. But, if I add any custom field to the annotation feature class FME crashes when its starts writing. I am using FME Desktop 2016.1.1.0 build 16609 32-bit if that makes a difference.I did the same operation but writing to a File Geodatabase and get the same result.If the input data is annotation instead of lines or polygons writing to custom fields works fine.Any trick to get this to work? Is this a known issue?

Hello,Lets say I have given JSON structure being passed to FME workspace as a published parameter value:{ "users": [{"user":"John", "age":"33"} ],"otherParameters" : [ {"name":"parameter1", "value":"NULL"}, {"name":"parameter2", "value":"NULL"}]}It may contain different users and otherParametersI would like to add a transformer/tester at the begining of the workspace flow so that if in the json there is a user with the name John and age 33 then do some things and if tha age is different or for example users list is empty do others.What would be the best approach to do that? Thanks in advance.

Hi,I am producing GML files from FME, but the writer automatically includes xmlns:xlink="http://www.w3.org/1999/xlink" attribute on gml:FeatureCollection element.Can I remove this attribute from writer?Thanks,Ashish

Some UNC paths are very long (\\global\analysis\more\another\and\so\on\...), so it might be necessary to map the very long path to a drive letter for example. How can I do this and retain transportability across Windows platforms, and maybe other platforms?At the moment I use a SystemCaller, and simply assign a drive letter I pick to the UNC path, e.g., SUBST X: \\global\analysis\etc\.But, this is possibly going to be wrong at some stage, when X: is assigned by the admins without warning, well, maybe. In Windows there are various ways to get the next unused drive letter, one of which is PUSHD \\global\analysis\etc\but, then how do I get the drive letter that is assigned, using the system caller?Or, is there another way?

Is there a transformer for stripping HTML from text? I see the HTMLStripper, but it appears to replace HTML with XML. I want all HTML tags removed, including the <!DOCTYPE html>.Thanks

Hi,I have two xml files, the first one is made with these informations:The second one is made with these information : My problem follows:1 - I have to put the element <TIMSH> present in the second file in the first file at the same place (same <ASE id>. How can i proceed (for 1 <TIMSH>)2 - I can have many elements <TIMSH> present in the second file for one <ASE id> and i have to update them in the first file at the same place. How to proceed ? (many <TIMSH> to update)3 - The tree structure is : <ASE><ATT><TIMSH>Thanks for your help

Dear community, I have difficulties understanding the behavior of server handling (unc) paths. I'm quite new to server so this one might be simple but I don't get it.What I want to do is use a Directory Watch publication on a upload folder. Then let a workbench subscription react to a new upload. This works. I need the workbench directory file and pathnames reader to scan the upload folder, add the new files to a list and move the files to a queue folder.This is where the trouble comes in. The log tells me that the folder is not found. But the path is not the path I defined (\\\\fc01\\FMEdata\\KLIC\\upload) but local (D:\\Program Files\\FMEServer\\repositories\\KLIC\\01_scan\\upload).When I create the path dynamic (datapath = \\\\fc01\\FMEdata\\KLIC, dataset = @Value(datapath)\\upload) things works fine. So I got it working but I do not understand why... Can anyone give me a hint in the right direction?I know for sure server has read/write acces to this path as I have no proble

I have a transformation from Oracle Non Spatial to Salesforce that works fine until there are more than 200 records. At that point it errors. I can't tell from the error message what the issue is exactly. Is it some setting in Salesforce? Do I not have the parameters set correctly on my Reader/Writer? Any help would be appreciated. I do know that the records after 200 do not have data issues as I can write them only not when they are greater than feature 200.Salesforce Writer: Record 201 was not processed successfully: 'CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY:InternalServiceOrderTrigger: execution of AfterUpdate caused by: System.NullPointerException: Attempt to de-reference a null object Class.InternalServiceOrderTriggerHandler.emailRelatedServiceOrderSDC: line 668, column 1 Class.InternalServiceOrderTriggerHandler.triggerHandler: line 93, column 1 Trigger.InternalServiceOrderTrigger: line 4, column 1:--'

I'm still quite new and struggling on the first hurdle, any help anyone could provide would be much appreciated. I have a CAD (DWG) file with multiple Layers. The Layers contain settings such as Linetype, Lineweight, colour etc. I would like to get the Layer setting out to and Excel spreadsheet.I've opened a CAD file, exposed only the relevant Layer attributes but nothing seems to flow through to the transformers or even into an inspector.

Hello, is it possible to write date to Excel dynamically (as it happends with Shape-file)? Without writing the Name of the output at the begin? I wonder if there is any Workaround to do it? In my case i Need to write Information in different Excel-Files with the Name of variable (depends on class of the data).

Hi,this might be odd question but here it goes:Is it possible to explode hatch paterns to its geometries. For example, if some polygon is hatched with horizontal lines can I get those lines?Thank you.