I want to Migrate my whole data from Quotewerks into Zoho CRM, and I have not found any specific information about it, what's the field of Quote exported from Quotewerks?
Should I export all data at once and import to Zoho CRM? or do I need ETL?
Thanks
Best Answer
S
Steve Siggs
said
over 1 year ago
NB: the Document Headers and Document Items are connected via the ID field in the Document Headers table and DocID in the Document Items table.
What data is it that you would like to migrate from QuoteWerks to Zoho? Just your Contacts to then link QW & Zoho? Or would you like to migrate everything - Contacts, Documents and/or Products?
R
Rokhsare
said
over 1 year ago
I want to migrate everything, Contacts, Product and especially all Quotes.
Steve Siggs
said
over 1 year ago
Ref. screenshots attached: Contacts and Products are pretty straightforward...
Contacts: open the Contacts menu -> Setup Contact Manager screen and click "Export Contacts". (See screenshot below.)
Products: open the Products menu -> Setup Product Data Sources screen -> right-click the relevant data source and click "Export".(See screenshot below.)
Documents are a bit trickier and it would probably be easiest opening the "docs.mdb" Access database and copy/pasting the Document Headers and Document Items out of the relevant table into Excel or using SQL Server Management Studio if you're on QuoteWerks Corporate re-hosted.
Just let me know if you'd like any other tips!
Steve Siggs
said
over 1 year ago
Answer
NB: the Document Headers and Document Items are connected via the ID field in the Document Headers table and DocID in the Document Items table.
R
Rokhsare
said
over 1 year ago
Thanks, dear Steve for your great response.
I've one question about exporting contacts from "Contact Manager", can I export it as CSV or XML? and if yes, does it specify those contact that has open Quotes?
R
Rokhsare
said
over 1 year ago
Thanks, dear Steve for your great response.
I've another question, in exporting contacts, is there any option to export contact (First Name and Last Name) separately from companies? or in the exported file is there any field that show the number of open Quotes of each company?
Thanks again.
Steve Siggs
said
over 1 year ago
>> is there any option to export contact (First Name and Last Name) separately from companies? or in the exported file is there any field that show the number of open Quotes of each company? <<
No, nothing like either of those things out of the box.
For the list of Contacts, you'd be looking at creating a report or back in Access / SSMS. For the open Quotes, you could report off of the Documents database and use Filters or Formula to get the counts or again, back to Access / SQL.
Steve Siggs
said
over 1 year ago
>> I've one question about exporting contacts from "Contact Manager", can I export it as CSV or XML? and if yes, does it specify those contact that has open Quotes? <<
They would come out as tab-delimited; no, it would not specify the number of quotes - you'll need reporting or Access / SQL for that.
Rokhsare
Hi everyone,
I want to Migrate my whole data from Quotewerks into Zoho CRM, and I have not found any specific information about it, what's the field of Quote exported from Quotewerks?
Should I export all data at once and import to Zoho CRM? or do I need ETL?
Thanks
NB: the Document Headers and Document Items are connected via the ID field in the Document Headers table and DocID in the Document Items table.
- Oldest First
- Popular
- Newest First
Sorted by Oldest FirstSteve Siggs
What data is it that you would like to migrate from QuoteWerks to Zoho? Just your Contacts to then link QW & Zoho? Or would you like to migrate everything - Contacts, Documents and/or Products?
Rokhsare
I want to migrate everything, Contacts, Product and especially all Quotes.
Steve Siggs
Ref. screenshots attached: Contacts and Products are pretty straightforward...
Contacts: open the Contacts menu -> Setup Contact Manager screen and click "Export Contacts". (See screenshot below.)
Products: open the Products menu -> Setup Product Data Sources screen -> right-click the relevant data source and click "Export". (See screenshot below.)
Documents are a bit trickier and it would probably be easiest opening the "docs.mdb" Access database and copy/pasting the Document Headers and Document Items out of the relevant table into Excel or using SQL Server Management Studio if you're on QuoteWerks Corporate re-hosted.
Just let me know if you'd like any other tips!
Steve Siggs
NB: the Document Headers and Document Items are connected via the ID field in the Document Headers table and DocID in the Document Items table.
Rokhsare
Thanks, dear Steve for your great response.
I've one question about exporting contacts from "Contact Manager", can I export it as CSV or XML? and if yes, does it specify those contact that has open Quotes?
Rokhsare
Thanks, dear Steve for your great response.
I've another question, in exporting contacts, is there any option to export contact (First Name and Last Name) separately from companies? or in the exported file is there any field that show the number of open Quotes of each company?
Thanks again.
Steve Siggs
>> is there any option to export contact (First Name and Last Name) separately from companies? or in the exported file is there any field that show the number of open Quotes of each company? <<
No, nothing like either of those things out of the box.
For the list of Contacts, you'd be looking at creating a report or back in Access / SSMS. For the open Quotes, you could report off of the Documents database and use Filters or Formula to get the counts or again, back to Access / SQL.
Steve Siggs
>> I've one question about exporting contacts from "Contact Manager", can I export it as CSV or XML? and if yes, does it specify those contact that has open Quotes? <<
They would come out as tab-delimited; no, it would not specify the number of quotes - you'll need reporting or Access / SQL for that.
-
Create a full backup
-
SQL Table Relationships?
-
Volusion API service works on one PC but no others
-
How to select copy paste cells just like microsoft excel?
-
Customer Approved Quote but Made a Mistake
-
Save Order as pdf at Conversion Time
-
New computer...
-
Windows 10 1803 Update and Running QuoteWerks SQL off a Linux Share
-
Add Literature as Spearate attachments
-
How to include optional discounts?
See all 147 topics