• Scott Holman
  • 0 Points
  • Member since 2013

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
  • 4

Hi ,


I have fixed width text files coming from a legacy system every day...

Is there any process where I can read the data from these fixed width text files and uplaod  into salesforce. I want to run them using a job which runs overnight and i have to monitor the job. 


Any help is greatly appreciated.



The rich text editor I am using to post this message meets my needs, but how can I get these features to be available when I create a rich text field on an object? 

  • Spell check isn't available
  • I would love to be able to set line spacing

What solutions exist? 

  • October 19, 2013
  • Like
  • 0

I want auto increment number in account field. format is first four letter from account name next two digits from number. i got it but the problem i have 1000 of accounts i want the number increament upto 99 and again i want to regenerate from 1. but it goes 100, 101, 102...... 


       example:  UPPER(LEFT(Name, 4))+AutoId__c


AutoId__c  i gave display format like this   {00}. i want regenerate from 1 after it reached 99.




  • October 18, 2013
  • Like
  • 0

1) I have a trigger that works in sb and does exactly what I want it to do:

Class I wrote will not get it above 55% (when it passed)

2) Made a small change and now it does not pass, but not seeing what is wrong.

I know - should have made a backup before changing!



Forgot to post the code - one of those Mondays, and, the test was based on a post I saw; looks like it overdoes it, but I am new at this.



Trigger Pharmacy_Demo_Completed on Task (before insert){
   for (Task T : trigger.new){
      string TaskProfile = 'Implementation Director';
      string TaskSubject = t.subject;
      string TaskType = 'Send Contracts';
      if (TaskSubject == 'Pharmacy Demo Completed'){
          List <User> usr = [select Id from User where Profile.Name =:TaskProfile limit 1];
 //         system.debug (Usr.size());

//          If (Usr.size() < 1){
//            system.debug ('No entries found for ');}
//          if (usr.size() > 0)
                {User u = [select Id ,name from User where Profile.Name =:TaskProfile limit 1];
                t.ownerid = u.id;
                t.type = TaskType;}


public class Taskusertest2 {
    List<Task> insertedTasks = new List<Task>{};
    static testMethod void myUnitTest() {
    for(Integer i = 0; i < 100; i++)    
        {Task t = new Task();
            t.IsRecurrence = FALSE;
            t.sma__CreatedLocationVerified__c = FALSE;
            t.IsReminderSet = FALSE;
            t.MA_Clean_State__c = 'tx';
            t.Subject = 'Testing';
            t.Type = 'Research';
            t.Priority = 'Normal';
            t.Description = 'Task Class Test';
            t.Status = 'Completed';
        insert t;}
         List<Task> insertedTasks = [SELECT Description
                                                FROM Task
                                                WHERE Status = 'Completed'];
         {for(Task t : insertedTasks)
          'This Task is probably left over from testing. It should probably be deleted.',
//        System.assertNotEquals(t.id, null);