Oracle NetSuite

Read Case Study

Project Details

Software Replaced

None Provided

Implementation Partner

Oracle NetSuite

Project Recorded

September 29, 2022

Company Details

Number of Staff

2-10

Locations

HQ Country:

HQ State:

California

Year Founded

1982

Art in Action

Primary Software

Oracle NetSuite

First Tier Industry

Second Tier Industry

Third Tier Industry

As a national nonprofit leader in visual arts curriculum, Art in Action has proudly served over a half million kindergarten through 8th grade students since 1982.

<script> !function(){var analytics=window.analytics=window.analytics||[];if(!analytics.initialize)if(analytics.invoked)window.console&&console.error&&console.error("Segment snippet included twice.");else{analytics.invoked=!0;analytics.methods=["trackSubmit","trackClick","trackLink","trackForm","pageview","identify","reset","group","track","ready","alias","debug","page","once","off","on","addSourceMiddleware","addIntegrationMiddleware","setAnonymousId","addDestinationMiddleware"];analytics.factory=function(e){return function(){var t=Array.prototype.slice.call(arguments);t.unshift(e);analytics.push(t);return analytics}};for(var e=0;e<analytics.methods.length;e++){var key=analytics.methods[e];analytics[key]=analytics.factory(key)}analytics.load=function(key,e){var t=document.createElement("script");t.type="text/javascript";t.async=!0;t.src="https://cdn.segment.com/analytics.js/v1/" + key + "/analytics.min.js";var n=document.getElementsByTagName("script")[0];n.parentNode.insertBefore(t,n);analytics._loadOptions=e};analytics._writeKey="e34MWdq7lp6JpecStM1lIcNuV2Oa0H2L";;analytics.SNIPPET_VERSION="4.15.3"; analytics.load("e34MWdq7lp6JpecStM1lIcNuV2Oa0H2L"); analytics.page(); }}(); </script>   document.addEventListener('DOMContentLoaded', async () => { console.log('Initializing Supabase integration...'); // Find the collection wrapper const collectionWrapper = document.querySelector('.partners-list-wrapper'); if (!collectionWrapper) { console.error('Collection wrapper not found - check your class name: .partners-list-wrapper'); return; } // Find template item const templateItem = collectionWrapper.querySelector('.partner-item'); if (!templateItem) { console.error('Template item not found - check your class name: .partner-item'); return; } // Store original template HTML to check for problematic elements const templateHTML = templateItem.innerHTML; console.log('Template structure loaded'); // Check for potential SVG issues in the template if (templateHTML.includes('<svg')) { console.warn('Template contains SVG elements which may cause issues - will attempt to fix during cloning'); } try { // REPLACE THESE with your actual Supabase details const SUPABASE_URL = 'https://aqstgfeoxjtnixgbuyvs.supabase.co'; const SUPABASE_ANON_KEY = 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6ImFxc3RnZmVveGp0bml4Z2J1eXZzIiwicm9sZSI6ImFub24iLCJpYXQiOjE3NDYwOTQ4MDQsImV4cCI6MjA2MTY3MDgwNH0.hPkIxyUAf07l8xSHbfyj7wEYbxNNX_zOCxL7hjDjdSY'; console.log('Connecting to Supabase...'); // Add connection verification before fetching data const connectionTest = await fetch(`${SUPABASE_URL}/rest/v1/`, { method: 'HEAD', headers: { 'apikey': SUPABASE_ANON_KEY } }).catch(error => { console.error('Connection to Supabase failed:', error); throw new Error('Unable to connect to Supabase. Please check your URL and API key.'); }); if (!connectionTest.ok) { throw new Error(`Connection test failed with status: ${connectionTest.status}`); } console.log('Connection successful, fetching data...'); // Fetch data from partners table const response = await fetch(`${SUPABASE_URL}/rest/v1/partners?select=*`, { headers: { 'apikey': SUPABASE_ANON_KEY, 'Content-Type': 'application/json' } }); if (!response.ok) { throw new Error(`HTTP error! Status: ${response.status}`); } const data = await response.json(); console.log(`Retrieved ${data.length} partners from Supabase`); // Remove existing items except the template const existingItems = collectionWrapper.querySelectorAll('.partner-item'); for (let i = 1; i < existingItems.length; i++) { collectionWrapper.removeChild(existingItems[i]); } // Prevent ID duplication in a safer way - remove all IDs from template first // and use classes instead which are designed for repeating elements let hasClassesForAllElements = true; const elementsWithIdsInTemplate = templateItem.querySelectorAll('[id]'); // Check if we have backup classes for all elements with IDs elementsWithIdsInTemplate.forEach(element => { if (element.classList.length === 0) { hasClassesForAllElements = false; console.warn(`Element with ID ${element.id} has no classes - this might cause selection issues`); } }); if (!hasClassesForAllElements) { console.warn('Some elements have IDs but no classes - consider adding classes to all elements in your Webflow design'); } // Create partners data.forEach((record, index) => { // Deep clone the template const newItem = templateItem.cloneNode(true); // Fix duplicate IDs by removing them or making them unique const elementsWithIds = newItem.querySelectorAll('[id]'); elementsWithIds.forEach(element => { // Option 1: Remove IDs completely (preferred for Webflow CMS items) element.removeAttribute('id'); // Option 2 (alternative): Make IDs unique // const originalId = element.id; // const newId = `${originalId}-${index}-${record.id || Date.now()}`; // element.id = newId; }); // Fix SVG issues const svgElements = newItem.querySelectorAll('svg'); svgElements.forEach(svg => { // Fix missing viewBox if (!svg.hasAttribute('viewBox')) { const width = svg.getAttribute('width') || '24'; const height = svg.getAttribute('height') || '24'; svg.setAttribute('viewBox', `0 0 ${width} ${height}`); } // Ensure width and height are set if (!svg.hasAttribute('width')) svg.setAttribute('width', '24'); if (!svg.hasAttribute('height')) svg.setAttribute('height', '24'); // Convert percentage dimensions to pixels if needed const width = svg.getAttribute('width'); const height = svg.getAttribute('height'); if (width && width.includes('%')) { svg.setAttribute('width', '24'); } if (height && height.includes('%')) { svg.setAttribute('height', '24'); } }); // Add data attribute for reference newItem.setAttribute('data-supabase-id', record.id || index); // Update content using class selectors (more reliable than IDs in Webflow) // Company name const nameElement = newItem.querySelector('.company-name'); if (nameElement && record.company_name) { nameElement.textContent = record.company_name; } // Description const descElement = newItem.querySelector('.company-description'); if (descElement && record.description) { descElement.textContent = record.description; } // Logo const logoElement = newItem.querySelector('.company-logo'); if (logoElement && record.logo_url) { logoElement.src = record.logo_url; logoElement.alt = record.company_name + ' logo'; } // Make sure the cloned item is visible newItem.style.display = ''; // Add to collection collectionWrapper.appendChild(newItem); console.log(`Added partner: ${record.company_name || 'Unnamed partner'}`); }); // Hide the original template templateItem.style.display = 'none'; console.log('Original template hidden - integration complete'); } catch (error) { console.error('Supabase integration error:', error); // Show user-friendly error message const errorElement = document.createElement('div'); errorElement.className = 'error-message'; errorElement.textContent = 'Unable to load partners. Please try again later.'; errorElement.style.color = 'red'; errorElement.style.padding = '20px'; collectionWrapper.appendChild(errorElement); // Log detailed error for debugging console.error({ message: error.message, stack: error.stack, time: new Date().toISOString() }); } });  </body></html>