wwwcad Posted October 25, 2010 Share Posted October 25, 2010 I'm making right now a CSV import script using the WHMCS API: Currently is working ok for the addclient Function and i will continue with the addorder function for domains and hostings. But 'm having a problem, the csv have the hosting plans with names not with product ids like the api function needs, it would not be a problem with a GetProducts function in the API but it doesnt exist. Any way to get the product id by name something like: getProductDetails($product_name); Regards 0 Quote Link to comment Share on other sites More sharing options...
A.Zan Posted November 6, 2010 Share Posted November 6, 2010 Did you figured out how to fix that ? 0 Quote Link to comment Share on other sites More sharing options...
kittiwatm Posted November 8, 2010 Share Posted November 8, 2010 Will be interested too as we'll be importing from an old custom billing system to WHMCS soon. Thanks. 0 Quote Link to comment Share on other sites More sharing options...
timgws Posted November 10, 2010 Share Posted November 10, 2010 wwwcad: you can get the product id of a product name w/ a quick SSL query: ie: <?php include("configuration.php"); include("includes/functions.php"); $SQL = "SELECT `id`,`name` FROM `tblproducts` WHERE `name` like '%vps-1%'"; $res = mysql_query($SQL); $row = mysql_fetch_assoc($res) $productid = $row['id']; Hope this helps you at all? 0 Quote Link to comment Share on other sites More sharing options...
wwwcad Posted November 23, 2010 Author Share Posted November 23, 2010 The module is ready. I have been using it to import sucessfully from Nicline, Directi and WSP. People who wants to get it PM me. Regards 0 Quote Link to comment Share on other sites More sharing options...
buliwyfa Posted November 29, 2010 Share Posted November 29, 2010 wwwcad, not sure why but i cannot PM anyone on the forum. Could you PM me anbout the nicline mod? Gracias 0 Quote Link to comment Share on other sites More sharing options...
austinflowers Posted December 8, 2010 Share Posted December 8, 2010 (edited) great........... I want this information too, but can't PM anyone ! --- Edited December 8, 2010 by austinflowers 0 Quote Link to comment Share on other sites More sharing options...
sgrayban Posted December 10, 2010 Share Posted December 10, 2010 PM doesn't work for new people here -- I think you need to have posted 10 times or something like that. 0 Quote Link to comment Share on other sites More sharing options...
alinford Posted January 11, 2011 Share Posted January 11, 2011 I am also after a CSV import script. I sent a PM, but have not heard back. 0 Quote Link to comment Share on other sites More sharing options...
lynchpat Posted January 23, 2011 Share Posted January 23, 2011 Same here. I'm unable to PM. This script would be a great help to me. Any chance I could get it as well? Thanks 0 Quote Link to comment Share on other sites More sharing options...
wwwcad Posted February 22, 2011 Author Share Posted February 22, 2011 Sorry about my late response. I didn't receive any notification of the post. Here is a Link to the Blog Post where you can download the module for free: http://dev.imaginacolombia.com/home/item/csv-import-and-update-script-for-whmcs'>http://dev.imaginacolombia.com/home/item/csv-import-and-update-script-for-whmcs More info and add-ons: http://dev.imaginacolombia.com 0 Quote Link to comment Share on other sites More sharing options...
metalcut Posted March 7, 2011 Share Posted March 7, 2011 Hi, I'm having trouble getting this module to work, I've copied it into billing/modules/admin and I have also changed the API username and password in the importcsv.php file. When I go into Addon Modules and then importcsv it just gives me a blank screen with no settings to configure. Maybe I'm doing something wrong, any help would be appreciated. Thanks Tinus 0 Quote Link to comment Share on other sites More sharing options...
wolfcreek Posted March 22, 2011 Share Posted March 22, 2011 i am getting a blank page as well no place to enter info. anyone else get this figured out? 0 Quote Link to comment Share on other sites More sharing options...
wwwcad Posted March 31, 2011 Author Share Posted March 31, 2011 I just solved some problems with a blank page in the first Step of the Wizard. Download: http://dev.imaginacolombia.com/home/item/csv-import-and-update-script-for-whmcs Let me know if it's working on your end. Regards 0 Quote Link to comment Share on other sites More sharing options...
Jalpari Posted April 6, 2011 Share Posted April 6, 2011 I am also learned about one of great feature, It also permits you to include an empty field at the beginning of each row, which is usually an auto increment integer primary key. 0 Quote Link to comment Share on other sites More sharing options...
cape2211 Posted April 7, 2011 Share Posted April 7, 2011 When I try to access importcsv from Modules I get the message Start Again When clicking on this link the page reloads and keeps showing Start Over. Ive checked the url and user name and password are correct - any ideas? 0 Quote Link to comment Share on other sites More sharing options...
jljubich Posted June 1, 2011 Share Posted June 1, 2011 I get "Error opening CSV file." error while trying opening example.csv. Could you please help me? Thanks, Jorge.- 0 Quote Link to comment Share on other sites More sharing options...
egfransen Posted November 17, 2011 Share Posted November 17, 2011 Having this problem.. When I try to access importcsv from Modules I get the message Start Again When clicking on this link the page reloads and keeps showing Start Over. Ive checked the url and user name and password are correct - any ideas? 0 Quote Link to comment Share on other sites More sharing options...
wolvyreen Posted November 18, 2011 Share Posted November 18, 2011 Is there a way to import invoice history in this way or is it only able to import client data? 0 Quote Link to comment Share on other sites More sharing options...
shotgun Posted November 25, 2011 Share Posted November 25, 2011 Hi, how can this be used to import domains ? Ineed to import approx 500 domains and it would be great if this can do it. 0 Quote Link to comment Share on other sites More sharing options...
Chaoswebhosting Posted January 21, 2012 Share Posted January 21, 2012 your website is not allowing the file to be DL. Its redirecting back to the index page. would love to try out this addon! 0 Quote Link to comment Share on other sites More sharing options...
netbone Posted May 20, 2012 Share Posted May 20, 2012 Script did not work on 5.0 0 Quote Link to comment Share on other sites More sharing options...
succeed.net Posted May 22, 2012 Share Posted May 22, 2012 If your looking for csv Import I would check with Konrad at Modules Garden. He is currently working on putting one together. http://www.modulesgarden.com/ 0 Quote Link to comment Share on other sites More sharing options...
lfrauseo Posted July 14, 2012 Share Posted July 14, 2012 The download link not working 0 Quote Link to comment Share on other sites More sharing options...
lfrauseo Posted July 14, 2012 Share Posted July 14, 2012 this link not working 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.