Ticket #430 (closed defect: invalid)

Opened 3 years ago

Last modified 2 years ago

Import New rate cards from CSV file doesnt work!!!

Reported by: 4tele Assigned to: areski
Priority: critical Milestone: milestone Version 1.3
Component: Admin UI Version: Branch 1.x
Keywords: cvs import rate card Cc:

Description

When CVS import RateCard?, after parsing and validation of imported data displayed error at blank page: No tariffplan defined!

Attachments

CC_card_import_analyse.php (11.1 kB) - added by 4tele on 03/31/09 14:59:38.
Untitled-1.png (4.1 kB) - added by 4tele on 04/01/09 04:44:10.
Import RateCard? - Step 2
Untitled-2.png (0.9 kB) - added by 4tele on 04/01/09 04:46:34.
Import RateCard? - Error Page after Step 2

Change History

03/31/09 14:59:38 changed by 4tele

  • attachment CC_card_import_analyse.php added.

(follow-up: ↓ 4 ) 04/01/09 03:17:02 changed by stavros

  • status changed from new to closed.
  • resolution set to worksforme.
  • milestone changed from milestone Version 1.4 to milestone Version 1.3.

OK, you sent me on a wild-goose-chase for 10 minutes by indicating milestone 1.4, but the file you uploaded is identical to that in branches/1.3 currently so you must be referring to v1.3.

I'm pretty sure importing cards functions correctly in v1.3.4 (and earlier versions). Did you try creating a tariff-plan (otherwise known as a call-plan) and importing again?

04/01/09 03:18:10 changed by stavros

PS There's no need to upload unmodified source files: we wrote them; we know where to find them.

04/01/09 04:43:03 changed by 4tele

  • status changed from closed to reopened.
  • resolution deleted.

I'm using version 1.3.4, but the file you're really left with the version 1.3.3 without changes.

Here are the screenshots

04/01/09 04:44:10 changed by 4tele

  • attachment Untitled-1.png added.

Import RateCard? - Step 2

04/01/09 04:46:34 changed by 4tele

  • attachment Untitled-2.png added.

Import RateCard? - Error Page after Step 2

(in reply to: ↑ 1 ; follow-up: ↓ 13 ) 04/01/09 04:54:16 changed by stavros

  • status changed from reopened to closed.
  • resolution set to invalid.

I can't reproduce this. Given the error message you provide, I can only refer you to my previous question:

stavros:

Did you try creating a tariff-plan (otherwise known as a call-plan) and importing again?

04/01/09 05:07:01 changed by 4tele

  • status changed from closed to reopened.
  • resolution deleted.

Yes. Change the current, creating a new, but still display this error.

(follow-up: ↓ 7 ) 04/01/09 05:13:05 changed by stavros

I'm grasping at straws here; perhaps you are forgetting to upload the .CSV file again at the confirmation screen?

(in reply to: ↑ 6 ) 04/01/09 05:46:48 changed by 4tele

Replying to stavros:

I'm grasping at straws here; perhaps you are forgetting to upload the .CSV file again at the confirmation screen?

I download CSV file, it was parsed, the screen shows confirmation - are normal. He has more than imports, the impression that more is not transferred to the variable tariffplan. As if mindful of this variable.

04/01/09 06:23:53 changed by stavros

  • status changed from reopened to closed.
  • resolution set to worksforme.

After reading the source it's apparent there's only one way to make this happen: failing to make a valid selection for "Choose the ratecard to import".

For me it works exactly as the documentation describes.

04/01/09 06:26:31 changed by stavros

Perhaps your PHP or SQL logs contain a clue?

(in reply to: ↑ description ) 02/12/10 17:37:57 changed by mfellay

  • status changed from closed to reopened.
  • resolution deleted.

Replying to 4tele:

When CVS import RateCard?, after parsing and validation of imported data displayed error at blank page: No tariffplan defined!

02/12/10 17:42:07 changed by mfellay

I reopened only to share what I found...just for future releases...What worked for me is at the end.

PHP 5.3 is deprecating function split which is used here and here..

$tariffplanval= split('-:-', $tariffplan); if (!is_numeric($tariffplanval[0])){

echo gettext("No tariffplan defined !"); exit();

}

$trunkval= split('-:-', $trunk); if (!is_numeric($trunkval[0])){

echo gettext("No Trunk defined !"); exit();

And what worked for me...

Doing the process using Chrome browser renders the error, but using IE does not and my rates where imported as they should.

Sorry to reopen this but it could be the later issue that was bugging 4tele.

02/12/10 18:38:01 changed by areski

Can you provide a patch for the trunk ? http://www.asterisk2billing.org/cgi-bin/trac.cgi/wiki/Development#ReportingBugs

Yours, /Areski

(in reply to: ↑ 4 ) 03/18/10 21:00:45 changed by ghenry

Replying to stavros:

I can't reproduce this. Given the error message you provide, I can only refer you to my previous question: stavros:

Did you try creating a tariff-plan (otherwise known as a call-plan) and importing again?

I just hit this, but it was due to this setting in /etc/php.ini not being big enough:

; Maximum size of POST data that PHP will accept. post_max_size = 20M

I had it set to 8M, but my ratesheet is 11MB :-)

04/08/10 16:23:50 changed by areski

  • status changed from reopened to closed.
  • resolution set to invalid.