• eCommerce
  • Social and Community Suite
  • Content Management
  • RSS Extensions
  • VirtueMart Extensions
Follow us on Twitter   Join The Factory on the New Digg  
(0) | Login | Register | Lost Password?
Username: Password:  
Home
Our Products
Joomla 1.7.x  (23) & J!1.6.x
Joomla 1.5.x (28)
Joomla 1.0.x (17)
Factory Club Extensions (7)
Drupal, Elxis, MODx (6)
Windows Gadgets for J! (11)
Free Templates (4)
All Products (92)
Documentation
Tweets
Forum
Contact Us
Terms & Conditions
How to Buy Guide
Customers FAQ's
Updates & Upgrades
About Us
The Factory Demo Server for Joomla Extensions
Money Back Guarantee
Payment Methods for Joomla Extensions
Follow us on Facebook

Latest Tweets

  • Join us at the Joomladay UK!
  • The Factory Extensions Joomla Compatibility Chart
  • Love Factory 2.4 for Joomla 1.7
  • Love Factory - Memberships [VIDEO]
  • Love Factory - Custom Fields Integration [VIDEO]
  • Love Factory - Google Maps Integration [VIDEO]
  • Love Factory - Administrator Guide [VIDEO]
  • Love Factory - Memberships
  • Collection Factory for Joomla 1.6 with CB support
  • Reverse Auction Factory 1.5.9
 
   Home   Help Search Login Register  
The Factory > Forum > eCommerce Factory Suite for Joomla CMS. > Auction Factory > Sample Data - Bulk Import
Pages: 1 [2]
« previous next »
  Print  
Author Topic: Sample Data - Bulk Import  (Read 12934 times)
lopnorth
Newbie
*
Posts: 5


View Profile
Re: Sample Data - Bulk Import
« Reply #15 on: August 07, 2009, 04:36:21 pm »

Thanks for the reply.  I'll check that out.  I'm also wondering about the fact that the sample csv when imported does not generate auction numbers.  shouldn't every auction have a unique auction number?  Thanks.
Logged
abs007
Newbie
*
Posts: 4


View Profile
Re: Sample Data - Bulk Import
« Reply #16 on: January 26, 2010, 05:56:28 pm »

Hi I tried to install the sample auction data but got loads of errors

Line 2 : Unknown user !
Line 3 : Unknown user !
Line 4 : Unknown user !
Line 5 : Unknown user !
Line 6 : Unknown user !
Line 7 : Unknown user !
Line 8 : Unknown user !
Line 9 : Unknown user !
Line 10 : Unknown user !
Line 11 : Unknown user !
Line 12 : Unknown user !
Line 13 : Unknown user !
Line 14 : Unknown user !
Line 15 : Unknown user !
Line 16 : Unknown user !
Line 17 : Unknown user !
Line 18 : Unknown user !
Line 19 : Unknown user !
Line 20 : Unknown user !
Line 21 : Unknown user !

and it gos on until line 42

Not to sure why this is- I have a feeling its got to do with the user 62,63 and 64 which is mentioned near the test auction download samples above.

I tried to add new users but do not have the option


ok no worries I went and uploaded from the front end

works fine thanks
« Last Edit: January 26, 2010, 06:00:52 pm by abs007 » Logged
Factory Staff 02
The Factory Staff
Hero Member
*
Posts: 1912



View Profile
Re: Sample Data - Bulk Import
« Reply #17 on: July 30, 2010, 11:20:24 am »

Importing Reserve Prices

In the current (1.7.2) version the reserved price can not be CSV imported by default.
A tweak is necessary for this.

In the CSV file , reserved prices (if any) will be concatenated to the start price separated by slash
So, start prices will be either
start_price either
start_price|reserve_price
(Ex  25 - for auction with start price  and no reserve price or 25|50  for an auction with start price and reserve price  ).


For importing this the following tweak is necessary in the bids.function.php file in the ImportFromCSV method.

