CatBase Help Desk: Search our Knowledgebase or raise a Support Ticket

Can I import data from a spreadsheet into CatBase?

Yes indeed - you can import data directly from an Excel spreadsheet (.xls or .xlsx). Select the data table that you want to import the spreadsheet into. Expand the Import topic on the left of the win...

1,033

(8)

I get a "Not enough memory" error message when trying to import a file (Mac)

Not enough space in memory Typically this error will occur when you try to import a file that is not in the same format as that selected in your Import Style. For example, perhaps you selected "Ta...

1,071

(4)

How do I link data to Categories in an import file?

Q: When I'm importing data into CatBase, how do I link each record to its category or categories? The short answer ... In each of the data tables in CatBase there is a field called MainCategoryName ...

9,212

(2)

How can I add new fields within an existing Import Style?

Adding additional fields to an existing Import Style Problem: You've set up an Import Style the way you want it. But then the source data changes: a couple of new fields (columns) have been added. Ho...

810

(2)

Importing errors: The field x is mandatory; record # n

Problem: When importing data, you get an error message telling you that a certain field is mandatory Explanation: In every database, certain fields are mandatory: they must be populated (have somet...

808

(4)

Importing errors: The field x must contain a unique entry; record # n

Problem: When importing data, you get an error message telling you that a certain field must contain a unique entry Explanation: In every database, certain fields are designated as requiring a uni...

1,414

(2)

How can I update existing data in my database when importing?

Problem You have data in your database, and you have an import file containing new or modified data that you want to use to update those existing records. For example, new prices. How can you use the...

725

(2)

Suggested knowledgebase articles:

Knowledgebase Importing Data

Articles in this category