[SLUG] OT Open Source CRM Package

2008-04-30 Thread leei
Hi all,

Sorry to bother all of you.

I hope that you might have a solution for me regarding the below.

We are looking for an Open Source CRM package that will take all e-mails
from Microsoft Outlook and export the mail folders from them into the CRM
package and have all the e-mails stored on the server so that all customer
details will be on the server. On the CRM package there can be levels of
security so that the md's data and the data for the staff are separate.

Thanks,

Regards,
Lee






---
South Africas premier free email service - www.webmail.co.za 
--
For super low premiums, click here http://www.webmail.co.za/dd.pwm

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] Outputing progress counters with PHP/HTML

2008-04-30 Thread Matthew Hannigan
  
  You do a select before every insert?!  Is the table indexed?
  If not that might explain the slowdown; a select WILL take
  longer the bigger the table.
 
 Perhaps better to put a unique index on the appropriate column(s), then
 just do an insert and throw away the error if the data is already there.

Yes, even better!  I was going to ask Howard whether it mattered
whether the data was different or whether it just had to be one of them.



-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] OT Open Source CRM Package

2008-04-30 Thread Sonia Hamilton
On Wed, 2008-04-30 at 08:41 +0200, [EMAIL PROTECTED] wrote:
 We are looking for an Open Source CRM package that will take all e-mails
 from Microsoft Outlook and export the mail folders from them into the CRM
 package and have all the e-mails stored on the server so that all customer
 details will be on the server. On the CRM package there can be levels of
 security so that the md's data and the data for the staff are separate.

Seems that you have 2 issues here:

1) getting the emails from Outlook
2) an Open Source CRM

For 1), what details do want? Email address only? All email to that
customer? Name? Is the email stored in .pst files on each user's
workstation, or up on an Exchange server? If on an Exchange server, one
way to access the emails would be to enable IMAP and get at the data via
a perl script

For 2) don't know. But I seem to remember Sridar posting about a package
a few days ago.

-- 
Thanks,
.
Sonia Hamilton
http://www.snowfrog.net
http://training.snowfrog.net
http://www.linkedin.com/in/soniahamilton
.
Your manuscript is both good and original; but the part that is good is
not original and the part that is original is not good - Samuel Johnson.

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] perl equivalent for cd $(dirname $0)?

2008-04-30 Thread Rick Welykochy

Sonia Hamilton wrote:


The difficulty in solving problems in any new topic is often knowing
what question to ask :-) I searched and searched (got the perl doco
locally), but didn't know what to look for...


Even if you know what you are looking for, things can be difficult.
Ever try to find out how the 'read' command works in bash? Searching
for the word 'read' in the doco leaves me breathless.

cheers
rickw


--

Rick Welykochy || Praxis Services || Internet Driving Instructor

We like to think of ourselves as the Microsoft of the energy world.
 -- Kenneth Lay, former CEO of Enron
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] Backup from Windows files to Linux

2008-04-30 Thread Massimiliano Fantuzzi
hi everybody !

in answer to question how to back up files from a Windows 2003 Small
Business Server ?
i would suggest, in addition to your solutions,  to try bacula, from
http://www.bacula.org , which runs pretty on every system, with GUIs and web
interfaces, a great solution.

another would be FREENAS , an entire Linux OS dedicated to backups. from
http://www.freenas.org/
it runs also on a virtual machine or obviously installed, and is great since
it integrates in Active Diretory, seamless RAID configuration, and rsync,
whose clients are available also for windows.

so, both solutions are good candidates to a backup machine, which acts as
NAS, and can inherit AD policies.
you can then automate (also by GUIs) your policies, but sure, a little
scripting can always help !!

bye and sorry for late posting, HTH however.
Massimiliano Fantuzzi


