Customer Forums


to post new content in the forum.

Importing

Find out more about importing data into Workbooks here.
Forum Name Replies Created Latest Reply
Updating custom fields on posted invoices
Once an invoice has been set to POSTED you can only edit custom fields on the invoice record.You may want to update custom fields through an import.   In this example I have a custom field on i...
0 9 weeks 5 days ago
by Support
n/a
Importing Campaign Membership information
Using Workbooks import you can add People to Marketing Campaigns and assign a status to them for each of those Campaigns. You can achieve this during the import of new People or can use Update through...
0 25 weeks 1 day ago
by Support
n/a
Importing multi-select values - a tip
If you are importing into a multi-select picklist field - something which contains comma-separated items within a single field - you need to consider how to build the values for that field.   &n...
0 27 weeks 6 days ago
by jkay
n/a
How do i view uploaded pdf files?
 I have uploded pdf fiels and located it under "Note".  But now I am having problem of viewing it.  It is there but inaccessible. No dobble clicking works.  Am I missing ...
1 28 weeks 1 day ago
by smari
28 weeks 1 day ago
by Support
Imported data is disappearing
We are currently evaluating the CRM solution and can't understand why we have imported our database into Workbooks 2 times now only to wake up the next day and login to find it is empty again, can you...
1 29 weeks 5 hours ago
by Anonymous
28 weeks 6 days ago
by Support
Importing updates to Campaign Member Status'
Hi, I'm doing some work on Marketing campaigns and I can see that I can export member data, which led me to the assumption that I could export a large number of members, quickly amend there member st...
1 30 weeks 4 hours ago
by Samantha Jones
30 weeks 2 hours ago
by Support
Importing Invoices
 Hi,   I am trying to import a spreadsheet of invoices, but when the records are uploaded, for some reason workbooks is increasing the invoice number by 2 between each one, so I get INV-1,...
3 37 weeks 2 days ago
by vkspence
36 weeks 6 days ago
by vkspence
Error when importing - Symbol string may not contain '\0'
When you want to import data into Workbooks the data must be in CSV format. Sometimes (especially if you've exported data from Workbooks into CSV format and then edited it using Excel), it's possible ...
0 38 weeks 7 hours ago
by jhardie-matthews
n/a
Using import to bulk update / overwrite records
Here are some examples of how the import facility can be used to bulk update / overwrite records:   Before you start, it is important to understand the role of the Object Reference field.  ...
0 49 weeks 4 days ago
by Support
n/a
Why do I receive the following warning when importing Activities (Tasks & Meetings)? Bad value - invalid date
Why do I receive the following warning when importing Activities (Tasks & Meetings) "Bad value 'dd/mm/yyyy' for 'Start' on 'Activity - Meeting': invalid date"...
2 50 weeks 5 days ago
by Anonymous
50 weeks 4 days ago
by Support
Importing Products
We're running two databases in one account and want the products we've created in our original database to appear in the new database too.  I exported the details to CSV and then imported them. &...
1 1 year 1 week ago
by Anonymous
1 year 6 days ago
by Support
How do I relate/link imported records to existing records?
How do I relate/link imported records to existing records? I want to import activities and link them to existing Cases....
1 1 year 5 weeks ago
by Anonymous
1 year 5 weeks ago
by Support
How should I escape characters when Importing into Workbooks?
Workbooks imports data in comma-separated values (CSV) format.  A variety of options exist to allow you to choose how that CSV data is interpreted. Normally you will not need to be too conc...
0 1 year 7 weeks ago
by jkay
n/a
How do I assign records to users during the import?
How do I assign records to users during the import?...
1 1 year 8 weeks ago
by Anonymous
1 year 8 weeks ago
by Support
How can I import my Apple Mac Address Book into Workbooks?
How can I import my Apple Mac Address Book into Workbooks? I can export the Address Book from my Mac as a file called "Address Book 2011-03-15.abbu", and the data appears to be contained in...
1 1 year 9 weeks ago
by Anonymous
1 year 9 weeks ago
by Support
Importing accented characters - CSV contains accented characters which look wrong in Workbooks
I have some accented characters in my CSV file which I am importing into Workbooks.  However when they arrive in Workbooks they don't look the same. What am I doing wrong?  ...
2 1 year 14 weeks ago
by Anonymous
1 year 13 weeks ago
by jkay
Undo import
I've accepted an import and now realise I shouldn't have.  Can I get rid of the data?...
1 1 year 14 weeks ago
by Anonymous
1 year 14 weeks ago
by Support
Can I concatenate fields in the import?
My CSV has address details in several columns.  Address line 1, 2, 3 and 4.  It also has city and county. Can I concatenate the address lines into a single address?...
2 1 year 15 weeks ago
by Anonymous
1 year 15 weeks ago
by Support
Import option is missing from my menu. How do I add it?
I need to import data but don't have the option to do that in my menu....
1 1 year 17 weeks ago
by Anonymous
1 year 17 weeks ago
by Support