jReviews :: Customer support forum
Home
Products
Support
Demo
Latest News
Testimonials
Contact
Client Area
jReviews en Español
Knowledgebase
View categorized listing of all common frequently asked questions.
Documentation
Overview, installation & setup, template customization.
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...
Beauty Products
she20.com
www.trovaidea.it
Travel and Going Out
www.qviaggi.it
www.qristoranti.it
www.travelshopireland.com
www.bestcruisespot.com
www.playamayanews.com
www.magischenachten.nl
www.travelguides.nl
Arts & Entertainment
www.wirelessbollinger.com
www.reelshowint.com
www.music-reviewer.com
www.musicmouth.co.uk
www.playshakespeare.com
www.filmforward.de
Computers & Technology
www.joomlahostingreviews.com
www.techreviewdb.com
www.classicamiga.com
www.ipodspeakerreviews.com
www.buzzaboutwireless.com
www.eyespots.de
Real Estate
www.neulandlord.com
www.deedquest.com
Cars
www.carz.com.br
Jobs & Companies
www.jobboardreviews.com
Miscellaneous
www.threadreviews.com
www.beermaster.se
www.pharmacyreviewer.com
Affiliate Reviews
www.sistemas-afiliados.com
Extensions we recommend
Jom Comment
iJoomla.com - Pro Extensions
Joomla Backup and Restore Component
JoomlaEquipment Component
Sakic.Net - SEF Advance
JoomSuite Components
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.
Home
Help
Search
Login
Register
jReviews Support Forum
|
jReviews 1.x
|
Tips & tricks
|
Steps to import content items and custom fields
« previous
next »
Pages:
1
[
2
]
Print
Author
Topic: Steps to import content items and custom fields (Read 6561 times)
crystalitc
Full Member
Offline
Posts: 92
Re: Steps to import content items and custom fields
«
Reply #15 on:
January 06, 2008, 01:14:31 PM »
Hey
it works great!
3500 items imported..... with towns and area in dropdowns.
Now for the next directory.
Regards
glenn
Logged
travisdh
Sr. Member
Offline
Posts: 138
Re: Steps to import content items and custom fields
«
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
Posts: 92
Re: Steps to import content items and custom fields
«
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
Posts: 138
Re: Steps to import content items and custom fields
«
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
Posts: 11
Re: Steps to import content items and custom fields
«
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
Posts: 138
Re: Steps to import content items and custom fields
«
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
Posts: 8456
Re: Steps to import content items and custom fields
«
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
Posts: 8456
Re: Steps to import content items and custom fields
«
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
Posts: 47
Re: Steps to import content items and custom fields
«
Reply #23 on:
September 26, 2008, 02:10:11 AM »
travisd: Thanks for the detailed post!
Logged
Pages:
1
[
2
]
Print
« previous
next »
Jump to:
Please select a destination:
-----------------------------
Announcements
-----------------------------
=> Announcements
-----------------------------
General
-----------------------------
=> Pre-sales questions
=> License
=> Site showcase
===> Using jReviewsEverywhere
=> Encoding questions
-----------------------------
Feature requests
-----------------------------
=> Feature requests
-----------------------------
Extensions
-----------------------------
=> CSV Import for Joomla and JReviews
-----------------------------
jReviews en Espaņol
-----------------------------
=> General Espaņol
-----------------------------
jReviews 2.x
-----------------------------
=> Installation and configuration
=> General discussion
=> Everywhere Addon
=> Themes
=> Tips & Tricks
=> Modules
=> SEF and SEO
=> Known conflicts & incompatibilities
=> Bug reports
-----------------------------
jReviews 1.x
-----------------------------
=> Installation and configuration
=> General Discussion
=> Bug reports
===> jReviews 1.2.07
===> jReviews 1.2.08
===> jReviews 1.2.09
=> Tips & tricks
=> Templates
===> Translations
===> Icons & Graphics
===> User Submitted Templates
=> Using SEF Extensions
-----------------------------
jReviews 1.x - jReviewsEverywhere Addon
-----------------------------
=> General Discussion
=> Modules
=> Bug reports
-----------------------------
jReviews 1.x - jReviews+Fireboard/Joomlaboard Addon
-----------------------------
=> General Discussion
===> jReviews + Joomlaboard Old Posts
=> Bug Reports
-----------------------------
jReviews 1.x - jReviews Modules and Hook Components
-----------------------------
=> Modules & bots
=> User Submitted Addons
=> Hook Components
-----------------------------
Freelance board
-----------------------------
=> The freelancer corner
=> jReviews Professionals
-----------------------------
Review Centric Community Building
-----------------------------
=> Requests for reviews
=> Tips for getting users to submit reviews
-----------------------------
Off Topic
-----------------------------
=> J's Lounge
Powered by SMF 1.1.7
|
SMF © 2006-2008, Simple Machines LLC
Joomla Bridge by
JoomlaHacks.com