[SLUG] OT Open Source CRM Package
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
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
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)?
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
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
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
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:
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:
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:
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:
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:
[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:
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?
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