Data

This has me stumped. I thought I had resolved this last week (I posted this in another question and thought it was resolved). The solution I thought would work was me clicking the buttons in Excel regarding Read Formulas and Read Hyperlinks. That doesn't work. I can't post the actual Excel file itself because it has information not allowed outside the company. But I've reviewed the field over and over and over again ... and there is nothing wrong with the field. For example, there are no hyperlinks or formulas in the field. The GIS ID is actually a text field because some GIS ID's have a letter in them. Like you might have 08786651 or you could have 08786677a01, 08786677a02, 08786677a03 for example. I'm attaching an image of the Reader parameters this time so you can see that the Reader does show column CF (GIS ID) in the Preview pane. But you can clearly see that a blank field is present for CF directly under CE (Lease Grid#) in the Attributes pane. Like it's t

Hello, I am converting shape files to variuos formats. Input shape file has been created by non-ESRI tool. When the shape file contains NULL attribute values for all features; that particular attribute is not in target format.  e.g. Shape file with attributes ID, NAME, URL, REMARKS with URL and REMARKS for all features is NULL. In this case output format there are only 2 attributes ID and NAME rest two are missing from output file.  I also observed that in "User Attributes" tab in "Feature Type Properties" dialog of a shape reader, I am not able to see these attributes i.e. in ablove case REMARKS and URL.  Is this behavior as expected? How can force FME to write out all attributes even if it's NULL.  Cheers, John

Hi there,  I'm trying to create a pdf file to visually represent some basic shape files I have. Using the Adobe geospatial PDF writer, everything seems to be fine. Until you zoom in a bit, then you see this:    The red lines are some simple boudary polygons, that aren't normally as spikey and those green "pie charts?" are roads, standard roads. These exact layers display perfectly fine in ArcMap, so I'm very confused as to where these strange geometrical anomalies come from. At this point I'm not even using any transformers, so it's a basic reader to writer translation. Any tips on what I might need to fix this, or even a suggestion on an alternative output format that's good for display purposes?  Kind Regards,

Hi, I am working on Win7 Machine with 8Gb RAM. While creating an XML from a shapefile, comments are being generated automatically which I want to remove. Tried XMLFormatter and StringReplacer, but didn't get the desired output. Can someone help me with that (: (The rows inside the box are automaticallygenerated and should be removed) 

There's no rhyme or reason to this issue. No matter where I move a certain field in my Excel file (I've moved the row to the beginning, middle, and end) the Excel Reader simply ignores it. When you click Parameters on the Add Reader dialog ... You can see the field listed in the Preview pane under Parameters. But it is not present in the Attributes pane under Parameters. When I say OK on the Parameters and then OK on the Reader it adds the Reader to my FME job but the field is missing. Even when I expose the attribute it shows up as null in an Inpsector.  Has anyone encountered this? Any ideas on how to get it to recognize the field or why it doesn't recognize it?  FYI: I've even put in the range of the data in the Parameters and it still doesn't pick up the field. For example:  Field Names Row: 3 Cell Range (e.g. B2:G9): A4:CF16430 

Hi,   I have a list of filenames that are located within a specific directory.  The list of filenames is generated within the FME workbench.  What is the best way to get the Reader to read in only the files within the larger directory?  Note: the files that I want to read in are within a number of sub-directories, which I don't know what they are. I only know the root directory.  Thanks,

Hello, I would like to do a jp2000 file with a tif. My conditions : 1- the tif is black on white so i want my jp2 black on white 2- the siz of the jp2 must be less than the tif  Using rasterpalletremover my jp2 is 500Ko big but i need to specify nodata=0 in Qgis to see it in black on white instead of white on black.. See joined files (fil and jp2 500 Ko). I test many ways like rasterpaletteresolver and the viewing is ok but the files is three times bigger!!!(2.9Mo).  If anyone can help me  thanks,  dowload my file here : https://drive.google.com/file/d/0B90n7rx5ph0ZMXFUUUtvbVplUXM/view?usp=sharing  PS : si vous parlez français dites le moi!!

Hi,  when I reproject a tiff file it sets as black those areas that incure due to rotation of original file. Is there a way to set them in other color. Of course, using raster cell replacer you can. But that will change all black colors in photo which I'd like to preserve since they were there in original file.  

I know you can incorporate FTP in a Esri Shape reader to pull a zipped shapefile but was wondering if you could do this for a zipped esri geodatabase?

Hi,  I have a need to change some text so it is in the form of a polygon. I was looking at some functions with labellers and wondered if they can be output in a shapefile for example and be in polygonal form.   I have seen a function MapTextLabeller which seems to output polygonal text, but its a paid plugin. Are there alternative methods?  Thanks.

I have a "master" folder which contains 50 sub folders, all of the 50 subfolders contain a shapefile with the same name (this is just the way trimble exports their data).  I want to be able to write all 50 shapefiles into one SQL feature class by somehow reading the master folder?  is this possible  

Hi. I want to create an attribute whose value is the sum of the three following values an existing attribute (Code in the picture). How do I write this formula in FME, specifying the value cells? I would rather not do this in excel as I would have to transform to xlsx and back.   

