Skip to content

Instantly share code, notes, and snippets.

@oca159
oca159 / config
Last active December 9, 2025 15:15
ghostty
theme = Catppuccin Mocha
adjust-cell-height = 0%
command = /bin/zsh -c "tmux new -A -s work"
copy-on-select = true
font-family = "BlexMono Nerd Font Mono"
font-size = 16
font-thicken = true
mouse-hide-while-typing = true
macos-non-native-fullscreen=visible-menu
@matthewpoer
matthewpoer / aos_to_sugar_quotes.md
Created September 5, 2014 07:47
Advance Open Sales Quotes to SugarCRM Quotes

Quote Conversion

The following scripts and commentary are a general guide that I created while migrating a customer from SugarCRM Community Edition with the Advanced OpenSales plugin to SugarCRM Professional using the built-in Quotes and Products modules. It's not perfect, and your mileage may very, but I hope it assists someone else as a solid starting point for a similar migration from AOS/SuiteCRM back to SugarCRM Pro.

These scripts ignore the PDF Template and Contract functionality from AOS. These were not relevant to my project, so I have no reason to attempt them.

populate product catalog

insert into product_templates

(id, deleted, date_entered, date_modified, modified_user_id, created_by, type_id, manufacturer_id, category_id, name, mft_part_num, vendor_part_num, date_cost_price, cost_price, discount_price, list_price, cost_usdollar, discount_usdollar, list_usdollar, currency_id, currency, status, tax_class, date_available, website, weight, qty_in_stock, description, support_name, supp