User Forum
Xequte User Forums
Profile    Active Topics    Forum FAQ    Search this forumSearch
Forum membership is Free!  Click Join to sign-up
Username:
Password:
Save Password
Forgot your Password?

     
Forum Tips
» This forum is for users to discuss their software problems and suggestions for improvement.  Remember that only a tiny percentage of our users experience such problems (To be precise less than 0.7% have ever posted on this forum)
» Include your software version number (as displayed in the About Box)
» Check the FAQ before posting as most common questions have already been answered
» You don't need to also e-mail us separately as our support team will respond to all questions on this forum
 
 All Forums
 Xequte User Forums
 MailList King
 importing from a backup?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Stevester01

USA
1 Posts

Posted - Mar 18 2010 :  14:30:54  Show Profile  Reply
I accidentally deleted a group from my mailing list. So I thought the easiest thing is to re-import the entire list from the backup. BAD IDEA! Did anyone ever try this before? My entire mailing list of 15000+ is messed up.
The columns can't match up from the CSV that it saved on members signed up different numbers of groups, because it separates each group with a comma in the record. Therefore no records can be formatted because they all differ from each other.
Is there a way to fix this and get a clean import?? please help!!

xequte

7504 Posts

Posted - Mar 18 2010 :  15:59:54  Show Profile  Reply
Hi Sylvester

Unfortunately there is an issue in v9.0 - 9.02 whereby CSV fields were not enclosed in quotes, leading to the issue you describe.

Firstly, if you have a full backup of your database files available (and we all back up our data, right ), use that.

If not, see the discussion at:

http://www.xequte.com/forum/topic.asp?TOPIC_ID=3589&SearchTerms=back

Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To: