Re: problem (how to mark orders as 'opened')
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17401
interpreted = N
texte = (Natalie)>... I need some mark near the cart number which will say>something like: opened by Natalie (date), so I will open only the>orders which do not have such mark.----------Easiest way to keep files apart:Move the files into different folders and name the folders like userswho worked with this files.If you need information abut the files within WebCat you can ask formodification date or something else with [listfiles].I suggest moving the files into a different folder anyway, it will makeall things possible you will invent after this... ;-)----------If you want to develop a sophisticated system which is better manageablewithin WebCat and on finder level (i.e. AppleScript) you can includenecessary information in the filename and store full filenames andextracted information within a database.Example (rough description):Use login names with fixed length. Add username, date and time to thefilenames as prefix once they were opened and move the files into adifferent folder.Use a naming convention like this one:(user)(date&time)(cart)(user) -> [username] -> three character login-name.(date&time) -> [date %Y%m%d%H%M%S] -> 14 digits for date and time.(cart) -> name of original cart.That makes 17 characters for information and leaves 15 digits for thecart name because you should not exceed 32 characters. I did not usestandard [date] and [time] because the separators produce longerfilenames...Please check if cart numbers can grow longer than 15 digits, I don'tknow that yet. Or generate your own names.For the user NMR and a cart 1234567890 construct the new filename:[MOVEFILE path=/orders/new/1234567890&to=/orders/done/[username][date %Y%m%d%H%M%S]1234567890]You will get for example:NMR199804301302431234567890(which means actually NMR-1998/04/30-13:02:43-1234567890)With this method you have known positions for all information.And if it is time to pull out some information or store everything in adatabase you get all parts of the name NMR199804301302431234567890with [GetChars] within a [ListFiles]-loop:[ListFiles /orders/done/] [Append OrdersDone.db] user=[GetChars start=1&end=3][FileName][/GetChars] &date=[GetChars start=4&end=11][FileName][/GetChars] &time=[GetChars start=12&end=17[FileName][/GetChars] &cart=[GetChars start=18&end=100][FileName][/GetChars] [/Append][/ListFiles]----------Peter__________________________________________Peter Ostry - po@ostry.com - www.ostry.comOstry & Partner - Ostry Internet SolutionsAuhofstrasse 29 A-1130 Vienna Austriafon ++43-1-8777454 fax ++43-1-8777454-21
Associated Messages, from the most recent to the oldest:
(Natalie)>... I need some mark near the cart number which will say>something like: opened by Natalie (date), so I will open only the>orders which do not have such mark.----------Easiest way to keep files apart:Move the files into different folders and name the folders like userswho worked with this files.If you need information abut the files within WebCat you can ask formodification date or something else with
[listfiles].I suggest moving the files into a different folder anyway, it will makeall things possible you will invent after this... ;-)----------If you want to develop a sophisticated system which is better manageablewithin WebCat and on finder level (i.e. AppleScript) you can includenecessary information in the filename and store full filenames andextracted information within a database.Example (rough description):Use login names with fixed length. Add username, date and time to thefilenames as prefix once they were opened and move the files into adifferent folder.Use a naming convention like this one:(user)(date&time)(cart)(user) ->
[username] -> three character login-name.(date&time) -> [date %Y%m%d%H%M%S] -> 14 digits for date and time.(cart) -> name of original cart.That makes 17 characters for information and leaves 15 digits for thecart name because you should not exceed 32 characters. I did not usestandard
[date] and
[time] because the separators produce longerfilenames...Please check if cart numbers can grow longer than 15 digits, I don'tknow that yet. Or generate your own names.For the user NMR and a cart 1234567890 construct the new filename:[MOVEFILE path=/orders/new/1234567890&to=/orders/done/
[username][date %Y%m%d%H%M%S]1234567890]You will get for example:NMR199804301302431234567890(which means actually NMR-1998/04/30-13:02:43-1234567890)With this method you have known positions for all information.And if it is time to pull out some information or store everything in adatabase you get all parts of the name NMR199804301302431234567890with
[getchars] within a
[listfiles]-loop:[ListFiles /orders/done/] [Append OrdersDone.db] user=[GetChars start=1&end=3][FileName][/GetChars] &date=[GetChars start=4&end=11][FileName][/GetChars] &time=[GetChars start=12&end=17[FileName][/GetChars] &cart=[GetChars start=18&end=100][FileName][/GetChars] [/Append][/ListFiles]----------Peter__________________________________________Peter Ostry - po@ostry.com - www.ostry.comOstry & Partner - Ostry Internet SolutionsAuhofstrasse 29 A-1130 Vienna Austriafon ++43-1-8777454 fax ++43-1-8777454-21
Peter Ostry
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Multiple Passwords (1997)
quantity minimum problem (1997)
Search results templates (1996)
Extra equals signs with IE? (More debugging questions...) (1997)
Roundup (2001)
Webcatalog 4.0 - When will we be able to beta test it? (2000)
Linux WebCatalog on Apache w/ Raven SSL (2000)
Re:no [search] with NT (1997)
Reverse WHOIS (2003)
[WebDNA] WebDNA FastCGI (2012)
Re:trouble (1997)
donation (2000)
reservation program (2000)
Math, Multiple Equasions and Show/Hide (1998)
carriage returns in data (1997)
Possible Bug in 2.0b15.acgi (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
AE aware WebCatalog.acgi? (1997)
WebDelivery downloads alias, not original ? (1997)
Intermitent problem using [referrer] (1997)