sql-ledger-users

[SL] New start (is the following method save ?)

[Luc v. S. <lu...@co...>]

Hello Sql-ledgerers,

I have copied the database of a environment where I need to start all 
over again (after 3 months). But I want to keep some information (like 
parts, customers suppliers, ledger etc)

I have experimented a bit and I think the following works:

-*Copy database*
-*Delete the content of all the of the following tables: *acc_trans, ap, 
ar, assembly, audittrail, business, dpt_trans, exchangerate, 
exchangerate, gifi (Does not apply in my country), gl, inventory, 
invoice, JCitems, oe, orderitems, partstax ( I will need to redo this 
because of mistakes), Status, Yearend

-*The following tables I Kept intact:* Chart, customer,customertax, 
defaults ( I know i need t alter a few things there when I will start), 
department, employee, language, makemodel, parts, partscustomer, 
partsgroup, pricegroup, project(was empty), recurring (was empty), 
Recurringemail (was empty), Recurringeprint (was empty), shipto (was 
empty),  sic (was empty), tax, translation, vendor, vendortax, warehouse,


 From this I want start all over again (not so much need to be entered),

    * Orderentries,
    * salesbookings
    * financialbookings etc


I have been playing around a bit and it seems it will work, can anybody 
comment on this exercise before I start putting in my orders, sales, 
bookings etcetera. It is allways very painfull to find out you have done 
things wrong

Tanks in advance

Luc

Re: [SL] New start (is the following method save ?)

[Luc v. S. <lu...@co...>]

Can anybody please review if this a good way to restart with booking in 
sql-ledger?.

Luc van Stappershoef wrote:
> Hello Sql-ledgerers,
>
> I have copied the database of a environment where I need to start all 
> over again (after 3 months). But I want to keep some information (like 
> parts, customers suppliers, ledger etc)
>
> I have experimented a bit and I think the following works:
>
> -*Copy database*
> -*Delete the content of all the of the following tables: *acc_trans, ap, 
> ar, assembly, audittrail, business, dpt_trans, exchangerate, 
> exchangerate, gifi (Does not apply in my country), gl, inventory, 
> invoice, JCitems, oe, orderitems, partstax ( I will need to redo this 
> because of mistakes), Status, Yearend
>
> -*The following tables I Kept intact:* Chart, customer,customertax, 
> defaults ( I know i need t alter a few things there when I will start), 
> department, employee, language, makemodel, parts, partscustomer, 
> partsgroup, pricegroup, project(was empty), recurring (was empty), 
> Recurringemail (was empty), Recurringeprint (was empty), shipto (was 
> empty),  sic (was empty), tax, translation, vendor, vendortax, warehouse,
>
>
>  From this I want start all over again (not so much need to be entered),
>
>     * Orderentries,
>     * salesbookings
>     * financialbookings etc
>
>
> I have been playing around a bit and it seems it will work, can anybody 
> comment on this exercise before I start putting in my orders, sales, 
> bookings etcetera. It is allways very painfull to find out you have done 
> things wrong
>
> Tanks in advance
>
> Luc
>
>
>
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>
>   

Re: [SL] New start (is the following method save ?)

[Ashley J G. <sql...@pu...>]

On Friday 26 January 2007 04:30, Luc van Stappershoef wrote:
> Can anybody please review if this a good way to restart with booking in
> sql-ledger?.
>
> Luc van Stappershoef wrote:
> > Hello Sql-ledgerers,
> >
> > I have copied the database of a environment where I need to start all
> > over again (after 3 months). But I want to keep some information (like
> > parts, customers suppliers, ledger etc)
> >
> > <<snip>>
> >
> > It is allways very painfull to find out you have done
> > things wrong

We can't really tell you if what you suggest is remotely sane because you 
haven't told us what's wrong. Throwing away then re-entering a heap of data 
sounds like a very silly thing to do if we don't know the context.

What is wrong with your existing data? Perhaps it can be fixed relatively 
easily rather than going through hours of re-entry.

-- 
Regards,
	Ashley J Gittins
	web: 	http://www.purple.dropbear.id.au
	jabber: agi...@pu...

Re: [SL] New start (is the following method save ?)

[R P. <arc...@mt...>]

Hello Luc

I have done this type of thing with previous SQL-ledger versions but I have=
n't looked into the database structure for a year and a half.
When i needed to correct a large number of COGS out of order problems I did=
 the following....
=2Dmade a copy of the dataset
=2Dcleaned the orders, invoices and quotes from the copy, by truncating (re=
moving the data from) some of the tables
=2D used a perl script to copy a date range of orders and invoices from the=
 original database to the copy in chronological order.

