Knowledgebase
View categorized listing of all common frequently asked questions.
Video Tutorials (jReviews 2.0)
Learn how to create a Movie & TV Show review website.
Learn how to start customizing the jReviews theme.
Forum
Community forum
Submit a Ticket
Use your client area email to access the ticket system.
Downloads
Guides, modules and more...
CSV Import for Joomla and jReviews
 
Welcome, Guest. Please login or register.
Did you miss your activation email?
November 21, 2008, 01:08:55 PM
21321 Posts in 4865 Topics by 2803 Members
Latest Member: sednasolutions
News: Use your client area email when you sign up to the forum so we can identify you as a trial or licensed user. Otherwise we may not answer your questions.
 
jReviews Support Forum  |  jReviews 1.x  |  Tips & tricks  |  Steps to import content items and custom fields « previous next »
Pages: 1 [2]
Author Topic: Steps to import content items and custom fields  (Read 6561 times)
crystalitc
Full Member
***
Offline Offline

Posts: 92



« Reply #15 on: January 06, 2008, 01:14:31 PM »

Hey Grin it works great!
3500 items imported..... with towns and area in dropdowns.

Now for the next directory.

Regards

glenn
Logged
travisdh
Sr. Member
****
Offline Offline

Posts: 138


WWW
« Reply #16 on: January 06, 2008, 09:54:23 PM »

just a quick question in regards to the component you had made up, (im having a similar thing just with xml support really is the main difference)

I was wondering what sort of a hosting plan your on, and also the size of the files, csv i assume you are uploading and processing through the component. the reason i ask is im going to do a similar thing but im thinking in my head and worrying because the files are pretty big im wondering how much cpu usage i will use, and trying to work out a way of doing it so that i don't get my account suspended lol.

the other option i was thinking was if it uses alot of cpu then maybe i would run it on my own home server but use the web server (hosting) as the database just while it is being uploaded, much slower but at least limited cpu usage. i know there will be some difference as xml takes abit more usage but just after some experiences with your component and how it is all going for you.

cheers - Trav
Logged

Cheers - Trav Hale (Skype Travis.mobile)

crystalitc
Full Member
***
Offline Offline

Posts: 92



« Reply #17 on: January 07, 2008, 04:57:19 AM »

Hi,
Mine does csv files only.
The one file was 3mb and the other was 2mb  and third was about half a meg- no problem at all.

I use hostdime.com - I have a vps server and will move over to my own dedicated one soon.
I have been with them over 4 years now, and have 24/7 support.
I am not punting them. I am also not responsible for anyone wishing to move. Please investigate all options. Do you homework. Cheap is not always best.

I have a xml file whick I am going to convert to csv and upload.

regards
Glenn
Logged
travisdh
Sr. Member
****
Offline Offline

Posts: 138


WWW
« Reply #18 on: January 08, 2008, 01:59:53 AM »

Thats okay, its good to be able to have a chat to other people who are using jReviews and Joomla, and get a little bit of an idea on how it is going for them in terms of Hosting, even just knowing who people are using and how they are happy about them. There are so many hosts out there it is hard to know which are good or bad.

at the moment i am using Inmotion Hosting, which seams alright, but i have to admit my site is still in its infancy with few visitors and not really much content. Out of intrest how many visitors do you get per day to need vps or was that just a personal choice?

Its amazing how many dedicated hosts there are out there as well, i even saw one cheap as, like 29 a month, however that said they charged that for reboots alone lol.

Whats your experience in hosting, as in do you have some experience in dedicated hosting or are you looking the managed dedicated.

----------------------------------

Also just to preface for you, don't worry about being responsible for anyone wishing to move, i ask questions based on personal experiences other people have had. and each person is responsible for their own actions, its just nice to get other peoples experiences.
Logged

Cheers - Trav Hale (Skype Travis.mobile)

jiwaniec
Newbie
*
Offline Offline

Posts: 11


« Reply #19 on: January 27, 2008, 08:04:06 PM »

This is a terrific thread.  Great work.  I'm working with a test site that we created using SOBI2 business directory and the problem is twofold, first importing is complicated but not insurmountable using php scripting . . . stilll a bit tedious.  Second and most important is that we are limited to jReviewsEverywhere and therefore we seem to be limited with respect to the features that are native in jReviews. 
So, I'm wondering what component are you using to hold your data.  Also, who did forum members use to do import of data. I'd be interested to compare cost of using an outside contractor.
Many thanks for your kind attention to this.
John
Logged
travisdh
Sr. Member
****
Offline Offline

Posts: 138


WWW
« Reply #20 on: February 01, 2008, 02:01:12 AM »

i cant really comment on using outside contractors to import data, but in terms of doing it myself, the easiest way seams to be import your data into excel to transform, i.e work out what columns go to where, and then import as csv through phpmyadmin. That really only works well using jReviews as the way the tables are set out is really smart (well done if your watching lol). Its pretty much as easy as giving the items you are importing unique itemid's and then using the same item id's to import it into the jReviews table with the custom fields.

In terms of using jReviewsEverywhere, i am going to be having a similar problem as well, i am looking at putting a few businesses in there as well using sobi2. That said sobi2 is a really difficult component in terms of the way the components are set out. There are a few posts on their site about importing data, ones to look out are a new script coming soon to import a csv file into database:

http://www.sigsiu.net/forum/index.php/topic,7229.0.html

And the HowTo document on how to import data:

http://www.sigsiu.net/forum/index.php/topic,1438.0.html

Hope this helps a little bit!
Logged

Cheers - Trav Hale (Skype Travis.mobile)

Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8456


« Reply #21 on: February 01, 2008, 07:34:48 AM »

I am watching, but let me point out that even though *it seems* the jReviews way is the smart way, it's actually only good from a human's ( as apposed to a machine's) perspective because the format is easily readable by people. I am moving towards a similar table design for the fields in a future version that will enable some additional features and large number of fields without unnecessarily making a table bigger and bigger based on the number of custom fields.

Importing then will be more difficult. The good news is I will have to come up with a script to migrate existing data, so I could use that as a starting point to import from CSV.
Logged

Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8456


« Reply #22 on: February 27, 2008, 07:14:24 PM »

Guys, checkout the latest announcement:

http://www.reviewsforjoomla.com/option,com_smf/Itemid,34/topic,3459.msg14159/#msg14159

About CSV Import for Joomla and jReviews

CSV Import allows users to easily create Joomla content items from data stored in spreadsheets and CSV files. When used with jReviews, the powerful review and rating extension that also allows for the creation of more complex structured content items, CSV Import allows for the easy transfer of data from spreadsheets into your jReviews-powered product catalogues, directory listings, contact lists, and more. With or without jReviews, CSV Import is an essential time-saving tool for any Joomla site.
Logged

Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
remek
Jr. Member
**
Offline Offline

Posts: 47


« Reply #23 on: September 26, 2008, 02:10:11 AM »

travisd: Thanks for the detailed post! Smiley
Logged
Pages: 1 [2]
« previous next »
    Jump to: