pierre rochon Posted February 6, 2018 Share Posted February 6, 2018 Is there a way to download a sales report as a PDF or Excel file? I'm only able to download a CSV file and DACS asks for PDF or Excel. Link to comment Share on other sites More sharing options...
James Hodgson Posted February 6, 2018 Share Posted February 6, 2018 If you have excel, you can open a csv file and the re save in whatever format you want. Link to comment Share on other sites More sharing options...
spacecadet Posted February 6, 2018 Share Posted February 6, 2018 csv is an Excel file. That's what I send to DACS. Link to comment Share on other sites More sharing options...
Allan Bell Posted February 6, 2018 Share Posted February 6, 2018 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 More sharing options...
spacecadet Posted February 6, 2018 Share Posted February 6, 2018 Only referring to Excel. I think the OP is too. Link to comment Share on other sites More sharing options...
pierre rochon Posted February 6, 2018 Author Share Posted February 6, 2018 I just sent the CSV file to DACS. Thanks for your answers. Link to comment Share on other sites More sharing options...
Kathy deWitt Posted February 14, 2018 Share Posted February 14, 2018 I can't see where you download a CSV file. Can someone direct me please? It used to be quite obvious. Thank you, Kathy Link to comment Share on other sites More sharing options...
spacecadet Posted February 14, 2018 Share Posted February 14, 2018 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 More sharing options...
Kathy deWitt Posted February 14, 2018 Share Posted February 14, 2018 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 More sharing options...
Cecile Marion Posted February 14, 2018 Share Posted February 14, 2018 Try setting your dates, then press “go” , before selecting download. Link to comment Share on other sites More sharing options...
spacecadet Posted February 14, 2018 Share Posted February 14, 2018 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. Link to comment Share on other sites More sharing options...
Kathy deWitt Posted February 14, 2018 Share Posted February 14, 2018 24 minutes ago, Cecile Marion said: Try setting your dates, then press “go” , before selecting download. Yes, I did this thank you. Link to comment Share on other sites More sharing options...
Cecile Marion Posted February 14, 2018 Share Posted February 14, 2018 My version of excel is about the same, though I haven’t checked. I downloaded and opened a file just the other day, but did have to fiddle with the program first. I’ve kept my excel up to date though, installing any new updates. Link to comment Share on other sites More sharing options...
spacecadet Posted February 14, 2018 Share Posted February 14, 2018 No fiddling here, and no updates. Link to comment Share on other sites More sharing options...
Cecile Marion Posted February 14, 2018 Share Posted February 14, 2018 Good point. Before excel would even recognize the CSV file I had to select something like “view all files” within the program. Link to comment Share on other sites More sharing options...
Cecile Marion Posted February 14, 2018 Share Posted February 14, 2018 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. Link to comment Share on other sites More sharing options...
Kathy deWitt Posted February 14, 2018 Share Posted February 14, 2018 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 More sharing options...
kontzBern Posted August 15, 2018 Share Posted August 15, 2018 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 More sharing options...
M.Chapman Posted August 15, 2018 Share Posted August 15, 2018 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 More sharing options...
M.Chapman Posted August 15, 2018 Share Posted August 15, 2018 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 More sharing options...
Allan Bell Posted August 16, 2018 Share Posted August 16, 2018 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.