import question

[scooter6 at gmail.com]

Thanks Josh - I do know Nancy does a lot of import/export stuff as do I :)


On Thu, Oct 31, 2019 at 4:54 PM Josh Reader via Filepro-list <
filepro-list at lists.celestial.com> wrote:

> Hi Scott,
>
> I remember Nancy saying something at the conference about @AF if you have
> associated fields.  I haven't used that command yet but possibly if you
> associate all 40 fields you could use something like if A1 eq "" and then
> use @AF to tell you what that blank field number is to be able to write to
> it?  Hopefully she'll post if that would be possible with your scenario.  I
> have a note from the conference saying to look into @AF but I haven't had a
> chance to experiment yet.
>
> Josh
>
>
> -----Original Message-----
> From: Filepro-list <filepro-list-bounces+josh.reader=
> mercuryelectronics.com at lists.celestial.com> On Behalf Of scooter6--- via
> Filepro-list
> Sent: Thursday, October 31, 2019 4:36 PM
> To: filePro Mailing List <filepro-list at lists.celestial.com>
> Subject: import question
>
> I will have ongoing csv files that I need to import into a filePro database
>
> The beginning of each line is static, in that it will say one of 4-5 things
> - based on field 1, it goes to a different part of the import
> There is one that will start with   'Charges|'   (it's a pipe delimited
> file)
> The 2nd field is used to look up the record
>
> Each record in filePro can have up to 40 charges in it
>
> Since the inbound csv file won't necessarily be sorted in order of field 2
> (the key to lookup the record) - is there a simpler way to know which field
> to put the new charge in vs having to say
>
> if charge field 1 is not "" but charge field 2 is blank, then put this
> charge in field 2 and so on?
> The bottom line will be if all 40 charge fields are not empty, it will
> skip the record (which I have that part - ) just wondering if there's an
> easier way I'm not thinking of than to 'step' through each charge field
> until I find the first empty one....
>
> thanks
> Scott
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://mailman.celestial.com/pipermail/filepro-list/attachments/20191031/b137ff56/attachment.html
> >
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20191031/f7d1a440/attachment.html>