Nick Hill's dashboard

richallum replied on June 27, 2008 07:38 to the question "Multiple contacts to client" in FreeAgent Central:

Great work guys.

Olly replied on June 26, 2008 22:21 to the question "Multiple contacts to client" in FreeAgent Central:

Hi again everyone

We've added support for a project-specific contact name in tonight's new release:

http://www.freeagentcentral.com/centr...

Hope this works for you all!

Nick Hill replied on June 24, 2008 14:53 to the question "Importing existing invoice data from another system" in FreeAgent Central:

that'd be fab. I just tried adding another person at a company I'd already inputted, and was told I couldn't as the name was already taken.

Cheers

Nick

Nick Hill started following the question "Multiple contacts to client" in FreeAgent Central.

A comment on the question "Importing existing invoice data from another system" in FreeAgent Central:

As long as you have your VAT registration date set up correctly, this shouldn't be a problem – Olly, on June 24, 2008 14:44

Olly replied on June 24, 2008 14:43 to the question "Importing existing invoice data from another system" in FreeAgent Central:

Hi Nick

Regarding the multiple contacts for one client, we're going to be providing a workaround for this within the next couple of weeks. Take a look at this thread:

http://getsatisfaction.com/freeagentc...

When this is released you'll be able to specify a Project Contact Name when you create an invoice, which will override the client name.

We will be improving the Client/Project area at some stage in the not-too-distant future, but in the meantime hopefully this workaround will suffice.

Nick Hill replied on June 24, 2008 14:24 to the question "Importing existing invoice data from another system" in FreeAgent Central:

oh and also - these invoices go back before I was limited or VAT registered, would that create a problem?

Nick Hill replied on June 24, 2008 14:23 to the question "Importing existing invoice data from another system" in FreeAgent Central:

Hey Olly

No, that makes sense. The way my system's set up at the moment is similar to the FreeAgent way - ie there's a table for clients, a table for invoices, one for work types (which can be per hour or per day etc) and then a long list of invoice items. I can have a crack at generating an XML file based on your schema, I don't want to make extra work for you :)

One thing I noticed was that with FreeAgent you seem to need to create a client contact and then their company, ie you can't create a company and then just add names to it. It's be useful to be able to do this as I've got a couple of big clients with a number of contacts at each one, and they ask me to invoice the contact/department directly rather than sending things directly to the finance department. Is this easy to do, or is it just a case of setting up the same company multiple times, for as many contacts as I have there? ... if that makes sense!

Olly replied on June 24, 2008 14:07 to the question "Importing existing invoice data from another system" in FreeAgent Central:

Ok, that's quite a lot of invoices and items ;-)

How easy would it be for you to generate the required data in CSV (or XML!) format? If you could do this I can take a look at giving you a hand importing the data -- just email olly at freeagentcentral dot com.

Before you can import any invoices though, you'll have to set up relevant Clients (which you can import) and Projects in FreeAgent. Each invoice in your CSV data will then have to be assigned to an appropriate project, preferably with the Project ID (the number you see in the URL, e.g. /projects/123.

Does this make sense or are you now wholly baffled?

Nick Hill replied on June 24, 2008 13:55 to the question "Importing existing invoice data from another system" in FreeAgent Central:

There are about 1400 items in all, over 148 invoices... I'd rather not do it by hand really but if that's the only way it might be an "evening project" for the next few months...

Olly replied on June 24, 2008 13:28 to the question "Importing existing invoice data from another system" in FreeAgent Central:

Hi Nick

Out of interest, how many invoices are you looking to import and how many items are generally on each invoice? It might not take you that long to do this manually, I reckon a couple of hours would do it.

Nick Hill replied on June 24, 2008 13:17 to the question "Importing existing invoice data from another system" in FreeAgent Central:

Hi Olly

Thanks very much for that. I think that might be a bit beyond me... I'd have to look into it (I'm not really a web developer, I just dabble, and I know PHP but not Ruby). I might try finding someone who can do that for me though, if it's not a big job. I'd imagine it'd be useful for other people too...

Cheers

Nick

Olly replied on June 24, 2008 13:11 to the question "Importing existing invoice data from another system" in FreeAgent Central:

Hi Nick

We don't have the facility to import directly from CSV or another database I'm afraid, but we do have an API which provides programmatic access to your FreeAgent account.

Check out the Invoices section in our API guide:

http://www.freeagentcentral.com/devel...

It would be pretty easy to write a script using, say, Ruby (the language FreeAgent is built with) or Python, to get your invoice data in, if you have those skills of course.

Is this an approach which would work for you?

Nick Hill asked a question in FreeAgent Central on June 24, 2008 12:53:

Importing existing invoice data from another system

I currently use a home-grown invoicing system - it's basic but is at least built on a database. It's got about 2 years of invoices in it - is it possible to import these into FreeAgent somehow? I can get the data into a CSV format or whatever's easiest.
Thanks in advance
Nick

nick@rainjam.com