Gossamer Forum
Home : Products : DBMan : Discussions :

Modify field definitions and data export

Quote Reply
Modify field definitions and data export
Hi

2 quick questions:

1. Can I modify the db_def so as to extend the form-length without affecting existing data?

2. Is there anyway to generate a CSV export (or similar) or the dbman data?

Thanks in advance

---Mark---
Quote Reply
Re: [markGruden] Modify field definitions and data export In reply to
In Reply To:
1. Can I modify the db_def so as to extend the form-length without affecting existing data?

Do you mean add more fields to an existing DB? Yes, it will affect existing data, but you can just add blank fields to the end of each record. There is a utility in the DBman resources to do that.

In Reply To:
2. Is there anyway to generate a CSV export (or similar) or the dbman data?

Yes. There is a mod to do that. Look for Excel export.
Quote Reply
Re: [oldmoney] Modify field definitions and data export In reply to
Thanks buddy

I was talking about character lenght in an alpha column. specifically I need change the character lenght on a column from 255 characters to 2000 characters.

Will look for the export tool you mentioned.

Cheers

Mark
Quote Reply
Re: [markGruden] Modify field definitions and data export In reply to
Ah, increasing the length of a field has absolutely no impact on existing records. Decreasing the length will have no impact *until* they try to modify their record and get an error message for a field they may not have touched (which could be annoying).
Quote Reply
Re: [oldmoney] Modify field definitions and data export In reply to
Many Thanks :)
Quote Reply
Re: [markGruden] Modify field definitions and data export In reply to
If you are using a text field and wanting it to contain more than 255 characters, you should consider changing the field to be a textarea, if you haven't already.

This would allow for much more data within the field.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/
Quote Reply
Re: [LoisC] Modify field definitions and data export In reply to
Thanks mate. Its already a TA.