|
 |
access thread: Transferring data with lookup tables
Message #1 by "Enzo Zaragoza" <enzaux@g...> on Thu, 19 Dec 2002 14:34:13 +0800
|
|
Hi! On my previous post regarding on how would I setup my tables (Transaction & Sender),
you've suggested that I must hve Transaction table's SenderID linked only to the Senders table to
avoid redundancy on the Transction table. Followin your suggestions, it is working
out fine, but my problem is exporting the Transactions to a text file to be imported in the
Central Station, I don't know how would I include the Sender Information since all I
have in the Transaction table is SenderID. What I have in mind is to have also a
Sender table in the Central Station, but my problem is how will the Branch transfer
the Sender Info for new Senders and Updates for those existing senders.
Branches export transactions once a week. Transactions are exported to a text file
and then emailed to the Central Station. The Central Station will import the text file
into the database. Exporting is done programatically and is not using Import/Export provided
by Access.
Suggestion please. Actually it's not the Sender ID only that is linked to Transaction
table, there are other look up tables that are linked on Transaction table which also increments
and updated occasionally.
Thanks,
enzo c",)?
Message #2 by "Carnley, Dave" <dcarnley@a...> on Thu, 19 Dec 2002 09:21:55 -0600
|
|
send multiple files in multiple emails
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Thursday, December 19, 2002 12:34 AM
To: Access
Subject: [access] Transferring data with lookup tables
Hi! On my previous post regarding on how would I setup my tables
(Transaction & Sender),
you've suggested that I must hve Transaction table's SenderID linked only to
the Senders table to
avoid redundancy on the Transction table. Followin your suggestions, it is
working
out fine, but my problem is exporting the Transactions to a text file to be
imported in the
Central Station, I don't know how would I include the Sender Information
since all I
have in the Transaction table is SenderID. What I have in mind is to have
also a
Sender table in the Central Station, but my problem is how will the Branch
transfer
the Sender Info for new Senders and Updates for those existing senders.
Branches export transactions once a week. Transactions are exported
to a text file
and then emailed to the Central Station. The Central Station will import
the text file
into the database. Exporting is done programatically and is not using
Import/Export provided
by Access.
Suggestion please. Actually it's not the Sender ID only that is
linked to Transaction
table, there are other look up tables that are linked on Transaction table
which also increments
and updated occasionally.
Thanks,
enzo c",)(tm)
Message #3 by "Enzo Zaragoza" <enzaux@g...> on Fri, 20 Dec 2002 10:10:07 +0800
|
|
Yup actually that is the way it's gonna be. But the issue here is
what data in the look up tables that I will include in the export? Are there
any way that I can include only those data that were only updated or recently added?
Thanks,
enzo c",)?
http://www.tropangwatakwatak.tk
-----Original Message-----
From: Carnley, Dave [mailto:dcarnley@a...]
Sent: Thursday, December 19, 2002 11:22 PM
To: Access
Subject: [access] RE: Transferring data with lookup tables
send multiple files in multiple emails
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Thursday, December 19, 2002 12:34 AM
To: Access
Subject: [access] Transferring data with lookup tables
Hi! On my previous post regarding on how would I setup my tables
(Transaction & Sender),
you've suggested that I must hve Transaction table's SenderID linked only to
the Senders table to
avoid redundancy on the Transction table. Followin your suggestions, it is
working
out fine, but my problem is exporting the Transactions to a text file to be
imported in the
Central Station, I don't know how would I include the Sender Information
since all I
have in the Transaction table is SenderID. What I have in mind is to have
also a
Sender table in the Central Station, but my problem is how will the Branch
transfer
the Sender Info for new Senders and Updates for those existing senders.
Branches export transactions once a week. Transactions are exported
to a text file
and then emailed to the Central Station. The Central Station will import
the text file
into the database. Exporting is done programatically and is not using
Import/Export provided
by Access.
Suggestion please. Actually it's not the Sender ID only that is
linked to Transaction
table, there are other look up tables that are linked on Transaction table
which also increments
and updated occasionally.
Thanks,
enzo c",)(tm)
Message #4 by "Carnley, Dave" <dcarnley@a...> on Fri, 20 Dec 2002 09:27:46 -0600
|
|
You would have to store a "modified date" for the lookup table records. Are
they very large tables? Most lookups are relatively smaller than the
entities that refer to them...
Oh I just had an idea...you could write a query that only extracted the
lookup values actually used by the data you were exporting. Any value int
he lookup table not used by the new/changed master records would be ignored.
That owuld be pretty easy to do I think.
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Thursday, December 19, 2002 8:10 PM
To: Access
Subject: [access] RE: Transferring data with lookup tables
Yup actually that is the way it's gonna be. But the issue here is
what data in the look up tables that I will include in the export? Are
there
any way that I can include only those data that were only updated or
recently added?
Thanks,
enzo c",)(tm)
http://www.tropangwatakwatak.tk
-----Original Message-----
From: Carnley, Dave [mailto:dcarnley@a...]
Sent: Thursday, December 19, 2002 11:22 PM
To: Access
Subject: [access] RE: Transferring data with lookup tables
send multiple files in multiple emails
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Thursday, December 19, 2002 12:34 AM
To: Access
Subject: [access] Transferring data with lookup tables
Hi! On my previous post regarding on how would I setup my tables
(Transaction & Sender),
you've suggested that I must hve Transaction table's SenderID linked only to
the Senders table to
avoid redundancy on the Transction table. Followin your suggestions, it is
working
out fine, but my problem is exporting the Transactions to a text file to be
imported in the
Central Station, I don't know how would I include the Sender Information
since all I
have in the Transaction table is SenderID. What I have in mind is to have
also a
Sender table in the Central Station, but my problem is how will the Branch
transfer
the Sender Info for new Senders and Updates for those existing senders.
Branches export transactions once a week. Transactions are exported
to a text file
and then emailed to the Central Station. The Central Station will import
the text file
into the database. Exporting is done programatically and is not using
Import/Export provided
by Access.
Suggestion please. Actually it's not the Sender ID only that is
linked to Transaction
table, there are other look up tables that are linked on Transaction table
which also increments
and updated occasionally.
Thanks,
enzo c",)(tm)
Message #5 by "Enzo Zaragoza" <enzaux@g...> on Sat, 21 Dec 2002 09:52:44 +0800
|
|
Great idea! Thanks! I guess that's the way I'll do it. :D
Thanks,
enzo c",)?
-----Original Message-----
From: Carnley, Dave [mailto:dcarnley@a...]
Sent: Friday, December 20, 2002 11:28 PM
To: Access
Subject: [access] RE: Transferring data with lookup tables
You would have to store a "modified date" for the lookup table records. Are
they very large tables? Most lookups are relatively smaller than the
entities that refer to them...
Oh I just had an idea...you could write a query that only extracted the
lookup values actually used by the data you were exporting. Any value int
he lookup table not used by the new/changed master records would be ignored.
That owuld be pretty easy to do I think.
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Thursday, December 19, 2002 8:10 PM
To: Access
Subject: [access] RE: Transferring data with lookup tables
Yup actually that is the way it's gonna be. But the issue here is
what data in the look up tables that I will include in the export? Are
there
any way that I can include only those data that were only updated or
recently added?
Thanks,
enzo c",)(tm)
http://www.tropangwatakwatak.tk
-----Original Message-----
From: Carnley, Dave [mailto:dcarnley@a...]
Sent: Thursday, December 19, 2002 11:22 PM
To: Access
Subject: [access] RE: Transferring data with lookup tables
send multiple files in multiple emails
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Thursday, December 19, 2002 12:34 AM
To: Access
Subject: [access] Transferring data with lookup tables
Hi! On my previous post regarding on how would I setup my tables
(Transaction & Sender),
you've suggested that I must hve Transaction table's SenderID linked only to
the Senders table to
avoid redundancy on the Transction table. Followin your suggestions, it is
working
out fine, but my problem is exporting the Transactions to a text file to be
imported in the
Central Station, I don't know how would I include the Sender Information
since all I
have in the Transaction table is SenderID. What I have in mind is to have
also a
Sender table in the Central Station, but my problem is how will the Branch
transfer
the Sender Info for new Senders and Updates for those existing senders.
Branches export transactions once a week. Transactions are exported
to a text file
and then emailed to the Central Station. The Central Station will import
the text file
into the database. Exporting is done programatically and is not using
Import/Export provided
by Access.
Suggestion please. Actually it's not the Sender ID only that is
linked to Transaction
table, there are other look up tables that are linked on Transaction table
which also increments
and updated occasionally.
Thanks,
enzo c",)(tm)
|
|
|
View Cart