On Thu, Jan 10, 2008 at 6:09 PM, Kelvin Nicholson [EMAIL PROTECTED]
wrote:

 Lee:

 In my opinion it depends on your goals.  It would be easy enough to
 setup a Linux box with Samba, map a share called e.g. 'Backup', and then
 use ntbackup to schedule routine backups to that share.  Although
 ntbackup is quite basic, it would fit the requirements you outlined, and
 cover you to a limited extent.

 Alternatively, you could take your pick of backup software for Windows
 (Backup Exec, ShadowProtect...) and use that to backup to the shared
 drive.

 That's what I have done/would do at least.

 Cheers,

 Kelvin


 On Thu, 2008-01-10 at 14:50 +0200, [EMAIL PROTECTED] wrote:
  Hi there,
 
  I am not sure if this is possible.
 
  Is there away for a Linux PC to be able to back up files from a Windows
  2003 Small Business Server. I would prefer to use Ubuntu as it is quick
 to
  install but the backup application would need to have a gui and be able
 to
  do full and incremental backups.
 
  Regards,
  Lee
 
 
  ---
  South Africas premier free email service - www.webmail.co.za
  --
  For super low premiums, click here http://www.webmail.co.za/dd.pwm
 
 --
 Kelvin Nicholson
 Voice: +886 9 52152 336
 Voice: +1 503 715 5535
 GPG Keyid: 289090AC
 Data: [EMAIL PROTECTED]
 Skype: yj_kelvin
 Site: http://www.kelvinism.com

 --
 SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
 Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html




-- 
Massimiliano Fantuzzi,
IT Professionist  System Builder
www.fantuz.net // [EMAIL PROTECTED]
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] Backup from Windows files to Linux

2008-04-30 Thread Massimiliano Fantuzzi
hi everybody !

in answer to question how to back up files from a Windows 2003 Small
Business Server ?
i would suggest, in addition to your solutions,  to try bacula, from
http://www.bacula.org , which runs pretty on every system, with GUIs and web
interfaces, a great solution.

another would be FREENAS , an entire Linux OS dedicated to backups. from
http://www.freenas.org/
it runs also on a virtual machine or obviously installed, and is great since
it integrates in Active Diretory, seamless RAID configuration, and rsync,
whose clients are available also for windows.

so, both solutions are good candidates to a backup machine, which acts as
NAS, and can inherit AD policies.
you can then automate (also by GUIs) your policies, but sure, a little
scripting can always help !!

bye and sorry for late posting, HTH however.
Massimiliano Fantuzzi

  On Thu, Jan 10, 2008 at 6:09 PM, Kelvin Nicholson [EMAIL PROTECTED]
 wrote:

  Lee:
 
  In my opinion it depends on your goals.  It would be easy enough to
  setup a Linux box with Samba, map a share called e.g. 'Backup', and then
  use ntbackup to schedule routine backups to that share.  Although
  ntbackup is quite basic, it would fit the requirements you outlined, and
  cover you to a limited extent.
 
  Alternatively, you could take your pick of backup software for Windows
  (Backup Exec, ShadowProtect...) and use that to backup to the shared
  drive.
 
  That's what I have done/would do at least.
 
  Cheers,
 
  Kelvin
 
 
  On Thu, 2008-01-10 at 14:50 +0200, [EMAIL PROTECTED] wrote:
   Hi there,
  
   I am not sure if this is possible.
  
   Is there away for a Linux PC to be able to back up files from a
  Windows
   2003 Small Business Server. I would prefer to use Ubuntu as it is
  quick to
   install but the backup application would need to have a gui and be
  able to
   do full and incremental backups.
  
   Regards,
   Lee
  
  
   ---
   South Africas premier free email service - www.webmail.co.za
   --
   For super low premiums, click here http://www.webmail.co.za/dd.pwm
  
  --
  Kelvin Nicholson
  Voice: +886 9 52152 336
  Voice: +1 503 715 5535
  GPG Keyid: 289090AC
  Data: [EMAIL PROTECTED]
  Skype: yj_kelvin
  Site: http://www.kelvinism.com
 
  --
  SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
  Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
 

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


[SLUG] SyPy meetup tonight

2008-04-30 Thread Mary Gardiner
FYI: apparently they are having one, it's just disorganised.

http://groups.google.com/group/sydneypython/browse_thread/thread/4dc848216c6df829#

According to our schedule this Thursday, the 1st of May is the time for
our monthly get together? Does anyone fancy joining me for a cold
beverage or two at the Grace Hotel from, say, 6pm?

-Mary
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


[SLUG] mutt Reply-To:

2008-04-30 Thread david
I'm using mutt in a script to send out emails. 

$ mutt -s subject -a file [EMAIL PROTECTED]  /dev/null

Is there any way to add a Reply-To: header? I can't find it in google or
man mutt.

Is there any other scripted way of doing it? Preferably bash.

thanks

David.

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] mutt Reply-To:

2008-04-30 Thread John Clarke
On Thu, May 01, 2008 at 01:07:50 +1000, david wrote:

 I'm using mutt in a script to send out emails. 
 
 $ mutt -s subject -a file [EMAIL PROTECTED]  /dev/null
 
 Is there any way to add a Reply-To: header? I can't find it in google or

