Hello & question/request

[Tim]

Hello Rushabh & All-

Is there any way to get an XLS dump (or even a CSV file) of all time logs entered in our database?  No particular formatting necessary, just a plain listing.  We're still in the process of aligning jobs to hours/cost centers/employee rates etc and need to do a manual accounting of all hours since January of '13. I tried to batch them all together with no luck...

R/tb

[Anand Doshi]

Hi Tim,

You can go to Projects > Time Log and click on the report icon from the list view. 

Here select the desired columns and click on the export button. 

Thanks 

Anand

Sent from my phone

--
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-fo...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Timothy Baker]

Anand,

Thank you for the reply, and apologies for the delay in mine; I've got a newborn at home and she's been taking me away from work in large chunks...

It's probably staring me in the face, but when I'm in the list view I can't locate an export button.. I've attached a screenshot to show you what I'm seeing. Am I missing something obvious, or has sleep deprivation finally taken over?

Thanks in advance-

tb

--
You received this message because you are subscribed to a topic in the Google Groups "ERPNext User's Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-user-forum/49-sWocMoHU/unsubscribe?hl=en.
To unsubscribe from this group and all its topics, send an email to erpnext-user-fo...@googlegroups.com.

[Anand Doshi]

Hi Tim,

Congratulations :)

You are almost there. Just to the left of the close button of the list view, there are 3 buttons. The last of them is the report view button. Go to the report view, select the desired columns and export. 

Thanks

Anand. 

Sent from my phone

<screencap.jpg>

[Timothy Baker]

Thanks, Anand.. I can't wait until she's a bit older and can push a lawnmower :/

Okay, I feel a bit silly here, but:

From Projects I enter the Time Log List; I've now got three icons/buttons to the left of the 'close' button (mousing over them shows form / list / calendar). I assume that since 'list' is black, it's the selected view.. but no report view button that I can see.  Again, my brain is admittedly at reduced capacity, but I'm not seeing it. Is it possible I've inadvertently removed it via the permission manager or some granular property I've previously changed?

t

[Nabin Hait]

To export data from the system, you need "System Manager" role. And another thing, download option is only available in reporp view, not in default listview.

[Nabin Hait]

Sorry, role needed is "Report Manager"

[Rushabh Mehta]

Tim,

The export button is in the Report View not listview. 

It seems you have removed "Report" permissions for yourself. Go to permissions manager, select Time Log and check "Report" for your role.

Then refresh and you will see a "Report" icon in the list view toolbar. Click on that and you will get the export button.

best,

Rushabh

ps. Congrats on the new born :)

https://erpnext.com

Twitter: @rushabh_mehta

[Timothy Baker]

Ah, okay .. makes sense now. There's another admin who has been working in the system while I've been out, so I'm going to blame him. I had a feeling it was something permissions-related. I'll go in and reset the Report permissions to the default.

Thanks again to both of you for your time & patience.

R/tb