Jump to content
Sign in to follow this  
KEA Scott

Importing 2 files

Recommended Posts

I am trying to import 2 files into the same table. The first file is a list of line items that are distinguished by an order number field then a line item field. Here is what the file looks like.

9000,1,"Belt","Belt",1,$3.95

9000,2,"Tax","Tax",1,$0.00

9000,3,"Shipping","Shipping",1,$7.60

9001,1,"Shoe","Shoe",1,$16.00

9001,2,"Tax","Tax",1,$0.00

9001,3,"Shipping","Shipping",1,$13.75

9002,1,"trgofoalta","DP-TAB-GODDESS",1,$34.95

9002,2,"ls-minispsin","LS-MINISPSIN",1,$0.90

9002,3,"ls-minispsin","LS-MINISPSIN",1,$0.30

9002,4,"hmugc","HMUGC",1,$3.95

9002,5,"ic3310","IC3310",1,$3.95

9002,6,"Tax","Tax",1,$0.00

9002,7,"Shipping","Shipping",1,$13.15

The second file has the same order number and line item number fields (but not ever line in the line items will be in the option field). The first import works fine. When I try to import the second file matching both the order number and line number it updates nothing. Anyone have an idea. Here is the second data.

9002,2,"ls-minispsin","LS-MINISPSIN","Colors","Silver (+.60)"

9002,3,"ls-minispsin","LS-MINISPSIN","Colors","Yellow"

Share this post


Link to post
Share on other sites

I made a quick database with 6 fields and imported the first file to populate it. Then the 2nd with update matching records checked, and the first 2 fields to match. It worked as I would expect - the

9002,2

and

9002,3

records now hold 'Colors' etc, not '1' and a price.

It seems odd that you are apparently overwriting what look like quantity and price with what looks like text??

Share this post


Link to post
Share on other sites

I am not trying to over write fields all data except for the first 2 in each file go into their own fields. We download files for our orders and the system that we use (yahoo stores) breaks out all the information into different files (I have never had a company do this before.

Share this post


Link to post
Share on other sites

Okay I am sorry I was tired and not looking at the matching fields. I guess that is what I get for being tired.

Thanks for your help

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.