Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate - Getting '####' in product descript


networkdad

Recommended Posts

I haven't touched easy populate in some time, but i'd like to start using it again. After modifying the tab-delim file in excel, then re-saving it, in *some* of my product descriptions, i'm coming up with '#################' in place of where my descriptions used to be.

 

Anyone seen this before? I did search around, but was unable to find anyone else that had seen this.

 

If you've seen this...how do i resolve this ?

 

Thanks! ;-)

 

Jason

Link to comment
Share on other sites

Jason;

 

I'm not sure of the solution for your text descriptions, but in Excel if you have a column that you have set to accept input of, say 5 digits and then perform a function that results in an answer that is 6 digits long - the # signs will appear indicating too wide for the column size. This is corrected by double-clicking on the right side border of said column, which then re-sizes the column to accept the new width.

 

My guess is that Excel is saying there's more there than what will fit in the column size it has been told to maintain, so you might try a double-click on that column border.

... if you want to REALLY see something that doesn't set up right out of the box without some tweaking,

try being a Foster Parent!

Link to comment
Share on other sites

Hi

 

We had this problem which is excel related and nothing to do with Easypopulate. Easypopulate is a real life saver.

 

If you view your file in excel, you'll see the columns/cells with XXX. Mark these cells as "number'' or ''currency'' which makes them appear as 'text' and they'll import into your database as you want to see it.

 

Its a bit of a pain but its a workaround.

 

If anyone has a better suggestion, we'd like to know.

Citizen of US Minor Outlying Islands

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...