Replace
  $auction->initial_price = floatval($data[6]);

With:
          
 $start_prices = explode("|",$data[6]);
 $auction->initial_price = floatval($start_prices[0]);
 if (isset($start_prices[1])) {
   $auction->reserve_price=floatval($start_prices[1]);
 }

Logged

The Factory's Development Team member.
penny
Newbie
*
Posts: 10


View Profile
Re: Sample Data - Bulk Import
« Reply #18 on: May 18, 2011, 07:27:15 am »

Hi,

I tried to upload CSV via backend but receive error on the date/timezone.

How to get around this?

Logged
hash
The Factory Staff
Hero Member
*
Posts: 1179


The Factory's Development Team member.


View Profile
Re: Sample Data - Bulk Import
« Reply #19 on: May 18, 2011, 03:18:08 pm »

Can you post your CSV file? I've just tested this feature with our sample file and could not replicate those warnings.
Logged

Don't be afraid to ask dumb questions. They're more easily handled than dumb mistakes.
penny
Newbie
*
Posts: 10


View Profile
Re: Sample Data - Bulk Import
« Reply #20 on: May 20, 2011, 10:59:52 am »

hi,

i used this file.
Logged
winstonb
Newbie
*
Posts: 6


View Profile
FIGURED OUT: Can't get Bulk Import working at all
« Reply #21 on: November 03, 2011, 05:32:24 am »

Hello. I posted this earlier tonight but after digging the in mysql Database realized the instructions are off a bit on what fields will be entered and their values. It's working now

for the following fields, you must enter a # not a text value at all....
currency = 5   (must be the SAME as the value your currency ID is. this is for CDN)
BIN_price =   0 (you must enter this in the value if you don't have a Buy It Now)
auction_type =   1  (you must enter 1 for Public and 0 for Private)
automatic =   1
payment= 4 (you must find the ID that matches this payment type in the PAYMENT section)

hope this helps. I hope the upload system gets improved, unless again I did it the wrong way.
/////////////////////////////////////

I am frustrated at this point with the import feature for the Bulk Import in Auction Factory and need a solution. I have followed the CSV layout EXACTLY as it's shown here; http://www.thefactory.ro/support/documentation/auction-factory-tutorial---bulk-uploading-auctions-into-your-system.html

But I just can not make it work. What am I doing wrong? I get messages like Currency doens't exist, enter a title and more.

Please please please review what my CSV file is setup as and let me know what I have done wrong as it should be an easy process.

I need this to work asap!

thank you ahead of time. the rest of the software is very good but this part is frustrating (at least for me)

w
« Last Edit: November 03, 2011, 06:02:01 am by winstonb » Logged
Pages: 1 [2]
  Print  
« previous next »
 
Jump to:  

Loading...
Joomla Extension - RSS Factory Manager  Joomla Extension - EBook Factory  Joomla Extension - Briefcase Factory  Joomla Extension - Auctions Factory  Joomla Module - RSS Contextual  Joomla Module - Exchange Factory (Europe / EURO)  Joomla Module - Exchange Factory (Romania/ RON)  Joomla Custom Extensions Development   Free Joomla Extensions  Joomla Extension - RSS Factory Pro (Enhanced Version)  Joomla Virtuemart Payment Plugin - Gecad (EPayment.ro)  Joomla Module - Mosimage / Image Module  Joomla Extension - Reverse Auction Factory (Lowest Bidder Auctions)  Joomla Extension - Article Factory Manager  Joomla Module - Lavalamp Menu  Joomla Module - RSS Image Extractor  Joomla Module - Exchange Factory (Europe / EURO) for Joomla 1.0.15  Joomla Module - Exchange Factory (Romania / RON) for Joomla 1.0.15  Joomla Module - Top Movies (IMDB)   Joomla Module - EBay Latest Auctions  Auction Factory Standalone PHP script