Search results by user ID 5398

Re: Export to Excel eats my data

Fred_D — Tue, 14 Aug 2012 20:38:22 GMT

Thanks for clearing that up. Sorry I misunderstood. Will get screen shot out later. Right now working on getting a hundred or so new membership cards out.

However, when I bring up any table in Method, my view is truncated to only as many columns that will fit on the display and I am not aware of any way to shrink it or view more columns (no scroll bar at the bottom). So, I can only give you a partial picture.

Fred

Re: Export to Excel eats my data

Fred_D — Tue, 14 Aug 2012 20:05:36 GMT

Sorry to not understand, but what you do mean by "grid"?

Fred

Re: Export to Excel eats my data

Fred_D — Tue, 14 Aug 2012 19:00:43 GMT

Thanks! What specifically do you want a screen shot of?

Fred

Re: Export to Excel eats my data

Fred_D — Mon, 13 Aug 2012 22:31:52 GMT

Nothing is different in how data is entered into QuickBooks, unless they changed their formatting. In our database, BillTo and Ship to are always identical.

Fred

Re: Export to Excel eats my data

Fred_D — Mon, 13 Aug 2012 22:29:55 GMT

i haven't made a screen shot in several yeas and it was several versions of Windows ago. I'll try and get one to you.

Fred

Re: Export to Excel eats my data

Fred_D — Mon, 13 Aug 2012 21:53:22 GMT

All zip code data is input into QuickBooks when we set up the Customer's account. From there it synchronizes into Method.

We never input customer entity data into Method. We always use QuickBooks to set up customer accounts.

The zip code data appears the Customer table. The membership tables takes it's data from the Customer table. We have made no modifications. Everything had been working fine since we started paying for Method. Now it doesn't.

Fred

Re: Export to Excel eats my data

Fred_D — Mon, 13 Aug 2012 17:20:44 GMT

After subscribing to Method last year, I set up a duplicate of my Customer table as a Membership table that I used to generate membership lists and generate membership cards.

Everything was running fine until June when I found that I could no longer export the table. I fixed this by republishing (no changes were made by me) and running the "export to Excel" function. Like I said, I did nothing to create this and assume it was a hiccup in your programming.

This table contains about 6,400 names. I now find that when I export to Excel, the spreadsheet is missing the zip code of most of my new members since June. I say most because I find it randomly adds some zip code, but all but a few are missing.

I don't have this problem when I export my Customer data to a CSV file that I use for printing mailing labels.

Again, I have made no changes and this problem started right after I had to republish my table because of something that happened on your end.

If you would like access to my account and run the files for yourself, just let me know.

Fred
PS - I'm finding it difficult to use this forum. My font is very very tiny and the first two lines scrunch together but I can't find the option to change my fonts. I had to create my response in a text editor in order for me to see what I was typing.

Export to Excel eats my data

Fred_D — Sat, 11 Aug 2012 17:08:10 GMT

I have been exporting one of my Customer files to Excel for as long as I've been using Method.

Since June, Method is not exporting zip codes on new customers that I have added. The customer was added in QuickBooks and migrates to Method and the zip codes are showing up in the table, but when I export the table to an Excel file the zip code disappears.

I "re-published" the table but nothing changed.

What's going on?

Fred

Re: Export to Excel - Error 404

Fred_D — Mon, 02 Jul 2012 23:59:06 GMT

This is wierd. I cured the problem by going into "customize," then "editing" the file and doing nothing more than "publshiing" and then saving and closing.

Question is - why did I need to do that? I haven't made any modifications to that file in a very long time and have been exporting it to Excel on a routing basis.

Thanks,
Fred

Export to Excel - Error 404

Fred_D — Mon, 02 Jul 2012 23:47:32 GMT

Just tried to export one of my customer tables to Excel (something I've been doing since the beginning) and I get a Server Error notice 404 - File or directory not found.

That pretty much stops all my work. How do "we" get it working again.

Thanks!
Fred