Database Layout?

We're upgrading our support forum. Replies are currently closed. Please view our Documentation and FAQ using the menu above.

I have an extra field (Customer Invoice Terms) that we have added to out customer record and need to add data to. I would like to be able to take a csv file of customer name and terms and write a SQL query to add the terms from the file. The file is exported from our old quick books system which has 100’s of our customers in it, and we do not want to do this by hand as it will take a few days to accomplish.

1) Is there a database layout that would describe how the ucm_extra and ucm_extra_default tables are defined, and how they relate back to the ucm_customer table?

2) Is there a better way to do this?

Should just be able to hit “Import Customers” up the top and upload your CSV file.

The Import/Export feature in UCM can handle all those Extra Fields.

The forum ‘Custom Development’ is closed to new topics and replies.

creativebooneDatabase Layout?