CSV Import Script

[wwwcad]

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

http://www.imaginacolombia.com

[A.Zan]

Did you figured out how to fix that ?

[kittiwatm]

Will be interested too as we'll be importing from an old custom billing system to WHMCS soon. Thanks.

[timgws]

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?

[wwwcad]

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

--
www.imaginacolombia.com

[buliwyfa]

wwwcad, not sure why but i cannot PM anyone on the forum.

Could you PM me anbout the nicline mod?

Gracias

[austinflowers]

great...........

I want this information too, but can't PM anyone !

---

[sgrayban]

PM doesn't work for new people here -- I think you need to have posted 10 times or something like that.

[ernie]

I too am after a CSV import script, my data is in a FileMaker database so I can manipulate it's export to suit virtually any CSV import script as long as I know the field format/order that is required.

[alinford]

I am also after a CSV import script. I sent a PM, but have not heard back.

[lynchpat]

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

[wwwcad]

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/...ript-for-whmcs

More info and add-ons: http://dev.imaginacolombia.com

--
http://www.imaginacolombia.com

[metalcut]

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

[wolfcreek]

i am getting a blank page as well no place to enter info. anyone else get this figured out?

[wwwcad]

I just solved some problems with a blank page in the first Step of the Wizard.

Download: http://dev.imaginacolombia.com/home/...ript-for-whmcs

Let me know if it's working on your end.

Regards