ERP/CMS for Small Business IT consultants

Serge asks: "In my IT-consultancy-network-engineer job, where I visit several small business customers, I've been looking for some software to extensively manage resources I have on our customers. Currently, the system sucks. We write reports in Microsoft Word, draw network schemes in Visio, export offers to PDF, and so on, and stack it all together on a nice Windows file server in a per customer directory structure. So much for the automation aspect of Information Technology. My ideal app would be accessible online and offline (I travel with my laptop), I would document a log on every network object I work on, I could pull a query on all those logs from one day to give a daily report to the customer, I could input my working hours to bill later on, it would be integrated with our helpdesk software and would manage each customer's to-do list. The sky is the obviously limit. So, what does Slashdot do to fully handle this information ERP issue?"

Comments

You have the tools

[Ropati]

Script it. Batch it. Perl it. AutoIT it. VBA it. Don't start over with a package. Make what you have work.

You write reports in Microsoft Word:
Make a template of your reports with all boiler plate data. Create a form to open with the template to enter the necessary data. Automate the form to a database for other reports, Statements of Work, Invoices etc..

You Draw network schemes in Visio:
Generate automation scripts to build your drawings. Visio has all the tools. In Visio 2000 you could import well formed text files. As I understand it, in Visio2003 you can import xml. Write a script to parse your sys data and make diagrams.

Export offers to PDF:
Look at AutoIT (http://www.hiddensoft.com/AutoIt/): You can automate whatever you need to do by keystroke.

Stack it all together on a nice Windows file server in a per customer directory structure:
And what is your problem??
Harden and put the file server in a DMZ with IPsec. Update the files from the road. Work alot behind an enterprise firewall, use SSH on the file server. Or VPN into your company system.

I could pull a query on all those logs from one day to give a daily report to the customer:
Try using Outlook journaling features (unfamiliar). Get the journal to generate time usage by time spent on Visio or Word doc work per File|Properties|Catagories string which would be scripted in.

I could input my working hours to bill later on:
Isn't that what Outlook Journalling does??

integrated with our helpdesk software:
What do you want to integrate? Diagrams? Reports?

If your file structure is clear enough, you should be able to script that pretty easily.
\Customer\Service Date\Reports
\Customer\Service Date\Diagrams etc.
One push of a button should open the customers latest diagram.

would manage each customer's to-do list:
This is probably more difficult as you want to now integrate with your financial package (open POs). Still it can be scripted.

Need help?
Google:
Microsoft Script Center
Scriptomatic
Perl
AutoIT
VBscript tutorials

Enable VBA in Word, Outlook and Visio. Read the help files

Or as all the other OOS zealots will tell you, start all over, learn Linux and roll your own.