MX CSV Import-Export Forum :: how to: database design

This thread was displayed: 41 times


Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.

For more information about the affected products visit: www.interaktonline.com/Support/

View Threaded Show descending
My Bad
01-27-2007 23:20:55 GMT +2

need help on database design based on specific need.

i have several sales people having their own handheld devices collecting customer info. i need to collect their customers' info into one database through CSV Import. each handheld could export csv files.

the handhelds has a main table: customer table has customer_id as primary key. there are other tables with customer_id as foreign key. each handheld device creates its own customer_id starting from 0 and auto-increments.

each sales person then uploads the files through the website using the CSV Import. i use only one database for this.

problem:

1. how do i avoid duplicated records?

2. the primary key (customer_id) changes upon upload so the related tables' foreign key gets error. how do i keep the handheld table relations intact?

any ideas? thanks.
Back | Reply | Quote | Top
Forums
MX CSV Import-Export 1.8.6
© Adobe Systems Romania. All rights reserved.