Client Management Suite

 View Only
  • 1.  report is not loaded properly

    Posted May 14, 2013 06:41 AM

    I have download the all installed software report. When i open the xxxxxx.csv file it showing error with File not loaded completely. I have extract the file number of time and every time file open with error.

    My confusion is that this is a normal error message or some of rows are missing?

    any permanent solution to fix it?



  • 2.  RE: report is not loaded properly

    Posted May 14, 2013 07:12 AM

    Hello

    What is the current running version?

    Kindly share the snapshot of error.



  • 3.  RE: report is not loaded properly

    Posted May 14, 2013 07:14 AM

    Hello

    Download the report in different format like .html/.xml and check it working fine or not?



  • 4.  RE: report is not loaded properly

    Posted May 14, 2013 07:34 AM

    hello,

    Can you provide office version ?

    Your data limit are exceed for Rows

    check this Microsoft KB

    "File not loaded completely" error importing text files larger than 65536 rows in Mac XL

    http://support.microsoft.com/kb/190032

     



  • 5.  RE: report is not loaded properly
    Best Answer

    Posted May 14, 2013 07:44 AM

    Excel has row limit 65536/1,048,576. If you have installed the excel 2003 then it limit is 65536. So you need to upgrade the excel later that 2003 version for getting the more row limit. 2007/2010 row limit is 1,048,576.

    If in case your data is bigger than this count then easiest way is then you can split the file in 2 parts.

    For splitting you can open the file in notepad and divide the data in 2 different notepad file and then save in .csv format. Try it.

     

    http://forums.asp.net/t/1189246.aspx

    Worksheet and workbook specifications and limits

    http://office.microsoft.com/en-in/excel-help/excel-specifications-and-limits-HP010342495.aspx

     

     



  • 6.  RE: report is not loaded properly

    Posted May 14, 2013 10:37 AM

    Rrajar,

    Make a test, put a filter on report and export to csv.
    Try to open, if the error not exist the problem is on limit of lines  of excel.

    Custodio



  • 7.  RE: report is not loaded properly

    Posted May 16, 2013 08:38 AM

    Hi,

    Create a snapshot for filtered output report which has limited rows and then export report, it will confirm that whether problem for limit of lines in csv. file or some other side.



  • 8.  RE: report is not loaded properly

    Posted May 17, 2013 02:51 AM

    I have divide the file in multiple with open it text format, but i am interested to know about snapshot, How to select snapshot?

    How it work?



  • 9.  RE: report is not loaded properly

    Posted May 17, 2013 02:52 AM

    there are multiple software data which i was required so don't know how to create the filter for multiple.



  • 10.  RE: report is not loaded properly

    Posted May 18, 2013 08:46 AM

    I have raise a forum so please give the step to use snapshot feature

    https://www-secure.symantec.com/connect/forums/snapshot-feature