6 Replies Latest reply: May 29, 2008 9:11 AM by John Doyle RSS

Metamatrix Tex File

praveen matam Newbie

How to import text file(.txt) in metamatrix designer,we have import metamdoel from text file option but nothing is imported into my metamodel.

I want to import text file and add to VDB.what would be the content in text descriptor file and text file(columns and rows)?please help me.

  • 1. Re: Metamatrix Tex File
    Steve Jacobs Newbie

    Hi

    The Import Metadata from Text File option lets you read some metadata from a .csv file and build a Relational model. The first page of the import wizard shows the format that Designer reads. Here are a few lines:

    TABLE, TableName, "This is the description"
    COLUMN, Column1, VARCHAR, 255, "This is the description"
    COLUMN, Column2, NUMBER, 10, "This is the description"

    The first value defines the relational entity to be created, the second is the name. For COLUMNs, the next two values are datatype and length, and the final value is the description field. COLUMNs imported after TABLEs are created inside the TABLE.

    The wizard also shows the format for importing SCHEMA, CATALOG, and INDEX entities, all of which are optional.

    I hope this helps, if not, perhaps you could show me a sample of the text you are trying to import.

    Steve

  • 2. Re: Metamatrix Tex File
    praveen matam Newbie

    Hi Jacob ...Thanks Man.


    TABLE, TableName, "This is the description"
    COLUMN, Column1, VARCHAR, 255, "This is the description"
    COLUMN, Column2, VARCHAR, 255, "This is the Test"

    In above if i add more than 2 column in my text file then it shows Index3(size3...outofBound)error...hope u will help me.



    New issue is....If i add XMLHttpExtension model to my VDB it doesnt accept,so how to add XMLHttpExtension Model to VDB and execute..

    In advance Thanks man.

  • 3. Re: Metamatrix Tex File
    John Doyle Novice

    The XMLHTTPExtension model is only for use with the XML based connectors like the XML-Relational File, XML Relational HTTP, etc. It's not for use with the Text Connector. Are these problems with the same model? Perhaps you can descirbe your source.

    When do you get the OutOfBounds error? Are you importing the metadata, executing the text connector?

    ~john

  • 4. Re: Metamatrix Tex File
    Barry LaFond Expert

    Can you try one more time with the following in a .txt or .csv file?

    TABLE, TableName, "This is the description"
    COLUMN, Column1, VARCHAR, 255, "This is the description"
    COLUMN, Column2, VARCHAR, 255, "This is the Test"
    COLUMN, Column3, VARCHAR, 255, "This is the Test Column 3"
    COLUMN, Column4, VARCHAR, 255, "This is the Test Column 4"

    1) Are you importing into an existing Relational model? or creating a new model?

    2) What's your Designer Version & Build ID (via Help > About MetaMatrix Enterprise Designer)

    3) Linux or Windows ?

    Barry

  • 5. Re: Metamatrix Tex File
    praveen matam Newbie

    The XMLHTTPExtension model is only for use with the XML based connectors like the XML-Relational File, XML Relational HTTP, etc. It's not for use with the Text Connector. Are these problems with the same model? Perhaps you can descirbe your source.

    ANS:Here iam using Xml connectors,like XML-Relational File.
    Here iam creating a source model with XMLExtension and create few columns and when i try to add to VDB ....it says error at VDB and also points out error at "Folder named XMLConnectorExtension...or similar Folder which comes in Metamatrix designer by default".Help me how to add this source model of XMLExtension type to VDB.




    When do you get the OutOfBounds error? Are you importing the metadata, executing the text connector?

    Ans:When i add one more column in textfile then iam getting OutOfBounds error at index3 size 3.
    Yes iam using text connector.


    Thanks man

  • 6. Re: Metamatrix Tex File
    John Doyle Novice

    In order to create a model with the XMLHTTPExtensions, you want to use the XML Schema as Relational Model Importer. The importer will associate the correct model extension based upon the selections you make. If you don't have a schema for your XML, then you can build the model by hand, but it is difficult and you should read the documentation for the XML-Relational connector in depth.

    You might try to fix this error by right cliking on your model in the Model Explorer and selecting Models->Update Imports. The click the Synchronize All button on the VDB overview tab.