wood burning stoves 2.0*
The moose likes JDBC and the fly likes Data Import thru Excel Spreadsheets Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Data Import thru Excel Spreadsheets" Watch "Data Import thru Excel Spreadsheets" New topic
Author

Data Import thru Excel Spreadsheets

Jacky Luk
Ranch Hand

Joined: Aug 02, 2012
Posts: 590
Hello,
Don't know if this is the right group to ask in.
I have prepared a template for our client to import
data from a POS system to our newly created CRM
The spreadsheet has a new customer worksheet.
There, we have a new sales transaction worksheet.
The customer IDs are to be generated by the system
when they get imported.
So the sales data need to have a Customer ID
along with them so that they know which
customer buys which item.
I can't have an item directly associated with the customer name
because many customers may have the same name

So how can I deal with this situation?
1) I can't directly hard code the customer ID into the customer worksheet
2) The sales data needs to have a customer ID to work with.

Thanks
Jack
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41149
    
  45
If it's important that purchases by the same customer are associated to each other (which would of course be a neat thing to do, and is probably one of the main points of having a CRM), then this needs to be done at the time of the purchase in some way. There are several ways this might be accomplished, but the mechanics depend on the circumstances of the over all system architecture, like which data is available, to whom, at what time, etc. (about all of which we know nothing, so we can't speculate about it).


Ping & DNS - my free Android networking tools app
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Data Import thru Excel Spreadsheets
 
Similar Threads
Importing Data From Custom Objects for POJO & Convert Sheet to Image
[B&S] what's the mean of the "owner" in the data file
Question: static modelling
i need to get my work verified , can u please check & comment ??
Custom Encoding for Worksheet to HTML, Load Excel Files with Drop Down