Alpha DevCon 2018
Results 1 to 6 of 6

Thread: Error Import Data from Excel

  1. #1
    Member
    Real Name
    sreekanth
    Join Date
    Jul 2018
    Posts
    3

    Default Error Import Data from Excel

    Hello,

    My self sreekanth, I am new to alpha five. I am trying to import the data from excel through gridview, but i got the error i.e (Could not get Table Info for target table.Unexpected error MySQL type aW50KDExKQ== not expected in NativeTypeToDataTypeInfo). Can you please guide me how to import the data from excel to database. for your reference i have attached the screen shot.


    Thanks,
    Sreekanth


    alpha.png

  2. #2
    Member
    Real Name
    Jason Martin
    Join Date
    Jan 2014
    Location
    Australia
    Posts
    21

    Default Re: Error Import Data from Excel

    I was working with imports a couple of weeks ago and was getting errors when attempting to import .xlsx files (current Excel format) despite Alpha Anywhere documentation claiming support for this format. I don't recall if it was the same error message as you are getting.

    My solution was to use .xls files (Excel 97-2003 format) as I didn't have time to delve further into why the xlsx files were not working with the import. Try saving your Excel file as a .xls and see if the error goes away.

  3. #3
    Member
    Real Name
    sreekanth
    Join Date
    Jul 2018
    Posts
    3

    Default Re: Error Import Data from Excel

    Thanks for respond Matrix,

    I have changed the format and try to upload the .xls file, But I am getting the same error. Today I have created List control in UX component and connect my database, try to upload the .xls file through list control but I got the error (Upload status: 403 -- Server returned an error.). My main task was import the data in to the database, So that's why I am using grid builder and UX component. But I am not able to import the data. Can you please helpme out.

    Thanks,

  4. #4
    Member
    Real Name
    Jason Martin
    Join Date
    Jan 2014
    Location
    Australia
    Posts
    21

    Default Re: Error Import Data from Excel

    I would suggest the Grid control is the easiest method to import from xls.

    This 3 part Alpha Anywhere video explains the process.

    http://www.viddler.com/v/952f10e4
    http://www.viddler.com/v/1d8afc38
    http://www.viddler.com/v/86f30365

  5. #5
    Member
    Real Name
    sreekanth
    Join Date
    Jul 2018
    Posts
    3

    Default Re: Error Import Data from Excel

    Dear Matrix,

    I followed those videos only to import the data, but I am not able to import. I am trying different formats to import, but there is no use. I am struck here please give me suggestions to import the data in database.
    Last edited by mannem; 07-11-2018 at 05:52 AM.

  6. #6
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,100

    Default Re: Error Import Data from Excel

    Given that the error reported contains the description "Unexpected error MySQL type" it would seem logical to create a simple Excel file with only character and numeric data. Try to import that. If that succeeds try adding other data as is contained in the file that is causing the error until you trigger the error again. At that point you will know what is causing the error and either report it as a bug or work around the issue.
    There can be only one.

Similar Threads

  1. how to import data excel from excel file was exported from alpha?
    By amitloh in forum Mobile & Browser Applications
    Replies: 6
    Last Post: 04-12-2017, 03:11 PM
  2. how to import data excel from excel file was exported from alpha?
    By zatuzee in forum Mobile & Browser Applications
    Replies: 9
    Last Post: 07-21-2015, 06:00 AM
  3. Syntax Error In Import Data from Excel Action Javascript
    By MRall in forum Application Server Version 11 - Web/Browser Applications
    Replies: 2
    Last Post: 04-09-2013, 11:26 AM
  4. Import Error on IMPORT Excel Feature - Over 5000 lies
    By KYBiggs in forum Application Server Version 10 - Web/Browser Applications
    Replies: 1
    Last Post: 04-22-2011, 12:21 PM
  5. import data from excel from web
    By David Brown in forum Application Server Version 8
    Replies: 1
    Last Post: 12-09-2007, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •