export

Syndicate content

Before the release of address fields, you may have created several separate fields to capture address information. For example, you may have the following fields:

October 28th, 2013 - 4:10 PM

This would occur if the spreadsheet's or database's CSV (comma separated values) parser is substandard. Excel comes with an excellent CSV parser that knows how to deal with hard returns (aka line breaks, paragraph markers, etc.) that are embedded within the contents of a field.

February 5th, 2009 - 6:02 PM

If you want to export one record at a time, and that record is either a contact or scheduled event, you can create and use a vCard or iCalendar field to send a record to Outlook.

February 5th, 2009 - 6:02 PM

Most QuickBase data will export seamlessly into Microsoft Excel. However, there are some cases when data is lost or displayed with the incorrect formatting.

One example is exporting a 5-digit zip code stored in a text field. When displayed in Excel, any leading zeroes in the zip code are lost. Similar problems can happen when exporting ID numbers, etc.

February 5th, 2009 - 6:02 PM

It is possible and quite easy to import data into QuickBase in such a way that it will update existing records. The key to being able to do this is that you must include the key field so that QuickBase knows exactly what records to update. By default the key field is the "Record ID" field.

You should go through these steps to export then reimport records:

February 5th, 2009 - 6:02 PM

1. I have a time of day field set up as military time but when it exports to Excel it converts to normal time and adds AM/PM.

For example, 18:00 exports as 6:00 PM.

2. I have a duration field that is exporting differently than on the view.

For example, 2:30 exports as 2.5 hours.

February 5th, 2009 - 6:02 PM

Customers are encouraged to maintain their own backups of their applications.  You can back up your application in several ways:

February 5th, 2009 - 6:02 PM

'Append Only' fields that have the "Show the name and date on their own line" setting turned on do not export to Excel correctly because they contain the leading dashes. Data gets cut off because Excel sees the leading dash and reads it as a numeric field which has a limited size.

February 5th, 2009 - 6:02 PM

There are issues in some Microsoft Internet Explorer and Microsoft Office configurations that can cause problems with downloads. We've seen the issue with all types of Microsoft Office documents and with PDF files. The issue can affect all QuickBase downloads including file attachments, exporting to a spreadsheet, and custom pages.

February 5th, 2009 - 6:02 PM

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit