ImportSnippets

Add useful import snippets here

Program examples

• Branch Import: Vinod Patel
• Category Import: Vinod Patel

Creating Customer Groups

next_token();//Group Code
if (code[0]) 
{
        if (!lookup(&ifdb[DRTYP], code))
                srec->drtype = ifdb[DRTYP].offset->ptr.record;
        else
        {
                struct s_sdrtyp *sdrtyp = recbuf[SDRTYP];
                getbuc(&fdb[DRTYP], IMPORT_DEFREC, sdrtyp);
                strncpy(sdrtyp->drtcode, code, sizeof(sdrtyp->drtcode)-1);
                strncpy(sdrtyp->drtname,"ADDED BY IMPORT",sizeof(sdrtyp->drtname)-1);
                addrec(&fdb[DRTYP], sdrtyp, drt_extnflds);
                printf("%s added group\n", code);
                
                if (lookup(&ifdb[DRTYP], code))
                        printf("Error adding group '%s'\n",code);
                else
                        srec->drtype = ifdb[DRTYP].offset->ptr.record;
        }
}

Creating Salespeople on the fly

next_token();// Account Dealer
if(!lookup(&ifdb[SMAN],code))
        srec->salesman = ifdb[SMAN].offset->ptr.record;
else if(code[0])
        {
        struct s_ssman *ssman = recbuf[SSMAN];
        getbuc(&fdb[SMAN],IMPORT_DEFREC,ssman);
        strncpy(ssman->smcode,code,sizeof(ssman->smcode)-1);
        strncpy(ssman->smname,"ZZ ADDED BY IMPORT",sizeof(ssman->smname)-1);
        addrec(&fdb[SMAN],ssman,sm_extnflds);
        if(!lookup(&ifdb[SMAN],code))
                {
                srec->salesman = ifdb[SMAN].offset->ptr.record;
                printf("Added salesman: '%s'\n",code);
                }
        else
                printf("Error adding salesman: '%s'\n",code);
                
        }

Creating customer records in the process of adding a customer record

if(!lookup(&ifdb[DEBTR],code))
        vrec->cust_pricing[0] = ifdb[DEBTR].offset->ptr.record;
else
        {
        // Need to create this customer
        S_CUSTOMER pricelist = {0};
        cpybuf(&pricelist,srec,fdb[DEBTR].bucsiz);
        getbuc(&fdb[DEBTR], IMPORT_DEFREC,srec);
        strncpy(srec->drcode,code,sizeof(srec->drcode)-1);
        strncpy(srec->nam_add[0],"ZZ PRICELIST ADDED BY IMPORT",sizeof(srec->nam_add[0])-1);
        addrec(&fdb[DEBTR], srec, dr_extnflds);
        cpybuf(srec,&pricelist,fdb[DEBTR].bucsiz);
                        
        if(!lookup(&ifdb[DEBTR],code))
                {
                vrec->cust_pricing[0] = ifdb[DEBTR].offset->ptr.record;
                printf("Added pricelist code: '%s'\n",code);
                }
        else
                printf("Error adding pricelist code: '%s'\n",code);
        }

Creating Suppliers

        getbuc(&fdb[CRED],IMPORT_DEFREC,scred);
        strncpy(scred->crcode,code,sizeof(scred->crcode)-1);
        strncpy(scred->crcoment,"ADDED BY STOCK IMPORT",sizeof(scred->crcoment)-1);
        addrec(&fdb[CRED],scred,cr_extnflds);
        if(!lookup(&ifdb[CRED],code))
        {
                sstock->ssupp[0].supp = ifdb[CRED].offset->ptr.record;
        }
        else
        {
                printf("Error adding %s supplier\n",code);
        }