Applied Users Forums

General Topics => Helpline => Topic started by: Judy Means on January 24, 2011, 03:59:40 PM

Title: Export Vehicle schedule to excel?
Post by: Judy Means on January 24, 2011, 03:59:40 PM
Can you export a vehicle schedule to Excel?  Chartis is wanting us to submit our vehicle list in excel format...says turnaround time for rating is faster. 


TIA



Judy
Title: Re: Export Vehicle schedule to excel?
Post by: Coral on January 24, 2011, 04:03:43 PM
Using reports you can search the business auto form and pull the auto information that way. I thought you could do this at the client level, but I can't find it.
Title: Re: Export Vehicle schedule to excel?
Post by: Jan Regnier on January 24, 2011, 05:03:10 PM
It would be nice if you could do this like Cert holder list - export and import using excel!
Title: Re: Export Vehicle schedule to excel?
Post by: Judy Means on January 24, 2011, 05:06:11 PM
I hate going overboard for a company, but in the case of Chartis (AIG) we just might.  They are incrediably slow in quotes. 


Thanks all.  I'll check reports and see what I can do.
Title: Re: Export Vehicle schedule to excel?
Post by: brinkerdana on January 24, 2011, 07:26:21 PM
Quote from: Jan Regnier on January 24, 2011, 05:03:10 PM
It would be nice if you could do this like Cert holder list - export and import using excel!

I put in a PMR on this when the certholder upload/download came into being.  Never heard another thing.
Title: Re: Export Vehicle schedule to excel?
Post by: Lance Bateman on January 24, 2011, 07:49:29 PM
They do have this in Vision and Epic, but don't know if it's planned for TAM

Quote from: brinkerdana on January 24, 2011, 07:26:21 PM
Quote from: Jan Regnier on January 24, 2011, 05:03:10 PM
It would be nice if you could do this like Cert holder list - export and import using excel!

I put in a PMR on this when the certholder upload/download came into being.  Never heard another thing.
Title: Re: Export Vehicle schedule to excel?
Post by: brinkerdana on January 25, 2011, 07:22:16 AM
I sure would be a nice option if you insure truckers or distributors with huge fleets.
Title: Re: Export Vehicle schedule to excel?
Post by: Jim Jensen on January 25, 2011, 09:57:58 AM
You don't need a utility to get the list to excel. Just use reports. Use the search facility for forms, specify the client, select what fields you want from the app and then send it to Excel instead of a report.
Title: Re: Export Vehicle schedule to excel?
Post by: GeorgeW on January 25, 2011, 10:04:41 AM
Our users do this with reports like the others have said. You can do this for any schedule...vehicle list, drivers, inland marine, etc.
Title: Re: Export Vehicle schedule to excel?
Post by: Judy Means on January 25, 2011, 11:40:37 AM
Thanks all.  I played with the form/excel yesterday, to see how it would work.  I'm just not seeing how Chartis wants it.  I've asked for a format or sample so I can try to create from that then.  Otherwise...right now I've got one very, very long line. 


Judy