This is good. Is there an easy way to get all 74 of my field names after the SELECT command? I notice that .#DATE * is not an acceptable syntax. I guess I could type them all into a text file for reference and copy & paste them whenever needed, but I thought I'd ask.
Thanks, Hans -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Ramsour Mike Sent: Wednesday, December 17, 2008 3:51 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Weekly imports with date Hans: Something like this could work. PROJECT TEMPORARY weekly_import FROM "master_table" USING col1, col2, col3, .... (Review the PROJECT command in the online help system) LOAD weekly_import FROM source_file AS CSV (or whatever format the source file is in.) INSERT INTO "master_table" * SELECT col1, col2, col3, .... .#DATE FROM weekly_import. This will populate the master table with all the data from your import table and you can include the #DATE system variable as a date stamp for the day that the data was loaded. That should give you some ideas or a good start. Mike Ramsour Authorized R:BASE Developer -----Original Message----- From: Hans Manhave/Jackson-Lloyd [mailto:[email protected]] Sent: Wednesday, December 17, 2008 4:26 PM To: [email protected] Subject: [RBASE-L] - Weekly imports with date What is the best (or easiest) way to import a set of records each week and include a custom date in a field not part of the import set? I have a weekly record set of 75 fields and several thousand records. I am using the LOAD command. Previously I thought I would just DELETE the current data and LOAD the new data. Now I have learned that I need to keep the old set(s) and so it appears to me that if I add a date field in the table then a plain date (12/17/2008, for example) would be sufficient to distinguish each timed import. No need to keep a time signature also. I thought to just add a field at the beginning or end of the table but that would throw off my import because the imported data doesn't have that field. I would like to be able to enter the date at some point of the import process. Something where it asks for the date to be used and then assigns that to all the records that are imported in that batch. That way I can add previous record sets. Also, how do I duplicate a table? I need to test the record sets before I import them. Thanks for any suggestions and pointers! --- Hans Manhave Operations Director Jackson-Lloyd Ins P.O.Box 187 Longview, TX 75606 903-758-6206
