You need to sign in to do that
Don't have an account?
Help WIth Objects
Hi,
I hope somebody could make a suggestion for me? I work at a telecoms company and I have created an area within the "Accounts" section in order for me to upload our customers call minutes.
In order to do this, I created a couple of objects one being CMM (Customer Month Minutes), and the other being Month.
My problem is that when I upload the minutes into salesforce, I have to assign the unique number to each minute record for each customer. Let me give you an example:
To create a new month I need to import 2010-08 against every customer UID, eg:
Account ID Month
xx0011998Uidd00x 2010-08
yy11228866Vl11zz 2010-08
ll661144qq7789yz 2010-08
xx0011998Uidd00x 2010-08
yy11228866Vl11zz 2010-08
ll661144qq7789yz 2010-08
This means each month record for each account now has a UID of it's own - example below:
Account ID Month Month ID
xx0011998Uidd00x 2010-08 zzzzzz1111122222
yy11228866Vl11zz 2010-08 zzzzzxxxx22221111
ll661144qq7789yz 2010-08 0000rrrzzz0000111
xx0011998Uidd00x 2010-08 778899qqq999q9q
yy11228866Vl11zz 2010-08 3131313qqqq3333
ll661144qq7789yz 2010-08 161658623858584
This means when up loading the minutes onto the customer account, I must map the Month ID, and the Account ID, etc etc etc.
What I would like to do is just upload the customer month minutes against a month, rather than a UID which is created per account. EG below:
Account ID Minute Type Day Month
11222zzz1100ydu Inbound 01 August
11222zzz1100ydu Inbound 02 August
11222zzz1100ydu Inbound 03 August
11222zzz1100ydu Inbound 04 August
11222zzz1100ydu Inbound 05 August
11222zzz1100ydu Outbound 01 August
11222zzz1100ydu Outbound 02 August
11222zzz1100ydu Outbound 03 August
11222zzz1100ydu Outbound 04 August
11222zzz1100ydu Outbound 05 August
zzx5574575yyd0o Inbound 01 August
zzx5574575yyd0o Inbound 02 August
zzx5574575yyd0o Inbound 03 August
zzx5574575yyd0o Inbound 04 August
zzx5574575yyd0o Inbound 05 August
zzx5574575yyd0o Outbound 01 August
zzx5574575yyd0o Outbound 02 August
zzx5574575yyd0o Outbound 03 August
zzx5574575yyd0o Outbound 04 August
zzx5574575yyd0o Outbound 05 August
Does anyone have any suggestions please??
Thanks for looking , best regards,
Justin
Hi Justin,
I'm a fairly new to this myself but I'm wondering why you would need the month object at all. Why not just load the minutes against the account and use a date field instead of separate month and day fields?
Rick
I agree with Rick - what is the requirement for the custom object 'Month'? Can't you just have a minutes custom object which is related directly to your account??