This might work:

mutt -s subject -a file -e 'my_hdr Reply-To [EMAIL PROTECTED]'  
/dev/null


Cheers,

John
-- 
 Oh yes - it's the old type random commands into vi and see what
 happens problem.
At least it wasn't TECO. Vi beeps too early to do much damage.
-- Tim Connors
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] mutt Reply-To:

2008-04-30 Thread AnĂ­bal Monsalve Salazar
On Thu, May 01, 2008 at 01:16:34PM +1000, John Clarke wrote:
This might work:

mutt -s subject -a file -e 'my_hdr Reply-To [EMAIL PROTECTED]'  
 /dev/null

I prefer:

(echo -e Subject: test\nTo: [EMAIL PROTECTED]: [EMAIL PROTECTED]: [EMAIL 
PROTECTED]: blahblah; cat /etc/hostname) | /usr/lib/sendmail -t


signature.asc
Description: Digital signature
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

Re: [SLUG] mutt Reply-To:

2008-04-30 Thread Robert Thorsby
On 01/05/08 13:07:50, david wrote:
 I'm using mutt in a script to send out emails. 
 
   $ mutt -s subject -a file [EMAIL PROTECTED]  /dev/null
 
 Is there any way to add a Reply-To: header? I can't
 find it in google or man mutt.
 
 Is there any other scripted way of doing it?
 Preferably bash.

I don't use mutt but some MUAs (eg, msmtp, E-MailRelay) treat the first 
paragraph of body text, if the para contains only Headers that are 
properly formatted, as headers.

I frequently use bash to either splice in some headers or expand 
existing headers (eg, to expand [EMAIL PROTECTED] to John Smith 
[EMAIL PROTECTED]) with the two mail clients mentioned above.

Robert Thorsby
MSOOXML - Not the best standard money can buy.

--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] mutt Reply-To:

2008-04-30 Thread Scott Ragen
[EMAIL PROTECTED] wrote on 01/05/2008 01:07:50 PM:

 I'm using mutt in a script to send out emails. 
 
 $ mutt -s subject -a file [EMAIL PROTECTED]  /dev/null
 
 Is there any way to add a Reply-To: header? I can't find it in google or
 man mutt.
 
 Is there any other scripted way of doing it? Preferably bash.
 

Set REPLYTO environment variable?
Its in the mutt man page.

Cheers,

Scott

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] mutt Reply-To:

2008-04-30 Thread david
On Thu, 2008-05-01 at 13:41 +1000, Scott Ragen wrote:
 [EMAIL PROTECTED] wrote on 01/05/2008 01:07:50 PM:
 
  I'm using mutt in a script to send out emails. 
  
  $ mutt -s subject -a file [EMAIL PROTECTED]  /dev/null
  
  Is there any way to add a Reply-To: header? I can't find it in google or
  man mutt.
  
  Is there any other scripted way of doing it? Preferably bash.
  
 
 Set REPLYTO environment variable?
 Its in the mutt man page.
 

I thought that was for invoking the REPLY-TO: when replying. I need to
create a REPLY-TO: in the original email. Am I wrong?


-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Thanks Re: [SLUG] NTFS HD, chkdsk and ntfsresize?

2008-04-30 Thread bill

Thanks for the reply Amos

Prior to your advice I tried G4L but stuffed it by reversing 
Source/Target . Dont know what data I lost ( Home PC), but nothing 
irreplaceable I think.


Oh well, at least I now have an empty 120gb SATA HD that I can reformat 
for Linux.


Thanks again

Bill


Subject:
Re: [SLUG] NTFS HD, chkdsk and ntfsresize?
From:
Amos Shapira [EMAIL PROTECTED]
Date:
Wed, 30 Apr 2008 14:03:20 +1000
To:
SLUG slug@slug.org.au

To:
SLUG slug@slug.org.au


On Wed, Apr 30, 2008 at 11:42 AM, bill [EMAIL PROTECTED] wrote:
  

 Note - Using 57676M ( obtained from result of sudo ntfsresize -i /dev/sda1
above) didnt work.

 Is it safe to use sudo ntfsresize  --force -s 43896M /dev/sda1 or do I risk
losing my data?



You should first resize the partition in the partition table (using
fdisk, delete then re-create the partition, change its type to 7
(NTFS)), have you done that?
After that is done, ntfsresize will by default automatically resize
the file system to occupy the entire partition (see the bottom of the
output from running ntfsresize without arguments).

--Amos

  






--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html