<% include("/elements/header.html",'Batch Package Import') %> Import a file containing package records.

<& /elements/form-file_upload.html, 'name' => 'PackageImportForm', 'action' => 'process/cust_pkg-import.html', 'num_files' => 1, 'fields' => [ 'agentnum', 'pkgbatch', 'format' ], 'message' => 'Package import successful', 'url' => $p."search/cust_pkg.cgi?pkgbatch=$pkgbatch", 'onsubmit' => "document.PackageImportForm.submitButton.disabled=true;" &> <% &ntable("#cccccc", 2) %> <% include( '/elements/tr-select-agent.html', #'curr_value' => '', #$agentnum, 'label' => "Agent", 'empty_label' => 'Select agent', ) %> Format Default Default with agent_custid Account service Account service with agent_custid Phone service Phone service with agent_custid External service External service with agent_custid Location Location with agent_custid Location with agent_custid and agent_pkgid <% include( '/elements/file-upload.html', 'field' => 'file', 'label' => 'Filename', ) %>
Uploaded files can be CSV (comma-separated value) files or Excel spreadsheets. The file should have a .CSV or .XLS extension.

Default format has the following field order: custnum<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire

Default with agent_custid format has the following field order: agent_custid<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire

Account service format has the following field order: custnum<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, username, _password, domsvc

Account service with agent_custid format has the following field order: agent_custid<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, username, _password, domsvc

Phone sevice format has the following field order: custnum<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, countrycode, phonenum, sip_password, pin

Phone service with agent_custid format has the following field order: agent_custid<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, countrycode, phonenum, sip_password, pin

External sevice format has the following field order: custnum<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, id, title

External service with agent_custid format has the following field order: agent_custid<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, id, title

Location format has the following field order: custnum<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, address1<%$req%>, address2, city<%$req%>, state<%$req%>, zip<%$req%>, country<%$req%>

Location with agent_custid format has the following field order: agent_custid<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, address1<%$req%>, address2, city<%$req%>, state<%$req%>, zip<%$req%>, country<%$req%>

Location with agent_custid and agent_pkgid format has the following field order: agent_custid<%$req%>, agent_pkgid, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, address1<%$req%>, address2, city<%$req%>, state<%$req%>, zip<%$req%>, country<%$req%>

<%$req%> Required fields

Field information:

• custnum: This specifies an existing customer by custnum.
• agent_custid: This specifies an existing customer record by agent_custid.
• agent_pkgid: This specifies an existing customer record by agent_custid.
• pkgpart: Package definition. Configuration -> Packages -> Package definitions
• discountnum: Optional discount. Configuration -> Packages -> Discounts
• start_date: Indicates a future start date; do not fill in for active packages
• setup: Indicates setup fee has been charged and package setup on this date
• bill: Next bill date
• last_bill: Last bill date
• susp: Indicates the package is suspended (on the given date).
• adjourn: Indicates a future suspension on this date.
• cancel: Indicates the package is cancelled (on the given date).
• expire: Indicates a future cancellation on this date.
• domsvc: Domain svcnum
• id: External service id, integer
• title: External service identifier, text
• address1: Service address, number and street, text
• address2: Service address, suite/unit/building identifier, text
• city: Service address, name of city, text
• state: Service address, state/province, abbreviated
• zip: Service address, postal code
• country: Service address, country, 2-letter code

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