Topic Options
#14301 - 09/03/08 12:53 PM IC database for web presentation
Robert Larson Offline
Adagio Enthusiast

Registered: 01/03/08
Posts: 21
Loc: SF CA
We get requests on a regular basis for a database of products that include fields that the customer will use to make a dynamic product webpage. We have done the work a few times in Excel, but I would prefer to put this data into our IC database so it's easy to generate on the fly.

Some data is standard in IC anyway. Some data would lend itself to the optional fields in Adagio IC, but they are limited in the number you can have.

Requested data fields could be something like the following:

Product Name
Product Alternate Name
Brand Name
Model Number
Product Description (as in catalog description)
Product Feature 1 (2, 3, 4, 5 etc)
Minimum Advertised Price
Dimensions
Can product be shipped as is or not
Warranty

I could go on and on, but you hopefully get the idea.

The major product description could be placed in the additional comments field of Adagio, and I wondered how well it would work to use the Adagio notes feature - despite no category - for other data. I could use a set date or time or combination of those for category (love work-arounds).

I was wondering if other Adagio users faced the same problem and how they went about solving it.

Thanks,
Robert

Top
#14303 - 09/03/08 01:12 PM Re: IC database for web presentation [Re: Robert Larson]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hi Robert,

Since the requirements are going o be different in every circumstance, your idea of use the notepad would work pretty well. I'd actually use a specific UserID for the entry (rather than a date and time) and make sure that the note entry conformed to a rigourous structure so that it would be easy to decode.

I think that adding all these fields to the Item master would make the record unmanageably large (and most of our users do not need these fields).

We are adding the ability to import notes into Adagio Receivables V9.0A and I expect that this feature will be propagated through the other modules "in the fullness of time". (Speaking of AR 9.0A - any features you'd like to see added?)
_________________________
Andrew Bates

Top


Moderator:  Softrak Support 
Who's Online
2 registered (smhoon, 1 invisible), 86 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14482 Topics
70726 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31