Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Parsing a value list into new records


Benjamondo

Recommended Posts

Hi Everyone,

 

This is my first post, so please be patient with me if I'm posting incorrectly.

 

I'm building a tracking system for our retouchers. Basically a list of files is sucked in and they can check boxes along the line until completion. The details of which are irrelevant and would bore you all.

 

I'm doing pretty well and have been referring heavily to these forums which are FANTASTIC.

However. I've hit a wall with the following task.

 

I have a field containing a list of filenames.

ie :

file_one.jpg

file_two.jpg

etc.jpg

 

each is on a new line. Basically the same format as a value list I guess.

So.

Now I want to put each of these filenames into its own record, in a field named "filename"

 

HOW?

 

Im stumped. can it be done?

 

I used the troi file plug in to generate the file list using TrFile_List_folder

 

is there a better way to get a list of files into a group of records?

 

Any help would be great

 

Thanks in advance

 

B

Link to comment
Share on other sites

Hi There,

 

Thanks for this. It seems on the surface to work very well.

 

I'm having a bit of a mental blank as to how I can grab the results and concatenate them to end of an existing set of records in another table.

 

Can you think of an easy way to do that?

 

Thanks again for the demo

 

B

Link to comment
Share on other sites

Hiya,

 

I guess Im unsure as to how I can directly integrate the operation of your demo into my own db. so Ive basically taken the demo and dumped it into my solution. I want to transfer the records created by your demo, and add them to the end of an existing table of my creation.

 

so basically i'm just asking for an easy way to take records from one table and put them in another.

 

B

Link to comment
Share on other sites

IIUC, you need to remove the part in my script that checks for existing records. The scripts are commented, so it should be easy.

 

Otherwise, an easy way to take records from one table and put them in another is by importing.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.



×
×
  • Create New...

Important Information

Terms of Use