<% include("/elements/header.html",'Batch Charge Import') %> Import a CSV file containing customer charges.

<& /elements/form-file_upload.html, 'name' => 'OneTimeChargeImportForm', 'action' => 'process/cust_main-import_charges.cgi', 'num_files' => 1, 'fields' => [ 'agentnum', 'custbatch', 'format' ], 'message' => 'One time charge batch import successful', 'url' => $p."misc/cust_main-import_charges.cgi", 'onsubmit' => "document.OneTimeChargeImportForm.submitButton.disabled=true;", &> <% &ntable("#cccccc", 2) %> <% include('/elements/tr-select-agent.html', #'curr_value' => '', #$agentnum, 'label' => "Agent", 'empty_label' => 'Select agent', ) %> Format % foreach my $format ( keys %formats ) { <% $formats{$format} %> % } <% include( '/elements/file-upload.html', 'field' => 'file', 'label' => 'Filename', ) %>
Simple file format is CSV, with the following field order: custnum, agent_custid, amount, description

Field information:

• custnum: This is the freeside customer number. It may be left blank. If specified, agent_custid must be blank.
• agent_custid: This is the reseller's idea of the customer number or identifier. It may be left blank. If specified, custnum must be blank.
• amount: A numeric value with at most two digits after the decimal point. If amount is negative, a credit will be applied instead.
• description: Text describing the transaction.

Ooma format has the following field order: Description, Description2, Record Type, Customer Number, Billing Phone Number or Zip Code, Bus/Res Indicator, Invoice Date, Invoice Number, Group, Item, Revenue<%$req%>, LineCount, Exempt, ExemptList, State, City, Zipcode, OfferingPK, Offering name<%$req%>, Quantity, AccountNo<%$req%>, Status, Cust Created, PartnerID

<% include('/elements/footer.html') %> <%once> my $req = qq!*!; <%init> die "access denied" unless $FS::CurrentUser::CurrentUser->access_right('Import'); tie my %formats, 'Tie::IxHash', FS::cust_main::Import_Charges->import_formats; my $custbatch = time2str('webimport-%Y/%m/%d-%T'. "-$$-". rand() * 2**32, time);