[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: ap2 web archive of ap2 legacy products...project..thoughts?




Actually, I ran intot his exact same issue. ONly i was logging magazines. I ended up placing the pertinent data into a spreadsheet and then prininting specific columns to generate the HTML. Every time I add or remove something formt he list, I print a new index.html file. The only caveat is that I need to name the stuff carefully...

Hind-sight is 20-20 though, I'd have been better off using a database so I can see all the pertinent data (descriptions) onthe screen at one time for any given item. A report could then be run to summarize quantity and cost and update values with a querry. (I use M$Access for my databasing and it can be converted to a web enabled dtabase for 'live querry'.) Personally though I like the print-out that generates a single flat HTML document that can be searched and archived by search engines where a standard database can not.

Thankx,
Ed

Sample formula to build HTML list of JPG images of scanned pages from spreadsheet data on Row 11... (Obviously colukmns could be adapted to Fields of a database and make it mor accessible. Col D=is it scanned,Col B=Issue, Col C=page#

=IF(D11<>"Y","Issue "&B11&" Page "&C11&"<BR>","<A Href="&CHAR(34)&"../HCIssue."&TEXT(B11, "00")&"/Page-"&TEXT(C11, "00")&".jpg"&CHAR(34)&">Issue "&B11&" Page "&C11&"</A><BR>")

brad wrote:

i was wondering if there is a program web based or with a www based option
someone would recommend..or some site where some other foo..er i mean 'apple
// guru' ...no i guess i mean fool like myself has managed to wrangle this
beast to some kinda collection/keep track of it all stalemate