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 users who worked with this files. If you need information abut the files within WebCat you can ask for modification date or something else with [listfiles]. I suggest moving the files into a different folder anyway, it will make all things possible you will invent after this... ;-) ---------- If you want to develop a sophisticated system which is better manageable within WebCat and on finder level (i.e. AppleScript) you can include necessary information in the filename and store full filenames and extracted information within a database.Example (rough description):Use login names with fixed length. Add username, date and time to the filenames as prefix once they were opened and move the files into a different 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 the cart name because you should not exceed 32 characters. I did not use standard [date] and [time] because the separators produce longer filenames... Please check if cart numbers can grow longer than 15 digits, I don't know 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 a database you get all parts of the name NMR199804301302431234567890 with [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.com Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++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 users who worked with this files. If you need information abut the files within WebCat you can ask for modification date or something else with
[listfiles]. I suggest moving the files into a different folder anyway, it will make all things possible you will invent after this... ;-) ---------- If you want to develop a sophisticated system which is better manageable within WebCat and on finder level (i.e. AppleScript) you can include necessary information in the filename and store full filenames and extracted information within a database.Example (rough description):Use login names with fixed length. Add username, date and time to the filenames as prefix once they were opened and move the files into a different 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 the cart name because you should not exceed 32 characters. I did not use standard
[date] and
[time] because the separators produce longer filenames... Please check if cart numbers can grow longer than 15 digits, I don't know 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 a database you get all parts of the name NMR199804301302431234567890 with
[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.com Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++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:
WebStar Questions ... (2000)
How to find duplicates - With code samples (2000)
Multicolumn table layout (was Variable Math) (1998)
Popup Menu Options (1998)
PR: WebCatalog Affiliates Program Announced -- Share the (2000)
WebCat2b12 - nesting [tags] (1997)
CommandSecurity? (1997)
contextual shownext (1998)
wrong authentication (1998)
WebCatalog NT beta 18 problem (1997)
WC 2.0 frames feature (1997)
textarea input (2002)
Credit Card not accepted (1998)
WebCatalog can't find database (1997)
Have no fear of WebCatalog Builder..... (2000)
Date search and sendmail (1997)
retain raw [cart] submitted value (2004)
UPS uber integration (2007)
[OT] 'Email this story to a friend' (2003)
auto enter dates (1998)