Jump to content

Downloading sales report


Recommended Posts

If you work on a csv file in "Numbers" on a mac and save it it becomes a "Numbers" spreadsheet and DACS cannot read it. I have had that happen to me.

 

Allan

 

 

Link to comment
Share on other sites

2 minutes ago, Kathy deWitt said:

I can't see where you download a CSV file.  Can someone direct me please?  It used to be quite obvious.

 

Thank you,

 

Kathy

 

 

"Download sales report" on dashboard to the right of cleared balance.

Then download with the relevant columns.

Link to comment
Share on other sites

50 minutes ago, spacecadet said:

"Download sales report" on dashboard to the right of cleared balance.

Then download with the relevant columns.

 

Of course, thank you.  It doesn't seem to work with my version of excel though, seems to be the wrong format, hmm, or maybe the Excel version is too old. V 14.0.0 Mac 2011?  I never use Excel and am not at all familiar with it.

Link to comment
Share on other sites

52 minutes ago, Kathy deWitt said:

 

Of course, thank you.  It doesn't seem to work with my version of excel though, seems to be the wrong format, hmm, or maybe the Excel version is too old. V 14.0.0 Mac 2011?  I never use Excel and am not at all familiar with it.

I'm using Excel 2010, but on a PC.

  • Upvote 1
Link to comment
Share on other sites

1 hour ago, Kathy deWitt said:

 

Of course, thank you.  It doesn't seem to work with my version of excel though, seems to be the wrong format, hmm, or maybe the Excel version is too old. V 14.0.0 Mac 2011?  I never use Excel and am not at all familiar with it.

 

My Mac Excel version is 14.7.7

Here's what I did:

Open Excel

From Alamy dashboard select download>sales report

Select dates, date paid, date of invoice, etc

Click "go"

Click "download" noting download destination of the files

In Excel: Select file>open

at bottom of window select "enable all files"

You should be able to navigate to and open your downloaded file from here.

 

  • Upvote 1
Link to comment
Share on other sites

5 minutes ago, Cecile Marion said:

Thanks Marion,  It seems I can post here again.  I have managed to do this.  The layout looks peculiar but perhaps the recipient can sort this out.  

 

 

5 minutes ago, Cecile Marion said:

My Mac Excel version is 14.7.7

Here's what I did:

Open Excel

From Alamy dashboard select download>sales report

Select dates, date paid, date of invoice, etc

Click "go"

Click "download" noting download destination of the files

In Excel: Select file>open

at bottom of window select "enable all files"

You should be able to navigate to and open your downloaded file from here.

 

2 hours ago, spacecadet said:

"Download sales report" on dashboard to the right of cleared balance.

Then download with the relevant columns.

 

Link to comment
Share on other sites

  • 6 months later...

CSV can be opened in Excel with no issues, it's an excel extension actually. Speaking of pdf, you could convert the report to this, there are dozens of editing tools allowing to do so, like this, as an example edit-pdf.pdffiller.com/ but consider it as a paid one, as well as the result you get can be formatted inproperly

Link to comment
Share on other sites

On 2/14/2018 at 15:52, Kathy deWitt said:

 

Of course, thank you.  It doesn't seem to work with my version of excel though, seems to be the wrong format, hmm, or maybe the Excel version is too old. V 14.0.0 Mac 2011?  I never use Excel and am not at all familiar with it.

 

It may just be that the column width isn't wide enough, this happens to me. Open the CSV in Excel and if the date columns appear to be full of ##### just right click the column header and increase the width to 12. CSV files should be readable in pretty much any version of Excel.

 

Mark

Link to comment
Share on other sites

On 2/6/2018 at 15:56, Allan Bell said:

If you work on a csv file in "Numbers" on a mac and save it it becomes a "Numbers" spreadsheet and DACS cannot read it. I have had that happen to me.

 

Allan

 

 

 

You can export from Mac Numbers to Excel format. File>Export to>Excel...

 

Mark

Link to comment
Share on other sites

13 hours ago, M.Chapman said:

 

You can export from Mac Numbers to Excel format. File>Export to>Excel...

 

Mark

 

Thanks Mark

 

Allan

 

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.