Alpha Video Training
Results 1 to 2 of 2

Thread: Upload excel file to mysql database issue !

  1. #1
    Member
    Real Name
    Parveen
    Join Date
    Dec 2011
    Location
    India
    Posts
    50

    Default Upload excel file to mysql database issue !

    Hi All,

    I am using Alpha Five V12.I am trying to upload excel file to data base but I couldn't able to upload.I am using updateable Grid ,in that grid I kept action button to import the excel file.

    My database is MYSQL

    Table structure

    Capture.JPG

    Excel file structure

    exceldata.JPG
    Grid is :

    Grid.JPG

    I am getting below error message while uploading.

    Could not get Table Info for target table.Unexpected error MySQL type
    dmFyY2hhcig0NSk= not expected in NativeTypeToDataTypeInfo


    Please help me out.

    Thanks,

    Parveen.

  2. #2
    Member
    Real Name
    Michael Colvin
    Join Date
    Mar 2016
    Posts
    28

    Default Re: Upload excel file to mysql database issue !

    I don't have an answer, but the same problem. I have tried csv, xls, xlsx. Made sure my field names in SQL Server 2014 match.
    Error says can't get target table info yet grid displays properly and target table is not part of the action java script settings.
    It works when using a list control, but the number of records I am importing causes a delay when refreshing the list and the grid would handle things better.
    I am at the point that it must be a bug in the program.

Similar Threads

  1. Excel file(.xls) import issue to database !
    By Parveen in forum Mobile & Browser Applications
    Replies: 0
    Last Post: 05-03-2019, 02:33 AM
  2. Upload PDF file and Open PDF file issue
    By jennygong in forum Application Server Version 11 - Web/Browser Applications
    Replies: 0
    Last Post: 04-24-2014, 11:01 AM
  3. Upload and Import MS Excel File
    By boba in forum Application Server Version 9 - Web/Browser Applications
    Replies: 4
    Last Post: 05-09-2009, 11:50 AM
  4. how to upload file in webapplication with alpha5 and mysql?
    By aashalm in forum Application Server Version 8
    Replies: 2
    Last Post: 03-25-2008, 09:44 PM
  5. how to upload file in webapplication with alpha5 and mysql?
    By aashalm in forum Application Server Version 8
    Replies: 1
    Last Post: 02-06-2008, 01:20 AM

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
  •