Alpha Video Training
Results 1 to 7 of 7

Thread: Scripts for Alpha4V8

  1. #1
    Member
    Real Name
    Alex Mansfield
    Join Date
    Apr 2007
    Posts
    10

    Default Scripts for Alpha4V8

    I am a new user of Alpha4V8. I have run into a problem and I am not sure how to solve it. When I import a file to Aplha4V8, usually I don't have any problems. I have an Excel file that I converted to a .slyk file and it uploaded with out any problem. When I did a browse I realized that with about 1/2 of the records the State and the zip code had either been switched, or in some case the zipcode was placed where the state is supposed to be and the Zipcode was left blank. Is there a script that can be written to correct this problem, or do I have to spend the time to go through 13,000 files and change each on individually. I would appreciate any help you are able to provide.

    Sincerel,

    Alex Mansfield
    Mailing Specialist
    Think Patented Printing

  2. #2
    Member
    Real Name
    Keith George
    Join Date
    May 2000
    Location
    Near Penzance Cornwall UK
    Posts
    205

    Default Re: Scripts for Alpha4V8

    It might be worth looking at the data "before" you export/import it as the problem may lie there.

    Keith

  3. #3
    Member
    Real Name
    Alex Mansfield
    Join Date
    Apr 2007
    Posts
    10

    Default Re: Scripts for Alpha4V8

    Dear Kieth

    Thank you for the tip, however, I did review the file before I imported it and after I imported it. The data on Excel is fine. Alpha4V8 put 45 in the state collumn and 0 in the zip code. It is strange because it only did this on about 1/2 of the files. The rest are fine.

  4. #4
    Member
    Real Name
    Keith George
    Join Date
    May 2000
    Location
    Near Penzance Cornwall UK
    Posts
    205

    Default Re: Scripts for Alpha4V8

    Hi Alex,

    Have you tried to export in other formats, this may help. The dbf format is often used, Alpha should import direct from the dbf format.

  5. #5
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Scripts for Alpha4V8

    Quote Originally Posted by Alexmjr1970 View Post
    Dear Kieth

    Thank you for the tip, however, I did review the file before I imported it and after I imported it. The data on Excel is fine. Alpha4V8 put 45 in the state collumn and 0 in the zip code. It is strange because it only did this on about 1/2 of the files. The rest are fine.
    You might also be certain that the column widths are displaying the contents of all rows (autofit). I have seen truncation and other issues when the entire contents of each column were not visible in the excel file.

  6. #6
    Member
    Real Name
    RL Brown
    Join Date
    Apr 2007
    Posts
    4

    Default Re: Scripts for Alpha4V8

    Try doing a find and replace for nulls replacing them with 0 in your xls spreadsheet .... then save as dbf and see if that works.

    That works in other applications.

  7. #7
    Member
    Real Name
    Alex Mansfield
    Join Date
    Apr 2007
    Posts
    10

    Default Re: Scripts for Alpha4V8

    I am hoping some one can tell me what I am doing wrong. I have a script for Alpha4V8 that I am using to do a word count. The script is this:
    W_Count<csv>=3 When I enter this I get an error telling me I am missing an Operator. I also have with following and I need advise on these:

    Word<csz.1> This script to UPDATE EXPRESS
    Word<csz.2>
    word<csz.3>
    Word<csz.1>+""+word<csz.2
    GEN2<CITY>#

    I would appreciate any help anyone can give.

    Thanks much.

Similar Threads

  1. Alpha4v8 shutting down
    By madtowng in forum Alpha Four Versions 7 and 8
    Replies: 4
    Last Post: 09-03-2004, 01:01 PM
  2. Networking Alpha4v8
    By madtowng in forum Alpha Four Versions 7 and 8
    Replies: 2
    Last Post: 08-27-2004, 02:12 PM
  3. alpha4v6-to alpha4v8
    By Ronald Goldman in forum Alpha Four Versions 7 and 8
    Replies: 2
    Last Post: 06-24-2004, 06:40 PM
  4. REGIONS IN ALPHA4V8
    By BILL SALTER in forum Alpha Four Versions 7 and 8
    Replies: 4
    Last Post: 06-07-2004, 06:13 AM
  5. Alpha4v8 Printing
    By Bill Stanley in forum Alpha Four Versions 7 and 8
    Replies: 1
    Last Post: 04-09-2003, 08:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •