Alpha Video Training
Results 1 to 2 of 2

Thread: Import to List from Excel

  1. #1
    "Certified" Alphaholic mikeallenbrown's Avatar
    Real Name
    Mike Brown
    Join Date
    Nov 2009
    Location
    United States
    Posts
    1,819

    Default Import to List from Excel

    Keep getting 500 error. Using 4491-4932.

    Am I missing something?? Attached is the xbasic error log. Component also attached (forum wouldn't let me upload a sample EXCEL file so I posted a screenshot of it).

    Ashampoo_Snap_Friday, September 1, 2017_11h53m43s_002_.png

    Test case...

    A5XbasicErrorStackLog.txt
    Import_To_List_Test_Case.a5wcmp
    Mike Brown - Contact Me
    Programmatic Technologies, LLC
    Programmatic-Technologies.com
    Independent Developer & Consultant

  2. #2
    "Certified" Alphaholic mikeallenbrown's Avatar
    Real Name
    Mike Brown
    Join Date
    Nov 2009
    Location
    United States
    Posts
    1,819

    Default Re: Import to List from Excel

    Per Selwyn it's a SQL error that is stopping the process. Alpha's code currently doesn't handle the presence of computed columns well.

    there is an error reported by sql server, which is shown below

    we will need to make a change to some code on our side to support import into tables that have computed columns
    Mike Brown - Contact Me
    Programmatic Technologies, LLC
    Programmatic-Technologies.com
    Independent Developer & Consultant

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. Import data from Excel into list -- Not available??
    By mikeallenbrown in forum Mobile & Browser Applications
    Replies: 1
    Last Post: 08-15-2016, 05:23 PM
  3. 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
  4. Import excel or CSV to UX (with list)
    By WindForce in forum Mobile & Browser Applications
    Replies: 0
    Last Post: 04-20-2015, 05:01 AM
  5. Excel/ASCII import into List Control with detail view
    By WindForce in forum Mobile & Browser Applications
    Replies: 1
    Last Post: 12-22-2014, 10:48 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
  •