Jump to content
Sign in to follow this  
silverdolphin

Easy Populate Warning

Recommended Posts

I have been having a heck of a time over the past three months trying to find out why every time I use EP with a certain client site, it creates duplicate records of many items. I finally cracked the problem and would like to warn other EP users.

 

The problem is not actually with EP, rather the spreadsheet program (specifically Excel in this case, but likely applicable to other packages). For some unexplained reason, Excel strips the leading zeroes off of the model number, and will not return them when you set the field to text. Then when you save, it saves the new number (missing the leading zeroes) as the model, and EP interprets this as a new product (and of course you restore from a backup because the database is all screwed up now, and never realize why EP is doing this).

 

So my recommendation is to make sure you do not use leading zeroes in a model number, or ensure that you use one non-numeric character in the model number (a text character gets around the dropping leading zeroes).

 

Now the fun part is manually replacing all the ISBN numbers in the model number field with something else, to remove to ones with leading zeroes. ARGH! :angry:

Share this post


Link to post
Share on other sites

You can use leading zeros. You havee to format the field where you are using the zeros to a custom perameter and then type in as many zeros as you want for that feild. for instance. If your ISBN# is 0002254445 you need to tell excel in your custom format that you want that feild to be shown with 10 characters no matter if they are numerical or not by just typin gin ten zeros in the format box. Excel will then leave all the leading zeros there. Make sense. I hope so. I am in a hurry :-)

 

Otherwise excel reads it as a number and will drop the leading zeros and jsut read it as 2,254,445.

 

Of course, you understand that any ISBNs ending in "x" will not have this problem and you should not have to adjust the cell format for that particulat cell. However, you can and it will not make any difference. SO you can format all the cells under one column to make things easier.

Edited by cxm322

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  

×