Method:Classic General Q&A

Re: Export to Excel

Anonymous — Mon, 10 Feb 2014 22:34:28 GMT

Hi Afrodite,

We've done some testing and discovered a few things. It appears that something has become corrupted on your grid. We tested the following to confirm this:

1) We created a new screen with the contacts table, built a grid, and created the Excel button -- it exported without issue.

2) We copied the original CRM_CustomerList screen, added an Export to Excel button, and again it worked without issue

3) Finally, we added a new grid to the custom screen you're currently having issue with, and redirected the Export to Excel button to that, and it worked

This confirms that the issue lies in your grid. I would recommend deleting the grid and re-creating it, and then re-trying the button.

Naeem

Re: Export to Excel

Anonymous — Thu, 06 Feb 2014 17:59:24 GMT

Hi Afrodite,

Still cracking at this -- I appreciate the patience. I had to edit your last post to remove some sensitive information -- for future reference, I recommend never to copy and paste stuff from live Method account to a forum post as it contains security related information. Screenshots would suffice, and are safe.

Naeem

Re: Export to Excel

Afrodite — Thu, 06 Feb 2014 15:42:39 GMT

Any updates?? Please advise

Re: Export to Excel

Afrodite — Wed, 05 Feb 2014 15:47:30 GMT

Hi Naeem,

The actions on the button are when button is click to export thecontact grid to excel. Below is some more info. Im not sure if it helps.

Screen Name	CPLEMS_CustomerJobList
Account	CPLEMS	Last Modified	2/5/2014 3:43:41 PM
Screen base table is	Contacts	Screen ID	706

Caption	Field Name in Table	Bound	Type	Row	Column
Header
Existing Customer Contacts List		False	Label	1	1

Search		False	Picture	1	5
Actions for Search
To edit an existing Customer or Contact click the Go To... link. If you'd like to create a new customer, click the New Customer tab link.		False	Label	2	1

Refresh		False	Button	3	1
Actions for Refresh
Existing Customers and Contacts List
Contacts		False	Grid	1	1

Footer Section
Export to Excel		False	Button	1	3
Actions for Export to Excel
New Customer		False	Picture	1	4
Actions for New Customer
Actions for Screen:
Actions for Screen
Total Grids: 1	Total Buttons: 2	Total Calendars: 0	Total Fields: 0	Total Objects: 7	Total Actions: 24

Re: Export to Excel

Anonymous — Wed, 05 Feb 2014 15:35:42 GMT

Hi Afrodite,

To answer this, I'll need a bit more information. Have you made any other changes to the customer/contacts list screen? Are there any other actions on the Export Grid button?

One quick thing you can try as well, is to re-open the screen and re-publish... that has fixed the issue for a customer in the past.

Naeem

Export to Excel

Afrodite — Wed, 05 Feb 2014 14:56:32 GMT

I created button that exports the contacts grid to excel but I am receiving and error message after I click on download excel report (see below).

I need to fix this asap because I am working on a project.

Belw is the error message I am receiving. Please advise how to correct this.

Thank you

Your file is ready to be downloaded. Click the link below to download your file:

Download Excel Report

Method:Classic General Q&A

Re: Export to Excel

Re: Export to Excel

Re: Export to Excel

Re: Export to Excel

Re: Export to Excel

Export to Excel

Server Error

404 - File or directory not found.

The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.