Export & Clean UP


K

Kathryn WOJ

I have exported the retail database to .csv file. Opened in Excel and I am
cleaning up Deptmements - Categories & Suppliers.

Couple of things: 1) The Dept/Cat/Sup export as ID codes - rather than text
- Will I need to create a text equivalent for each & import the text names
for each?
2) Can I delete all items & then reimport cleanly without losing sales &
report data?

I will be using QSImport tool to reimport the cleaned up data

Kathryn
Wings Of Joy
 
Ad

Advertisements

A

Akber Alwani

hi Kathey,
if the purpose of the export to clean up the department, categories so no
need the hug work just update the Item table with following query
update item set departmentid=null,categoryid=null,supplierid=null -- this
will update for all items for department and categories and supplier to empty

Don't delete the items as it will create the descripencieis in your reports
and data will be reduandant then.
 
Ad

Advertisements

K

Kathryn WOJ

Thanks - that makes sense - I will run a test db with query - clean up &
re-import
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clean-up - Condense 1
Cleaning up Accounts 3
Clean up payee list ? 2
Cleaning up payee list 2
Cleaning up a Quicken file 6
Clean-up or Start Over? 0
File Menu Clean Up 2
Cleaning Up Transaction Registers 5

Top