Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

Importing Products Records

Sage 50 general help forum - Free help and support for all general issues
Post Reply
Elbonrules
User
User
Posts: 3
Joined: 09 Dec 2008, 08:50

Importing Products Records

Post by Elbonrules » 09 Dec 2008, 09:03

We are currently running Sage Line 50 and a separate dBase Invoicing/Stock Control system importing the invoice data on a daily basis. We are now considering migrating the stock system into Sage but, although the import of Product Records works OK the following problem has arisen. The description of each stock item is an amalgam of 4 fields from the database and I have tried to retain the field size of each of these fieldsby inserting blanks so that the data appears in Sage in nice neat readable columns within the description. The csv file looks OK and the columns are maintained but, when I run the import, Sage appears to apply proportional spacing to the data removing trailing blanks and consequently the apparent column structure is lost making the stock description difficult to read . Is there anyway I can resolve this

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 11 Dec 2008, 11:47

I think trying to put more than one thing into a field is always going to cause problems, how about putting it into separate fields in Sage, e.g. the comments fields.

If you want to see them on the screen, then perhaps, using a field like commodity code which can be displayed on the main screen?

The proportional spacing of the font used is probably applied by windows, I suspect you could use a fixed spaced font but windows might look really weird.

The csv looks okay, only because you use a fixed space font to view it.

Not sure, why they need to line up so, can't really help more.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

Elbonrules
User
User
Posts: 3
Joined: 09 Dec 2008, 08:50

Post by Elbonrules » 12 Dec 2008, 13:11

Thanks Bruce,

I rather expected that I wouldn't be able to import the description while keeping the component fields in the required columns.

Thanks anyway for your efforts

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 16 Dec 2008, 14:00

component fields?

Sounds like a BOM to me, have you looked at BOM's?
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

Elbonrules
User
User
Posts: 3
Joined: 09 Dec 2008, 08:50

Post by Elbonrules » 18 Dec 2008, 11:24

Hi Bruce,

Sorry, but I think I may have misled you by using the word "component". I think the best way of showing my problems is by the following. My company supplies and fits car and truck tyres and the database system (which I wrote) has been successfully used by our staff for over 20 year and , the main feature is how they use the system to respond to customer telephone enquiries. For example, if a customer phones and is looking for a tyre size 195/65x15, my system has a simple query so that when the size is keyed in all the tyres in stock are shown for that size showing the manufacturer, tread pattern, ply and cost and sales prices as

Bridgestone SP200E 91V 100.00 120.00
Toyo Profiler 88W 100.00 120.00
Hankook ST11 91T 100.00 120.00

The problem is that the manufacture can vary from 4 characters up to 14 characters and the other fields also vary. The fact that they are shown in my system in columns make it easy to scan a page of say 20 items but, it is this columnar display that I lose when I import the file into Sage and in the above example the space between Bridgestone and SP is applied to the Toyo tyre which moves Profiler etc several positions to the left making a visual scan very difficult.

As I said previously, I don't expect that there is an easy answer to this but, I appreciate your continued efforts to find one.

Sorry for being so long winded

Cheers

Ian

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 18 Dec 2008, 11:48

If the database system works well (and my assumption is that based on 20 years use it does) then why abandon it?

We could get this other information into other fields but that wont be much help during a lookup.

My only practical suggestion would be to change the order so the most variable data was on the right, at least this way it would be "more lined up"
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

Post Reply

Who is online

Users browsing this forum: Amazon [Bot], Bing [Bot] and 6 guests