TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
BACKUP AND RESTORE
TeamDesk have (very unhelpfully) limited the amount of data that can be imported via the Import function and I am told to use the Backup and Restore tool.

I have just found the notes on Backup and Restore and quite frankly they are total JARGON.

Is there a plain-english explanation anywhere please?
And why has it been limited in the first place?

Thanks,
Rebecca
ID
874
Category
User Experience
Author

Rebecca Sell
Date Created
6/9/2015 9:29:15 AM
Date Updated
12/28/2021 12:41:58 PM
Comments
cooper collier  6/9/2015 2:25:44 PM
Are you referring to this document page
http://teamdesk.crmdesk.com/answer.aspx?aid=22386

this section??
'Restore works in opposite direction – it scans the file created by backup, establish the connection between CSV file and its columns and a database table and columns, splits file's records into a batches by 500 records or 20Mb and sends them to server. If some records cannot be inserted or updated (due to validation rules violation, for example), new file is written alongside original data file containing bad record's data and the error description as a last column. Original data file is left intact. You can then analyse error file, fix problems and repeat the process again.""

iF so, I do not think it says that its limited to how much it will restore. It just will restore it in 500 record batches. I know that if you pick too many records in an operation, the browser will timeout on you.

===
the next section that has all the garbly gooky..
I agree its hard to understand just reading it. But if you make a backup and look in the folder. there is a file with your "database_number.tdbackup"

if you open that in a text editor it looks like this

; Auto-generated by tdbackup, do not modify!
Homes.csv -> Homes
Home ALERT -> Home ALERT ;Checkbox
Home Closed -> Home Closed ;Checkbox
Home ALERTNote -> Home ALERTNote ;Multiline
Home Name -> Home Name ;Text
Home Type -> Home Type ;Text
Home Phone -> Home Phone ;Text
Cell Phone -> Cell Phone ;Text
Fax -> Fax ;Text
Home Email -> Home Email ;Email
Contact Notes -> Contact Notes ;Text
Web Site -> Web Site ;Text
Home Street -> Home Street ;Text
Home City -> Home City ;Text
Home State -> Home State ;Text
Home Zip -> Home Zip ;Text
County -> County ;Text
Home Travel Fee -> Home Travel Fee ;Text
Home Provider Name -> Home Provider Name ;Text
Home Owner -> Home Owner ;Text
Home Contracted Rate -> Home Contracted Rate ;Text
Home Current Contract -> Home Current Contract ;Attachment

With that open the jargon makes some sense.
THEY are saying how you can edit this for a restore.
WHICH YOU SHOULD NOT DO unless you really understand it.

so if I wanted my Home Owner to be restored to another field..(Home Name) .. I could change it here...

PERSONALLY...
the have some awesome backup tools on there servers, I cannot imagine ever needing to restore myself.

i do backups because I am a backup crazy person. But I do not expect to have a clean restore from this sort of backup.


If your backing up for development. This is likely not the best option.
You should do it, wont hurt but.

I do the following.

Make a copy of the database with no records. = this saves the design (and saved me a time or two)

Make a development branch and work there.

I then export the data from any tables I am working on, the export takes only a few minutes.

If I need to import data back in.
I make sure I do another export first, so I have any records that users may have made while i was working. Then I import the old data.

Either that or I go in and disable users so nobody can make changes while I am working.



Andrew Winters 6/9/2015 4:57:42 PM
I may be wrong but I believe that the web-based import/export functions in teamdesk are limited because higher volume would tax the network. I am at an basic level myself and the Teamdesk support team walked me through a lot. If you need any help feel free to message me offline and I can explain what I learned step by step. Once you get the hang of it the backup/restore tools are very powerful.
Kirill Bondar  Staff  6/11/2015 9:58:32 AM
We've released TeamDesk Backup and Restore Tools v2.1; tdrestorewin has been extended to be able to operate on a .CSV file directly. In you select .CSV file it will prompt you to select a table to import to and provide correspondence between file and database columns pretty much the same way it's done in TeamDesk import wizard.
Slava Shinderov  Staff  6/16/2015 11:02:26 AM
A simple way of importing .CSV files directly to your database using tdrestorewin:
http://blog.teamdesk.net/2015/06/a-simple-way-of-importing-csv-files-directly-to-your-database.html
Ansar Ahmad 12/28/2021 12:41:58 PM
We export a master table using the Teamdesk backup tool. However, the exported .CSV file is barely readable. How do I work in it or make changes in it?

Basically, I want to fill data in a new filed that we just added to the table. I want to fill data in the old records and then upload it in Teamdesk.

Looking forward to hearing from you!
Feedback
Back to Search Results