Skip to main content
To homepage To homepage
Solved

GML field

  • February 11, 2019
  • 6 replies
  • 51 views
R
Starter

In one of my single text files is a field which is actually a GML field.

When i'm trying to deploy and execute this field as varchar(4000) it gives me the following error: 'string or binary data would be truncated'

So I wanted to override data type vut this seems to be impossible when your data source is a single text file.

So I tried something else, i made an Excel file of my csv file and read objects from data source as Excel, but then my GML field isn't even visible in the data selection tab.

is there another possible way to insert my GML file in TimeXtender without getting an error?

Best answer by Jacob.Ross.Andersen

This issue has been resolved and is not related to GML fields. 

Problem:

The file contained a non-standard field delimiter (semi-colon). CDATA's standard delimiters are: comma & TAB. 

Solution:

I created a "schema.ini" file and placed it in the same directory as the text file. It only contained the following script:

[FileName.csv]Format=Delimited(;)

You can read more in this article

 

 

View original
    Did this topic help you find an answer to your question?

    6 replies

    T
    Explorer
    • teld
    • Explorer
    • 5 replies
    • February 11, 2019

    Hi Rik,

    I would recommend that you try connecting to the file using the CDATA text file source, this generally has improved handling of many data types over 'single text file'. 

    The source is really easy to work with, in many cases you just need to set the URI.

    See this article for more details

    Tobias

    R
    Starter
    • r.miltenburg
    • Author
    • Starter
    • 4 replies
    • February 12, 2019

    Hi Tobias,

    Thanks for your reply.

    I've tried using the CDATA text file source. When I'm trying to read the data it instantly gives me the error: "String or binary data would be truncated."

    I also tried to override data type based on fieldname, but it doesn't seems te work....

    J
    Contributor

    Hi Rik

    The CDATA CSV provider assumes that first row is column headers. I typically get the "String or binary data would be truncated" error when my file doesn't include headers. I believe the limit is 128 characters for objects in SQL Server so that's easy to break.

    Solution is to set the "Include Column Headers" property to "False".

     

    Then it should work.

    If you get the during Execution then it's likely caused by size of data type. CDATA default size is NVARCHAR(2000). 

    You can override the default by setting the "DefaultColumnSize=VALUE" in the "Other" property. 

    Remember to Synchronize the data source before executing again. That should resolve that issue.

    Let me know if above two possible solutions doesn't fix it.

    R
    Starter
    • r.miltenburg
    • Author
    • Starter
    • 4 replies
    • February 12, 2019

    Hi Jacob,

     

    Thanks for your reply.

    I've tried all the steps you've noticed. See screenshots below for the result i got.

    Error 1 is what I get when I just have a normal dataset (with clumn headers in my csv file)

    Then I changed my datasource, deleted the column headers, changed the column header option. What I see is that i can't see the different columns. I just get 1 column named col0. when I try to deploy and execute it ofcourse gives me an error.

    Any extra ideas?

    J
    Contributor

    Hi Rik,

    Hm... and you remember to synchronize after you set the DefaultColumnSize property? 

    Would you be able to send me the file or a sample of the file? I'll be happy to take a quick look and see if I can find the fix.

    Please send to: jross@timextender.com

     

    J
    Contributor

    This issue has been resolved and is not related to GML fields. 

    Problem:

    The file contained a non-standard field delimiter (semi-colon). CDATA's standard delimiters are: comma & TAB. 

    Solution:

    I created a "schema.ini" file and placed it in the same directory as the text file. It only contained the following script:

    [FileName.csv]Format=Delimited(;)

    You can read more in this article

     

     

    Reply


    Most helpful members this week

    Terms and ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings