Hello & question/request

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



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-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

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

On 25-May-2013, at 5:32 AM, Tim <ba...@gmail.com> wrote:

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



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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 



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-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

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




On Fri, May 24, 2013 at 7:17 PM, Anand Doshi <an...@iwebnotes.com> wrote:
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

On 25-May-2013, at 5:32 AM, Tim <ba...@gmail.com> wrote:


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



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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.








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-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

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

On 05-Jun-2013, at 8:53 AM, Timothy Baker <ba...@gmail.com> wrote:

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




On Fri, May 24, 2013 at 7:17 PM, Anand Doshi <an...@iwebnotes.com> wrote:
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

On 25-May-2013, at 5:32 AM, Tim <ba...@gmail.com> wrote:


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



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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 



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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 




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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

<screencap.jpg>



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-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

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



On Tue, Jun 4, 2013 at 8:36 PM, Anand Doshi <an...@iwebnotes.com> wrote:
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

On 05-Jun-2013, at 8:53 AM, Timothy Baker <ba...@gmail.com> wrote:


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




On Fri, May 24, 2013 at 7:17 PM, Anand Doshi <an...@iwebnotes.com> wrote:
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

On 25-May-2013, at 5:32 AM, Tim <ba...@gmail.com> wrote:


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



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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.








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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.




<screencap.jpg>



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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







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-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

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.

On 5 Jun 2013 08:54, "Timothy Baker" <ba...@gmail.com> wrote:
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




On Fri, May 24, 2013 at 7:17 PM, Anand Doshi <an...@iwebnotes.com> wrote:
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

On 25-May-2013, at 5:32 AM, Tim <ba...@gmail.com> wrote:


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



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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.








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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.






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-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

Sorry, role needed is "Report Manager"

On 5 Jun 2013 10:01, "Nabin Hait" <na...@iwebnotes.com> wrote:

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.

On 5 Jun 2013 08:54, "Timothy Baker" <ba...@gmail.com> wrote:
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




On Fri, May 24, 2013 at 7:17 PM, Anand Doshi <an...@iwebnotes.com> wrote:
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

On 25-May-2013, at 5:32 AM, Tim <ba...@gmail.com> wrote:


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



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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.








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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.






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-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

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 :)


On Wed, Jun 5, 2013 at 8:53 AM, Timothy Baker <ba...@gmail.com> wrote:
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




On Fri, May 24, 2013 at 7:17 PM, Anand Doshi <an...@iwebnotes.com> wrote:
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

On 25-May-2013, at 5:32 AM, Tim <ba...@gmail.com> wrote:


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



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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.








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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.












Twitter: @rushabh_mehta



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-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

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


On Tue, Jun 4, 2013 at 9:40 PM, Rushabh Mehta <rm…@gmail.com> wrote:

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 :)


On Wed, Jun 5, 2013 at 8:53 AM, Timothy Baker <ba...@gmail.com> wrote:
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




On Fri, May 24, 2013 at 7:17 PM, Anand Doshi <an...@iwebnotes.com> wrote:
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

On 25-May-2013, at 5:32 AM, Tim <ba...@gmail.com> wrote:


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



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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.








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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.














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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







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-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.