Hi,   I have a file geodatabase that i need to update weekly with a CAD file. How i can set up the update on the file geodatabase? I am using Esri Geodatabase (File Geodb ArcObjects)  Thank you,   David

I would like to know how to get the JOB ID included in a notification I get from FME Server. With lots of job's running each  night and I need the job id when I get notified of a failed run. Can someone point me in the right direction?

Hello,  I am trying to view Oracle Spatial data in FME Data Inspector. I need to view spatial data from a synonym but when try to retrieve table list I am getting only tables not the synonyms.  Is this expected behaviour of FME? Is there any way around to view data from synonym?  Cheers, John 

Hello, While converting shapefile to any format I am getting an error "IFMELine was given an index beyond its current range.". So I guess this must be to do with shapefile but I can open shape file in Data inspector. Could somebody please point out what is causing this error?  Any resolution?  Cheers, John   Cheers, John 

How to create DEM from ERDAS IMAGINE(*.img) raster?

Hi. I have a FME Server 2014 workflow that is created exactly the same way as the following FMEpedia article: FME Server Workflow Management (http://fmepedia.safe.com/articles/How_To/FME-Server-Workflow-Management). A controller script is starting multiple other scripts via serverjobsumitter transformer (the scripts were created in FME Desktop 2014). Unfortunately the workflow is not using only one engine as stated in the article but two. So now my controller script is waiting for the submitted jobs to be finished and in the meantime blocking the second engine. Can someone give me a hint where I have to change this behavour? Thank you very much!

In shape to DGN conversion,how to get all attributes in Level name seperated by underscore(_)

Hello, I'm converting ArcGIS geodatabase annotations to text within a block using a dwg model. Everything works ok except that AutoCAD (several versions 2010-2015) does not apply the text justification. The text property is recognized by AutoCAD but for some reason, it is not graphically applied as you can see in the image below.   When I click that Justification dropdown and reselect the same choice (middle-center), then the text aligns in the center of the triangle.  What needs to be done in FME for the justification to be taken into account by ACAD ? I'm using script. Here is the reader/writer snippet: MULTI_READER $(_SDE3UserName).MOB_SL_GROUPEFEUXA              \\     geodb_text_string            %text_value                                                  \\     ANGLE                        %angle_value                                                  \\     ANNOTATIONCLASSID            %ref_name                                          DWG MOB_SL_GroupeFeux              

Hi. I would like to format the an attribute of the a tiler transformer (the column), to be listed in letters  instead of in numbers (e.g. A B C instead of 1 2 3), is this possible? 

Hello!  I 've got a workspace that runs properly if I use FME Desktop, but  it doesn't work if I use it at FME Server. I get following error message:  The clause 'REFERENCE_INFO ATTRIBUTES REFERENCE_TABLE ValueZUSO_ID ValueZUSO_ID'  within  'FACTORY_DEF * ReferenceFactory FACTORY_NAME FeatureMerger INPUT REFERENCER FEATURE_TYPE AttributeCreator_OUTPUT INPUT REFERENCEE FEATURE_TYPE TIM.TIM_REO REFERENCE_INFO ATTRIBUTES REFERENCE_TABLE ValueZUSO_ID ValueZUSO_ID MERGE_ATTRIBUTES Yes MANAGE_FME_TYPE Yes MODE COMPLETE PROCESS_DUPLICATE_REFERENCEES No OUTPUT COMPLETE FEATURE_TYPE FeatureMerger_MERGED'  is incorrect. Only one value can follow REFERENCE_INFO  I'll supsect that the featuremerger doesn't work porperly. The problem appeared using different Service Packs with Version 13, but it also remains if both the workspace and FME Server have the same Service Pack (Version 13, SP1 - Build 13450).  Thank you for your answers  Isabell

AutoCAD Reader: Error opening file during version check,  I have a simple workbench that converts CAD to lines. I got the error below when the workbench is run.  AutoCAD Reader: Error opening file '\\\\213.6.3.171\\Temp\\FMEInput\\Ayman_02.dwg' during version check A fatal error has occurred. Check the logfile above for details     What might be the issue here?   Thank you  Best  Jamal

Have anyone come up with a solution to this problem:  http://fmepedia.safe.com/AnswersQuestionDetail?id=906a0000000cg4TAAQ  Except using "Daves method"?  It would be very handy to have an option on the FeatureHolder like this: - Wait for Writers (YES/NO).  This would be very handy on FMEServer to be able to WRITE some features, then do some more Custom Transformers and then WRITE some other features to another WRITER. The alternative way is to create separate workspaces for each and use either a WorkspaceRunner or FMEServerWorkspaceRunner, however this creates the need for saving and loading features inbetween the Workspaces.  Another option would be for the FMEServerWorkspaceRunner to also work on FMEServer when selecting "Wait for Result" to not worry about the line:  "When you run a workspace on FME Server that contains this transformer, and the workspace sends a job to the same FME Server that is running the original workspace: depending on the availability

Dear all , We are using GeometryPropertySetter to set the skatchup file to be in different layers but it doesn't works , we also tried fanout but we got different skatchup file instead of one file with different layers . we exposed the autocad layer name and added to GeometryPropertySetter but again all in vain , any help would be appreicated . Thanks in advnace