Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #440

Re: Import File.....

Show all headers | View raw

On Wed, 19 Oct 2011 15:12:05 -0700 (PDT), JayBee wrote:
>  Without deleting the whole product table and re-importing everything
>  (because this would affect the sales records already created) how can
>  I import the new price column and ensure that each price will be
>  matched to the correct record?!  The thing that makes me nervous about
>  this is that the newly imported prices could be mis-matched between
>  records.

I do this frequently.

My solution is to have a dedicated import table. There I do whatever is
needed for comparison - you could match article and price and remove
everything which remained identical. You then may change old prices and
tag them as invalid and import new prices from the import table to the
price list.

And even more important: you may have to add new article IDs.

Thus you shold have at least three tables:

1) an import table
... where all records could be deleted after processing, or could be
kept for an import history

2) an article table

3) a price table

I recommend to keep 2 and 3 separately.

You can automate most of it, where you only have to choose the excel
source file (and even this could be automated).

- Martin

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Find similar

Thread

Import File..... JayBee <Jennifer_Beecroft@hotmail.com> - 2011-10-19 15:12 -0700
  Re: Import File..... yourname@yourisp.com (Your Name) - 2011-10-20 13:21 +1300
  Re: Import File..... cortical <cb@corticaldata.com.au> - 2011-10-20 11:46 +1030
    Re: Import File..... yourname@yourisp.com (Your Name) - 2011-10-20 16:10 +1300
      Re: Import File..... cortical <cb@corticaldata.com.au> - 2011-10-20 22:17 +1030
        Re: Import File..... yourname@yourisp.com (Your Name) - 2011-10-21 09:14 +1300
          Re: Import File..... JayBee <Jennifer_Beecroft@hotmail.com> - 2011-10-24 15:07 -0700
  Re: Import File..... Martin Τrautmann <t-usenet@gmx.net> - 2011-10-20 04:41 +0000

csiph-web