Can you describe what you want to do in detail ?

=46rom your post I understand that you want to keep:
Parts, Customers, Vendors, Chart of accounts

Is there anything else you need to keep ?

You want to  truncate the partstax table ?... this would force you to edit =
every part to reconfigure it's tax settings.=20
Are all the parts configured wrong for tax ?
Could you keep the partstax table intact and edit the few parts with errors=
 ?


Cheers,
Roy




On Thursday 25 January 2007 12:30 pm, Luc van Stappershoef wrote:
> Can anybody please review if this a good way to restart with booking in=20
> sql-ledger?.
>=20
> Luc van Stappershoef wrote:
> > Hello Sql-ledgerers,
> >
> > I have copied the database of a environment where I need to start all=20
> > over again (after 3 months). But I want to keep some information (like=
=20
> > parts, customers suppliers, ledger etc)
> >
> > I have experimented a bit and I think the following works:
> >
> > -*Copy database*
> > -*Delete the content of all the of the following tables: *acc_trans, ap=
,=20
> > ar, assembly, audittrail, business, dpt_trans, exchangerate,=20
> > exchangerate, gifi (Does not apply in my country), gl, inventory,=20
> > invoice, JCitems, oe, orderitems, partstax ( I will need to redo this=20
> > because of mistakes), Status, Yearend
> >
> > -*The following tables I Kept intact:* Chart, customer,customertax,=20
> > defaults ( I know i need t alter a few things there when I will start),=
=20
> > department, employee, language, makemodel, parts, partscustomer,=20
> > partsgroup, pricegroup, project(was empty), recurring (was empty),=20
> > Recurringemail (was empty), Recurringeprint (was empty), shipto (was=20
> > empty),  sic (was empty), tax, translation, vendor, vendortax, warehous=
e,
> >
> >
> >  From this I want start all over again (not so much need to be entered),
> >
> >     * Orderentries,
> >     * salesbookings
> >     * financialbookings etc
> >
> >
> > I have been playing around a bit and it seems it will work, can anybody=
=20
> > comment on this exercise before I start putting in my orders, sales,=20
> > bookings etcetera. It is allways very painfull to find out you have don=
e=20
> > things wrong
> >
> > Tanks in advance
> >
> > Luc
> >
> >
> >
> >
> >
> > -----------------------------------------------------------------------=
=2D-
> > Take Surveys. Earn Cash. Influence the Future of IT
> > Join SourceForge.net's Techsay panel and you'll get the chance to share=
 your
> > opinions on IT & business topics through brief surveys - and earn cash
> > http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=
=3DDEVDEV
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> >
> >
> >  =20
>=20
>=20
>=20
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share y=
our
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>=20

=2D-=20
Roy W Pennington
Customer Support
Arch Distributors of Canada
Phone: 204.257.8161

Re: [SL] New start (is the following method save ?)

[Luc v. S. <lu...@co...>]

Ashley,

Offcourse you are right I will try and contact off list to discuss what 
is wrong


Luc

Ashley J Gittins wrote:
> On Friday 26 January 2007 04:30, Luc van Stappershoef wrote:
>   
>> Can anybody please review if this a good way to restart with booking in
>> sql-ledger?.
>>
>> Luc van Stappershoef wrote:
>>     
>>> Hello Sql-ledgerers,
>>>
>>> I have copied the database of a environment where I need to start all
>>> over again (after 3 months). But I want to keep some information (like
>>> parts, customers suppliers, ledger etc)
>>>
>>> <<snip>>
>>>
>>> It is allways very painfull to find out you have done
>>> things wrong
>>>       
>
> We can't really tell you if what you suggest is remotely sane because you 
> haven't told us what's wrong. Throwing away then re-entering a heap of data 
> sounds like a very silly thing to do if we don't know the context.
>
> What is wrong with your existing data? Perhaps it can be fixed relatively 
> easily rather than going through hours of re-entry.
>
>   

Re: [SL] New start (is the following method save ?)

[Ashley J G. <sql...@pu...>]

On Saturday 27 January 2007 09:04, Luc van Stappershoef wrote:
> Ashley,
>
> Offcourse you are right I will try and contact off list to discuss what
> is wrong

Luc, no need to take it off list - indeed, I may not be able to help you out 
depending on what the issue is. But it you can let the list know in general 
terms what the problem is then someone (quite likely not me) may have an 
easier fix that they can suggest.

You don't need to disclose any confidential details, since the names and 
figures themselves don't matter, but if you can let us know the nature of the 
problem you have hopefully someone (or several) will be able to help out.

Cheers,
	Ash