Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2005
    Posts
    50

    Question Unanswered: Logging imported records?

    I know there are probably many ways to do this. I was hoping people might discuss some different ways this is done.

    As of now, I import new records into my db at irregular times. Each new recorded is time/date stamped, so I have a 'date imported' field.

    Ultimately, it'd be nice to automatically get this info into an exel spreadsheet (shoot, or even a .txt file).

    Thoughts/ideas/methods?

    Thanks much for any feedback.

    edited to add:
    I simply need the info in a more presentable format, rather than having to look at an operational table that contains 15 fields sorted by SKUID.
    Last edited by trunkstar; 01-04-06 at 17:03.
    Who imported me here?

  2. #2
    Join Date
    Jan 2005
    Posts
    50
    Some more details.

    I could easily query the items, sort on the 'date imported' field and export to excel.
    But what I actually need is an idea of how many items are imported during each import.
    Who imported me here?

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Well in that case, attach an "import_id" field to your records relating to an import table containing date of import...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  4. #4
    Join Date
    Jan 2005
    Posts
    50
    Went with something like this and worked great. Thanks for the responses.

    SELECT Count([Desc].SKUID) AS CountOfSKUID, [ShopCartSmall - Desc].[Date Imported]
    FROM [Desc]
    GROUP BY [Desc].[Date Imported]
    HAVING (((Desc].[Date Imported]) Is Not Null))
    ORDER BY [Desc].[Date Imported] DESC;
    Who imported me here?

  5. #5
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Don't use spaces in your field names...


    That said, what happens if you do two imports on the same day?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  6. #6
    Join Date
    Jan 2005
    Posts
    50
    Yeah, I know it's hard to resist saying that (about the spaces).
    Point taken, time and again.

    If there's two imports on the same day, the records added during the second import will get counted and be summed in the total amount of records imported on that date.
    Who imported me here?

  7. #7
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    In that case, sounds like a good plan.

    I would still go the route of creating a table to track import metadata for flexibility and the ever-present "WHOOPS!" factor. If you created a seperate table and stored an import_id, you could roll things back much easier if something goes wrong as well as pull much more detailed information about how and when imports happened.

    But what you have now will work.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •