Joobi

Joomla components

For Bug Report or Feature Request please use the ticket system accessible on the tab Support.
This forum is not monitored by Joobi Team although we might take part in discussion.
The forum is mainly a place for members to share ideas and interact together.

You are not logged in.

Pages: 1

#1 14 Apr 2008 20:34:24

Another Import Hurdle

I have a existing list of 1600 subscribers I've been sending through other software up until now. I am trying to import into Acajoom for two lists.

If I understand I can use a .csv file if the field name and contents are as follows:

Name,email,receiveHTML(1/0),confirmed(1/0)
"John Wade"," This e-mail address is being protected from spambots. You need JavaScript enabled to view it ",1,1

My use of 1 indicates a positive.

I am starting with the import of only 5 records. I receive this error:

l�a�n�i�@�w�i�g�h�t�m�a�n�.�c�a: The email entered is invalid.

jw

#2 14 Apr 2008 20:36:32

kornikopic
Platinum Member

Re: Another Import Hurdle

Hello John,

You have to write your CSV file without the quotes. The comma makes the separation between the different fields
*** Please, read our 

Sorry. You have to be registered to access this content.

before posting. Thank you ***

Best regards,
Jonathan

#3 14 Apr 2008 20:44:11

Re: Another Import Hurdle

Same area with the following:

John Wade, This e-mail address is being protected from spambots. You need JavaScript enabled to view it ,1,1

jw

#4 14 Apr 2008 20:48:50

kornikopic
Platinum Member

Re: Another Import Hurdle

Can you copy a sample of your file ? Please
*** Please, read our 

Sorry. You have to be registered to access this content.

before posting. Thank you ***

Best regards,
Jonathan

#5 14 Apr 2008 20:51:39

Re: Another Import Hurdle

see attached.

jw

#6 14 Apr 2008 20:53:37

Re: Another Import Hurdle

Won't take a .csv file I'll zip
jw 

Sorry. You have to be registered to access this content.

#7 14 Apr 2008 21:13:10

kornikopic
Platinum Member

Re: Another Import Hurdle

Ok, I see.

What text editor do you use to make your csv?
There's invalid characters inside your file, that's the problem.

I advise you to use a simple text editor like Notepad (for Windows), emacs/vi (for GNU/Linux).
*** Please, read our 

Sorry. You have to be registered to access this content.

before posting. Thank you ***

Best regards,
Jonathan

#8 14 Apr 2008 21:17:58

Re: Another Import Hurdle

I have a contact manager named ACT made by Sage. It's been around for years. 

Sorry. You have to be registered to access this content.



From that database, I exported directly as a .csv. Opened in OpenOfficeCalc to put the fields in the order as per instructions, saved and then opened in notepad to find and replace the quotation marks.

jw

#9 14 Apr 2008 23:42:07

Re: Another Import Hurdle

I've found the odd characters but in a programmers text editor. They don't appear elsewhere. The programmers text editor can do a find and replace but not for unidentifiable characters. I messing around for another editor but now luck so far. Any suggestions?

jw

#10 15 Apr 2008 00:15:46

kornikopic
Platinum Member

Re: Another Import Hurdle

Try this software : 

Sorry. You have to be registered to access this content.



Kaboom converts code pages of text files, from shift-jis into UTF-8 and vice versa. It supports Windows, DOS, IBM, ISO, ASCII, ISCII, Macintosh and UNICODE code pages. Kaboom can read and write byte order marks (BOM) and is very useful for everybody who has to deal with text files in foreign code pages. In addition Kaboom has over 50 clipboard filters, for replacement of special chars into character entity references.
*** Please, read our 

Sorry. You have to be registered to access this content.

before posting. Thank you ***

Best regards,
Jonathan

#11 15 Apr 2008 00:47:51

Re: Another Import Hurdle

I'm on it like a dog on a bone.

jw

#12 15 Apr 2008 01:25:03

Re: Another Import Hurdle

I'm on it like a dog on a bone.

jw

#13 15 Apr 2008 01:46:29

Re: Another Import Hurdle

Okay, I choked on the bone. I haven't a clue on how to use the program I downloaded. I took a stab in the dark a few times though. I've never had a problem using data exported as .csv from my contact manager ACT. When you looked at the data, what editor did you use to find the hidden characters. Will it strip them from the file using a find and replace?

jw

#14 15 Apr 2008 02:41:38

Re: Another Import Hurdle

I did it. Here's how.

Open the csv file in open office (calc). Take each column separately and paste it using the unformatted paste into a Thunderbird email. Copy that and paste the column into a new calc sheet. Repeat with each column to be safe, but I just needed it with my email for some reason. Now you should have in this order on your calc page: Name, Email, 1 (or 0), 1 (or 0).

Save it as a csv file.

Close

Open as a note pad and you'll see quotations where you don't want them. You just want the commas. Do a find and replace of the " in the find and leave the 'with' - blank.

Save and then try importing that. It worked for me and all I know anything about is training dogs.

#15 21 Jul 2008 11:58:41

salinawu
New member

Re: Another Import Hurdle

NINGBO BEIXIANG IMPORT AND EXPORT LIMITED COMPANY
TEL:+86-574-87485408
FAX:+86-574-87485408
MOBILE NO:13957875354
WEBSITE:www.kalsen-promotion.com
E-MAIL: This e-mail address is being protected from spambots. You need JavaScript enabled to view it
ADD: Floor28,Huijin Building,No.77,Heyi Road,Ningbo,China
Code: 315000
A professional manufacturer in:office products
                                Plastic pen
                                Metal pen
                                Office mate :calculator,scissors, eraser,glue stick,pencil sharpener,ruler,hole punch,pen stand ,stationery tape ,correction tape ,stamp pad ,book end ,cutting knife,bill counter ,pen bag ,wastebin,stapler,and so on

Pages: 1

Forum Tools